Movement Raw Current Fungible Asset Balances
Chain
Movement MainnetDataset name
movement_mainnet.raw_current_fungible_asset_balancesVersion
1.0.0Description
Current balance per storage_id, merging v1 coin + v2 FA into a unified amount. Query this for "what wallet X holds now."
Example data
| storage_id | owner_address | asset_type_v2 | asset_type_v1 | is_primary | is_frozen | amount_v1 | amount_v2 | amount | last_transaction_version_v1 | last_transaction_version_v2 | last_transaction_version | last_transaction_timestamp_v1 | last_transaction_timestamp_v2 | last_transaction_timestamp | inserted_at | asset_type | token_standard |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x00a4b597bb3e6db47f64865c5d2fecda6639e8a45ac9e6b3937c136c8be042a0 | 0x9e04c70917b13f84f907f97bffe6ac8ad5e59755f41c78ed2a60dc635da14983 | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | null | true | false | null | null | 629465 | 629465 | null | 1742357162000 | 1742357162000 | 1781249785215 | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | v2 | ||
| 0x004a8bea9b7f05090f768f2a293c93014067f65a4822784e1ba1df9fdcf132b8 | 0x4ed7e8acb82e5fb9ffac2cde07d20ebee2cf061f8e03d67f2639c1a895b05d4c | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | null | true | false | null | null | 576973 | 576973 | null | 1742276313000 | 1742276313000 | 1781248980925 | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | v2 | ||
| 0x007bf29e643866b1ffa71a41e3dedc658145cbe515adc833ba8a5204b7f721ef | 0x9dd32c848bbf9086addbed96582e3eac4c5696b5d08b4ce4570a1228a352192f | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | null | true | false | null | null | 624606 | 624606 | null | 1742349292000 | 1742349292000 | 1781249704360 | 0x447721a30109c662dde9c73a0c2c9c9c459fb5e5a9c92f03c50fa69737f5d08d | v2 |
Schema
| Column | Type |
|---|---|
| storage_id | string |
| owner_address | string |
| asset_type_v2 | string |
| asset_type_v1 | string |
| asset_type | string |
| is_primary | boolean |
| is_frozen | boolean |
| amount_v1 | decimal |
| amount_v2 | decimal |
| last_transaction_version_v1 | long |
| last_transaction_version_v2 | long |
| last_transaction_timestamp_v1 | timestamp-millis |
| last_transaction_timestamp_v2 | timestamp-millis |
| inserted_at | timestamp-millis |