Sample query:

select * from bitcoin.assets.balances_latest

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

Table Columns

Column NameDescriptionExample
addressAddress of the account.bc1qdm8s6drm6dkvfqczyneldq2zmw5995dg3hhvky
token_addressToken address of the asset, 0x0000000000000000000000000000000000000000 for native token0x0000000000000000000000000000000000000000
token_nameName of the token.BTC
token_symbolToken symbol of this token.BTC
raw_balanceBalance of tokens (unnormalized)15,834,706
raw_balance_strBalance of tokens (unnormalized) in string.15834706
balance_strBalance of the token, normalized by the decimal points defined by BTC protocol in sats. One sat = 1e-8 btc0.15834706
balanceBalance of this token, normalized by the decimal points defined in the token contract.0.15834706
usd_balance_currentThe amount of tokens, in $USD at the current time5,373.119530803
usd_balance_at_block_timestampThe amount of tokens, in $USD at the price evaluated at the time of the block_timestamp5,403.393905204
usd_exchange_rate_currentThe exchange rate used to calculate the usd_value at current time33,932.55
usd_exchange_rate_at_block_timestampThe exchange rate used to calculate the usd_value at block_timestamp34,123.74
last_activity_block_timestampThe latest timestamp of the block that that resulted in change in balance.2023-10-24 09:34:58
last_activity_block_numberThe number of the latest block that resulted in change in balance.813,624
last_activity_block_hashThe hash of the latest block that resulted in change in balance.00000000000000000003306de67b0a54e98ef716b46b012d4d0937286e38d577
_updated_at__usd_exchange_rate_currentTime the usd exchange rate was calculated2023-10-24 17:00:00
_updated_at__unhydratedTime the raw balance was calculated2023-10-24 18:17:07
_updated_atTime the row was updated2023-10-24 18:17:07
unique_idUnique ID of the balances entryblock-20755138_address-0xe6c27255fbb9d3a9718fb5e2dc313cd6eba10b78_eth