Native Balances Latest
The current Native balance of all addresses.
The assets.native_balances_latest table contains the latest balance of Native of all addresses. It is otherwise identical to Native Balances.
Sample Query
Getting the latest Native balance of an address.
Table Columns
Unique Key: unique_id
address
VARCHAR
Address of the account
token_address
VARCHAR
Address of the native token, which is represented as null address (0x0000000000000000000000000000000000000000)
token_name
VARCHAR
Name of the native token
token_symbol
VARCHAR
Symbol of the token
raw_balance
NUMERIC
Raw balance of native token in wei
raw_balance_str
VARCHAR
Raw balance of native token in wei and in string format
balance
FLOAT
Balance of native token normalized
balance_str
VARCHAR
Balance of native token normalized and in string format
usd_balance_current
FLOAT
USD balance of ETH at the current timestamp
usd_balance_at_block_timestamp
FLOAT
USD balance of ETH at the timestamp of the last activity that resulted in balance change
usd_exchange_rate_current
FLOAT
USD exchange rate of ETH at the current timestamp
usd_exchange_rate_at_block_timestamp
FLOAT
USD exchange rate of ETH at the timestamp of the last activity that resulted in balance update
last_activity_block_timestamp
TIMESTAMP_NTZ(9)
The last timestamp of the block that resulted in the balance update
last_activity_block_number
INTEGER
The last block number that resulted in the balance update
last_activity_block_hash
VARCHAR
The last hash of the block that resulted in the balance update
_updated_at__usd_exchange_rate_current
TIMESTAMP_NTZ(9)
Timestamp of the current USD exchange
unique_id
VARCHAR
Unique ID of the balance
_updated_at
TIMESTAMP_NTZ(9)
Timestamp of the balance update
Last updated