Community Data

All community datasets currently available in Spice

The Spice.ai platform includes a comprehensive set of read-to-query community, sample, and blockchain datasets.

TPC-H

Explore the TPC-H Benchmark dataset. The dataset is widely used to evaluate the analytic query capabilities of databases.

Customer	tpch.customer
Lineitem	tpch.lineitem
Part	tpch.part
Partsupp	tpch.partsupp
Orders	tpch.orders
Nation	tpch.nation
Region	tpch.region
Supplier	tpch.supplier

Blockchain Datasets

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

Ethereum Wallet Balances datasets

A block-level view of all changes to any account's Ether balance

eth.wallet_balances

eth.recent_wallet_balances

Ethereum Uniswap datasets

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

Ethereum Sushiswap datasets

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

Ethereum Name Service (ENS) datasets

ENS Domains

ens.domains

Ethereum Beacon Chain datasets

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

Ethereum Eigenlayer datasets

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

Ethereum Aave V2 datasets

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

Goerli Wallet Balances Dataset

A block-level view of all changes to any account's Ether balance

goerli.wallet_balances

goerli.recent_wallet_balances

Goerli Beacon Chain Datasets

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

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

Chainlink datasets

Prices (historical)

eth.chainlink.prices

eth.chainlink.recent_prices

Time-series Datasets

• Ethereum blocks

• Ethereum gas fees

Spot and historical Prices

• 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

• See JSON RPC Methods