spookyswap_v1_fantom

Tables

FarmV2_Harvest_event

Reward harvest events from SpookySwap V2 yield farms on Fantom, recording when users claim farming rewards from pool IDs (pid). Used for tracking farm reward distributions, user claim patterns, and yield farming activity analysis.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pid`	`STRING`	Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_pid	address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
10	0x18b4f774fdc7bf685daeef66c2990b1ddd9ea6ad	0x01a621fe05fe5aab97c3a9841383230a96d8392b	false	0	146	48865747	2022-10-10T14:16:45.000Z	0x51e55bfee0c430e6f31acf0176097fc4c0e32cb807bd069f3d6402cc8a5c9bab
10	0x18b4f774fdc7bf685daeef66c2990b1ddd9ea6ad	0x01a621fe05fe5aab97c3a9841383230a96d8392b	false	0	97	48866473	2022-10-10T14:32:17.000Z	0x59da7dfe164961cfdfce1bfa62e252193401a890a5e0d474c294acd5df42c4a0
10	0x18b4f774fdc7bf685daeef66c2990b1ddd9ea6ad	0x01a621fe05fe5aab97c3a9841383230a96d8392b	false	54702406794283072	135	48875190	2022-10-10T17:39:47.000Z	0x0b81c8f899c14c479e3520578f6fc3985f64b497283c071eb555a4c1fee75761

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spookyswap_v1_fantom.FarmV2_Harvest_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
0x7f41312b5d2d31d49482f31c9a53e6485df37e1d	0x5c021d9cfad40aafc57786b409a9ce571de375b4	false	0x7f41312b5d2d31d49482f31c9a53e6485df37e1d	258	139687658856565270343	26382152410898870870	18613996	2021-10-08T18:08:30.000Z	0x5dec09a3fa8b1caa08ec7b036cc96ae7544e24c8a0d0bbd72b2f0d1a8f71751b
0x7f41312b5d2d31d49482f31c9a53e6485df37e1d	0x5c021d9cfad40aafc57786b409a9ce571de375b4	false	0x7f41312b5d2d31d49482f31c9a53e6485df37e1d	259	94329649782265906914	19461560971947113021	18563865	2021-10-08T03:42:35.000Z	0x259823fb6b2934986608407215e47bf2f6be08132c429b65f8d0db49132bcfe4
0xf491e7b69e4244ad4002bc14e878a34207e38c29	0x2a651563c9d3af67ae0388a5c8f89b867038089e	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	5	1519410654124962621045	1767966454350449091403	18554687	2021-10-08T00:06:13.000Z	0xa6351ca4b181f62a3a324ba48fcb28132bc48fcbb0e0d5de27b4961ce2a910fd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spookyswap_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
0x011732f65e2f28c50f528e32420a2f69937b9e68	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	6	69471514991516967184	2543869779219510180	26188604	2021-12-27T11:46:18.000Z	0x3dda9320f790fb2f88699128973eea5128de7bd86e6a0ba5f851d292392888e9
0x011732f65e2f28c50f528e32420a2f69937b9e68	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	7	78898659572180437213	2861853501621948953	26190351	2021-12-27T12:13:02.000Z	0x7449f47cc724e5b90be46244777c7d66a85ee6f9b502d4fb83d17ab81389ac77
0x011732f65e2f28c50f528e32420a2f69937b9e68	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	7	90300083825156266711	3292426704137094820	26189243	2021-12-27T11:55:56.000Z	0x52f1a54bfeec8373e428397542f5b354c4924893fe913f294dd436c9b8546de6

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`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	block_number	in_amount0In	in_amount1In	in_amount0Out	in_amount1Out	block_timestamp	transaction_hash
0x0000002bf118391ebe8d37f7ab2a4d8ae1c45aa3	0x2b4c76d0dc16be1c31d4c1dc53bf9b45987fc75c	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	4	13238539	0	11000000000000000000	2673603	0	2021-07-29T10:57:11.000Z	0x09bf333a1f6c81cd8ecf3f839dd304bd450310fea8a048c8addda207920ccc7f
0x000cef8f0ab0a2fadbecaeb92e8781ab3e04b01e	0x8bff7b8b6a14e576a3634d6c0466a19a6e9b170a	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	11	13256178	10000000000000000000	0	0	228559590886630648974	2021-07-29T15:53:12.000Z	0x616b1d95483cb1625c4940e6889b27e69f3671b3bf994b6b28485563ffcab235
0x0036dbacf60c73f0351e33a7f2443725bc66d404	0x4733bc45ef91cf7ccecaeedb794727075fb209f2	false	0xf491e7b69e4244ad4002bc14e878a34207e38c29	150	13271381	288034401995942607716	0	0	136567299658298954	2021-07-29T20:02:15.000Z	0x8d94badaf19130b2a5680591be0dbb78625c71818771baf3c468de354441fd95

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spookyswap_v1_fantom.Pair_Swap_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
0x0b9589a2c1379138d4cc5043ce551f466193c8de	false	76	194519184492	76495707536184	66690051	2023-08-06T12:54:24.000Z	0x029540cf041670a9e4d56e26bebe03569482983e5632137338b24ff942f324f7
0x0bfe6f893a6bc443b575ddf361a30f39aa03e59c	false	63	38465485320713692097130	1958131718051770996668	66690051	2023-08-06T12:54:24.000Z	0xc676b2edda91136c6e7a2bfa1cc2d411eabaa54eee63011e2a734f69b39d37e5
0xa196c7754f4ec79de55bb5db82187bbe82275f7f	false	87	601455455756	2544187851936864592382575	66690051	2023-08-06T12:54:24.000Z	0x029540cf041670a9e4d56e26bebe03569482983e5632137338b24ff942f324f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spookyswap_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
0x3b3fdc40582a957206aed119842f2313de9ee21b	0x004d108e4dd54ed629b493ed889c80549fbfa8f3	0x0000000000000000000000000000000000000000	false	14775355015141	47	41390547	2022-06-26T15:24:07.000Z	0x41e5e8ac0a510299dab327554bf07e42708edb27a30818e73cb691a59690a6e7
0xfdedc9e2241de23e9bd6a922eb68850525da2f9d	0x004d108e4dd54ed629b493ed889c80549fbfa8f3	0x0000000000000000000000000000000000000000	false	3888965724473558385	48	41390547	2022-06-26T15:24:07.000Z	0x41e5e8ac0a510299dab327554bf07e42708edb27a30818e73cb691a59690a6e7
0x3921a03fb2280aa6d4c68443169270835a14938f	0x00d6508e6b041e77499ea6d908291bfcaad42d9c	0x2a1d82f5242064330bac450c2305cb1d6cb6e2b2	false	124262601274650	109	41389786	2022-06-26T15:11:28.000Z	0x6f6d68432ff8b37b8149a6abfd9fcd93fdc060dd77f29dfc7b882f6fe96e58f5

