stargate_v1_fantom

Tables

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
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x1c180075ef61ba11c027cf0d709ee570f9a7cbf6	false	7	6190474304	6190474304	76649204	2024-03-03T05:28:10.000Z	0x18915cdf651bef798aeff04a6356af28095335669a6c30103dd9c94b33b282af
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x36e7e8fc9552d4f1590c0f3978e0386c8ca72969	false	183	200800000	200800000	76654598	2024-03-03T10:39:38.000Z	0x8fd7a655ec4cb5bf7ae70231f1cdbcde49712f506b450a183b7477c7cbd17bad
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x3baa16325f0014e1dfd2e33a4fe1fd3e510159af	false	1	1398274472	1398274472	76654795	2024-03-03T10:52:40.000Z	0xff1c118454bcb541a05c6f0bb551b3cbd7de45f26b183e4e7c889f5ed6e74f56

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_fantom.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
0x77ac6a6d7d81d5992b20f567904229c2556faf7b	0xc647ce76ec30033aa319d472ae9f4462068f2ad7	false	3	300000	300000	97738327	2024-11-19T14:08:01.000Z	0x5514c21cb4b907a47293653182cb0911d9975859ccf2cfeb7002787e1cfbda94
0xf32be088eef49ea0fe9841c3a08592e606d0b65b	0xc647ce76ec30033aa319d472ae9f4462068f2ad7	false	2	10000	10000	77088609	2024-03-10T19:49:00.000Z	0xd3142dbf037afe0244dd322ba8123452b980075ac0bac1e3d260529f9d25fe58
0x5094086cb7f12bceb2639549f4691f856cd422bc	0xc647ce76ec30033aa319d472ae9f4462068f2ad7	false	2	103854786	103854786	77053012	2024-03-10T01:51:31.000Z	0x552139a6448d2c1d74723f5ac7a3623511c74dcbb516b4cc5af8918d3f4ae531

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_fantom.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
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x162f4635222abbf76d25f6e02bb76ef21b246041	false	163235	5146	0	106	51253255	101485353	1	46321	2024-12-30T10:38:31.000Z	0xc66bc946396d3da77618a594eb3e0c9cc4f894588734e85c1ac59969f269838f
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x68b2ca416a9109c9aa5221079ab64d2921410c61	false	480584	15173	41	106	151104082	101485086	1	136562	2024-12-30T10:33:18.000Z	0xa32d4995e490f16345b944e3baf1958430f2b75c154566ecc7edc6be85637670
0xc647ce76ec30033aa319d472ae9f4462068f2ad7	0x0dd1aa0fb1ca21af1f0a7da0b54339fac617c141	false	808909	22032	3	109	219295690	101454582	1	198292	2024-12-30T01:28:42.000Z	0xbd48f1efc4489c26b92bc9fa1fe7adcd1169150ae7ebb57f24d49a543195f39e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_fantom.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
0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd	2804967103500574685145	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	4	42903375	2	2022-07-16T17:29:13.000Z	0x364df4f5608b8e200db6f8494a4fa0f084a6d563caa9d9dd4ffdb140c892bfb9
0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd	2814469051302754721487	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	35	42903290	2	2022-07-16T17:27:47.000Z	0x60795cb90b487d385f629a2e858f7101b8e8cdbea219fb691e3ae0a81d429f64
0x1118869ea46bd1673e0ac7261e85a2bcfb6764cd	2824157376064068797737	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	false	38	42903232	2	2022-07-16T17:26:37.000Z	0x1b74abdf9293592ddbc7e759c9323e5aba65c60cd1867b382dd2e1d0131125d6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.stargate_v1_fantom.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
0x327518480b2d37b6b0a2834aa1f15d41b0f19af9	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0x0000000000000000000000000000000000000000	false	100000000000000000	157	74800719	2024-01-26T16:34:23.000Z	0x2fb0e57d1ccfb13ae4baa48771b04773957e8d7889d276e62af41c89e4a15f1b
0xe8745f7f4c0b61fbc2b56c25abf3b19b22c73948	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0x0000000000000000000000000000000000000000	false	744761140000000000000	211	74788113	2024-01-26T06:15:28.000Z	0xba10a65b0ae1a6070249f1acd3ca890a933569b8693a5d44086e279cf7ce9cba
0x6948d663e33a73a183f265b50a2a98fc0c9c3b87	0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590	0x0000000000000000000000000000000000000000	false	21314310000000000000000	279	74791003	2024-01-26T08:41:24.000Z	0xb9be3f8152ab8dcc347aac686d930ed00f532bf7c1ce54ee706b7d0cdefb2bf3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

​StargateToken_SendToChain_event

​StargateToken_Transfer_event

Tables

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

StargateToken_SendToChain_event

StargateToken_Transfer_event