ERC20 Tokens

ERC20 tokens indexed by Allium.

Sample Query

Querying the latest erc20 tokens created by block_timestamp.

select *
  from polygon.raw.erc20_tokens
  where address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174'
order by block_timestamp desc 
limit 100

Table Columns

USDC used as an example.

Column Name	Description	Example
address	Contract address of the ERC20 token.	0x2791bca1f2de4661ed88a30c99a7a9449aa84174
name	Name of the ERC20 token.	USD Coin (PoS)
symbol	The token symbol.	USDC
decimals	The number of decimal points the token amounts are represented in. This is used to calculate the normalized amount of a token by taking the raw amount divided by 10^decimal_points. Using USDC as an example with 6 decimal points, the normalized value for 2500000 USDC is 2500000 / 10^6 = 2.5	6
block_timestamp	The timestamp of the block that this ERC20 token was created in.
block_number	The number of the block that this ERC20 token was created in.
block_hash	The hash of the block that this ERC20 token was created in.