stargate_v1_ethereum

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
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30111”,“srcEid”:“30101”,“endTime”:“1757890047”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1757889957”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“19664893”}	205	0x5ffc509a453875809266263e4e28fe901a0e517891573e406111e5f686c83b4e	23364393	2025-09-14T22:45:59.000Z	0x58bf030c339f2dd6c28d614ab10516efcef49fd1d9e33e2206e738a213199ea6
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30111”,“srcEid”:“30101”,“endTime”:“1757857647”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1757857557”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“19397285”}	170	0x9017849f6534b2e2649c4d81d308469370c2a2d5de05c0146581ddc1004b0ee6	23361706	2025-09-14T13:45:59.000Z	0xc52d77aaefce43a6ac99cc6233c98e3318c8dc54288613b1a8ad4c3fe45ec7c7
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30111”,“srcEid”:“30101”,“endTime”:“1757872047”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1757871957”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“19640609”}	243	0x684b12874d291488c9721c7086dcf2fcfb51f752e7dece35a043a7f9f8e1ffce	23362901	2025-09-14T17:45:59.000Z	0x5e8420a4c2b33116654d7940afc4493ba66f6488e6dbcc1873eb5a9bcb9f89cc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.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
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30101”,“srcEid”:“30110”,“endTime”:“1754697106”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754697016”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“20000000”,“outputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“outputAmount”:“19722671”}	50	0x5d515f51a04e42172d857640088d82eaab99e25be2876e66a7f7e225dc07af16	23099729	2025-08-08T23:50:23.000Z	0xd6f6a39cc7b94408fe7dc9df59e9f7dfe16d8daecec086feddccf7afe88ce6b9
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30101”,“srcEid”:“30110”,“endTime”:“1754688102”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754688012”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“20000000”,“outputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“outputAmount”:“19483338”}	279	0x616cc7cd76d5cb8cc84b8ef76ecf96e1725b113b58f9037cf58ec979b623f99e	23098982	2025-08-08T21:20:23.000Z	0xf4ed266d3578f47ffdba53d9686c3383c12a89da40542bff3e0595737498fd2a
0x0736bdc975af0675b9a045384efed91360d25479	false	{“dstEid”:“30101”,“srcEid”:“30110”,“endTime”:“1754685880”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754685790”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“20000000”,“outputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“outputAmount”:“19512999”}	526	0xa21e0bed3a7ac25aff9f06164c19fa2f5655ad5dcbfd6ba7b557de5773330727	23098798	2025-08-08T20:43:23.000Z	0x5724f238ff7ef0f0fca255babd99e880b2ef81fc1c451df0bb0a858a50cc637f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.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
35558308108740	0x0736bdc975af0675b9a045384efed91360d25479	0x88bb4d699d64d415e0eb923a5f816e10065db3ff0d990168967e9ca81979b509	false	774	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30110	28	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f20019d81fc80e33b1ef009c26c7405aed3ffeb6b296e50040ba3ea9de251eba5ef2ec0d924aaf1b1df4d2d779a965e4562949bded87549793d00acb99536d73f633adee62db480c4945b39bc73a195710568c4e14d88999a3bc993c05431567a9360b78f3bd93a7282b380edf98c4e94f1cee078700caae2ddc8dadd07cfff8228ad9be0b6f4ac42a96a5dd3657b7d46055fe6ef031e087d2fa46c95342adfbd20ad6b78b03bc46b107fa5f78347d17dade8f4ac69cefeda058dd2a32725a215a19582d895c8366bca768daa84937458eec5dd7fcf32d22c73fd3f1dc68a921f0f3ab86882dff16d0a163a9cf92b2799a216c2623a19d0435260593d89f2a4566c48d005da090a93121eeab1b156c017ff37ad9b441f88bf2ea697afc1e8ad5701bd2f11b7f7ff5bb1d4de14b208013c0069134bd8cb9053470b967412eede410bcf1d66cb10b67b7dfe57a304d8835ba4784bbaf8b4632ec387986aa045b33b63de8f9483131a799fad67ff9ad041ee6530f162ce8d311e15797fd3370dfd4a150ecdadbcf789603a84085075553a9b2aecdcbea2231f715cc421da3c9491f278e6d07f07ffe49d37a99fa24da8f52828e51b5acd0781ca0fcae978dd8963168229d1d333b8b08675b770542f1eff385f1f956d23796b413761895fba1c38786d6a54c3282628f88386c1cb94a8c3fd6ba8f24bfc7a5119f41ed90f706ee211d019ae2d43660fa656a5987ba652edf4a4770a39e49b9338c53db29e339a75ba06c7d17347a37a392dcd1cb8f0cba96363ee5a84c2ff10bb1bd528495a7a30a7e834474be48794027f26ce1b87d7e855004f8f836c971ef6ec02c4a4517d06f8db427ffa15c44ff826fe2cc7ce2aa77a63d9b3dd3cb6ba293ad14ee8171a809deecbb016df4df9af3dc0cf0fec9bdf4dbd31efb9da1ae46df8c7c173ca7a38ab6c40ef6bd81388788fd140712edb7a5de910e50a52a625211c66118c9de4e02830d5d795b89827f195c17ef9eaf7f231336f9dd88aee5249082172116aa9ff064712b9dc9abf655ff7c3c7b8b5417ee9f5a0480de2f0e37d1d52174cd75ed8d4c40dd0417303ebe4c9004fd17c032fea32d39c5bf511245a6be003c44b51ef4acfb2d	23386740	2025-09-18T01:40:35.000Z	0xf1b1815a7d72ba7c412e2a06db974806a96acdd41bcca1e9af8ccfd6aa8b749b
50369925028740	0x0736bdc975af0675b9a045384efed91360d25479	0x2e21369614a1e104da2ab1d2806f3e794cd0526e8dba44d652d4cf9d41d9915f	false	781	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30110	70	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2003351f6824f49265c326e49aa7bf482a5da64e125686501b57ab44a2ba049b08e9bd9517ead32322c63b6e363e4adb9609f8563a9f5ce476f05b1e0def8bcfa5b8e61112b5afff4fe7599a7593649dfe0764a6b38d09d5c230ac0833b10264c8a4566d58fccdbb6bbfa12a7c73cea4d20719bc62f42884836420d565903761f99c8bbaa8ceb255e4770626a9d2f24ffbc55dd7377beb85a0e3fbca89ff265c33c4a28354003a04d4ea54e9553fc59a18347f0ac23d5551689009ff70f32fb2588a27bde1f688076270cead1a233565236a76298847bcdec6fe00cdfff8bb3cc845088b70f63b1a979004e6a52edc1ca33ba22bed51f4b60893d4596a5dfb9223c398088da035296cd7eb70ab7549ad088cb395c2e7b2b809a9f84d16f9e18246009e5ca12f6746a5f024442d3c829039f909ecd927551c2d519d634844fc6017d8e16b8709dc725a60f876053c7dc2980e9282bdd55b0212fbed0b5d7781bf21dd250091f1ba15a1234ec3e52559b686d40fc3f4979fdf86a477d4818a084b1f96e65f36b63b51b878fd2e399ad3743cb0a97c7ea42ccaf98ef09d14b70286cb6c052baa2d168a8f04eb2c41fd872c67e71fbe8a71ea69434bf4defa4e470f54155dec8c7d7cbf86ae5f3f476cca468f23e704880384fb907f76a19889a0fc2689b793bcc7cfe7c7570e56686c0a0bdd092f512fa8320c5bf3536fd9f8df6b07fbbc0b03557dfc112c0200e3a474e0e2dabc6fef2d2881a35df07df0056bf23de0ea3bbc54b35f9e25a5a7cc3dffdccbbe874606c20b0fc1ef60c60022d18e0a336aec49aa841f6213b0d20244cd1621388b18b9a455a2d9e16b29136aa104d0878278b9e1bd2ecb98c8950481da78b036aa7aec7a1e55d109a9711c315b0d294b4d2d4721621d0c3f88ce319a4d83958e29e8d6c08f5bf2095235bbcb38e542dfb714f3058ce07143805e2cf346039e5f295a9a91a10c67beba39f79885745e5375212124e8fa3c47bfb06bfc95e1bd7fb17bc007cd0bc2da97b6c5873682fff4c04091b5c3c64bd8bfa1083bdf7c468eb414a1bc97a95cedec1331c251939886e25cc302cbda96002e805cb6dcb029a144ce840b397f708040a0f37323e1d83484a75197b6c13d1f728b40ecc8d114c2fe79ce68b0eea3067f54f24e391e6d8d89f70b7c76512a987c1a4c82a27b47ddcd2bb55124d3114eb729ce62136b5509c3ed284ec3434e47ff5ad28b69722520b5a0512f57a521b43d591ab8d08cb97f743e833db19e264b60b32b2154f2c0780719d7ab37f037cdc26629696bb4a528dd20e5c2bed48585b13036bf0b87bafc082f3dd88ac496a59a68b83fcbea7611d89a338cb79c3a1d4c75028144ff867d613f48b32d1b152a7eccde91f9847b2777a7221d8b86900f75e5a10288b4b87679933efcce4af9b947189b45404cfa46c4d660457352985f268eb89b04adaa7f305d51bdae181028c797beb8d80fb42344630389d3cceecf012e3389d5568c3e2c700d3f695d831fedf2e2e9484aa7b31c5f7e54aa5c25d79a8a3511a214675240d980f84af1c291b983a364162e82da92f3eaed1d534871cb2bbc3c6274446940b2907f822b0c248c7bab7f9181b830513a0500490048b3a6dd19b2e569eae2ec907bbcafb0ac019bf06a7a6e1ff41854b31deb284db580c4c080659a0309fd7fef2ee3b7393578e1be26dc698dbe85ce3b112d4a7cb4c995c3422633bcaf7b11895a6d99bfccdb39e1776a48cbb0fd058af6829801856ddbf4ca3a4d81d5627c0325869e2b82a6be1f11b1415237addb12ba7381c27411ab787edca17d00060c40c83125259fb2675f93b0d62a8c13b7fcc0e21e0058d87ba1abdc0e14d2f3a4c13d04d592ff8cda9376f17983324dee8f843fcad293911575420a6b2c1e6cd93481c479df9c79f33fe67d1b70f13e5674aa8893a89462f27dac02171afcf5807171ffa041377ec6c2227241655118ebb1a60825f2f0676d756107a4a503c93581f40350fc411477e15e64b159870b0cd460908cc520f8b12ee1587090483be68a60beba6399d1504fb75f3af4c1190fe3b08411dc9427b40e7fe81fe34c47d35870400357854f84066fef794fbe728df57f87a7a698b11d02a29755b03396089f2b97aa3542ec1c690c15dbc49df7e9bdf535e52e1b1ca621b84bbd35f6cb56b2d1ea513c7089c928df1be08d358faae46513d01314eb6002c375e67a61cad647dad1d030ae1a87296ba1a55936c1a4cbe0df265f64ebc3df4991b6baf187bf7ca21e4f8945e059c9eae4e4e608f82	23393350	2025-09-18T23:50:11.000Z	0xa6b5cc20c255ef6adcc7c079ee51c28f7f866f493577a282adc4074f02fce6e2
76304546347540	0x0736bdc975af0675b9a045384efed91360d25479	0x7e3e67f4d985772389fd71f53d0c4804ae761b0134087682d04a010576f611cc	false	778	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30110	165	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2001f9af680d84043387c321c7371594e62329f2b534002695cffe1ba78f01796287530d178a7144cf79ccd4861183bd5d90eb863f06fe4c2892a3d3ac00d6c8e00f691bf1f06641612a03488726ef3b2f8fd7355c896cbbbffc9c73911960f91c6a7c5a961753a1510790011f2354f8a7968d1c715596919e37b91e95111f02551ecb59865c675611a5f537eb2f5532fe76cb04481ab647078f0963f320da9cab1aa4855058ef5a439235eadfa3e1567d564cfd94fb487d2fdcab8a0bb63e67e09897134723f39e50547cce4e06b818ab73b202f67ef913beca1125a4a4d4ad377fd052a498019e4a9534c63338ba9f53eb7a8f85e7463960e5bdd5d73ef142405d5f723dff61477b14e68bff3be6b7a99c268dd4b9cd3fe45753d741b6b929087a00f4bca8d534a408f748e10116cd9d535ed4b28994136f83d627e89fdc8682e1796f57eab294fdfc3692467fe0d5e697c85a671deeba9fe0aaad7afa4df95bd844c094a693c0e434cf03533b35727b460bd9bf5ba98fd2548cc4c24a9cb3f9e1771e650d97bd5f1683efc7b496e4a4ccea5941f1aac207bb3a50a59408184a1e0983e2f8d63c5f7365dcd374cee393e4050251433f39c2f38129df7983b16fed433637b370b3cc18a2cc31f46ffbc285c0de8a1cf08dc43b9bc2482c683ebf7b2e3d839ef2621b4a33c1624a20f220e6c9beab333d17773053d766c27e30ce11ed6974059d73a7bbd4c6786b63142efd02f7aa5bfce6392fcad41adda3600c2912348978f92e3872bb0d1e8feaadd7fba6fccade22df0e028ab86b155a9a0731f563b282c3ced642a48fe007de585a651804d968b1c93c97913c58b62ba518e49417265c28ab5dd70fb801a86de47105bb723be2e45e503a4ede646d15963fab56eb7c8fa55d09440066642514ffd3b0b0dfd48507818120100a3fd3a7d92225eedf88b5b01360bd235562035d26a00c8ddbab094d9b69364064233d37530a31b577c3744546ac5fbbf44d138e365d8f9e088fc9dc48fff69a0a07c401355c4dca76a10d7223e7b7af77f42c22f45a7a18f8111938d6a67d4f43a3dceaa3e18f4c61bbe056c0f9d6c3713c1fcbf1885dd78ee020647a5042d894a27b63de8272f756b68d44513682588056e1f4af9cc0dc945ef7d78d5fc3c9bf10951d6245dfcc7d67311e39a60a6d2eddecc9dc5dc40da71c228bf70e37b03b3c6055e23b739ca6c37c6c263d7f176e2e5c530a5a2ab6720f925e4b78093a2b7eebe017226f37a5f82cb4133982b02eff02e207c44c3b2ccb2097d33ae0176a1a695be5423f895c0926c58b39c2eee45a5b3c6d4c40cdb4be2cfbbe800671214d3606847319d9baa9f49380c600e6798ead7cc60fdbb367ce68f236dcd96a286f4e59d6a5252	23390398	2025-09-18T13:55:47.000Z	0x1e2465562ab33feb001d46b02956ee76defe424a984db8d5ea4784a5cb01c8ad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.AoriSettlement_SettleSent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_createPool_function

