aptos

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`	The transaction version number of the first transaction included in this block. Sequential identifier in Aptos’ global transaction ordering system, where each block contains one or more consecutive transaction versions.
`last_version`	`STRING`	Transaction version number of the last transaction included in this block. Transaction versions on Aptos are monotonically increasing integers that uniquely identify each transaction across the entire chain history.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.

Sample Data

timestamp	block_hash	block_height	last_version	first_version
2023-01-19T16:14:10.712Z	0x032ac3b0716bbdb4cc6043d35bce25c0ae9bffc7f4caad34a5921f5128552594	26496536	72091521	72091518
2023-01-19T19:03:53.207Z	0x0c5ede217dc52e97fc04580f103aa29180162b8cfe9e85cf5ef0120aa8f4eac4	26525139	72159007	72159005
2023-01-19T11:40:47.986Z	0x1d5848d5fcd41709660d679cd044c6237891024cb06d28675afe1752634ebd1e	26446564	71968900	71968899

Example Query

Query with partition filter

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

changes

State changes from Aptos blockchain transactions including resource writes, module updates, and table modifications. Used for analyzing account state evolution, smart contract activity, and validator performance metrics across blocks.

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`	`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.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`changes`	`JSON`	Complete raw JSON object of the state change as returned by the Aptos node API. Contains the full change record including address, data payload, state key hash, and change type metadata.

Sample Data

data	changes	data_type	block_height	changes_type	changes_index	block_timestamp	changes_address	transaction_hash
{“epoch_interval”:“7200000000”,“height”:“146463376”,“new_block_events”:{“counter”:“146463377”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“3”}}},“update_epoch_interval_events”:{“counter”:“0”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“4”}}}}	{“address”:“0x1”,“data”:{“data”:{“epoch_interval”:“7200000000”,“height”:“146463376”,“new_block_events”:{“counter”:“146463377”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“3”}}},“update_epoch_interval_events”:{“counter”:“0”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“4”}}}},“type”:“0x1::block::BlockResource”},“state_key_hash”:“0x5ddf404c60e96e9485beafcabb95609fed8e38e941a725cae4dcec8296fb32d7”,“type”:“write_resource”}	0x1::block::BlockResource	146463376	write_resource	0	2024-02-16T12:15:10.706Z	0x1	0x1cf4354abe73d8731c8b66c021a6ff5fd86d5bb059c44fc74c6b767c26b191e1
{“validators”:[{“failed_proposals”:“0”,“successful_proposals”:“16”},{“failed_proposals”:“0”,“successful_proposals”:“13”},{“failed_proposals”:“0”,“successful_proposals”:“4”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“29”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“14”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“113”},{“failed_proposals”:“0”,“successful_proposals”:“168”},{“failed_proposals”:“0”,“successful_proposals”:“160”},{“failed_proposals”:“0”,“successful_proposals”:“91”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“5”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“13”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“126”},{“failed_proposals”:“0”,“successful_proposals”:“103”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“5”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“108”},{“failed_proposals”:“0”,“successful_proposals”:“26”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“15”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“130”},{“failed_proposals”:“0”,“successful_proposals”:“138”},{“failed_proposals”:“0”,“successful_proposals”:“109”},{“failed_proposals”:“0”,“successful_proposals”:“105”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“107”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“31”},{“failed_proposals”:“0”,“successful_proposals”:“30”},{“failed_proposals”:“0”,“successful_proposals”:“33”},{“failed_proposals”:“0”,“successful_proposals”:“134”},{“failed_proposals”:“0”,“successful_proposals”:“136”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“124”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“112”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“104”},{“failed_proposals”:“0”,“successful_proposals”:“74”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“123”},{“failed_proposals”:“0”,“successful_proposals”:“126”},{“failed_proposals”:“0”,“successful_proposals”:“101”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“157”},{“failed_proposals”:“0”,“successful_proposals”:“138”},{“failed_proposals”:“0”,“successful_proposals”:“84”},{“failed_proposals”:“0”,“successful_proposals”:“104”},{“failed_proposals”:“0”,“successful_proposals”:“98”},{“failed_proposals”:“0”,“successful_proposals”:“17”},{“failed_proposals”:“0”,“successful_proposals”:“173”},{“failed_proposals”:“0”,“successful_proposals”:“56”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“108”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“154”},{“failed_proposals”:“0”,“successful_proposals”:“27”},{“failed_proposals”:“0”,“successful_proposals”:“198”},{“failed_proposals”:“0”,“successful_proposals”:“47”},{“failed_proposals”:“0”,“successful_proposals”:“113”},{“failed_proposals”:“0”,“successful_proposals”:“129”},{“failed_proposals”:“0”,“successful_proposals”:“124”},{“failed_proposals”:“0”,“successful_proposals”:“121”},{“failed_proposals”:“0”,“successful_proposals”:“114”},{“failed_proposals”:“0”,“successful_proposals”:“132”},{“failed_proposals”:“0”,“successful_proposals”:“150”},{“failed_proposals”:“0”,“successful_proposals”:“25”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“19”},{“failed_proposals”:“0”,“successful_proposals”:“59”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“50”},{“failed_proposals”:“0”,“successful_proposals”:“107”},{“failed_proposals”:“0”,“successful_proposals”:“123”},{“failed_proposals”:“0”,“successful_proposals”:“109”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“130”},{“failed_proposals”:“0”,“successful_proposals”:“99”},{“failed_proposals”:“0”,“successful_proposals”:“158”},{“failed_proposals”:“0”,“successful_proposals”:“28”},{“failed_proposals”:“0”,“successful_proposals”:“98”},{“failed_proposals”:“0”,“successful_proposals”:“141”},{“failed_proposals”:“0”,“successful_proposals”:“119”},{“failed_proposals”:“0”,“successful_proposals”:“32”},{“failed_proposals”:“0”,“successful_proposals”:“34”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“117”},{“failed_proposals”:“0”,“successful_proposals”:“145”},{“failed_proposals”:“0”,“successful_proposals”:“46”},{“failed_proposals”:“0”,“successful_proposals”:“78”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“16”},{“failed_proposals”:“0”,“successful_proposals”:“84”},{“failed_proposals”:“0”,“successful_proposals”:“15”},{“failed_proposals”:“0”,“successful_proposals”:“27”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“86”},{“failed_proposals”:“0”,“successful_proposals”:“28”},{“failed_proposals”:“0”,“successful_proposals”:“35”}]}	{“address”:“0x1”,“data”:{“data”:{“validators”:[{“failed_proposals”:“0”,“successful_proposals”:“16”},{“failed_proposals”:“0”,“successful_proposals”:“13”},{“failed_proposals”:“0”,“successful_proposals”:“4”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“29”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“14”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“113”},{“failed_proposals”:“0”,“successful_proposals”:“168”},{“failed_proposals”:“0”,“successful_proposals”:“160”},{“failed_proposals”:“0”,“successful_proposals”:“91”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“5”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“13”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“126”},{“failed_proposals”:“0”,“successful_proposals”:“103”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“5”},{“failed_proposals”:“0”,“successful_proposals”:“7”},{“failed_proposals”:“0”,“successful_proposals”:“108”},{“failed_proposals”:“0”,“successful_proposals”:“26”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“15”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“130”},{“failed_proposals”:“0”,“successful_proposals”:“138”},{“failed_proposals”:“0”,“successful_proposals”:“109”},{“failed_proposals”:“0”,“successful_proposals”:“105”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“107”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“31”},{“failed_proposals”:“0”,“successful_proposals”:“30”},{“failed_proposals”:“0”,“successful_proposals”:“33”},{“failed_proposals”:“0”,“successful_proposals”:“134”},{“failed_proposals”:“0”,“successful_proposals”:“136”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“124”},{“failed_proposals”:“0”,“successful_proposals”:“9”},{“failed_proposals”:“0”,“successful_proposals”:“6”},{“failed_proposals”:“0”,“successful_proposals”:“112”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“104”},{“failed_proposals”:“0”,“successful_proposals”:“74”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“123”},{“failed_proposals”:“0”,“successful_proposals”:“126”},{“failed_proposals”:“0”,“successful_proposals”:“101”},{“failed_proposals”:“0”,“successful_proposals”:“8”},{“failed_proposals”:“0”,“successful_proposals”:“157”},{“failed_proposals”:“0”,“successful_proposals”:“138”},{“failed_proposals”:“0”,“successful_proposals”:“84”},{“failed_proposals”:“0”,“successful_proposals”:“104”},{“failed_proposals”:“0”,“successful_proposals”:“98”},{“failed_proposals”:“0”,“successful_proposals”:“17”},{“failed_proposals”:“0”,“successful_proposals”:“173”},{“failed_proposals”:“0”,“successful_proposals”:“56”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“108”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“154”},{“failed_proposals”:“0”,“successful_proposals”:“27”},{“failed_proposals”:“0”,“successful_proposals”:“198”},{“failed_proposals”:“0”,“successful_proposals”:“47”},{“failed_proposals”:“0”,“successful_proposals”:“113”},{“failed_proposals”:“0”,“successful_proposals”:“129”},{“failed_proposals”:“0”,“successful_proposals”:“124”},{“failed_proposals”:“0”,“successful_proposals”:“121”},{“failed_proposals”:“0”,“successful_proposals”:“114”},{“failed_proposals”:“0”,“successful_proposals”:“132”},{“failed_proposals”:“0”,“successful_proposals”:“150”},{“failed_proposals”:“0”,“successful_proposals”:“25”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“19”},{“failed_proposals”:“0”,“successful_proposals”:“59”},{“failed_proposals”:“0”,“successful_proposals”:“52”},{“failed_proposals”:“0”,“successful_proposals”:“50”},{“failed_proposals”:“0”,“successful_proposals”:“107”},{“failed_proposals”:“0”,“successful_proposals”:“123”},{“failed_proposals”:“0”,“successful_proposals”:“109”},{“failed_proposals”:“0”,“successful_proposals”:“49”},{“failed_proposals”:“0”,“successful_proposals”:“130”},{“failed_proposals”:“0”,“successful_proposals”:“99”},{“failed_proposals”:“0”,“successful_proposals”:“158”},{“failed_proposals”:“0”,“successful_proposals”:“28”},{“failed_proposals”:“0”,“successful_proposals”:“98”},{“failed_proposals”:“0”,“successful_proposals”:“141”},{“failed_proposals”:“0”,“successful_proposals”:“119”},{“failed_proposals”:“0”,“successful_proposals”:“32”},{“failed_proposals”:“0”,“successful_proposals”:“34”},{“failed_proposals”:“0”,“successful_proposals”:“81”},{“failed_proposals”:“0”,“successful_proposals”:“117”},{“failed_proposals”:“0”,“successful_proposals”:“145”},{“failed_proposals”:“0”,“successful_proposals”:“46”},{“failed_proposals”:“0”,“successful_proposals”:“78”},{“failed_proposals”:“0”,“successful_proposals”:“11”},{“failed_proposals”:“0”,“successful_proposals”:“10”},{“failed_proposals”:“0”,“successful_proposals”:“16”},{“failed_proposals”:“0”,“successful_proposals”:“84”},{“failed_proposals”:“0”,“successful_proposals”:“15”},{“failed_proposals”:“0”,“successful_proposals”:“27”},{“failed_proposals”:“0”,“successful_proposals”:“12”},{“failed_proposals”:“0”,“successful_proposals”:“86”},{“failed_proposals”:“0”,“successful_proposals”:“28”},{“failed_proposals”:“0”,“successful_proposals”:“35”}]},“type”:“0x1::stake::ValidatorPerformance”},“state_key_hash”:“0x8048c954221814b04533a9f0a9946c3a8d472ac62df5accb9f47c097e256e8b6”,“type”:“write_resource”}	0x1::stake::ValidatorPerformance	146450520	write_resource	1	2024-02-16T11:27:10.143Z	0x1	0x65f12d7b5ad53cca29062b857c6677e87831614b4245491650468ca76ae11b0e
{“epoch_interval”:“7200000000”,“height”:“146521748”,“new_block_events”:{“counter”:“146521749”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“3”}}},“update_epoch_interval_events”:{“counter”:“0”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“4”}}}}	{“address”:“0x1”,“data”:{“data”:{“epoch_interval”:“7200000000”,“height”:“146521748”,“new_block_events”:{“counter”:“146521749”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“3”}}},“update_epoch_interval_events”:{“counter”:“0”,“guid”:{“id”:{“addr”:“0x1”,“creation_num”:“4”}}}},“type”:“0x1::block::BlockResource”},“state_key_hash”:“0x5ddf404c60e96e9485beafcabb95609fed8e38e941a725cae4dcec8296fb32d7”,“type”:“write_resource”}	0x1::block::BlockResource	146521748	write_resource	0	2024-02-16T15:56:28.907Z	0x1	0x29a7fe2f44c035fb254232d670987d3e5cd7ae3e9a001255a69458380a7a2481

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.aptos.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`	`STRING`	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 portion of the event’s globally unique identifier (GUID) on Aptos. Hex-encoded, 0x-prefixed 64-character string representing the account that emitted this event.
`event_guid_creation_number`	`INT64`	Account address of the event’s globally unique identifier (GUID), represented as a hex-encoded 0x-prefixed string. Combined with `event_guid_creation_number`, this forms a unique event stream identifier on Aptos.
`data`	`JSON`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.

