Flipside Docs
Search…
ERC20 Balances Table
The ethereum.erc20_balances table contains daily roll-ups of balances for each address associated with an ERC-20 token. The table is updated throughout the day, to provide an intra-day view of balance readings as on-chain events occur.

Table Schema

ethereum.erc20_balances
Field
Type
Description
amount_usd
number
USD Value of the token balance
balance
number
Latest recorded balance for that given day and token.
balance_date
string
UTC timestamp of the day the balance was recorded on.
contract_address
address
Token contract address.
contract_label
label
The label associated with the contract_address(see Labels section for more details).
label
label
The label associated with the user_addresscolumn (see Labels section for more details).
label_subtype
label
The label subtype associated with the user_addresscolumn (see Labels section for more details).
label_type
label
The label type associated with the user_addresscolumn (see Labels section for more details).
price
number
The average price of the token that day.
symbol
string
Token symbol.
user_address
address
The address the balance is for.
Copy link
Contents
Table Schema