spiritswap_v1_fantom

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0xef45d134b73241eda7703fa787148d9c9f4950b0	0xc9b98e4a4e306dfc24bc5b5f66e271e19fd74c5a	false	1162	0x82f0b8b456c1a451378467398982d4834b6829c1	0xddc0385169797937066bbd8ef409b5b3c0dfeb52	23	19113454	2021-10-14T23:00:54.000Z	0x27f4ef880e93f55a2d5a236a8637904ab842ceef42bf3da861512314e09b9607
0xef45d134b73241eda7703fa787148d9c9f4950b0	0x9309aa76f94e155f96ccdd9eea6d213e0d590f66	false	1161	0x468fc9bfb3656da7307aa991d35448d81d2ef61d	0x5cc61a78f164885776aa610fb0fe1257df78e59b	0	19081730	2021-10-14T14:26:37.000Z	0xe16545e0ee082941da9b39035f68ad0433089e3b43412109788bd41cd63c9811
0xef45d134b73241eda7703fa787148d9c9f4950b0	0xff59735b1ffb626f888332a7d3696975e7f8e3de	false	1859	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x323b05c10029ae66b46baf0604739331edb4808f	16	33460434	2022-03-15T04:39:44.000Z	0xca92870df3f71090c69ac1adde8103a302b059cc6e78cfc0f88cf4febdfd2c14

Example Query

Query with partition filter

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

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	0x30748322b6e34545dbe0788c421886aeb5297789	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	5	279991155977065070448	1577303470583159185280	10779099	2021-06-27T19:27:22.000Z	0xe7c640221c06ece966a879e8e266e907d23e3b7375af3c4d575d6416e810fd91
0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	0x040dd0d0f5e2a01feb0c5457abb588b23cf4c43a	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	6	154338025587334177565	224171180077846059	10733286	2021-06-27T04:13:50.000Z	0x05803df3d95eecdce1dcdff59f7c3b0651d62bed175125097204692345b19cf4
0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	0x040dd0d0f5e2a01feb0c5457abb588b23cf4c43a	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	6	250637122575244487332	372427966322550114	10792303	2021-06-27T23:36:53.000Z	0x192273a2b9ab8d8cb6fb8ad4143fbd29034dc08adf2d182d07cffa892dfd184e

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xe7f86cef8fef60ce5050899d1f8e465c00d04a79	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	5	36384300	42536584	69913420	2023-10-29T02:04:59.000Z	0xad947086eaf5161f417e89db75055ea4748bee01db93640189c767ac60ff29f3
0xc28cf9aebfe1a07a27b3a4d722c841310e504fe3	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	6	75917174989083379800	5591722230462347500	69938572	2023-10-29T17:39:56.000Z	0xbcb9852f7b1aca8101d9c13c0f1730db6353fb36e4ad241f311cf2783404b8c1
0x15fd4c105ead01fc357cae997cbd7fe989fb40e5	false	0x16327e3fbdaca3bcf7e38f5af2599d2ddc33ae52	7	2263093859178875460000	10224900417149950246425	69909652	2023-10-29T00:10:03.000Z	0x0e58f23a4d987d132aae55f2844bb2a7081833d1c9acfec373bb9204f813c9d0

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x00fc5d6c2e45644837994d7ff024daeaa579d7ba	false	50	172544364404569723396	4225378431883868074724	53669303	2023-01-13T04:10:30.000Z	0x40d9fbd58650e22a5cbe670f97053f50db66b35c6533a1a54a9c0b2d436cdd83
0x01426fb55132f6be843f0af53cf4f0faf7f14125	false	6	5723673147647418185853	11140917292015244207	53708315	2023-01-13T19:22:37.000Z	0x442cce361d2a00834bceb3b604015fa721cd5b6de8a80bc037646383c8ba5389
0x01d8ab2573bcbc8dde113a9827a6d2f21b41c325	false	2	16246291853609186802	692866024027447287	53664967	2023-01-13T02:19:40.000Z	0x936d17b8238ea99873931a5d12eb7dc8dab7bcc1d3fb0cbfe3ed1171e6838330

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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
0x4d5362dd18ea4ba880c829b0152b7ba371741e59	0x02376d39c7cdc95207969f53958c09a69e70b155	0x0000000000000000000000000000000000000000	false	1228021042774547801	73	12026061	2021-07-14T03:26:59.000Z	0x0ea1fba69435d3c6d808ac1ef82cb0f3a8d26d7e18629805c797b19d31d2f251
0xa22fd33f9122a112946873db8c0e78df8050b3d5	0x02376d39c7cdc95207969f53958c09a69e70b155	0x0000000000000000000000000000000000000000	false	51836951375119408	74	12026061	2021-07-14T03:26:59.000Z	0x0ea1fba69435d3c6d808ac1ef82cb0f3a8d26d7e18629805c797b19d31d2f251
0x5bc37caaa3b490b65f5a50e2553f4312126a8b7e	0x02376d39c7cdc95207969f53958c09a69e70b155	0xa22fd33f9122a112946873db8c0e78df8050b3d5	false	0	45	12026061	2021-07-14T03:26:59.000Z	0x0ea1fba69435d3c6d808ac1ef82cb0f3a8d26d7e18629805c797b19d31d2f251

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Sync_event

Pair_Transfer_event