Links
Comment on page

Web3 Data

All Web3 data and datasets currently available in Spice
New datasets are added every week, so this list is just the start. Get in touch on Discord to suggest more. We're just getting started!

Datasets for SQL Query

Explore SQL-queryable datasets organized by chain and data type, each with representative tables. Click the section header links for more information and complete table listings.
Blocks
eth.blocks
eth.recent_blocks
Transactions
eth.transactions
eth.recent_transactions
Logs
eth.logs
eth.recent_logs
Contracts
eth.contracts
Traces
eth.traces
eth.recent_traces
Withdrawals
eth.withdrawals
eth.recent_withdrawals
Contracts (erc20, erc721, erc1155)
eth.contracts
Tokens (erc20, erc721, erc1155)
eth.tokens
Token Transfers (erc20, erc721, erc1155)
eth.token_transfers
eth.recent_token_transfers
Token Mints (erc20, erc721, erc1155)
eth.token_mints
eth.recent_token_mints
NFTs
eth.nfts
NFT Contracts
eth.nft_contracts
NFT Transfers (with optional hold time)
eth.nft_transfers
eth.recent_nft_transfers
NFT Owners
eth.nft_owners
NFT Airdrop Transfers
eth.nft_airdrop_transfers
eth.recent_nft_airdrop_transfers
A block-level view of all changes to any account's Ether balance
eth.wallet_balances
eth.recent_wallet_balances
Uniswap V2 Pools
eth.uniswap_v2.pools
Uniswap V2 Pool Statistics (reserves and price info)
eth.uniswap_v2.pool_stats
Uniswap V2 Events (swaps, mints, burns, etc)
eth.uniswap_v2.event_swaps
eth.uniswap_v2.recent_event_swaps
Uniswap V3 Pools
eth.uniswap_v3.pools
Uniswap V3 Pool Statistics (reserves and price info)
eth.uniswap_v3.pool_stats
Uniswap V3 Events (swaps, mints, burns, etc)
eth.uniswap_v3.event_swaps
eth.uniswap_v3.recent_event_swaps
Sushiswap Pools
eth.sushiswap.pools
Sushiswap Pool Statistics (reserves and price info)
eth.sushiswap.pool_stats
Sushiswap Events (swaps, mints, burns, etc)
eth.sushiswap.event_swaps
eth.sushiswap.recent_event_swaps
ENS Domains
ens.domains
Validators
eth.beacon.validators
Slots
eth.beacon.slots
eth.beacon.recent_slots
Attestations
eth.beacon.attestations
eth.beacon.recent_attestations
Deposits
eth.beacon.deposits
eth.beacon.recent_deposits
Voluntary Exits
eth.beacon.voluntary_exits
eth.beacon.recent_voluntary_exits
Attester Slashings
eth.beacon.attester_slashings
eth.beacon.recent_attester_slashings
Proposer Slashings
eth.beacon.proposer_slashings
eth.beacon.recent_proposer_slashings
BLS To Execution Changes
eth.beacon.bls_to_execution_changes
eth.beacon.recent_bls_to_execution_changes
Withdrawals
eth.beacon.withdrawals
eth.beacon.recent_withdrawals
All Eigenpods
eth.eigenlayer.eigenpods
All Eigenpod Validators
eth.eigenlayer.eigenpod_validators
Eigenpod ETH wallet changed balances
eth.eigenlayer.eigenpod_balances
eth.eigenlayer.recent_eigenpod_balances
Withdrawal Router ETH wallet balances
eth.eigenlayer.withdrawal_router
StrategyManager events for a strategy being approved for a deposit
eth.eigenlayer.strategy_manager_added_to_deposit_whitelist
StrategyManager events for when a new deposit occurs on behalf of depositor
eth.eigenlayer.strategy_manager_deposits
StrategyManager events for a strategy being removed for a deposit
eth.eigenlayer.strategy_manager_removed_from_deposit_whitelist
StrategyManager events for when a new withdrawal occurs on behalf of depositor
eth.eigenlayer.strategy_manager_share_withdrawal_queued
StrategyManager events for when the strategyWhitelister is changed
eth.eigenlayer.strategy_manager_strategy_whitelister_changed
StrategyManager events for when a queued withdrawal is completed
eth.eigenlayer.strategy_manager_withdrawal_completed
StrategyManager events for when the withdrawalDelayBlocks variable is modified
eth.eigenlayer.strategy_manager_withdrawal_delay_blocks_set
StrategyManager events for when a new withdrawal is queued by depositor
eth.eigenlayer.strategy_manager_withdrawal_queued
Eigenpod withdrawal recipient balances
eth.eigenlayer.withdrawal_recipient_balances
eth.eigenlayer.recent_withdrawal_recipient_balances
Eigenpod withdrawal DelayedWithdrawalRouter balances
eth.eigenlayer.withdrawal_router_balances
eth.eigenlayer.recent_withdrawal_router_balances
Decoded DelayedWithdrawalClaimed events for the DelayedWithdrawalRouter contract
eth.eigenlayer.withdrawal_router_claimed
eth.eigenlayer.recent_withdrawal_router_claimed
Decoded DelayedWithdrawalCreated events from the DelayedWithdrawalRouter contract
eth.eigenlayer.withdrawal_router_created
eth.eigenlayer.recent_withdrawal_router_created
Loans (historical)
eth.aave_v2.loan_updates
eth.aave_v2.recent_loan_updates
Collateral (historical)
eth.aave_v2.collateral_updates
eth.aave_v2.recent_collateral_updates
Loans (latest view)
eth.aave_v2.loans
Collateral (latest view)
eth.aave_v2.collateral
Blocks
goerli.blocks
goerli.recent_blocks
Transactions
goerli.transactions
goerli.recent_transactions
Logs
goerli.logs
goerli.recent_logs
Contracts
goerli.contracts
Traces
goerli.traces
goerli.recent_traces
Withdrawals
goerli.withdrawals
goerli.recent_withdrawals
Contracts (erc20, erc721, erc1155)
goerli.contracts
Tokens (erc20, erc721, erc1155)
goerli.tokens
Token Transfers (erc20, erc721, erc1155)
goerli.token_transfers
goerli.recent_token_transfers
Token Mints (erc20, erc721, erc1155)
goerli.token_mints
goerli.recent_token_mints
A block-level view of all changes to any account's Ether balance
goerli.wallet_balances
goerli.recent_wallet_balances
Validators
goerli.beacon.validators
Slots
goerli.beacon.slots
goerli.beacon.recent_slots
Attestations
goerli.beacon.attestations
goerli.beacon.recent_attestations
Deposits
goerli.beacon.deposits
goerli.beacon.recent_deposits
Voluntary Exits
goerli.beacon.voluntary_exits
goerli.beacon.recent_voluntary_exits
Attester Slashings
goerli.beacon.attester_slashings
goerli.beacon.recent_attester_slashings
Proposer Slashings
goerli.beacon.proposer_slashings
goerli.beacon.recent_proposer_slashings
BLS To Execution Changes
goerli.beacon.bls_to_execution_changes
goerli.beacon.recent_bls_to_execution_changes
Withdrawals
goerli.beacon.withdrawals
goerli.beacon.recent_withdrawals
Blocks
polygon.blocks
polygon.recent_blocks
Transactions
polygon.transactions
polygon.recent_transactions
Logs
polygon.logs
polygon.recent_logs
Contracts
polygon.contracts
Traces
polygon.traces
polygon.recent_traces
Contracts (erc20, erc721, erc1155)
polygon.contracts
Tokens (erc20, erc721, erc1155)
polygon.tokens
Token Transfers (erc20, erc721, erc1155)
polygon.token_transfers
polygon.recent_token_transfers
Token Mints (erc20, erc721, erc1155)
polygon.token_mints
polygon.recent_token_mints
NFTs
polygon.nfts
NFT Contracts
polygon.nft_contracts
NFT Transfers (with optional hold time)
polygon.nft_transfers
polygon.recent_nft_transfers
NFT Owners
polygon.nft_owners
NFT Airdrop Transfers
polygon.nft_airdrop_transfers
polygon.recent_nft_airdrop_transfers
Blocks
btc.blocks
btc.recent_blocks
Transactions
btc.transactions
btc.recent_transactions
Transaction Inputs
btc.transaction_inputs
btc.recent_transaction_inputs
Transaction Outputs
btc.transaction_outputs
btc.recent_transaction_outputs
Historical OHLC cryptocurrency and token prices are available for SQL query at 1 minute granularity. ~2,000 token pairs are currently available sourced from centralized exchanges like Coinbase, Gemini, and Binance, and decentralized exchanges like Uniswap and Sushiswap. More pais are automatically added each day as they are listed on the exchanges.
To see all pairs available for query:
SHOW TABLES IN prices;
Or access all pairs in a single table:
SELECT DISTINCT pair FROM prices.all_pairs;
For historical price exchange data to tick level granularity, try the time-series Prices API.
Prices (historical)
eth.chainlink.prices
eth.chainlink.recent_prices

Time-series Datasets

  • Binance
    • Spot/latest prices for all pairs traded on Binance.
    • Historical OHLC prices at 1-min granularity for all pairs.
  • Coinbase
    • Spot/latest prices for all pairs traded on Coinbase.
    • Historical OHLC prices at 1-min granularity for all pairs.
  • Gemini
    • Spot/latest prices for all pairs traded on Gemini.
    • Partial historical OHLC prices at 1-min granularity for all pairs.

JSON RPC Methods

Last modified 1mo ago