sushiswap_v2_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
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x223913c606f40a6996d816cdb0dd7f1cf7cce4f3	false	870	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0xfd1153a2be2a04ff0ae9e95a25544d58af97f548	6	17646480	2021-09-25T08:10:43.000Z	0xa5ac2380ff2988dcb0e59aaa62ea09a3748664a2f9fba314b8c2b93e51b5678f
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x39efda564761535117eef30bb03d918b8eee60da	false	872	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0xdda5ed81ccc75349916df38dea1012ccc17684d1	0	17651466	2021-09-25T10:08:28.000Z	0x30e1ee8d939f098ca92bae228915010479e3e7b2ef0b49cd6d9c640715d8ecd3
0xc35dadb65012ec5796536bd9864ed8773abc74c4	0xc9dd15a6d82b1f7ecfe467377f6fabd932810049	false	871	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	0xdda5ed81ccc75349916df38dea1012ccc17684d1	15	17651451	2021-09-25T10:08:09.000Z	0xfba8ddd0efdedc1e17f52eee4d3528d3dc0e620ed2204a0ec9b11b100f597685

Example Query

Query with partition filter

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

MiniChef_Harvest_event

Reward claims from MiniChef staking contracts emitted when users harvest accumulated incentive tokens. Contains pool identifier, user address, and harvested token amount for tracking yield farming rewards across liquidity mining programs.

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

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf731202a3cf7efa9368c2d7bd613926f7a144db5	0xb17857c6c382680140eb4eb1aac4eb1184987d47	false	30529679559659588	11	52424866	2022-12-16T04:02:23.000Z	0xa9a53ce5260bc043c95eee1bb34cc3d426382b5fc28720f5e8f70fb00674c9c3
0xf731202a3cf7efa9368c2d7bd613926f7a144db5	0xb17857c6c382680140eb4eb1aac4eb1184987d47	false	24573993433083104	301	52437769	2022-12-16T14:32:47.000Z	0xda2d91356229890cb53b215ab2df5d6608465ae15209aaf3e63059d72a13e820
0xf731202a3cf7efa9368c2d7bd613926f7a144db5	0xb17857c6c382680140eb4eb1aac4eb1184987d47	false	31542628414784420	44	52435222	2022-12-16T12:27:38.000Z	0xaa1f6d32b0857b0c360dd36f86a8cf8475f8a2227cc2d0c3fc76038fe616c331

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_fantom.MiniChef_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
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0x84311ecc54d7553378c067282940b0fdfb913675	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	11	410204696155608494287	120804645716125119731	61155152	2023-04-30T17:50:10.000Z	0x9995755fa3d1bfd73429bd3b0624e83d350252ce56298c27df1fc7e88d28ae9b
0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	0xa48869049e36f8bfe0cc5cf655632626988c0140	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	9	6626205	15588206083304602769	61108927	2023-04-30T02:43:16.000Z	0xe1ef8934851b89173830a4bb5b88cd129731708781d82d51842722721804cdd1
0xce3870506c57bd6a891adc8d35d51557a5b55769	0xa48869049e36f8bfe0cc5cf655632626988c0140	false	0xce3870506c57bd6a891adc8d35d51557a5b55769	37	89476886	210169841427107649904	61161841	2023-04-30T19:57:55.000Z	0x5014474a1268865d88a2222cb40add6c33f77430e478c4a9b9dffdfd840bf5fe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x206d807c14709db7c1c7500395178d9f72da7160	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	6	164283608121448075483	22999999999999999999	3141234	2021-03-30T15:32:35.000Z	0xcc6b7ecfaec383ea21ed62973a2efce680c02ee8602949309b1722649e7057be
0x206d807c14709db7c1c7500395178d9f72da7160	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	6	973199601657167750	130086824302740921	3148362	2021-03-30T17:37:53.000Z	0x97f5c175aa7fff4966074cc050f14cdb976ff4bd5ad7b8136b0e8378649776fc
0x206d807c14709db7c1c7500395178d9f72da7160	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	23	1067216446444271511615	200000000000000000000	3131164	2021-03-30T12:57:20.000Z	0x720a280b3a7573774de0dbbc9f69398c648321195ec37b2044be8705fd15c046

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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_amount1Out	block_timestamp	transaction_hash
0x0103715fd20a3f2e11fd7b3e646a5f6f6703d245	0xbeddbae6e24314a3336ef5e706a9a039395d6cb7	false	0x7efc47d92c90908ef3d82bc52e71235fef23cc02	64	13247421	100000000000000000	39162772162122	2021-07-29T13:33:12.000Z	0x57a1e8e311597cf677aa33bc578f4d94eb1eaf9d50789fdb4681911dadd448da
0x0103715fd20a3f2e11fd7b3e646a5f6f6703d245	0xbeddbae6e24314a3336ef5e706a9a039395d6cb7	false	0x7efc47d92c90908ef3d82bc52e71235fef23cc02	3	13283531	1557081308745571072	606853581609301	2021-07-29T23:50:01.000Z	0x807698a349abb40b6a16f706b5281622f5742c394d6ba7dd566f9dfd86b9a0e2
0x0146ee4158736957714a48f8805bdf5ca924e426	0xfa7ca6e6d17368e0a1fa9c75f2ebe5a8d7be9fc6	false	0x1b02da8cb0d097eb8d57a175b88c7d8b47997506	15	13233623	324403904473654097	548279484359845980	2021-07-29T09:29:08.000Z	0xfdd443c6acbd47aa45a69a5aa63669378fd008de467c4d63d2325b846da6a4ad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0x6158df79da9e0d60b48029d922d6cdc0c562a0b2	false	173	11212071562780	1	30549412	2022-02-10T12:22:28.000Z	0x38f4cb139fafd95ac0a1284a7f1218601304b8d007d51b2313501b5762efdb39
0x14e2c315a4a5414edbcbe5d521f8f4e2ff48c22a	false	93	95785646	5761	30512563	2022-02-10T03:24:50.000Z	0x68c6302b9346edbf41bc3caaffddc516024d9f9be7e7b24213f3fb19d4cebcb3
0x3e5b15be38f91a0fc9f87e852b2c8106c5edad28	false	103	3518586502109331888120	3875325	30555329	2022-02-10T14:07:59.000Z	0x069eb93a4b6bf0e3d14855ecfffd2bb158c77ba1764b58e2cd6a53c9d938f4ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v2_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
0xc8d28a420ace09a0665afb14d794287685a4aa6e	0x0dcb7f634b87b3a40750ef3c5e47b5e42e473104	0x0000000000000000000000000000000000000000	false	2824480580751274919	5	11049480	2021-07-01T09:52:21.000Z	0x4ac0ad2bb2a90db0240f1c2e46ba9143766ab8316e1982372e66e1eab16ce61c
0xcc159bcb6a466da442d254ad934125f05dab66b5	0x0dcb7f634b87b3a40750ef3c5e47b5e42e473104	0x0000000000000000000000000000000000000000	false	40194419062672443	4	11049480	2021-07-01T09:52:21.000Z	0x4ac0ad2bb2a90db0240f1c2e46ba9143766ab8316e1982372e66e1eab16ce61c
0x62304508e0f138cda080ff93f552b4f10e7ee178	0x0dcb7f634b87b3a40750ef3c5e47b5e42e473104	0xc8d28a420ace09a0665afb14d794287685a4aa6e	false	2824480580751274919	3	11049483	2021-07-01T09:52:24.000Z	0x8bc219206119e3656e031cc788db9e421467da4f3db578e86bc1cdb324dffca8

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​MiniChef_Harvest_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

MiniChef_Harvest_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event