movement

Tables

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`first_version`	`STRING`	Starting version number of the first transaction included in this block. References Movement’s internal version counter that increments sequentially across all transactions.
`last_version`	`STRING`	The version number of the last transaction included in this block on the Movement chain. String-encoded integer that increments sequentially across all blocks and transactions in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transactions`	`ARRAY<STRING>`	List of transaction identifiers or transaction objects included in the block.

Sample Data

timestamp	block_hash	block_height	last_version	transactions	first_version
2025-03-15T17:03:46.431Z	0x0a0254dfeb4e3317ae8aac6e3a410cc8a25e49a9971972bd7d8c4d8d06e7ba67	128535	488954	[“0xc37c07b4c02a4ac6acc51831db9dca0d216b0659de0cd159c61e72789a28c368”,“0x3fb5c0e76200da924160848042e56d732e5d6695d5d73b3283cc254a4449a8c0”,“0xc7d8b15daa85fe3c1c9d86080a34ddf3c88df322c91d4b4bcfe16f855123e91a”]	488952
2025-03-15T01:23:33.104Z	0x0cbdecc0dce6f17486cf43cc006f211d372df3f1c5e44a8fa7d54ef20e211149	124577	477052	[“0xf1aaea5466a63ef3f2dc71875b24a67df728e90ce9df44e8f2ddabba0b2e2949”,“0xa64625502c5c056201dc828463e752f9d4231c05c314a2597ab6f1d4ef400c41”]	477051
2025-03-15T16:28:25.314Z	0x1d17ad25d89cd595a1e4f8a47196be7f8dc9dd0430135f6991c6c1032081cdc8	128293	488233	[“0xef4c136cfe3a44aa6e043802981c25698c96b443c7789463ab00fd85ecdeefd2”,“0xddfc8d054d3efd67073d29943e93e389f1fc2bafcf246a4b445ca890097400e9”,“0x6dc32488943f76fa37c7e0b1520dba5bec690e9887c03f210ce4b7162bc6869a”]	488231

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

changes

State change records from Movement blockchain transactions capturing resource writes, including account balances, coin stores, and smart contract data modifications for tracking on-chain state transitions and protocol interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`changes_index`	`INT64`	Sequential position of a state change within a transaction. Zero-indexed integer representing the order of resource writes, module deployments, or table updates in the transaction’s execution.
`changes_type`	`STRING`	Type of blockchain state modification performed. Values include write_resource for account resource updates, write_module for smart contract deployments, and write_table_item for table entry modifications.
`changes_address`	`STRING`	Account address where the state change occurred. Hex-encoded, 0x-prefixed string representing the on-chain account affected by the resource write, module deployment, or table update.
`data_type`	`JSON`	Fully qualified type identifier of the resource or data structure. Format follows Move module path convention with address, module name, and type name separated by double colons, including generic type parameters in angle brackets where applicable.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`changes`	`STRUCT<address STRING, state_key_hash STRING, data JSON, type STRING, handle STRING, key STRING, value STRING, resource STRING>`	Nested record containing the full state change object, including type, address, state key hash, and modified data. This is the raw, complete change event as emitted by the Movement blockchain.

Sample Data

data	changes	data_type	block_height	changes_type	changes_index	block_timestamp	changes_address	transaction_hash
{“coin”:{“value”:“83400”},“deposit_events”:{“counter”:“1”,“guid”:{“id”:{“addr”:“0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df”,“creation_num”:“2”}}},“frozen”:false,“withdraw_events”:{“counter”:“2”,“guid”:{“id”:{“addr”:“0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df”,“creation_num”:“3”}}}}	{“key”:null,“data”:”{“data”:{“coin”:{“value”:“83400”},“deposit_events”:{“counter”:“1”,“guid”:{“id”:{“addr”:“0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df”,“creation_num”:“2”}}},“frozen”:false,“withdraw_events”:{“counter”:“2”,“guid”:{“id”:{“addr”:“0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df”,“creation_num”:“3”}}}},“type”:“0x1::coin::CoinStore<0x1::aptos_coin::AptosCoin>”}”,“type”:“write_resource”,“value”:null,“handle”:null,“address”:“0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df”,“resource”:null,“state_key_hash”:“0xf31353d74d2872370c01579dd494feecabcf6fdb4273bc5e6a67d64622504703”}	“0x1::coin::CoinStore<0x1::aptos_coin::AptosCoin>“	1070799	write_resource	0	2025-05-27T14:26:37.607Z	0x823365d25e2616212902a3ff1342df62fa7eed614f55e62caef78b5bdc8f05df	0xeb384201db6d837f9d4681a05aa1758d987321b9ae22d068daad03e20fcf6bee
{“current”:{“max_value”:“340282366920938463463374607431768211455”,“value”:“991616506957132563”}}	{“key”:null,“data”:”{“data”:{“current”:{“max_value”:“340282366920938463463374607431768211455”,“value”:“991616506957132563”}},“type”:“0x1::fungible_asset::ConcurrentSupply”}”,“type”:“write_resource”,“value”:null,“handle”:null,“address”:“0xa”,“resource”:null,“state_key_hash”:“0x1db5441d8fa4229c5844f73fd66da4ad8176cb8793d8b3a7f6ca858722030043”}	“0x1::fungible_asset::ConcurrentSupply”	1067746	write_resource	2	2025-05-27T11:02:47.071Z	0xa	0x9937419beb4b5c9ff7c217fe23641872b6dd0dd3dc8be07d0533862be8fb9db3
{“validators”:[{“failed_proposals”:“0”,“successful_proposals”:“1036863”}]}	{“key”:null,“data”:”{“data”:{“validators”:[{“failed_proposals”:“0”,“successful_proposals”:“1036863”}]},“type”:“0x1::stake::ValidatorPerformance”}”,“type”:“write_resource”,“value”:null,“handle”:null,“address”:“0x1”,“resource”:null,“state_key_hash”:“0x8048c954221814b04533a9f0a9946c3a8d472ac62df5accb9f47c097e256e8b6”}	“0x1::stake::ValidatorPerformance”	1075171	write_resource	2	2025-05-27T19:18:43.580Z	0x1	0x1a4eca540c5faa7a4ea0e060746b5e55c2e45805ed0d1b3f14a539f72a755039

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.changes`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

