# Datasets

{% hint style="success" %}
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!**
{% endhint %}

### 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](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum)

<table data-header-hidden><thead><tr><th width="230.5"></th><th width="235"></th><th></th></tr></thead><tbody><tr><td>Blocks</td><td><code>eth.blocks</code></td><td><code>eth.recent_blocks</code></td></tr><tr><td>Transactions</td><td><code>eth.transactions</code></td><td><code>eth.recent_transactions</code></td></tr><tr><td>Logs</td><td><code>eth.logs</code></td><td><code>eth.recent_logs</code></td></tr><tr><td>Contracts</td><td><code>eth.contracts</code></td><td></td></tr><tr><td>Traces</td><td><code>eth.traces</code></td><td><code>eth.recent_traces</code></td></tr><tr><td>Withdrawals</td><td><code>eth.withdrawals</code></td><td><code>eth.recent_withdrawals</code></td></tr></tbody></table>

[**Ethereum Token datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/token-tables)

<table data-header-hidden><thead><tr><th width="278.5"></th><th width="236"></th><th></th></tr></thead><tbody><tr><td>Contracts (erc20, erc721, erc1155)</td><td><code>eth.contracts</code></td><td></td></tr><tr><td>Tokens (erc20, erc721, erc1155)</td><td><code>eth.tokens</code></td><td></td></tr><tr><td>Token Transfers (erc20, erc721, erc1155)</td><td><code>eth.token_transfers</code></td><td><code>eth.recent_token_transfers</code></td></tr><tr><td>Token Mints (erc20, erc721, erc1155)</td><td><code>eth.token_mints</code></td><td><code>eth.recent_token_mints</code></td></tr></tbody></table>

[**Ethereum NFT datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/nft-tables)

<table data-header-hidden><thead><tr><th width="223.5"></th><th width="266"></th><th></th></tr></thead><tbody><tr><td>NFTs</td><td><code>eth.nfts</code></td><td></td></tr><tr><td>NFT Contracts</td><td><code>eth.nft_contracts</code></td><td></td></tr><tr><td>NFT Transfers (with optional hold time)</td><td><code>eth.nft_transfers</code></td><td><code>eth.recent_nft_transfers</code></td></tr><tr><td>NFT Owners</td><td><code>eth.nft_owners</code></td><td></td></tr><tr><td>NFT Airdrop Transfers</td><td><code>eth.nft_airdrop_transfers</code></td><td><code>eth.recent_nft_airdrop_transfers</code></td></tr></tbody></table>

[**Ethereum Wallet Balances datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/wallet-balances)

| A block-level view of all changes to any account's Ether balance | `eth.wallet_balances` | `eth.recent_wallet_balances` |
| ---------------------------------------------------------------- | --------------------- | ---------------------------- |

[**Ethereum Uniswap datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/uniswap-v2-tables)

<table data-header-hidden><thead><tr><th width="280.5"></th><th></th><th></th></tr></thead><tbody><tr><td>Uniswap V2 Pools</td><td><code>eth.uniswap_v2.pools</code></td><td></td></tr><tr><td>Uniswap V2 Pool Statistics (reserves and price info)</td><td><code>eth.uniswap_v2.pool_stats</code></td><td></td></tr><tr><td>Uniswap V2 Events (swaps, mints, burns, etc)</td><td><code>eth.uniswap_v2.event_swaps</code></td><td><code>eth.uniswap_v2.recent_event_swaps</code></td></tr><tr><td>Uniswap V3 Pools</td><td><code>eth.uniswap_v3.pools</code></td><td></td></tr><tr><td>Uniswap V3 Pool Statistics (reserves and price info)</td><td><code>eth.uniswap_v3.pool_stats</code></td><td></td></tr><tr><td>Uniswap V3 Events (swaps, mints, burns, etc)</td><td><code>eth.uniswap_v3.event_swaps</code></td><td><code>eth.uniswap_v3.recent_event_swaps</code></td></tr></tbody></table>

[**Ethereum Sushiswap datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/sushiswap-tables)

| 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**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/token-tables-1)

<table data-header-hidden><thead><tr><th width="368.5"></th><th></th></tr></thead><tbody><tr><td>ENS Domains</td><td><code>ens.domains</code></td></tr></tbody></table>

[**Ethereum Beacon Chain datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/beacon-chain-tables)

