> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# algorand
> Tables in tt-blockchain.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.
| 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. |
| seed | number | params | run\_id | rewards | timestamp | block\_date | genesis\_id | genesis\_hash | number\_index | upgrade\_vote | upgrade\_state | timestamp\_unix | sequential\_number | transaction\_count | transactions\_root | previous\_block\_hash | state\_proof\_tracking | participation\_updates | 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= | 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\\}](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= | 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\\}](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= | 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\\}](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= |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| fee | logs | note | lease | sender | rekey\_to | auth\_addr | signature | block\_date | genesis\_id | last\_valid | round\_time | first\_valid | block\_number | genesis\_hash | close\_rewards | closing\_amount | sender\_rewards | transaction\_id | block\_timestamp | confirmed\_round | receiver\_rewards | transaction\_type | local\_state\_delta | sequential\_number | transaction\_group | transaction\_index | global\_state\_delta | inner\_transactions | intra\_round\_offset | keyreg\_transaction | created\_asset\_index | payment\_transaction | application\_transaction | asset\_config\_transaction | asset\_freeze\_transaction | created\_application\_index | asset\_transfer\_transaction |
| ---- | ---- | -------------------------------- | ----- | ---------------------------------------------------------- | --------- | ---------------------------------------------------------- | --------------------------------------------------------------------------------------------------- | ----------- | ------------ | ----------- | ----------- | ------------ | ------------- | -------------------------------------------- | -------------- | --------------- | --------------- | ---------------------------------------------------- | ------------------------ | ---------------- | ----------------- | ----------------- | ------------------- | ------------------ | -------------------------------------------- | ------------------ | -------------------- | ------------------- | -------------------- | ------------------- | --------------------- | -------------------- | ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------- | --------------------------- | ---------------------------- |
| 0 | | eyJ0cmFpdHMiOiBbIlNwZWNpYWwxIl19 | | 47KPTVPRIIKKGEVSLTTOTK42ZK7FNMBSLMGXCAXENEWDDDVYJDERINJXMA | | AEFRJY2IQI5OOCA32D4F7GNW5Q4EIXN2PMWSNXE5P6ZBQ5HFUOCJDSU7KU | \{"sig":"fS2cnxzpsXkwlgTqK89PWQRGyyIzwldq74n/qVFeiv4JvZ2W8T50FIUFyGlWTQaNDbUtLw+7zT/OdgsWJjNDBA=="} | 2025-11-25 | mainnet-v1.0 | 55876358 | 1764040992 | 55876328 | 55876336 | wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8= | 0 | 0 | 0 | B3F53U53HG2MCZGJ6XDDBMGA4JONR4MVSNX3D54K4TURX7X5O7HQ | 2025-11-25T03:23:12.000Z | 55876336 | 0 | 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= | 0 | 0 | 0 | XB4DTPIVUYJBB35QFO7RD44F4YR7NMEL23J3OKLUBNGQYM7SXZUQ | 2025-11-25T15:20:27.000Z | 55891773 | 0 | 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"\\}\\}](https://thevalueville.com/nft-voucher/6JMRGWNEIQ","url-b64":"aHR0cHM6Ly90aGV2YWx1ZXZpbGxlLmNvbS9uZnQtdm91Y2hlci82Sk1SR1dORUlR"\\}\\}) | | | |
| 1000 | | | | QGWMPIJZEZIQ5ZSGUWS66K442COXFH5RGSUP7W3UYL3NFQHZNISUBJRUZI | | | \{"sig":"klOC756C9Zenas1UD2jOxcUrZ2mlPeyIlEut1Ga1qY7i2z5zrGK1zKUQU2vrXZLG1x9Z0wewJJeuh1xpqeiUBQ=="} | 2025-11-25 | mainnet-v1.0 | 55883825 | 1764061520 | 55883725 | 55883733 | wGHE2Pwdvd7S12BL5FaOP20EGYesN73ktiC1qzkkit8= | 0 | 0 | 0 | 363EI73ZRRDUTE24B7B3XOCSNNQ45BDN6HWSDNYLWTOQKFOMJA5Q | 2025-11-25T09:05:20.000Z | 55883733 | 0 | acfg | | 55883733 | | 1 | | | 1 | | | | | \{"asset-id":3325700687} | | | |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-blockchain.algorand.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***