Sample Data

data	event_type	block_height	block_timestamp	sequence_number	transaction_hash	event_guid_account_address
{“type_info”:{“account_address”:“0x1”,“module_name”:“0x6170746f735f636f696e”,“struct_name”:“0x4170746f73436f696e”}}	0x1::account::CoinRegisterEvent	22619189	2023-01-04T11:11:42.664Z	0	0x046a14b1ff11ad3c616316c2ec0e258d3dc220c882043e2a49c7eeedaa776646	0x116578de230dc9e12aac985bcf24123c79183b3a83445ce3af751c3973565e0b
{“type_info”:{“account_address”:“0x1”,“module_name”:“0x6170746f735f636f696e”,“struct_name”:“0x4170746f73436f696e”}}	0x1::account::CoinRegisterEvent	22664308	2023-01-04T15:25:09.418Z	0	0x3a330a2059129f7d840ae62e077b160e5f2ccedd6ad324b78b5e8ab2cd9c5420	0x6631597141646756108f3ad53c721fbec92abf046d3fb1bdad49c98704e3bc94
{“type_info”:{“account_address”:“0x6de517a18f003625e7fba9b9dc29b310f2e3026bbeb1997b3ada9de1e3cec8d6”,“module_name”:“0x6f7063”,“struct_name”:“0x4f5043”}}	0x1::account::CoinRegisterEvent	22626894	2023-01-04T11:55:30.816Z	1	0xc0c8d373f2d0b9f84b2820f047cf278f6eb9511e9317e14ea575dba5b8d21a74	0x8b9ff0fd706f7e63389c27a01782ea274303d4a301518717d4e3b7c66de09753

Example Query

Query with partition filter

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

modules

