Skip to main content

Table Details

PropertyValue
Table Nameethereal.raw.erc20_tokens
Table StatusProduction-Ready
Unique Keyaddress
Clustering Key(s)to_date("block_timestamp")
Search Optimizationaddress

Table Columns

Column NameData TypeDescription
addressVARCHAR(42)Contract address of the ERC20 token.
nameVARCHAR(16777216)Name of the ERC20 token.
symbolVARCHAR(16777216)The token symbol.
decimalsNUMBER(38,0)The number of decimal points the token amounts are represented in.
block_timestampTIMESTAMP_NTZ(9)(Nullable*) The timestamp of the block.
block_numberNUMBER(38,0)(Nullable*) The block number that this token was created in.
block_hashVARCHAR(66)(Nullable*) The hash of the block.
_created_atTIMESTAMP_NTZ(9)Timestamp of entry creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of entry update.