The assets.matic_balances_latest table contains the latest balance of MATIC of all addresses. It is otherwise identical to MATIC Balance.

Table Columns

Column NameDescriptionExample
addressAddress of the account.0xfc6b13fa53d369ca727ae1103e287786eedea24b
token_addressAddress of the Ether, which is represented as nulll address.0x0000000000000000000000000000000000000000
token_nameName of the token.MATIC
token_symbolSymbol of the token.MATIC
raw_balanceRaw balance of ether in wei.6.15E+16
raw_balance_strRaw balance of ether in wei and in string format.61546380600000001
balance_strBalance of ether normalized and in string format.0.0615463806
balanceBalance of ether normalized.0.0615463806
usd_balance_currentUSD balance of MATIC at the current timestamp.0.04698450695
usd_balance_at_block_timestampUSD balance of MATIC at the timestamp of the last activity that resulted in balance change.0.1121375055
usd_exchange_rate_currentUSD exchange rate of MATIC at the current timestamp.0.7634
usd_exchange_rate_at_block_timestampUSD exchange rate of MATIC at the timestamp of the last activity that resulted in balance update.1.822
transaction_hashThe transaction hash that resulted in the balance update.0x29bbe45222f99a2d89ece577b2c21a42ecd575146b9231d9486624e3281c7c84
last_activity_block_timestampThe last timestamp of the block that that resulted in the balance update.2022-02-15 15:41:46
last_activity_block_numberThe last block number that resulted in the balance update.24,975,778
last_activity_block_hashThe last hash of the block that resulted in the balance update.0xbd5913bce15ce278f8cfe889253ff58cf445e907e6724f1de972a2d0c74797fc