Skip to main content
The assets.fungible_balances contains block-level balances of fungible tokens (ERC20 and native (gas) tokens). Fungible balances combines both native and erc20 balances into a single table. Each entry in the model corresponds to a specific event/transaction that causes a balance change in a particular asset at the block level. This means a new data entry is only created when a transaction alters an asset’s balance at the block level. For example, if a wallet receives 1 USDC in 2020 and experiences no further changes until yesterday, the model will have two entries: one for the initial receipt in 2020 and another for the recent change

​
Table Columns

Unique Key: unique_id
Column NameData TypeDescription
addressVARCHARThe wallet address holding the tokens
token_addressVARCHARContract address of the token
token_nameVARCHARName of the token
token_symbolVARCHARSymbol of the token
raw_balanceFLOATToken balance, unnormalized
raw_balance_strVARCHARToken balance as string to retain precision
balanceFLOATToken balance, normalized
balance_strVARCHARToken balance as string to retain precision
usd_balanceFLOATToken balances in USD
usd_exchange_rateFLOATExchange rate used for USD conversion
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block
block_numberBIGINTNumber of the block
block_hashVARCHARHash of the block
unique_idVARCHARUnique identifier combining block, address, token address, token_id, and type
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full refresh