invarch

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
`relay_chain`	`STRING`	Identifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
`chain`	`STRING`	Blockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`extrinsics_root`	`STRING`	Merkle root hash of all extrinsics included in the block. 66-character hex string including 0x prefix.
`author_id`	`STRING`	Identifier of the validator or collator who authored the block. Base58-encoded string representing the block producer’s public key.
`finalized`	`BOOL`	Boolean indicator of whether the block has been finalized by the network consensus mechanism. True indicates the block has achieved finality and is immutable in the blockchain.
`block_date`	`TIMESTAMP`	Date when the block was produced. Derived from block timestamp, truncated to day precision.
`extrinsics_count`	`INT64`	Number of extrinsics included in the block. Integer value representing the total count of transactions and other state-changing operations.

Sample Data

chain	number	author_id	finalized	timestamp	block_hash	state_root	parent_hash	relay_chain	extrinsics_root	extrinsics_count
invarch	836416	i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33	true	2024-02-21T07:52:00.447Z	0x0585ed0090a050dca205760bc5694aa788de8f09773781aab325302ef732e0b7	0x5befb4199b32cd0a820d33e8bacb9f82aaa53b5aa0c809e7d709e78742c5ec14	0x99b87218e3f3ff50f24148336fcd9b9057b350b758cb1257f423611dbe0190a4	polkadot	0x755f78480313c0fc848b06dc014e121add501e4662e26845c9ac13d5b74adf16	2
invarch	839588	i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33	true	2024-02-21T18:55:12.490Z	0x084edf111bc145120dda138bac36b9bc75290da9b097d30e9eb2b53a8bbf140e	0x3572883093ded63b7b0b2033670737cc2d748e61e2099ce85ac50efb38ac9b88	0x1250287710d5a2675baa40d869b7223c0cdb380cf1c1b2251efd4490d0fad77e	polkadot	0x2533274a872e0506151dee06704b32a3c5cb04271a0de8f7bef39e25ae69e684	2
invarch	835938	i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33	true	2024-02-21T06:12:12.451Z	0x0c7f9aaa10a3952afe387dfa4a702456d737e717f9b97c17b352aae687000a84	0x63f5c13f8547151e8d85342db77df074b86879683b79711b6b9e6e597546eb4d	0x7895feadfb78879cdd5783afca304cb8eded3338d7eaf9108129a8e8a7eee2f6	polkadot	0xbbb8796e493e0bf203001c6448f5fc6b92c1a618c521c5308c13dc66cf3d3f78	2

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.invarch.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

events

Blockchain state change notifications emitted by runtime modules during transaction execution and block processing. Contains event metadata (pallet, method, index), encoded parameters, block context, and optional extrinsic linkage for analyzing on-chain activity across Substrate-based chains.

Columns

Column	Type	Description
`relay_chain`	`STRING`	Identifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
`chain`	`STRING`	Blockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`pallet`	`STRING`	Name of the substrate runtime module containing the operation being executed. Identifies the pallet (functional module) such as balances, staking, or governance.
`method`	`STRING`	Name of the operation or function being executed. Identifies the specific action within a pallet or module, such as transfer, stake, or swap.
`id`	`STRING`	Unique identifier for the record. String format, specific structure varies by table and blockchain implementation.
`extrinsic_hash`	`STRING`	Unique identifier for the extrinsic. 66-character hex string including 0x prefix.
`extrinsic_id`	`STRING`	Composite identifier linking an event or extrinsic to its block and position within that block. Format is `\{block_number\}-\{index\}` where index represents the sequential position of the extrinsic within the block, starting from 0.
`success`	`BOOL`	Boolean indicator of whether the operation completed successfully without errors.
`event_method`	`STRING`	Name of the event triggered by the blockchain operation. Identifies the specific state change or notification emitted by a pallet, such as Transfer, Deposit, or NewSession.
`event_pallet`	`STRING`	Name of the substrate runtime module that emitted the blockchain event. Identifies the pallet (functional module) responsible for the event, such as balances, session, or treasury.
`event_data`	`ARRAY<JSON>`	Array of JSON-encoded parameters associated with the blockchain event. Contains ordered arguments specific to the event method being executed, such as account addresses, token amounts, transaction hashes, or state changes.
`event_index`	`INT64`	Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
`event_type`	`STRING`	Processing phase within the blockchain’s block lifecycle. Values include ‘initialize’ for events occurring during block initialization, ‘finalize’ for events during block finalization, and chain-specific event type identifiers for transaction-related events.

Sample Data

chain	block_hash	event_data	event_type	relay_chain	block_number	event_method	event_pallet	block_timestamp
invarch	0x0ea83a4442b7d65eb222b42035e17c34d45c4c322250d47d76cf7407b3ba8147	[""i4zM9rETRpQhXJVc3prWq8VVgRssnp8AjxSCmDYBLy4aGKzo9"",""i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33"",""104""]	initialize	polkadot	966283	Transfer	balances	2024-03-11T16:50:12.381Z
invarch	0x140e24883bfe5f2b7ae296738b30c5f2b1ebac798e53b7951dd35dbfb61a09b4	[""i4zM9rETRpQhXJVc3prWq8VVgRssnp8AjxSCmDYBLy4aGKzo9"",""i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33"",""2429""]	initialize	polkadot	967448	Transfer	balances	2024-03-11T20:59:00.562Z
invarch	0x1af6c2108ddfa23f6ff8912dc35b670f49bcab9f95240f3201f1e96d0ab1f0d0	[""i4zM9rETRpQhXJVc3prWq8VVgRssnp8AjxSCmDYBLy4aGKzo9"",""i4yEhMAj1p2PLpAYXTmft8ELmiotifkU15Mcv2WAC5LvczD33"",""226135""]	initialize	polkadot	964520	Transfer	balances	2024-03-11T10:33:48.363Z

