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.
contract_addressrefers to the contract emmitting the event, i.e. the token address, while
evt_indexconveniently lets you join with
ethereum.logsusing a query like
erc20.tokensto get human readable token symbols and the number of decimals like
Synthetixand are found in the
prices.usd_daihave been renamed to
prices.usd_sai, and the symbol changed to
SAI- we still don’t have
DAIprices unfortunately, as our price provider has not listed it.
prices.usd_repnow has the correct token address for
REPfor entries after the migration. Previsouly all entries had the old address.