Skip to main content

​
Tables

​
AoriSettlement_Deposit_event

Deposit events from the Aori Settlement contract recording Request-for-Quote (RFQ) order executions with cross-chain settlement details. Contains order parameters including input/output tokens and amounts, source and destination endpoint identifiers (srcEid/dstEid), offerer and recipient addresses, and time windows for order validity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_orderSTRUCT<inputAmount STRING, outputAmount STRING, inputToken STRING, outputToken STRING, startTime STRING, endTime STRING, srcEid STRING, dstEid STRING, offerer STRING, recipient STRING>Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
addressremovedin_orderlog_indexin_orderIdblock_numberblock_timestamptransaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30184”,“srcEid”:“30383”,“endTime”:“1760402214”,“offerer”:“0x01ac7e293ca033aa09338fe9da508e45085da255”,“recipient”:“0x01ac7e293ca033aa09338fe9da508e45085da255”,“startTime”:“1760402124”,“inputToken”:“0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34”,“inputAmount”:“60000000000000000000”,“outputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“outputAmount”:“59923030”}60xc0dcd3b8695bfbd8ff1412f2e5ef6b7f6102b416a66de431a7821b6981b6cfa134727352025-10-14T00:35:41.000Z0xeb0ee993fdc4a8261aef9609df078c2a003ea94960e4da4ac83668afe4095e37
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30101”,“srcEid”:“30383”,“endTime”:“1760480580”,“offerer”:“0xe9304ad2180e647fa2ec6d99095939efc280c860”,“recipient”:“0xe9304ad2180e647fa2ec6d99095939efc280c860”,“startTime”:“1760480490”,“inputToken”:“0x6100e367285b01f48d07953803a2d8dca5d19873”,“inputAmount”:“82684253766954837866”,“outputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“outputAmount”:“37823567”}150x8aa585cd189fb93059b5c7cdc56bc5ec4146724609d3e8bc9c9ab06bd44e893e35511082025-10-14T22:21:54.000Z0xb7a0c98aaaa7998aca6aee634abfa6782340af447809c089d1c1e0b88e67185f
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30110”,“srcEid”:“30383”,“endTime”:“1760406714”,“offerer”:“0x261af68f656dc79e88bd748564c74304baab714a”,“recipient”:“0x261af68f656dc79e88bd748564c74304baab714a”,“startTime”:“1760406624”,“inputToken”:“0x6100e367285b01f48d07953803a2d8dca5d19873”,“inputAmount”:“251000000000000000000”,“outputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“outputAmount”:“119879773”}60xbd998345028447dae6358c945ffe854c5b59c61f0f7be640e6d98993a6fd078434772372025-10-14T01:50:43.000Z0xf97f0f1b6740f42df4a6b06129b5312004e557a9489d8cfdd34e1d7b629a5515
Query with partition filter
SELECT *
FROM `tt-contracts.stargate_v1_plasma.AoriSettlement_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
AoriSettlement_Fill_event

Order fill events from Aori Settlement protocol recording completed Request-for-Quote (RFQ) trades with cross-chain execution details. Contains order identifiers, token pair information, amounts, source and destination chain endpoints (srcEid/dstEid), offerer and recipient addresses, and time windows for order validity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderIdSTRINGUnique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
in_orderSTRUCT<inputAmount STRING, outputAmount STRING, inputToken STRING, outputToken STRING, startTime STRING, endTime STRING, srcEid STRING, dstEid STRING, offerer STRING, recipient STRING>Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
addressremovedin_orderlog_indexin_orderIdblock_numberblock_timestamptransaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760074984”,“offerer”:“0x5b76ce885b30cb96915be533998cb1aaf7e27c6c”,“recipient”:“0x5b76ce885b30cb96915be533998cb1aaf7e27c6c”,“startTime”:“1760074894”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“13549196952914964806”}70x77f1374b3264e0d021000d025fd579851e5b4ea3286e730299c615f3cc09a1fb31455202025-10-10T05:42:06.000Z0x724287beff7276f58a25376b9d5312058f565819e80f4fc36f06744127d39de7
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760104680”,“offerer”:“0x350cfa3ed5cdd857c0b0dc26da3d431f7e387f64”,“recipient”:“0x350cfa3ed5cdd857c0b0dc26da3d431f7e387f64”,“startTime”:“1760104590”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“12039131509318059874”}350x74cfa2c789465b77ecb99ae6dbf37e7cc45cdd206d38e8437602ffcb05a8bff831752122025-10-10T13:56:58.000Z0x2c388cf277d1e36a8ec39ba516fc775801ca109b9e4c3aabf274ebb2d2581f86
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8false{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760121886”,“offerer”:“0x994e6f31a7ee579ef16f589a16b5d7f1ddcfe122”,“recipient”:“0x994e6f31a7ee579ef16f589a16b5d7f1ddcfe122”,“startTime”:“1760121796”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“12823642651590315685”}90x0671ff1cc7a027ec8a5e908f811b44a28ef3d761df7ccf0da098b1f2a11d8e8c31924122025-10-10T18:43:38.000Z0xde3be70e5b9edaff75b22b891c214d138644759848302859e4fcea8a13e0d2e8
Query with partition filter
SELECT *
FROM `tt-contracts.stargate_v1_plasma.AoriSettlement_Fill_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
AoriSettlement_SettleSent_event

