stargate_v1_avalanche

Tables

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_avalanche.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
0x1205f31718499dbf1fca446663b532ef87481fe1	0x3503d0583b4157ae3b7a5cf895479f4c07a8ae0d	false	2	997025	997915	59436163	2025-03-29T19:20:24.000Z	0xe68e20f8cf15e923bbf88794ef5eeeddfc581fd110fb6e0ab164155bcd5f2bfc
0x1205f31718499dbf1fca446663b532ef87481fe1	0x25a7ec9fed551870fbdad657eb7a644cdbb84f40	false	2	999256	1000148	59412101	2025-03-29T07:00:52.000Z	0x5581b8bace84cd5458396a58ddd3f44c7413ba222b207b0cfcb3e6c19a3e9838
0x1205f31718499dbf1fca446663b532ef87481fe1	0xbd8ecc4b5773bda53e138e766bbe009b13eeb2ed	false	2	5117252	5121821	59407041	2025-03-29T04:17:21.000Z	0xc0e97b9bb97393d2de2148859c66a743e484b6b73c688555eda8c25d7adc36b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_avalanche.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
0x061d30d1594751a2c0f770fafb5180a46fe2c7fd	0x1205f31718499dbf1fca446663b532ef87481fe1	false	211	0	0	38457430	2023-12-01T00:37:37.000Z	0x7d60a3d219817f12d3d7bff154d3f5fe0e48e8b6cbe116d356c4a462b5488710
0x02ff309da1477c613f231dbbad48376c53a6d72f	0x1205f31718499dbf1fca446663b532ef87481fe1	false	70	8602663	8609330	38485573	2023-12-01T16:27:58.000Z	0x4b11eef73bd0b18d3e547ae75591cc49adc2367a17b0f6f1e2703013b084ca3b
0x31a11a23c37aff9581bc2afa15d2e56323b8e5b3	0x1205f31718499dbf1fca446663b532ef87481fe1	false	131	12968788	12978838	38482698	2023-12-01T14:50:57.000Z	0xe6fb01c80d18f28e1e22eee8929a4c280ac17af2ce134041c960242e76b9d514

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_avalanche.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_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x1205f31718499dbf1fca446663b532ef87481fe1	0x6a9eb4d69411b7db19888bfd08c7741f6d681fb2	false	26620	101	886472758	40691217	2	860740	2024-01-22T12:12:18.000Z	0x3aaddfe51e283996f71e45db50b9b74f4079ba3a6f2ec59d5f6aba756a8d951d
0x29e38769f23701a2e4a8ef0492e19da4604be62c	0x4d1cdc931e2fe30894d4bff401cc26ef91775d0f	false	2537	102	84548832	40709153	2	48221	2024-01-22T22:22:09.000Z	0x53c39edd7548d08c14326ee4e20ea913d44eb6c5be446ee2c6c9736c48b1e24f
0x29e38769f23701a2e4a8ef0492e19da4604be62c	0xdbdc8b37da1c5429668e511a9e4f3a9b629c0243	false	598	102	19937781	40675108	2	11370	2024-01-22T03:04:09.000Z	0xe7b1847552d2f30393a1e1bdf251ae14e429151db3de3a91f9debf825f846550

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_avalanche.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
0xcc9c693f6db3d7be87762825d6d725c1d5f8ce61	5833720900938803368	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	6	51436155	102	2024-10-06T13:09:08.000Z	0x6dda977475ede81ffd35734a816422ecd9c980691155d0a449b946a7b18586ca
0xd86ca179eef99bc53e053942cbd242e1e3b62c19	5080954273215783670	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	14	51433422	102	2024-10-06T11:33:12.000Z	0x1098da204134c0b1a2c45a4d2a2132321374046535770b2ad43e49e906503550
0x7dd927f52beb6fc1a044274ad12c353ca2efddfe	22000000000000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	7	51435815	183	2024-10-06T12:57:30.000Z	0x07448f69c17a696e51140b0c35d68f875df741e7bac003152a7d63bddd80aac4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_avalanche.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	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0x278624e59041c9df619e5935ba141094a332161f	false	13345127648556759507	32415781	2023-07-10T09:21:55.000Z	0x352edb4b1ac094b6d39cdbac6be76bd8f8d1a743f04de95507c6d630c463cb5a
0xca0f57d295bbce554da2c07b005b7d6565a58fce	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0xecf467274d2e8b29c5b1dd2fd88f64cca5407a6d	false	179456869043286394	32425461	2023-07-10T14:50:10.000Z	0x446931ea600c83622213775b98f4e854e090333396e15524c72d68028f3c1dad
0x0000000000000000000000000000000000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0xe46366aa8ccdd501745a52d432a68d8463d6cde5	false	100000000000000000	32438616	2023-07-10T22:13:47.000Z	0xe53954811e3d3e354a105db44b3841882ecff4572cf5a0945f7c4dbc5a36ad74

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event

​Tables

​Factory_createPool_function

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

​StargateToken_SendToChain_event

​StargateToken_Transfer_event

Tables

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event