ERC20 Tokens

ERC20 tokens indexed by Allium.

Sample Query

Querying the latest erc20 tokens created by block_timestamp.

select *
  from ethereum.raw.erc20_tokens
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.	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
name	Name of the ERC20 token.	USDC
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.	2018-08-03 19:28:24
block_number	The number of the block that this ERC20 token was created in.	6082465
block_hash	The hash of the block that this ERC20 token was created in.	0xb2f6986457f5a24ff088a0beb5567c8c1fe2da02687c78e743507ee7c982b977