<table><thead><tr><th width="218"></th><th></th><th></th></tr></thead><tbody><tr><td>Validators</td><td><code>eth.beacon.validators</code></td><td></td></tr><tr><td>Slots</td><td><code>eth.beacon.slots</code></td><td><code>eth.beacon.recent_slots</code></td></tr><tr><td>Attestations</td><td><code>eth.beacon.attestations</code></td><td><code>eth.beacon.recent_attestations</code></td></tr><tr><td>Deposits</td><td><code>eth.beacon.deposits</code></td><td><code>eth.beacon.recent_deposits</code></td></tr><tr><td>Voluntary Exits</td><td><code>eth.beacon.voluntary_exits</code></td><td><code>eth.beacon.recent_voluntary_exits</code></td></tr><tr><td>Attester Slashings</td><td><code>eth.beacon.attester_slashings</code></td><td><code>eth.beacon.recent_attester_slashings</code></td></tr><tr><td>Proposer Slashings</td><td><code>eth.beacon.proposer_slashings</code></td><td><code>eth.beacon.recent_proposer_slashings</code></td></tr><tr><td>BLS To Execution Changes</td><td><code>eth.beacon.bls_to_execution_changes</code></td><td><code>eth.beacon.recent_bls_to_execution_changes</code></td></tr><tr><td>Withdrawals</td><td><code>eth.beacon.withdrawals</code></td><td><code>eth.beacon.recent_withdrawals</code></td></tr></tbody></table>

#### [Ethereum Aave V2 datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/aave-v2-tables)

|                          |                                  |                                         |
| ------------------------ | -------------------------------- | --------------------------------------- |
| 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](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/goerli)

<table data-header-hidden><thead><tr><th width="230.5"></th><th width="235"></th><th></th></tr></thead><tbody><tr><td>Blocks</td><td><code>goerli.blocks</code></td><td><code>goerli.recent_blocks</code></td></tr><tr><td>Transactions</td><td><code>goerli.transactions</code></td><td><code>goerli.recent_transactions</code></td></tr><tr><td>Logs</td><td><code>goerli.logs</code></td><td><code>goerli.recent_logs</code></td></tr><tr><td>Contracts</td><td><code>goerli.contracts</code></td><td></td></tr><tr><td>Traces</td><td><code>goerli.traces</code></td><td><code>goerli.recent_traces</code></td></tr><tr><td>Withdrawals</td><td><code>goerli.withdrawals</code></td><td><code>goerli.recent_withdrawals</code></td></tr></tbody></table>

#### [Goerli Token Datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/goerli/token-tables)

<table data-header-hidden><thead><tr><th width="278.5"></th><th width="236"></th><th></th></tr></thead><tbody><tr><td>Contracts (erc20, erc721, erc1155)</td><td><code>goerli.contracts</code></td><td></td></tr><tr><td>Tokens (erc20, erc721, erc1155)</td><td><code>goerli.tokens</code></td><td></td></tr><tr><td>Token Transfers (erc20, erc721, erc1155)</td><td><code>goerli.token_transfers</code></td><td><code>goerli.recent_token_transfers</code></td></tr><tr><td>Token Mints (erc20, erc721, erc1155)</td><td><code>goerli.token_mints</code></td><td><code>goerli.recent_token_mints</code></td></tr></tbody></table>

#### [Goerli Wallet Balances Dataset](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/goerli/token-tables-1)

| A block-level view of all changes to any account's Ether balance | `goerli.wallet_balances` | `goerli.recent_wallet_balances` |
| ---------------------------------------------------------------- | ------------------------ | ------------------------------- |

#### [Goerli Beacon Chain Datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/goerli/beacon-chain-tables)

<table data-header-hidden><thead><tr><th width="218"></th><th></th><th></th></tr></thead><tbody><tr><td>Validators</td><td><code>goerli.beacon.validators</code></td><td></td></tr><tr><td>Slots</td><td><code>goerli.beacon.slots</code></td><td><code>goerli.beacon.recent_slots</code></td></tr><tr><td>Attestations</td><td><code>goerli.beacon.attestations</code></td><td><code>goerli.beacon.recent_attestations</code></td></tr><tr><td>Deposits</td><td><code>goerli.beacon.deposits</code></td><td><code>goerli.beacon.recent_deposits</code></td></tr><tr><td>Voluntary Exits</td><td><code>goerli.beacon.voluntary_exits</code></td><td><code>goerli.beacon.recent_voluntary_exits</code></td></tr><tr><td>Attester Slashings</td><td><code>goerli.beacon.attester_slashings</code></td><td><code>goerli.beacon.recent_attester_slashings</code></td></tr><tr><td>Proposer Slashings</td><td><code>goerli.beacon.proposer_slashings</code></td><td><code>goerli.beacon.recent_proposer_slashings</code></td></tr><tr><td>BLS To Execution Changes</td><td><code>goerli.beacon.bls_to_execution_changes</code></td><td><code>goerli.beacon.recent_bls_to_execution_changes</code></td></tr><tr><td>Withdrawals</td><td><code>goerli.beacon.withdrawals</code></td><td><code>goerli.beacon.recent_withdrawals</code></td></tr></tbody></table>

#### [Polygon datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/polygon)

