stargate_v1_plasma

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_order`	`STRUCT<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.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	block_timestamp	transaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30184”,“srcEid”:“30383”,“endTime”:“1760402214”,“offerer”:“0x01ac7e293ca033aa09338fe9da508e45085da255”,“recipient”:“0x01ac7e293ca033aa09338fe9da508e45085da255”,“startTime”:“1760402124”,“inputToken”:“0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34”,“inputAmount”:“60000000000000000000”,“outputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“outputAmount”:“59923030”}	6	0xc0dcd3b8695bfbd8ff1412f2e5ef6b7f6102b416a66de431a7821b6981b6cfa1	3472735	2025-10-14T00:35:41.000Z	0xeb0ee993fdc4a8261aef9609df078c2a003ea94960e4da4ac83668afe4095e37
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30101”,“srcEid”:“30383”,“endTime”:“1760480580”,“offerer”:“0xe9304ad2180e647fa2ec6d99095939efc280c860”,“recipient”:“0xe9304ad2180e647fa2ec6d99095939efc280c860”,“startTime”:“1760480490”,“inputToken”:“0x6100e367285b01f48d07953803a2d8dca5d19873”,“inputAmount”:“82684253766954837866”,“outputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“outputAmount”:“37823567”}	15	0x8aa585cd189fb93059b5c7cdc56bc5ec4146724609d3e8bc9c9ab06bd44e893e	3551108	2025-10-14T22:21:54.000Z	0xb7a0c98aaaa7998aca6aee634abfa6782340af447809c089d1c1e0b88e67185f
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30110”,“srcEid”:“30383”,“endTime”:“1760406714”,“offerer”:“0x261af68f656dc79e88bd748564c74304baab714a”,“recipient”:“0x261af68f656dc79e88bd748564c74304baab714a”,“startTime”:“1760406624”,“inputToken”:“0x6100e367285b01f48d07953803a2d8dca5d19873”,“inputAmount”:“251000000000000000000”,“outputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“outputAmount”:“119879773”}	6	0xbd998345028447dae6358c945ffe854c5b59c61f0f7be640e6d98993a6fd0784	3477237	2025-10-14T01:50:43.000Z	0xf97f0f1b6740f42df4a6b06129b5312004e557a9489d8cfdd34e1d7b629a5515

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_order`	`STRUCT<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.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	block_timestamp	transaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760074984”,“offerer”:“0x5b76ce885b30cb96915be533998cb1aaf7e27c6c”,“recipient”:“0x5b76ce885b30cb96915be533998cb1aaf7e27c6c”,“startTime”:“1760074894”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“13549196952914964806”}	7	0x77f1374b3264e0d021000d025fd579851e5b4ea3286e730299c615f3cc09a1fb	3145520	2025-10-10T05:42:06.000Z	0x724287beff7276f58a25376b9d5312058f565819e80f4fc36f06744127d39de7
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760104680”,“offerer”:“0x350cfa3ed5cdd857c0b0dc26da3d431f7e387f64”,“recipient”:“0x350cfa3ed5cdd857c0b0dc26da3d431f7e387f64”,“startTime”:“1760104590”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“12039131509318059874”}	35	0x74cfa2c789465b77ecb99ae6dbf37e7cc45cdd206d38e8437602ffcb05a8bff8	3175212	2025-10-10T13:56:58.000Z	0x2c388cf277d1e36a8ec39ba516fc775801ca109b9e4c3aabf274ebb2d2581f86
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30383”,“srcEid”:“30101”,“endTime”:“1760121886”,“offerer”:“0x994e6f31a7ee579ef16f589a16b5d7f1ddcfe122”,“recipient”:“0x994e6f31a7ee579ef16f589a16b5d7f1ddcfe122”,“startTime”:“1760121796”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“10000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“12823642651590315685”}	9	0x0671ff1cc7a027ec8a5e908f811b44a28ef3d761df7ccf0da098b1f2a11d8e8c	3192412	2025-10-10T18:43:38.000Z	0xde3be70e5b9edaff75b22b891c214d138644759848302859e4fcea8a13e0d2e8

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_srcEid`	`STRING`	LayerZero source endpoint identifier for the cross-chain message origin. String-encoded integer representing the chain ID in LayerZero’s endpoint numbering scheme.
`in_filler`	`STRING`	Address of the entity that fulfilled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_payload`	`STRING`	Encoded 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_guid`	`STRING`	Globally unique identifier for the LayerZero cross-chain message. 66-character hex string including 0x prefix.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	in_guid	removed	in_nonce	in_filler	in_srcEid	log_index	in_payload	block_number	block_timestamp	transaction_hash
82390338581017720	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0x829e5e56053c22b88fc73d4e7bfa659a9e58f8d962c6694a2cd5fc2b54138869	false	374	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30184	9	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f200250341b8c891b85be2c165eba4372347db1fc6a6dda267516d97baded727524703bf406e9ea29c7da8531809e431748836b89cf919292c53beada12e9a7586406b5a8d98d84a873565d69d42068f030cad47c9233f94e509696ad2a27b7a9612e88c956b4b02f74e5423ffe415d0a5f19589f21ebf5de231a76ac6d836e07a9c06c0e6fc5dede41c8154cb3410e84062f26f47d10f597d55889a4946ffc87e69ea0d60ef8889511de76edc967eb7e5a6998e93fe3a1ac6b7369db734ea0a09be7ffdc93c2ea2dea23f8ee2ae136fdbb0588e47c992755eb77d1bae3324f7dd9303857e95355b872442f33d37f767d0fe252c2de9f941e334d4c9fd33a48e5d5ea4c1bd1e270e52526d1f4363c713a10b2ae58cdb6c61f9e110f0cbd43969de1b043114b2dbddd1e5ed578f7e9406d71caecc82cd7c2606f24c21195a5f96e8a2dd559fcc27ef9c4c4ffea89b32ba50324c85453d1838cdf8747f5fb3c2ff6aa237527395190b849ded87f393dcbbe360fc3ce1ba1d8eb50a1f67e6f8fb170c3bb43a1cb85fde4ed24a8b982df674306263d5253555b7770106d592832bc04447c2b3a65e6608aa41d2361cec377d7abc532ac347b96657882c17b433c28aa116988ba4862e96ffc53bf0a3be647a4705a147fa8e35c20b449f760598f20ff37aa467c11d1d77e9985685cab115bfc8e3002e14c9ca936c314604a39f4588f0a67c1d538f30c9a6682820face85513280ec433344bc003644ea71da50db719a712d6da825d8606b4f37410f86e6442461b6fc277216ef2399c771c08fffc54e239a8e30596ef051c124681d18cc06f2cca8b49bf40b5672a4e9418a45f49923207d846baae98fd7ffbbbd600e191f56a648e6db08265124892f24893841a08bcd8877da869ae127e7303b685ea9ddfc0c3f7fb890b9b43d816d4dbab50a70f1832e1da777bc53da4c5a89fe219e514dc9894e02e81bea0ed2665b9c65091adcd2565db4f93999dcec63fd82d7cb22c4e059894b9229c694d10d029aa65514e3a3ed0410f9b33d67219692cd08ae03d8d530e03139858c16b1a240b2171b20da5fb7c49e509c5c68704ba4ad48e9fb2126c0fcaa1e788be063ebf5b8f2c81589d562f6e1b2a80e4253e6195d0f354aaf2673f0e7f6ecbd9fbfa37dd8e00b084c332085ef2ade048bbf1d3a721072e83437e10ea4acaa236bff682ea4a7d2bb897e4a3555f4ef72ae82a42547fe825917e78c87f2a0a798fe21d672a9d6ca2e443284ff297a4dacb5e7a095dca7ef1c51cb801d85925dcbadaf7e166e4574e34c7b800bf31e452326975cce00442721c47e0879f1bc16a68faa826ea4e816b0b4a2e1093bf36792fd67ce2ce9545cf9856be38213884af0e7ac1324d64228d5b138c7794154eb4f9faa107a57ff48b6bfd16d820524f039aca4d809a5e6f4d956f7987507ecb6607ac73831fd3680d494da3541e2bfedb80e6d098c2f81bee77be66db3dca7cf4a6207d990a80d5c9efbd262d8588eae14f591b8b0da48d89fb8927d61523d9d903d50fbdad13eb68e2d5b0304cc76958a2a33e83458cb5a74b4609caf2caa9f73062ddc7df8b830a23618b79cccfe817029fd32daac78ade45508be0722e46219c6778ab464879bc6fe6eb9a6f5b027d9a86ae772a94241a5238c9c	2700074	2025-10-05T01:54:16.000Z	0xe06980f81031c9f9cc9162ea2e2d104e08e89c80eec2264dc183442a76f54412
1828776729901204761	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0xa5614b915f86689322caf5dc7e9085d6a65b5beb5cd621b57d8a2171753c0f34	false	375	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	17	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f20009464e7c5c87a2a3912d0f4acc4b4f8f66e971b2dd1d7b16f45c8ee3e05b0f0f38354a89607dd1f4b19aa42be6efe88da6ec53828cb163f7b50b271fc1bc03c4af0a0800b0c7dd057ab8fa6efadb723eba86d02e27b90eec97a292834d2749fd3bd890e11bdc3897b70573646ce625589f34f9a10601e319b275471f217d6ffde0ebf8e3be6d9427bb2d01f0ef5345c0fdf0882063e941fc00797fdeefe4961e13672f4ca3fb84ef25ffaae19a920c7332304a211f133b9f2a65df0b43f31374aa742287c1e78a1a2d552d5501c41a4a5ea0a27343636678a6df87aa0166e75b18d0f8f014152ca4495c370f3618077ddf48e9e87ef4986b5b6e1af1761ba7b92315742f4db31e5d5d2b5ca4ba4de6cc94cce3a95d3a012be274febcbc2fe231a5	2700074	2025-10-05T01:54:16.000Z	0x60d494d0c78e94e205fa820a4e2ceec6fb41abe088fbf49b21d62d3e5797195d
177453271355873563	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0xf972db531629c2318f8ef609250d9d3ecbca35a1d616be9bac0406f95f97d6b0	false	260	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30110	13	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2000bfb4433d00b3417553d0d3d72be783c213a0fa2bf5ba56a8f99f3b16f74488ce14db08b86923db735ef4b9d9c442823d72f3722a18261b88faff1f6884661f5a5cecd4b7216d3ec0cbf1e2c8f937f64abd87a9b51d2f3251ad62a363c3ddcc0fe1e7c934d4650a75c867ed83e653648dc1b0cbafd6884bb4a4a033ca1df181f1cc501ab5024713c149c247460a2ff55abb270244d4b3c0fa6e724902c8f289d2fec4b932c65e885c0bfffd271a17568799624394c7bc29897f17b8973ada8a0e639aee46d5eba97f9c137c0c084394f59d486d67354ef9d6df753b79f95ba1a5147d9319714b98d523334e9a1f28dbfca73d46f939e23fbe7704274ba100af9e8c957937ac969119a179fb0a2d641a5dad85fa87a50d7a244eb6ac47627660f2773867150af3eebcb092f10b9107a2ab56f2f975ca836db092690176b4012c78d4f633f8a50bc66a4b6fa199f202cac14df111621189171e622465efabe54d5bc	2700074	2025-10-05T01:54:16.000Z	0xfa8e52e28e77581149645f9c4ded2289b942b2d5ee29fd5d4a87c536b91072ac

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AoriSettlement_Deposit_event

AoriSettlement_Fill_event

AoriSettlement_SettleSent_event

​Tables

​AoriSettlement_Deposit_event

​AoriSettlement_Fill_event

​AoriSettlement_SettleSent_event

Tables

AoriSettlement_Deposit_event

AoriSettlement_Fill_event

AoriSettlement_SettleSent_event