Skip to main content

​
Tables

​
blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.
ColumnTypeDescription
timestampTIMESTAMPTimestamp when the block was produced. UTC timezone.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
numberINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
transaction_countINT64Number of transactions included in the block.
timestamp_unixINT64Unix timestamp of when the block was produced, stored as seconds since epoch (January 1, 1970). Values align with the timestamp field but in integer format for easier arithmetic operations.
sequential_numberINT64Sequential block number representing the position of this block in the Algorand chain, identical to the number field. Values increment by 1 with each new block, starting from genesis.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
genesis_hashSTRINGBase64-encoded hash identifier for the Algorand network genesis block. Constant value across all blocks within the same network (e.g., mainnet vs testnet).
genesis_idSTRINGNetwork identifier for the Algorand blockchain. Mainnet uses “mainnet-v1.0” while testnets have different identifiers.
previous_block_hashSTRINGHash of the previous block in the blockchain, linking blocks in chronological sequence to form the chain structure.
seedSTRINGVerifiable random seed used for Algorand’s consensus protocol. Base64-encoded string generated for each block to ensure unpredictability in leader selection.
run_idSTRINGPipeline execution identifier for internal data processing tracking. Typically null in production data.
transactions_rootSTRINGMerkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
transactions_root_sha256STRINGMerkle tree root hash of all transactions in the block, SHA-256 encoded. Base64-encoded string used for transaction integrity verification.
paramsJSONJSON object containing consensus protocol parameters for this block. Typically null in standard blocks as parameter changes occur infrequently through protocol upgrades.
rewardsJSONJSON object containing fee sink address, rewards pool address, rewards calculation round number, and current rewards level for this block’s distribution.
participation_updatesJSONJSON object containing updates to account participation keys for consensus. Typically null; populated when validators register or update their participation credentials for block proposal and voting.
upgrade_stateJSONJSON object containing protocol upgrade status and next protocol details. Includes current protocol version URL, approval count, and upgrade timing information for network consensus changes.
upgrade_voteJSONJSON object containing proposal voting parameters for protocol upgrades. Includes approval status and delay settings for network consensus mechanisms.
state_proof_trackingJSONState proof tracking metadata for consensus verification on Algorand. Contains next-round number, online stake weight, and proof type as base64-encoded JSON.
seednumberparamsrun_idrewardstimestampblock_dategenesis_idgenesis_hashnumber_indexupgrade_voteupgrade_statetimestamp_unixsequential_numbertransaction_counttransactions_rootprevious_block_hashstate_proof_trackingparticipation_updatestransactions_root_sha256
nCw702/TlxGrwqvSaBuJdHAiaS1Fq4dPwAYJ5TCY17A=23763456{“fee-sink”:“Y76M3MSY6DKBRHBL7C3NNDXGS5IIMQVQVUAB6MP4XEMMGVF2QWNPL226CA”,“rewards-calculation-round”:24000000,“rewards-level”:218288,“rewards-pool”:“737777777777777777777777777777777777777777777777777UFEJ2CI”,“rewards-rate”:0,“rewards-residue”:6845750026}2022-09-29T00:03:07.000Z2022-09-29mainnet-v1.0wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=0{“upgrade-approve”:false,“upgrade-delay”:0}{“current-protocol”:“https://github.com/algorandfoundation/specs/tree/433d8e9a7274b6fca703d91213e05c7e6a589e69”,“next-protocol-approvals”:0,“next-protocol-switch-on”:0,“next-protocol-vote-before”:0\}166440978723763456887725528oS5w/ETYY+3rxWQl53Go1ztRZ63GOmyAVEVaA8A65Lg=RCyAGkJuFqGlo/FdRmzlIxA9vecqsm6AhGu3gRQv3P0=[{“next-round”:23763456,“online-total-weight”:2020553278807429,“type”:0,“voters-commitment”:“RiM8z7oJZ00vfxzkDlN2AmI3z33Jg4kEgbAvwjUOc0ooi0z7vkcrlObMxif3QwPf+bfk4VCmEQlvkJGneu8s7g==”}]LUMTonCE36vpgTNRo/C/iun0nh+L9gFHi4rpKl+0FVo=
UECA786Yv4xTP1FDNmwns3/lBeknEi+xkc4inkh51eU=23763451{“fee-sink”:“Y76M3MSY6DKBRHBL7C3NNDXGS5IIMQVQVUAB6MP4XEMMGVF2QWNPL226CA”,“rewards-calculation-round”:24000000,“rewards-level”:218288,“rewards-pool”:“737777777777777777777777777777777777777777777777777UFEJ2CI”,“rewards-rate”:0,“rewards-residue”:6845750026}2022-09-29T00:02:48.000Z2022-09-29mainnet-v1.0wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=0{“upgrade-approve”:false,“upgrade-delay”:0}{“current-protocol”:“https://github.com/algorandfoundation/specs/tree/433d8e9a7274b6fca703d91213e05c7e6a589e69”,“next-protocol-approvals”:0,“next-protocol-switch-on”:0,“next-protocol-vote-before”:0\}166440976823763451887725345qUY3/pyEamX5vX9JYFxf2aNUeEDsjTF+bkxDvFt8OLQ=AhRJEExhi90GXURS+X6m0dgxhFgCiPTa5MXD2fyIjNA=[{“next-round”:23763456,“online-total-weight”:0,“type”:0}]PGQPRkrBe1eOwKQplTX3+WmldodryRIufWGMKCUPpdY=
nII7XCbh+YLoKOWorCI8QDrE+We3Qx3DlMvz7LgrDcM=23763424{“fee-sink”:“Y76M3MSY6DKBRHBL7C3NNDXGS5IIMQVQVUAB6MP4XEMMGVF2QWNPL226CA”,“rewards-calculation-round”:24000000,“rewards-level”:218288,“rewards-pool”:“737777777777777777777777777777777777777777777777777UFEJ2CI”,“rewards-rate”:0,“rewards-residue”:6845750026}2022-09-29T00:01:07.000Z2022-09-29mainnet-v1.0wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=0{“upgrade-approve”:false,“upgrade-delay”:0}{“current-protocol”:“https://github.com/algorandfoundation/specs/tree/433d8e9a7274b6fca703d91213e05c7e6a589e69”,“next-protocol-approvals”:0,“next-protocol-switch-on”:0,“next-protocol-vote-before”:0\}166440966723763424887724231suQM6Yd3KSGhCgFj1x9aaH4tIXzR+wWuMb0iRdvYv6A=Cjt1+wu/iYSbwHYNH0k+UPKwrtgI4Dln2lz31uK5XE0=[{“next-round”:23763456,“online-total-weight”:0,“type”:0}]frfuLBuS8FMK6RwHj8UY2jeMUBvEJmljxLoYr2hoU5o=
Query with partition filter
SELECT *
FROM `tt-blockchain.algorand.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_dateDATEDate when the block was produced. Derived from block timestamp, truncated to day precision.
block_numberINT64Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
transaction_idSTRINGUnique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_typeSTRINGEIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
senderSTRINGAddress that initiated the transaction. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; base58-encoded or base32-encoded for non-EVM chains.
feeINT64Transaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
intra_round_offsetINT64Position of this transaction within the block when multiple transactions occur in the same round. Zero-indexed integer indicating execution order among concurrent transactions.
sequential_numberINT64Unique identifier for each transaction in ascending order across the entire Algorand blockchain. Equivalent to confirmed_round in these samples, providing a sequential count of transaction records.
transaction_groupSTRINGBase58-encoded identifier linking transactions that must execute atomically as a single group. Null for standalone transactions not part of a group.
first_validINT64Round number when this transaction first becomes valid for inclusion in a block. Algorand transactions specify a validity window using first_valid and last_valid round numbers.
last_validINT64Round number of the last block in which this transaction can be confirmed. Transactions must be confirmed between first_valid and last_valid rounds.
confirmed_roundINT64Round number in which this transaction was confirmed and included in the blockchain. This value matches the block_number for all confirmed transactions.
round_timeINT64Unix timestamp indicating when the block containing this transaction was created by the network. Measured in seconds since epoch (January 1, 1970).
genesis_hashSTRINGNetwork genesis hash identifying the Algorand blockchain instance. Base64-encoded identifier that distinguishes mainnet from testnet or other networks.
genesis_idSTRINGNetwork identifier string for the Algorand blockchain instance. Typically “mainnet-v1.0” for mainnet or “testnet-v1.0” for testnet, used to distinguish between different Algorand networks.
noteSTRINGBase64-encoded arbitrary data attached to the transaction by the sender, often containing metadata like JSON descriptors for NFTs or platform-specific event tracking. Nullable and frequently used for off-chain context or application-specific messaging.
leaseSTRINGTransaction lease identifier used to prevent duplicate transaction execution. Base64-encoded string that enforces uniqueness when set, commonly null for non-atomic operations.
rekey_toSTRINGAlgorand address to which spending authority for the sender’s account is rekeyed. Null if the transaction does not perform rekeying.
auth_addrSTRINGAddress authorized to sign transactions on behalf of the sender account. Null when the sender signs directly; populated when transaction authority has been delegated via rekeying.
sender_rewardsINT64Reward amount (in microALGOs) credited to the transaction sender’s account for participation in consensus. Typically zero unless sender is staking.
receiver_rewardsINT64Rewards allocated to the transaction receiver from Algorand’s staking mechanism, denominated in microAlgos. Typically zero for most transaction types, non-zero only when receiver participates in consensus.
close_rewardsINT64Rewards allocated to the closing address when an account is closed. Measured in microAlgos; typically zero when no account closure occurs.
closing_amountINT64Amount of ALGO sent to the close remainder address when an account is closed. Denominated in microALGOs, typically zero unless the transaction explicitly closes the sender’s account.
created_asset_indexINT64Asset ID assigned to a newly created Algorand Standard Asset (ASA) when this transaction is an asset creation. Null for all other transaction types or when modifying existing assets.
created_application_indexINT64Application ID assigned to a newly created smart contract in this transaction. Non-null only for successful application creation transactions (transaction_type = ‘appl’).
payment_transactionJSONJSON object containing payment transaction details including receiver address, amount transferred in microAlgos, and optional close remainder recipient. Null for non-payment transaction types.
asset_transfer_transactionJSONJSON object containing Algorand Standard Asset (ASA) transfer details when transaction_type is ‘axfer’. Null for all other transaction types.
asset_config_transactionJSONJSON object containing asset configuration transaction details including asset ID, creator address, decimals, frozen status, and role addresses (manager, reserve, freeze, clawback). Populated only when transaction_type is ‘acfg’ (asset configuration).
asset_freeze_transactionJSONStructured details of an asset freeze transaction that locks or unlocks an Algorand Standard Asset (ASA) in a specific account. Null when the transaction is not of type afrz.
application_transactionJSONStructured data specific to Algorand application call transactions, containing application ID, accounts, foreign apps/assets, and call arguments. Null for non-application transaction types.
keyreg_transactionJSONJSON object containing details of a key registration transaction used to participate in Algorand consensus. Null when the transaction is not of type ‘keyreg’.
global_state_deltaJSONJSON object containing changes to an application’s global state variables resulting from this transaction. Null when the transaction does not modify global application state.
local_state_deltaJSONChanges to application-specific storage scoped to individual accounts during smart contract execution. Contains key-value pairs modified in the transaction’s local state, or null if no account-level state was altered.
logsJSONEvent logs emitted by application calls during transaction execution, stored as JSON array. Null for non-application transactions or when no logs are produced.
inner_transactionsJSONNested array of transactions spawned by smart contract execution during this transaction. May contain multiple levels of contract calls and inner transaction details.
signatureJSON# Canonical Column Description: signature
Cryptographic signature authorizing the operation. Hex-encoded string format, typically 130-132 characters including 0x prefix for signed transactions and operations. |
feelogsnoteleasesenderrekey_toauth_addrsignatureblock_dategenesis_idlast_validround_timefirst_validblock_numbergenesis_hashclose_rewardsclosing_amountsender_rewardstransaction_idblock_timestampconfirmed_roundreceiver_rewardstransaction_typelocal_state_deltasequential_numbertransaction_grouptransaction_indexglobal_state_deltainner_transactionsintra_round_offsetkeyreg_transactioncreated_asset_indexpayment_transactionapplication_transactionasset_config_transactionasset_freeze_transactioncreated_application_indexasset_transfer_transaction
0eyJ0cmFpdHMiOiBbIlNwZWNpYWwxIl1947KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMAAEFRJY2IQI5OOCA32D4F7GNW5Q4EIXN2PMWSNXE5P6ZBQ5HFUOCJDSU7KU{“sig”:“fS2cnxzpsXkwlgTqK89PWQRGyyIzwldq74n/qVFeiv4JvZ2W8T50FIUFyGlWTQaNDbUtLw+7zT/OdgsWJjNDBA==“}2025-11-25mainnet-v1.05587635817640409925587632855876336wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=000B3F53U53HG2MCZGJ6XDDBMGA4JONR4MVSNX3D54K4TURX7X5O7HQ2025-11-25T03:23:12.000Z558763360acfg55876336A3NIlAggzmOqZvM1+VRpMxxTI4FAK+V/k0QHzddBjYY=873{“asset-id”:1017837363,“params”:{“creator”:“47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA”,“decimals”:0,“default-frozen”:false,“manager”:“47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA”,“reserve”:“RAGUG3VLGDDTGBDFST36A2KN2YAVZAIXZDPP3K3KHBCA3UY5IKKRKK6UEM”,“total”:0}}
1000QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI{“sig”:“wTqP82rvs0lSfWaFo8dbKp/fQvkm2NIB5Ef6aEoESIatQRP/SRD5Xj22lPmzMNYlDNrikb57nGaOTxvw1IrrBg==“}2025-11-25mainnet-v1.05589186917640840275589176955891773wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=000XB4DTPIVUYJBB35QFO7RD44F4YR7NMEL23J3OKLUBNGQYM7SXZUQ2025-11-25T15:20:27.000Z558917730acfg55891773553340484314{“asset-id”:0,“params”:{“clawback”:“QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI”,“creator”:“QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI”,“decimals”:0,“default-frozen”:false,“freeze”:“QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI”,“manager”:“QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI”,“name”:“6JMRGWNEIQ”,“name-b64”:“NkpNUkdXTkVJUQ==”,“reserve”:“QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI”,“total”:1,“url”:“https://thevalueville.com/nft-voucher/6JMRGWNEIQ”,“url-b64”:“aHR0cHM6Ly90aGV2YWx1ZXZpbGxlLmNvbS9uZnQtdm91Y2hlci82Sk1SR1dORUlR”\}\}
1000QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI{“sig”:“klOC756C9Zenas1UD2jOxcUrZ2mlPeyIlEut1Ga1qY7i2z5zrGK1zKUQU2vrXZLG1x9Z0wewJJeuh1xpqeiUBQ==“}2025-11-25mainnet-v1.05588382517640615205588372555883733wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=000363EI73ZRRDUTE24B7B3XOCSNNQ45BDN6HWSDNYLWTOQKFOMJA5Q2025-11-25T09:05:20.000Z558837330acfg5588373311{“asset-id”:3325700687}
Query with partition filter
SELECT *
FROM `tt-blockchain.algorand.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100