<table data-header-hidden><thead><tr><th width="251.5"></th><th></th><th></th></tr></thead><tbody><tr><td>Blocks</td><td><code>polygon.blocks</code></td><td><code>polygon.recent_blocks</code></td></tr><tr><td>Transactions</td><td><code>polygon.transactions</code></td><td><code>polygon.recent_transactions</code></td></tr><tr><td>Logs</td><td><code>polygon.logs</code></td><td><code>polygon.recent_logs</code></td></tr><tr><td>Contracts</td><td><code>polygon.contracts</code></td><td></td></tr><tr><td>Traces</td><td><code>polygon.traces</code></td><td><code>polygon.recent_traces</code></td></tr></tbody></table>

[**Polygon Token Datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/polygon/token-tables)

<table data-header-hidden><thead><tr><th width="320.5"></th><th></th><th></th></tr></thead><tbody><tr><td>Contracts (erc20, erc721, erc1155)</td><td><code>polygon.contracts</code></td><td></td></tr><tr><td>Tokens (erc20, erc721, erc1155)</td><td><code>polygon.tokens</code></td><td></td></tr><tr><td>Token Transfers (erc20, erc721, erc1155)</td><td><code>polygon.token_transfers</code></td><td><code>polygon.recent_token_transfers</code></td></tr><tr><td>Token Mints (erc20, erc721, erc1155)</td><td><code>polygon.token_mints</code></td><td><code>polygon.recent_token_mints</code></td></tr></tbody></table>

[**Polygon NFT Datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/polygon/nft-tables)

<table data-header-hidden><thead><tr><th width="239.5"></th><th></th><th></th></tr></thead><tbody><tr><td>NFTs</td><td><code>polygon.nfts</code></td><td></td></tr><tr><td>NFT Contracts</td><td><code>polygon.nft_contracts</code></td><td></td></tr><tr><td>NFT Transfers (with optional hold time)</td><td><code>polygon.nft_transfers</code></td><td><code>polygon.recent_nft_transfers</code></td></tr><tr><td>NFT Owners</td><td><code>polygon.nft_owners</code></td><td></td></tr><tr><td>NFT Airdrop Transfers</td><td><code>polygon.nft_airdrop_transfers</code></td><td><code>polygon.recent_nft_airdrop_transfers</code></td></tr></tbody></table>

[**Bitcoin datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/bitcoin)

<table data-header-hidden><thead><tr><th width="240.5"></th><th></th><th></th></tr></thead><tbody><tr><td>Blocks</td><td><code>btc.blocks</code></td><td><code>btc.recent_blocks</code></td></tr><tr><td>Transactions</td><td><code>btc.transactions</code></td><td><code>btc.recent_transactions</code></td></tr><tr><td>Transaction Inputs</td><td><code>btc.transaction_inputs</code></td><td><code>btc.recent_transaction_inputs</code></td></tr><tr><td>Transaction Outputs</td><td><code>btc.transaction_outputs</code></td><td><code>btc.recent_transaction_outputs</code></td></tr></tbody></table>

#### [Flow datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/flow/core-tables)

<table data-header-hidden><thead><tr><th width="251.5"></th><th></th><th></th></tr></thead><tbody><tr><td>Blocks</td><td><code>flow.blocks</code></td><td><code>flow.recent_blocks</code></td></tr><tr><td>Transactions</td><td><code>flow.transactions</code></td><td><code>flow.recent_transactions</code></td></tr><tr><td>Events</td><td><code>flow.events</code></td><td><code>flow.recent_events</code></td></tr></tbody></table>

[**Flow Token/NFT datasets**](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/flow/token-nft-tables)

<table data-header-hidden><thead><tr><th width="239.5"></th><th></th><th></th></tr></thead><tbody><tr><td>NFTs</td><td><code>flow.nfts</code></td><td></td></tr><tr><td>NFT Transfers</td><td><code>flow.nft_transfers</code></td><td><code>flow.recent_nft_transfers</code></td></tr><tr><td>Fungible Token Transfers</td><td><code>flow.token_transfers</code></td><td><code>flow.recent_token_transfers</code></td></tr></tbody></table>

#### [Prices datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/prices)

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:

```sql
SHOW TABLES IN prices;
```

Or access all pairs in a single table:

```sql
SELECT DISTINCT pair FROM prices.all_pairs;
```

{% hint style="info" %}
For historical price exchange data to tick level granularity, try the [time-series Prices API](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/api/prices).
{% endhint %}

#### [Chainlink datasets](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/reference/sql-query-tables/ethereum/chainlink-tables)

|                     |                        |                               |
| ------------------- | ---------------------- | ----------------------------- |
| Prices (historical) | `eth.chainlink.prices` | `eth.chainlink.recent_prices` |

### Time-series Datasets

* [Ethereum blocks](https://docs.spice.xyz/api/ethereum/blocks)
* [Ethereum gas fees](https://docs.spice.xyz/api/ethereum/gas-fees)

#### [Spot and historical Prices](https://docs.spice.ai/~/changes/fl1GUvkHE2461izfYRLa/api/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](#time-series-datasets-1)