stargate_v1_bsc

Tables

AoriSettlement_Deposit_event

Deposit events from the Aori Settlement contract recording Request-for-Quote (RFQ) order executions with cross-chain settlement details. Contains order parameters including input/output tokens and amounts, source and destination endpoint identifiers (srcEid/dstEid), offerer and recipient addresses, and time windows for order validity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_order`	`STRUCT<inputAmount STRING, outputAmount STRING, inputToken STRING, outputToken STRING, startTime STRING, endTime STRING, srcEid STRING, dstEid STRING, offerer STRING, recipient STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	block_timestamp	transaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30184”,“srcEid”:“30102”,“endTime”:“1761472941”,“offerer”:“0x679f6d19dd99733bbb3e83108dfd10ebc9fbe972”,“recipient”:“0x679f6d19dd99733bbb3e83108dfd10ebc9fbe972”,“startTime”:“1761472851”,“inputToken”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“inputAmount”:“1313032854835209”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“1283718316178668”}	323	0x190e58cda2f9514234639e69d616bd839e758168dfe1d66bdb3d5b92efaaf650	65962721	2025-10-26T10:01:19.000Z	0x0de2f10461797377c31e43621963d044c244eb1e50441b213ba7f5212543b44f
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30184”,“srcEid”:“30102”,“endTime”:“1761484568”,“offerer”:“0xe7fc3a59af09fd322c846d3a23dcf05bf58019bb”,“recipient”:“0xe7fc3a59af09fd322c846d3a23dcf05bf58019bb”,“startTime”:“1761484478”,“inputToken”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“inputAmount”:“1770595901461593”,“outputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“outputAmount”:“1735392702465896”}	700	0x17ad7d49198cc2c94036650cf75ed3a1587ff0741d6011b3067e888047558637	65978213	2025-10-26T13:14:58.000Z	0x93b1ed6d2fb6579e1fd53e8ee923859ba69cbf8b07e90533e35ec19ff476db0a
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30111”,“srcEid”:“30102”,“endTime”:“1761505060”,“offerer”:“0x6de7a68c2075079099c3c46262c6e09a04e67055”,“recipient”:“0x6de7a68c2075079099c3c46262c6e09a04e67055”,“startTime”:“1761504970”,“inputToken”:“0x55d398326f99059ff775485246999027b3197955”,“inputAmount”:“403206665082795191320”,“outputToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“outputAmount”:“403095790”}	331	0xef9de89787036d43b34cb166bc89513cf2629e18c151601f60969378c5c9635f	66005523	2025-10-26T18:56:23.000Z	0x6496924f810d839517d466245c9a958b5ec82ded28e7b88056f1fb62ea994ba1

Example Query

Query with partition filter

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

AoriSettlement_Fill_event

