Mirror Node (public)
Core Hedera mirror node data: transactions, entities, tokens, NFTs, topics, and contracts.
46 queryable tables. Every table supports the standard Hasura query arguments — where, order_by, limit, offset, distinct_on — plus an _aggregate field.
Access: All plans, including Free
Tables
_transferaddress_bookaddress_book_entryaddress_book_service_endpointassessed_custom_feecontractcontract_actioncontract_logcontract_resultcontract_statecontract_state_changecontract_transactions_last_24hrscrypto_allowancecrypto_allowance_historycrypto_transfercustom_feeentityentity_historyentity_stakeethereum_transactionnetwork_stakenftnft_allowancenft_allowance_historynft_historynode_stakenon_fee_transferprngschedulestaking_reward_transfertokentoken_accounttoken_account_historytoken_airdroptoken_airdrop_historytoken_allowancetoken_allowance_historytoken_historytoken_transfertopictopic_messagetopic_message_lookuptotal_accountstransactiontransaction_signaturetransactions_last_24hrs
_transfer
| Column | Postgres type | GraphQL type |
|---|---|---|
type | transfer_type | transfer_type |
token_id | bigint | bigint |
serial_number | bigint | bigint |
amount | bigint | bigint |
sender_account_id | bigint | bigint |
receiver_account_id | bigint | bigint |
is_approval | boolean | Boolean |
errata | errata_type | errata_type |
consensus_timestamp | bigint | bigint |
query Get_transfer {
_transfer(limit: 10) {
type
token_id
serial_number
amount
}
}
address_book
| Column | Postgres type | GraphQL type |
|---|---|---|
start_consensus_timestamp | bigint | bigint |
end_consensus_timestamp | bigint | bigint |
file_id | bigint | bigint |
node_count | integer | Int |
file_data | bytea | bytea |
query GetAddressBook {
address_book(limit: 10) {
start_consensus_timestamp
end_consensus_timestamp
file_id
node_count
}
}
address_book_entry
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
memo | character varying(128) | String |
public_key | character varying(1024) | String |
node_id | bigint | bigint |
node_account_id | bigint | bigint |
node_cert_hash | bytea | bytea |
description | character varying(100) | String |
stake | bigint | bigint |
query GetAddressBookEntry {
address_book_entry(limit: 10) {
consensus_timestamp
memo
public_key
node_id
}
}
address_book_service_endpoint
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
ip_address_v4 | character varying(15) | String |
node_id | bigint | bigint |
port | integer | Int |
domain_name | character varying(253) | String |
query GetAddressBookServiceEndpoint {
address_book_service_endpoint(limit: 10) {
consensus_timestamp
ip_address_v4
node_id
port
}
}
assessed_custom_fee
| Column | Postgres type | GraphQL type |
|---|---|---|
amount | bigint | bigint |
collector_account_id | bigint | bigint |
consensus_timestamp | bigint | bigint |
token_id | bigint | bigint |
effective_payer_account_ids | bigint[] | [bigint] |
payer_account_id | bigint | bigint |
query GetAssessedCustomFee {
assessed_custom_fee(limit: 10) {
amount
collector_account_id
consensus_timestamp
token_id
}
}
contract
| Column | Postgres type | GraphQL type |
|---|---|---|
id | bigint | bigint |
file_id | bigint | bigint |
initcode | bytea | bytea |
runtime_bytecode | bytea | bytea |
query GetContract {
contract(limit: 10) {
id
file_id
initcode
runtime_bytecode
}
}
contract_action
| Column | Postgres type | GraphQL type |
|---|---|---|
call_depth | integer | Int |
call_type | integer | Int |
caller | bigint | bigint |
caller_type | entity_type | entity_type |
consensus_timestamp | bigint | bigint |
gas | bigint | bigint |
gas_used | bigint | bigint |
index | integer | Int |
input | bytea | bytea |
recipient_account | bigint | bigint |
recipient_address | bytea | bytea |
recipient_contract | bigint | bigint |
result_data | bytea | bytea |
result_data_type | integer | Int |
value | bigint | bigint |
call_operation_type | integer | Int |
payer_account_id | bigint | bigint |
query GetContractAction {
contract_action(limit: 10) {
call_depth
call_type
caller
caller_type
}
}
contract_log
| Column | Postgres type | GraphQL type |
|---|---|---|
bloom | bytea | bytea |
consensus_timestamp | bigint | bigint |
contract_id | bigint | bigint |
data | bytea | bytea |
index | integer | Int |
topic0 | bytea | bytea |
topic1 | bytea | bytea |
topic2 | bytea | bytea |
topic3 | bytea | bytea |
payer_account_id | bigint | bigint |
root_contract_id | bigint | bigint |
transaction_hash | bytea | bytea |
transaction_index | integer | Int |
query GetContractLog {
contract_log(limit: 10) {
bloom
consensus_timestamp
contract_id
data
}
}
contract_result
| Column | Postgres type | GraphQL type |
|---|---|---|
function_parameters | bytea | bytea |
gas_limit | bigint | bigint |
function_result | bytea | bytea |
gas_used | bigint | bigint |
consensus_timestamp | bigint | bigint |
amount | bigint | bigint |
bloom | bytea | bytea |
call_result | bytea | bytea |
contract_id | bigint | bigint |
created_contract_ids | bigint[] | [bigint] |
error_message | text | String |
payer_account_id | bigint | bigint |
sender_id | bigint | bigint |
failed_initcode | bytea | bytea |
transaction_hash | bytea | bytea |
transaction_index | integer | Int |
transaction_result | smallint | smallint |
transaction_nonce | integer | Int |
gas_consumed | bigint | bigint |
query GetContractResult {
contract_result(limit: 10) {
function_parameters
gas_limit
function_result
gas_used
}
}
contract_state
| Column | Postgres type | GraphQL type |
|---|---|---|
contract_id | bigint | bigint |
created_timestamp | bigint | bigint |
modified_timestamp | bigint | bigint |
slot | bytea | bytea |
value | bytea | bytea |
query GetContractState {
contract_state(limit: 10) {
contract_id
created_timestamp
modified_timestamp
slot
}
}
contract_state_change
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
contract_id | bigint | bigint |
payer_account_id | bigint | bigint |
slot | bytea | bytea |
value_read | bytea | bytea |
value_written | bytea | bytea |
migration | boolean | Boolean |
query GetContractStateChange {
contract_state_change(limit: 10) {
consensus_timestamp
contract_id
payer_account_id
slot
}
}
contract_transactions_last_24hrs
| Column | Postgres type | GraphQL type |
|---|---|---|
count | bigint | bigint |
updated_at | timestamptz | timestamptz |
query GetContractTransactionsLast24hrs {
contract_transactions_last_24hrs(limit: 10) {
count
updated_at
}
}
crypto_allowance
| Column | Postgres type | GraphQL type |
|---|---|---|
amount_granted | bigint | bigint |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
amount | bigint | bigint |
query GetCryptoAllowance {
crypto_allowance(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}
crypto_allowance_history
| Column | Postgres type | GraphQL type |
|---|---|---|
amount_granted | bigint | bigint |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
amount | bigint | bigint |
query GetCryptoAllowanceHistory {
crypto_allowance_history(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}
crypto_transfer
| Column | Postgres type | GraphQL type |
|---|---|---|
entity_id | bigint | bigint |
consensus_timestamp | bigint | bigint |
amount | bigint | bigint |
payer_account_id | bigint | bigint |
is_approval | boolean | Boolean |
errata | errata_type | errata_type |
query GetCryptoTransfer {
crypto_transfer(limit: 10) {
entity_id
consensus_timestamp
amount
payer_account_id
}
}
custom_fee
| Column | Postgres type | GraphQL type |
|---|---|---|
fixed_fees | jsonb | jsonb |
fractional_fees | jsonb | jsonb |
royalty_fees | jsonb | jsonb |
timestamp_range | int8range | int8range |
entity_id | bigint | bigint |
query GetCustomFee {
custom_fee(limit: 10) {
fixed_fees
fractional_fees
royalty_fees
timestamp_range
}
}
entity
| Column | Postgres type | GraphQL type |
|---|---|---|
auto_renew_account_id | bigint | bigint |
auto_renew_period | bigint | bigint |
created_timestamp | bigint | bigint |
deleted | boolean | Boolean |
expiration_timestamp | bigint | bigint |
id | bigint | bigint |
key | bytea | bytea |
memo | text | String |
num | bigint | bigint |
public_key | character varying | String |
proxy_account_id | bigint | bigint |
realm | bigint | bigint |
shard | bigint | bigint |
receiver_sig_required | boolean | Boolean |
max_automatic_token_associations | integer | Int |
timestamp_range | int8range | int8range |
type | entity_type | entity_type |
alias | bytea | bytea |
ethereum_nonce | bigint | bigint |
evm_address | bytea | bytea |
decline_reward | boolean | Boolean |
staked_account_id | bigint | bigint |
staked_node_id | bigint | bigint |
stake_period_start | bigint | bigint |
obtainer_id | bigint | bigint |
permanent_removal | boolean | Boolean |
balance | bigint | bigint |
balance_timestamp | bigint | bigint |
query GetEntity {
entity(limit: 10) {
auto_renew_account_id
auto_renew_period
created_timestamp
deleted
}
}
entity_history
| Column | Postgres type | GraphQL type |
|---|---|---|
auto_renew_account_id | bigint | bigint |
auto_renew_period | bigint | bigint |
created_timestamp | bigint | bigint |
deleted | boolean | Boolean |
expiration_timestamp | bigint | bigint |
id | bigint | bigint |
key | bytea | bytea |
memo | text | String |
num | bigint | bigint |
public_key | character varying | String |
proxy_account_id | bigint | bigint |
realm | bigint | bigint |
shard | bigint | bigint |
receiver_sig_required | boolean | Boolean |
max_automatic_token_associations | integer | Int |
timestamp_range | int8range | int8range |
type | entity_type | entity_type |
alias | bytea | bytea |
ethereum_nonce | bigint | bigint |
evm_address | bytea | bytea |
decline_reward | boolean | Boolean |
staked_account_id | bigint | bigint |
staked_node_id | bigint | bigint |
stake_period_start | bigint | bigint |
obtainer_id | bigint | bigint |
permanent_removal | boolean | Boolean |
balance | bigint | bigint |
balance_timestamp | bigint | bigint |
query GetEntityHistory {
entity_history(limit: 10) {
auto_renew_account_id
auto_renew_period
created_timestamp
deleted
}
}
entity_stake
| Column | Postgres type | GraphQL type |
|---|---|---|
end_stake_period | bigint | bigint |
id | bigint | bigint |
pending_reward | bigint | bigint |
staked_node_id_start | bigint | bigint |
staked_to_me | bigint | bigint |
stake_total_start | bigint | bigint |
timestamp_range | int8range | int8range |
query GetEntityStake {
entity_stake(limit: 10) {
end_stake_period
id
pending_reward
staked_node_id_start
}
}
ethereum_transaction
| Column | Postgres type | GraphQL type |
|---|---|---|
access_list | bytea | bytea |
call_data_id | bigint | bigint |
call_data | bytea | bytea |
chain_id | bytea | bytea |
consensus_timestamp | bigint | bigint |
data | bytea | bytea |
gas_limit | bigint | bigint |
gas_price | bytea | bytea |
hash | bytea | bytea |
max_fee_per_gas | bytea | bytea |
max_gas_allowance | bigint | bigint |
max_priority_fee_per_gas | bytea | bytea |
nonce | bigint | bigint |
payer_account_id | bigint | bigint |
recovery_id | smallint | smallint |
signature_r | bytea | bytea |
signature_s | bytea | bytea |
signature_v | bytea | bytea |
to_address | bytea | bytea |
type | smallint | smallint |
value | bytea | bytea |
query GetEthereumTransaction {
ethereum_transaction(limit: 10) {
access_list
call_data_id
call_data
chain_id
}
}
network_stake
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
epoch_day | bigint | bigint |
max_staking_reward_rate_per_hbar | bigint | bigint |
node_reward_fee_denominator | bigint | bigint |
node_reward_fee_numerator | bigint | bigint |
stake_total | bigint | bigint |
staking_period | bigint | bigint |
staking_period_duration | bigint | bigint |
staking_periods_stored | bigint | bigint |
staking_reward_fee_denominator | bigint | bigint |
staking_reward_fee_numerator | bigint | bigint |
staking_reward_rate | bigint | bigint |
staking_start_threshold | bigint | bigint |
max_stake_rewarded | bigint | bigint |
max_total_reward | bigint | bigint |
reserved_staking_rewards | bigint | bigint |
reward_balance_threshold | bigint | bigint |
unreserved_staking_reward_balance | bigint | bigint |
query GetNetworkStake {
network_stake(limit: 10) {
consensus_timestamp
epoch_day
max_staking_reward_rate_per_hbar
node_reward_fee_denominator
}
}
nft
| Column | Postgres type | GraphQL type |
|---|---|---|
account_id | bigint | bigint |
created_timestamp | bigint | bigint |
deleted | boolean | Boolean |
metadata | bytea | bytea |
serial_number | bigint | bigint |
token_id | bigint | bigint |
delegating_spender | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
query GetNft {
nft(limit: 10) {
account_id
created_timestamp
deleted
metadata
}
}
nft_allowance
| Column | Postgres type | GraphQL type |
|---|---|---|
approved_for_all | boolean | Boolean |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
query GetNftAllowance {
nft_allowance(limit: 10) {
approved_for_all
owner
payer_account_id
spender
}
}
nft_allowance_history
| Column | Postgres type | GraphQL type |
|---|---|---|
approved_for_all | boolean | Boolean |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
query GetNftAllowanceHistory {
nft_allowance_history(limit: 10) {
approved_for_all
owner
payer_account_id
spender
}
}
nft_history
| Column | Postgres type | GraphQL type |
|---|---|---|
account_id | bigint | bigint |
created_timestamp | bigint | bigint |
deleted | boolean | Boolean |
metadata | bytea | bytea |
serial_number | bigint | bigint |
token_id | bigint | bigint |
delegating_spender | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
start_timestamp | bigint | bigint |
end_timestamp | bigint | bigint |
query GetNftHistory {
nft_history(limit: 10) {
account_id
created_timestamp
deleted
metadata
}
}
node_stake
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
epoch_day | bigint | bigint |
node_id | bigint | bigint |
reward_rate | bigint | bigint |
stake | bigint | bigint |
stake_rewarded | bigint | bigint |
staking_period | bigint | bigint |
max_stake | bigint | bigint |
min_stake | bigint | bigint |
stake_not_rewarded | bigint | bigint |
query GetNodeStake {
node_stake(limit: 10) {
consensus_timestamp
epoch_day
node_id
reward_rate
}
}
non_fee_transfer
| Column | Postgres type | GraphQL type |
|---|---|---|
entity_id | bigint | bigint |
consensus_timestamp | bigint | bigint |
amount | bigint | bigint |
payer_account_id | bigint | bigint |
is_approval | boolean | Boolean |
query GetNonFeeTransfer {
non_fee_transfer(limit: 10) {
entity_id
consensus_timestamp
amount
payer_account_id
}
}
prng
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
range | integer | Int |
prng_bytes | bytea | bytea |
prng_number | integer | Int |
payer_account_id | bigint | bigint |
query GetPrng {
prng(limit: 10) {
consensus_timestamp
range
prng_bytes
prng_number
}
}
schedule
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
creator_account_id | bigint | bigint |
executed_timestamp | bigint | bigint |
payer_account_id | bigint | bigint |
schedule_id | bigint | bigint |
transaction_body | bytea | bytea |
expiration_time | bigint | bigint |
wait_for_expiry | boolean | Boolean |
query GetSchedule {
schedule(limit: 10) {
consensus_timestamp
creator_account_id
executed_timestamp
payer_account_id
}
}
staking_reward_transfer
| Column | Postgres type | GraphQL type |
|---|---|---|
account_id | bigint | bigint |
amount | bigint | bigint |
consensus_timestamp | bigint | bigint |
payer_account_id | bigint | bigint |
query GetStakingRewardTransfer {
staking_reward_transfer(limit: 10) {
account_id
amount
consensus_timestamp
payer_account_id
}
}
token
| Column | Postgres type | GraphQL type |
|---|---|---|
token_id | bigint | bigint |
created_timestamp | bigint | bigint |
decimals | bigint | bigint |
freeze_default | boolean | Boolean |
freeze_key | bytea | bytea |
initial_supply | bigint | bigint |
kyc_key | bytea | bytea |
name | character varying(100) | String |
supply_key | bytea | bytea |
symbol | character varying(100) | String |
total_supply | bigint | bigint |
treasury_account_id | bigint | bigint |
wipe_key | bytea | bytea |
max_supply | bigint | bigint |
supply_type | token_supply_type | token_supply_type |
type | token_type | token_type |
fee_schedule_key | bytea | bytea |
pause_key | bytea | bytea |
pause_status | token_pause_status | token_pause_status |
timestamp_range | int8range | int8range |
freeze_status | smallint | smallint |
kyc_status | smallint | smallint |
metadata | bytea | bytea |
metadata_key | bytea | bytea |
query GetToken {
token(limit: 10) {
token_id
created_timestamp
decimals
freeze_default
}
}
token_account
| Column | Postgres type | GraphQL type |
|---|---|---|
account_id | bigint | bigint |
associated | boolean | Boolean |
automatic_association | boolean | Boolean |
created_timestamp | bigint | bigint |
freeze_status | smallint | smallint |
kyc_status | smallint | smallint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
balance | bigint | bigint |
balance_timestamp | bigint | bigint |
query GetTokenAccount {
token_account(limit: 10) {
account_id
associated
automatic_association
created_timestamp
}
}
token_account_history
| Column | Postgres type | GraphQL type |
|---|---|---|
account_id | bigint | bigint |
associated | boolean | Boolean |
automatic_association | boolean | Boolean |
created_timestamp | bigint | bigint |
freeze_status | smallint | smallint |
kyc_status | smallint | smallint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
balance | bigint | bigint |
balance_timestamp | bigint | bigint |
query GetTokenAccountHistory {
token_account_history(limit: 10) {
account_id
associated
automatic_association
created_timestamp
}
}
token_airdrop
| Column | Postgres type | GraphQL type |
|---|---|---|
amount | bigint | bigint |
receiver_account_id | bigint | bigint |
sender_account_id | bigint | bigint |
serial_number | bigint | bigint |
state | airdrop_state | airdrop_state |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
query GetTokenAirdrop {
token_airdrop(limit: 10) {
amount
receiver_account_id
sender_account_id
serial_number
}
}
token_airdrop_history
| Column | Postgres type | GraphQL type |
|---|---|---|
amount | bigint | bigint |
receiver_account_id | bigint | bigint |
sender_account_id | bigint | bigint |
serial_number | bigint | bigint |
state | airdrop_state | airdrop_state |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
query GetTokenAirdropHistory {
token_airdrop_history(limit: 10) {
amount
receiver_account_id
sender_account_id
serial_number
}
}
token_allowance
| Column | Postgres type | GraphQL type |
|---|---|---|
amount_granted | bigint | bigint |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
amount | bigint | bigint |
query GetTokenAllowance {
token_allowance(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}
token_allowance_history
| Column | Postgres type | GraphQL type |
|---|---|---|
amount_granted | bigint | bigint |
owner | bigint | bigint |
payer_account_id | bigint | bigint |
spender | bigint | bigint |
timestamp_range | int8range | int8range |
token_id | bigint | bigint |
amount | bigint | bigint |
query GetTokenAllowanceHistory {
token_allowance_history(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}
token_history
| Column | Postgres type | GraphQL type |
|---|---|---|
token_id | bigint | bigint |
created_timestamp | bigint | bigint |
decimals | bigint | bigint |
freeze_default | boolean | Boolean |
freeze_key | bytea | bytea |
initial_supply | bigint | bigint |
kyc_key | bytea | bytea |
name | character varying(100) | String |
supply_key | bytea | bytea |
symbol | character varying(100) | String |
total_supply | bigint | bigint |
treasury_account_id | bigint | bigint |
wipe_key | bytea | bytea |
max_supply | bigint | bigint |
supply_type | token_supply_type | token_supply_type |
type | token_type | token_type |
fee_schedule_key | bytea | bytea |
pause_key | bytea | bytea |
pause_status | token_pause_status | token_pause_status |
timestamp_range | int8range | int8range |
freeze_status | smallint | smallint |
kyc_status | smallint | smallint |
metadata | bytea | bytea |
metadata_key | bytea | bytea |
query GetTokenHistory {
token_history(limit: 10) {
token_id
created_timestamp
decimals
freeze_default
}
}
token_transfer
| Column | Postgres type | GraphQL type |
|---|---|---|
token_id | bigint | bigint |
account_id | bigint | bigint |
consensus_timestamp | bigint | bigint |
amount | bigint | bigint |
payer_account_id | bigint | bigint |
is_approval | boolean | Boolean |
query GetTokenTransfer {
token_transfer(limit: 10) {
token_id
account_id
consensus_timestamp
amount
}
}
topic
| Column | Postgres type | GraphQL type |
|---|---|---|
admin_key | bytea | bytea |
created_timestamp | bigint | bigint |
id | bigint | bigint |
fee_exempt_key_list | bytea | bytea |
fee_schedule_key | bytea | bytea |
submit_key | bytea | bytea |
timestamp_range | int8range | int8range |
query GetTopic {
topic(limit: 10) {
admin_key
created_timestamp
id
fee_exempt_key_list
}
}
topic_message
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
message | bytea | bytea |
running_hash | bytea | bytea |
sequence_number | bigint | bigint |
running_hash_version | smallint | smallint |
chunk_num | integer | Int |
chunk_total | integer | Int |
payer_account_id | bigint | bigint |
valid_start_timestamp | bigint | bigint |
topic_id | bigint | bigint |
initial_transaction_id | bytea | bytea |
query GetTopicMessage {
topic_message(limit: 10) {
consensus_timestamp
message
running_hash
sequence_number
}
}
topic_message_lookup
| Column | Postgres type | GraphQL type |
|---|---|---|
partition | text | String |
sequence_number_range | int8range | int8range |
timestamp_range | int8range | int8range |
topic_id | bigint | bigint |
query GetTopicMessageLookup {
topic_message_lookup(limit: 10) {
partition
sequence_number_range
timestamp_range
topic_id
}
}
total_accounts
| Column | Postgres type | GraphQL type |
|---|---|---|
count | bigint | bigint |
updated_at | timestamptz | timestamptz |
query GetTotalAccounts {
total_accounts(limit: 10) {
count
updated_at
}
}
transaction
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
type | smallint | smallint |
result | smallint | smallint |
payer_account_id | bigint | bigint |
valid_start_ns | bigint | bigint |
valid_duration_seconds | bigint | bigint |
node_account_id | bigint | bigint |
entity_id | bigint | bigint |
initial_balance | bigint | bigint |
max_fee | bigint | bigint |
charged_tx_fee | bigint | bigint |
memo | bytea | bytea |
transaction_hash | bytea | bytea |
transaction_bytes | bytea | bytea |
scheduled | boolean | Boolean |
nonce | integer | Int |
parent_consensus_timestamp | bigint | bigint |
errata | errata_type | errata_type |
index | integer | Int |
nft_transfer | jsonb | jsonb |
itemized_transfer | jsonb | jsonb |
transaction_record_bytes | bytea | bytea |
max_custom_fees | bytea[] | [bytea] |
batch_key | bytea | bytea |
inner_transactions | bigint[] | [bigint] |
query GetTransaction {
transaction(limit: 10) {
consensus_timestamp
type
result
payer_account_id
}
}
transaction_signature
| Column | Postgres type | GraphQL type |
|---|---|---|
consensus_timestamp | bigint | bigint |
public_key_prefix | bytea | bytea |
entity_id | bigint | bigint |
signature | bytea | bytea |
type | smallint | smallint |
query GetTransactionSignature {
transaction_signature(limit: 10) {
consensus_timestamp
public_key_prefix
entity_id
signature
}
}
transactions_last_24hrs
| Column | Postgres type | GraphQL type |
|---|---|---|
count | bigint | bigint |
updated_at | timestamptz | timestamptz |
query GetTransactionsLast24hrs {
transactions_last_24hrs(limit: 10) {
count
updated_at
}
}