Smart contract module deployment and update records on Aptos blockchain. Contains Move bytecode, exposed functions, struct definitions, and metadata for analyzing protocol deployments and on-chain code changes.

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`	`STRING`	Account address that owns and published this Move module on the Aptos blockchain. Hex-encoded, 0x-prefixed 64-character string representing the module’s namespace.
`module_name`	`STRING`	Name of the Move module being deployed or modified on Aptos. Examples include “minting”, “admin”, and “bucket_table”.
`exposed_functions`	`JSON`	JSON array of function signatures exported by this module, including function names, parameters, return types, generic constraints, and visibility modifiers. Empty array indicates a module with no public interfaces.
`friends`	`JSON`	JSON array of module addresses that this module designates as “friends” in the Move programming language. Friend modules have special access privileges to call certain functions defined in this module.
`structs`	`JSON`	JSON array of struct definitions within the module, including field names, types, abilities (storage/copy permissions), and generic type parameters. May be empty for modules containing only functions.
`bytecode`	`STRING`	Compiled Move module bytecode represented as a hex-encoded string. This is the executable code deployed on-chain when a module is published or updated.
`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
[]	[{“abilities”:[“store”],“fields”:[{“name”:“buckets”,“type”:“0x1::table_with_length::TableWithLength<u64, vector<T0>>”},{“name”:“end_index”,“type”:“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”},{“name”:“num_buckets”,“type”:“u64”},{“name”:“bucket_size”,“type”:“u64”}],“generic_type_params”:[{“constraints”:[]}],“is_native”:false,“name”:“BigVector”},{“abilities”:[“copy”,“drop”,“store”],“fields”:[{“name”:“bucket_index”,“type”:“u64”},{“name”:“vec_index”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“BigVectorIndex”}]	0xa11ceb0b050000000e010008020812031aaa0104c4012005e401be0107a203800308a2064006e2061e108007b5010ab508190bce08020cd008f3080dc3110c0ecf1108000001010102010300040401000000050700021b040203010001000600010100000702030100000804050100000906070100000a080700000b090a0100000c0b0c00000d0d0c0100000e0b0c00000f090e01000010060a01000011060701000012070d010400130f0d01040014101101000015120c01000016120c01000017130c01000018100c01000019021101000206151602030002071718020300011f070700020d190c02030002120c1902030402201b0c0203000221171c02030003191e110100141415140b110a110911121117140211001118140c11111119141a140e111b1102060b000109000608010106090002070b000109000608010107090002060b000109000301080101060b0001090001030106080102060b000109000609000101020708010300010b0001090002010302030301070b0001090001090002070b00010900090002070b000109000302030a090002060b02020900090109000106090102070b020209000901090001070901010b020209000901030308010303070b020209000901090009010109010501070a0900030900090002070a0900030a6269675f766563746f72056572726f72117461626c655f776974685f6c656e67746806766563746f7209426967566563746f720e426967566563746f72496e64657806626f72726f770a626f72726f775f6d75740c6275636b65745f696e6465780b6275636b65745f73697a65106275636b6574735f726571756972656408636f6e7461696e730f64656372656d656e745f696e6465780d64657374726f795f656d7074790f696e6372656d656e745f696e64657808696e6465785f6f660869735f656d707479066c656e677468036e6577116e65775f776974685f636170616369747908706f705f6261636b09707573685f6261636b11707573685f6261636b5f6e6f5f67726f7707726573657276650d736872696e6b5f746f5f6669740b737761705f72656d6f7665076275636b6574730f5461626c65576974684c656e67746809656e645f696e6465780b6e756d5f6275636b657473097665635f696e64657810696e76616c69645f617267756d656e74036164640672656d6f7665146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b830000000000000000000000000000000000000000000000000000000000000001030801000000000000000308020000000000000003080300000000000000126170746f733a3a6d657461646174615f7630a0010301000000000000001445494e4445585f4f55545f4f465f424f554e44531d566563746f7220696e646578206973206f7574206f6620626f756e6473020000000000000010454f55545f4f465f43415041434954590e566563746f722069732066756c6c03000000000000001145564543544f525f4e4f545f454d5054592143616e6e6f742064657374726f792061206e6f6e2d656d70747920766563746f720002041a0b0202030a09001c08011d03090301020208031e030011000100000c0b0b0037000a0110011438000b01100214421102010100000c0b0b0036000a0110011438010b01100214431102020100000c160a010a003802230406050a0b00010700270a010a003701141a0b010b0037011419120102030100000c040b0037011402040000000f130a001002140600000000000000002104090600000000000000000c01050b0601000000000000000c010b010c020b001001140b021602050100000c0e0a00380304090b01010b000109020b000b0138040102060100000c290a001002140600000000000000002104200a0010011406000000000000000024040d05110b00010700270a00100114060100000000000000170a000f01150b01060100000000000000170b000f021505280a00100214060100000000000000170b000f021502070100000c100e0038030404050707021116270d0038050b003a00010101380602080100000c1e0a00100214060100000000000000160b012104150a00100114060100000000000000160a000f01150600000000000000000b000f0215051d0a00100214060100000000000000160b000f021502090100001a2c0600000000000000000c020a0038020c040a0006000000000000000038070c030a020a04230425050e0a000e0338080a0121041b0b01010b0001080b02020b02060100000000000000160c020d030a00370114110805090b01010b000109060000000000000000020a0100000c050b00380206000000000000000021020b0100000c0e0a0037021001140a00370114180b00370210021416020c0100000c0f0a00060000000000000000240405050706000000000000000027380906000000000000000006000000000000000012010600000000000000000b003900020d0100000d080b00380a0c020d020b01380b0b02020e0100000c1a0a002e3803200406050b0b000107001116270a0036020a0037011411060a0036000b00370210011438014511020f0100000c280a0037021001140a003703142104180a0036000a0037031440110000000000000000380c0a00370314060100000000000000160a003603150a0036000a00370210011438010b0144110a0036020b00370114110802100100000c1f0a0037021001140a0037031423040a050f0b000107011116270a0036000a00370210011438010b0144110a0036020b00370114110802110100000c1c0a0106000000000000000024041905050a0036000a0037031440110000000000000000380c0a00370314060100000000000000160a003603150b01060100000000000000170c0105000b000102120100000c1c0a003703140a003702110424041905090a00370314060100000000000000170a003603150a0036000a00370314380d4611000000000000000005000b000102130100001d3e0a00380e0c050a0037021001140a011001142104160a0037021002140a01100214210c020518090c020b0204200b00010b01010b05020b0036000a0110011438010c030a032e41110c040a030a01100214380f0c060a030b0544110b030b011002140b040601000000000000001747110b0602000001000101000300010002001103110411051100	big_vector	33308400	write_module	1	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x7facf8ade0655244f312b282066e7219be46f5e0c4e9304c4fa061df1fb2544d	2023-02-16T10:56:50.956Z	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x124c143d55d98d2f9c7aef55140bef592ba56b4618c9d70a23224112ec933971	[{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“borrow”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”],“return”:[“&T0”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“borrow_mut”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”],“return”:[“&mut T0”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“bucket_index”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“u64”],“return”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“bucket_size”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“contains”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“&T0”],“return”:[“bool”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“decrement_index”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“destroy_empty”,“params”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“increment_index”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“index_of”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“&T0”],“return”:[“bool”,“u64”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“is_empty”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[“bool”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“length”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“store”]}],“is_entry”:false,“is_view”:false,“name”:“new”,“params”:[“u64”],“return”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“store”]}],“is_entry”:false,“is_view”:false,“name”:“new_with_capacity”,“params”:[“u64”,“u64”],“return”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“pop_back”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[“T0”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“push_back”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“T0”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“push_back_no_grow”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“T0”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“reserve”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“shrink_to_fit”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“swap_remove”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<T0>”,“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVectorIndex”],“return”:[“T0”],“visibility”:“public”}]
[]	[{“abilities”:[“store”],“fields”:[{“name”:“buckets”,“type”:“0x1::table_with_length::TableWithLength<u64, vector<0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::Entry<T0, T1>>>”},{“name”:“num_buckets”,“type”:“u64”},{“name”:“level”,“type”:“u8”},{“name”:“len”,“type”:“u64”}],“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_native”:false,“name”:“BucketTable”},{“abilities”:[“store”],“fields”:[{“name”:“hash”,“type”:“u64”},{“name”:“key”,“type”:“T0”},{“name”:“value”,“type”:“T1”}],“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_native”:false,“name”:“Entry”}]	0xa11ceb0b050000000e01000a020a180322920104b4011605ca01cc02079604aa0208c006400680073c10bc07ec010aa809210bc909040ccd09fc090dc9130e0ed7130e00000101010201030104000504020000000000060402000000000315040203010001000700010200000008020302030000090204020300000a050600000b0708020000000c0901020000000d0a06020000000e0a06020000000f060902060400100b0c02020000110d0102000000120e0102000000130f0600011c1206010003091504020300021d06060003081a030203000310150c020300030c1b01020300030f011b02030403071d01020300041e1f1101000d110e1407130b13101411141214131414140a13151603070b000209000901090009010002070b0002090009010900010609010107090103020303010302060b0002090009010609000101010b00020900090101060b00020900090102070b00020900090106090001090102070b0002090009010301070b0002090009010203030603070a0b0102090009010303030301090001060900020900090102030a0b01020900090102070b0202090009010900010b0102090009010603070a0b010209000901060b01020900090103030305070a0b010209000901070b01020900090103030304060a0b01020900090103030302060b0202090009010900010b020209000901020b0202030a0b0102090009010b00020900090103070b020209000901090009010603070a0b010209000901030303090102070a0900030a03060b0102090009010b0102090009010303030a0b01020900090103070a0b010209000901030c6275636b65745f7461626c650a6170746f735f68617368056572726f72117461626c655f776974685f6c656e67746806766563746f720b4275636b65745461626c6505456e7472790361646406626f72726f770a626f72726f775f6d75740c6275636b65745f696e64657808636f6e7461696e730d64657374726f795f656d707479066c656e6774680b6c6f61645f666163746f72036e65770672656d6f76650573706c69741073706c69745f6f6e655f6275636b657403786f72076275636b6574730f5461626c65576974684c656e6774680b6e756d5f6275636b657473056c6576656c036c656e0468617368036b65790576616c7565137369705f686173685f66726f6d5f76616c756510696e76616c69645f617267756d656e740b737761705f72656d6f7665146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b8300000000000000000000000000000000000000000000000000000000000000010308040000000000000003080300000000000000030801000000000000000308020000000000000003084b0000000000000003080a00000000000000126170746f733a3a6d657461646174615f7630d7010401000000000000000a454e4f545f464f554e44214b6579206e6f7420666f756e6420696e20746865206275636b6574207461626c6502000000000000000e455a45524f5f43415041434954592b4275636b6574207461626c65206361706163697479206d757374206265206c6172676572207468616e203003000000000000000a454e4f545f454d5054592043616e6e6f742064657374726f79206e6f6e2d656d70747920686173686d617004000000000000000e45414c52454144595f4558495354124b657920616c726561647920657869737473000204140b0202030a0b01020900090116031702180301020319031a09001b09010113001300010000104d0e0138000c050a003700140a003701140a0511030c070a0036020b0738010c040600000000000000000c060a042e41160c080a060a08230433051c0a040a060c032e0b03421637030e01220427052e0b00010b04010700110f270b06060100000000000000160c0605170b040b050b010b02390044160a00370414060100000000000000160a003604150a002e3802070424044a0b003803054c0b0001020101000017370a003700140a003701140e01380011030c060b0036020b0638010c030600000000000000000c050a032e41160c070a050a07230432051a0a030a050c022e0b0242160c040a0437030e0121042b0b03010b043705020b04010b05060100000000000000160c0505150b03010702110f270201000018340a003700140a003701140e01380011030c050b0036020b0538010c020600000000000000000c040a022e41160c060a040a0623042f051a0a020a0443160c030a0337030e012104280b02010b033605020b03010b04060100000000000000160c0405150b02010702110f27030000000f170b020601000000000000000a003101162f190c040a040b0123040f0b040c0305150b040601000000000000000b002f190c030b03020401000019310a003700140a003701140a01380011030c040b0037020b0438040c020600000000000000000c030a0241160c050a030a0523042b05190a020a03421637030a012104260b01010b020108020b03060100000000000000160c0305140b01010b020109020501000006240e00370414060000000000000000210407050a0701110f270600000000000000000c010a010e0037011423041d05130d0036020a013805461600000000000000000b01060100000000000000160c01050c0b003a010101013806020601000001040b003704140207010000010c0a00370414066400000000000000180b003701140705181a02080100001c1b0a0006000000000000000024040505080703110f2738070c010d010600000000000000004016000000000000000038080b01060100000000000000310006000000000000000039010c020d020b000601000000000000001738090b0202090100001e450a003700140a003701140a01380011030c050a0036020b0538010c030600000000000000000c040a032e41160c060a040a0623043c051a0a030a040c022e0b02421637030a012104370b01010b030b04380a3a000c0701010a00370414060100000000000000170b003604150b07020b04060100000000000000160c0405150b00010b01010b03010702110f270a010000010f0a0106000000000000000024040c05050b01060100000000000000170c010a00380305000b0001020b00000020720a003701140c080a080601000000000000000a003700142f110c0c0a401600000000000000000c070a08060100000000000000160a003601150a0a060100000000000000160601000000000000000a003700142f2104260a003700143101160a003600150a0036020b0a38010c090600000000000000000c040a092e41160c050a050c060a040a0523045a05380a090a040c012e0b0142160c020a003700140a003701140b0237061411030a082104550b05060100000000000000170c050a090a040a05471605590b04060100000000000000160c0405330a050a0623046a055f0a0945160c030d070b0344160b06060100000000000000170c06055a0b09010b0036020b080b073808020c00000001040b000b011d020002000100000101000301020100001301130213031304130513061300	bucket_table	33308400	write_module	2	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x1f802787acef16770955a2ef3a0bfc4bfd51c2df098182b791153e30bf736272	2023-02-16T10:56:50.956Z	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x124c143d55d98d2f9c7aef55140bef592ba56b4618c9d70a23224112ec933971	[{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“add”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“T0”,“T1”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“copy”,“drop”]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“borrow”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“T0”],“return”:[“&T1”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“copy”,“drop”]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“borrow_mut”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“T0”],“return”:[“&mut T1”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“contains”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“&T0”],“return”:[“bool”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“destroy_empty”,“params”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“length”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“load_factor”,“params”:[“&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”],“return”:[“u64”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“drop”,“store”]},{“constraints”:[“store”]}],“is_entry”:false,“is_view”:false,“name”:“new”,“params”:[“u64”],“return”:[“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[“drop”]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“remove”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“&T0”],“return”:[“T1”],“visibility”:“public”},{“generic_type_params”:[{“constraints”:[]},{“constraints”:[]}],“is_entry”:false,“is_view”:false,“name”:“split”,“params”:[“&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<T0, T1>”,“u64”],“return”:[],“visibility”:“public”}]
[]	[{“abilities”:[“key”],“fields”:[{“name”:“collection_name”,“type”:“0x1::string::String”},{“name”:“collection_description”,“type”:“0x1::string::String”},{“name”:“collection_maximum”,“type”:“u64”},{“name”:“collection_uri”,“type”:“0x1::string::String”},{“name”:“collection_mutate_config”,“type”:“vector<bool>”},{“name”:“token_name_base”,“type”:“0x1::string::String”},{“name”:“token_counter”,“type”:“u64”},{“name”:“royalty_payee_address”,“type”:“address”},{“name”:“token_description”,“type”:“0x1::string::String”},{“name”:“token_maximum”,“type”:“u64”},{“name”:“token_mutate_config”,“type”:“0x3::token::TokenMutabilityConfig”},{“name”:“royalty_points_den”,“type”:“u64”},{“name”:“royalty_points_num”,“type”:“u64”},{“name”:“tokens”,“type”:“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big_vector::BigVector<0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::minting::TokenAsset>”},{“name”:“added_tokens”,“type”:“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<0x1::string::String, bool>”},{“name”:“public_mint_limit_per_address”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“CollectionConfig”},{“abilities”:[“key”],“fields”:[{“name”:“admin”,“type”:“address”},{“name”:“treasury”,“type”:“address”},{“name”:“signer_cap”,“type”:“0x1::account::SignerCapability”},{“name”:“token_minting_events”,“type”:“0x1::event::EventHandle<0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::minting::NFTMintMintingEvent>”}],“generic_type_params”:[],“is_native”:false,“name”:“NFTMintConfig”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“token_receiver_address”,“type”:“address”},{“name”:“token_id”,“type”:“0x3::token::TokenId”}],“generic_type_params”:[],“is_native”:false,“name”:“NFTMintMintingEvent”},{“abilities”:[“key”],“fields”:[{“name”:“public_minting_addresses”,“type”:“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<address, u64>”},{“name”:“public_mint_price”,“type”:“u64”},{“name”:“public_minting_start_time”,“type”:“u64”},{“name”:“public_minting_end_time”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“PublicMintConfig”},{“abilities”:[“drop”,“store”],“fields”:[{“name”:“token_uri”,“type”:“0x1::string::String”},{“name”:“property_keys”,“type”:“vector<0x1::string::String>”},{“name”:“property_values”,“type”:“vector<vector<u8>>”},{“name”:“property_types”,“type”:“vector<0x1::string::String>”}],“generic_type_params”:[],“is_native”:false,“name”:“TokenAsset”},{“abilities”:[“key”],“fields”:[{“name”:“whitelisted_address”,“type”:“0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket_table::BucketTable<address, u64>”},{“name”:“whitelist_mint_price”,“type”:“u64”},{“name”:“whitelist_minting_start_time”,“type”:“u64”},{“name”:“whitelist_minting_end_time”,“type”:“u64”}],“generic_type_params”:[],“is_native”:false,“name”:“WhitelistMintConfig”}]	0xa11ceb0b050000000c01001c021c480364de0104c2022005e202b603079806860c089e126006fe12ef0110ed14bb040aa8197b0ca31a8c100daf2a3a0000010101020103010401050106010701080109010a020b000c000d000e0800000f080000100600001108000012060000130800081607000b2b07000c2f040100000d31040200000000013606000538040106010b3b07000c5407000b5507000257080000140001000015020300001704030000180003000019050300001a060300001b070300001c080300001d090300001e070300001f0a0b000748000d0004490a0a00014a0e0100094b030a00014c0d1000044d0a0a000d4e12030200000c4f170a01000d5019100200000c511a0301000652071b000153001d010604560a0a000358200301000859210300095a030a000c5b222301000c5c24250100085d2603000b5e2728000b5f292a000b602b030005612c0301060d622e2f0203000b633132000c640a3301040d640a340206040b653503000866370b000a673903010011111216131814161118161c181f1b161c16211c13112211241625182511283801060c010c03060c0a05030005060c0a08060a0a08060a0a0a020a0a080603060c030302060c0302060c050e060c080608060308060a010806050806030a0103030307060c03030303030301030108060107080101050106080a040503070801070805010102050303070b090209000901090009010701010107080003070801060806010a0806010a0a0201080401060b080109000208060102060b09020900090106090002070b08010900090001080a010802010b0b0109000b080d07080008060307080108060c0804080e080c080601080f03060c0503020708060a0202060b080109000301080d02070b0801090006080d0109000207080608060d060c08060806080603080605030308070a08060a0a020a080601080e03060c080e0301080c04060c060c080c0302070b0b01090009000f0101010506080001010703030307080307030306080507080502070b0902090009010900010709010601010708010708010c0c01060a01010807010b08010900010b09020900090106060c080608060806030a011201030303060c010b09020503030303060c0b09020503070801030708030c0c070805010a02010201070a0900076d696e74696e67076163636f756e740a6170746f735f636f696e04636f696e056572726f72056576656e74107265736f757263655f6163636f756e74067369676e657206737472696e670974696d657374616d7006766563746f7205746f6b656e0a6269675f766563746f720c6275636b65745f7461626c6510436f6c6c656374696f6e436f6e6669670d4e46544d696e74436f6e666967134e46544d696e744d696e74696e674576656e74105075626c69634d696e74436f6e6669670a546f6b656e41737365741357686974656c6973744d696e74436f6e66696717616371756972655f7265736f757263655f7369676e6572106164645f746f5f77686974656c69737406537472696e670a6164645f746f6b656e730b696e69745f6d6f64756c65046d696e74086d696e745f6e6674097365745f61646d696e2b7365745f636f6c6c656374696f6e5f636f6e6669675f616e645f6372656174655f636f6c6c656374696f6e1a7365745f6d696e74696e675f74696d655f616e645f70726963650c7365745f74726561737572790d7536345f746f5f737472696e670f636f6c6c656374696f6e5f6e616d6516636f6c6c656374696f6e5f6465736372697074696f6e12636f6c6c656374696f6e5f6d6178696d756d0e636f6c6c656374696f6e5f75726918636f6c6c656374696f6e5f6d75746174655f636f6e6669670f746f6b656e5f6e616d655f626173650d746f6b656e5f636f756e74657215726f79616c74795f70617965655f6164647265737311746f6b656e5f6465736372697074696f6e0d746f6b656e5f6d6178696d756d13746f6b656e5f6d75746174655f636f6e66696715546f6b656e4d75746162696c697479436f6e66696712726f79616c74795f706f696e74735f64656e12726f79616c74795f706f696e74735f6e756d06746f6b656e7309426967566563746f720c61646465645f746f6b656e730b4275636b65745461626c651d7075626c69635f6d696e745f6c696d69745f7065725f616464726573730561646d696e0874726561737572790a7369676e65725f636170105369676e65724361706162696c69747914746f6b656e5f6d696e74696e675f6576656e74730b4576656e7448616e646c6516746f6b656e5f72656365697665725f6164647265737308746f6b656e5f696407546f6b656e4964187075626c69635f6d696e74696e675f616464726573736573117075626c69635f6d696e745f7072696365197075626c69635f6d696e74696e675f73746172745f74696d65177075626c69635f6d696e74696e675f656e645f74696d6509746f6b656e5f7572690d70726f70657274795f6b6579730f70726f70657274795f76616c7565730e70726f70657274795f74797065731377686974656c69737465645f616464726573731477686974656c6973745f6d696e745f70726963651c77686974656c6973745f6d696e74696e675f73746172745f74696d651a77686974656c6973745f6d696e74696e675f656e645f74696d650a616464726573735f6f66117065726d697373696f6e5f64656e6965641d6372656174655f7369676e65725f776974685f6361706162696c6974790b6e6f775f7365636f6e6473096578697374735f617410696e76616c69645f617267756d656e7403616464066c656e67746808636f6e7461696e7309707573685f6261636b1d72657472696576655f7265736f757263655f6163636f756e745f636170106e65775f6576656e745f68616e646c650e426967566563746f72496e6465780b546f6b656e446174614964127265736f757263655f657868617573746564094170746f73436f696e087472616e736665720b617070656e645f75746638106e6f775f6d6963726f7365636f6e64730c6275636b65745f696e6465780b737761705f72656d6f766506617070656e64106372656174655f746f6b656e646174610a6d696e745f746f6b656e0f6469726563745f7472616e736665720a656d69745f6576656e740a626f72726f775f6d75741e6372656174655f746f6b656e5f6d75746162696c6974795f636f6e666967036e6577116372656174655f636f6c6c656374696f6e04757466380772657665727365146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000030308030000000000000003080a0000000000000003080e000000000000000308100000000000000003080c0000000000000003080d0000000000000003080f00000000000000030805000000000000000308060000000000000003080b000000000000000308020000000000000003080700000000000000030808000000000000000308010000000000000003080900000000000000030804000000000000000520146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b8305208aea215de397b372d7f7c144541996960b804654cf8d6abf05c9718adee105020a0203023a200a02020130126170746f733a3a6d657461646174615f7630a6041001000000000000000f454e4f545f415554484f52495a45440002000000000000000d45494e56414c49445f54494d4500030000000000000017454143434f554e545f444f45535f4e4f545f45584953540004000000000000001845564543544f525f4c454e4754485f554e4d4154434845440005000000000000001b45455843454544535f434f4c4c454354494f4e5f4d4158494d554d0006000000000000000e45494e56414c49445f50524943450007000000000000001d45494e56414c49445f5550444154455f41465445525f4d494e54494e4700080000000000000017454d494e54494e475f49535f4e4f545f454e41424c454400090000000000000016454e4f5f454e4f5547485f544f4b454e535f4c454654000a0000000000000018454143434f554e545f4e4f545f57484954454c4953544544000b000000000000002645494e56414c49445f524f59414c54595f4e554d455241544f525f44454e4f4d494e41544f52000c000000000000001b45434f4c4c454354494f4e5f414c52454144595f43524541544544000d000000000000001745434f4e4649475f4e4f545f494e495449414c495a4544000e000000000000001d45414d4f554e545f455843454544535f4d494e54535f414c4c4f574544000f0000000000000012454455504c4943415445445f544f4b454e53001000000000000000284543414e4e4f545f52454d4f56455f4558495354494e475f57484954454c4953545f434f4e464947000002102008062108062203230806240a012508062603270528080629032a08072c032d032e0b08010804300b090208060132030102043305340535080a370b0b01080202020239053a080c0302043c0b090205033d033e033f03040204400806410a0806420a0a02430a0806050204440b0902050345034603470300010001010c1407102a010c010b00110b0a0110001421040b05100b0101070d110c270b011001110d020101040201050f4707102a010c050b00110b0b0510001421040b050e070d110c2707102905041205150705110c2707102a050c060a06100214110e24041f05240b0601070b110c270600000000000000000c040a040e01410d230444052c0e010a04420d140c030a03110f0435053a0b060107001110270a060f030b030a0238000b04060100000000000000160c0405260b060102020104040001030513af0107102a010c0a0b00110b0b0a10001421040b050e070d110c2707102905041d07102b05100414110e240419051c070b110c27052f07102903042105240705110c2707102b03100514110e24042c052f070b110c2707102900043305360705110c270e01410b0e0241142104430e0241140e034115210c050545090c050b05044e0e0341150e044114210c060550090c060b0604530556070f11102707102a000c080e01410b0a0810063801160a08100714250467080c07056d0a08100714060000000000000000210c070b07047005750b080107071110270600000000000000000c090a090e01410b2304ac01057d0e010a09420b0c0b0a0810080a0b380220048801058f010b0b010b080107061110270a080f060a0b140e020a094214140e030a094215140e040a09421414120438030a080f080b0b140838040b09060100000000000000160c0905770b080102030000001b0d0a00071111150c010a00071107110b010b00380512012d01020400000200011e920107102a010c0707102a000c040a04100638010a0226040d05160b07010b00010b0401070e1117270a000a071009140b010a021838060a04100a140c0d0d0d071211190a071001110d0c090a0206000000000000000024048b01052e111a0a0410063801190c060a0410060b0638070c030a040f060e0338080c0a0a0d0c050a04100b14110a0c080d050b08111d0e090a04100c140b050a04100d140a04100e140e0a100f140a041010140a041011140a041012140a041013140e0a1014140e0a1015140e0a101614111e0c0b0e090b0b060100000000000000111f0c0c0e090a000a0c06010000000000000011200a04100b14060100000000000000160a040f0b150a070f170a00110b0b0c120238090b02060100000000000000170c0205290b07010b00010b04010205010404000103052dd901071029000407071029030c020509090c020b02040c05110b00010705110c2707102b000c0607102a030c0c110e0c0a090c0807102905043407102b050c0f0a0a0a0f10041424042e0a0a0b0f100214230c0305320b0f01090c030b030c080a0a0a0c1005142404410b0a0a0c101814230c040543090c040b040c070a080b071e044a05530b0c010b00010b0601070c110c270a06100638010c0e0a010b0e25045c05650b0c010b00010b0601070e1110270a0c1019140c0b0a00110b0c050b0804a1010b0c010b060107102a050c100a1010030e05380a047b0582010b10010b00010701110c270a100f030b05380b0c0d0a0d140a0126048d010596010b10010b0d010b000107021110270a0d140a01170b0d150b10101a140c0b05d4010a06101b140600000000000000002204d0010a0c101c0e05380a2004b5010a0c0f1c0a050b06101b14380005b7010b06010b0c0f1c0b05380b0c090a010a09142504c20105c9010b00010b090107021110270a09140a01170b091505d4010b0c010b06010b000b0b0b0111040206010401010c1507102a010c020b00110b0a0210001421040b05100b0201070d110c270b010b020f0015020701040101306307102a010c100b00110b0b1010001421040b050e070d110c270e0541100603000000000000002104190e0a4110060500000000000000210c0e051b090c0e0b0e041e0521070f1110270a0b06000000000000000024042a0a0c0a0b230c0f052c090c0f0b0f042f0532070911102707102900200437053a0704110c2707102a010c110a111001110d0c120e120a010a020a030a040a050b060601000000000000000b070b080b090e0a11230b0b0b0c068000000000000000380c068000000000000000380d0b0d12002d000b111001110d0c130e130b010b020b040b030b051126020801040301030536a90107102a010c130b00110b0a1310001421040b05100b1301070d110c27110e0c140a010600000000000000002404460a010b1424041f0a010a02230c070521090c070b07042405290b1301070a1110270a040a022404320a040a05230c0c0534090c0c0b0c0437053c0b1301070a1110270a060a0326044105460b130107081110270710290504630a0106000000000000000024044e05530b1301070311102707102a050c180b010a180f04150b020a180f02150b030b180f1a15057d0a0106000000000000000022047d0a131001110d0c160e160c11068000000000000000380e0c0d0b010c0e0b020c0f0b030c100b110b0d0b100b0e0b0f12052d05071029030492010b130107102a030c150b040a150f05150b050a150f18150b060b150f191505a8010b131001110d0c170e170c0b060800000000000000380e0c120b040c080b050c090b060c0a0b0b0b120b0a0b080b0912032d030209010401010c1507102a010c020b00110b0a0210001421040b05100b0201070d110c270b010b020f0915020a00000037200a000600000000000000002104070713112702403800000000000000000c010a0006000000000000000022041b050e0d010630000000000000000a00060a0000000000000019163344380b00060a000000000000001a0c0005090d01380f0b01112702010001020503050005020302000d0002000e01010005000600000008000904000007000b000c000a0401040204030103030303010501000f030000	minting	33308400	write_module	0	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x30e0cde048a58e56b3f31516c7bee5ac9535059f474f82944c142c5f8afddcaa	2023-02-16T10:56:50.956Z	0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83	0x124c143d55d98d2f9c7aef55140bef592ba56b4618c9d70a23224112ec933971	[{“generic_type_params”:[],“is_entry”:false,“is_view”:false,“name”:“acquire_resource_signer”,“params”:[“&signer”],“return”:[“signer”],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“add_to_whitelist”,“params”:[“&signer”,“vector<address>”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“add_tokens”,“params”:[“&signer”,“vector<0x1::string::String>”,“vector<vector<0x1::string::String>>”,“vector<vector<vector<u8>>>”,“vector<vector<0x1::string::String>>”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“mint_nft”,“params”:[“&signer”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_admin”,“params”:[“&signer”,“address”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_collection_config_and_create_collection”,“params”:[“&signer”,“0x1::string::String”,“0x1::string::String”,“u64”,“0x1::string::String”,“vector<bool>”,“0x1::string::String”,“address”,“0x1::string::String”,“u64”,“vector<bool>”,“u64”,“u64”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_minting_time_and_price”,“params”:[“&signer”,“u64”,“u64”,“u64”,“u64”,“u64”,“u64”],“return”:[],“visibility”:“public”},{“generic_type_params”:[],“is_entry”:true,“is_view”:false,“name”:“set_treasury”,“params”:[“&signer”,“address”],“return”:[],“visibility”:“public”}]

Example Query

Query with partition filter

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

resources

State change history for Aptos Move resources, capturing writes, deletions, and modifications to on-chain resource data at each transaction. Used for tracking contract state evolution and reconstructing historical account balances or protocol parameters.

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`	Aptos account address that owns or stores the resource represented in this state change. Hex-encoded, 0x-prefixed 64-character string uniquely identifying the on-chain account.
`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”:{“deployer”:“0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b”,“signer_cap”:{“account”:“0x5bc11445584a763c1fa7ed39081f1b920954da14e04b32440cba863d03e19625”}},“type”:“0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b::deployer::DeployingSignerCapability”}	0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b::deployer::DeployingSignerCapability	1094358	write_resource	21	0xad42354cd66d21f6b712d3da2e470efd37b86ceb203096b3e5b62655dad5c611	2022-10-19T00:49:48.492Z	0x5bc11445584a763c1fa7ed39081f1b920954da14e04b32440cba863d03e19625	0x5bc11445584a763c1fa7ed39081f1b920954da14e04b32440cba863d03e19625	0x7e70995643dd63d5193bdbcee8458a0a6900ec0f899fa3393ad607fa3594ca47
{“data”:{“deployer”:“0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b”,“signer_cap”:{“account”:“0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4f”}},“type”:“0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b::deployer::DeployingSignerCapability”}	0x108bc32f7de18a5f6e1e7d6ee7aff9f5fc858d0d87ac0da94dd8d2a5d267d6b::deployer::DeployingSignerCapability	1094430	write_resource	22	0xa9237f148c72dc27fad754315c1c6be7258a9a324b053f273ff9e0b62695a1ff	2022-10-19T00:50:06.116Z	0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4f	0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4f	0x3aab7951998b1d03f7aa9cb29504307acb3644984cdb52e83b8066f7372edf3d
{“data”:{“buy_events”:{“counter”:“232”,“guid”:{“id”:{“addr”:“0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4”,“creation_num”:“6”}}},“delist_events”:{“counter”:“45”,“guid”:{“id”:{“addr”:“0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4”,“creation_num”:“5”}}},“list_events”:{“counter”:“568”,“guid”:{“id”:{“addr”:“0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4”,“creation_num”:“4”}}}},“type”:“0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4::Events::Events”}	0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4::Events::Events	1433957	write_resource	1	0x4c41afe62d089b7d737bd2b2d5a6e455e5c8c6b6d9acf35250802542c7be2d9a	2022-10-19T23:49:48.822Z	0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4	0x143f6a7a07c76eae1fc9ea030dbd9be3c2d46e538c7ad61fe64529218ff44bc4	0x4de29bab0c6ac6dd2b306de397d0d26a32b04a2b4203920d30374fe60140f298

Example Query

Query with partition filter

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

table_items

State changes to Aptos Move table storage structures, tracking key-value updates within table handles across transactions. Used for analyzing on-chain data structure modifications like token balances, NFT metadata, and protocol state variables.

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`	Unique identifier for an Aptos table resource where this key-value pair is stored. Hex-encoded, 0x-prefixed 64-character string that remains constant for the same table across multiple updates.
`key`	`STRING`	Unique identifier for an item within an Aptos table resource, represented as a hex-encoded hash. Used to look up specific entries in on-chain data structures like token ownership records or protocol state mappings.
`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	0x839dd05854f174010000000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	80582651	write_table_item	2	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2023-08-14T00:29:10.410Z	0x32dd44bdac74d318b91245516627020d47db8ab788506c77d53fbeac0a8d7f98
0x0619dc29a0aac8fa146714058e8dd6d2d0f3bdf5f6331907bf91f3acd81e6935	null	0xd2f432555cfa74010000000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	80819370	write_table_item	2	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2023-08-14T15:43:36.267Z	0xc46f6aa3d09cb79e42dbd373b8d4738c361c4ffbb93ee577cf3e4a58a624596a
0x0619dc29a0aac8fa146714058e8dd6d2d0f3bdf5f6331907bf91f3acd81e6935	null	0x8cf83071e9f374010000000000000000	0x1b854694ae746cdbd8d44186ca4929b2b337df21d1c74633be19b2710552fdca	80650343	write_table_item	2	0x6e4b28d40f98a106a65163530924c0dcb40c1349d3aa915d108b4d6cfc1ddb19	2023-08-14T04:47:09.856Z	0xdb29ed6dac87b9b44e64bf2ac0541cab7ea6064de7bd17adfa836019ead7541d

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.aptos.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`	Unique transaction identifier represented as a hex-encoded, 0x-prefixed 64-character hash. This hash uniquely identifies each transaction on the Aptos blockchain and can be used for lookups and verification.
`timestamp`	`STRING`	Timestamp when the block was produced. UTC timezone.
`accumulator_root_hash`	`STRING`	Merkle accumulator root hash representing the cryptographic state of all transactions up to this point in the Aptos ledger. Used for verifying transaction inclusion and blockchain state consistency.
`epoch`	`STRING`	Sequential identifier for consensus periods in the blockchain. Integer value representing distinct phases of validator set rotation or network governance cycles.
`event_root_hash`	`STRING`	Merkle root hash of all events emitted by this transaction. Hex-encoded 0x-prefixed 64-character string representing the cryptographic summary of transaction events.
`expiration_timestamp_secs`	`STRING`	Unix timestamp in seconds when the transaction expires and can no longer be included in a block. Transactions not processed before this time are discarded by validators.
`failed_proposer_indices`	`ARRAY<INT64>`	Indices of validators who failed to propose blocks during consensus in this epoch. Array is typically empty for successful transactions; populated during block metadata transactions to track validator performance.
`gas_unit_price`	`STRING`	Price per unit of gas paid by the transaction sender, denominated in Octas (smallest Aptos unit). Typically set to 100 or 120 Octas as shown in samples.
`gas_used`	`STRING`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`id`	`STRING`	Unique identifier for the record. String format, specific structure varies by table and blockchain implementation.
`max_gas_amount`	`STRING`	Maximum amount of gas units the transaction sender is willing to pay for execution. Commonly set to 200000 for most user transactions.
`previous_block_votes_bitvec`	`ARRAY<INT64>`	Bitvector indicating which validators voted on the previous block in the consensus protocol. Empty array for user-initiated transactions; populated for validator-related block metadata.
`proposer`	`STRING`	Validator address responsible for producing the block. Hex-encoded string, typically 66 characters including 0x prefix.
`round`	`STRING`	Consensus round number during which this transaction was proposed for inclusion. Null for most user transactions as this field is primarily populated for block metadata and validator-related transactions.
`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.
`state_change_hash`	`STRING`	Cryptographic hash representing the state changes produced by this transaction. Null for some transaction types that do not modify chain state.
`state_checkpoint_hash`	`STRING`	Merkle hash representing the state checkpoint after this transaction’s execution. Null for most transactions; populated only at specific checkpointing intervals in the blockchain.
`success`	`BOOL`	Boolean indicator of whether the operation completed successfully without errors.
`type`	`STRING`	Transaction category indicating the origin and execution method of the transaction, such as user-initiated transactions, system transactions, or block metadata. Common values include ‘user_transaction’ for standard user-submitted operations.
`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.
`vm_status`	`STRING`	Execution outcome message returned by the Aptos virtual machine after processing the transaction. Contains “Executed successfully” for successful transactions or specific error messages for failures.
`signature_type`	`STRING`	Ed25519 or multi-signature scheme identifier used to verify the transaction signature. Typically “ed25519_signature” for standard single-key transactions on Aptos.
`signature_public_key`	`STRING`	Public key used to verify the transaction signature. Hex-encoded 64-character string representing the Ed25519 public key of the sender account.
`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 | Full transaction payload as JSON, containing the type, function identifier, arguments, and type arguments for the transaction execution. | | payload_function | STRING | Fully qualified function identifier being called in an entry function transaction. Formatted as address::module::function_name where address is 0x-prefixed, typically representing Move smart contract methods. | | payload_type | STRING | Type of transaction payload that defines the operation being executed. Common values include entry_function_payload for function calls and script_payload for custom scripts. | | payload_type_arguments | JSON | Type arguments passed to generic functions in the transaction payload, such as token contract addresses for swap operations. Empty array for non-generic functions; typically contains one or more hex-encoded Aptos resource identifiers when present. | | payload_arguments | JSON | Arguments passed to the smart contract function being called in this transaction. Contains the actual parameter values as a JSON array, which can be primitive types (numbers, strings, addresses) or complex objects depending on the function signature. |

Sample Data

hash	type	sender	payload	success	version	gas_used	signature	timestamp	vm_status	block_height	payload_type	gas_unit_price	max_gas_amount	signature_type	block_timestamp	event_root_hash	sequence_number	payload_function	payload_arguments	state_change_hash	signature_public_key	accumulator_root_hash	payload_type_arguments	failed_proposer_indices	expiration_timestamp_secs	previous_block_votes_bitvec
0x7b16544dc80d8d51dd95b9b517319bc60d108ee34b554585a6f4a174a0d7dab9	user_transaction	0x74ac19dae71b16aa74c8380d66f3bfc1975486bb3db61afe5e2d3538c9b5fc96	{“arguments”:[“231709203000000”],“function”:“0xc0188ad3f42e66b5bd3596e642b8f72749b67d84e6349ce325b27117a9406bdf::oracle::set_underlying_price_type_args”,“type”:“entry_function_payload”,“type_arguments”:[“0xd0b4efb4be7c3508d9a26a9b5405cf9f860d0b9e5fe2f498b90e68b8d2cedd3e::aptos_launch_token::AptosLaunchToken”]}	true	180773319	7	0x71c03fa30f899e0d2f6c748701c12e05edfe1680144b61964d741d82c9cdcfdfae83a34bc08a25a78110004d9af024ac2e4f92af1ddd9af22581dcf43a4bb50c	1689277585654543	Executed successfully	69031466	entry_function_payload	100	200000	ed25519_signature	2023-07-13T19:46:25.654Z	0x239dfa858f0ffd30b70e9b5600ce3b6f2fbeb58a692d31c624847fcd4f8a0ad9	28802	0xc0188ad3f42e66b5bd3596e642b8f72749b67d84e6349ce325b27117a9406bdf::oracle::set_underlying_price_type_args	[“231709203000000”]	0x2af3ed58b84b2ed9955dabf08af35ed9c665fdf7f96d2e5ed775673d1b726f3e	0x59d7f989a443c555057375151e0f9b7cc58d243e26e37446668ffd78d8e3d8ca	0xa3110bf023df7445216351c351bf46ac726bd4a8bb305ea6745c5bb0e42dd134	[“0xd0b4efb4be7c3508d9a26a9b5405cf9f860d0b9e5fe2f498b90e68b8d2cedd3e::aptos_launch_token::AptosLaunchToken”]	[]	1689283585	[]
0x3f0e0057ab82a9597b0d472b5f4ccfa49b34d496ed7dbc110b77c436ae09da31	user_transaction	0x8f572e334b2f8db2cb95be76962c71a19bbb3565e5b83e27b75ade87011a913b	{“arguments”:[“0x01001bd0445cc80000000000112417780000155c5d0064afd4fb03c602027d02”,“0x2144a857b9727e1f3174df7916baa8f3ea746a958cd73a24e50e7e94f2ed57e8e16904fe67cb82c9387d7434d3dc297871dcbc8d3d51cb355399f9016aab9f40”,“0xef52cb0940b411ea8c1f7119ecb96f4d0a81a3aa”,true],“function”:“0xc0de4c979914cc543a8b57829b4eca3829a4362791ccaf153d7c8dafc9d5dd37::MesonSwap::executeSwap”,“type”:“entry_function_payload”,“type_arguments”:[“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT”]}	true	180373683	45	0xe1d625b93f989ac930efd285c7d6d03d7bedef1993e7cc61a6053d7adc60bda87a0c75e725d1df23e35be796c35de7309315aee9b6a562f6689612d1c73a0907	1689239575261663	Executed successfully	68889830	entry_function_payload	100	200000	ed25519_signature	2023-07-13T09:12:55.261Z	0x414343554d554c41544f525f504c414345484f4c4445525f4841534800000000	37986	0xc0de4c979914cc543a8b57829b4eca3829a4362791ccaf153d7c8dafc9d5dd37::MesonSwap::executeSwap	[“0x01001bd0445cc80000000000112417780000155c5d0064afd4fb03c602027d02”,“0x2144a857b9727e1f3174df7916baa8f3ea746a958cd73a24e50e7e94f2ed57e8e16904fe67cb82c9387d7434d3dc297871dcbc8d3d51cb355399f9016aab9f40”,“0xef52cb0940b411ea8c1f7119ecb96f4d0a81a3aa”,true]	0x4795351de8e307e7af3b281e168f345bfb6c58d635087ddf89b5b6e81deed5fc	0xfa97eed9d3e043ed3e6d0a68d5222646f1fa1d444e1de59573b47c2680b2b26f	0x0785c28579abcb0c5e18ccda99041825150db4b5795b653f0ebddea8aac0a9b2	[“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT”]	[]	1689239594	[]
0xd7fa8c1bc603a7b621b5ddd4a6261d60ed7ed8b3eb110c3c27a2524251d9a375	user_transaction	0xc20ea5a196c81d8d7aff814aa37f8a5823acffbc4193efd3b2aafc9ef2803255	{“arguments”:[“0x858ee8ea878585a541945051ae13f367a8b742da690e55d7a04c5efd9dbd9e08”,“12”,“1689309149”,“0x57456f91460aebb6791e140d2e0eedd8da84d87e680c18db3d4709ffb9e49ef90b50bd508b6664a1b383f85d58dadcfcc62438884fef713406e188c142bde75e0030f54fea3449b33ad3719c7cee3c31de7d29c7dbe34983733790b5bbdbe1b04a0645d457270756ef9d95201e6663c6f0b4836ea4184a7df7211615e64a3ad69401”],“function”:“0xc2846ea05319c339b3b52186ceae40b43d4e9cf6c7350336c3eb0b351d9394eb::oracle::mso_propose”,“type”:“entry_function_payload”,“type_arguments”:[]}	true	180899392	939	0x90ab4633137c1983c33561280358abe97cd6e2d8d192a0a5b317118b853c5b7639eec4e9d80b4d1eab3db72565d5eb82917d27ede1a448a89a7543744575ca0b	1689287554134936	Executed successfully	69072218	entry_function_payload	120	200000	ed25519_signature	2023-07-13T22:32:34.134Z	0x3886f91dc10a48586768e85250000f81dc5bef3bcae20390cece7f213201c30e	1059469	0xc2846ea05319c339b3b52186ceae40b43d4e9cf6c7350336c3eb0b351d9394eb::oracle::mso_propose	[“0x858ee8ea878585a541945051ae13f367a8b742da690e55d7a04c5efd9dbd9e08”,“12”,“1689309149”,“0x57456f91460aebb6791e140d2e0eedd8da84d87e680c18db3d4709ffb9e49ef90b50bd508b6664a1b383f85d58dadcfcc62438884fef713406e188c142bde75e0030f54fea3449b33ad3719c7cee3c31de7d29c7dbe34983733790b5bbdbe1b04a0645d457270756ef9d95201e6663c6f0b4836ea4184a7df7211615e64a3ad69401”]	0x8c4e8940b3d34a92a6fb244d4cabaf52926af3d4dc541c2f19ba8e2ae8b4ca9d	0xf22c5aeb53fc98ec8196d88df86df952a616108eabdbb993f14805660a8b1831	0x839e9cd9ec2265c9de04bddffad615ad5cd96269e3cc512e4e903bf112f8d1a0	[]	[]	1689288754	[]

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

changes

events

modules

resources

table_items

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​changes

​events

​modules

​resources

​table_items

​transactions

Tables

blocks

changes

events

modules

resources

table_items

transactions