Sample query:

select * from bitcoin.assets.balances

where block_timestamp >= current_timestamp - interval '5 hours';

Table Columns

Column NameDescriptionExample
addressAddress of the account.bc1qvs5783dumxhulduns7r48tk744dulw2x2nt2kk
raw_balanceBalance of tokens (unnormalized)15,834,706
raw_balance_strString of balance of tokens15834706
balanceBalance of the token, normalized by the decimal points defined by BTC protocol in sats. One sat = 1e-8 btc0.15834706
balance_strBalance of this token, normalized by the decimal points defined in the token contract.0.15834706
usd_balanceThe amount of tokens, in $USD at the current time.5,373.119530803
usd_exchange_rateThe exchange rate used to calculate the usd_value at current time.33,932.55
block_timestampThe timestamp of the block that that resulted in change in balance.2023-10-24 09:34:58
block_numberThe number of the block that resulted in change in balance.813,624
block_hashThe hash of block that resulted in change in balance.00000000000000000003306de67b0a54e98ef716b46b012d4d0937286e38d577
unique_idUnique ID of the balances entryblock-813634_address-18BHxCWdeGXLFm9BwpmaPzEMLbcxHxiwRj_bitcoin