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.

​Ethereum datasets​

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
​Ethereum Token datasets​
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
​Ethereum NFT datasets​
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
​

​Goerli Datasets​

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

​Goerli Token Datasets​

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

​Polygon datasets​

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
​Polygon Token Datasets​
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
​Polygon NFT Datasets​
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
​Bitcoin datasets​
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

​Prices datasets​

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