Aptos GraphQL and Analytics

Raw blockchain data can be difficult for developers to work with for a number of reasons.

It is often stored in a proprietary format that is not easily accessible or readable by external systems or tools.
It can be voluminous and complex, making it difficult to extract and analyze the specific information that is needed for a particular application or use case
It may be distributed across multiple nodes in the blockchain network, requiring developers to devise complex strategies for accessing and integrating the data from multiple sources

BlockEden.xyz solves this by indexing blockchain data in real-time and presents the result to you with an analytics web portal and indexer GraphQL.

How BlockEden.xyz Analytics and GraphQL works?

Analytics web portal

BlockEden.xyz Analytics is a metabase web portal for exploring and analyzing blockchain data. It allows users to easily query, visualize, and share data from Aptos and Sui blockchains.

Quick start

SQL examples

Aptos User Tx Per Day

select date(timestamp) as date, count(*) as user_tx_count from user_transactions group by 1;

Aptos NFT swap volume last 14 days

SELECT date(inserted_at) AS date,
       sum(((DATA #>> '{coin_amount}')::bigint / pow(10, 8))) AS coin_amount
FROM EVENTS
WHERE TYPE like '%::token_coin_swap::TokenSwapEvent'
  AND inserted_at BETWEEN NOW() - INTERVAL '14 DAYS' AND NOW()
GROUP BY 1;

Indexer GraphQL

GraphQL is a query language and runtime for building APIs that allows clients to request and receive only the data they need, in a predictable and flexible format. It provides a way for clients to specify the shape of the data they need, and for the server to describe the data it can provide, enabling more efficient and flexible communication between the client and the server. GraphQL is often used as an alternative to REST APIs, and is particularly well-suited for modern, data-driven applications that need to be flexible and easily extended.

You may create an api key at the dashboard to get transaction, block, coin, NFT, and events data from our GraphQL API.

Indexer database schema

block_metadata_transactions

Field	Type	Description
version	Int8	A version is the sequence id of a transaction.
block_height	Int8	height of the block where the transactions are recorded
id	Varchar	identifier of the block
round	Int8	A round consists of achieving consensus on a block of transactions and their execution results.
epoch	Int8	An epoch is a fixed duration of time, currently defined as two hours on mainnet.
previous_block_votes_bitvec	Jsonb	bitvector of previous block votes
proposer	Varchar	address of the block proposer
failed_proposer_indices	Jsonb	list of failed proposer indices
timestamp	Timestamp	Timestamp is the machine timestamp of when the block is committed.
inserted_at	Timestamp	inserted_at is when the row is inserted into the database.

coin_activities

The coin_activities table contains all the coin transfter activity history.

Field	Type	Description
transaction_version	Int8	version of the transaction
event_account_address	Varchar	account address where event is recorded
event_creation_number	Int8	block creation number of the event
event_sequence_number	Int8	unique identifier of the event
owner_address	Varchar	address of the owner of the coin
coin_type	Varchar	Coin type or symbol. Get all registered coin types.
amount	Numeric	amount of the coin
activity_type	Varchar	The type of the activity among `0x1::coin::DepositEvent`, `0x1::aptos_coin::GasFeeEvent,` `0x1::coin::WithdrawEvent`
is_gas_fee	Bool	indicates if the transaction is a gas fee or not
is_transaction_success	Bool	indicates if the transaction is successful or not
entry_function_id_str	`Nullable<Varchar>`	entry function identifier of the transaction
block_height	Int8	height of the block where the transaction is recorded
transaction_timestamp	Timestamp	when is the transaction minted
inserted_at	Timestamp	time when the transaction was inserted into the database

Example

List 10 most recent USDC coin activities for deposits into a specific address after a date.

Query:

query CoinActivities($owner_address: String, $limit: Int, $offset: Int, $coin_type: String, $after_at: timestamp) {
  coin_activities(
    where: {owner_address: {_eq: $owner_address}, activity_type: {_eq: "0x1::coin::DepositEvent"}, coin_type: {_eq: $coin_type}, transaction_timestamp: {_gte: $after_at}}
    order_by: {transaction_version: desc}
    limit: $limit
    offset: $offset
  ) {
    inserted_at
    activity_type
    amount
    block_height
    coin_type
    entry_function_id_str
    event_account_address
    event_creation_number
    event_sequence_number
    is_gas_fee
    is_transaction_success
    owner_address
    transaction_timestamp
    transaction_version
  }
}

Variables:

{
  "owner_address": "0x8304621d9c0f6f20b3b5d1bcf44def4ac5c8bf7c11a1ce80b53778532396312b",
  "limit": 10,
  "offset": 0,
  "coin_type": "0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T",
  "after_at": "2021-01-07T19:15:58.268388"
}

coin_balances

Field	Type	Description
transaction_version	Int8	version of the transaction
owner_address	Varchar	address of the owner
coin_type_hash	Varchar	hash of the coin type
coin_type	Varchar	symbol or name of the coin type
amount	Numeric	amount of the transaction
transaction_timestamp	Timestamp	when the transaction was initiated
inserted_at	Timestamp	when the row was inserted into the database

coin_infos

Field	Type	Description
coin_type_hash	Varchar	Hash of the coin type metadata.
coin_type	Varchar	The type or symbol of the coin.
transaction_version_created	Int8	Version of the transaction that created the coin type.
creator_address	Varchar	The address of the transaction creator.
name	Varchar	The name of the coin.
symbol	Varchar	The symbol used to represent the coin.
decimals	Int4	The number of decimal places used to represent the coin value.
transaction_created_timestamp	Timestamp	The timestamp of when the transaction was created.
inserted_at	Timestamp	The timestamp of when the row was inserted into the database.
supply_aggregator_table_handle	`Nullable<Varchar>`	Handle to the table that contains the supply aggregation data for the coin.
supply_aggregator_table_key	`Nullable<Text>`	Key used to identify the supply aggregation data for the coin.

coin_supply

Field	Type	Description
transaction_version	Int8	Transaction version
coin_type_hash	Varchar	Hash of the coin type
coin_type	Varchar	Type of coin
supply	Numeric	Total supply of the coin
transaction_timestamp	Timestamp	Timestamp of the transaction
transaction_epoch	Int8	Epoch of the transaction
inserted_at	Timestamp	Timestamp of when the data was inserted

collection_datas

Field	Type	Description
collection_data_id_hash	Varchar	Hash of the collection data ID
transaction_version	Int8	Transaction version
creator_address	Varchar	Address of the creator
collection_name	Varchar	Name of the collection
description	Text	Description of the collection
metadata_uri	Varchar	URI of the metadata
supply	Numeric	Total supply of the collection
maximum	Numeric	Maximum supply of the collection
maximum_mutable	Bool	Flag indicating if the maximum supply is mutable
uri_mutable	Bool	Flag indicating if the metadata URI is mutable
description_mutable	Bool	Flag indicating if the description is mutable
inserted_at	Timestamp	Timestamp of when the data was inserted
table_handle	Varchar	Handle of the table
transaction_timestamp	Timestamp	Timestamp of the transaction

current_ans_lookup

Field	Type	Description
domain	Varchar	Domain name
subdomain	Varchar	Subdomain name
registered_address	`Nullable<Varchar>`	Address that is registered
expiration_timestamp	Timestamp	Timestamp of when the registration expires
last_transaction_version	Int8	Last transaction version
inserted_at	Timestamp	Timestamp of when the data was inserted

current_coin_balances

Field	Type	Description
owner_address	Varchar	Address of the owner
coin_type_hash	Varchar	Hash of the coin type
coin_type	Varchar	Type of coin
amount	Numeric	Amount of coins
last_transaction_version	Int8	Last transaction version
last_transaction_timestamp	Timestamp	Timestamp of the last transaction
inserted_at	Timestamp	Timestamp of when the data was inserted

current_collection_datas

Field	Type	Description
collection_data_id_hash	Varchar	Unique identifier of the collection
creator_address	Varchar	Address of the creator of the collection
collection_name	Varchar	Name of the collection
description	Text	Description of the collection
metadata_uri	Varchar	URI of the metadata of the collection
supply	Numeric	Current supply of the collection
maximum	Numeric	Maximum supply of the collection
maximum_mutable	Bool	Indicates if the maximum supply can be changed
uri_mutable	Bool	Indicates if the URI of the collection can be changed
description_mutable	Bool	Indicates if the description of the collection can be changed
last_transaction_version	Int8	Version of the last transaction
inserted_at	Timestamp	Timestamp of when the collection was created
table_handle	Varchar	Handle of the table where the collection data is stored
last_transaction_timestamp	Timestamp	Timestamp of the last transaction

current_staking_pool_voter

Field	Type	Description
staking_pool_address	Varchar	Address of the staking pool
voter_address	Varchar	Address of the voter
last_transaction_version	Int8	Version of the last transaction
inserted_at	Timestamp	Timestamp of when the voting relationship was created

current_token_datas

Field	Type	Description
token_data_id_hash	Varchar	Unique identifier for the token data
creator_address	Varchar	Address of the creator of the token
collection_name	Varchar	Name of the collection the token belongs to
name	Varchar	Name of the token
maximum	Numeric	Maximum number of tokens allowed to exist
supply	Numeric	Current number of tokens in existence
largest_property_version	Numeric	Largest property version of the token
metadata_uri	Varchar	URI for the token metadata
payee_address	Varchar	Address of the payee for the token
royalty_points_numerator	Numeric	Numerator for the token's royalty points
royalty_points_denominator	Numeric	Denominator for the token's royalty points
maximum_mutable	Bool	Indicates if the maximum number of tokens can be changed
uri_mutable	Bool	Indicates if the metadata URI can be changed
description_mutable	Bool	Indicates if the description of the token can be changed
properties_mutable	Bool	Indicates if the properties of the token can be changed
royalty_mutable	Bool	Indicates if the royalty points of the token can be changed
default_properties	Jsonb	Default properties for the token
last_transaction_version	Int8	Version of the last transaction for the token
inserted_at	Timestamp	Timestamp of when the token data was inserted
collection_data_id_hash	Varchar	Unique identifier for the collection the token belongs to
last_transaction_timestamp	Timestamp	Timestamp of the last transaction for the token
description	Text	Description of the token

current_token_ownerships

Field	Type	Description
token_data_id_hash	Varchar	Unique identifier for token data
property_version	Numeric	Version of token properties
owner_address	Varchar	Address of token owner
creator_address	Varchar	Address of token creator
collection_name	Varchar	Name of token collection
name	Varchar	Name of the token
amount	Numeric	Amount of the token
token_properties	Jsonb	Token properties in JSON format
last_transaction_version	Int8	Version of the last transaction
inserted_at	Timestamp	Timestamp of data insertion
collection_data_id_hash	Varchar	Unique identifier for collection data
table_type	Text	Type of the table
last_transaction_timestamp	Timestamp	Timestamp of the last transaction

current_token_pending_claims

Field	Type	Description
token_data_id_hash	Varchar	Unique identifier for token data
property_version	Numeric	Version of token property
from_address	Varchar	Address of the sender
to_address	Varchar	Address of the receiver
collection_data_id_hash	Varchar	Unique identifier for collection data
creator_address	Varchar	Address of token creator
collection_name	Varchar	Name of token collection
name	Varchar	Name of the token
amount	Numeric	Amount of the token
table_handle	Varchar	Handle of the table
last_transaction_version	Int8	Version of the last transaction
inserted_at	Timestamp	Timestamp of data insertion
last_transaction_timestamp	Timestamp	Timestamp of the last transaction

events

Field	Type	Description
sequence_number	Int8	Unique sequence number of the event
creation_number	Int8	Creation number of the event
account_address	Varchar	Address of the account
transaction_version	Int8	Version of the transaction
transaction_block_height	Int8	Height of the block in which the event was included
type_	Text	Type of the event
data	Jsonb	Data related to the event
inserted_at	Timestamp	Timestamp of when the event was inserted into the database

indexer_status

Field	Type	Description
db	Varchar	Name of the database
is_indexer_up	Bool	Whether the indexer is up or down
inserted_at	Timestamp	Timestamp when the indexer status was recorded

ledger_infos

Field	Type	Description
chain_id	Int8	Chain ID of the ledger

move_modules

Field	Type	Description
transaction_version	Int8	Version number of the transaction
write_set_change_index	Int8	Index of the change made in the write set
transaction_block_height	Int8	Block height of the transaction
name	Text	Name of the module
address	Varchar	Address of the module
bytecode	`Nullable<Bytea>`	Bytecode of the module
friends	`Nullable<Jsonb>`	Friends of the module
exposed_functions	`Nullable<Jsonb>`	List of functions exposed by the module
structs	`Nullable<Jsonb>`	Structs defined in the module
is_deleted	Bool	Indicates whether the module has been deleted
inserted_at	Timestamp	Timestamp of when the module was inserted

move_resources

Field	Type	Description
transaction_version	Int8	Version of the transaction
write_set_change_index	Int8	The index of the change in the write set
transaction_block_height	Int8	Block height in which the transaction was processed
name	Text	Name of the resource
address	Varchar	Address of the resource
type	Text	Type of the resource
module	Text	Module where the resource belongs to
generic_type_params	`Nullable<Jsonb>`	Generic type parameters for the resource
data	`Nullable<Jsonb>`	Data stored in the resource
is_deleted	Bool	Indicates if the resource has been deleted
inserted_at	Timestamp	Timestamp of when the resource was inserted

Examples

List all the move resources for a specific account by address, time and type.

Query:

query AccountTransactionsData($address: String, $limit: Int, $offset: Int, $after_at: timestamp, $type: String) {
  move_resources(
    where: {address: {_eq: $address}, inserted_at: {_gte: $after_at}, type: {_eq: $type}}
    order_by: {transaction_version: desc}
    distinct_on: transaction_version
    limit: $limit
    offset: $offset
  ) {
    type
    transaction_version
    data
    inserted_at
  }
}

Variables:

{
  "address": "0x8304621d9c0f6f20b3b5d1bcf44def4ac5c8bf7c11a1ce80b53778532396312b",
  "limit": 100,
  "offset": 0,
  "after_at": "2022-01-07T19:15:58.268388",
  "type": "0x1::coin::CoinStore<0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T>"
}

processor_status

Field	Type	Description
processor	Varchar	Name of the processor
last_success_version	Int8	Version of the last successful transaction processed by the processor
last_updated	Timestamp	Timestamp of when the processor was last updated

processor_statuses

Field	Type	Description
name	Varchar	Name of the object
version	Int8	Version number of the object
success	Bool	Flag indicating the success of the operation
details	`Nullable<Text>`	Detailed information about the operation
last_updated	Timestamp	Timestamp of the last update made to the object

signatures

Field	Type	Description
transaction_version	Int8	Version of the transaction
multi_agent_index	Int8	Index of the multi-agent involved in the transaction
multi_sig_index	Int8	Index of the multi-signature involved in the transaction
transaction_block_height	Int8	Block height at which the transaction was included
signer	Varchar	The signer of the transaction
is_sender_primary	Bool	Flag indicating if the signer is the primary sender
type	Varchar	Type of the transaction
public_key	Varchar	Public key of the signer
signature	Varchar	Signature of the transaction
threshold	Int8	Threshold required for the transaction to be valid
public_key_indices	Jsonb	Indices of the public keys involved in the transaction
inserted_at	Timestamp	Timestamp of when the transaction was inserted

table_items

Field	Type	Description
key	Text	Key identifying the object in the database
transaction_version	Int8	Version of the transaction that wrote to the object
write_set_change_index	Int8	Index of the change made to the write set of the object
transaction_block_height	Int8	Block height at which the transaction was included
table_handle	Varchar	Handle of the table that the object belongs to
decoded_key	Jsonb	Decoded key of the object
decoded_value	`Nullable<Jsonb>`	Decoded value of the object
is_deleted	Bool	Flag indicating if the object has been deleted
inserted_at	Timestamp	Timestamp of when the object was inserted

table_metadatas

Field	Type	Description
handle	Varchar	Unique identifier for the metadata
key_type	Text	Type of the key for the metadata
value_type	Text	Type of the value for the metadata
inserted_at	Timestamp	Timestamp when the metadata was inserted

token_activities

Field	Type	Description
transaction_version	Int8	Version of the transaction
event_account_address	Varchar	Address of the event account
event_creation_number	Int8	Creation number of the event
event_sequence_number	Int8	Sequence number of the event
collection_data_id_hash	Varchar	Hash of the collection data id
token_data_id_hash	Varchar	Hash of the token data id
property_version	Numeric	Version of the property
creator_address	Varchar	Address of the creator
collection_name	Varchar	Name of the collection
name	Varchar	Name of the token
transfer_type	Varchar	Type of transfer of the token
from_address	`Nullable<Varchar>`	Address the token was transferred from, if applicable
to_address	`Nullable<Varchar>`	Address the token was transferred to, if applicable
token_amount	Numeric	Amount of tokens involved in the transfer
coin_type	`Nullable<Text>`	Type of the coin involved in the transfer, if applicable
coin_amount	`Nullable<Numeric>`	Amount of the coin involved in the transfer, if applicable
inserted_at	Timestamp	Timestamp when the activity was inserted into the table
transaction_timestamp	Timestamp	Timestamp of the transaction

token_datas

Field	Type	Description
token_data_id_hash	Varchar	Unique identifier of the token data
transaction_version	Int8	Version of the transaction
creator_address	Varchar	Address of the creator of the token
collection_name	Varchar	Name of the token collection
name	Varchar	Name of the token
maximum	Numeric	Maximum number of tokens in circulation
supply	Numeric	Current number of tokens in circulation
largest_property_version	Numeric	Largest version of the token properties
metadata_uri	Varchar	URI containing the metadata of the token
payee_address	Varchar	Address of the payee
royalty_points_numerator	Numeric	Numerator of the royalty points
royalty_points_denominator	Numeric	Denominator of the royalty points
maximum_mutable	Bool	Flag indicating if the maximum number of tokens is mutable
uri_mutable	Bool	Flag indicating if the metadata URI is mutable
description_mutable	Bool	Flag indicating if the description of the token is mutable
properties_mutable	Bool	Flag indicating if the properties of the token are mutable
royalty_mutable	Bool	Flag indicating if the royalty of the token is mutable
default_properties	Jsonb	Default properties of the token
inserted_at	Timestamp	Timestamp when the record was inserted
collection_data_id_hash	Varchar	Unique identifier of the collection data
transaction_timestamp	Timestamp	Timestamp of the transaction
description	Text	Description of the token

token_ownerships

Field	Type	Description
token_data_id_hash	Varchar	Unique identifier of the token data
property_version	Numeric	Version of the token properties
transaction_version	Int8	Version of the transaction
table_handle	Varchar	Unique identifier of the table
creator_address	Varchar	Address of the creator of the token
collection_name	Varchar	Name of the token collection
name	Varchar	Name of the token
owner_address	`Nullable<Varchar>`	Address of the token owner, can be `NULL`
amount	Numeric	Number of tokens owned by the owner
table_type	`Nullable<Text>`	Type of the table, can be `NULL`
inserted_at	Timestamp	Timestamp when the record was inserted
collection_data_id_hash	Varchar	Unique identifier of the collection data
transaction_timestamp	Timestamp	Timestamp of the transaction

tokens

Field	Type	Description
token_data_id_hash	Varchar	The unique identifier of the token data
property_version	Numeric	The version of the token properties
transaction_version	Int8	The version of the transaction that created the token
creator_address	Varchar	The address of the creator of the token
collection_name	Varchar	The name of the collection the token belongs to
name	Varchar	The name of the token
token_properties	Jsonb	The properties of the token
inserted_at	Timestamp	The time the token was inserted into the database
collection_data_id_hash	Varchar	The unique identifier of the collection data
transaction_timestamp	Timestamp	The time the transaction that created the token was executed

transactions

Field	Type	Description
version	Int8	version is the sequence id of the transaction
block_height	Int8	The block height of the transaction
hash	Varchar	The unique identifier of the transaction
type	Varchar	The type of the transaction (e.g. function call, contract creation)
payload	`Nullable<Jsonb>`	The payload contains arguments, code, function, type, type arguments if it is a function call
state_change_hash	Varchar	The hash representing the state changes of the transaction
event_root_hash	Varchar	The root hash of all events produced by the transaction
state_checkpoint_hash	`Nullable<Varchar>`	The hash of the state checkpoint at the time of the transaction
gas_used	Numeric	The amount of gas used by the transaction
success	Bool	Whether the transaction was successful or not
vm_status	Text	The status of the virtual machine after executing the transaction
accumulator_root_hash	Varchar	The root hash of the accumulator after executing the transaction
num_events	Int8	The number of events produced by the transaction
num_write_set_changes	Int8	The number of write set changes made by the transaction
inserted_at	Timestamp	The time the transaction was inserted into the database
epoch	Int8	The epoch of the transaction

user_transactions

Field	Type	Description
version	Int8	version of the user transaction
block_height	Int8	block height at which the transaction was confirmed
parent_signature_type	Varchar	signature type used for the transaction
sender	Varchar	address of the sender of the transaction
sequence_number	Int8	sequence number of the transaction
max_gas_amount	Numeric	maximum gas amount allowed for the transaction to be executed
expiration_timestamp_secs	Timestamp	expiration time of the transaction in seconds
gas_unit_price	Numeric	gas unit price in smallest unit of the currency
timestamp	Timestamp	time at which the transaction was confirmed
entry_function_id_str	Text	string representation of the ID of the entry function of the smart contract being executed
inserted_at	Timestamp	time at which the transaction was inserted in the user_transactions table
epoch	Int8	epoch of the transaction

write_set_changes

Field	Type	Description
transaction_version	Int8	version of the transaction
index	Int8	index of the change in the write set
hash	Varchar	hash of the transaction
transaction_block_height	Int8	block height at which the transaction was confirmed
type_	Text	type of write set change, among delete_resource, delete_table_item, write_module, write_resource, write_table_item
address	Varchar	address of the change in the write set
inserted_at	Timestamp	time at which the change was inserted in the write_set_changes table

Share on Twitter

Analytics web portal​

SQL examples​

Indexer GraphQL​

Indexer database schema​

current_collection_datas​

Analytics web portal

SQL examples

Indexer GraphQL

Indexer database schema

current_collection_datas