Skip to main content

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

_transfer

ColumnPostgres typeGraphQL type
typetransfer_typetransfer_type
token_idbigintbigint
serial_numberbigintbigint
amountbigintbigint
sender_account_idbigintbigint
receiver_account_idbigintbigint
is_approvalbooleanBoolean
errataerrata_typeerrata_type
consensus_timestampbigintbigint
query Get_transfer {
_transfer(limit: 10) {
type
token_id
serial_number
amount
}
}

address_book

ColumnPostgres typeGraphQL type
start_consensus_timestampbigintbigint
end_consensus_timestampbigintbigint
file_idbigintbigint
node_countintegerInt
file_databyteabytea
query GetAddressBook {
address_book(limit: 10) {
start_consensus_timestamp
end_consensus_timestamp
file_id
node_count
}
}

address_book_entry

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
memocharacter varying(128)String
public_keycharacter varying(1024)String
node_idbigintbigint
node_account_idbigintbigint
node_cert_hashbyteabytea
descriptioncharacter varying(100)String
stakebigintbigint
query GetAddressBookEntry {
address_book_entry(limit: 10) {
consensus_timestamp
memo
public_key
node_id
}
}

address_book_service_endpoint

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
ip_address_v4character varying(15)String
node_idbigintbigint
portintegerInt
domain_namecharacter varying(253)String
query GetAddressBookServiceEndpoint {
address_book_service_endpoint(limit: 10) {
consensus_timestamp
ip_address_v4
node_id
port
}
}

assessed_custom_fee

ColumnPostgres typeGraphQL type
amountbigintbigint
collector_account_idbigintbigint
consensus_timestampbigintbigint
token_idbigintbigint
effective_payer_account_idsbigint[][bigint]
payer_account_idbigintbigint
query GetAssessedCustomFee {
assessed_custom_fee(limit: 10) {
amount
collector_account_id
consensus_timestamp
token_id
}
}

contract

ColumnPostgres typeGraphQL type
idbigintbigint
file_idbigintbigint
initcodebyteabytea
runtime_bytecodebyteabytea
query GetContract {
contract(limit: 10) {
id
file_id
initcode
runtime_bytecode
}
}

contract_action

ColumnPostgres typeGraphQL type
call_depthintegerInt
call_typeintegerInt
callerbigintbigint
caller_typeentity_typeentity_type
consensus_timestampbigintbigint
gasbigintbigint
gas_usedbigintbigint
indexintegerInt
inputbyteabytea
recipient_accountbigintbigint
recipient_addressbyteabytea
recipient_contractbigintbigint
result_databyteabytea
result_data_typeintegerInt
valuebigintbigint
call_operation_typeintegerInt
payer_account_idbigintbigint
query GetContractAction {
contract_action(limit: 10) {
call_depth
call_type
caller
caller_type
}
}

contract_log

ColumnPostgres typeGraphQL type
bloombyteabytea
consensus_timestampbigintbigint
contract_idbigintbigint
databyteabytea
indexintegerInt
topic0byteabytea
topic1byteabytea
topic2byteabytea
topic3byteabytea
payer_account_idbigintbigint
root_contract_idbigintbigint
transaction_hashbyteabytea
transaction_indexintegerInt
query GetContractLog {
contract_log(limit: 10) {
bloom
consensus_timestamp
contract_id
data
}
}

contract_result

ColumnPostgres typeGraphQL type
function_parametersbyteabytea
gas_limitbigintbigint
function_resultbyteabytea
gas_usedbigintbigint
consensus_timestampbigintbigint
amountbigintbigint
bloombyteabytea
call_resultbyteabytea
contract_idbigintbigint
created_contract_idsbigint[][bigint]
error_messagetextString
payer_account_idbigintbigint
sender_idbigintbigint
failed_initcodebyteabytea
transaction_hashbyteabytea
transaction_indexintegerInt
transaction_resultsmallintsmallint
transaction_nonceintegerInt
gas_consumedbigintbigint
query GetContractResult {
contract_result(limit: 10) {
function_parameters
gas_limit
function_result
gas_used
}
}

contract_state

