Flipside Docs
Search…
Address Balance Model
Flipside records the balance for every address that is involved within a transaction, in addition to account for such things as genesis allocation and mint-time distributions.
Balances for each address are rolled up into a daily balance table, account for every address we've seen on the network.

Daily Balance Table Schema

Field
Description
date
The date the balance was recorded.
address
The address the balance was recorded for.
balance
The decimal adjusted balance recorded for the address.
balance_usd
The USD equivalent of the recorded balance.
balance_type
The type of balance, i.e. 'liquid', 'staked', 'locked', etc.
currency
The on-chain asset being recorded.

Dataset Features:

  • Current day data is updated throughout the day to provide an up-to-date reading of balances.
  • If an account is inactive one day, their previous day's balance is carried forward.
  • The currency field denotes which on-chain asset is being recorded.
  • Addresses are labeled according to our Label System.
  • Label fields are left blank (NULL) if the address is unlabeled.
Copy link
Contents