| Feature | Ethereum | Aptos |
|---|---|---|
| Account Addresses | 160-bit | 256-bit |
| Storage Mindset | Contract-based storage | Account centric mindset for code and data |
| Caller ID | msg.sender | &signer reference |
| Smart Contracts | Solidity, EVM | Move, MoveVM |
| Benefits | Mature, wide adoption | Scalability, low latency, predictable fees |
| Transaction Fees | Variable, can be high | Lower and more predictable |
| Sponsored Transactions | Requires third-party services or EIP-7702 wallet support (2025+) | Natively supported via fee payer field. Geomi Gas Stations provides production infrastructure |
| Account Structure | Balance in a single field, uses nonce | Modules and resources, uses sequence number |
| Data Storage | Patricia Merkle Trees | Global storage with resources and modules |
| Upgradeability | Proxy patterns | Direct module upgrades |
| Safety & Security | Vulnerable to attacks like reentrancy | Mitigates common vulnerabilities |
| Dispatch Type | Dynamic dispatch | Static dispatch |
| Frontend SDK | Ethers.js library | Aptos Typescript SDK |
| NFT Standards | ERC-721, ERC-1155 | Digital Asset |
| FT Standard | ERC-20, factory pattern | See Fungible Asset, copy paste in your module: use aptos_framework::fungible_asset... |
| Example Code | ERC-20 (new contract per deploy) | Fungible Asset (single reusable module) |
| Solidity | Move (Aptos) | |
|---|---|---|
| Token Structure | Each token is its own contract. | Every token is a typed FungibleAsset instantiation that reuses the same published module. |
| Token Standard | Must conform to standards like ERC-20; implementations can vary per deploy. | Uniform interface and implementation enforced by the shared module; new tokens simply register a new type rather than redeploying code. |
| Balance Storage | Balances stored in contract using a mapping structure. | Resource-Oriented Balance: balances live in an extensible object owned by the user's account. |
| Transfer Mechanism | Tokens can be transferred without receiver's explicit permission. | Transfers can skip receiver permission, but only when the FA explicitly enables primary-store auto creation (visible in the token's creation code). |
| EVM (Ethereum Virtual Machine) | Move VM (Move Virtual Machine) | |
|---|---|---|
| Data Storage | Data is stored in the smart contract's storage space. | Data is stored across smart contracts, user accounts, and objects. |
| Parallelization | Parallel execution is limited due to shared storage space. | More parallel execution enabled due to flexible split storage design. |
| VM and Language Integration | Separate layers for EVM and smart contract languages (e.g., Solidity). | Seamless integration between VM layer and Move language, with native functions written in Rust executable in Move. |
| Critical Network Operations | Implementation of network operations can be complex and less direct. | Critical operations like validator set management natively implemented in Move, allowing for direct execution. |
| Function Calling | Dynamic dispatch allows for arbitrary smart contract calls. | Static dispatch aligns with a focus on security and predictable behavior. |
| Type Safety | Contract types provide a level of type safety. | Module structs and generics in Move offer robust type safety. |
| Transaction Safety | Uses nonces for transaction ordering and safety. | Uses sequence numbers for transaction ordering and safety. |
| Authenticated Storage | Yes, with smart contract storage. | Yes, leveraging Move’s resource model. |
| Object Accessibility | Objects are not globally accessible; bound to smart contract scope. | Guaranteed global accessibility of objects. |
| Key type | Prefix byte |
|---|---|
| Ed25519 generalized scheme | 0x00 |
| Secp256k1Ecdsa generalized scheme | 0x01 |
| Secp256r1Ecdsa WebAuthn scheme | 0x02 |
| Keyless | 0x03 |
| Limit Type | Current Per Transaction Limit |
|---|---|
| transaction | 64KB |
| governance transaction | 1MB |
| a single write op | 1MB |
| all write ops combined | 10MB |
| number of write ops | 8192 |
| a single event | 1MB |
| all events combined | 10MB |
| Token Name | Token Symbol | Token Address | Source of Address |
|---|---|---|---|
| Tether USD | USDt | 0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b | Aptos Foundation |
| USDC | USDC | 0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b | Circle |
| Ondo US Dollar Yield | USDY | 0xcfea864b32833f157f042618bd845145256b1bf4c0da34a7013b76e42daa53cc::usdy::USDY | Ondo Finance |
| Index Name | Indexed Columns |
|---|---|
| user_transactions_pkey | version |
| user_transactions_sender_sequence_number_key | sender, sequence_number |
| ut_epoch_index | epoch |
| ut_insat_index | inserted_at |
| ut_sender_seq_index | sender, sequence_number |
| user_transactions_contract_info_index | entry_function_contract_address, entry_function_module_name, entry_function_function_name |
| Index Name | Indexed Columns |
|---|---|
| block_metadata_transactions_block_height_key | block_height |
| block_metadata_transactions_pkey | version |
| bmt_insat_index | inserted_at |
| Index Name | Indexed Columns |
|---|---|
| account_transactions_pkey | account_address, transaction_version |
| at_insat_index | inserted_at |
| at_version_index | transaction_version DESC |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| delegated_staking_activities | Join | Use the Hasura explorer to see these sub-fields. | |
| fungible_asset_activities | Join | References fungible_asset_activities. | |
| token_activities | Join | Use the Hasura explorer to see these sub-fields. | |
| token_activities_aggregate | Join | Use the Hasura explorer to see these sub-fields. | |
| token_activities_v2 | Join | References token_activities_v2. | |
| token_activities_v2_aggregate | Join | References token_activities_v2. | |
| account_address | String! | Yes | This is an Aptos account address. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" |
| transaction_version | bigint! | Yes | Blockchain version of the transaction. Ex. 10000000 |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| chain_id | int | Yes | The unique identifier for the chain you are accessing. Ex. 1 (for Mainnet), 2 (for Testnet), etc. |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| last_success_version | bigint | Yes | The version number of the last successful processor run. Ex. 5000000 |
| last_transaction_timestamp | String | Timestamp of the last processed transaction. Ex. "2024-04-17T02:14:25.68771" | |
| last_updated | String | Timestamp of the last update to this processor's status. Ex. "2024-04-17T02:14:25.68771" | |
| processor | String | Yes | Name of the processor. Ex. "transaction_processor" |
| Index Name | Indexed Columns |
|---|---|
| ta2_from_type_index | from_address, type |
| ta2_insat_index | inserted_at |
| ta2_owner_type_index | event_account_address, type |
| ta2_tid_index | token_data_id |
| ta2_to_type_index | to_address, type |
| token_activities_v2_pkey | transaction_version, event_index |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| aptos_names_from | Join | Use the Hasura explorer to see these sub-fields. | |
| aptos_names_from_aggregate | Join | Use the Hasura explorer to see these sub-fields. | |
| aptos_names_to | Join | Use the Hasura explorer to see these sub-fields. | |
| aptos_names_to_aggregate | Join | Use the Hasura explorer to see these sub-fields. | |
| current_token_data | Join | Use the Hasura explorer to see these sub-fields. | |
| after_value | String | The value of a token property after the transaction. Ex. "100" | |
| before_value | String | The value of a token property before the transaction. Ex. "50" | |
| entry_function_id_str | String | The identifier of the function called in this transaction. Ex. "0x1::aptos_account::transfer" | |
| event_account_address | String | This is an Aptos account address related to the event. This address must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| event_index | bigint | Yes | Index of the event within the transaction. Ex. 1 |
| from_address | String | This is an Aptos account address from which the token was sent. This address must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| is_fungible_v2 | Boolean | Indicates whether the token is fungible. Soon to be deprecated. Ex. False for NFTs. | |
| property_version_v1 | bigint | The version of the token's properties under schema version 1. This field is only for token standard v1. It is always 0 for v2. Ex. 0 | |
| to_address | String | This is an Aptos account address to which the token was sent. This address must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| token_amount | bigint | The amount of the token transferred in this activity. Ex. 3 | |
| token_data_id | String | Unique identifier for this particular token's data. For token standard v1, this is derived from a combination of creator_address, collection_name, and token_name. This ID must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" | |
| transaction_timestamp | String | Timestamp when the transaction occurred. Ex. "2024-04-17T02:14:25.68771" | |
| transaction_version | bigint | Yes | Blockchain version of the transaction. Ex. 10000000 |
| type | String | Type of transfer - like "deposit" or "withdrawal". Ex. "0x3::token::DepositEvent" |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| animation_optimizer_retry_count | Int | Number of retries to optimize animation. Ex. 3 | |
| asset_uri | String | Yes | URI of the asset. Ex. "https://example.com/nft/123" |
| cdn_animation_uri | String | Content Delivery Network URI for animation. Ex. "https://cdn.example.com/animations/123" | |
| cdn_image_uri | String | Content Delivery Network URI for image. Ex. "https://cdn.example.com/images/123" | |
| cdn_json_uri | String | Content Delivery Network URI for JSON metadata. Ex. "https://cdn.example.com/metadata/123.json" | |
| raw_animation_uri | String | Original URI for animation before CDN optimization. Ex. "https://example.com/raw/animations/123" | |
| raw_image_uri | String | Original URI for image before CDN optimization. Ex. "https://example.com/raw/images/123" |
| Index Name | Indexed Columns |
|---|---|
| nft_inserted_at | inserted_at |
| nft_raw_animation_uri | raw_animation_uri |
| nft_raw_image_uri | raw_image_uri |
| parsed_asset_uris_pkey | asset_uri |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| composed_nfts_aggregate | Join | Aggregate information about the composed NFTs, such as count or other statistics. | |
| current_token_data | Join | Detailed information about the token's current data; structure is defined in a related table. | |
| amount | bigint | The amount of the token owned. Example: 1 for an NFT. | |
| composed_nfts | Array | An array containing the IDs of NFTs that compose this token, if applicable. | |
| is_fungible_v2 | Boolean | Indicates whether the token is fungible. Example: true or null | |
| is_soulbound_v2 | Boolean | Indicates whether the token is soulbound (non-transferable once owned). Example: true or null | |
| last_transaction_timestamp | String | Timestamp of the last transaction involving the token. Example: "2024-04-17T02:14:25.68771" | |
| last_transaction_version | bigint | The version number of the last transaction involving the token. Example: 20747031 | |
| non_transferrable_by_owner | Boolean | Indicates whether the token is non-transferrable by the owner. Example: true or null | |
| owner_address | String | Yes | The Aptos account address that currently owns the token. Addresses must be 66 characters so may be 0 padded. Example: "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" |
| property_version_v1 | bigint | Yes | The version number of the token's properties as of the last update. This field is only for token standard v1. It is always 0 for v2. Example: 0 |
| storage_id | String | Yes | A unique identifier used for storage purposes. IDs must be 66 characters long, so may be 0 padded. Ex. "0xd8d41ff9f67d17d7dee061b5b683b92013b420cb6a30c21fc7c287454792d7a8" |
| table_type_v1 | String | The Move function type. Example: "0x3::token::TokenStore" | |
| token_data_id | String | Yes | A unique identifier for the token data, typically a hash or a numeric ID. Ex. "0x3d911af2dc3e47848fbba17b8694cf526942be183b84f8393a6c048232fb976d" |
| token_properties_mutated_v1 | Object | Properties of the token that have been mutated from the original. Often in JSON or similar format. Example: | |
| token_standard | String | The standard used to generate this token. Ex. "v1" or "v2" |
| Index Name | Indexed Columns |
|---|---|
| curr_to2_insat_index | inserted_at |
| curr_to2_owner_index | owner_address |
| curr_to2_wa_index | storage_id |
| current_token_ownerships_v2_pkey | token_data_id, property_version_v1, owner_address, storage_id |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| cdn_asset_uris | Join | Use the Hasura explorer to see these sub-fields. | |
| current_collection | Join | Use the Hasura explorer to see these sub-fields. | |
| current_token_ownerships | Join | Use the Hasura explorer to see these sub-fields. | |
| current_token_ownerships_aggregate | Join | Use the Hasura explorer to see these sub-fields. | |
| aptos_name | String | This is a name tied to this token using the Aptos Name Service (ANS). Ex. "EpicDragon" | |
| collection_id | String | Yes | Identifier for the collection that includes this token. Ex. "0x360f6eeabb4d7a9d2fab1f35b01e02831e3b5c4b73c7fd6c98dcc1c301c817c8" |
| decimals | bigint | Number of decimal places for token value, typically for fungible tokens. Ex. 18 | |
| description | String | Description of the token. Ex. "A legendary dragon from the mystical lands." | |
| is_fungible_v2 | Boolean | Whether the token is fungible. Ex. False for NFTs | |
| largest_property_version_v1 | bigint | The largest version number of the token's properties under the first schema. Ex. 1 | |
| last_transaction_timestamp | bigint | Unix timestamp of the last transaction involving this token. Ex. 2024-03-27T07:41:58.800893 | |
| last_transaction_version | bigint | Blockchain version of the last transaction involving this token. Ex. 30000000 | |
| maximum | bigint | Maximum possible quantity of this token, relevant for fungibles. Ex. 1000000 | |
| supply | bigint | Current supply of the token in circulation. Ex. 500000 | |
| token_data_id | String | Unique identifier for the token's data. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" | |
| token_name | String | The formal name of the token. Ex. "Mystic Dragon" | |
| token_properties | Object | Use the Hasura explorer to see these sub-fields. | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" | |
| token_uri | String | URI linking to further information about the token. Ex. "https://example.com/tokens/987654321" |
| Index Name | Indexed Columns |
|---|---|
| cur_td2_cid_name_index | collection_id, token_name |
| cur_td2_insat_index | inserted_at |
| current_token_datas_v2_pkey | token_data_id |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| cdn_asset_uris | Join | Use the Hasura explorer to see these sub-fields. | |
| collection_id | String | Yes | Unique identifier for the collection. IDs must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b88" |
| collection_name | String | The formal name of the collection. Ex. "Mythic Dragons" | |
| creator_address | String | This is an Aptos account address that created the collection. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| current_supply | bigint | Current supply of tokens in this collection. Ex. 500 | |
| description | String | Description of the collection. Ex. "A collection of rare digital dragons." | |
| last_transaction_timestamp | String | Timestamp of the last transaction involving this collection. Ex. "2024-04-17T02:14:25.68771" | |
| last_transaction_version | bigint | Blockchain version of the last transaction involving this collection. Ex. 3000000002 | |
| max_supply | bigint | Maximum possible quantity of tokens in this collection. If the max supply is 0, there is no limit on the supply. Ex. 1000 | |
| mutable_description | String | Changeable description of the collection. Ex. "Updated collection description." | |
| mutable_uri | Boolean | True if the uri is changeable by the creator. Ex. True | |
| table_handle_v1 | String | Legacy identifier handle for the collection in earlier schema versions. Ex. "handle_12345" | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" | |
| total_minted_v2 | bigint | Total number of tokens minted in this collection under schema version 2. Ex. 800 | |
| uri | String | This is a URI to where the image live. This can also be JSON data. Ex. "https://example.com/collections/9876543210" |
| Index Name | Indexed Columns |
|---|---|
| cur_col2_crea_cn_index | creator_address, collection_name |
| cur_col2_insat_index | inserted_at |
| current_collections_v2_pkey | collection_id |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| current_collection | Join | Use the Hasura explorer to see these sub-fields. | |
| collection_id | String | Yes | Unique identifier for the collection. IDs must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" |
| collection_name | String | The formal name of the collection. Ex. "Mythic Dragons" | |
| collection_uri | String | URI linking to further information about the collection. Ex. "https://example.com/collections/9876543210" | |
| creator_address | String | This is an Aptos account address that created the collection. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| distinct_tokens | bigint | The count of distinct tokens owned within this collection. Ex. 150 | |
| last_transaction_version | bigint | The version number of the last transaction involving this collection. Ex. 3000000002 | |
| owner_address | String | Yes | This is an Aptos account address that currently owns the token. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" |
| single_token_uri | String | URI linking to information about a specific token within the collection. Ex. "https://example.com/tokens/9876543210" | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| asset_type | String | Yes | The type of the asset, described by a Move resource. Ex. "0x1::aptos_coin::AptosCoin" |
| creator_address | String | This is an Aptos account address that created the asset. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| decimals | bigint | Number of decimal places for token value, typically for fungible tokens. Ex. 18 | |
| icon_uri | String | URI for the icon of the asset. Ex. "https://cdn.example.com/icons/123" | |
| last_transaction_timestamp | String | Timestamp of the last transaction involving this asset. Ex. "2024-04-17T02:14:25.68771" | |
| last_transaction_version | bigint | Blockchain version of the last transaction involving this asset. Ex. 10000000 | |
| name | String | The formal name of the asset. Ex. "Digital Gold" | |
| project_uri | String | URI linking to the project information associated with this asset. Ex. "https://www.example.com/project\_name/" | |
| supply_aggregator_table_handle_v1 | String | Legacy handle for the supply aggregator table from an earlier schema version. Ex. "handle_67890" | |
| supply_aggregator_table_key_v1 | String | Legacy key for accessing the supply aggregator table in earlier schema versions. Ex. "key_12345" | |
| symbol | String | The trading symbol of the asset. Ex. "DGOLD" | |
| token_standard | String | Standard that the asset adheres to. Ex. "v1" |
| Index Name | Indexed Columns |
|---|---|
| fam_creator_index | creator_address |
| fam_insat_index | inserted_at |
| fungible_asset_metadata_pkey | asset_type |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| owner_aptos_names | Join | References owner_aptos_names. | |
| owner_aptos_names_aggregate | Join | References owner_aptos_names. | |
| amount | bigint | The amount of the asset involved in the activity. Ex. 1000 | |
| asset_type | String | Yes | The type of the asset, described by a Move resource. For fungible assets, this will be the address of the metadata object. Ex. "0x1::aptos_coin::AptosCoin" |
| block_height | bigint | The blockchain id at which this activity occurred. Ex. 1500000 | |
| entry_function_id_str | String | The identifier of the function called in this transaction. Ex. "0x1::aptos_account::transfer" | |
| event_index | bigint | Index of the event within the transaction. Ex. 1 | |
| gas_fee_payer_address | String | This is an Aptos account address that paid the gas fee for the transaction. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| is_frozen | Boolean | True if this activity is a freeze asset activity. Ex. null | |
| is_gas_fee | Boolean | Indicates whether this activity involved a gas fee. Ex. True | |
| is_transaction_success | Boolean | Indicates whether the transaction was successful. Ex. True | |
| metadata | Object | Use the Hasura explorer to see fields for metadata in this table. | |
| owner_address | String | This is an Aptos account address that owns the asset. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" | |
| storage_id | String | Identifier for the storage used in the transaction. IDs must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" | |
| storage_refund_amount | bigint | Amount refunded for storage after the transaction. This is always in APT octas. Ex. 50 | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" | |
| transaction_timestamp | String | Timestamp when the transaction occurred. Ex. "2024-04-17T02:14:25.68771" | |
| transaction_version | bigint | Blockchain version of the transaction. Ex. 2 | |
| type | String | Type of the transaction, described by a Move entry function. Ex. "0x1::coin::WithdrawEvent" |
| Index Name | Indexed Columns |
|---|---|
| faa_at_index | asset_type |
| faa_gfpa_index | gas_fee_payer_address |
| faa_insat_idx | inserted_at |
| faa_owner_type_index | owner_address, type |
| faa_si_index | storage_id |
| fungible_asset_activities_pkey | transaction_version, event_index |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| amount | bigint | The amount of the asset owned. Ex. 2000 | |
| asset_type | String | The type of the asset, described by a Move resource. For v2 tokens this is the address of the fungible asset metadata object. For v1 it's the fully qualified path of the move resource. Ex. "0x1::aptos_coin::AptosCoin" | |
| is_frozen | Boolean | Indicates whether the account is frozen. Ex. False | |
| is_primary | Boolean | Indicates whether this is the primary balance of the owner. Ex. True | |
| last_transaction_timestamp | String | Timestamp of the last transaction involving this balance. Ex. "2024-04-17T02:14:25.68771" | |
| last_transaction_version | bigint | Blockchain version of the last transaction involving this balance. Ex. 30000000 | |
| metadata | Object | Use the Hasura explorer to see fields for metadata in current_fungible_asset_balances. | |
| owner_address | String | This is an Aptos account address that owns the asset. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" | |
| storage_id | String | Yes | Identifier for the storage associated with this balance. IDs must be 66 characters long, and so may be 0 padded. Ex. "0xa815a9a09105973084bfc31530e7c8f002846787c2f0521e1e34dc144ad83b89" |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" |
| Index Name | Indexed Columns |
|---|---|
| cufab_insat_index | inserted_at |
| cufab_owner_at_index | owner_address, asset_type |
| current_unified_fungible_asset_balances_pkey | storage_id |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| staking_pool_address | String | Yes | The address of the delegation pool. |
| total_coins | bigint | Amount of APT in the staking pool. | |
| total_shares | bigint | The total number of shares in the delegation pool. | |
| operator_commission_percentage | bigint | The commission percentage taken by the staking pool operator. | |
| inactive_table_handle | String | The table handle for the inactive table. | |
| active_table_handle | String | The table handle for the active table. | |
| last_transaction_version | int8 | Transaction version (identifier) for the last transaction involving this staking pool. | |
| inserted_at | String | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| current_delegated_staking_pool_balances_pkey | staking_pool_address |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| delegation_pool_address | String | Yes | The address of the delegation pool. |
| delegator_address | String | Yes | The address of the delegator. |
| table_handle | String | The table handle tracking this position. | |
| voter | String | The address of the current voter in the delegation pool. | |
| pending_voter | String | The address of the pending voter awaiting confirmation. | |
| last_transaction_version | bigint | The transaction version (identifier) of the last transaction involving this delegation. | |
| last_transaction_timestamp | Timestamp | The block timestamp of the last transaction involving this delegation. | |
| inserted_at | Timestamp | The timestamp when the record was inserted into the database. |
| Index Name | Indexed Columns |
|---|---|
| current_delegated_voter_pkey | delegation_pool_address, delegator_address |
| cdv_da_index | delegator_address |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| delegator_address | String | Yes | The address of the delegator. |
| pool_address | String | The address of the delegator pool. | |
| pool_type | String | If the shares are active or inactive | |
| table_handle | String | The table handle for the pool. | |
| shares | bigint | The number of shares in the pool. | |
| parent_table_handle | String | The table handle for the parent table. | |
| last_transaction_version | bigint | Transaction version (identifier) for the last transaction involving this staking pool. | |
| inserted_at | Timestamp | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| current_delegator_balances_pkey | delegator_address, pool_address, pool_type, table_handle |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| staking_pool_address | String | Yes | The address of the staking pool. |
| voter_address | String | The address of the voter. | |
| operator_address | String | The address of the operator. | |
| last_transaction_version | bigint | Transaction version (identifier) for the last transaction involving this staking pool. | |
| inserted_at | Timestamp | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| current_staking_pool_voter_pkey | staking_pool_address |
| ctpv_va_index | voter_address |
| ctpv_insat_index | inserted_at |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| transaction_version | bigint | Transaction version (identifier) for activity | |
| event_index | bigint | The index of the event. Ex. 1 | |
| delegator_address | String | The address of the delegator. | |
| pool_address | String | The address of the pool. | |
| event_type | String | DistributeRewards, AddStake, UnlikeStake, ReactiveStake, WithdrawStake | |
| amount | bigint | The amount being staked. Ex. 1000 | |
| inserted_at | Timestamp | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| delegated_staking_activities_pkey | transaction_version, event_index |
| dsa_pa_da_index | pool_address, delegator_address, transaction_version, event_index |
| dsa_insat_index | inserted_at |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| transaction_version | bigint | Transaction version (identifier) for activity | |
| staking_pool_address | String | The address of the delegation pool. | |
| total_coins | bigint | Amount of APT in the staking pool. | |
| total_shares | bigint | The total number of shares in the delegation pool. | |
| operator_commission_percentage | bigint | The commission percentage taken by the staking pool operator. | |
| inactive_table_handle | String | The table handle for the inactive table. | |
| active_table_handle | String | The table handle for the active table. | |
| inserted_at | String | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| delegated_staking_pool_balances_pkey | transaction_version, staking_pool_address |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| staking_pool_address | String | The address of the staking pool. | |
| first_transaction_version | bigint | The version number of the first transaction involving this pool. Ex. 5000000 | |
| inserted_at | Timestamp | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| delegated_staking_pools_pkey | staking_pool_address |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| transaction_version | bigint | The version number of the transaction. Ex. 5000000 | |
| write_set_change_index | bigint | The index of the write set change. Ex. 1 | |
| delegator_address | String | The address of the delegator. | |
| pool_address | String | The address of the delegator pool. | |
| pool_type | String | The type of the pool. Ex. "delegated" | |
| table_handle | String | The table handle for the pool. | |
| shares | bigint | The number of shares in the pool. | |
| parent_table_handle | String | The table handle for the parent table. | |
| inserted_at | Timestamp | The timestamp when the record was inserted. |
| Index Name | Indexed Columns |
|---|---|
| delegator_balances_pkey | transaction_version, write_set_change_index |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| domain | String | The domain associated with this Aptos name. Ex. "example.crypto" | |
| domain_with_suffix | String | The full domain name including any suffix. Ex. "example.crypto.aptos" | |
| expiration_timestamp | String | Timestamp when the domain registration expires. Ex. "2024-04-17T02:14:25.68771" | |
| is_active | Boolean | Indicates whether the domain is currently active. Ex. True | |
| is_domain_owner | Boolean | Indicates whether the registered address is the owner of the domain. Ex. False | |
| is_primary | Boolean | Indicates whether this is the primary domain for the registered address. Ex. True | |
| last_transaction_version | bigint | The version number of the last transaction involving this domain. Ex. 5000000 | |
| owner_address | String | This is an Aptos account address that owns the domain. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x123abc456def7890abcdef1234567890abcdef1234" | |
| registered_address | String | This is an Aptos account address registered to the domain. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| subdomain | String | Any subdomain part of the domain name. Ex. "sub.example" | |
| token_name | String | The name of the token associated with this domain. Ex. "ExampleToken" | |
| token_standard | String | Aptos standard that the collection adheres to. Ex. "v1" |
| Field | Type | Primary Key | Description |
|---|---|---|---|
| domain | String | Yes | The domain associated with this Aptos name. Ex. "example.crypto" |
| expiration_timestamp | String | Timestamp when the domain registration expires. Ex. "2024-04-17T02:14:25.68771" | |
| is_deleted | Boolean | Indicates whether the domain registration has been deleted. Ex. False | |
| last_transaction_version | bigint | The version number of the last transaction involving this domain. Ex. 5000000 | |
| registered_address | String | This is an Aptos account address registered to the domain. Addresses must be 66 characters long, and so may be 0 padded. Ex. "0x50bc83f01d48ab3b9c00048542332201ab9cbbea61bda5f48bf81dc506caa78a" | |
| subdomain | String | Yes | Any subdomain part of the domain name. Ex. "sub.example" |
| token_name | String | The name of the token associated with this domain. Ex. "ExampleToken" | |
| token_standard | String | Yes | Aptos standard that the collection adheres to. Ex. "v1" |
| Index Name | Indexed Columns |
|---|---|
| ans_v2_et_index | expiration_timestamp |
| ans_v2_insat_index | inserted_at |
| ans_v2_ra_index | registered_address |
| ans_v2_tn_index | token_name, token_standard |
| current_ans_lookup_v2_pkey | domain, subdomain, token_standard |
| Table | Notes |
|---|---|
| address_version_from_move_resources | Replace with account_transactions |
| address_events_summary | To query custom events, you should create a No-Code Indexer |
| address_version_from_events | To query custom events, you should create a No-Code Indexer |
| coin_activities | Replace with fungible_asset_activities |
| coin_balances | Replace with current_fungible_asset_balances |
| coin_infos | Replace with fungible_asset_metadata |
| coin_supply | No replacement; non-realtime APT coin supply is available with this query |
| collection_datas | Replace with current_collections_v2 |
| current_ans_lookup | Replace with current_ans_lookup_v2 |
| current_coin_balances | Replace with current_fungible_asset_balances |
| current_collection_datas | Replace with current_collections_v2 |
| current_token_datas | Replace with current_token_datas_v2 |
| current_token_ownerships | Replace with current_token_ownerships_v2 |
| events_view | To query custom events, you should create a No-Code Indexer |
| move_resources | Replace with account_transactions |
| move_resources_view | Replace with account_transactions |
| nft_marketplace_v2_* | No direct replacement; query marketplace activity via the Indexer API |
| token_activities | Replace with token_activities_v2 |
| token_datas | Replace with current_token_datas_v2 |
| token_ownerships | Replace with current_token_ownerships_v2 |
| tokens | Replace with current_token_datas_v2 |
| transactions | No replacement; non-realtime data is available in BigQuery |
| transactions_view | No replacement; non-realtime data is available in BigQuery |
| Feed | URL | Best for |
|---|---|---|
| llms.txt | /llms.txt | Structured index with page titles, descriptions, and per-page .md links |
| llms-small.txt | /llms-small.txt | Condensed docs for smaller context windows |
| llms-full.txt | /llms-full.txt | Full documentation — all pages concatenated |