ERC20 Token Metadata

The tokens.erc20 table contains metadata for ERC20 tokens across all EVM-compatible networks indexed on Dune. This dataset provides essential information about ERC20 tokens, including:

The blockchain on which the token exists
The contract address of the token
The token symbol
The token name
The number of decimals used by the token

Coverage

This table covers tokens across all EVM chains on Dune. Tokens are automatically detected and included when they meet the following criteria:

Have emitted ERC20 Transfer events
Have at least 1 transfer recorded on-chain

New tokens meeting these criteria are added to the table within approximately 1 hour of detection.

Data Sources

We use DefinedFi as our metadata provider to retrieve token metadata for qualifying contracts. Native tokens are also included in this dataset, using metadata information from dune.blockchains.

Utility

The ERC20 metadata table offers valuable information for token analysis and integration, allowing you to:

Identify tokens across different blockchains
Retrieve essential token information for calculations and display

Table Schema

Column	Type	Description
`blockchain`	`VARCHAR`	Blockchain on which the token exists
`contract_address`	`VARBINARY`	Token contract address
`symbol`	`VARCHAR`	Token ticker symbol
`name`	`VARCHAR`	Full token name
`decimals`	`INTEGER`	Number of decimal places used by the token
`_updated_at`	`TIMESTAMP`	When this record was last updated

Sample Queries

Query ERC20 tokens on a specific blockchain This query returns ERC20 tokens on the Ethereum blockchain:

SELECT
    contract_address,
    symbol,
    decimals
FROM tokens.erc20
WHERE blockchain = 'ethereum'
LIMIT 100

Find tokens with a specific symbol across blockchains This query finds all tokens with the symbol “USDC” across different blockchains:

SELECT
    blockchain,
    contract_address,
    symbol,
    decimals
FROM tokens.erc20
WHERE symbol = 'USDC'

List tokens with non-standard decimal places This query lists tokens that don’t use the standard 18 decimal places:

SELECT
    blockchain,
    contract_address,
    symbol,
    decimals
FROM tokens.erc20
WHERE decimals != 18
ORDER BY decimals DESC
LIMIT 50

Count tokens by blockchain This query shows the distribution of tokens across different blockchains:

SELECT
    blockchain,
    COUNT(*) as token_count
FROM tokens.erc20
GROUP BY blockchain
ORDER BY token_count DESC

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

ERC20 Token Metadata

Coverage

Data Sources

Utility

Table Schema

Sample Queries

​Coverage

​Data Sources

​Utility

​Table Schema

​Sample Queries

Coverage

Data Sources

Utility

Table Schema

Sample Queries