events

Blockchain state change notifications emitted by runtime modules during transaction execution and block processing. Contains event metadata (pallet, method, index), encoded parameters, block context, and optional extrinsic linkage for analyzing on-chain activity across Substrate-based chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`sequence_number`	`INT64`	Sequential counter tracking the number of transactions sent from an account. Integer value that increments with each transaction from the same sender address.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Processing phase within the blockchain’s block lifecycle. Values include ‘initialize’ for events occurring during block initialization, ‘finalize’ for events during block finalization, and chain-specific event type identifiers for transaction-related events.
`event_index`	`INT64`	Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier (GUID) on Movement blockchain. Typically ‘0x0’ for system-generated events or a hex-encoded address for user-specific events.
`event_guid_creation_number`	`INT64`	Account-specific identifier representing the creation number component of the event’s Globally Unique Identifier (GUID) in the Movement blockchain’s event system. Typically 0 for system-generated events, as shown in the samples.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.

Sample Data

data	event_type	event_index	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“amount_in”:“10000”,“amount_out”:“6543706”,“bid_liquidity”:“0”,“fa_in”:“0x83121c9f9b0527d1f056e21a950d6bf3b9e9e2e8353d0e95ccea726713cbea39”,“fa_out”:“0xa”,“fee_in”:“30”,“last_slot_timestamp”:“0”,“pool”:“0xc41f4a26f98b72b3c69d253adeb9d4766efb534ce38cb8f5b3e0cc229e0d1f91”,“slot_balance_x”:“0”,“slot_balance_y”:“0”}	0x13418bb00810eca160f77aa03e134d6d62b0859653f9236ccc6293acf1a6513d::events::Swap	4	3561084	2025-07-12T07:32:18.809Z	0x50759e7e96828739dadde88d277b0718ac13ac4f33c6135397c8f66152c6d49d	0x0
{“amount_in”:“17”,“amount_out”:“14490138”,“bid_liquidity”:“0”,“fa_in”:“0xb06f29f24dde9c6daeec1f930f14a441a8d6c0fbea590725e88b340af3e1939c”,“fa_out”:“0xa”,“fee_in”:“1”,“last_slot_timestamp”:“0”,“pool”:“0xdf7dd8b4965de3f63c6d977b4518ea518b9e254023661135ba82bf7c5513d41a”,“slot_balance_x”:“0”,“slot_balance_y”:“0”}	0x13418bb00810eca160f77aa03e134d6d62b0859653f9236ccc6293acf1a6513d::events::Swap	9	3581356	2025-07-12T16:16:02.825Z	0x4b8f297f78670a4837b9682e715606c87d68c1763320a4c29e322023e3983be9	0x0
{“pool_address”:“0xff22e2f44b858bcfd6477ddf1e4ee561bbc4c2624eaa33c58a51eaecfc13087b”,“reward_amount”:“163525398”,“reward_token”:{“inner”:“0xa”},“user”:“0x7524833c9a63667b23b17ef2d8e3c9b1e4cfc749c15b39e4aa581864da3fc5c3”}	0x113a1769acc5ce21b5ece6f9533eef6dd34c758911fa5235124c87ff1298633b::multi_rewards::RewardClaimedEvent	2	3594718	2025-07-12T22:48:27.814Z	0xc300970a79774da7eeabaf33b1b2020510f22d16581a576d725ff0ebfd53e7dc	0x0

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.events`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

modules

Smart contract module deployment and update records on Movement blockchain. Contains Move module bytecode, exposed functions, struct definitions, and module dependencies for tracking protocol deployments and upgrades.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`changes_type`	`STRING`	Type of blockchain state modification performed. Values include write_resource for account resource updates, write_module for smart contract deployments, and write_table_item for table entry modifications.
`changes_index`	`INT64`	Sequential position of a state change within a transaction. Zero-indexed integer representing the order of resource writes, module deployments, or table updates in the transaction’s execution.
`changes_address`	`STRING`	Account address where the state change occurred. Hex-encoded, 0x-prefixed string representing the on-chain account affected by the resource write, module deployment, or table update.
`module_address`	`JSON`	Account address where this smart contract module is deployed on Movement blockchain. Hex-encoded, 0x-prefixed 64-character string representing the module owner’s address.
`module_name`	`JSON`	Smart contract module identifier on the Movement blockchain. Stored as a string representing the module’s name within its parent package address.
`exposed_functions`	`JSON`	JSON-encoded array of public function definitions available in this smart contract module. Includes function signatures, parameter types, return types, visibility modifiers, and entry/view flags for each callable method.
`friends`	`JSON`	List of module addresses that can call restricted friend functions in this smart contract module. Follows Move language module path format (address::module_name).
`structs`	`JSON`	Smart contract data structures defined in this module, including their field names, types, and capabilities. Contains schema definitions for on-chain objects used by the module’s functions.
`bytecode`	`JSON`	Compiled module code in hexadecimal format representing the deployed smart contract bytecode on Movement. This field contains the executable code that runs when the module’s functions are called.
`state_key_hash`	`STRING`	Cryptographic hash of the blockchain state key. 66-character hex string including 0x prefix.

Sample Data

friends	structs	bytecode	module_name	block_height	changes_type	changes_index	module_address	state_key_hash	block_timestamp	changes_address	transaction_hash	exposed_functions
[“0xbbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b436::interest_rate_strategy”]	[{“abilities”:[“drop”],“fields”:[{“name”:“available_liquidity”,“type”:“u256”},{“name”:“total_debt”,“type”:“u256”},{“name”:“current_variable_borrow_rate”,“type”:“u256”},{“name”:“current_liquidity_rate”,“type”:“u256”},{“name”:“borrow_usage_ratio”,“type”:“u256”},{“name”:“supply_usage_ratio”,“type”:“u256”},{“name”:“available_liquidity_plus_debt”,“type”:“u256”}],“generic_type_params”:[],“is_native”:false,“name”:“CalcInterestRatesLocalVars”},{“abilities”:[“copy”,“drop”,“store”,“key”],“fields”:[{“name”:“optimal_usage_ratio”,“type”:“u256”},{“name”:“max_excess_usage_ratio”,“type”:“u256”},{“name”:“base_variable_borrow_rate”,“type”:“u256”},{“name”:“variable_rate_slope1”,“type”:“u256”},{“name”:“variable_rate_slope2”,“type”:“u256”}],“generic_type_params”:[],“is_native”:false,“name”:“DefaultReserveInterestRateStrategy”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“address”},{“name”:“optimal_usage_ratio”,“type”:“u256”},{“name”:“max_excess_usage_ratio”,“type”:“u256”},{“name”:“base_variable_borrow_rate”,“type”:“u256”},{“name”:“variable_rate_slope1”,“type”:“u256”},{“name”:“variable_rate_slope2”,“type”:“u256”}],“generic_type_params”:[],“is_native”:false,“name”:“ReserveInterestRateStrategy”},{“abilities”:[“key”],“fields”:[{“name”:“value”,“type”:“0x1::smart_table::SmartTable<address, 0xbbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b436::default_reserve_interest_rate_strategy::DefaultReserveInterestRateStrategy>”}],“generic_type_params”:[],“is_native”:false,“name”:“ReserveInterestRateStrategyMap”}]	“0xa11ceb0b060000000d0100100210180328a90104d1010a05db016207bd02a00908dd0ba00106fd0c22109f0dca020ae90f370ca010f4080d94191a0fae1902000001140217031c0320012c043101370001020000090f00000f060000110800011304020000000000150001000116030402020002180105000019060700001a000800001b010900031d070a00031e070a00001f070a000421010a000422070a000023000a000024000a000025000a000026000a0003270a0a000128030c0202000029000a00002a000a00002b0e0100052d0e0000012e010f020704022f01050000300004000632000400063300040000341001000335010a00013611010203020738130101060239010500023a0105000102100215021c021d120105000205080102060b040209000901090001010103070f0f0f0f0f050f020f0f010801010800010f0308010800070f010609010106080301060c010b04020900090106060c050f0f0f0f03070b04020900090109000901010802010900020f08012664656661756c745f726573657276655f696e7465726573745f726174655f73747261746567791a43616c63496e74657265737452617465734c6f63616c5661727313617661696c61626c655f6c69717569646974790a746f74616c5f646562741c63757272656e745f7661726961626c655f626f72726f775f726174651663757272656e745f6c69717569646974795f7261746512626f72726f775f75736167655f726174696f12737570706c795f75736167655f726174696f1d617661696c61626c655f6c69717569646974795f706c75735f646562742244656661756c7452657365727665496e746572657374526174655374726174656779136f7074696d616c5f75736167655f726174696f166d61785f6578636573735f75736167655f726174696f19626173655f7661726961626c655f626f72726f775f72617465147661726961626c655f726174655f736c6f706531147661726961626c655f726174655f736c6f7065321b52657365727665496e7465726573745261746553747261746567790561737365741e52657365727665496e7465726573745261746553747261746567794d61700576616c75650a536d6172745461626c650b736d6172745f7461626c651a61737365745f696e7465726573745f726174655f65786973747308636f6e7461696e730c6572726f725f636f6e666967156765745f6561737365745f6e6f745f6c69737465641863616c63756c6174655f696e7465726573745f7261746573226765745f726573657276655f696e7465726573745f726174655f7374726174656779256372656174655f63616c635f696e7465726573745f72617465735f6c6f63616c5f766172730c7761645f7261795f6d617468077261795f646976077261795f6d756c176765745f6f766572616c6c5f626f72726f775f726174650a6d6174685f7574696c73156765745f70657263656e746167655f666163746f720b70657263656e745f6d756c1d6765745f626173655f7661726961626c655f626f72726f775f726174651a6765745f6d61785f6578636573735f75736167655f726174696f1c6765745f6d61785f7661726961626c655f626f72726f775f72617465176765745f6f7074696d616c5f75736167655f726174696f0a7761645f746f5f72617906626f72726f77186765745f7661726961626c655f726174655f736c6f706531186765745f7661726961626c655f726174655f736c6f7065321b696e69745f696e7465726573745f726174655f7374726174656779067369676e65720a616464726573735f6f66036e6577136765745f656e6f745f726174655f6f776e6572186f6e6c795f7269736b5f6f725f706f6f6c5f61646d696e730a61636c5f6d616e6167650d69735f7269736b5f61646d696e0d69735f706f6f6c5f61646d696e227365745f726573657276655f696e7465726573745f726174655f73747261746567790372617906757073657274056576656e7404656d6974206765745f65696e76616c69645f6f7074696d616c5f75736167655f726174696f226765745f6563616c6c65725f6e6f745f7269736b5f6f725f706f6f6c5f61646d696e16696e7465726573745f726174655f7374726174656779bbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b43600000000000000000000000000000000000000000000000000000000000000012c07b806c26bf4d3107bfe95113c58e7b90fc0c3b77a0c51e65afe39492b8892877cef9f353e9610eeb2d3a75fa913067e7a9664905fb573c009863bf99134c9034ee7348fdc85555566b4f5c19a1de8478e4734ae539c6431528e02c4c32bb40520bbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b43614636f6d70696c6174696f6e5f6d65746164617461090003322e3003322e31126170746f733a3a6d657461646174615f7631960200011b52657365727665496e74657265737452617465537472617465677901040008176765745f6f7074696d616c5f75736167655f726174696f0101001863616c63756c6174655f696e7465726573745f7261746573010100186765745f7661726961626c655f726174655f736c6f706531010100186765745f7661726961626c655f726174655f736c6f7065320101001a6765745f6d61785f6578636573735f75736167655f726174696f0101001c6765745f6d61785f7661726961626c655f626f72726f775f726174650101001d6765745f626173655f7661726961626c655f626f72726f775f72617465010100226765745f726573657276655f696e7465726573745f726174655f7374726174656779010100000207020f030f040f050f060f070f080f0102050a0f0b0f0c0f0d0f0e0f02020610050a0f0b0f0c0f0d0f0e0f030201120b04020508010001000103010907002b0310000b00380004070211022703010001030b92010b0511040c0711050c080d080f010c090a030b09154a00000000000000000000000000000000000000000000000000000000000000000d080f02150e071003140d080f04150e081001144a000000000000000000000000000000000000000000000000000000000000000022031c05440b060b01160b02170d080f05150e081005140e08100114160d080f06150e081001140e0810061411060d080f07150e081001140e081006140b001611060d080f08150e081007140e0710091424047f0e081007140e07100914170e07100a1411060c000e081004140e07100b14160e07100c140b001107160d080f04150b030e0810041411080e08100814110711090b0417110a0d080f02150e081002140e08100414020e081004140e07100b140e0810071411070e071009141106160d080f041505680500000001094a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000001200020b0100010308070b0011040c010e01100314020c0100010308070b0011040c010e01100a14020d01000103080f0b0011040c010e011003140e01100b14160e01100c1416020e0100010308070b0011040c010e0110091402080000000a100a000c020a024a00000000000000000000000000000000000000000000000000000000000000002104084a0000000000000000000000000000000000000000000000000000000000000000020b00110f0b0111070b02110f11060204010001030d1707002b030c010a0110000a00380003110b01014a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000004a00000000000000000000000000000000000000000000000000000000000000001201020b0110000b0038011402110100010308070b0011040c010e01100b1402120100010308070b0011040c010e01100c140213010000010e0a001114070021040a0b00380212032d03020b000111162717000000040b0a0011180407080c010b01020b0011190c0105051a0104010314260b00111411170424111b0a02260422111b0a02170c060a020a060a030a040a0512010c0707002a030f000a010b0738030b010b020b060b030b040b051202380402111e27111f270300000100030102000200000006000400050100010101030104003b00"	"default_reserve_interest_rate_strategy”	22454	write_module	3	”0xbbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b436”	0xa009f57568f6fffb049cdf6e5ef7ed1dbeef797bdd48562bfb6d5218cbccde85	2025-03-05T07:20:05.205Z	0xbbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b436	0xb9c8c7ccbac7720b788988c05a1bd59c494647251aa6f3bff0a13a75b92cfed5	[{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“asset_interest_rate_exists”,“params”:[“address”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“calculate_interest_rates”,“params”:[“u256”,“u256”,“u256”,“u256”,“u256”,“address”,“u256”],“return”:[“u256”,“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_base_variable_borrow_rate”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_max_excess_usage_ratio”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_max_variable_borrow_rate”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_optimal_usage_ratio”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_reserve_interest_rate_strategy”,“params”:[“address”],“return”:[“0xbbda13fd537f58b936b96055756b1364a6bde477df462e41f736d1c53606b436::default_reserve_interest_rate_strategy::DefaultReserveInterestRateStrategy”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_variable_rate_slope1”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_variable_rate_slope2”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“init_interest_rate_strategy”,“params”:[“&signer”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_reserve_interest_rate_strategy”,“params”:[“&signer”,“address”,“u256”,“u256”,“u256”,“u256”],“return”:[],“visibility”:“public”}]
[“0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::price_calculator”,“0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::oracle”,“0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::price_cap_stable_adapter”]	[{“abilities”:[“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“address”},{“name”:“feed_id”,“type”:“vector<u8>”}],“generic_type_params”:[],“is_native”:false,“name”:“AssetPriceFeedRemoved”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“address”},{“name”:“feed_id”,“type”:“vector<u8>”}],“generic_type_params”:[],“is_native”:false,“name”:“AssetPriceFeedUpdated”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“address”}],“generic_type_params”:[],“is_native”:false,“name”:“AssetValidityPeriodRemoved”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“address”},{“name”:“validity_period”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“AssetValidityPeriodUpdated”},{“abilities”:[“copy”,“drop”,“store”],“fields”:[{“name”:“asset”,“type”:“0x1::string::String”},{“name”:“unit”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“BaseCurrency”},{“abilities”:[“key”],“fields”:[{“name”:“asset_feed_ids”,“type”:“0x1::smart_table::SmartTable<address, vector<u8>>”},{“name”:“asset_validity_periods”,“type”:“0x1::smart_table::SmartTable<address, u64>”},{“name”:“signer_cap”,“type”:“0x1::account::SignerCapability”},{“name”:“base_currency”,“type”:“0x1::option::Option<0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::oracle_base::BaseCurrency>”}],“generic_type_params”:[],“is_native”:false,“name”:“PriceOracleData”}]	“0xa11ceb0b060000000d01001202122e0340d2010492022805ba02b50107ef03e30808d20c800106d20d3610880ef3020afb103d0cb811c8040d80160c0f8c16060000010a010f01130116011d012a02330335000106000004060000050600000606000008070001090700000c0800020e040200000000031206000415070100000017000100001802000002190405020200021a0406020200001b080200001c030200051e0a020106001f0302000020000c0000210f100000220f0c0000230001000024021100042513050100041a1314010004260a15010004270215010000280200000329171800062b190000002c021800002d190200002e190200032f1a1b000230021c0207040031190500003219020007340005000836020c00073700050003381f00000039000200023a2021020300003b000200003c030200023d2302020302003e0d0200083f020c000040002500020303030609060b020d030d0d120e120f1210121803180d200d062220032303230d06240f0110010105010a020002050a0202060b0702090009010900010101060901010608060203030108000109000108010103020503020608060301060804010805010b0901080401080401060b0901090001060900010b09010900020608060b0901080401060808010c01060c02060c0a02020c0808010b0702090009010208080c0205010206050a0202070b070209000901090001090101080203070b07020900090109000901010803010b09010a02020608060b09010a020b6f7261636c655f6261736515417373657450726963654665656452656d6f76656405617373657407666565645f6964154173736574507269636546656564557064617465641a417373657456616c6964697479506572696f6452656d6f7665641a417373657456616c6964697479506572696f64557064617465640f76616c69646974795f706572696f640c4261736543757272656e637906537472696e6706737472696e6704756e69740f50726963654f7261636c65446174610e61737365745f666565645f6964730a536d6172745461626c650b736d6172745f7461626c651661737365745f76616c69646974795f706572696f64730a7369676e65725f636170105369676e65724361706162696c697479076163636f756e740d626173655f63757272656e6379064f7074696f6e066f7074696f6e1b6173736572745f61737365745f666565645f69645f6578697374730e6f7261636c655f6164647265737308636f6e7461696e7306626f72726f771e6173736572745f62656e63686d61726b735f6d617463685f6173736574731d656d69745f61737365745f70726963655f666565645f72656d6f766564056576656e7404656d69741d656d69745f61737365745f70726963655f666565645f75706461746564196765745f61737365745f76616c69646974795f706572696f64176765745f626173655f63757272656e63795f6173736574166765745f626173655f63757272656e63795f756e69740b6765745f666565645f6964186765745f6f7261636c655f626173655f63757272656e63790769735f736f6d6504736f6d65046e6f6e651b6765745f6f7261636c655f7265736f757263655f6163636f756e741d6372656174655f7369676e65725f776974685f6361706162696c697479067369676e65720a616464726573735f6f661b6765745f7265736f757263655f6163636f756e745f7369676e65720b696e69745f6f7261636c65116f6e6c795f6f7261636c655f61646d696e176372656174655f7265736f757263655f6163636f756e74036e65770f69735f6f7261636c655f61646d696e176f6e6c795f7269736b5f6f725f706f6f6c5f61646d696e0a61636c5f6d616e6167650d69735f706f6f6c5f61646d696e0c6572726f725f636f6e666967226765745f6563616c6c65725f6e6f745f7269736b5f6f725f706f6f6c5f61646d696e0d69735f7269736b5f61646d696e176372656174655f7265736f757263655f616464726573731c72656d6f76655f61737365745f76616c69646974795f706572696f640672656d6f76650e72656d6f76655f666565645f6964117365745f61737365745f666565645f696406757073657274197365745f61737365745f76616c69646974795f706572696f64226765745f65696e76616c69645f61737365745f76616c69646974795f706572696f64157472795f6765745f61737365745f666565645f69641070726963655f63616c63756c61746f72066f7261636c651870726963655f6361705f737461626c655f61646170746572b8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d2960000000000000000000000000000000000000000000000000000000000000001034ee7348fdc85555566b4f5c19a1de8478e4734ae539c6431528e02c4c32bb42c07b806c26bf4d3107bfe95113c58e7b90fc0c3b77a0c51e65afe39492b88920a0211104c4159455242414e4b5f4f5241434c450520b8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d29614636f6d70696c6174696f6e5f6d65746164617461090003322e3003322e31126170746f733a3a6d657461646174615f7631bf0204010000000000000012455f4f5241434c455f4e4f545f41444d494e00020000000000000016455f41535345545f414c52454144595f4558495354530003000000000000000f455f4e4f5f41535345545f4645454400040000000000000022455f4f5241434c455f42454e43484d41524b5f4c454e4748545f4d49534d41544348000415417373657450726963654665656452656d6f766564010400154173736574507269636546656564557064617465640104001a417373657456616c6964697479506572696f6452656d6f7665640104001a417373657456616c6964697479506572696f6455706461746564010400030e6f7261636c655f61646472657373010100186765745f6f7261636c655f626173655f63757272656e63790101001b6765745f6f7261636c655f7265736f757263655f6163636f756e740101000002020205030a020102020205030a020202010205030202020507030402020208050b030602040d0b0702050a02100b07020503110808140b090108040003000105071211012b050c010a0110000a003800040e0b0110000b00380114020b0101060300000000000000270403000002070b000b0121040502060400000000000000270503000002050b000b0112003802020703000002050b000b01120138030208030001050e1511012b050c010a0110010a00380404100b0110010b003805140c020b02020b0101062c010000000000000c02050e0901000002040b00100214020a01000002040b00100314020b03000105020711012b0510000b00380114020c01000105161411012b050c000a0010043806040f0b00100438071438080c010b01020b000138090c01050d1101000105180811012b05100511120c000e001113021403000105020511012b051005111202150300001d0f0a0011160b00070011170c010c020e02380a380b0b01380912052d05021901000002050b001113070121021601000002060b001119040402060100000000000000271a0300001e110b0011130c010a01111b040d080c020b02040b02111c270b01111d0c02050801010000000607010c000e000700111e021f03000105020a11012a050f010a00380c010b001202380d022103000105020711012a050f000b00380e01022203000105020711012a050f000b000b01380f022403000105051a0a010600000000000000002404170a01068051010000000000230c020b02041511012a050f010a000a0138100b000b011203381102112527090c0205082603000105261611012b050c010a0110000a00380004110b0110000b0038011438120c020b02020b010138130c02050f05000501040004010503050200410042004300"	"oracle_base”	22455	write_module	4	”0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296”	0x75556f7bee4a986f96d0c9eea766c3ae6966135b9428018d485ff714a8b92ee9	2025-03-05T07:20:17.223Z	0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296	0xbd68be2a155d7b8709276e2f92d299cc91233a11bbc7bdf2d3b2f63df2edecdf	[{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“assert_asset_feed_id_exists”,“params”:[“address”],“return”:[“vector<u8>”],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“assert_benchmarks_match_assets”,“params”:[“u64”,“u64”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“emit_asset_price_feed_removed”,“params”:[“address”,“vector<u8>”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“emit_asset_price_feed_updated”,“params”:[“address”,“vector<u8>”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“get_asset_validity_period”,“params”:[“address”],“return”:[“u64”],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“get_base_currency_asset”,“params”:[“&0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::oracle_base::BaseCurrency”],“return”:[“0x1::string::String”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“get_base_currency_unit”,“params”:[“&0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::oracle_base::BaseCurrency”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“get_feed_id”,“params”:[“address”],“return”:[“vector<u8>”],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_oracle_base_currency”,“params”:[],“return”:[“0x1::option::Option<0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::oracle_base::BaseCurrency>”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_oracle_resource_account”,“params”:[],“return”:[“address”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“get_resource_account_signer”,“params”:[],“return”:[“signer”],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“init_oracle”,“params”:[“&signer”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“is_oracle_admin”,“params”:[“&signer”],“return”:[“bool”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“only_oracle_admin”,“params”:[“&signer”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“only_risk_or_pool_admin”,“params”:[“&signer”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“oracle_address”,“params”:[],“return”:[“address”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“remove_asset_validity_period”,“params”:[“address”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“remove_feed_id”,“params”:[“address”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“set_asset_feed_id”,“params”:[“address”,“vector<u8>”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“set_asset_validity_period”,“params”:[“address”,“u64”],“return”:[],“visibility”:“friend”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“try_get_asset_feed_id”,“params”:[“address”],“return”:[“0x1::option::Option<vector<u8>>”],“visibility”:“friend”}]
[“0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296::price_cap_stable_adapter”]	[]	“0xa11ceb0b060000000801000a030a8201058c014707d301830408d605401096067b0c9107f7030f880b020000000200040005011300010001000103000100020300010003030001000006020300010602030000070401000108000100010702010000090501000109060100010a060100000b070100010b080100000c020900000d080900000e0a0100010f020b000110020100011106010000120d01000414010300020c080900031508090000160f1000001704010001060c000105010302060c0503060c050a0202050a0203060c0503020503010f02060c0a05010a0205030103050a0203060c0a050a0a02020f0f010a05010a0f050a0f0301030f066f7261636c650b696e69745f6d6f64756c650b6f7261636c655f626173650b696e69745f6f7261636c650b6f7261636c655f707974681070726963655f63616c63756c61746f72196765745f61737365745f76616c69646974795f706572696f641c72656d6f76655f61737365745f76616c69646974795f706572696f64176f6e6c795f7269736b5f6f725f706f6f6c5f61646d696e117365745f61737365745f666565645f69641d656d69745f61737365745f70726963655f666565645f75706461746564197365745f61737365745f76616c69646974795f706572696f640f6765745f61737365745f70726963651d6765745f61737365745f70726963655f66726f6d5f66616c6c6261636b1b62617463685f72656d6f76655f61737365745f666565645f6964731b6173736572745f61737365745f666565645f69645f6578697374730e72656d6f76655f666565645f69641d656d69745f61737365745f70726963655f666565645f72656d6f7665641862617463685f7365745f61737365745f666565645f6964730c6572726f725f636f6e6669671f6765745f65696e636f6e73697374656e745f706172616d735f6c656e6774680870726963655f6f66116765745f6173736574735f7072696365731472656d6f76655f61737365745f666565645f69641870726963655f6361705f737461626c655f61646170746572b8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d2962c07b806c26bf4d3107bfe95113c58e7b90fc0c3b77a0c51e65afe39492b889214636f6d70696c6174696f6e5f6d65746164617461090003322e3003322e31126170746f733a3a6d657461646174615f7631480000030f6765745f61737365745f7072696365010100116765745f6173736574735f707269636573010100196765745f61737365745f76616c69646974795f706572696f640101000000000001070a0011010a0011020b001103020401000001030b001105020601040001050b0011070b011108020901040001090b0011070a010a02110a0b010b02110b020c01040001060b0011070b010b02110d020e01000003070a0011050c010b000b01110f02100104000c280b0011070600000000000000000c02090c030e0141020c04050b05240a0304250b02060100000000000000160c020a020a0423031605240e010a024202140c050a0511110a0511120c060b050b061113050902080c030511140104000c330b0011070e0141020e02410b2104310600000000000000000c03090c040e0141020c050511052d0a04042e0b03060100000000000000160c030a030a0523031c052d0e010a034202140c060e020a03420b140c070a060a07110a0b060b07110b050f02080c0405171115270f0000000e110a000a0111160c020a024a000000000000000000000000000000000000000000000000000000000000000021040e0b000b0111170c030b03020b020c03050c180100001125400900000000000000000c010600000000000000000c02090c030e0041020c04050b05200a0304220b02060100000000000000160c020a020a0423031605200e000a02420214110e0c050d010b05440905090b0102080c030511190104000b0b0b0011070a0111110c020a0111120b010b02111302001800"	"oracle”	22455	write_module	3	”0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296”	0x442d08c3d774163c78df5a283ddc8dba72ef68c2f9abeb5b947f1b07d1be8a0f	2025-03-05T07:20:17.223Z	0xb8894dfe086ce32bc379724e95e1f9336246b5f5609de75e94dede9dbe36d296	0xbd68be2a155d7b8709276e2f92d299cc91233a11bbc7bdf2d3b2f63df2edecdf	[{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_asset_validity_period”,“params”:[“address”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“remove_asset_validity_period”,“params”:[“&signer”,“address”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_asset_feed_id”,“params”:[“&signer”,“address”,“vector<u8>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_asset_validity_period”,“params”:[“&signer”,“address”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_asset_price”,“params”:[“address”],“return”:[“u256”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“batch_remove_asset_feed_ids”,“params”:[“&signer”,“vector<address>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“batch_set_asset_feed_ids”,“params”:[“&signer”,“vector<address>”,“vector<vector<u8>>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:true,“name”:“get_assets_prices”,“params”:[“vector<address>”],“return”:[“vector<u256>”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“remove_asset_feed_id”,“params”:[“&signer”,“address”],“return”:[],“visibility”:“public”}]

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.modules`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

