ERC20 Tokens - Allium Documentation Hub

Table Details

Property	Value
Table Name	`avalanche.raw.erc20_tokens`
Table Status	Production-Ready
Unique Key	`address`
Clustering Key(s)	`to_date("block_timestamp")`
Search Optimization	`address`

Table Columns

Column Name	Data Type	Description
address	VARCHAR(42)	Contract address of the ERC20 token.
name	VARCHAR(16777216)	Name of the ERC20 token.
symbol	VARCHAR(16777216)	The token symbol.
decimals	NUMBER(38,0)	The number of decimal points the token amounts are represented in.
block_timestamp	TIMESTAMP_NTZ(9)	(Nullable*) The timestamp of the block.
block_number	NUMBER(38,0)	(Nullable*) The block number that this token was created in.
block_hash	VARCHAR(66)	(Nullable*) The hash of the block.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of entry creation.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of entry update.

* These fields are null for tokens that are indexed by our self-healing / patching pipelines in the event that our initial decoding attempt is unsuccessful.

EVM Raw ERC20 Tokens