stargate_v1_optimism

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”:“30111”,“endTime”:“1758486535”,“offerer”:“0x0a8c33a7359eff8d306c8079b4043bbc1d887ae8”,“recipient”:“0x0a8c33a7359eff8d306c8079b4043bbc1d887ae8”,“startTime”:“1758486445”,“inputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“inputAmount”:“15800000000000000”,“outputToken”:“0x01bff41798a0bcf287b996046ca68b395dbc1071”,“outputAmount”:“70897109”}	44	0xecdf4f3dc5c286c105dce8f9f5a3815771d3e2e380d4f9561a358dd83cacb647	141443841	2025-09-21T20:27:39.000Z	0x58580886067ec190eb3744874ff1e5f43158468a97838f107f33f19aea48312a
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30111”,“endTime”:“1758465117”,“offerer”:“0x87c5393736d3ce4a9fcb6e1d6893bd032eddcd65”,“recipient”:“0x87c5393736d3ce4a9fcb6e1d6893bd032eddcd65”,“startTime”:“1758465027”,“inputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“inputAmount”:“500000000000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“2238384”}	176	0xf19791a87a66486e9ce888551c97137e1ce5c2171dc35f5f9cc1f049fbc2212f	141433131	2025-09-21T14:30:39.000Z	0xcbb9c5967c7f81088a0c2460554d7ed9d74dd7f95f36055f2301291e5da9588d
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30111”,“endTime”:“1758465139”,“offerer”:“0xe876084b9e0266dba674ebd367ba0363341e6dda”,“recipient”:“0xe876084b9e0266dba674ebd367ba0363341e6dda”,“startTime”:“1758465049”,“inputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“inputAmount”:“400000000000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“1790680”}	204	0x14227b0f617e8a28ee4643a33df8dd15788aae112922e83bffc483a18c70a2ff	141433144	2025-09-21T14:31:05.000Z	0x827520c66bd73f74a21ac0b47058e5f03aa4d7d8765868af56a34223250c1f52

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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”:“30111”,“srcEid”:“30101”,“endTime”:“1755904664”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1755904574”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“19021157”}	60	0x1d365bfc4475e2bf34cd871917818c772f1102add0d21e638c4373d9f1862e23	140152907	2025-08-22T23:16:31.000Z	0x5764fd2f96e3e1bace54385f76299421c63440e9f6bb6f99ef578099d5300aef
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30101”,“endTime”:“1755879464”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1755879374”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“5834781”}	99	0x56840d868d354ba274d48ef8dcb201a2325c0af47bcc8e322b6c336637b7d656	140140307	2025-08-22T16:16:31.000Z	0xf63661e8ae19cc7eb94668ab177761d32bc2398bbd91973621b6d958a6f37662
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30111”,“srcEid”:“30101”,“endTime”:“1755825464”,“offerer”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“recipient”:“0x804f8505cdfde9714996183c9d6918392f0f6775”,“startTime”:“1755825374”,“inputToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“inputAmount”:“20000000”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“19793494”}	18	0x7ce3c441f89ed360a3f94f8c0f0fdadc9fd42c9e9eb223aa0b390dd6ab10e634	140113306	2025-08-22T01:16:29.000Z	0xff3b883683263e5d80759894b772e0d0d309c16a7472a0092948edf696a8c82a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
571427165538931	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0x2e48f0af2e946f8246f4e3d8b06f4c0f82063b4ab4021d412dec9fca0a8982c9	false	608	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	173	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f20004969e5bf9731015768c3179c9dd216c5c33819bf64aca3e97a9ea17ec1da842aaccfd9dde4bf2dc4c07949cf64c854dbf8dfd71bd4daf91eb01ea12751bc7627cd1bd24ed9e3e64ee63dd6ea170dcb3da7943ec11dc0290c1b8b8adeb186400cb2772cde64487691bdcfa118720af0d008b48d02f14d158196c7ed706c91cf699	140674182	2025-09-04T00:52:21.000Z	0x6464624d29f41d17026bccba10e85e68677c584e28f3e21985170efbc05b37cd
37962063024055	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0x4816436d0e497467730cd0ab1eb61d5c95a581c43c85e62f8dfc32a6a5f6314f	false	375	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30184	169	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f200028ea59056690e997079d40f11ff88b9fd87ff03800b78217e0d98ffde00462de058083e1478760b3d7253436b9c61f5ab9696289352a5ca0923ad27af870ca9e2	140674182	2025-09-04T00:52:21.000Z	0x62fc84efca67d3a061cc625ce7549e43aafaade23e4ca10a9c3d7ac45d83b21e
492607163013577	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0xfd9d130d339d39dc57da67dac43190c20a5b38c7864d86315384644ba86b7fcd	false	609	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	125	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f20008119c563cc72365948e624e9e196b207df0d4de46de3614116bcf07e685e005690b57a0e54457ba5e08a540f72a354835e82707b6d9fb50e166f6addbfd5d5e2f141c8264087be8eb31bbce82f6d27677cb0cba625e7e0766b7a6bb045ad73e2614b5a25010c3d69d1a7cb0741c6a16257fd8f730c733d657a0621474d20c8b90793bc2b3b75a0f41b734cf27c8c117d33e3cddc7b6eb651d29153dd11b9ace809e73d069a83e141a9edfa77493f115787a8a1feeb5883a88120eb163d7eb4c6554bd6694821a3b81daf6bfebfaa37fe90a752aedaaf83336907abbb00a30f0e375adb46ed6b022e404f13eaffcb5b49c94be31a6e580f8d52ca7441e01c220b6	140677600	2025-09-04T02:46:17.000Z	0x7ce174cca4aeec56d5fcfa68652369455afb948fcf7201392796f39dc7c61fe4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
3939833	true	3824400	Stargate Ether Vault-LP	0xb69c8cbcd90a39d8d3d3ccf0a3e968511c3856a0	0x7af935a1	13	S*SGETH	0xe3b53af74a4bf62ae5511055290838050bf764df	13332734	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	1,0,0	2022-06-27T18:23:43.000Z	0xd22363e3762ca7339569f3d33eade20127d5f98c	0x424b6496554d0f97c91b955f7b961f90bb0eec157602604592903978151b6c59	18	18
4376431	true	3824400	Wootrade Network-LP	0x871f2f2ff935fd1ed867842ff2a7bfd051a5e527	0x7af935a1	20	S*WOO	0xe3b53af74a4bf62ae5511055290838050bf764df	75856818	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	2,0,0	2023-02-22T02:08:25.000Z	0xb0a7e3b4aedb6f103bc43f2603c6e73151c8886b	0xef60431d429f4e539d86a86d1a4d85b208bd2f11c474c971d9113911a3a4f790	18	18
3841500	true	3841500	USD Coin-LP	0x7f5c764cbc14f9669b88837ca1490cca17c31607	0x7af935a1	1	S*USDC	0xe3b53af74a4bf62ae5511055290838050bf764df	4535509	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b		2022-03-17T07:52:39.000Z	0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0xefe9c26748a7a0e058232b92003c92ff9afabf29feabeba03b64705b30d252b8	6	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
0x165137624f1f692e69659f944bf69de02874ee27	0x1ea3da9b3641e41e10f39678bb53554aa070fc09	false	17	1104000	1104173	131211410	2025-01-27T23:46:37.000Z	0xb4e246b51ecf8d11562e7a8e99ec6fbeea22ededd6d7d3df828597189e3d7605
0x2f8bc9081c7fcfec25b9f41a50d97eaa592058ae	0xb33036386450cb904af3109059493cc4f28b2543	false	1	41864187	41876374	131181388	2025-01-27T07:05:53.000Z	0xbbda5dbd7c87395764728e474b730d0887a61c060d006ef32350d1d06ab99afc
0x368605d9c6243a80903b9e326f1cddde088b8924	0x4deb9b89f1493bdef9fb7c637121bee3964ecae5	false	66	44903832	44907394	131181870	2025-01-27T07:21:57.000Z	0x9d1fc8de8645138be1d9c66e8ddfe27066c2cb9b440cbb19e0883a52bfdcabf6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
0x6398f2612e98c39de1bd54f5e55019e2a6f981ff	0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	false	3	99945557	100000000	6480866	2022-04-26T10:17:34.000Z	0x0270b76c0c98e6dbaa24de001ae93d159a1afb336fa1e34f4f09ad68ba9990ce
0x552e66e3b9ec27d67a8326993a2580aeab7798a0	0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	false	3	100944885	101000000	6532299	2022-04-26T23:42:30.000Z	0x2bd20f4fbf34915bb0ed48c2db9f3ca36e0bb1796b167c07dc0063b452da7c37
0xf808825029737224d228d542ea35e4e30005010e	0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	false	3	102712006	102768073	6506706	2022-04-26T17:36:53.000Z	0x23a14b36f15f75077692d16d20cad9dc225ba8a9165462ce9006654b3bf503f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0x09fc1031d03a78ed4f60463fa9749870d33439bc	false	43668	655030	1	1454749529	5112956	1	174675	2022-03-31T08:13:33.000Z	0xc473912b1adc6d1b5c88a6c327eb92fcd9c4d7c93b8817cf160013dde4525fc0
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0xae75b29ade678372d77a8b41225654138a7e6ff1	false	3000	45000	1	99940000	5146001	1	12000	2022-03-31T18:15:16.000Z	0x0fbcb826e360a43fae3187b37131496c133c0fca3b59d832bf72b493822a51af
0xdecc0c09c3b5f6e92ef4184125d5648a66e35298	0x92bcfd8132d58af96b40b15f349ed8c7665b4eb0	false	122152	1832293	10	4069319408	5151417	1	488612	2022-03-31T20:47:57.000Z	0x48a6e39fd493372c6105b11077299c57fa2c8227555f1b498bbce8e265dd621a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
0x8d5b48934c0c408adc25f14174c7307922f6aa60	3000008224847173084300	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	5	30566007	101	2022-10-21T09:33:36.000Z	0x51dcee2c3db33201602178c6aa44b80ace76cac6b934d9fd420064e8b16bce18
0x3eedb85da27cac4ec83ab5a8a38f18b0edbc7042	300982635589025197094	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	5	30649631	101	2022-10-21T19:28:59.000Z	0x4e0550c59f711167cd5f05bf65e7d924ce126eb59ceaaf729b6fed58d84fee45
0xf22d0475241c1da4079619675083577c1fdbead3	214412750158066494499	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	false	5	30520092	102	2022-10-21T04:33:45.000Z	0xf753e75987e25371b4f20cc173e241c84fdb717639f6faf59f2e322c5372bca9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_optimism.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
0x2d722c96f79d149dd21e9ef36f93fc12906ce9f8	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	0x1de84e1324baf5a9f3a49a48892fe90ce48456f1	false	2196729334208468911267	7	123954345	2024-08-13T00:04:27.000Z	0x525381c233f79708e96ea57dd25313fa8dd2e7c3f53f1b70c06733990174e874
0x2d722c96f79d149dd21e9ef36f93fc12906ce9f8	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	0x1de84e1324baf5a9f3a49a48892fe90ce48456f1	false	2540299487287728466319	2	123954348	2024-08-13T00:04:33.000Z	0x4f8959603d64280bc1fd135f7af42077ff469fd7d9e006a3e27a375ae6e05b52
0x2d722c96f79d149dd21e9ef36f93fc12906ce9f8	0x296f55f8fb28e498b858d0bcda06d955b2cb3f97	0x1de84e1324baf5a9f3a49a48892fe90ce48456f1	false	3376525124588714964848	16	123954350	2024-08-13T00:04:37.000Z	0xe9fac1caa777485f26524c351f113814e8fa1ef81e7458872af280102526d74a

Example Query

Query with partition filter

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