Settlement notification events emitted when Aori protocol cross-chain settlement messages are sent via LayerZero. Contains source endpoint identifier, filler address, message payload, and associated fees for tracking cross-chain order settlement lifecycle.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_srcEidSTRINGLayerZero source endpoint identifier for the cross-chain message origin. String-encoded integer representing the chain ID in LayerZero’s endpoint numbering scheme.
in_fillerSTRINGAddress of the entity that fulfilled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
in_payloadSTRINGEncoded data transmitted in a cross-chain message or contract call. Hex-encoded, 0x-prefixed string containing function parameters, transaction instructions, or other application-specific information.
in_guidSTRINGGlobally unique identifier for the LayerZero cross-chain message. 66-character hex string including 0x prefix.
in_nonceSTRINGUnique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressin_guidremovedin_noncein_fillerin_srcEidlog_indexin_payloadblock_numberblock_timestamptransaction_hash
823903385810177200xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d80x829e5e56053c22b88fc73d4e7bfa659a9e58f8d962c6694a2cd5fc2b54138869false3740x95dd8db1c0c066eba8c37cd1c6b4c895500b20f23018490x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f200250341b8c891b85be2c165eba4372347db1fc6a6dda267516d97baded727524703bf406e9ea29c7da8531809e431748836b89cf919292c53beada12e9a7586406b5a8d98d84a873565d69d42068f030cad47c9233f94e509696ad2a27b7a9612e88c956b4b02f74e5423ffe415d0a5f19589f21ebf5de231a76ac6d836e07a9c06c0e6fc5dede41c8154cb3410e84062f26f47d10f597d55889a4946ffc87e69ea0d60ef8889511de76edc967eb7e5a6998e93fe3a1ac6b7369db734ea0a09be7ffdc93c2ea2dea23f8ee2ae136fdbb0588e47c992755eb77d1bae3324f7dd9303857e95355b872442f33d37f767d0fe252c2de9f941e334d4c9fd33a48e5d5ea4c1bd1e270e52526d1f4363c713a10b2ae58cdb6c61f9e110f0cbd43969de1b043114b2dbddd1e5ed578f7e9406d71caecc82cd7c2606f24c21195a5f96e8a2dd559fcc27ef9c4c4ffea89b32ba50324c85453d1838cdf8747f5fb3c2ff6aa237527395190b849ded87f393dcbbe360fc3ce1ba1d8eb50a1f67e6f8fb170c3bb43a1cb85fde4ed24a8b982df674306263d5253555b7770106d592832bc04447c2b3a65e6608aa41d2361cec377d7abc532ac347b96657882c17b433c28aa116988ba4862e96ffc53bf0a3be647a4705a147fa8e35c20b449f760598f20ff37aa467c11d1d77e9985685cab115bfc8e3002e14c9ca936c314604a39f4588f0a67c1d538f30c9a6682820face85513280ec433344bc003644ea71da50db719a712d6da825d8606b4f37410f86e6442461b6fc277216ef2399c771c08fffc54e239a8e30596ef051c124681d18cc06f2cca8b49bf40b5672a4e9418a45f49923207d846baae98fd7ffbbbd600e191f56a648e6db08265124892f24893841a08bcd8877da869ae127e7303b685ea9ddfc0c3f7fb890b9b43d816d4dbab50a70f1832e1da777bc53da4c5a89fe219e514dc9894e02e81bea0ed2665b9c65091adcd2565db4f93999dcec63fd82d7cb22c4e059894b9229c694d10d029aa65514e3a3ed0410f9b33d67219692cd08ae03d8d530e03139858c16b1a240b2171b20da5fb7c49e509c5c68704ba4ad48e9fb2126c0fcaa1e788be063ebf5b8f2c81589d562f6e1b2a80e4253e6195d0f354aaf2673f0e7f6ecbd9fbfa37dd8e00b084c332085ef2ade048bbf1d3a721072e83437e10ea4acaa236bff682ea4a7d2bb897e4a3555f4ef72ae82a42547fe825917e78c87f2a0a798fe21d672a9d6ca2e443284ff297a4dacb5e7a095dca7ef1c51cb801d85925dcbadaf7e166e4574e34c7b800bf31e452326975cce00442721c47e0879f1bc16a68faa826ea4e816b0b4a2e1093bf36792fd67ce2ce9545cf9856be38213884af0e7ac1324d64228d5b138c7794154eb4f9faa107a57ff48b6bfd16d820524f039aca4d809a5e6f4d956f7987507ecb6607ac73831fd3680d494da3541e2bfedb80e6d098c2f81bee77be66db3dca7cf4a6207d990a80d5c9efbd262d8588eae14f591b8b0da48d89fb8927d61523d9d903d50fbdad13eb68e2d5b0304cc76958a2a33e83458cb5a74b4609caf2caa9f73062ddc7df8b830a23618b79cccfe817029fd32daac78ade45508be0722e46219c6778ab464879bc6fe6eb9a6f5b027d9a86ae772a94241a5238c9c27000742025-10-05T01:54:16.000Z0xe06980f81031c9f9cc9162ea2e2d104e08e89c80eec2264dc183442a76f54412
18287767299012047610xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d80xa5614b915f86689322caf5dc7e9085d6a65b5beb5cd621b57d8a2171753c0f34false3750x95dd8db1c0c066eba8c37cd1c6b4c895500b20f230101170x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f20009464e7c5c87a2a3912d0f4acc4b4f8f66e971b2dd1d7b16f45c8ee3e05b0f0f38354a89607dd1f4b19aa42be6efe88da6ec53828cb163f7b50b271fc1bc03c4af0a0800b0c7dd057ab8fa6efadb723eba86d02e27b90eec97a292834d2749fd3bd890e11bdc3897b70573646ce625589f34f9a10601e319b275471f217d6ffde0ebf8e3be6d9427bb2d01f0ef5345c0fdf0882063e941fc00797fdeefe4961e13672f4ca3fb84ef25ffaae19a920c7332304a211f133b9f2a65df0b43f31374aa742287c1e78a1a2d552d5501c41a4a5ea0a27343636678a6df87aa0166e75b18d0f8f014152ca4495c370f3618077ddf48e9e87ef4986b5b6e1af1761ba7b92315742f4db31e5d5d2b5ca4ba4de6cc94cce3a95d3a012be274febcbc2fe231a527000742025-10-05T01:54:16.000Z0x60d494d0c78e94e205fa820a4e2ceec6fb41abe088fbf49b21d62d3e5797195d
1774532713558735630xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d80xf972db531629c2318f8ef609250d9d3ecbca35a1d616be9bac0406f95f97d6b0false2600x95dd8db1c0c066eba8c37cd1c6b4c895500b20f230110130x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2000bfb4433d00b3417553d0d3d72be783c213a0fa2bf5ba56a8f99f3b16f74488ce14db08b86923db735ef4b9d9c442823d72f3722a18261b88faff1f6884661f5a5cecd4b7216d3ec0cbf1e2c8f937f64abd87a9b51d2f3251ad62a363c3ddcc0fe1e7c934d4650a75c867ed83e653648dc1b0cbafd6884bb4a4a033ca1df181f1cc501ab5024713c149c247460a2ff55abb270244d4b3c0fa6e724902c8f289d2fec4b932c65e885c0bfffd271a17568799624394c7bc29897f17b8973ada8a0e639aee46d5eba97f9c137c0c084394f59d486d67354ef9d6df753b79f95ba1a5147d9319714b98d523334e9a1f28dbfca73d46f939e23fbe7704274ba100af9e8c957937ac969119a179fb0a2d641a5dad85fa87a50d7a244eb6ac47627660f2773867150af3eebcb092f10b9107a2ab56f2f975ca836db092690176b4012c78d4f633f8a50bc66a4b6fa199f202cac14df111621189171e622465efabe54d5bc27000742025-10-05T01:54:16.000Z0xfa8e52e28e77581149645f9c4ded2289b942b2d5ee29fd5d4a87c536b91072ac
Query with partition filter
SELECT *
FROM `tt-contracts.stargate_v1_plasma.AoriSettlement_SettleSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100