• Core
  • ACCOUNTS
  • BLOCKS
  • MICROBLOCKS
  • BURNCHAIN_REWARDS
  • MINER_REWARDS
  • CONTRACT_LOGS
  • LAST_BLOCK
  • TRANSACTIONS
  • TXS
  • SMART_CONTRACTS
  • FUNCTION_CALLS
  • FUNCTION_ARGS
  • POST_CONDITIONS
  • TOKEN_PROPERTIES
  • POX
  • POX2_EVENTS
  • POX3_EVENTS

Core

ACCOUNTS

A view of all wallets in Stacks blockchain with total STX balance as of now.

Column	Type	Description
account	text	STX wallet address
total	numeric	Total STX balance

BLOCKS

All successfully mined blocks. Alternative blocks are not included.

Column	Type	Description
block_hash	text	Block hash (as “0x…”)
block_id	binary	Block hash in binary form
block_time	timestamp	UTC timestamp
block_height	integer	The height of the block
burn_block_time	integer	epoch
burn_block_hash	binary
miner_txid	binary

MICROBLOCKS

All successfully mined microblocks.

Column Name	Type	Description
id	bigint
receive_timestamp	timestamp without time zone
canonical	boolean
microblock_canonical	boolean
microblock_hash	bytea
microblock_sequence	integer
microblock_parent_hash	bytea
index_block_hash	bytea
parent_index_block_hash	bytea
block_height	integer
parent_block_height	integer
parent_block_hash	bytea	Yes
parent_burn_block_height	integer
parent_burn_block_time	integer
parent_burn_block_hash	bytea
block_hash	bytea

BURNCHAIN_REWARDS

Miner rewards table

Column	Type	Description
burn_block_hash	text	Burnchain block hash (as “0x…”)
burn_block_height	integer
burn_amount	numeric
reward_recipient	text
reward_amount	numeric
reward_index	integer

MINER_REWARDS

Column Name	Type	Description
id	integer
block_hash	bytea
index_block_hash	bytea
from_index_block_hash	bytea
mature_block_height	integer
canonical	boolean
recipient	text
miner_address	text
coinbase_amount	numeric
tx_fees_anchored	numeric
tx_fees_streamed_confirmed	numeric
tx_fees_streamed_produced	numeric

CONTRACT_LOGS

Logs emitted by smart contracts

Column Name	Data Type	Description
tx_hash	text	tx hash (as “0x…”)
id	integer
event_index	integer
tx_id	bytea	tx hash as byte array
tx_index	smallint
block_height	integer
index_block_hash	bytea
parent_index_block_hash	bytea
microblock_hash	bytea
microblock_sequence	integer
microblock_canonical	boolean
canonical	boolean
contract_identifier	text
topic	text
value	jsonb

LAST_BLOCK

A special table with only one row: latest successful block

Column	Type	Description
block_hash	text	Block hash (as “0x…”)
block_id	binary	Block hash in binary form
block_height	integer	The height of the block
burn_block_time	integer	epoch
burn_block_hash	binary
miner_txid	binary

TRANSACTIONS

For types of transactions check stacks documentation.

Column	Type	Description
tx_type	text	token transfer, smart contract, contract call, poison, or coinbase
block_time	timestamp	UTC time of the transaction’s block
tx_hash	text	Transaction hash (as “0x…”)
tx_id	binary	Transaction hash in binary form
block_hash	text	Corresponding block’s hash
block_height	integer	Corresponding block’s height
status	integer	1 for success, -1 for failed (aborted), -2 for failed (reverted due to post conditions)
sender_address	text	The address of transaction initiator
token_transfer_recipient_address	text	The transfer recipient (for token transfer tx type)
token_transfer_amount	text	The transfer amount in ustx (for token transfer tx type)
token_transfer_memo	text	Optional memo
contract_call_contract_id	text	The id of the contract (for contract call tx type)
contract_call_function_name	text	The name of the function (for contract call tx type)
smart_contract_contract_id	text	The id of the contract to be deployed (for smart contract tx type)
smart_contract_source_code	text	The source code to be deployed (for smart contract tx type)
microblock_sequence	integer	Corresponding microblock’s sequence (2147483647 for coinbase)
tx_index	integer	The index within the corresponding microblock
id	integer	Internal transaction id, convenient for proper ordering.