resources

State changes to Move resources on Movement blockchain, tracking write operations with resource type, address, and JSON data payloads. Enables analysis of smart contract state modifications and on-chain resource lifecycle across all modules and accounts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`changes_type`	`STRING`	Type of blockchain state modification performed. Values include write_resource for account resource updates, write_module for smart contract deployments, and write_table_item for table entry modifications.
`changes_index`	`INT64`	Sequential position of a state change within a transaction. Zero-indexed integer representing the order of resource writes, module deployments, or table updates in the transaction’s execution.
`changes_address`	`STRING`	Account address where the state change occurred. Hex-encoded, 0x-prefixed string representing the on-chain account affected by the resource write, module deployment, or table update.
`resource_address`	`STRING`	Account address that owns the resource being modified in this state change. Hex-encoded, 0x-prefixed address on the Movement blockchain, often `0x1` for system-level resources.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`data_type`	`STRING`	Fully qualified type identifier of the resource or data structure. Format follows Move module path convention with address, module name, and type name separated by double colons, including generic type parameters in angle brackets where applicable.
`state_key_hash`	`STRING`	Cryptographic hash of the blockchain state key. 66-character hex string including 0x prefix.

Sample Data

data	data_type	block_height	changes_type	changes_index	state_key_hash	block_timestamp	changes_address	resource_address	transaction_hash
{“data”:{“max_capacity”:2000,“next_idx”:0,“table”:{“inner”:{“handle”:“0x38ff67f17cf7998cd41ed5267b52cff7af37d06a22e8b390ce44b69680fc0e97”},“length”:“2000”}},“type”:“0x1::block::CommitHistory”}	0x1::block::CommitHistory	1541999	write_resource	1	0xe8e5837bc9b6b65c401636219abaf22a84a1facf1b7693ffe0048f1366b5aee5	2025-06-13T02:10:35.446Z	0x1	0x1	0x7922f2af9ef8803573bf1e42656d846f40ff62553396b28ef8fb60f2098087c0
{“data”:{“max_capacity”:2000,“next_idx”:0,“table”:{“inner”:{“handle”:“0x38ff67f17cf7998cd41ed5267b52cff7af37d06a22e8b390ce44b69680fc0e97”},“length”:“2000”}},“type”:“0x1::block::CommitHistory”}	0x1::block::CommitHistory	1573999	write_resource	1	0xe8e5837bc9b6b65c401636219abaf22a84a1facf1b7693ffe0048f1366b5aee5	2025-06-13T12:09:13.962Z	0x1	0x1	0x38ba336964aa0f03d7495b020d4a27c1bbc04555762aaa2761b5e699a1ea20d5
{“data”:{“max_capacity”:2000,“next_idx”:0,“table”:{“inner”:{“handle”:“0x38ff67f17cf7998cd41ed5267b52cff7af37d06a22e8b390ce44b69680fc0e97”},“length”:“2000”}},“type”:“0x1::block::CommitHistory”}	0x1::block::CommitHistory	1559999	write_resource	1	0xe8e5837bc9b6b65c401636219abaf22a84a1facf1b7693ffe0048f1366b5aee5	2025-06-13T07:40:40.956Z	0x1	0x1	0xdfed9ca98be1d345ad76b2f2c66af0d7ad39c1923b83ba822703d3c01030cf5a

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.resources`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

table_items

State changes to Move table storage on the Movement blockchain, tracking writes to key-value pairs within table handles. Useful for analyzing smart contract storage updates and state transitions at the transaction level.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`changes_type`	`STRING`	Type of blockchain state modification performed. Values include write_resource for account resource updates, write_module for smart contract deployments, and write_table_item for table entry modifications.
`changes_index`	`INT64`	Sequential position of a state change within a transaction. Zero-indexed integer representing the order of resource writes, module deployments, or table updates in the transaction’s execution.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`handle`	`STRING`	Table handle identifier representing the Move table where this state change occurred. Hex-encoded, 0x-prefixed 64-character string used to reference specific on-chain data structures.
`key`	`STRING`	Hex-encoded identifier for the table item entry within the Movement blockchain state. This 0x-prefixed hash serves as the lookup key for retrieving the associated value from the table handle.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`state_key_hash`	`STRING`	Cryptographic hash of the blockchain state key. 66-character hex string including 0x prefix.

Sample Data

key	data	value	handle	block_height	changes_type	changes_index	state_key_hash	block_timestamp	transaction_hash
0x0619dc29a0aac8fa146714058e8dd6d2d0f3bdf5f6331907bf91f3acd81e6935	null	0x299809bd710000000100000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	3410	write_table_item	3	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2025-01-03T00:00:15.611Z	0xf1dfbb4fb860848c463840d294d984607a7bbef43344ebcf690a2005646cc56b
0x0619dc29a0aac8fa146714058e8dd6d2d0f3bdf5f6331907bf91f3acd81e6935	null	0x4d9209bd710000000100000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	3413	write_table_item	3	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2025-01-03T03:00:14.759Z	0x791194db9369703fc31141bc4ddce94437f633fcbd908a2db19bd2fecfe3005f
0x0619dc29a0aac8fa146714058e8dd6d2d0f3bdf5f6331907bf91f3acd81e6935	null	0xdd7a09bd710000000100000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	3425	write_table_item	3	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2025-01-03T15:00:11.821Z	0x8ce8b1878cee41a5da1ac71e0960ef6b2320d866e41ba9db1768c9c060a190c9

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.table_items`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`hash`	`STRING`	Transaction hash uniquely identifying this transaction on the Movement blockchain. Hex-encoded, 0x-prefixed 64-character string that serves as the primary identifier for tracking and referencing specific transactions.
`timestamp`	`STRING`	Timestamp when the block was produced. UTC timezone.
`version`	`STRING`	Sequential version number of the transaction or block structure indicating the format specification. Integer value representing the data structure version used for encoding and validation.
`state_change_hash`	`STRING`	Cryptographic hash representing all state changes resulting from this transaction. Null for block metadata transactions that don’t modify state.
`event_root_hash`	`STRING`	Merkle root hash of all events emitted during this transaction’s execution. Hex-encoded, 0x-prefixed 64-character string used for cryptographic verification of event logs.
`state_checkpoint_hash`	`STRING`	Cryptographic hash representing the state checkpoint after this transaction’s execution. Null for most transaction types; populated for specific state synchronization operations.
`gas_used`	`STRING`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`success`	`STRING`	Boolean indicator of whether the operation completed successfully without errors.
`vm_status`	`STRING`	Status message returned by the virtual machine after executing the transaction. Typically “Executed successfully” for successful transactions, with error details for failed ones.
`accumulator_root_hash`	`STRING`	Cryptographic hash representing the root of the Merkle accumulator tree after this transaction. Used to verify the complete transaction history up to this point.
`type`	`STRING`	Transaction category indicating the type of ledger operation. Values include ‘block_metadata_transaction’ for consensus metadata and user-initiated transaction types for on-chain contract interactions.
`id`	`STRING`	Unique identifier for the record. String format, specific structure varies by table and blockchain implementation.
`epoch`	`STRING`	Sequential identifier for consensus periods in the blockchain. Integer value representing distinct phases of validator set rotation or network governance cycles.
`round`	`STRING`	Consensus round number within the current epoch when this transaction was proposed. Typically 0 for block metadata transactions in Movement’s consensus protocol.
`previous_block_votes_bitvec`	`JSON`	Bitvector representing which validators voted on the previous block in the consensus round. Typically an empty array for block metadata transactions on Movement chain.
`proposer`	`STRING`	Validator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
`failed_proposer_indices`	`JSON`	List of validator indices that failed to propose blocks in this epoch. Typically empty, populated only when validators miss their assigned block proposal slots.
`sender`	`STRING`	Address that initiated the transaction. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; base58-encoded or base32-encoded for non-EVM chains.
`sequence_number`	`STRING`	Sequential counter tracking the number of transactions sent from an account. Integer value that increments with each transaction from the same sender address.
`max_gas_amount`	`STRING`	Maximum gas units that can be consumed by this transaction. Null for block metadata transactions that do not consume gas.
`gas_unit_price`	`STRING`	Price per unit of gas for this transaction in Movement network’s native token. Null for block metadata transactions that consume no gas.
`expiration_timestamp_secs`	`STRING`	Unix timestamp indicating when the transaction expires if not processed, represented in seconds. Null for block metadata transactions; populated for user-submitted transactions to prevent indefinite pending status.
`signature_type`	`STRING`	Type of cryptographic signature scheme used to authorize the transaction. Null for block metadata transactions that don’t require user signatures.
`signature_public_key`	`STRING`	Public key used to verify the transaction signature, identifying the account that authorized the transaction. Null for block metadata transactions that don’t require user signatures.
`signature`	`STRING`	# Canonical Column Description: signature