ColumnPostgres typeGraphQL type
contract_idbigintbigint
created_timestampbigintbigint
modified_timestampbigintbigint
slotbyteabytea
valuebyteabytea
query GetContractState {
contract_state(limit: 10) {
contract_id
created_timestamp
modified_timestamp
slot
}
}

contract_state_change

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
contract_idbigintbigint
payer_account_idbigintbigint
slotbyteabytea
value_readbyteabytea
value_writtenbyteabytea
migrationbooleanBoolean
query GetContractStateChange {
contract_state_change(limit: 10) {
consensus_timestamp
contract_id
payer_account_id
slot
}
}

contract_transactions_last_24hrs

ColumnPostgres typeGraphQL type
countbigintbigint
updated_attimestamptztimestamptz
query GetContractTransactionsLast24hrs {
contract_transactions_last_24hrs(limit: 10) {
count
updated_at
}
}

crypto_allowance

ColumnPostgres typeGraphQL type
amount_grantedbigintbigint
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
amountbigintbigint
query GetCryptoAllowance {
crypto_allowance(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}

crypto_allowance_history

ColumnPostgres typeGraphQL type
amount_grantedbigintbigint
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
amountbigintbigint
query GetCryptoAllowanceHistory {
crypto_allowance_history(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}

crypto_transfer

ColumnPostgres typeGraphQL type
entity_idbigintbigint
consensus_timestampbigintbigint
amountbigintbigint
payer_account_idbigintbigint
is_approvalbooleanBoolean
errataerrata_typeerrata_type
query GetCryptoTransfer {
crypto_transfer(limit: 10) {
entity_id
consensus_timestamp
amount
payer_account_id
}
}

custom_fee

ColumnPostgres typeGraphQL type
fixed_feesjsonbjsonb
fractional_feesjsonbjsonb
royalty_feesjsonbjsonb
timestamp_rangeint8rangeint8range
entity_idbigintbigint
query GetCustomFee {
custom_fee(limit: 10) {
fixed_fees
fractional_fees
royalty_fees
timestamp_range
}
}

entity

ColumnPostgres typeGraphQL type
auto_renew_account_idbigintbigint
auto_renew_periodbigintbigint
created_timestampbigintbigint
deletedbooleanBoolean
expiration_timestampbigintbigint
idbigintbigint
keybyteabytea
memotextString
numbigintbigint
public_keycharacter varyingString
proxy_account_idbigintbigint
realmbigintbigint
shardbigintbigint
receiver_sig_requiredbooleanBoolean
max_automatic_token_associationsintegerInt
timestamp_rangeint8rangeint8range
typeentity_typeentity_type
aliasbyteabytea
ethereum_noncebigintbigint
evm_addressbyteabytea
decline_rewardbooleanBoolean
staked_account_idbigintbigint
staked_node_idbigintbigint
stake_period_startbigintbigint
obtainer_idbigintbigint
permanent_removalbooleanBoolean
balancebigintbigint
balance_timestampbigintbigint
query GetEntity {
entity(limit: 10) {
auto_renew_account_id
auto_renew_period
created_timestamp
deleted
}
}

entity_history

ColumnPostgres typeGraphQL type
auto_renew_account_idbigintbigint
auto_renew_periodbigintbigint
created_timestampbigintbigint
deletedbooleanBoolean
expiration_timestampbigintbigint
idbigintbigint
keybyteabytea
memotextString
numbigintbigint
public_keycharacter varyingString
proxy_account_idbigintbigint
realmbigintbigint
shardbigintbigint
receiver_sig_requiredbooleanBoolean
max_automatic_token_associationsintegerInt
timestamp_rangeint8rangeint8range
typeentity_typeentity_type
aliasbyteabytea
ethereum_noncebigintbigint
evm_addressbyteabytea
decline_rewardbooleanBoolean
staked_account_idbigintbigint
staked_node_idbigintbigint
stake_period_startbigintbigint
obtainer_idbigintbigint
permanent_removalbooleanBoolean
balancebigintbigint
balance_timestampbigintbigint
query GetEntityHistory {
entity_history(limit: 10) {
auto_renew_account_id
auto_renew_period
created_timestamp
deleted
}
}

entity_stake

ColumnPostgres typeGraphQL type
end_stake_periodbigintbigint
idbigintbigint
pending_rewardbigintbigint
staked_node_id_startbigintbigint
staked_to_mebigintbigint
stake_total_startbigintbigint
timestamp_rangeint8rangeint8range
query GetEntityStake {
entity_stake(limit: 10) {
end_stake_period
id
pending_reward
staked_node_id_start
}
}

ethereum_transaction

ColumnPostgres typeGraphQL type
access_listbyteabytea
call_data_idbigintbigint
call_databyteabytea
chain_idbyteabytea
consensus_timestampbigintbigint
databyteabytea
gas_limitbigintbigint
gas_pricebyteabytea
hashbyteabytea
max_fee_per_gasbyteabytea
max_gas_allowancebigintbigint
max_priority_fee_per_gasbyteabytea
noncebigintbigint
payer_account_idbigintbigint
recovery_idsmallintsmallint
signature_rbyteabytea
signature_sbyteabytea
signature_vbyteabytea
to_addressbyteabytea
typesmallintsmallint
valuebyteabytea
query GetEthereumTransaction {
ethereum_transaction(limit: 10) {
access_list
call_data_id
call_data
chain_id
}
}

network_stake

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
epoch_daybigintbigint
max_staking_reward_rate_per_hbarbigintbigint
node_reward_fee_denominatorbigintbigint
node_reward_fee_numeratorbigintbigint
stake_totalbigintbigint
staking_periodbigintbigint
staking_period_durationbigintbigint
staking_periods_storedbigintbigint
staking_reward_fee_denominatorbigintbigint
staking_reward_fee_numeratorbigintbigint
staking_reward_ratebigintbigint
staking_start_thresholdbigintbigint
max_stake_rewardedbigintbigint
max_total_rewardbigintbigint
reserved_staking_rewardsbigintbigint
reward_balance_thresholdbigintbigint
unreserved_staking_reward_balancebigintbigint
query GetNetworkStake {
network_stake(limit: 10) {
consensus_timestamp
epoch_day
max_staking_reward_rate_per_hbar
node_reward_fee_denominator
}
}

nft

ColumnPostgres typeGraphQL type
account_idbigintbigint
created_timestampbigintbigint
deletedbooleanBoolean
metadatabyteabytea
serial_numberbigintbigint
token_idbigintbigint
delegating_spenderbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
query GetNft {
nft(limit: 10) {
account_id
created_timestamp
deleted
metadata
}
}

nft_allowance

ColumnPostgres typeGraphQL type
approved_for_allbooleanBoolean
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
token_idbigintbigint
query GetNftAllowance {
nft_allowance(limit: 10) {
approved_for_all
owner
payer_account_id
spender
}
}

nft_allowance_history

ColumnPostgres typeGraphQL type
approved_for_allbooleanBoolean
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
token_idbigintbigint
query GetNftAllowanceHistory {
nft_allowance_history(limit: 10) {
approved_for_all
owner
payer_account_id
spender
}
}

nft_history

ColumnPostgres typeGraphQL type
account_idbigintbigint
created_timestampbigintbigint
deletedbooleanBoolean
metadatabyteabytea
serial_numberbigintbigint
token_idbigintbigint
delegating_spenderbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
start_timestampbigintbigint
end_timestampbigintbigint
query GetNftHistory {
nft_history(limit: 10) {
account_id
created_timestamp
deleted
metadata
}
}

node_stake

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
epoch_daybigintbigint
node_idbigintbigint
reward_ratebigintbigint
stakebigintbigint
stake_rewardedbigintbigint
staking_periodbigintbigint
max_stakebigintbigint
min_stakebigintbigint
stake_not_rewardedbigintbigint
query GetNodeStake {
node_stake(limit: 10) {
consensus_timestamp
epoch_day
node_id
reward_rate
}
}

non_fee_transfer

ColumnPostgres typeGraphQL type
entity_idbigintbigint
consensus_timestampbigintbigint
amountbigintbigint
payer_account_idbigintbigint
is_approvalbooleanBoolean
query GetNonFeeTransfer {
non_fee_transfer(limit: 10) {
entity_id
consensus_timestamp
amount
payer_account_id
}
}

prng

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
rangeintegerInt
prng_bytesbyteabytea
prng_numberintegerInt
payer_account_idbigintbigint
query GetPrng {
prng(limit: 10) {
consensus_timestamp
range
prng_bytes
prng_number
}
}

schedule

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
creator_account_idbigintbigint
executed_timestampbigintbigint
payer_account_idbigintbigint
schedule_idbigintbigint
transaction_bodybyteabytea
expiration_timebigintbigint
wait_for_expirybooleanBoolean
query GetSchedule {
schedule(limit: 10) {
consensus_timestamp
creator_account_id
executed_timestamp
payer_account_id
}
}

staking_reward_transfer

ColumnPostgres typeGraphQL type
account_idbigintbigint
amountbigintbigint
consensus_timestampbigintbigint
payer_account_idbigintbigint
query GetStakingRewardTransfer {
staking_reward_transfer(limit: 10) {
account_id
amount
consensus_timestamp
payer_account_id
}
}

token

ColumnPostgres typeGraphQL type
token_idbigintbigint
created_timestampbigintbigint
decimalsbigintbigint
freeze_defaultbooleanBoolean
freeze_keybyteabytea
initial_supplybigintbigint
kyc_keybyteabytea
namecharacter varying(100)String
supply_keybyteabytea
symbolcharacter varying(100)String
total_supplybigintbigint
treasury_account_idbigintbigint
wipe_keybyteabytea
max_supplybigintbigint
supply_typetoken_supply_typetoken_supply_type
typetoken_typetoken_type
fee_schedule_keybyteabytea
pause_keybyteabytea
pause_statustoken_pause_statustoken_pause_status
timestamp_rangeint8rangeint8range
freeze_statussmallintsmallint
kyc_statussmallintsmallint
metadatabyteabytea
metadata_keybyteabytea
query GetToken {
token(limit: 10) {
token_id
created_timestamp
decimals
freeze_default
}
}

token_account

ColumnPostgres typeGraphQL type
account_idbigintbigint
associatedbooleanBoolean
automatic_associationbooleanBoolean
created_timestampbigintbigint
freeze_statussmallintsmallint
kyc_statussmallintsmallint
timestamp_rangeint8rangeint8range
token_idbigintbigint
balancebigintbigint
balance_timestampbigintbigint
query GetTokenAccount {
token_account(limit: 10) {
account_id
associated
automatic_association
created_timestamp
}
}

token_account_history

ColumnPostgres typeGraphQL type
account_idbigintbigint
associatedbooleanBoolean
automatic_associationbooleanBoolean
created_timestampbigintbigint
freeze_statussmallintsmallint
kyc_statussmallintsmallint
timestamp_rangeint8rangeint8range
token_idbigintbigint
balancebigintbigint
balance_timestampbigintbigint
query GetTokenAccountHistory {
token_account_history(limit: 10) {
account_id
associated
automatic_association
created_timestamp
}
}

token_airdrop

ColumnPostgres typeGraphQL type
amountbigintbigint
receiver_account_idbigintbigint
sender_account_idbigintbigint
serial_numberbigintbigint
stateairdrop_stateairdrop_state
timestamp_rangeint8rangeint8range
token_idbigintbigint
query GetTokenAirdrop {
token_airdrop(limit: 10) {
amount
receiver_account_id
sender_account_id
serial_number
}
}

token_airdrop_history

ColumnPostgres typeGraphQL type
amountbigintbigint
receiver_account_idbigintbigint
sender_account_idbigintbigint
serial_numberbigintbigint
stateairdrop_stateairdrop_state
timestamp_rangeint8rangeint8range
token_idbigintbigint
query GetTokenAirdropHistory {
token_airdrop_history(limit: 10) {
amount
receiver_account_id
sender_account_id
serial_number
}
}

token_allowance

ColumnPostgres typeGraphQL type
amount_grantedbigintbigint
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
token_idbigintbigint
amountbigintbigint
query GetTokenAllowance {
token_allowance(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}

token_allowance_history

ColumnPostgres typeGraphQL type
amount_grantedbigintbigint
ownerbigintbigint
payer_account_idbigintbigint
spenderbigintbigint
timestamp_rangeint8rangeint8range
token_idbigintbigint
amountbigintbigint
query GetTokenAllowanceHistory {
token_allowance_history(limit: 10) {
amount_granted
owner
payer_account_id
spender
}
}

token_history

ColumnPostgres typeGraphQL type
token_idbigintbigint
created_timestampbigintbigint
decimalsbigintbigint
freeze_defaultbooleanBoolean
freeze_keybyteabytea
initial_supplybigintbigint
kyc_keybyteabytea
namecharacter varying(100)String
supply_keybyteabytea
symbolcharacter varying(100)String
total_supplybigintbigint
treasury_account_idbigintbigint
wipe_keybyteabytea
max_supplybigintbigint
supply_typetoken_supply_typetoken_supply_type
typetoken_typetoken_type
fee_schedule_keybyteabytea
pause_keybyteabytea
pause_statustoken_pause_statustoken_pause_status
timestamp_rangeint8rangeint8range
freeze_statussmallintsmallint
kyc_statussmallintsmallint
metadatabyteabytea
metadata_keybyteabytea
query GetTokenHistory {
token_history(limit: 10) {
token_id
created_timestamp
decimals
freeze_default
}
}

token_transfer

ColumnPostgres typeGraphQL type
token_idbigintbigint
account_idbigintbigint
consensus_timestampbigintbigint
amountbigintbigint
payer_account_idbigintbigint
is_approvalbooleanBoolean
query GetTokenTransfer {
token_transfer(limit: 10) {
token_id
account_id
consensus_timestamp
amount
}
}

topic

ColumnPostgres typeGraphQL type
admin_keybyteabytea
created_timestampbigintbigint
idbigintbigint
fee_exempt_key_listbyteabytea
fee_schedule_keybyteabytea
submit_keybyteabytea
timestamp_rangeint8rangeint8range
query GetTopic {
topic(limit: 10) {
admin_key
created_timestamp
id
fee_exempt_key_list
}
}

topic_message

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
messagebyteabytea
running_hashbyteabytea
sequence_numberbigintbigint
running_hash_versionsmallintsmallint
chunk_numintegerInt
chunk_totalintegerInt
payer_account_idbigintbigint
valid_start_timestampbigintbigint
topic_idbigintbigint
initial_transaction_idbyteabytea
query GetTopicMessage {
topic_message(limit: 10) {
consensus_timestamp
message
running_hash
sequence_number
}
}

topic_message_lookup

ColumnPostgres typeGraphQL type
partitiontextString
sequence_number_rangeint8rangeint8range
timestamp_rangeint8rangeint8range
topic_idbigintbigint
query GetTopicMessageLookup {
topic_message_lookup(limit: 10) {
partition
sequence_number_range
timestamp_range
topic_id
}
}

total_accounts

ColumnPostgres typeGraphQL type
countbigintbigint
updated_attimestamptztimestamptz
query GetTotalAccounts {
total_accounts(limit: 10) {
count
updated_at
}
}

transaction

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
typesmallintsmallint
resultsmallintsmallint
payer_account_idbigintbigint
valid_start_nsbigintbigint
valid_duration_secondsbigintbigint
node_account_idbigintbigint
entity_idbigintbigint
initial_balancebigintbigint
max_feebigintbigint
charged_tx_feebigintbigint
memobyteabytea
transaction_hashbyteabytea
transaction_bytesbyteabytea
scheduledbooleanBoolean
nonceintegerInt
parent_consensus_timestampbigintbigint
errataerrata_typeerrata_type
indexintegerInt
nft_transferjsonbjsonb
itemized_transferjsonbjsonb
transaction_record_bytesbyteabytea
max_custom_feesbytea[][bytea]
batch_keybyteabytea
inner_transactionsbigint[][bigint]
query GetTransaction {
transaction(limit: 10) {
consensus_timestamp
type
result
payer_account_id
}
}

transaction_signature

ColumnPostgres typeGraphQL type
consensus_timestampbigintbigint
public_key_prefixbyteabytea
entity_idbigintbigint
signaturebyteabytea
typesmallintsmallint
query GetTransactionSignature {
transaction_signature(limit: 10) {
consensus_timestamp
public_key_prefix
entity_id
signature
}
}

transactions_last_24hrs

ColumnPostgres typeGraphQL type
countbigintbigint
updated_attimestamptztimestamptz
query GetTransactionsLast24hrs {
transactions_last_24hrs(limit: 10) {
count
updated_at
}
}