Example Query

Query with partition filter

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

PairFactory_PairCreated_event

Event logs emitted when a new liquidity pool pair is created by a DEX (Decentralized Exchange) factory contract. Records the deployed pair contract address, constituent token addresses, and creation metadata for tracking protocol liquidity expansion.

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
0x152ee697f2e276fa89e96742e9bb9ab1f2e61be3	0x51bceeff6d208117cd4d57ce216045f04b69789c	false	24353	0x02479e37d7f134be5e9c9b3e8310329eb97b7d66	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	4	54129760	2023-01-21T07:30:39.000Z	0xcab64c3507c6b68ce33608df90b1bd3d98d6a246f56149cb642959c65f3be316
0x152ee697f2e276fa89e96742e9bb9ab1f2e61be3	0x5d637c7c8dd358eb2ca6f8f77f5f5f20cc01c1c9	false	24354	0x078af57c73dd1d4c7eb3f15ae8bf2bd791b0182e	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	1	54133354	2023-01-21T08:41:52.000Z	0x51f8510ae9c603c3f53070a4c84b8812aecad4fbfe9546295b691d29fcb1b1b9
0x152ee697f2e276fa89e96742e9bb9ab1f2e61be3	0x61a663375af232523a3f625bf7e449096152984d	false	24350	0x19ea07bd17abd687a9b6da9506a3c6779f79a890	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	13	54118510	2023-01-21T04:15:02.000Z	0x8d3d0fadb91ac75bc2cb79dc50c9f20dce1f238c8221dd0839f1212e8702091d

Example Query

Query with partition filter

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

SpookyToken_Transfer_event

BOO token transfer events from SpookySwap v1 on Fantom, including mints from zero address and transfers between accounts. Useful for tracking BOO token distribution, liquidity mining rewards, and holder activity.

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
0x2b2929e785374c651a81a63878ab22742656dcdd	0x841fad6eae12c286d1fd18d1d525dffa75c7effe	0x0000000000000000000000000000000000000000	false	1903866646692742500	2	15339211	2021-08-23T19:24:25.000Z	0x0002d6ab63c0ba11ff6ab3b0b4f88951556d84f8fd20806352b0864f055ce98c
0xe0c15e9fe90d56472d8a43da5d3ef34ae955583c	0x841fad6eae12c286d1fd18d1d525dffa75c7effe	0x0000000000000000000000000000000000000000	false	190386664669274250	0	15339211	2021-08-23T19:24:25.000Z	0x0002d6ab63c0ba11ff6ab3b0b4f88951556d84f8fd20806352b0864f055ce98c
0x2b2929e785374c651a81a63878ab22742656dcdd	0x841fad6eae12c286d1fd18d1d525dffa75c7effe	0x0000000000000000000000000000000000000000	false	3807733293385485000	29	15283129	2021-08-23T04:14:12.000Z	0x000659a8c9dde130ed6944b7511ecc31c01ff09dd62e57641021343d4dc06dd1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

FarmV2_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

SpookyToken_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​FarmV2_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairFactory_PairCreated_event

​SpookyToken_Transfer_event

Tables

FarmV2_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairFactory_PairCreated_event

SpookyToken_Transfer_event