Token Tables
Ethereum Token tables available to query via SQL
Last updated
Ethereum Token tables available to query via SQL
Last updated
Links
Table Name | Description |
---|---|
The columns and their schema available for each table can be viewed with the describe <table>
command. For example:
Query performance can be significantly improved by adding WHERE
clauses to your query on specific indexed columns.
Table Name | Indexed Columns |
---|---|
ERC-20, ERC-721 and ERC-1155 token contracts
ERC-20, ERC-721, and ERC-1155 token transfers
Token transfers from the last 30 minutes, ~128 blocks
ERC-20 token contracts
ERC-20 token transfers
ERC-721 token contracts
ERC-721 token transfers (NFTs)
ERC-1155 token contracts
ERC-1155 token transfers
ERC-20, ERC-721, and ERC-1155 token mints
Token mints from the last 30 minutes, ~128 blocks
eth.tokens
block_number
block_timestamp
name
symbol
eth.tokens_erc20
block_number
block_timestamp
name
symbol
eth.tokens_erc721
block_number
block_timestamp
name
symbol
eth.tokens_erc1155
block_number
block_timestamp
name
symbol
eth.token_transfers
block_number
block_timestamp
block_hash
transaction_hash
eth.recent_token_transfers
block_number
block_timestamp
block_hash
transaction_hash
eth.token_transfers_erc20
block_number
block_timestamp
block_hash
transaction_hash
eth.token_transfers_erc721
block_number
block_timestamp
block_hash
transaction_hash
eth.token_transfers_erc1155
block_number
block_timestamp
block_hash
transaction_hash
eth.token_mints
block_number
block_timestamp
block_hash
transaction_hash
eth.recent_token_mints
block_number
block_timestamp
block_hash
transaction_hash