Function call data for liquidity pool creation through factory contracts, including token pair addresses, fee tiers, and the resulting pool address. Used for tracking DEX (Decentralized Exchange) pool deployments and factory contract interactions.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__poolId`	`STRING`	Unique identifier for the Stargate liquidity pool being created. Numeric string assigned to distinguish pools across chains.
`in__token`	`STRING`	Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string.
`in__sharedDecimals`	`INT64`	Number of decimal places used for the token’s shared representation across chains in Stargate protocol. Integer value standardizing precision for cross-chain transfers.
`in__localDecimals`	`INT64`	Number of decimal places for the token on the local chain. Integer value indicating precision for amount conversions.
`in__name`	`STRING`	Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes.
`in__symbol`	`STRING`	Ticker symbol for the liquidity pool token being created. Short string identifier combining token symbols.
`out_poolAddress`	`STRING`	Contract address of the newly created Stargate liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	in__name	in__token	signature	in__poolId	in__symbol	to_address	block_number	from_address	trace_address	block_timestamp	out_poolAddress	transaction_hash	in__localDecimals	in__sharedDecimals
4265343	true	3824450	Mai Stablecoin-LP	0x8d6cebd76f18e1558d4db88138e2defb3909fad6	0x7af935a1	16	S*MAI	0x06d538690af257da524f25d0cd52fd85b1c2173e	15979653	0x8731d54e9d02c286767d56ac03e8037c07e01e98	0,1,0,0	2022-11-16T02:37:23.000Z	0x9cef9a0b1be0d289ac9f4a98ff317c33eaa84eb8	0x515069bc71fd74c6afaa26bd0ca6dc6bdc55e7eaed0f4710e51f58be2d4d4b19	18	6
3836114	true	3824400	Tether USD-LP	0xdac17f958d2ee523a2206206994597c13d831ec7	0x7af935a1	2	S*USDT	0x06d538690af257da524f25d0cd52fd85b1c2173e	14403402	0x8731d54e9d02c286767d56ac03e8037c07e01e98	0	2022-03-17T10:11:00.000Z	0x38ea452219524bb87e18de1c24d3bb59510bd783	0x6f7809e3c4e499028a5e42dec447d75de1e5f1034c2343c31783f09cb4ee0dfe	6	6
3841500	true	3841500	USD Coin-LP	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x7af935a1	1	S*USDC	0x06d538690af257da524f25d0cd52fd85b1c2173e	14403393	0x8731d54e9d02c286767d56ac03e8037c07e01e98	0	2022-03-17T10:08:52.000Z	0xdf0770df86a8034b3efef0a1bb3c889b8332ff56	0x4efe677c25cf886b27c38f2caf898b753594d7af4eec7f7ab255bfa94fbd934d	6	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.Factory_createPool_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountLP`	`STRING`	Amount of liquidity provider (LP) tokens involved in the mint or burn operation. Numeric string representing the quantity of pool-specific LP tokens.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.

