> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# aptos
> Tables in tt-blockchain.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| data | event\_type | event\_index | block\_height | block\_timestamp | sequence\_number | transaction\_hash | event\_guid\_account\_address | event\_guid\_creation\_number |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------- | ------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ----------------------------- |
| \{"type\_info":\{"account\_address":"0x1","module\_name":"0x6170746f735f636f696e","struct\_name":"0x4170746f73436f696e"}} | 0x1::account::CoinRegisterEvent | 0 | 22619189 | 2023-01-04T11:11:42.664Z | 0 | 0x046a14b1ff11ad3c616316c2ec0e258d3dc220c882043e2a49c7eeedaa776646 | 0x116578de230dc9e12aac985bcf24123c79183b3a83445ce3af751c3973565e0b | 0 |
| \{"type\_info":\{"account\_address":"0x1","module\_name":"0x6170746f735f636f696e","struct\_name":"0x4170746f73436f696e"}} | 0x1::account::CoinRegisterEvent | 0 | 22664308 | 2023-01-04T15:25:09.418Z | 0 | 0x3a330a2059129f7d840ae62e077b160e5f2ccedd6ad324b78b5e8ab2cd9c5420 | 0x6631597141646756108f3ad53c721fbec92abf046d3fb1bdad49c98704e3bc94 | 0 |
| \{"type\_info":\{"account\_address":"0x6de517a18f003625e7fba9b9dc29b310f2e3026bbeb1997b3ada9de1e3cec8d6","module\_name":"0x6f7063","struct\_name":"0x4f5043"}} | 0x1::account::CoinRegisterEvent | 0 | 22626894 | 2023-01-04T11:55:30.816Z | 1 | 0xc0c8d373f2d0b9f84b2820f047cf278f6eb9511e9317e14ea575dba5b8d21a74 | 0x8b9ff0fd706f7e63389c27a01782ea274303d4a301518717d4e3b7c66de09753 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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\>"},\{"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\","&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\","&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\","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\"],"return":\["u64"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"contains","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\","\&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\"],"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"],"return":\["bool","u64"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"is\_empty","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\"],"return":\["bool"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"length","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\"],"return":\["u64"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\["store"]}],"is\_entry":false,"is\_view":false,"name":"new","params":\["u64"],"return":\["0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\"],"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\"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"pop\_back","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\"],"return":\["T0"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"push\_back","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\","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"],"return":\[],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"reserve","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\","u64"],"return":\[],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"shrink\_to\_fit","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\"],"return":\[],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"swap\_remove","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVector\","&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::big\_vector::BigVectorIndex"],"return":\["T0"],"visibility":"public"}] |
| \[] | \[\{"abilities":\["store"],"fields":\[\{"name":"buckets","type":"0x1::table\_with\_length::TableWithLength\>>"},\{"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"],"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"],"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"],"return":\["\&mut T1"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"contains","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\","\&T0"],"return":\["bool"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"destroy\_empty","params":\["0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\"],"return":\[],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"length","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\"],"return":\["u64"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"load\_factor","params":\["&0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\"],"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\"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\["drop"]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"remove","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\","\&T0"],"return":\["T1"],"visibility":"public"},\{"generic\_type\_params":\[\{"constraints":\[]},\{"constraints":\[]}],"is\_entry":false,"is\_view":false,"name":"split","params":\["\&mut 0x146e94218f2cbbb430a06b3c316c0fe815213e5a8106018d7ef5718044172b83::bucket\_table::BucketTable\","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\"},\{"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\"},\{"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\>"},\{"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\"},\{"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\","u64"],"return":\[],"visibility":"public"},\{"generic\_type\_params":\[],"is\_entry":true,"is\_view":false,"name":"add\_tokens","params":\["\&signer","vector\<0x1::string::String>","vector\>","vector\>>","vector\>"],"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\","0x1::string::String","address","0x1::string::String","u64","vector\","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"}] |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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. |
| id | hash | type | epoch | round | sender | payload | success | version | gas\_used | proposer | 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 | state\_checkpoint\_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 | \[] |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.aptos.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***