TXS

Same as transactions with an additional row for the raw hex encoded serialized transaction.

Column	Type	Description
raw_tx	binary	Raw transaction content

SMART_CONTRACTS

All successfully deployed smart contracts.

Column	Type	Description
tx_hash	text	Deployment transaction hash
contract_id	text	Contract readable id
block_height	integer	Deployment block height
source_code	text	The source code of the contract
abi	json	The ABI of the contract

FUNCTION_CALLS

All smart contract function calls with arguments in JSON format.

Column Name	Data Type	Description
tx_hash	text
contract_id	text
fname	text
args	jsonb
block_height	integer

FUNCTION_ARGS

A helper table with parameters passed to the contract’s functions

Column	Type	Description
tx_hash	text	Function call transaction hash
name	text	The name of the parameter
type	text	The type of the parameter
repr	text	The string representation of the parameter passed to the function

POST_CONDITIONS

A helper table with post-conditions of contracts’ functions. This table contains a row per each post-condition in a transaction.

Column	Type	Description
tx_hash	text	Function call transaction hash
condition_index	integer
repr	json	post conditions in JSON format, see post_conditions under mempool.md

TOKEN_PROPERTIES

A helper table with all existing token properties such as symbol and decimals. Could be helpful for joining FT_EVENTS.

Column	Type	Description
contract	text	shorter contract name (like SP1YK770QXSJY7G1SJD664CQKQGWM2N25DBFTMBMB.token-wstx)
contract_id	text	full name (like SP1YK770QXSJY7G1SJD664CQKQGWM2N25DBFTMBMB.token-wstx::wstx)
properties	json	{“name”: , “symbol”: , “decimals”: }

POX

POX 1 Staking delegation transactions

Column	Type	Description
tx_hash	text	Function call transaction hash
amount	numeric	amount delegated in ustx
address	text	pool address

POX2_EVENTS

Column Name	Data Type	Description
tx_hash	text
id	bigint
event_index	integer
tx_id	bytea
tx_index	smallint
block_height	integer
index_block_hash	bytea
parent_index_block_hash	bytea
microblock_hash	bytea
microblock_sequence	integer
microblock_canonical	boolean
canonical	boolean
stacker	text
locked	numeric
balance	numeric
burnchain_unlock_height	bigint
name	text
pox_addr	text
pox_addr_raw	bytea
first_cycle_locked	numeric
first_unlocked_cycle	numeric
delegate_to	text
lock_period	numeric
lock_amount	numeric
start_burn_height	numeric
unlock_burn_height	numeric
delegator	text
increase_by	numeric
total_locked	numeric
extend_count	numeric
reward_cycle	numeric
amount_ustx	numeric

POX3_EVENTS

Column Name	Type	Description
tx_hash	text
id	bigint
event_index	integer
tx_id	bytea
tx_index	smallint
block_height	integer
index_block_hash	bytea
parent_index_block_hash	bytea
microblock_hash	bytea
microblock_sequence	integer
microblock_canonical	boolean
canonical	boolean
stacker	text
locked	numeric
balance	numeric
burnchain_unlock_height	bigint
name	text
pox_addr	text
pox_addr_raw	bytea
first_cycle_locked	numeric
first_unlocked_cycle	numeric
delegate_to	text
lock_period	numeric
lock_amount	numeric
start_burn_height	numeric
unlock_burn_height	numeric
delegator	text
increase_by	numeric
total_locked	numeric
extend_count	numeric
reward_cycle	numeric
amount_ustx	numeric