Cryptographic signature authorizing the operation. Hex-encoded string format, typically 130-132 characters including 0x prefix for signed transactions and operations. | | payload | JSON | Transaction payload containing the function call, arguments, and type information for user-initiated transactions. Null for block metadata transactions that don’t contain executable payloads. | | payload_function | STRING | Fully qualified name of the function being invoked in the transaction payload (e.g., module::function_name). Null for non-user transactions like block metadata transactions. | | payload_type | STRING | Transaction category indicating the type of operation being performed. Common values include entry_function_payload for smart contract function calls, script_payload for custom scripts, and null for metadata transactions. | | payload_type_arguments | JSON | Structured type arguments for generic functions in the transaction payload, defining specific types when calling parameterized smart contract functions. Null for non-generic function calls or block metadata transactions. | | payload_arguments | JSON | Input parameters passed to the function specified in payload_function, encoded as JSON array. Null for block metadata transactions and other non-user transaction types. |

Sample Data

id	hash	type	epoch	success	version	proposer	timestamp	vm_status	block_height	block_timestamp	event_root_hash	state_change_hash	accumulator_root_hash	failed_proposer_indices	previous_block_votes_bitvec
0xf22137633f30bfa617eff3c1d8fe670ce616be10583b0658571adf8e17d2f13c	0x1ee1ae00f0169bf1619b39d2317a3dce37a056ab70ce8d715c83f0722a13e987	block_metadata_transaction	9002262	true	33508704	0xd1126ce48bd65fb72190dbd9a6eaa65ba973f1e1664ac0cfba4db1d071fd0c36	1761595382862765	Executed successfully	9008565	2025-10-27T20:03:02.862Z	0x4a63b1b218ae1735b939cac99ce5339406183f398599042fa539eecdd9fec5df	0x59e99b193fe0db39fdf77d125cf86624c5ccef19ab3e92499995fbaf73f2e0ac	0xcfcdb883960a036492927805b2e0ec65ca05166f1e3ea26d7be444b95d6d833a	[]	[]
0x0a66d2b88976e8d3b527ecc5649012a76d8a6eb47a24fe7cda2087be2df3ada9	0x1f5561aef917fde55a450a21a78996b8d305bedbc54176fc443d16c0697a2a33	block_metadata_transaction	8996373	true	33489862	0xd1126ce48bd65fb72190dbd9a6eaa65ba973f1e1664ac0cfba4db1d071fd0c36	1761585378857984	Executed successfully	9002676	2025-10-27T17:16:18.857Z	0xa192d614c92ae88eb13b63e1ad48b381b9b8e64fb0816b4dd2a647fbd6376b26	0x788f29354d7c0dfdd78a358338bbd17df17c42df41622715397101c0bbf3fae8	0x6b7a637398ff046e1a59ef119ce70f8798e8902bb008ac1664a5b6a30b792a1f	[]	[]
0x3eb376333661ed25c0003b2e0895f28dac32048cce17d0ca2776e9530fe8f130	0x2a4202376ba07a7400d714aebd1e159223ce3218b10fbac56a424ecdb6bc6f2f	block_metadata_transaction	8973625	true	33416327	0xd1126ce48bd65fb72190dbd9a6eaa65ba973f1e1664ac0cfba4db1d071fd0c36	1761542976848793	Executed successfully	8979928	2025-10-27T05:29:36.848Z	0xf73c70c9a895667627cb93b20dd1b800f1c47db68828b6c97a27c5fc30241e01	0x06df31c1816c9bb5254eae2bc188a498f3a04564ada26f7f1b86c78ff3d6855e	0xc0b554ba41239d60432706c756bf8f4b92b563dd79a267e17cb8e10cc9d725f2	[]	[]

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.movement.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

changes

events

modules

resources

table_items

transactions

​Tables

​blocks

​changes

​events

​modules

​resources

​table_items

​transactions

Tables

blocks

changes

events

modules

resources

table_items

transactions