erc20."ERC20_evt_Transfer"
and erc20."ERC20_evt_Approval"
tables to get decoded token transfers and approvals. These tables should include all events that could be decoded using the ABI of the ERC20 standard. This means that all transfers from all tokens can be queried through this table. The table is large (240M rows at time of writing), so please let us know your experience of the query performance.erc20."ERC20_evt_Transfer"
schema:"from"
bytea
"to"
bytea
value
numeric
contract_address
bytea
evt_tx_hash
bytea
evt_index
bigint
erc20."ERC20_evt_Approval"
schema:owner
bytea
spender
bytea
value
numeric
contract_address
bytea
evt_tx_hash
bytea
evt_index
bigint
contract_address
refers to the contract emmitting the event, i.e. the token address, while evt_tx_hash
and evt_index
conveniently lets you join with ethereum.logs
using a query likeerc20.tokens
to get human readable token symbols and the number of decimals likegnosis_sight
, gnosis_safe
and gnosis_dfusion
schemas respectively.Synthetix
and are found in the synthetix
schemaprices.usd_dai
have been renamed to prices.usd_sai
, and the symbol changed to SAI
- we still don’t have DAI
prices unfortunately, as our price provider has not listed it.prices.usd_rep
now has the correct token address for REP
for entries after the migration. Previsouly all entries had the old address.