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

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`

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

Last updated 1 year ago