Fungible Balances EOD

The fungible_balances_eod table provides end-of-day balance snapshots for each address and fungible token.

Unique Key: block_date, address, currency

Column Name	Description
address	The wallet address holding the balance.
currency	The currency or token denomination for the balance.
raw_balance_str	The raw balance as a string to retain precision.
block_date	The date of the end-of-day balance snapshot.
block_timestamp	The timestamp of the block that produced the end-of-day balance.
block_height	The height of the block that produced the end-of-day balance.
block_hash	The hash of the block that produced the end-of-day balance.
transaction_hash	The hash of the transaction that last changed the balance for the day.
transaction_index	The index of the transaction within the block.
event_index	The index of the event within the transaction.
block_event_kind	The phase in which the block event was emitted, such as begin, end, or finalize.
block_event_index	The index of the block event within the block.
block_event_type	The type of block event that changed the balance.
unique_id	A unique identifier for this balance snapshot.
_address_short	A shortened version of the address for indexing.
_currency_short	A shortened version of the currency for indexing.
_pseudo_global_order	A pseudo-global ordering field for consistently selecting the latest balance event within a day.

Documentation Index