The Indexer API allows you to access rich data about tokens, fungible assets, and accounts 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.

To ensure your queries filter data efficiently, check out the available indexes for each table. Some indexes are composite B-tree indexes, meaning they consist of multiple columns. B-tree indexes are ordered and perform optimally when queries utilize a left-most prefix of the indexed columns.

Transactions filtered to user_transactions (not system).

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

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

Index Name	Indexed Columns
block_metadata_transactions_block_height_key	block_height
block_metadata_transactions_pkey	version
bmt_insat_index	inserted_at

Has an aggregate view for summary data called account_transactions_aggregate

Index Name	Indexed Columns
account_transactions_pkey	account_address, transaction_version
at_insat_index	inserted_at
at_version_index	transaction_version DESC

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

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

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.

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”

Has an aggregate view for summary data called token_activities_v2_aggregate

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

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”

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”

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

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”

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

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”

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

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”

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

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”

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”

Index Name	Indexed Columns
fam_creator_index	creator_address
fam_insat_index	inserted_at
fungible_asset_metadata_pkey	asset_type

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”

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

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”

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

With AIP-6 we added the ability for staking pools to be formed with delegated funds (delegation pools). Once these pools hold over 1M APT, they can become a staking pool (validator node).

This table tracks the current balances of each account in a delegated staking pool.

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

This table tracks the current delegated voters of a delegation pool.

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

This table tracks the current balances of each account in a delegated staking pool.

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

This table tracks the current voters of a staking pool.

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

This table tracks delegated staking events.

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

This table tracks the historical balances of each account in a delegated staking pool.

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

This table tracks when a delegated pool was created.

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

This table tracks the historical balances of each account in a delegation pool.

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

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

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”

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

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	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_*	Replace with NFT Aggregator 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