Flipside Docs
Search…
Osmosis Daily Balances

Table Schema

osmosis.daily_balances
This table is currently under development and will release in the Velocity App soon. This table only includes balances for addresses that are actively staking or providing liquidity to a liquidity pool. If an address is not doing either of these actions on a given date, it will not be represented in the table on that date.
Field
Type
Description
date
timestamp
The day that the balance corresponds to.
balance_type
string
Either "staked" or "liquid."
address
string
The wallet that the balance belongs to.
currency
string
An address that corresponds to the currency in the wallet.
decimal
integer
Divide "balance" by POW(10, decimal) to get the balance.
balance
integer
The amount of currency in the wallet on the given day.
Copy link