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.
heightINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
parent_block_hashSTRINGHash of the previous block in the Cardano blockchain, establishing the chain’s sequential linkage. Hex-encoded 64-character string that references the immediate predecessor block at parent_height.
parent_heightINT64Block height of the preceding block in the Cardano blockchain, establishing the chain’s sequential ordering. Always equals the current block’s height minus one in a valid chain.
block_timestampINT64Timestamp when the block was produced. UTC timezone, microsecond precision.
transaction_countINT64Number of transactions included in the block.
epoch_noINT64Cardano epoch number during which this block was produced. Epochs are fixed periods of approximately 5 days used for staking reward distribution and protocol parameter updates.
slot_noINT64Unique slot number in the Cardano blockchain representing the specific time unit when this block was produced. Each epoch contains a fixed number of slots, with values incrementing sequentially across epochs.
sizeINT64Block size in bytes. Represents the total serialized size of the block data structure.
created_bySTRINGIdentifier of the stake pool that produced this block. Formatted as “Pool-” followed by a 16-character hexadecimal string unique to each validator.
numberINT64Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
number_indexINT64Index of the record within the block, starting at 0 for the first record and incrementing by 1 for each subsequent record.
sizeheightnumberslot_noepoch_notimestampblock_dateblock_hashcreated_bynumber_indexparent_heightblock_timestampparent_block_hashtransaction_count
34568980456898060683492112020-08-17T03:24:00.000Z2020-08-174741fc0b6d7db830c7c868990b464dc1125e8187d54a222f99cb0900d1724681Pool-2e65f9aa580a28d0045689791597634640000f4a8768866f242a6cb22eb6b2eb86b4122025b27a33b18e816c2935e3029eb890
34569145456914560716392112020-08-17T04:18:50.000Z2020-08-175fa0c79ca8c2b1366d9a7d07d93a0c71052c085c89bb74e0f86ff0865307ec4dPool-21ae98f98fa835820456914415976379300009b73a01364b0289909845725568280bff38e229b2fc8a4979cc548bc3d4f361d0
34570352457035260961992112020-08-17T11:08:10.000Z2020-08-174b7cf796f7025925bc6182f85f685604af6d2001fe1516f16384f5ad4a8fc4d0Pool-ee9ef63e4d50a24e0457035115976624900008b8af1ca9abce2e2f7394108478c3061cbab1af7bda8ab6026af2f01f1d6cdb50
Query with partition filter
SELECT *
FROM `tt-blockchain.cardano.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_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_timestamp_unixINT64Unix epoch timestamp of when the block containing this transaction was added to the Cardano blockchain, in milliseconds. Value is the same for all operations within the same transaction and block.
epoch_noINT64Epoch number representing the Cardano protocol’s time period when the transaction was processed. Each epoch lasts approximately 5 days and contains multiple slots.
slot_noINT64Slot number within the Cardano blockchain representing the time unit for block production. Each slot is a fixed time interval (typically 1 second) and increments sequentially across all epochs.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
operation_indexINT64Sequential position of this operation within the transaction, starting from 0. Each transaction can contain multiple operations (inputs, outputs, staking actions), with this index providing their order.
network_indexINT64Network index position of the operation within multi-network transactions on Cardano. Null for most operations as they typically execute on a single network.
operation_typeSTRINGType of operation performed in this transaction such as stakeKeyRegistration, stakeDelegation, or stakeKeyDeregistration. Represents Cardano-specific actions including stake key management, delegation events, and ADA transfers.
operation_statusSTRINGOperation outcome indicator showing whether the transaction operation completed successfully or failed. Typically shows ‘success’ for executed operations, with failure states appearing when transactions are rejected or reverted.
addressSTRINGContract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
amount_valueINT64Amount of ADA or native tokens transferred in the operation, denominated in the smallest unit (lovelaces for ADA). Null for staking operations that don’t involve token transfers like delegations and key registrations.
currency_symbolSTRINGToken symbol for native assets transferred in this operation. Null for ADA transfers and non-monetary operations like stake registration or delegation.
currency_decimalsINT64Number of decimal places for the token or currency involved in the operation. Null for non-transfer operations like staking actions.
coin_actionSTRINGAction performed on the coin balance within the operation (e.g., coin_created, coin_spent). Null for non-transfer operations like staking registrations and delegations.
coin_identifierSTRINGUnique identifier for the specific coin or UTXO (Unspent Transaction Output) involved in the operation. Null for non-coin operations like stake key registration or delegation.
transaction_sizeINT64Total size of the transaction in bytes on the Cardano blockchain. Larger transactions typically contain more inputs, outputs, or metadata.
script_sizeINT64Size in bytes of the Plutus script associated with this operation. Null for operations without attached scripts.
token_bundleARRAY<JSON>JSON array of native tokens included in the operation, containing asset identifiers, quantities, and metadata for Cardano multi-asset transfers. Null or empty for ADA-only operations and staking actions.
withdrawal_amount_valueINT64Amount of ADA withdrawn from a staking reward address during this transaction, denominated in lovelaces (1 ADA = 1,000,000 lovelaces). Null when the transaction does not include a withdrawal operation.
withdrawal_currency_symbolSTRINGSymbol of the currency being withdrawn from a staking reward account (e.g., ADA for Cardano’s native token). Null when the operation does not involve a withdrawal.
withdrawal_currency_decimalsINT64Number of decimal places for the withdrawal currency, determining how to interpret the withdrawal_amount_value. Null when no withdrawal occurs in the operation.
related_operationsJSONReferences to other operations within the same transaction that are logically connected to this operation. Null for most operations; populated when operations depend on or relate to each other within a transaction.
addressslot_noepoch_noblock_dateblock_hashcoin_actionscript_sizeamount_valueblock_heighttoken_bundlenetwork_indexoperation_typeblock_timestampcoin_identifiercurrency_symboloperation_indexoperation_statustransaction_hashtransaction_sizecurrency_decimalstransaction_indexrelated_operationsblock_timestamp_unixwithdrawal_amount_valuewithdrawal_currency_symbolwithdrawal_currency_decimals
stake1u88xmvgqxf82cry2rnjp6cyxsnptase48fcm3u9d7k5qzgg4fwyg81511219815472025-03-23530c2d9d9f7149e4895e44121f3005af01c9900c6a5d55447841bbdb29c2e43d011638492[]stakeKeyRegistration2025-03-23T00:04:32.000Z1successe3137291c9a0382209798ee58abb3f691f03cbdf1d0341d6209a3e0e4e16a5ed728121742688272000
stake1u88xmvgqxf82cry2rnjp6cyxsnptase48fcm3u9d7k5qzgg4fwyg81511219815472025-03-23530c2d9d9f7149e4895e44121f3005af01c9900c6a5d55447841bbdb29c2e43d011638492[]stakeDelegation2025-03-23T00:04:32.000Z2successe3137291c9a0382209798ee58abb3f691f03cbdf1d0341d6209a3e0e4e16a5ed728121742688272000
stake1uyfxj5zlmcy3zzx8h270xxf0malglgrgpdn5wywq0cv56rqg4ltqv1511222345472025-03-236f6a434a13c55a280de479bd04c69ece24c02bb9fe49ab994f843c1ba85f0e46011638505[]stakeDelegation2025-03-23T00:08:45.000Z2successaaedeea8721bd9dc5bf35b6e68eb1e223da64aa7828d407cf84a0057c07fddc642711742688525000
Query with partition filter
SELECT *
FROM `tt-blockchain.cardano.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100