Sample Data

address	in_from	removed	log_index	in_amountLP	in_amountSD	block_number	block_timestamp	transaction_hash
0x0faf1d2d3ced330824de3b8200fc8dc6e397850d	0x63435ad7678ef11eb1c9f8d92aeee96c2294817a	false	441	19999576	19999999	20165910	2024-06-25T03:07:35.000Z	0x40422b9292f2310486b3dcf3d9d5f746b7d9abf1c1b810bd9002c291269a54ac
0x101816545f6bd2b1076434b54383a1e633390a2e	0x9168113a55d79293670fe07a09919299b4c370b2	false	84	99991838483004749	100018762005943425	20168896	2024-06-25T13:08:47.000Z	0x9dbc4f0ad11d5d92c887b95b3ee3069818ef470cf53199589060bf1944459b4f
0x101816545f6bd2b1076434b54383a1e633390a2e	0x3bfb060d6ec8cfb48f4808235d19bb53ee29d3e1	false	343	869038017170753973	869271999999999999	20167469	2024-06-25T08:21:47.000Z	0xe9ea879811666c038fcbc984efadfadbd8c13edb8a3cbed661ec5e58cc761e6c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountLP`	`STRING`	Amount of liquidity provider (LP) tokens involved in the mint or burn operation. Numeric string representing the quantity of pool-specific LP tokens.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_mintFeeAmountSD`	`STRING`	Fee amount charged for minting liquidity provider tokens, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.

