Flipside Docs
Search…
What is Flipside?
Our Data
Data Updates
Data Model Overview
Tables
AAVE Tables
Algorand Tables
Astroport Tables
Compound Tables
Ethereum Tables
Ethereum Transactions Table
Ethereum UDM Events Table
Ethereum Events Emitted Table
Ethereum Contracts Table
ERC20 Balances Table
Ethereum NFT Tables
Ethereum DEX Tables
Ethereum_Core Tables
Ethereum_Sushi Tables
FLOW Tables
Osmosis Tables
Polygon Tables
Solana Tables
Terra Tables
Terraswap Tables
THORChain Tables
Uniswap V3 Tables
Data Tutorials
Flipside App
Getting Started with the Flipside App
Parameterized Queries
Query Editor Shortcuts
Powered By GitBook
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
address_name
​label​
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.
Previous
Ethereum Contracts Table
Next
Ethereum NFT Tables
Last modified 1yr ago
Copy link
Contents
Table Schema