Tokens Data
Decoded ERC token metadata.
Query ERC tokens by contract address.
select * from ethereum.erc20_tokens
where address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC ContractComing Soon
ERC20 tokens equivalent (e.g. BEP-20, TRC-20 tokens)
Table "evm.erc20_tokens"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
-----------------+-----------------------------+-----------+----------+-------------------+----------+-------------+--------------+-------------
address | character varying(42) | | not null | | extended | | |
name | character varying | | | | extended | | |
symbol | character varying | | | | extended | | |
decimals | bigint | | | | plain | | |
block_timestamp | timestamp without time zone | | | | plain | | |
block_number | bigint | | | | plain | | |
block_hash | character varying(66) | | | | extended | | |
_created_at | timestamp without time zone | | | CURRENT_TIMESTAMP | plain | | |
_updated_at | timestamp without time zone | | | CURRENT_TIMESTAMP | plain | | |
Indexes:
"erc20_tokens_pk" PRIMARY KEY, btree (address)
"erc20_tokens_address_index" btree (address)
"erc20_tokens_block_timestamp_index" btree (block_timestamp DESC)
"erc20_tokens_symbol_index" btree (symbol)Last updated