Example Query

Query with partition filter

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

extrinsics

Substrate blockchain operations submitted to blocks, containing pallet module calls with method parameters, signatures, and execution metadata. Fundamental unit for tracking on-chain state transitions and user interactions across Substrate-based networks.

Columns

Column	Type	Description
`relay_chain`	`STRING`	Identifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
`chain`	`STRING`	Blockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
`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.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`pallet`	`STRING`	Name of the substrate runtime module containing the operation being executed. Identifies the pallet (functional module) such as balances, staking, or governance.
`method`	`STRING`	Name of the operation or function being executed. Identifies the specific action within a pallet or module, such as transfer, stake, or swap.
`signature`	`STRING`	# 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. | | id | STRING | Unique identifier for the record. String format, specific structure varies by table and blockchain implementation. | | nonce | INT64 | Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering. | | args | JSON | JSON object containing the operation’s input parameters. Structure and fields vary by pallet and method, encoding the specific arguments required to execute the operation. | | tip | BIGNUMERIC | Optional amount paid to the block producer to prioritize the extrinsic. Numeric value representing additional fee in the chain’s native token denomination, above the standard transaction fee. | | extrinsic_hash | STRING | Unique identifier for the extrinsic. 66-character hex string including 0x prefix. | | extrinsic_id | STRING | Composite identifier linking an event or extrinsic to its block and position within that block. Format is \{block_number\}-\{index\} where index represents the sequential position of the extrinsic within the block, starting from 0. | | info | JSON | JSON object containing metadata about the extrinsic’s execution. Stores information such as weight consumed, fees paid, and dispatch result class for successful operations. | | immortal_era | NUMERIC | Boolean indicator of whether the transaction has an immortal era. Value of 0 indicates an immortal transaction that never expires; null indicates a mortal transaction with a finite validity period. | | success | BOOL | Boolean indicator of whether the operation completed successfully without errors. | | pays_fee | BOOL | Boolean indicator of whether the extrinsic requires a transaction fee to be paid by the submitter. |

Sample Data

id	args	info	chain	nonce	method	pallet	success	pays_fee	signature	block_hash	relay_chain	block_number	extrinsic_id	extrinsic_hash	block_timestamp
i51xYXDdJvP7qbFVYWzPAPBQTC2UQDt52YN1uM7MPwAgdkAmd	{“core_id”:“1”,“value”:“115000000000000”}	{“error”:“Fee calculation not supported for this network”}	invarch	20	stake	ocifStaking	true	true	0xaeba1256aec4a08e50a98b36bbf1e63e290cc86f5651471b332160972bb0a25b00c6447ae8618ab6cd40c0b682b428ade87f7d195ccfa0909f2a4f563c8a5484	0x5e23faf2cb6bd77ba3dbe36e6e53911c07ebc7b0649b8bf872134aba48faddb9	polkadot	2044514	2044514-2	0x6fb358b22fc8a233b56e2f816e13c7ea63fa9cc0c36ecd5ba1296b344e76fbc0	2024-08-14T05:34:12.549Z
i51pv7b5jm6KkxikhmXewJS4cXe6SgfQmADdhKkJ21uDmA8ec	{“core_id”:“12”,“value”:“246074112517593”}	{“error”:“Fee calculation not supported for this network”}	invarch	106	stake	ocifStaking	true	true	0xfaf02de18388511d408c68e1af696cdf6e05f98724d925d469c28b505aa640728bc2451178bfdbbcc33a8c499b279d1291af579487f0b1d25a68d61805d90887	0x47b6e5e80f40b874a1ea48dc7c3c84ecb2ce0cd9ec56718a772095f3603d926e	polkadot	2043546	2043546-2	0x48ec69f52325c4e72cc3f54272016fe5bcb056e94c7ff5c8df8b05d0e88bec0b	2024-08-14T02:19:36.597Z
i52iHP5ahAM1ANVhT59TaJZwqYWs26kCJ1MDoc5zYvqkopwts	{“core_id”:“0”,“value”:“157639644275215”}	{“error”:“Fee calculation not supported for this network”}	invarch	100	stake	ocifStaking	true	true	0xea6418078360e59780d8eedc9698a0a53264d66e99dcfb25ddb7897b2a7a9d6a893e865cf112066fb834d767ec4ac12926f1e08d39ce0bf6a4b7cbb6d8fec98e	0x6e28f8a1b98b087265ad905a536b44b1bf5ccb4f7df8166bdb7b7eff45212700	polkadot	2047065	2047065-2	0xdec89b199d056dc60572495b546b3c8a2dae0b42761dc8aedfeaf34c3f9250b1	2024-08-14T14:12:54.531Z

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

events

extrinsics

​Tables

​blocks

​events

​extrinsics

Tables

blocks

events

extrinsics