algorand

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.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`transaction_count`	`INT64`	Number of transactions included in the block.
`timestamp_unix`	`INT64`	Unix 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_number`	`INT64`	Sequential 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_index`	`INT64`	Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
`genesis_hash`	`STRING`	Base64-encoded hash identifier for the Algorand network genesis block. Constant value across all blocks within the same network (e.g., mainnet vs testnet).
`genesis_id`	`STRING`	Network identifier for the Algorand blockchain. Mainnet uses “mainnet-v1.0” while testnets have different identifiers.
`previous_block_hash`	`STRING`	Hash of the previous block in the blockchain, linking blocks in chronological sequence to form the chain structure.
`seed`	`STRING`	Verifiable random seed used for Algorand’s consensus protocol. Base64-encoded string generated for each block to ensure unpredictability in leader selection.
`run_id`	`STRING`	Pipeline execution identifier for internal data processing tracking. Typically null in production data.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`transactions_root_sha256`	`STRING`	Merkle tree root hash of all transactions in the block, SHA-256 encoded. Base64-encoded string used for transaction integrity verification.
`params`	`JSON`	JSON object containing consensus protocol parameters for this block. Typically null in standard blocks as parameter changes occur infrequently through protocol upgrades.
`rewards`	`JSON`	JSON object containing fee sink address, rewards pool address, rewards calculation round number, and current rewards level for this block’s distribution.
`participation_updates`	`JSON`	JSON 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_state`	`JSON`	JSON 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_vote`	`JSON`	JSON object containing proposal voting parameters for protocol upgrades. Includes approval status and delay settings for network consensus mechanisms.
`state_proof_tracking`	`JSON`	State proof tracking metadata for consensus verification on Algorand. Contains next-round number, online stake weight, and proof type as base64-encoded JSON.

Sample Data