Order fill events from Aori Settlement protocol recording completed Request-for-Quote (RFQ) trades with cross-chain execution details. Contains order identifiers, token pair information, amounts, source and destination chain endpoints (srcEid/dstEid), offerer and recipient addresses, and time windows for order validity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_order`	`STRUCT<inputAmount STRING, outputAmount STRING, inputToken STRING, outputToken STRING, startTime STRING, endTime STRING, srcEid STRING, dstEid STRING, offerer STRING, recipient STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	block_timestamp	transaction_hash
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30102”,“srcEid”:“30184”,“endTime”:“1761230374”,“offerer”:“0xff54ec0dc3bb987a40b4a56e52e73bc3f9189ba4”,“recipient”:“0xff54ec0dc3bb987a40b4a56e52e73bc3f9189ba4”,“startTime”:“1761230284”,“inputToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“inputAmount”:“50000000”,“outputToken”:“0x000ae314e2a2172a039b26378814c252734f556a”,“outputAmount”:“48731834654205803738”}	397	0xcc5a675401351f6c5bc4bddc927f2ecd4f736f0011618a59b12efeca3192e0b3	65639319	2025-10-23T14:38:15.000Z	0x05ddea6a418cf796d48e678996287f86a7702c47f4b10354fa42ad43cb4190b5
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30102”,“srcEid”:“30383”,“endTime”:“1761230635”,“offerer”:“0xcaca41c458f48d4d7c710f2e62aee931e149a37d”,“recipient”:“0xcaca41c458f48d4d7c710f2e62aee931e149a37d”,“startTime”:“1761230545”,“inputToken”:“0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb”,“inputAmount”:“50000000”,“outputToken”:“0x000ae314e2a2172a039b26378814c252734f556a”,“outputAmount”:“48757705745305938697”}	751	0x4b792b4a84cae4ebb8779c4e4d3d1cd7584a536f53012d6cbd3befe12ebace49	65639675	2025-10-23T14:42:42.000Z	0xc0d3a54731f130e8ba0c74540850b34d42e4448496fec8142491b33a571e09c1
0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	false	{“dstEid”:“30102”,“srcEid”:“30110”,“endTime”:“1761231091”,“offerer”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“recipient”:“0x6d9798053f498451bec79c0397f7f95b079bdcd6”,“startTime”:“1761231001”,“inputToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“inputAmount”:“500000000000000”,“outputToken”:“0x000ae314e2a2172a039b26378814c252734f556a”,“outputAmount”:“1812631880464497412”}	1084	0x5d65d949e36e6c17c302dfdeeff418409761b360144c86e1d333fa7eea035014	65640269	2025-10-23T14:50:08.000Z	0xc9e15a32b6357ad8495e01bc24da747d385da25d739b2981e896432fa9fed698

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
9369262393549071	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0xed494b94faa714f5326b79b89dce5918b50e190550a494a2286aa143796520dc	false	204	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	381	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f2000503fb06ee524658300e4f3f13308028fa76936c8c8b2d218c505dd87dadac4931ddf50482c56ce02ea3eaf07af27b9def2da215afbf08e6497cb06f38ef5658974f96f9724469c99fe9cefd81be6ee4d318d47365cb30f6232865b8a1bda956b56cbf6cb5411525483d244fd720b87d07b5c5e1c9362bd35b60fe7cae3f5de898f3d8d3288a0fc8b4e7a475d736b4d3de3d1e264d627b7a3cf14e356ad3c22386	67037176	2025-11-04T17:53:51.000Z	0x51233564dd3c3ec7af9b29e3a723e5623e41dd64ba664f10540a72cf2f1675eb
5369230397173219	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0xe71ecd4f3516b56cab401c37f92617ef4851e6af11a7019b3265a9dc37e1dd86	false	198	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	282	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f200010d4dd556b2c430ac948e7a84a927d7309c09f788cc4aca701b5d58a6f83398c4	66980867	2025-11-04T06:09:50.000Z	0xe8a8b5a9d01369d6940338f8ba0771497ac4863b95dd2b6a65db8798cfc24260
6409394241018736	0xffe691a6ddb5d2645321e0a920c2e7bdd00dd3d8	0x96a0753cf5cbedcf714d9688fc440ee67527296caf93a19f88e8b4adbc7bfdbc	false	206	0x95dd8db1c0c066eba8c37cd1c6b4c895500b20f2	30101	171	0x0095dd8db1c0c066eba8c37cd1c6b4c895500b20f200015251142e572db88b65edd1460724626a85e44852d986b2b3e282c4052b4c7187	67048372	2025-11-04T20:13:49.000Z	0xe9daf8fdf87c2864fb947e667b5a55789b85cea2fcec2b0686e8e838b40eb6c6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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`	`NUMERIC`	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
4256957	true	3806300	Decentralized USD-LP	0xd17479997f34dd9156deef8f95a52d81d265be9c	0x7af935a1	11	S*USDD	0xe7ec689f432f29383f217e36e680b5c855051f25	18578045	0x4a364f8c717caad9a442737eb7b8a55cc6cf18d8	0,1,0,0	2022-06-10T21:56:54.000Z	0x4e145a589e4c03cbe3d28520e4bf3089834289df	0x89eaacbf8f7d472fd4e612fb3bb35403e1301b7009ffa79081419635846cf2f5	18	18
4482914	true	3806300	Wootrade Network-LP	0x4691937a7508860f876c9c0a2a617e7d9e945d4b	0x7af935a1	20	S*WOO	0xe7ec689f432f29383f217e36e680b5c855051f25	25875444	0x4a364f8c717caad9a442737eb7b8a55cc6cf18d8	0,2,0,0	2023-02-22T02:11:52.000Z	0x5a0f550bfcade1d898034d57a6f72e7aef32ce79	0xd6e3f9fc14dfeb4c55f04c56d99a1ab4fa2f4ad2713c8a43096b23386ef75851	18	18
3821350	true	3821350	Tether USD-LP	0x55d398326f99059ff775485246999027b3197955	0x7af935a1	2	S*USDT	0xe7ec689f432f29383f217e36e680b5c855051f25	16135132	0x4a364f8c717caad9a442737eb7b8a55cc6cf18d8	0	2022-03-17T10:08:38.000Z	0x9aa83081aa06af7208dcc7a4cb72c94d057d2cda	0x18e0190903afce28b60af8fca0eb6f031e08f5be884c115afefafbcb743e6506	18	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
0x68c6c27fb0e02285829e69240be16f32c5f8befe	0xe450d4ab48e29a2e66a350047924f5a54d43a4bc	false	53	876806964	878039212	35172283	2024-01-12T06:11:27.000Z	0x27b6ee69669b21e82286929717d8818c9c663fc57ee1b0a5cd3fee1b3a0b8234
0x68c6c27fb0e02285829e69240be16f32c5f8befe	0x893503e0112cf490e7d32b468af2df7e1824ba27	false	280	7311761	7322051	35178807	2024-01-12T11:38:04.000Z	0xc887417e06d9bdffd29dd9cc03f1f33fe71955f28f108afdb1434179f44854e9
0x68c6c27fb0e02285829e69240be16f32c5f8befe	0x8e2d1ce359218452308afad8fbe47f7bb606366c	false	464	292784925	293196426	35173711	2024-01-12T07:22:58.000Z	0x4b15e58dde7f4284f5a6ff9c5b91f46bfe4b42d338a4986233ef255df4587aa3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
0xf378702a03a8b2a229607c040f392a18a035e169	0x98a5737749490856b401db5dc27f522fc314a4e1	false	72	199865930	200000000	23089733	2022-11-15T23:32:36.000Z	0x71f2cfbb2328065a965078b6d75c0cea7ff26dba3bc2c0b91170f223fc6a8f3d
0xc33f816c1ee804994361c5fe3b7f87ec46201cb1	0x98a5737749490856b401db5dc27f522fc314a4e1	false	447	1498994	1500000	23079294	2022-11-15T14:41:11.000Z	0xd773bec7ecd9f06535302051e6eed1a3b93e878369296da34a808880ad4f776b
0x55e23b335c783975edd1c99390d14fd75d5d970b	0x98a5737749490856b401db5dc27f522fc314a4e1	false	266	4978537	4981877	23062519	2022-11-15T00:26:26.000Z	0x94ea310ada2e21a9637f400ceaf2837cda2ca05aa5e4373cc60a0daa9362f09a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
0x5a0f550bfcade1d898034d57a6f72e7aef32ce79	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	4596449486480958514	10016155950000000000	122	101	100096866114813519041486	34711957	20	50080779750000000000	2023-12-27T05:50:20.000Z	0xc0e056401b13da0be3b390e0f1246277175b761f9164d9b3968564c5d5edccce
0x5a0f550bfcade1d898034d57a6f72e7aef32ce79	0xecc19e177d24551aa7ed6bc6fe566eca726cc8a9	false	200618839633261	668729465444205	402	109	6683282277649391388	34714858	20	3143028487587767	2023-12-27T08:15:48.000Z	0x80d088d14d90676fc6d004a87e8fe4c4452989ab89d1366c4c0bee499a437086
0x5a0f550bfcade1d898034d57a6f72e7aef32ce79	0x52c8001da24b748bf0bc6b322580d3077cbcb687	false	3188554015635082	10628513385450273	108	109	106221362774190034394	34720943	20	49954012911616286	2023-12-27T13:20:20.000Z	0x7ec98209cb4cef2c5ed39c0d4def682d0f1d57faa20b77e4b6cfaee430099198

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
0x46f997877dbd03c2b37fa6a9d34a384e19690640	8120000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	309	44672169	106	2024-12-07T18:49:41.000Z	0xe993d64638e7439b6948945a2cb740408ba74d7fffaa7f23476e61bee4c5ffb6
0x43a423795a7a84c8af4bcfc963e431853f63aa39	1000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	170	44673757	109	2024-12-07T20:09:05.000Z	0x46e3dcb8f22a93e04044a332e00011ea4ab6d0eaeec6d32b107d04a981fc2fbd
0x59b93685a11ed0e0f73dcc777bac4d097c2404b5	1320000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	false	263	44673769	109	2024-12-07T20:09:41.000Z	0x093042ce6ee4e5a4cb212850da42c255c925192827c08d6a4cdc0ce27aa9ba08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_bsc.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
0x0000000000000000000000000000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	0x0bf748d20cae6823e0da16a72886b2b90c408a61	false	6640072917930000000000	45	21890164	2022-10-04T09:14:29.000Z	0x1c80542efaccd9f5d677bff2dfe589399db66b47cf52f147b5ea6039d7c9455d
0x0000000000000000000000000000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	0x5f3f7e4ae0d369aada4e042302c6cec8f231367c	false	12999830000000000000000	164	21888566	2022-10-04T07:53:52.000Z	0x208c00dff7d77deda6267d5e2a2b927d2d5568c21525e5b617a2fe577fbeb238
0x0000000000000000000000000000000000000000	0xb0d502e938ed5f4df2e681fe6e419ff29631d62b	0x75cb713e83040790f0b22d497d2f5ffe451e1e8e	false	2459812476853417378	115	21893139	2022-10-04T11:45:11.000Z	0x8257eb8187522f238b1b3cb0b4d32b8f779f93e6d5511ee9405c457181fbba41

Example Query

Query with partition filter

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