Balances Daily

Sample query: Fetch the daily balance of a wallet over time.

select * from bitcoin.assets.balances_daily
where address = '34xp4vRoCGJym3xR7yCVPFHoCNxv4Twseo'
order by date desc

Table Columns Unique Key: date, address

Unique Key	Description
date	Date of the balance.
address	Address of the account.
raw_balance_str	String of balance of tokens
raw_balance	Balance of tokens (unnormalized)
balance_str	Balance of this token, normalized by the decimal points defined in the token contract.
balance	Balance of the token, normalized by the decimal points defined by BTC protocol in sats. One sat = 1e-8 btc
usd_balance	The amount of tokens, in $USD at the current time.
usd_exchange_rate	The exchange rate used to calculate the usd_value at current time.
last_activity_block_timestamp	Timestamp of the last activity block.
last_activity_block_number	Number of the last activity block.
last_activity_block_hash	Hash of the last activity block.
last_activity_transaction_hash	Hash of the last activity transaction.
last_activity_transaction_index	Index of the last activity transaction.
_created_at	Timestamp of the balance entry creation.
_updated_at	Timestamp of the balance entry update.

⌘I