Indexer API Reference

The Indexer API allows you to access rich data about tokens, accounts, transactions, and events on-chain using GraphQL queries. You can access it here.

For common queries, check out the sidebar for examples to work from. When building your own, this reference guide should help you determine which tables are most relevant, and how to format your queries.

⚠️

Before relying on a table for production services, check the bottom of this page to see if that table is deprecated. If so, use the note section for guidance on what to do to migrate to a non-deprecated table.

If you are looking up a table with the _by_pk suffix, search for the table name without that suffix. _by_pk tables are automatically generated for convenience to allow querying by primary key.

Indexer Table Reference

Remember to use Ctrl + F to find the table you are interested in! When in doubt, you may also want to query the Hasura tables linked in the Indexer API Access page to see examples of the data inside.

Raw Data

`user_transactions`

Transactions filtered to user_transactions (not system).

`events`

Events emitted by transaction.

`block_metadata_transactions`

A type of system transaction emitted once per block, useful for mapping to timestamp or epoch.

General

`account_transactions`

Has an aggregate view for summary data called account_transactions_aggregate

This table maps accounts and transactions that interact with that account.

Field	Type	Primary Key	Description
coin_activities	Join		Use the Hasura explorer to see these sub-fields.
coin_activities_aggregate	Join		Use the Hasura explorer to see these sub-fields.
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

`ledger_infos`

This table shares what chain is currently being queried.

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.

`processor_status`

This table shares how current this processor’s data is.

gives you latest version processed per “processor”

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”

NFT

`token_activities_v2`

Has an aggregate view for summary data called token_activities_v2_aggregate

This table tracks token activities and is especially useful for tracking NFT activity. This includes both v1 and v2 data.

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”

`nft_metadata_crawler_parsed_asset_uris`

This table allows you to look up the cdn and uris for NFT images / content.

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”

`current_token_ownerships_v2`

Has an aggregate view for summary data called current_token_ownerships_v2_aggregate

This table tracks who owns which NFTs. This includes both v1 and v2 tokens. Fungible tokens are not tracked as consistently.

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”

`current_token_datas_v2`

This table tracks the metadata associated with each NFT (Ex. URI, supply, etc.). This tracks both v1 and v2 tokens.

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”

`current_collections_v2`

This table tracks the metadata associated with each NFT collection (Ex. collection_id, creator_address, etc.). This tracks both v1 and v2 tokens.

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”

`current_collection_ownership_v2_view`

Has an aggregate view for summary data called current_collection_ownership_v2_view_aggregate

This table maps collections to who owns them and helps count how much of a collection is owned by other accounts.

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”

Fungible Assets

`fungible_asset_metadata`

This tracks the metadata tied to each fungible asset (ex. decimals of precision). It includes v1 token data. This is a current_ table.

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”

`fungible_asset_activities`

This tracks the activity of fungible assets. It includes v1 token data.

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”

`current_fungible_asset_balances`

Has an aggregate view for summary data called current_fungible_asset_balances_aggregate

This tracks the asset balances of each account on-chain. It includes v1 token data.

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”

Aptos Naming Service (ANS)

`current_aptos_names`

Has an aggregate view for summary data called current_aptos_names_aggregate

This view of current_ans_lookup_v2 helps query by name instead of account.

Field	Type	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”

`current_ans_lookup_v2`

This table maps tokens, standards, and addresses to human readable names.

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”

Deprecated Tables

The following tables are planned for deprecation, or are already deprecated. See the notes section for any direct replacements or notes on how to migrate if you currently depend on one of these tables. Please do not use any of the below tables for production services.

Table	Deprecation Date	Delete Date	Notes
address_version_from_move_resources	6/7	TBD	The move_resources table has been replaced with legacy_migration_v1.move_resources, which uses account_transactions in a view. To use the migrated view, you will need to backfill and run account_transactions processor.
address_version_from_move_resources_aggregate	6/7	TBD	The move_resources table has been replaced with legacy_migration_v1.move_resources, which uses account_transactions in a view. To use the migrated view, you will need to backfill and run account_transactions processor.
coin_activities	7/22	TBD	We will replace with fungible_asset_activities
coin_activities_aggregate	7/22	TBD	We will replace with fungible_asset_activities
coin_balances	7/22	TBD	Replace with fungible_asset_balances
collection_datas	7/22	TBD	Replace with collection_v2
current_coin_balances	7/22	TBD	Replace with current_fungible_asset_balances
current_token_ownerships	7/22	TBD	Replace with current_token_ownerships_v2
current_token_ownerships_aggregate	7/22	TBD	Replace with current_token_ownerships_v2
move_resources	6/7	TBD	Replace with account_transactions
move_resources_aggregate	6/7	TBD	Replace with account_transactions
nft_marketplace_v2_current_nft_marketplace_auctions	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
nft_marketplace_v2_current_nft_marketplace_collection_offers	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
nft_marketplace_v2_current_nft_marketplace_listings	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
nft_marketplace_v2_current_nft_marketplace_listings_aggregate	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
nft_marketplace_v2_current_nft_marketplace_token_offers	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
nft_marketplace_v2_nft_marketplace_activities	TBD	TBD	We’re deprecating nft_marketplace processor so all the nft_marketplace tables should be deleted
signatures	6/21	TBD
token_activities	7/22	TBD	Replace with token_activities_v2
token_activities_aggregate	7/22	TBD	Replace with token_activities_v2
token_datas	7/22	TBD
token_ownerships	7/22	TBD	Replace with token_ownerships_v2
tokens	7/22	TBD	Replaced with v2 tables

Indexer API Access Architecture