stargate_v1_arbitrum

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”:“30184”,“srcEid”:“30110”,“endTime”:“1755052027”,“offerer”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“recipient”:“0x19602f8dbf7d95e3e83bd854977f7782ad47b4ce”,“startTime”:“1755051937”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“100000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“21706061556913623”}	3	0x447cbc6a43e094ffa231ad7b56ba482fa557d6fee1a8e6493d7eb1bf3c5f6210	367843453	2025-08-13T02:25:44.000Z	0x5c583a07e4d2d00f3add9861f7d11ab0c70318a57a6696e972f747dba8ca8fe2
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30184”,“srcEid”:“30110”,“endTime”:“1755115893”,“offerer”:“0x33cb90bce4016913dc04eb0b05dd0b14dec13b2b”,“recipient”:“0x33cb90bce4016913dc04eb0b05dd0b14dec13b2b”,“startTime”:“1755115803”,“inputToken”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“inputAmount”:“179306246763294597”,“outputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“outputAmount”:“951624”}	10	0x6ac641c9534d60f44b2fada2027479418894ea2ef34166ee863ee83894a609df	368099427	2025-08-13T20:10:12.000Z	0x4013e7a8cc90a52e0394fb53cf2629f57e928782027f33da52e45d6e3186642a
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30184”,“srcEid”:“30110”,“endTime”:“1755051169”,“offerer”:“0x5e2561b4317182bd875737d26a797ded6c00a3d4”,“recipient”:“0x5e2561b4317182bd875737d26a797ded6c00a3d4”,“startTime”:“1755051079”,“inputToken”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”,“inputAmount”:“2000000”,“outputToken”:“0x4200000000000000000000000000000000000006”,“outputAmount”:“427268468129769”}	2	0xb37714dfc590804663c964aacb9f209b1b561a57d5ec7268f56ff9a163dc3e46	367839999	2025-08-13T02:11:22.000Z	0xb66c5b70ec5b71fd1459e0da4dda260338fcec3e588b933bdfb0c26ccb62c642

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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”:“30110”,“srcEid”:“30184”,“endTime”:“1757698356”,“offerer”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“recipient”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“startTime”:“1757698266”,“inputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“inputAmount”:“2150100”,“outputToken”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“outputAmount”:“3927026216416843786”}	21	0xb467cb131a4f029a23ef76aecb10b61b16b16512dfabdd79d29868929fa5f623	378441314	2025-09-12T17:31:11.000Z	0x54c1669228479f686e26a69eaa9088a273429f78db4b60b1539bbadb839a5131
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30110”,“srcEid”:“30184”,“endTime”:“1757696377”,“offerer”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“recipient”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“startTime”:“1757696287”,“inputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“inputAmount”:“20000000”,“outputToken”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“outputAmount”:“37334896404761592000”}	27	0x6b8d143ef22a09988f96c2f142675ba5ce7f46dc8405a976a08fbd5eeeb88e58	378433406	2025-09-12T16:58:12.000Z	0xff12722348fdcd789cb5be5bb5ef5e6fbed439f3e66ee7484d48ca6372805218
0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	false	{“dstEid”:“30110”,“srcEid”:“30111”,“endTime”:“1757698284”,“offerer”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“recipient”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“startTime”:“1757698194”,“inputToken”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“inputAmount”:“2150100”,“outputToken”:“0x912ce59144191c1204e64559fe8253a0e49e6548”,“outputAmount”:“3946114887970889881”}	20	0xeddc4b81f796b4aad11164329766064f5877ead87d97961c9e3ea79657b49aa4	378441033	2025-09-12T17:30:00.000Z	0xb8987f5ecb99287404da3c10cea8b2d26dd9610abc6475e44de06e0200be8dd5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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
34790580773603	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0x16f3417efe6df68c337e0ea7d4967c970f8a6ca4fab78d4e6a77b6a6fa7a1717	false	203	0x32757f03722c637f6598dc789e2209a2d05d3965	30184	10	0x0032757f03722c637f6598dc789e2209a2d05d39650002cad87a4d2049340b458c57a09026f8ee3a68a50b9593b8493651303105f62f7acae93c8c8573499eb0c9eb5222f92927ab07249fe1c2b4effdec9e4d7020c17c	369543003	2025-08-18T00:17:39.000Z	0x75e739551e010eb5f28f379b84295b2ef27f7af36b4363a3bf46a4dcc9cda9c9
325282077433937	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0xffda2096cf02a41d5d30e432b2b447748e2aa39502e784043201309392bd0dd3	false	97	0x32757f03722c637f6598dc789e2209a2d05d3965	30101	15	0x0032757f03722c637f6598dc789e2209a2d05d39650001ab07b551bc55f03366dc7b44e52a5c9761e9afd84f0cb51e83167d3253587bce	369543003	2025-08-18T00:17:39.000Z	0x387f6dc3f984f3eb123c6ba21ed568661c796fb063ff0e1a074473dc6d8b2bc6
370606861199077	0xc6868edf1d2a7a8b759856cb8afa333210dfeda6	0x0476a27fd14fccba35dfe2e6d51371495c3de2561b062630ef8de7919691d6e2	false	98	0x32757f03722c637f6598dc789e2209a2d05d3965	30101	4	0x0032757f03722c637f6598dc789e2209a2d05d39650001fd4bbde31bf87f90d203cc83577e3b2ec0d0887fe9d3e3ae6582816d8961927e	369557423	2025-08-18T01:17:40.000Z	0x19d0dab242a2105a4551cf68923331beb8db77726946252a0322d301d960a0eb

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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
0x892785f33cdee22a30aef750f285e18c18040c3e	0x3f61c5ebda9fa7ad334c075f2d22929489af9e67	false	1	240570919	240958069	89645405	2023-05-11T16:08:27.000Z	0xd9864c2b54f3587b9a191cdc66836a41d298acc6b6fd64f297036f3b978a232c
0x892785f33cdee22a30aef750f285e18c18040c3e	0xbecd474275a640d61ea844925b0b1b434214fa31	false	1	6980370	6991603	89580820	2023-05-11T11:39:04.000Z	0xb80a470b0a55f2756833929bfab9fdbf9a3974954bcb7683c95f3f3434fb8aea
0x892785f33cdee22a30aef750f285e18c18040c3e	0xcdc452c83b8772fb53cd152fc447f1114ec45423	false	1	6127768	6137629	89541379	2023-05-11T08:53:14.000Z	0xc03f113b9b024e63b1719ba90177e13bb1fedde8116924b0ff2ac622fb24de65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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
0xc4a88dc35f91e0eba6657d2db54deefb6ff160a9	0x892785f33cdee22a30aef750f285e18c18040c3e	false	3	1000390	1002000	100445046	2023-06-12T15:45:01.000Z	0x9206dfae7a3db8d412d5be4db949a50a4c8166b022f3fcc019c47caa9044a0ef
0x7f305e59aa7fa9dfb7e20756814275cf0d45f39a	0x892785f33cdee22a30aef750f285e18c18040c3e	false	3	1002386859	1004000000	100335651	2023-06-12T08:11:04.000Z	0x3bc76beead0759bd5185e2ba5e74216b4a7dbb4e4c3d93721eb633b405db873d
0x3c5a202d4edd9ed7063b0ca23ca8cbe9e2e8dc64	0x892785f33cdee22a30aef750f285e18c18040c3e	false	3	1003285413	1004900000	100376842	2023-06-12T11:02:06.000Z	0xe86ea86fe917241807df48e61ca2c72a0c688532a8b75c8b0bd7a1520856c6db

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	block_timestamp	transaction_hash
0x892785f33cdee22a30aef750f285e18c18040c3e	0xd7e23c91d00daf2017bdb96f57b69c56dc82c317	false	8	109	997	65703317	1	2023-03-01T10:15:43.000Z	0xe3e1a5e3d14cb6ad6512f29f0c641a9b404d4180fecb3ad35c4a16f94433e851
0xb6cfcf89a7b22988bfc96632ac2a9d6dab60d641	0xd7e23c91d00daf2017bdb96f57b69c56dc82c317	false	25	111	99	65733450	1	2023-03-01T12:25:46.000Z	0xe7c82db00d170df97746e4e373b6156575917dc8f4980bf8ad3aac4b5609e9f1
0x892785f33cdee22a30aef750f285e18c18040c3e	0xd7e23c91d00daf2017bdb96f57b69c56dc82c317	false	7	109	997	65716720	1	2023-03-01T11:14:22.000Z	0x6f10cc7548c9a4231c75d8e7a8cade611688e756e4d41ff29ab36757ad538e49

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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
0x41a096c56a739fc3a6bfbea66c45dae883bc4845	1657782733208935413824	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	7	336818130	101	2025-05-15T04:05:20.000Z	0x3d09b2fcf761a47e2552859ffc5d51b212f94029e6c2f53bf33a6a1c35605589
0xe466aa59b5e599152b3f6d9c3b0524848f7ee21a	106284155336016515770	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	36	336903145	101	2025-05-15T10:02:21.000Z	0xb2ae4ee055772ea580ee323dfca6d9e5b6ec0cb741d887ca529553eb52dca864
0x91ddd14bd8fbf4c944d0015e9d211b82bb9d81b1	100786535371176636239	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	false	5	336905461	101	2025-05-15T10:12:14.000Z	0x61ba2be39bd65389b6a981d8b18ca0ea35aed2ebdb919297c66d540ae045a1e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_arbitrum.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
0xb45eaf45bc144676d5701164c3606d204119c109	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	0x0000000000000000000000000000000000000000	false	26000000000000000000	18	52815071	2023-01-13T16:45:15.000Z	0x0be0a5cfab3e2c53bc6ae614be5ad84fafdf1feb75541366534bea23073e6e9e
0xc962e41e23234eed51853a96b27360c88a528f58	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	0x07749429d3d9047a966b28a489500325bac9f1b6	false	33234872097770904139	21	52776624	2023-01-13T12:58:51.000Z	0xd3c4a0dd53181bb1e4cbf6a28c74523f750c42c646e593c28ffe7e28764716de
0x353c1f0bc78fbbc245b3c93ef77b1dcc5b77d2a0	0x6694340fc020c5e6b96567843da2df01b2ce1eb6	0x07749429d3d9047a966b28a489500325bac9f1b6	false	6147770419845281	20	52776624	2023-01-13T12:58:51.000Z	0xd3c4a0dd53181bb1e4cbf6a28c74523f750c42c646e593c28ffe7e28764716de

Example Query

Query with partition filter

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