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
relay_chainSTRINGIdentifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
chainSTRINGBlockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
timestampTIMESTAMPTimestamp when the block was produced. UTC timezone.
numberINT64Sequential 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_hashSTRINGHash of the parent block in the blockchain. 66-character hex string including 0x prefix.
state_rootSTRINGMerkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
extrinsics_rootSTRINGMerkle root hash of all extrinsics included in the block. 66-character hex string including 0x prefix.
author_idSTRINGIdentifier of the validator or collator who authored the block. Base58-encoded string representing the block producer’s public key.
finalizedBOOLBoolean 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_dateTIMESTAMPDate when the block was produced. Derived from block timestamp, truncated to day precision.
extrinsics_countINT64Number of extrinsics included in the block. Integer value representing the total count of transactions and other state-changing operations.
chainnumberauthor_idfinalizedtimestampblock_dateblock_hashstate_rootparent_hashrelay_chainextrinsics_rootextrinsics_count
centrifuge34165614cS65GoK9sfqJNRg5pmpYdvXyJhkYp9FmhyGJ4uRmTRoFzKWtrue2023-07-18T18:29:48.333Z0x0509d03583f99ee2951bafbade38de666c9f5f3d9191a84b1a9a5db640534c8c0xe01f0eecf599a3ca1bf623cdb09bcec0de7a7643c11b56db4a4bc6259f14c3000xf29821c4e0bfd6e8409fb77996a699b2eec82aceff7ba3367f07d21822cc6d64polkadot0x6ac415b98cdaf67c4f64bed1f30f5d412098ad623383b94e9d179908deb8e8552
centrifuge34175644cS65GoK9sfqJNRg5pmpYdvXyJhkYp9FmhyGJ4uRmTRoFzKWtrue2023-07-18T21:52:36.538Z0x1ea5752ddf0e9ae46cfb63170d3d69abd07053474addcee824f67257cfab7c950x42392a57435c00d626dd73ebcd006a46c343575adb1ed10479024b7baeda50b80xe749e7dc164dd08d81971e960829c7c005909448f8f3d2777583d37bb8201ecdpolkadot0x247064770fa39cd92de3f037ca9358efa041faddc8d3875a9212a380e1e071232
centrifuge34138044cS65GoK9sfqJNRg5pmpYdvXyJhkYp9FmhyGJ4uRmTRoFzKWtrue2023-07-18T09:10:54.305Z0x503ab3791b28708aebdc042a87a6877e93b8f948c9615f36ff658cd71225ce1b0xce75a3625cc9baeca678eb0e3eee7ced9183f4f9c37f7cfe4f49c32086ed76320x2cb6e19df4a076b2d01abc5527a03214e353bc6f758cced82271a446fea5744apolkadot0x33e48c49164764fe442ee2ca2ede1caa2fc4cd7f7d1c8472d4c601940b1f432d2
Query with partition filter
SELECT *
FROM `tt-blockchain.centrifuge.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.
ColumnTypeDescription
relay_chainSTRINGIdentifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
chainSTRINGBlockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
block_numberINT64Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
palletSTRINGName of the substrate runtime module containing the operation being executed. Identifies the pallet (functional module) such as balances, staking, or governance.
methodSTRINGName of the operation or function being executed. Identifies the specific action within a pallet or module, such as transfer, stake, or swap.
idSTRINGUnique identifier for the record. String format, specific structure varies by table and blockchain implementation.
extrinsic_hashSTRINGUnique identifier for the extrinsic. 66-character hex string including 0x prefix.
extrinsic_idSTRINGComposite 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.
successBOOLBoolean indicator of whether the operation completed successfully without errors.
event_methodSTRINGName 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_palletSTRINGName 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_dataARRAY<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_indexINT64Sequential position of the event within its containing block. Zero-indexed integer indicating the order in which events occurred during block processing.
event_typeSTRINGProcessing 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.
idchainmethodpalletsuccessblock_hashevent_dataevent_typeevent_indexrelay_chainblock_numberevent_methodevent_palletextrinsic_idextrinsic_hashblock_timestamp
centrifuge0x1ba861a1e22e47b05989d972263be89929dea03243e0c393673d5a2dd12c6377[""1488""]initialize0polkadot2678400NewSessionsession2023-04-06T01:09:24.226Z
centrifuge0xabf8209bee8060c2d4ac30a840aebe04bebce4ea884c519ccde0d35dc02b634c[""1489""]initialize0polkadot2680200NewSessionsession2023-04-06T07:13:24.371Z
centrifuge0x3d6c2ff8924220c23c9e8310bef1d0b01dd1f565acd2b9e062fc560affeb5903[""1490""]initialize0polkadot2682000NewSessionsession2023-04-06T13:20:00.315Z
Query with partition filter
SELECT *
FROM `tt-blockchain.centrifuge.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.
ColumnTypeDescription
relay_chainSTRINGIdentifier of the relay chain to which the parachain is connected. Lowercase string (e.g., ‘polkadot’, ‘kusama’).
chainSTRINGBlockchain network identifier. Lowercase string indicating the specific chain (e.g., ‘acala’, ‘polkadot’, ‘kusama’).
block_numberINT64Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
palletSTRINGName of the substrate runtime module containing the operation being executed. Identifies the pallet (functional module) such as balances, staking, or governance.
methodSTRINGName of the operation or function being executed. Identifies the specific action within a pallet or module, such as transfer, stake, or swap.
signatureSTRING# 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. |
idtipargsinfochainnoncemethodpalletsuccesspays_feesignatureblock_hashrelay_chainblock_numberextrinsic_idimmortal_eraextrinsic_hashblock_timestamp
{“data”:{“downwardMessages”:[],“horizontalMessages”:{“1000”:[],“2004”:[]},“relayChainState”:{“trieNodes”:[“0x56be89c98b91434fef07000080f7dcaa9de89d657c94f1bb6016e8e8e580df0d31b8ebcc76b8057585948c7312”,“0x5d0046f4f0e76585e8030000ef070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5d07ef7576b87a33ef070000d4070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5e414cb008e0e61e46722aa60abdd67280c39960a6390dbe0f96eeddd4cb0a91ad87ab6e64d719fd1bd70b8bf8573f7a06”,“0x5e55851595ababf9ef070000e8030000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5e77dfdb8adb10f78f10a5df8742c5458401778593378a33daf3205fae18abc67138246bee311875a5d7e132d476077eb68d”,“0x5e9b85bc463fb44dd4070000ef070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5ee678799d3eff024253b90e84927cc680d8e21ff9276ad8c6aa4de00b80a33e555269359e46019280a1187010c9e63722”,“0x5f04b49d95320d9021994c850f25b8e3853d030000a000005000000a00000000c8000000c800000a0000000a00000040380000580200000000500000c800000700e8764817020040011e0000000000000000e8764817000000000000000000000000e87648170000000000000000000000e8030000009001001e00000000000000009001004038000000000000000000000a0000000a0000000a00000001000000010500000001c8000000060000005802000002000000580200000200000059000000000000001e000000280000000700c817a80402004001010200000014000000”,“0x8000148004b5bc901e3b3443b63bfca3c3c3a44ea2a7cc48a9e01330c9859e34f0fbf921807251152a0b19389f97ad599b651bcd5c495cd5dfe21349d8ecfffbbbee970a0e”,“0x80011080138ff1543a6be9d3588d4a7606344de8797fac5b4a522640d251227a1a4a2a22800ebe650369ce0e3ce85b22816181f598cc6ecf7a3b22314357ab4181b9ccb867”,“0x80011080704bcafb04e3e42d30bc359a9e1010cd5c566cfabb2e62ea696f0ca0c533382180028bd82bcd6201d61977439cedc29c6e97ee1d939a7cfd06ea9d45cf4082dcd1”,“0x800404801f8c5940bb92977d89e30a335a296ca56a9ceb755370f6421d3bba50612f74ea80ee3cefde9becc4b979a6a8b0f26e44656fb9640467a214f7f980bcae7d338996”,“0x80046480ff82ddd2e80853f1bf9431e3b65779f298296da7cfbf7aef417cda81e0e487168090a360a1c783711c899427721c99dcc875dd307370d8f882da8fd6b9e73180b880ce17a62aedc56f1b989a0ffc2646bfa859fbc21a25ea260f60ba9180fec855ff80993f429dd8cdb8a09b18d21748e7a28ae823d597a122f3ff5f6795c2d68fc97d”,“0x80080480844a4452d7f9a340bbf19697cb9bf9dde3c1effaf802d433964df6cccc60fd05801d95b9ab0c30ffaa91ce1dda785ed8240760e69de6a615ff4e512dbd7cc0c461”,“0x80082080a44c0d1f91e715c1dff17e6f1ecdf100feeb9126a982801427b8a936192cbc58485ead6eef5c4b1c68eaa71ea17a02d9de0400”,“0x8008c280e3febb7d72dc23da1929c4b2a0854311f19a9ed6812370e1df34b3dc005e18e88049da90db410ddc5fcb63a6ba31fff1140f1f027eab9f575207946938a6dff049803532fad3b3f17f2ed4271c716f42763952cabfdc4f82002ae1ef9259170e57d5807ce6f0fbe29569dc3b249b1b28ababfae71448fd2fab2c7d88d8521051e6975a”,“0x80101780e3f91f08bec1a46d6f2234414ff0594c21dbc36be58ef7f758b1b9c8fdda08ed8033693053ae9aad367632c02f2db4172fe56927ea356c49274b58a3d70a1f47198069bf6842145bf277fa518a5e8cf0df2c5f2edc48e071ae86f2a8a61c87bb26c7802fee57423de2ed3e3b4910ca4cccb2a6ee52ba6ac95eedb46fc64373456dac6580e7933fddfc23b7c3e0b24b80e4bbd380bd6a920b53a4ab0c7202ae69fbd65f54”,“0x8010408055f7120dbee2fc56df98dae7b16f99a6c1a0083180db28e75a0c7de276fb89b0805f738e2d7016159bb83f0acfc05b94f3bfed39826328fbea9a5a6844b0ee9f62”,“0x80120080b00c1d225fcc9cb41d533a2518033a041f3dc763f96ba9e944394a752fb9d64780a18673b451b154098a7a400495526a375c86a62e3c8f6def0a67b00eb6d26e87”,“0x80308080c26d737ae224d2f3ec3e7c021248ec7d78340ccecddd3c1ca042f8a028cf5dab80d43aac2ec8df93850d8fb9e7bea864d228418eec6cb9cd00f7803b98f0b6c35e80e052ec155aa308264bcbf0c9c7d3227c8eb67ade519ef1b9ba96bb30d5142b32”,“0x8040088003e3c9ffdc6de7292806d3e17c16b7fc8586d592ff17929e523f901f387cf513808c68f773671aec1db46b2c37b4c827e64aa7290d65e305cdaaa6b175596256f1”,“0x80650080a4821e6364e1ddbfa8d2e71d62a5c1f9be01a14bc6368c24ec2716025759eb5e802b251ca4a3b1bf0dd413a91933ea701cea65a41579a67905dc303104c55bae6380134e4b2139141d4977d202cb56c77e753fa01d64207b19d5069cfa65848af61780af579d5ddc5c697d42bfc014076594e66c7b324cfd3017810c4e93e4f6f0ae9e”,“0x80c00080416d0ab2e57e6c614e9fd5f64809b2a699c3586a59502e7b5ad32603f890243c5856be89c98b91434fef0700002408e8030000d4070000”,“0x80c00080b9b4ddcf32d17318666d702f438abfe1baf7b6926b9900618c16cb950c7ff6f45856be89c98b91434fef0700002408e8030000d4070000”,“0x80d100806533f89ae3c08448bb808f0c4940196fd41d6fb1f14a9db55ba5be7df17a31ca80c55d6afaf0725e68da40edfdc552121da792ec702a32bae2011e4c113e3346b7807e102a07c6211231c0e6e016fe4b1edb62ff4b87ddb29bbebbbf299eb6472354806275e8fdf1a6a5c07ab904edcadf8893211338d63a55d8104ba299d9e6bcc67d”,“0x80ffff8062e0760c4c33b186370bf03610824735e930ede99137c4744b7d190ade6e9148807812cd5c0cd8e3836ba8fd3be43cc7b179ba35a1072dc28cb1820f7c750ea47b804875ac41c4b40043178a1f354eb8cfed3e3d37f986fe5fa6ab53cbf0977ae6a0802933611de1cc2e8d9dade8c5678c7b9950de3e1d3c61cbc2c26af33110f6c7c98049f18b393a490e5f846fe6f4a188c8b0e28493943dbc7a525110861a60a3e1b18057281355ba6845f226fdad30ce98c20e33d211b1026fd04f891a28d79d1437f680857e9e203780e04f290460a1954defc8cc29b94703747544f808567cf58d93c18055347b5ccf5d6619f578b487c0bb0a16d30003ef4e0ecce10112525f69493d3680e42a53a4f279ef125ba7a5c83905b88fb97996d814207ab69f7fdb1e73392db580b6d3e3d060dff26d0f21e6ab5caa14dadbc5f562dca08ac6cef62cd9da1146888013f2b31c4144ab005eb771242609e34fff174be8e521b0a0982d6518b2ede66380edc572c8142d5e863b7094e2a1393c6008e48c20e375fd07bd70240dd4dd002180913aa778ba5f6a380d9afa7b4cc75d9b831cff957b98c31861772509e577072480198913767eaa145000d564edbf86fc4c6129e4bf74f1416be224a2167fc3941680296ee89cc5c717285f6176e682e451f0bf36903b4e116b3f8cad834a60bcdaf780d26df57c3ae3f0f177af851280b7477d6454040fa9a2f49db19399a6177a0a5a”,“0x9d007f03cfdce586301014700e2c2593414080776fdf331ededb557c273c87efa8d2e3919d6745e8645214665bf43afed8b5e9685f0d9ef3b78afddab7f5c7142131132ad42001000000000000004c5f0ec2d17a76153ff51817f12d9cfc3c7f0400”,“0x9d0da05ca59913bc38a8630590f2627c07d9800595f45ce013262d2730563c19c532d61b71f53605e67d135f0c58a4956dc86c80e1ee9e091b478bedf1f39111330d97dc88481c3f5b399a2cdfc9f16643d9a68c80711b0853e07b6ee8a83a4101fd99c2f8ccbf9debbddf53d68a2c4ab44d2af41780e7330800b00f380de0354e1d3fbace0531b8a5550fa4a32f659b7f6e491039e7803419ab8fb8cafaf404fc1a5fd65a56c93de37f4acb0002f6e28e50a8dcddc31c80ceab5d0ecedb7ac8f712b90fef3e7688b6e36cf9c14a34337926e921e0ec880080fe20d9a744142b01474930a28d8b9a5ef3c851504a99fed5a4fec46d0533c7d880f4ef6a08e3569e3a85d86e931734475841d274b2f53bcc6c44cb57bdadc294f1”,“0x9e710b30bd2eab0352ddcc26417aa1944fc380bcc0ea29054e30153438a1a010041c3e34979756f648c502846ce6c8eacc73df80de55429c3a257390dd8e89787f9f7fa9c21ee2cd2e1ea47f6e4d0495bfff7a5380ac1a8194d2c6c7030fd6a3404928160bef51a9bca32d28125fd0a8492fea9d32800336ed49851d24337c0fc20c963fb1b85b0c24c2718c7696d23ab57ac610c94f4c5f03c716fb8fff3de61a883bb76adb34a2040080070d52e4745030654b7b412fc3d20043f2770eed801d6c665cc5b4b7c10461554c5f0f4993f016e2d2f8e5f43be7bb259486040080064537dd75ae39487db5a88c83aadda03f65a95c78c4c6cb1def94b18b9eaaf3808bb05138604134117a68ae7080432cd8ffb791aa0b95e59c8831e0b0a4c191a9”,“0x9eb6f36e027abb2091cfb5110ab5087ff96e685f06155b3cd9a8c9e5e9a23fd5dc13a5ed20e5bca41000000000685f08316cbf8fa0da822a20ac1c55bf1be3200617000000000000505f0e7b9012096b41c4eb3aaf947f6ea4290800008080f6989a7f8d0c039c56460641f3972dadc3cbe970799de2d9ea23fecd5d26c48084a80a22d77d8016adc89610b528c15ba17e4522a53faec0e60d84f5130362a580936d4c537006068a5f53627d78d01b903f7b66b9df7e8d0b13c00fc8aae910db800d49fef039517cc312c00412803ca1df50ac6d90c50541f649a9c85b83c0fdd880e2e4fd649f930fa88477ddd1662e5d414cc4718252768e985e63780fd1b0e92d8013959a94c76a9853c3aa21f5a09758b8ec5b1b47e4b451259c02fdac506749aa806c4270312d7cb26eedc69f9fc1be88b39ead4d5b334392c44d86c47e69ff0a5c685f090e2fbf2d792cb324bffa9427fe1f0e207dc7d600ddd0d600”,“0x9ede3d8a54d27e44a9d5ce189618f22d3008505f0e7b9012096b41c4eb3aaf947f6ea4290803004c5f03b4123b2e186e07fb7bad5dda5f55c004008057ab6abcf895dece27a356a900a7daab1355e0d2c9dacb1b2930ee85d3f31970”,“0x9ef78c98723ddc9073523ef3beefda0c100480166727f660b0142443b60d073fe48f19d1841435e983fe047d5f0996e6e377d58067361e344e35cd60a3fcdbe86b1ea23d6948fa086728f57b36172991cf777a9b”,“0x9f012b746dcf32e843354583c9702cc020eabb80be285bb4533a72e5ad87807bf82144a96fd4bcd9430bfa5cb1e7ec5f5f741aa680d11d71ea91a8cbe9858770d23355ed19ad19a263b94d55f6d6f503c17eb3dd524c570f9d7e46afdef838d80700001404db07000080bb7fd6b2fa22db69bca4f70304addc539798fc6174ddae0c5865c71ff96e53415c5700bd9a93e85e3ce1d20700002408d6070000dc070000808bcf4df698258721a43ddc4ca2ac34124f6472a731baa4bb5df016ebec9a92b180606eed2df93dcf07a651dfdfba8c111064063610fa645ca2dd9619e653be48f3801bff773d6d6d765292b4e595ee0cd425bebe341c2f21af1768896cbfb71cc5d080f4a289f11f4c53a1d4a74a5d5f27324423ca9afd2902f5b387264aaa67e2184480f16a8f3131a154cf5d143f612a03093561b7ce489a137180482ff8b80979f1af80c8f9b7ce6ae92a9823fde5f89232e76394eae663b855650d808c17c2f30cc4cf”,“0x9f06604cff828a6e3f579ca6c59ace013dffff80a2093fc461229cbbd6354497a92c5554db05d14ac0bab19637e335bbe38d0bb680674dcca1090449014176f16c374f8a5ee09c204a8b8ca4f352730c44b6b60de080d01ef690c8bfe57901178303317289b43c8e4615e85ead821449d1c7a2dcce2a80cc8ebdf221450bef043cd53d6d13353f47dfe843f3d353d810ef0bee6f521ffc8092bf722f1a68194eac15e8bcf78a11ef285f02aeca76da0b979c0a4bebf4f0fb80d9f513e9484a082cd4358ae625a99b49f6974e03feb87fbfdbf024ed12cd74c4801317f8cd90578670a90513979bd3d232d66e7154f0884f7f98bd16e7e0adfde3807dc2bc1fb3e0046b3fbe8df63625d3bb33943b70bd107322ec5209d54a01ab42809c0128e2fc0bf4ef020b1b2886cffa809c4642f8ab08732ac76cdf4b8c408653803737d1d37e1668f0037711eb9299ace7fc14990b3ae9ca70cb04d1a6345fc17d80a7728f39a2ecacf79df86eba12b3f5d1b0f5be980fecfff3f0f1fbcc089681e9803a05bfab427c22880f5f3228b27482759988bca342dfccab70db17c7f1b79aa680d1cc8d0a6e0e7a22a9754ad1234d61d57332d2cbee746f89a7eb88b1d401148b80ee1860f50f04070a2cf7b4fb430033d4d18e6cc23dacfcdf2b54b9e156fba8ec800a6e05f132ae208a138d02250ebf7c71c90aa0db67fec1f593880addff43730e80c46bb98cb24fe54f8de69616c59815a4640c57d03790499fdfa2aa2461740020”,“0x9f0d3719f5b0b12c7105c073c507445948eabb80908a4b83685980351382690794f2ba84e53bde8de88ac588b0e0cc0ddff6b03f80378f52923a50ac752516512c3e08c4ac56319d3f204e39130eb69677a056cc9e4c570f9d7e46afdef838d80700001404db07000080cc0c38844aaa6edb1a75664c79c04a921573e48fa1dac5b44102cba2e60e4b315c5700bd9a93e85e3ce1d20700002408d6070000dc07000080edd8485cf492fde213ad27d181bb185d82a7fd734e016f7d886cf1a07ff474ee8028a273f1472cfb688c72f4fe25bb3342654ac0b83efcc1be38583e74085318228019cbbdbf60cd90027c802d921f737c07a073bb4bed3b9ff0c37b26506e6aafc94c57077a93d174890f1ff20700001404d007000080f16a8f3131a154cf5d143f612a03093561b7ce489a137180482ff8b80979f1af80d8add93605afba18029c91cbc9d466eeeafa817f66eef4acb71f09da522c276d”,“0x9f0d7fefc408aac59dbfe80a72ac8e3ce5eebf8090c4266f78adf45d14821097898ef0db88d034a5e5d82c86c7e71cf3d7bae448807e1ee2c8362cd0745aa0c58780b99fefa1024c1b472d3386a2319e71b68028a68061e8333726261ca910eb3a3ead1bc90945c46789ed19c7d33aa06303febd447580b8c46faa970910f4a062f43b47ab14880158131c396e3fb7169e5e6cb50b517a804e47b9b74a9d21bb3e284be6aec2b65e2dedcba4dc876f4ebdbf1ef3ce19057080a8842b069c158af198d7d570838f69a2f4c9a218d51c69ad60361a873a11bbea8055bd0c6232f3521e18355ae206891b33839524b0decb85a5dea18d31a01c5eeb8098f361953fd49bf2e61ccb395b765c065e369b404e3d8bde1c707cdd76158440807b3ccf9a93b86b26e892cd0ecb9572f84edb92f6f170f5c1670470d17a68dc478038d74d42b49e90f7940af56252528e79c5e42adf473905d7febfbf10ecb60adb8038843c02fd420fbe859e96b0b059908a5db74608489cac5ae7774e55efd2310580f594c54d94f934898a07cb734b13922b23f2abec20386163a92adae02b04c81c805598b57ac0ec2a900028bd8812872243daf12dd927c1fd162789f669096d098a”]},“validationData”:{“maxPovSize”:“5242880”,“parentHead”:“0xbe0b19ab3871350275b58375925c33dc572290d79f6a5734084835c0569a37ff96fe880082ceba325bdd6e6c01bba5b90a1946277fd94cff958b5e05b59e6c5ec4d2d5c3645646e3999fe59eee8163c5f2a8fc58fead3cb9005447cafebcb0dfabf162bc08066175726120715e520800000000056175726101012a3ede484b18965a7a9fd6deed7910966575ed4081dd88789d9becc1c27c5b70b6a15df816bba616965a6518017983b827cfde90bc507738a7a3781122123281”,“relayParentNumber”:“14079727”,“relayParentStorageRoot”:“0x87d9eb6f366782bcce319219042dbce28a9d5077a21eaeaac58f577ffc6957f6”}}}{}centrifugesetValidationDataparachainSystemtruefalse0x6da95738e84db085d7151f819c16393caf15c0a5ff4e7fb836eff5ff2de1b838polkadot22445182244518-000xf2a4e69a7c9753079bf714e7d3ae59b472b6cf974ee6bba9edbe31aced7ebca22023-02-03T02:11:42.389Z
{“now”:“1675397022289”}{}centrifugesettimestamptruefalse0x143f7912235c7f85cfac2055b3d72d78ba9a5edb2017ec384889933b8cc17985polkadot22450692245069-100xaf05ac67e0b17257377759a90ed3d2e2d11331d780c029bc4f8cac3522b2ee9a2023-02-03T04:03:42.289Z
{“data”:{“downwardMessages”:[],“horizontalMessages”:{“1000”:[],“2004”:[]},“relayChainState”:{“trieNodes”:[“0x56be89c98b91434fef07000080f7dcaa9de89d657c94f1bb6016e8e8e580df0d31b8ebcc76b8057585948c7312”,“0x5d0046f4f0e76585e8030000ef070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5d07ef7576b87a33ef070000d4070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5e414cb008e0e61e46722aa60abdd67280d8e21ff9276ad8c6aa4de00b80a33e555269359e46019280a1187010c9e63722”,“0x5e55851595ababf9ef070000e8030000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5e77dfdb8adb10f78f10a5df8742c54584015613e23dff4bdff4585a9ef3302935dcef2822e79039a780f0a1955cd7a34ffe”,“0x5e9b85bc463fb44dd4070000ef070000d4e8030000009001000090010000000000000000000000e8764817000000000000000000000000e87648170000000000000000000000”,“0x5ee678799d3eff024253b90e84927cc680fdfc5d78a5e496918541b6ac7507ce37bc8b2820d8f66ae090dcda811ba76f60”,“0x5f04b49d95320d9021994c850f25b8e3853d030000a000005000000a00000000c8000000c800000a0000000a00000040380000580200000000500000c800000700e8764817020040011e0000000000000000e8764817000000000000000000000000e87648170000000000000000000000e8030000009001001e00000000000000009001004038000000000000000000000a0000000a0000000a00000001000000010500000001c8000000060000005802000002000000580200000200000059000000000000001e000000280000000700c817a80402004001010200000014000000”,“0x800014805d1e97c921199ab17eac0f07f86cadf70abdb7ed18dbf173803adffe16cc41b780067cf32eb80120b4f61b5546498c293140449b92810466e89e67ad83bcd48ec6”,“0x800110806a0e1050bc4c12760a283cee479af5c1f8e3278791acd6972f893022f0cf63d9800ebe650369ce0e3ce85b22816181f598cc6ecf7a3b22314357ab4181b9ccb867”,“0x800110807efde6f291a4d8b63ffbcd098b704f40d16071099c6de0ede0eac405d634932380028bd82bcd6201d61977439cedc29c6e97ee1d939a7cfd06ea9d45cf4082dcd1”,“0x800404801f8c5940bb92977d89e30a335a296ca56a9ceb755370f6421d3bba50612f74ea80ee3cefde9becc4b979a6a8b0f26e44656fb9640467a214f7f980bcae7d338996”,“0x80046480e26165dfad3c880427e0d144a66469975c034a4dc1b526736c244d043f84dcb28090a360a1c783711c899427721c99dcc875dd307370d8f882da8fd6b9e73180b88054595dd4f89cc7b0a07ab7e63319b0e288b8d2d30c05663c9707de46518c805d80c53cc9abcace3fe4a6e59c29def3b290ea73c6918d8b2f8d9eb56b83bfa6c1f1”,“0x800804802f92629ce334ea77b6474088e985d635c480728793b1d83580afcf24eab137ab8085edb23aa7f535353e9be399a998b9766920fdf0b01b1c9e37045a5ffadd6b11”,“0x80082080a44c0d1f91e715c1dff17e6f1ecdf100feeb9126a982801427b8a936192cbc58485ead6eef5c4b1c68eaa71ea17a02d9de0400”,“0x8008c280e3febb7d72dc23da1929c4b2a0854311f19a9ed6812370e1df34b3dc005e18e88049da90db410ddc5fcb63a6ba31fff1140f1f027eab9f575207946938a6dff049803532fad3b3f17f2ed4271c716f42763952cabfdc4f82002ae1ef9259170e57d5807ce6f0fbe29569dc3b249b1b28ababfae71448fd2fab2c7d88d8521051e6975a”,“0x80101780e3f91f08bec1a46d6f2234414ff0594c21dbc36be58ef7f758b1b9c8fdda08ed8033693053ae9aad367632c02f2db4172fe56927ea356c49274b58a3d70a1f4719807fb8fa2d67944e570614b882a2c5f149ff403a000635a785f530314b486f93d1802fee57423de2ed3e3b4910ca4cccb2a6ee52ba6ac95eedb46fc64373456dac65802b1d57a72a7ea85bd0454667cfa7cea5c527fee80c7a4882634c3d7a7d3d679c”,“0x8010408055f7120dbee2fc56df98dae7b16f99a6c1a0083180db28e75a0c7de276fb89b0805f738e2d7016159bb83f0acfc05b94f3bfed39826328fbea9a5a6844b0ee9f62”,“0x80120080b00c1d225fcc9cb41d533a2518033a041f3dc763f96ba9e944394a752fb9d64780a18673b451b154098a7a400495526a375c86a62e3c8f6def0a67b00eb6d26e87”,“0x80308080c26d737ae224d2f3ec3e7c021248ec7d78340ccecddd3c1ca042f8a028cf5dab80d43aac2ec8df93850d8fb9e7bea864d228418eec6cb9cd00f7803b98f0b6c35e80e052ec155aa308264bcbf0c9c7d3227c8eb67ade519ef1b9ba96bb30d5142b32”,“0x8040088003e3c9ffdc6de7292806d3e17c16b7fc8586d592ff17929e523f901f387cf513808c68f773671aec1db46b2c37b4c827e64aa7290d65e305cdaaa6b175596256f1”,“0x806500805532472b1df03310532e75ec556aa0498c600fe34cdc849fe1ac74451b000efc802b251ca4a3b1bf0dd413a91933ea701cea65a41579a67905dc303104c55bae6380134e4b2139141d4977d202cb56c77e753fa01d64207b19d5069cfa65848af61780af579d5ddc5c697d42bfc014076594e66c7b324cfd3017810c4e93e4f6f0ae9e”,“0x80c00080416d0ab2e57e6c614e9fd5f64809b2a699c3586a59502e7b5ad32603f890243c5856be89c98b91434fef0700002408e8030000d4070000”,“0x80c00080b9b4ddcf32d17318666d702f438abfe1baf7b6926b9900618c16cb950c7ff6f45856be89c98b91434fef0700002408e8030000d4070000”,“0x80d100806533f89ae3c08448bb808f0c4940196fd41d6fb1f14a9db55ba5be7df17a31ca80c55d6afaf0725e68da40edfdc552121da792ec702a32bae2011e4c113e3346b7809b440e01376677f9cbde84184fce6658594a5acac83dffd845535a17729065b8806275e8fdf1a6a5c07ab904edcadf8893211338d63a55d8104ba299d9e6bcc67d”,“0x80ffff8062e0760c4c33b186370bf03610824735e930ede99137c4744b7d190ade6e9148805798cff06469c175aa0d1300f009c4a329ad268b18f2fac29fcf3f8e774d246080a1114a8cf8e6efb920a6c05dc1084d0f155702856f518dbb45037bd7e4afb01a802933611de1cc2e8d9dade8c5678c7b9950de3e1d3c61cbc2c26af33110f6c7c980329f876095aa69bf09281dc7e614c13e302003297bf8f250d043bd5ab44423c1806535baf143faedc53d2ac0431de86bc82e49940fdffe7abd930edec4eb0a812c802791da22192339718d4dc1067583423183fa77d5cd2220353122105a96585a008053dbedb5057b3457cfd4d904aa21c347e5cdab3dbedb133617e83e927ab35f138071ed885f5229c96d3a4094fb50617ad20d275c1e19bb3b121dfa7faf0c079a0e80fd804424de90a05bdfd7832e856f84d12c7bdc9d7faf30188b07cad5c681d3c28013f2b31c4144ab005eb771242609e34fff174be8e521b0a0982d6518b2ede66380062ba587e7a4f79dac34966f56242ab0ae68c20f3d06425fc5dbb26db479eda680f241d75887bb91e81c147a1460582dbca1617ef85378707ac05f57942000a3ce80198913767eaa145000d564edbf86fc4c6129e4bf74f1416be224a2167fc3941680296ee89cc5c717285f6176e682e451f0bf36903b4e116b3f8cad834a60bcdaf780bb6204e44c37d38fd2279704aaeed3f5c99f8cfc6fd6e4a155992897cbab795c”,“0x9d007f03cfdce586301014700e2c2593414080776fdf331ededb557c273c87efa8d2e3919d6745e8645214665bf43afed8b5e9685f0d9ef3b78afddab7f5c7142131132ad42001000000000000004c5f0ec2d17a76153ff51817f12d9cfc3c7f0400”,“0x9d0da05ca59913bc38a8630590f2627c07d980e68d5be6f4cee09ae8c7db9923cd18b9b681205eaa731afde5e6070da15b470180e1ee9e091b478bedf1f39111330d97dc88481c3f5b399a2cdfc9f16643d9a68c80711b0853e07b6ee8a83a4101fd99c2f8ccbf9debbddf53d68a2c4ab44d2af41780e7330800b00f380de0354e1d3fbace0531b8a5550fa4a32f659b7f6e491039e780309f424b64e09fa06004075a2f64cea6d0c07cf73829d8c964cc65d2e81334bd80ceab5d0ecedb7ac8f712b90fef3e7688b6e36cf9c14a34337926e921e0ec880080fe20d9a744142b01474930a28d8b9a5ef3c851504a99fed5a4fec46d0533c7d880f4ef6a08e3569e3a85d86e931734475841d274b2f53bcc6c44cb57bdadc294f1”,“0x9e710b30bd2eab0352ddcc26417aa1944fc380bcc0ea29054e30153438a1a010041c3e34979756f648c502846ce6c8eacc73df80f02d43e2444312fae873f50f3e356e2c23af5eb56a90e67db3b2005afd1fb81780ac1a8194d2c6c7030fd6a3404928160bef51a9bca32d28125fd0a8492fea9d32800336ed49851d24337c0fc20c963fb1b85b0c24c2718c7696d23ab57ac610c94f4c5f03c716fb8fff3de61a883bb76adb34a2040080070d52e4745030654b7b412fc3d20043f2770eed801d6c665cc5b4b7c10461554c5f0f4993f016e2d2f8e5f43be7bb259486040080064537dd75ae39487db5a88c83aadda03f65a95c78c4c6cb1def94b18b9eaaf3808bb05138604134117a68ae7080432cd8ffb791aa0b95e59c8831e0b0a4c191a9”,“0x9eb6f36e027abb2091cfb5110ab5087ff96e685f06155b3cd9a8c9e5e9a23fd5dc13a5ed200cc7a41000000000685f08316cbf8fa0da822a20ac1c55bf1be3200717000000000000505f0e7b9012096b41c4eb3aaf947f6ea4290800008080f6989a7f8d0c039c56460641f3972dadc3cbe970799de2d9ea23fecd5d26c48084a80a22d77d8016adc89610b528c15ba17e4522a53faec0e60d84f5130362a5803a10680aa1d79371a10706738e7618294e51f048104d06820c1fa420a6241f96800d49fef039517cc312c00412803ca1df50ac6d90c50541f649a9c85b83c0fdd880e2e4fd649f930fa88477ddd1662e5d414cc4718252768e985e63780fd1b0e92d8051c36493cf533b306093ab1849280707b77ca655e16f9261385f62107115762a8048a941ea6506eeeebc0423f946c47515ec8432db6349bd20d22a944752c92214685f090e2fbf2d792cb324bffa9427fe1f0e20ddd0d6003ddad600”,“0x9ede3d8a54d27e44a9d5ce189618f22d3008505f0e7b9012096b41c4eb3aaf947f6ea4290803004c5f03b4123b2e186e07fb7bad5dda5f55c004008057ab6abcf895dece27a356a900a7daab1355e0d2c9dacb1b2930ee85d3f31970”,“0x9ef78c98723ddc9073523ef3beefda0c100480542a67c2f2b56e7f4681e1ae632ce394742c24019a63268afa6b4379199141298067361e344e35cd60a3fcdbe86b1ea23d6948fa086728f57b36172991cf777a9b”,“0x9f012b746dcf32e843354583c9702cc020eabb80be285bb4533a72e5ad87807bf82144a96fd4bcd9430bfa5cb1e7ec5f5f741aa680d11d71ea91a8cbe9858770d23355ed19ad19a263b94d55f6d6f503c17eb3dd524c570f9d7e46afdef838d80700001404db07000080bb7fd6b2fa22db69bca4f70304addc539798fc6174ddae0c5865c71ff96e53415c5700bd9a93e85e3ce1d20700002408d6070000dc070000808bcf4df698258721a43ddc4ca2ac34124f6472a731baa4bb5df016ebec9a92b180606eed2df93dcf07a651dfdfba8c111064063610fa645ca2dd9619e653be48f3801bff773d6d6d765292b4e595ee0cd425bebe341c2f21af1768896cbfb71cc5d080f4a289f11f4c53a1d4a74a5d5f27324423ca9afd2902f5b387264aaa67e2184480f16a8f3131a154cf5d143f612a03093561b7ce489a137180482ff8b80979f1af80c8f9b7ce6ae92a9823fde5f89232e76394eae663b855650d808c17c2f30cc4cf”,“0x9f06604cff828a6e3f579ca6c59ace013dffff80a2093fc461229cbbd6354497a92c5554db05d14ac0bab19637e335bbe38d0bb680674dcca1090449014176f16c374f8a5ee09c204a8b8ca4f352730c44b6b60de080ad5aafcc0284c9b070712821bc5d870c5f1173cdf0c86e144a4b7c90c995afb380cc8ebdf221450bef043cd53d6d13353f47dfe843f3d353d810ef0bee6f521ffc80f887b04d1eb8b08069d187353415e1efaabc57c5c1853850c66d468b434bd7e180d9f513e9484a082cd4358ae625a99b49f6974e03feb87fbfdbf024ed12cd74c4801317f8cd90578670a90513979bd3d232d66e7154f0884f7f98bd16e7e0adfde3807dc2bc1fb3e0046b3fbe8df63625d3bb33943b70bd107322ec5209d54a01ab42809c0128e2fc0bf4ef020b1b2886cffa809c4642f8ab08732ac76cdf4b8c40865380e257ad06d4b0746f135f17ddb049efec1a5c5d4ff5b446d14ccc13718aaa44df805406b30c5149a3a57862bdad5c8b18bb2bc2656d661ed88d89b648d50025a49480ac64fad41f0a3cb34c69315ceb54caf0345d4df5e6f3cecdf76d3913df38e71080d1cc8d0a6e0e7a22a9754ad1234d61d57332d2cbee746f89a7eb88b1d401148b80156cfe24cff6c0e1c952b3bfb52e4b5f25718f89666946099fb2293b0f8140c680a7d764f78d424492cdb9e8edbe12e4049136eb0021cb1f3f61a76638ff27167e808b460ed97b309f5f9b34d38c0a7285a87b51117dc5512ada0c96f53690f57f34”,“0x9f0d3719f5b0b12c7105c073c507445948eabb80908a4b83685980351382690794f2ba84e53bde8de88ac588b0e0cc0ddff6b03f80378f52923a50ac752516512c3e08c4ac56319d3f204e39130eb69677a056cc9e4c570f9d7e46afdef838d80700001404db07000080cc0c38844aaa6edb1a75664c79c04a921573e48fa1dac5b44102cba2e60e4b315c5700bd9a93e85e3ce1d20700002408d6070000dc07000080edd8485cf492fde213ad27d181bb185d82a7fd734e016f7d886cf1a07ff474ee8028a273f1472cfb688c72f4fe25bb3342654ac0b83efcc1be38583e74085318228019cbbdbf60cd90027c802d921f737c07a073bb4bed3b9ff0c37b26506e6aafc94c57077a93d174890f1ff20700001404d007000080f16a8f3131a154cf5d143f612a03093561b7ce489a137180482ff8b80979f1af80d8add93605afba18029c91cbc9d466eeeafa817f66eef4acb71f09da522c276d”,“0x9f0d7fefc408aac59dbfe80a72ac8e3ce5eebf8090c4266f78adf45d14821097898ef0db88d034a5e5d82c86c7e71cf3d7bae448807e1ee2c8362cd0745aa0c58780b99fefa1024c1b472d3386a2319e71b68028a68061e8333726261ca910eb3a3ead1bc90945c46789ed19c7d33aa06303febd447580b8c46faa970910f4a062f43b47ab14880158131c396e3fb7169e5e6cb50b517a80ba8bc4911dde21323c7a92953a6c6b4b141241869f194dad6b53e14e247408d380a8842b069c158af198d7d570838f69a2f4c9a218d51c69ad60361a873a11bbea80bcd0f1cfef6d71892546004ffa6edc5ec02b9bdd20925c264f360b9739befdff806cd99b065f49e0148ffbc93271a758ee78eed0214006254a6450ff29a86fa4cb807b3ccf9a93b86b26e892cd0ecb9572f84edb92f6f170f5c1670470d17a68dc4780797c52bed11ba76515c067dd43b2b20ee71d46e1144f7aa3e143e32d7e3c08cf80bbaac43edc88a3aa7f70795a8cf0866d48b9456fa6617e9e24588c03eacd65a78007005a7aca11ea0d2c67a48ecd886f279cc3cfd78b95ed04f419ae01b231af6a805598b57ac0ec2a900028bd8812872243daf12dd927c1fd162789f669096d098a”]},“validationData”:{“maxPovSize”:“5242880”,“parentHead”:“0xf3f7ad70617230f8e340424267b90f17ae7719f990d9d6e05b7202db534f8feca6128900d3e82a4f3e98ed33c2364b675f0756364dc196f860bd3e7953ad8f7b20a09591f52b9abd87e70126623b302788991e689b232af19d385074c1e0078990c45a7808066175726120856352080000000005617572610101fefb954c51ec096ab1760f44a5137518e16bcd187e766f2ae5d499cdf3836a0106667a4bd4fcd4a9f16d7cd20585e3dee12971c5284ca873b42b58a9c87aae87”,“relayParentNumber”:“14082326”,“relayParentStorageRoot”:“0xc470745830b207114ba995d9000b42d1c8998632d8e89bfdc097649850ba412e”}}}{}centrifugesetValidationDataparachainSystemtruefalse0x1712727d7dc9f300e9550663e7721d910cb13d3163a673e214f831011362aff5polkadot22458022245802-000x46ea1e62003ca51fa2a02743aeccdf248c53fa1982d2fd14f64b8618245ee13d2023-02-03T06:31:36.175Z
Query with partition filter
SELECT *
FROM `tt-blockchain.centrifuge.extrinsics`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100