stargate_v1_base

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
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30184”,“endTime”:“1754790735”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754790645”,“inputToken”:“0x4200000000000000000000000000000000000006”,“inputAmount”:“5000000000000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“4979256319129365”}	190	0xb52fab0cb6bee0094653f9fd57c5a12c625f69311898cc549e0d22636df0d6bf	34000650	2025-08-10T01:50:47.000Z	0x10837531a3e861a3f8ab7480674dff93a33956c062feadb0ab199eaebed32f1b
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30184”,“endTime”:“1754788946”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754788856”,“inputToken”:“0x4200000000000000000000000000000000000006”,“inputAmount”:“5000000000000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“4981135239081920”}	347	0xb240e5e7e2ca37bd12d40621f247d713b8f9eb24802f788d857d9ca3c91b7288	33999755	2025-08-10T01:20:57.000Z	0xa10f754841a80de59f657a5f3982bb2aaf8f9d33a8db45b77059bfaa1afcf4f8
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30184”,“endTime”:“1754801534”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1754801444”,“inputToken”:“0x4200000000000000000000000000000000000006”,“inputAmount”:“5000000000000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“4939461151712712”}	121	0xc1c6782022d61afb67ef16d4dd4f597aad14d77bdaee808d16ca68e17e935e57	34006050	2025-08-10T04:50:47.000Z	0x2cd588a9327d9c7d4a49b2ea240806bf248099fbaf91ceed9adef4b983ecbd98

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30184”,“srcEid”:“30111”,“endTime”:“1755565449”,“offerer”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“recipient”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“startTime”:“1755565359”,“inputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“inputAmount”:“20000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“4566745079047601”}	502	0x45b72eb98457cdb36ad54c6a9367b354b80e0f480a5cbdf160659d905865813d	34388012	2025-08-19T01:02:51.000Z	0x837f551c418153e12e6aed6b3e78236e9571e5957e3911398e7085bb177f7120
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30184”,“srcEid”:“30111”,“endTime”:“1755565468”,“offerer”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“recipient”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“startTime”:“1755565378”,“inputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“inputAmount”:“20000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“4566629454690547”}	1198	0x4599e56d9eab1032575b7b05ec70fa035c4ac458760a5f91b7789b4168b54aba	34388023	2025-08-19T01:03:13.000Z	0x7a5d8424349973541e7df82f40da8e23a946f569f8f36d71e7fffa6474c17e6a
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30184”,“srcEid”:“30111”,“endTime”:“1755603695”,“offerer”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“recipient”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“startTime”:“1755603605”,“inputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“inputAmount”:“100000000000000”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“98459463147231”}	685	0x48aaaf56787a45838700465cd5121b602dffe6344f35b2c0e17c422cbf9e088c	34407134	2025-08-19T11:40:15.000Z	0xed82a9f0f41324f2caf752c2d405ff6837a69030a598d4953fa30817a2912bcf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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
2198866407904491	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0xf71158ed357b498c396d15c46b8599d4f4039bde36207c031b6496f2d6708f2f	false	1055	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	547	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2001212d9020c00e97b20a95a06ff4c16a028341c5840858ff970baff22295759766b02855b15f629ed14167d979aefe8ee284a6037a72b33f80a49b7fbb8580e1c83a966c0255afd2ef28bb34121a9972c38b0c1537de6b325f0c10fdd54490c9f25231e395dba07f871b9345277af2452016c65419da6cce5957d6731d11d9f6a181f35bbf472e0d67156e154bd92f8cae8f2dbe85a3b4870cf3e6b20047d62511b6380d6f435fd402012c5c360e642483f6788ab93816998981dbb055698d29f28ea40d085dcee4ececa0a5fe541b1dfdeca6157b25de41a006d7f629ff3f49d8862a6cd6d429e7aaf610d46842f509520ff9116eb1a5693affbbb7d695bf32dcef0966ef796671c45c6887a3d6ddb7441bd4231901e03c5996cf37b075b370625a9f5a425c97f8557a6adfdc5180ce85de3b85ce432a11af59a141ec8948a01ddc433f484a1c46eb6c79e804cfbf1a781b62cb59fdae61c545de1794675c5539e0ad3d25f644b79cc0eea4e5b2215a4699d3924637ec470663ed02409ec7fd5e8b291d27171e78b7d2d2cf0e65fd4e094c9b9659e943b38c1ea668641d5571284f7ae92b627ca72eb3fb02ffaba6487726682969dcb07fccc9f988afb03c468242d5f606e45670a682cc109beee6c73ed0eeded90d5b86e03559fe2165f78a10e1dc687737121c3e2eb2d35b4aa50bbaa8311b50395348eb15e29c96c4a6860d564d07c418b4bcc8302570575cd8899a8e877a7e3407c811a1c34486f920ac2e0f8038c6e8ae1feaf03d309fb4a6d782a64684db09cb14edfe9f36e093c840a23	36057158	2025-09-26T16:21:03.000Z	0x07034ca81cd7e4b6fd360ab2beac51a1e86533a668e2868015af19fba1658c9a
287981907199388	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0xcfb92623b9646f25a898547540096f3ed4096227baff9e7d7754d638d969d614	false	1052	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	110	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2001838b314333571d8f635a4592f38a2e26e23b9149143f9ab4533ba6469ed8ecfef50c1b5de2582f3eafd39bfcce6e54bb1c420c5628f53258deb127d70302afeca832b5b37bfaf11eb1f788146a398bc11d41270b5830a91ac532676be10b204011ee61c30be99a3a1efde6b186a95a39fbacc3f2d993dfb7b32fec202bdca8a6d06388de53eb1528693b8b9594a695b4f50c00bb80d4fafd6c58e66dcb0e34fa1754d205a21bd36b6e9eb1f7dcd798b57ade41afaa4ced793f680ee3a168b7a238cb6e3f8aa040ca6842b4ae450d20ae3c3fdde0310bd49199e294268311f73934d4cfc3b9f9a651bcbd8cf8d19ea771eb6c99804540e5a3daa2ffe69207a54b39a6bc5202e259b9bbb5de0bf7f90cdc2de699855574d140837d366e26df46194c6c9461a4810fe79262fdecee0d06a1b2c8dac5c94cb15dbd654ec995c8164711e0b2a4dcfc880d68669a10a962e6c6815e31743b5289126141a8cbc011d2c2d65e93ad19e769341c15ac2523308d88dec4e1e6114629ecadf39ebc9386ffb31f5db344043b7f4a8f214da5dc049997e18340befae68472cc5faa9928b3ccb6419a8015df967015b16235a77eb5bca5b1e4f77a9b4f21836686d0115646cb2578ad5a549031b5b961fcd986f6d6c47b986de9c58208189e406a9b744cf2c058a7b525c9d7780f3a01027769fd36a6fefb8a2e546e337e5e73a4c6f7302f389f84b8e87ad2866ef0a9614e8494eee800fad9a8e309f4a999a9d8802565c5e0be936995919570155a9add10641f7e8e8df594bb3a5c969b4d0df2665273688b2f611b6708d880cbd08967a56d6eb5e265ddbd5921638dfa514ec96ff7e659b126f4994296ad4800f482c3b5c372e0de4a7c10e5e6e5fd9044fff26c714508724e11f07c96c1abfe08a95c9b8247c9b55234e23ebb7e75574204ae1813a4180afd4ad84b0741926cf4f3ade73de921417ea12e6ab413c08ba6f335c9f110a8425f613e882304d654ce3eac1ede49075b3b5e2fb3078ed212cf00b30a2a7da84a5967cfe7a41bcb267d1b27d84cb76ae2bdf080efcae6108705c60a86175ad4a9d95	36041347	2025-09-26T07:34:01.000Z	0x0fbe714b24d44606a3b08d6c5fb1e197211c29f81741391ad8925997064afc18
920666197951050	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0x975d85c0e3f446ae9058ab55e4da2043353522945636ddd520a30ea58277079d	false	1056	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	634	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2000f0bfafa1db6670ed5c1213d1289d0e547f3e1309bea42a05b004df0202cc1abb1961fe5367173eff7462a86941c7a695703e72abab6bfd2a416e226e39b81c8025d374c35ad17232ceae1c9285ae5edcc1e39b3b3476b9c16045521ee0ac31674a6f13651df99fff2d039e096d9d370a8161ce0bae61789dc69ede2912a3a0e7721578e2013291fbe477c302025bc04e75702a7bd11e30a59bf51e7b1de033de7b36c7e794deca55e7cf92d686f570596478f850dfe9df597ebf58ad7c598e34bc03f233e83264fb3ca8a8781741db548f3982b5e97cf4692e2392efcbf3474770423167265f038eec3bd210302488b29c96deacb852124fca22863c0d0bb36bf32b24d3096cf9039ca54e79fd2f8a54c6ac34d415f373975d69a1f5efa2b896abb7659d44864acdc5c01ea3721b0ff4211232e4de5609d5f5d7ec87b7351d8a20e5b48667afbbfd802655d1d7fb95bfbb1c5cce94ee4e6e11aa63ebcc80b05f25ad6e3bf5ace2542c5eb4a9531bf59ba598bcbef8624699da0f993cd1b1de27e7780c6a8041c1b6ff6cc713e94071719a94371cb1cf323b961e39dbb2864292b92601ce648aeb01862510f8eec26ecfee51051fc9668dc6cee103ebb690b34717c70ed1d6be370ae45b6d7a152d35e67291cf4dc23ec840aacd555113109fad3	36062946	2025-09-26T19:33:59.000Z	0x114937d181275121820c3fee03c1afd9495e10ef6f5fb731a3d209295a7f620c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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	value	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
4889988	0	true	3824400	USD Base Coin-LP	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x7af935a1	1	S*USDbC	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	2145730	0x45f1a95a4d3f3836523f5c83673c797f4d4d263b	0	2023-08-03T16:40:07.000Z	0x4c80e24119cfb836cdf0a6b53dc23f04f7e652ca	0x878e7e5de53fd49cd76c09406cc7484079c25f81a9fafffd072ef992d119a971	6	6
4889905	0	true	3841500	Stargate Ether Vault-LP	0x224d8fd7ab6ad4c6eb4611ce56ef35dec2277f03	0x7af935a1	13	S*SGETH	0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6	2143751	0x45f1a95a4d3f3836523f5c83673c797f4d4d263b	0	2023-08-03T15:34:09.000Z	0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x8c754216ddc44f7a753b233a45c79626c849b19fbb890388b4dfa99c29a096e7	18	18

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x10eacd3068e605e74b3b0d187478a073e8c5454e	false	4	317480370702868	319560376665354	13826517	2024-04-30T01:59:41.000Z	0xf872e6b13872fef51febf1eed0245d8e037c8e877cbe2983b9a312e5641cc328
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x337b5ce429574a67abfc9ead4fcf036e7f1812a3	false	5	65000000000000000	65427975547467204	13841116	2024-04-30T10:06:19.000Z	0x3ff22d8bcfd7469eb40e820a6dba9a99fbca6883d549f9b63195dc8f0dc57b41
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x314fb60d3f311395fc323736f212f9783aff3321	false	6	2278148467071122271	2293077318568869779	13827725	2024-04-30T02:39:57.000Z	0x1f023a0ee93c561be54928fd34fa7fb6642826d8cd7e9a06026f35419e7feaf2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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
0xbb22fa634ab00973a8aeb5d7ef27517f415f8641	0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	false	672	88467820581725943	89124819229531371	26883764	2025-02-26T08:01:15.000Z	0x004765b6a8115247d4c6480cae6f9989a55ff95d15e20d5e44d8675adc2bfdc1
0x64f55716f825f12c345894682870461d3697af45	0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	false	357	71982512028121423	72517085411761209	26896294	2025-02-26T14:58:55.000Z	0x328c556fe945b0d71222ba4c0e74e6a46327f02abe607377ac6c97464f7403ea
0x137fddc8aab54981cadea0b1883a8f5418551a1b	0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	false	340	84820320793330535	85450233318058608	26893483	2025-02-26T13:25:13.000Z	0x284e01f9125c65e159143c50e1f7292aa769ad922b4faea9698dd1066d311f20

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.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	log_index	in_chainId	in_amountSD	in_eqReward	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x4c80e24119cfb836cdf0a6b53dc23f04f7e652ca	0x41ed11488c45037abd0932982f3f51fe53c19e91	false	7601	117	101	13019488	18880	26207414	2	18880	2025-02-10T16:16:15.000Z	0x0567fd1a36cc5706fa8992b6955a16d6dcfaa91d8f71624a6f79c443ecec3d50
0x28fc411f9e1c480ad312b3d9c60c22b965015c6b	0x50b6ebc2103bfec165949cc946d739d5650d7ae4	false	58212584192399	315	101	934105438883243	681976924358	26200871	13	681976924358	2025-02-10T12:38:09.000Z	0x615b6cbd0978ce0c9e14e65a4244efc30c6702f2ec55c632d3bc8f6296d5a86f
0x4c80e24119cfb836cdf0a6b53dc23f04f7e652ca	0x41ed11488c45037abd0932982f3f51fe53c19e91	false	340545	237	101	94510861	131917	26216954	1	131917	2025-02-10T21:34:15.000Z	0x4992502429d6299984fd893e9975de40ee83a89d934854519ef6aa5d75518b03

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_base.Pool_Swap_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

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

​Tables

​AoriSettlement_Deposit_event

​AoriSettlement_Fill_event

​AoriSettlement_SettleSent_event

​Factory_createPool_function

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

Tables

AoriSettlement_Deposit_event

AoriSettlement_Fill_event

AoriSettlement_SettleSent_event

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event