assets.native_balances_latest table contains the latest balance of MATIC of all addresses. It is otherwise identical to MATIC Balance.
Table Columns
| Column Name | Description | Example |
|---|---|---|
| address | Address of the account. | 0xfc6b13fa53d369ca727ae1103e287786eedea24b |
| token_address | Address of the Ether, which is represented as nulll address. | 0x0000000000000000000000000000000000000000 |
| token_name | Name of the token. | MATIC |
| token_symbol | Symbol of the token. | MATIC |
| raw_balance | Raw balance of ether in wei. | 6.15E+16 |
| raw_balance_str | Raw balance of ether in wei and in string format. | 61546380600000001 |
| balance_str | Balance of ether normalized and in string format. | 0.0615463806 |
| balance | Balance of ether normalized. | 0.0615463806 |
| usd_balance_current | USD balance of MATIC at the current timestamp. | 0.04698450695 |
| usd_balance_at_block_timestamp | USD balance of MATIC at the timestamp of the last activity that resulted in balance change. | 0.1121375055 |
| usd_exchange_rate_current | USD exchange rate of MATIC at the current timestamp. | 0.7634 |
| usd_exchange_rate_at_block_timestamp | USD exchange rate of MATIC at the timestamp of the last activity that resulted in balance update. | 1.822 |
| transaction_hash | The transaction hash that resulted in the balance update. | 0x29bbe45222f99a2d89ece577b2c21a42ecd575146b9231d9486624e3281c7c84 |
| last_activity_block_timestamp | The last timestamp of the block that that resulted in the balance update. | 2022-02-15 15:41:46 |
| last_activity_block_number | The last block number that resulted in the balance update. | 24,975,778 |
| last_activity_block_hash | The last hash of the block that resulted in the balance update. | 0xbd5913bce15ce278f8cfe889253ff58cf445e907e6724f1de972a2d0c74797fc |