stargate_v1_polygon

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`	`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
3939882	true	3824450	(PoS) Dai Stablecoin-LP	0x8f3cf7ad23cd3cadbd9735aff958023239c6a063	0x7af935a1	3	S*DAI	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	35610642	0x45a01e4e04f14f7a4a6702c74187c5f6222033cd	0,1,0,0	2022-11-14T20:55:34.000Z	0x1c272232df0bb6225da87f4decd9d37c32f63eea	0x18c61463aa231e02dc26e7dba2a13ae715ecc7c95f7da12f9fddcef0bf44df68	18	6
3836114	true	3824400	(PoS) Tether USD-LP	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	0x7af935a1	2	S*USDT	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	26032728	0x45a01e4e04f14f7a4a6702c74187c5f6222033cd	0	2022-03-17T08:05:56.000Z	0x29e38769f23701a2e4a8ef0492e19da4604be62c	0xc71d72461e8a8dd06bfb7488bae27f678110c98a192ff0b74b68c40e83a4f4af	6	6
3841500	true	3841500	USD Coin (PoS)-LP	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x7af935a1	1	S*USDC	0x808d7c71ad2ba3fa531b068a2417c63106bc0949	26032726	0x45a01e4e04f14f7a4a6702c74187c5f6222033cd	0	2022-03-17T08:05:48.000Z	0x1205f31718499dbf1fca446663b532ef87481fe1	0x871e66b14aae09a8a71642039647d19843c405d39fab2732e8470297b42fbdf2	6	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_polygon.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	0xc77572b549cb83afccc7068e4258b8f094f39947	false	169	746071504	746563217	45488610	2023-07-25T04:48:46.000Z	0x1f32f4864ab2688298b05d8848d1d216b5d0e27bdf1f0270f96345fa721d89ea
0x1205f31718499dbf1fca446663b532ef87481fe1	0x946e94d7408f928a2f6b07bd19bd87ec87f8ee15	false	222	5000000	5003298	45508439	2023-07-25T17:14:32.000Z	0x32c5ea1bbefb6546070fc669c288dbc6fcb7fa556553c9cbd2eae451bdebe8a6
0x1205f31718499dbf1fca446663b532ef87481fe1	0x6a5705376e2c29bac60cd685f199f32269851f3b	false	84	1010753338	1011419515	45489903	2023-07-25T05:36:22.000Z	0x3d15e987f648ae6b3691008de8b7e00c7745dbc4e2873f8d3dd749e0a1d7e887

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_polygon.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
0xab05bfb2e1a35763fd4b2bd02226f22ecd03a91d	0x1205f31718499dbf1fca446663b532ef87481fe1	false	198	10382400	10390040	52145133	2024-01-10T03:18:11.000Z	0x02082513cce46f376ab23ac333f0c0344b0031d17a586cde99e9a927fe5950c2
0x97de76e77635f856dae681faf621be4d60ca9300	0x1205f31718499dbf1fca446663b532ef87481fe1	false	345	199852873	200000000	52177494	2024-01-10T23:35:33.000Z	0xe000f70a818af64ef8e0c34027698c253aee0f1a9a9bc188f0c043496b42189f
0xd63946b12168e53c1e032492a3a24ba96f8bf26c	0x1205f31718499dbf1fca446663b532ef87481fe1	false	465	99926448	100000000	52165631	2024-01-10T16:16:31.000Z	0xef3631ae54c7b9d79a4b9926f8ec207f83ac9b68869387e378a0300448dd13de

Example Query

Query with partition filter

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

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_chainId`	`STRING`	Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155.
`in_dstPoolId`	`STRING`	Identifier for the destination Stargate liquidity pool in a cross-chain swap operation. Numeric string representing the pool ID on the target chain.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountSD`	`STRING`	Amount of tokens involved in the swap operation, represented in shared decimals (SD). Numeric string denominated in the standard decimal precision used across Stargate pools for cross-chain compatibility.
`in_eqReward`	`STRING`	Reward amount credited for equilibrium rebalancing in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_eqFee`	`STRING`	Fee charged for equilibrium adjustment in the Stargate cross-chain swap operation. Numeric string representation without decimals.
`in_protocolFee`	`STRING`	Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
`in_lpFee`	`STRING`	Fee collected by liquidity providers from the swap transaction. Numeric string representation without decimals.

Sample Data

address	in_from	removed	in_eqFee	log_index	in_chainId	in_amountSD	block_number	in_dstPoolId	in_protocolFee	block_timestamp	transaction_hash
0x1205f31718499dbf1fca446663b532ef87481fe1	0x2faf55a544c5f73666438bc185aecc9d685e6e3c	false	124397	146	101	4144091607	38179154	1	2363549	2023-01-17T04:58:42.000Z	0x45b3e83d4a146fdef81a69c0e7640d405f338d5d75447cece7c657632ff3962a
0x1205f31718499dbf1fca446663b532ef87481fe1	0x0f9c8d582c746a2007bb3b0f7f0d237b30bd18ba	false	155040	152	101	5164922635	38184746	1	2945773	2023-01-17T08:12:48.000Z	0x2440b2ff0ea055f97f2f4ed089db2c795ad491e49f9913120f82f05481bb4ade
0x29e38769f23701a2e4a8ef0492e19da4604be62c	0xdc2716b92480225533abc3328c2ab961f2a9247d	false	2332	277	101	77715208	38176515	2	44324	2023-01-17T03:27:58.000Z	0x1ded090c18c397f8b766c071c76765f02a6526f43cba5a17e20155b45a7af30c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_polygon.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
0xe70bfaf288a88b048db4b2e952819c44b0e94a8f	98427700405740000000000	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	314	36859391	101	2022-12-15T12:10:06.000Z	0x16889d85ebbfa5bab4b18140c68f3f71918d7f2b8eaef003bf08ec47706798e0
0x58328980d7195f05b4ff52eba2010a43fff7918b	37519321926565543959	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	329	36879007	102	2022-12-15T23:31:13.000Z	0x3d8860a18252f7b6aae6df787464fdb78f227db3f4ab576d1ac7f390f15a5d8b
0xdbd950304110fecda365176eb238f52717e3e381	26549937757891366870	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	261	36856778	106	2022-12-15T10:36:04.000Z	0x4000e3f041693317d142f642b4a1dc8194a955384648d3c962f919911b356f72

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_polygon.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	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0x47ce50339162b2374dfb1dff0d7915804a2be665	false	3429763674053187662380	114	34008661	2022-10-06T15:44:40.000Z	0x4baa9997fa789f50ea690803a23e7f87290088acbb7e2826f45a4883cbf8ceed
0x0319000133d3ada02600f0875d2cf03d442c3367	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0xbadffffffff3f678866b558e3fd0a2a4deb4dc48	false	9134424827884807826	215	33981438	2022-10-06T00:02:54.000Z	0x87be45d63f2eb56e4d1e6ce6b6f4a8645c047f3e3f41acdb706254fd52cec55e
0x0319000133d3ada02600f0875d2cf03d442c3367	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0xbadffffffff3f678866b558e3fd0a2a4deb4dc48	false	2197143883320658229	96	33981484	2022-10-06T00:04:30.000Z	0x8818ca14aed92cbd0f6cced014357d76986addbcc88f4b7fe2fd8deb25aa105f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_createPool_function

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event

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