seed	number	rewards	timestamp	block_date	genesis_id	genesis_hash	upgrade_vote	upgrade_state	timestamp_unix	sequential_number	transaction_count	transactions_root	previous_block_hash	state_proof_tracking	transactions_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.000Z	2022-09-29	mainnet-v1.0	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	{“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\}	1664409787	23763456	887725528	oS5w/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.000Z	2022-09-29	mainnet-v1.0	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	{“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\}	1664409768	23763451	887725345	qUY3/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.000Z	2022-09-29	mainnet-v1.0	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	{“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\}	1664409667	23763424	887724231	suQM6Yd3KSGhCgFj1x9aaH4tIXzR+wWuMb0iRdvYv6A=	Cjt1+wu/iYSbwHYNH0k+UPKwrtgI4Dln2lz31uK5XE0=	[{“next-round”:23763456,“online-total-weight”:0,“type”:0}]	frfuLBuS8FMK6RwHj8UY2jeMUBvEJmljxLoYr2hoU5o=

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_date`	`DATE`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_id`	`STRING`	Unique 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_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_type`	`STRING`	EIP-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.
`sender`	`STRING`	Address that initiated the transaction. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; base58-encoded or base32-encoded for non-EVM chains.
`fee`	`INT64`	Transaction 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_offset`	`INT64`	Position of this transaction within the block when multiple transactions occur in the same round. Zero-indexed integer indicating execution order among concurrent transactions.
`sequential_number`	`INT64`	Unique 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_group`	`STRING`	Base58-encoded identifier linking transactions that must execute atomically as a single group. Null for standalone transactions not part of a group.
`first_valid`	`INT64`	Round 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_valid`	`INT64`	Round number of the last block in which this transaction can be confirmed. Transactions must be confirmed between `first_valid` and `last_valid` rounds.
`confirmed_round`	`INT64`	Round number in which this transaction was confirmed and included in the blockchain. This value matches the block_number for all confirmed transactions.
`round_time`	`INT64`	Unix timestamp indicating when the block containing this transaction was created by the network. Measured in seconds since epoch (January 1, 1970).
`genesis_hash`	`STRING`	Network genesis hash identifying the Algorand blockchain instance. Base64-encoded identifier that distinguishes mainnet from testnet or other networks.
`genesis_id`	`STRING`	Network 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.
`note`	`STRING`	Base64-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.
`lease`	`STRING`	Transaction lease identifier used to prevent duplicate transaction execution. Base64-encoded string that enforces uniqueness when set, commonly null for non-atomic operations.
`rekey_to`	`STRING`	Algorand address to which spending authority for the sender’s account is rekeyed. Null if the transaction does not perform rekeying.
`auth_addr`	`STRING`	Address 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_rewards`	`INT64`	Reward amount (in microALGOs) credited to the transaction sender’s account for participation in consensus. Typically zero unless sender is staking.
`receiver_rewards`	`INT64`	Rewards 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_rewards`	`INT64`	Rewards allocated to the closing address when an account is closed. Measured in microAlgos; typically zero when no account closure occurs.
`closing_amount`	`INT64`	Amount 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_index`	`INT64`	Asset 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_index`	`INT64`	Application ID assigned to a newly created smart contract in this transaction. Non-null only for successful application creation transactions (transaction_type = ‘appl’).
`payment_transaction`	`JSON`	JSON 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_transaction`	`JSON`	JSON object containing Algorand Standard Asset (ASA) transfer details when transaction_type is ‘axfer’. Null for all other transaction types.
`asset_config_transaction`	`JSON`	JSON 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_transaction`	`JSON`	Structured 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_transaction`	`JSON`	Structured data specific to Algorand application call transactions, containing application ID, accounts, foreign apps/assets, and call arguments. Null for non-application transaction types.
`keyreg_transaction`	`JSON`	JSON 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_delta`	`JSON`	JSON 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_delta`	`JSON`	Changes 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.
`logs`	`JSON`	Event logs emitted by application calls during transaction execution, stored as JSON array. Null for non-application transactions or when no logs are produced.
`inner_transactions`	`JSON`	Nested array of transactions spawned by smart contract execution during this transaction. May contain multiple levels of contract calls and inner transaction details.
`signature`	`JSON`	# 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. |

Sample Data

fee	note	sender	auth_addr	signature	block_date	genesis_id	last_valid	round_time	first_valid	block_number	genesis_hash	transaction_id	block_timestamp	confirmed_round	transaction_type	sequential_number	transaction_group	transaction_index	intra_round_offset	created_asset_index	asset_config_transaction
0	eyJ0cmFpdHMiOiBbIlNwZWNpYWwxIl19	47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA	AEFRJY2IQI5OOCA32D4F7GNW5Q4EIXN2PMWSNXE5P6ZBQ5HFUOCJDSU7KU	{“sig”:“fS2cnxzpsXkwlgTqK89PWQRGyyIzwldq74n/qVFeiv4JvZ2W8T50FIUFyGlWTQaNDbUtLw+7zT/OdgsWJjNDBA==“}	2025-11-25	mainnet-v1.0	55876358	1764040992	55876328	55876336	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	B3F53U53HG2MCZGJ6XDDBMGA4JONR4MVSNX3D54K4TURX7X5O7HQ	2025-11-25T03:23:12.000Z	55876336	acfg	55876336	A3NIlAggzmOqZvM1+VRpMxxTI4FAK+V/k0QHzddBjYY=	8	73		{“asset-id”:1017837363,“params”:{“creator”:“47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA”,“decimals”:0,“default-frozen”:false,“manager”:“47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA”,“reserve”:“RAGUG3VLGDDTGBDFST36A2KN2YAVZAIXZDPP3K3KHBCA3UY5IKKRKK6UEM”,“total”:0}}
1000		QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI		{“sig”:“wTqP82rvs0lSfWaFo8dbKp/fQvkm2NIB5Ef6aEoESIatQRP/SRD5Xj22lPmzMNYlDNrikb57nGaOTxvw1IrrBg==“}	2025-11-25	mainnet-v1.0	55891869	1764084027	55891769	55891773	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	XB4DTPIVUYJBB35QFO7RD44F4YR7NMEL23J3OKLUBNGQYM7SXZUQ	2025-11-25T15:20:27.000Z	55891773	acfg	55891773		5	5	3340484314	{“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”\}\}
1000		QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI		{“sig”:“klOC756C9Zenas1UD2jOxcUrZ2mlPeyIlEut1Ga1qY7i2z5zrGK1zKUQU2vrXZLG1x9Z0wewJJeuh1xpqeiUBQ==“}	2025-11-25	mainnet-v1.0	55883825	1764061520	55883725	55883733	wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8=	363EI73ZRRDUTE24B7B3XOCSNNQ45BDN6HWSDNYLWTOQKFOMJA5Q	2025-11-25T09:05:20.000Z	55883733	acfg	55883733		1	1		{“asset-id”:3325700687}

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.algorand.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

transactions

​Tables

​blocks

​transactions

Tables

blocks

transactions