Sample Data

in_to	address	removed	log_index	in_amountLP	in_amountSD	block_number	block_timestamp	transaction_hash
0x0e5c3e34d75c44eb2ef7a4f5a66c5bc6cf779098	0x0faf1d2d3ced330824de3b8200fc8dc6e397850d	false	377	18179568	18179953	17915956	2023-08-14T22:05:35.000Z	0x63eaab9bb9a5d0d2536eaa4d7d2cfb8a78bb047b780172ccf33079afb1b19775
0xa7592a9f43448c8bb4ad83be0054d132257bdf91	0x101816545f6bd2b1076434b54383a1e633390a2e	false	9	5449700344672354194	5450145159195787768	17915390	2023-08-14T20:11:35.000Z	0x229541161393f0e35d4d910270a64750d606320282bd79fd108fbf726883b073
0x56a132fb615b2f5235905f4fa20ee01c10bf86f0	0x101816545f6bd2b1076434b54383a1e633390a2e	false	463	5999510308980284	6000000000000000	17915593	2023-08-14T20:52:35.000Z	0x5daabf68e9081f84465837446a11249594df5648b713e794bb5fc33bf39aae4c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_dstPoolId`	`STRING`	Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_eqReward`	`STRING`	Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_eqFee`	`STRING`	Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

address	in_from	removed	in_eqFee	in_lpFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x101816545f6bd2b1076434b54383a1e633390a2e	0x150f94b44927f078737562f0fcf3c95c01cc2376	false	3235711471	10785704903	267	184	107792334806481	22172142	13	50692813046	2025-04-01T06:03:35.000Z	0x5a51a733ee5b4f6264d513ed594843165e4803ef7fc498de1ebd9ffa388a8ca9
0x101816545f6bd2b1076434b54383a1e633390a2e	0x150f94b44927f078737562f0fcf3c95c01cc2376	false	59994000000	199980000000	29	184	1998600120000000	22174689	13	939906000000	2025-04-01T14:35:23.000Z	0xd08b9c551531ab50c68da6a7593bcdf36fa07671248b47acbdda080423685294
0x101816545f6bd2b1076434b54383a1e633390a2e	0x150f94b44927f078737562f0fcf3c95c01cc2376	false	8910000000	29700000000	1131	110	296821800000000	22176814	13	139590000000	2025-04-01T21:42:23.000Z	0x1e041859fcd25fff6596fbe65edcc23d6b43e228e6253ffc236a8fedbcaf5d0d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StargateToken_SendToChain_event

Cross-chain token transfer events from Stargate protocol capturing outbound transactions to destination blockchains via LayerZero. Records sender address, recipient address, token quantity, and destination chain identifier for tracking omnichain liquidity movements.

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_dstChainId`	`STRING`	Destination chain identifier for cross-chain operations. String-encoded integer representing the target blockchain in LayerZero’s chain ID system.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_qty`	`STRING`	Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.

Sample Data

in_to	in_qty	address	removed	log_index	block_number	in_dstChainId	block_timestamp	transaction_hash
0xc7ffa5070a1cdb10dfcc6cc20a59d24c3fb54e05	320588888969359089858	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	353	15354585	11	2022-08-16T20:54:46.000Z	0x6a6142fe05c6fc939bf55ebae30dfce46109e4ea4eb900478d1ff6aa04dc9276
0x71389a674e2f97131fa8b4608bdbeadf1d97e89a	1500000000000000000000	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	242	15354863	10	2022-08-16T21:53:11.000Z	0xd6915306f2894a60e7dabb7fafaba3dabfbe688c1a870abe1a2f63842a62cad8
0xd275e5cb559d6dc236a5f8002a5f0b4c8e610701	4354284261458852435661	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	false	105	15353221	6	2022-08-16T15:40:55.000Z	0xad1568ebef18f0ca517f55027059da72defdc59913b083cc36dd3bada9c0b8fd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.StargateToken_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StargateToken_Transfer_event

ERC-20 Transfer events emitted by Stargate token contracts. Records token movements between addresses including mints (from zero address) and burns (to zero address) for cross-chain liquidity management and staking operations.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x28c6c06298d514db089934071355e5743bf21d60	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	0xb9de6951a93e1d6236ad4e6a3561ac8421823087	false	109477183030747002798127	322	15771269	2022-10-18T00:00:23.000Z	0x71495549221061d2e8891e237fe4311e46aa32e18d0466a0a1379c3541ece23d
0x28c6c06298d514db089934071355e5743bf21d60	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	0x54b35bb1b2adfa27a32ca6896841cd3a90227d06	false	42851000000000000000000	320	15771269	2022-10-18T00:00:23.000Z	0x123e6a1af6f0875fe18ee954bf0f60a39f3071b69eceb6571666c3ed0c860f28
0xb9de6951a93e1d6236ad4e6a3561ac8421823087	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	0x58cced60ccd63149a0e8deaf272d2a071fecf3ee	false	54693000000000000000000	253	15771280	2022-10-18T00:02:35.000Z	0xe7ceae054f6cf784d723aa21fc78858ca1326dbc11fbdb44058df94085d38f26

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_ethereum.StargateToken_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

AoriSettlement_Deposit_event

AoriSettlement_Fill_event

AoriSettlement_SettleSent_event

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AoriSettlement_Deposit_event

​AoriSettlement_Fill_event

​AoriSettlement_SettleSent_event

​Factory_createPool_function

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

​StargateToken_SendToChain_event

​StargateToken_Transfer_event

Tables

AoriSettlement_Deposit_event

AoriSettlement_Fill_event

AoriSettlement_SettleSent_event

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event