Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

Note that the USD prices of any given latest balance might lag more than you expect them to. Check the _updated_at__usd_exchange_rate_current column to ensure the price is fresh enough for your use case.
The assets.native_balances_latest table contains the latest balance of ETH of all addresses. It is otherwise identical to ETH Balances.

​
Sample Query

-- Get the latest ETH balance of a particular user address
select * from ethereum.assets.native_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

​
Table Columns

Column NameDescriptionExample
addressAddress of the account.0x66a84d487780c088d862971045d84b02d9b25aab
token_addressAddress of the Ether, which is represented as nulll address.0x0000000000000000000000000000000000000000
token_nameName of the token.ETH
token_symbolSymbol of the token.ETH
raw_balanceRaw balance of ether in wei.216,765,847,229,634
raw_balance_strRaw balance of ether in wei and in string format.216765847229634
balanceBalance of ether normalized.0.0002167658472
balance_strBalance of ether normalized and in string format.0.0002167658472
usd_balance_currentUSD balance of ETH at the current timestamp.0.308804626
usd_balance_at_block_timestampUSD balance of ETH at the timestamp of the last activity that resulted in balance change.0.2800939895
usd_exchange_rate_currentUSD exchange rate of ETH at the current timestamp.1,424.60
usd_exchange_rate_at_block_timestampUSD exchange rate of ETH at the timestamp of the last activity that resulted in balance update.1,292.15
last_activity_block_timestampThe last timestamp of the block that that resulted in the balance update.2022-12-05 03:58:11
last_activity_block_numberThe last block number that resulted in the balance update.16,116,061
last_activity_block_hashThe last hash of the block that resulted in the balance update.0x49ae37a2a5feb07d3f237dbfe4af59abb3b9ef19e3cd47ef083f1d7e45a2e616
_updated_at__usd_exchange_rate_currentTimestamp of the current USD exchange.2023-03-10 22:00:00
unique_idUnique ID of the balance.block-16116061_address-0x66a84d487780c088d862971045d84b02d9b25aab_eth
_updated_atTimestamp of the balance update.2023-03-10 10:18:07