kittypunch_v2_flowevm

Tables

PunchSwapV2Factory_PairCreated_event

Liquidity pool creation events from PunchSwap V2 decentralized exchange on Flow EVM. Records new trading pair deployments with token addresses and sequential pair identifiers for tracking DEX growth and token listing 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_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
0x29372c22459a4e373851798bfd6808e71ea34a71	0x20e0cae3edbd9e5aec1175c8293626443d3dca31	false	120	0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed	0x717dae2baf7656be9a9b01dee31d571a9d4c9579	0	46361443	2025-11-11T00:37:40.000Z	0x78ee7ece97a410e4e3ffa69d7ec231d7a0065e7728ff276b79782c1700754c0a
0x29372c22459a4e373851798bfd6808e71ea34a71	0x967981e4ef6fc1416a398d7899b63f947ab5b6e9	false	88	0x91a3df77816007a1f13bc06435d867c25a215ee9	0xa79fc39bc4f98025ccc9cef432610fe52876815b	11	31044837	2025-06-20T16:44:14.000Z	0xe301cd438d0de41943506828a31162a32c79e7dd7a20c4fdf938ce761f0406d0
0x29372c22459a4e373851798bfd6808e71ea34a71	0xf3474766a4cf6ed47525c106ef98276cde98caa0	false	87	0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed	0x91a3df77816007a1f13bc06435d867c25a215ee9	11	30989074	2025-06-20T04:19:37.000Z	0x5d7a1bdf1e95889c163429c2ba0e7eadeef847854caf56312d4e60d8ed4e5cba

Example Query

Query with partition filter

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

PunchSwapV2Pair_Burn_event

Liquidity removal (burn) events from PunchSwap V2 decentralized exchange pairs on Flow EVM, recording token amounts withdrawn and recipient addresses. Useful for tracking liquidity provider exits and pool depth changes across 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_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
0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	0x4b07f2d19028a7fb7bf5e9258f9666a9673da331	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	5	1299999999	2394197498420351696784	6972124	2024-11-08T20:13:20.000Z	0xf181b41fada997e4bbe2da4778120f345574b4cb6ba3cfc5d6c3acb373e4b846
0xf42935853fc5429e33c49685e7fe3a89edb02fe3	0x4b07f2d19028a7fb7bf5e9258f9666a9673da331	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	5	1299999997	2394197494736952801076	6972652	2024-11-08T20:20:25.000Z	0x82ebc293303bf6e7416f2e028a0c0f99f88c78f836f01f33b57fafa67dea24f2
0x682c3ec35127ff2115c7006a551081f7c03a5eb9	0x4b07f2d19028a7fb7bf5e9258f9666a9673da331	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	6	129410938	173885178042309711892	12396446	2024-12-29T02:58:43.000Z	0x54f908ecbedafa5ae7c47d33fdb6f15837ba4e500d5a236fb90d18a8624e019a

Example Query

Query with partition filter

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

PunchSwapV2Pair_Mint_event

Liquidity provision events from PunchSwap V2 decentralized exchange pairs on Flow EVM, recording token amounts deposited by liquidity providers. Used to track liquidity additions, pool composition changes, and LP activity across 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_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
0x27d955b3a85c091b496912b3fedbd8a5c8e28005	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	13	17032083299186402278	19999999999999999999	48991742	2025-12-05T09:21:37.000Z	0xbe66e49c8d78cac5322169e5ceef6dcf3dc212a52c1348ca91b2b2dc9b03a169
0x17e96496212d06eb1ff10c6f853669cc9947a1e7	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	4	117153778	367136411145416000000	31791506	2025-06-27T15:25:20.000Z	0x7835fde7ec30426108ef014f3895d174a90c4b08c32b2acf09219c8634f47a38
0x17e96496212d06eb1ff10c6f853669cc9947a1e7	false	0xf45afe28fd5519d5f8c1d4787a4d5f724c0efa4d	4	163465	512271611737250800	31759485	2025-06-27T08:17:26.000Z	0xbe814e68b8e65479fe7b69cea7ec9dd15ab0e9729220d9679cc6023ec282d252

Example Query

Query with partition filter

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

PunchSwapV2Pair_Swap_event

Token swap events from PunchSwap V2 decentralized exchange (DEX) pairs on Flow EVM. Captures individual swap executions with input/output token amounts, sender and recipient addresses for analyzing trading volume and liquidity flow.

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
0x74aa6977536f498c5ad4f30c02718c6c1988a112	0x442ae0f33d66f617af9106e797fc251b574aedb3	false	0x74aa6977536f498c5ad4f30c02718c6c1988a112	6	4009953	0	1353872072440368665580	1325547548145382554763	0	2024-10-12T09:06:43.000Z	0xbac9914dd01651dc4c6380e31229f70d8a1efe768d9b81754e81770391e2bd8d
0x74aa6977536f498c5ad4f30c02718c6c1988a112	0x4b07f2d19028a7fb7bf5e9258f9666a9673da331	false	0x74aa6977536f498c5ad4f30c02718c6c1988a112	3	4039337	333265419	0	0	604440168174792745776	2024-10-12T15:38:35.000Z	0x5e0bf43a48097f43c43b773c74918a264de132635c87379735cf4634636bb258
0x74aa6977536f498c5ad4f30c02718c6c1988a112	0x442ae0f33d66f617af9106e797fc251b574aedb3	false	0x74aa6977536f498c5ad4f30c02718c6c1988a112	3	4034058	1158864987474447220967	0	0	1177025943274317421203	2024-10-12T14:28:12.000Z	0xd71da538e30a2b04e7c6bb962a10d347882efbb8447181ef534773e09caa1ef4

Example Query

Query with partition filter

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

PunchSwapV2Pair_Sync_event

Sync events from PunchSwap V2 liquidity pairs on Flow EVM tracking reserve balance updates for both tokens in each pool. Used for analyzing liquidity changes, price movements, and automated market maker (AMM) pool state over time.

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
0x11152a6d924dae1bcdb449faf97033726ad9e19d	false	4	38064182621481764934357800	15772225910577562180565353	25619657	2025-05-01T09:19:46.000Z	0x4ca5e6f6c34ee93f30ba67b7e970774f414d87aaaa6a57f4c61ea4c380a11c68
0x11152a6d924dae1bcdb449faf97033726ad9e19d	false	4	38065765397943345961802733	15771567758445510619501929	25593712	2025-05-01T03:33:38.000Z	0x5109e1f4b1a75f81c04fb58e0c48425afe357b05a184a4d7bc5b3e26b751f2b5
0x11152a6d924dae1bcdb449faf97033726ad9e19d	false	4	38066972348955086766337154	15771066051487386964039758	25579207	2025-05-01T00:20:09.000Z	0xa8eb14e0ddcd6b0c74cd4e8cca87f34fe2bed7c5edc048f0b47b60185695fcca

Example Query

Query with partition filter

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

PunchSwapV2Pair_Transfer_event

Transfer events for PunchSwap V2 liquidity pool (LP) token on Flow EVM, tracking mints (from zero address), burns (to zero address), and transfers of LP shares between liquidity providers. Used for analyzing liquidity provision activity, LP token holder distributions, and pool entry/exit patterns.

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
0xbbb968172a6ca191edbae510ce45521eee81a102	0x17e96496212d06eb1ff10c6f853669cc9947a1e7	0x0000000000000000000000000000000000000000	false	259681573377	2	18754881	2025-02-26T03:59:48.000Z	0xcbdf97d6fae0aa06665561bfdf954ae3dd0861700e471b44377b4defedb872ef
0x88fdc16d6ba532a79aa08cccc1ed6b48581cd9b7	0x17e96496212d06eb1ff10c6f853669cc9947a1e7	0x0000000000000000000000000000000000000000	false	479401975635	3	18754881	2025-02-26T03:59:48.000Z	0xcbdf97d6fae0aa06665561bfdf954ae3dd0861700e471b44377b4defedb872ef
0xb334b50fc34005c87c7e6420e3e2d9a027e4d662	0x17e96496212d06eb1ff10c6f853669cc9947a1e7	0x88fdc16d6ba532a79aa08cccc1ed6b48581cd9b7	false	479354036729	0	18755898	2025-02-26T04:13:23.000Z	0x2c929f1eef4ad88bcceb54915b4a02aad7b6d888c749c1fb0c602ecff4c996f6

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

PunchSwapV2Factory_PairCreated_event

PunchSwapV2Pair_Burn_event

PunchSwapV2Pair_Mint_event

PunchSwapV2Pair_Swap_event

PunchSwapV2Pair_Sync_event

PunchSwapV2Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​PunchSwapV2Factory_PairCreated_event

​PunchSwapV2Pair_Burn_event

​PunchSwapV2Pair_Mint_event

​PunchSwapV2Pair_Swap_event

​PunchSwapV2Pair_Sync_event

​PunchSwapV2Pair_Transfer_event

Tables

PunchSwapV2Factory_PairCreated_event

PunchSwapV2Pair_Burn_event

PunchSwapV2Pair_Mint_event

PunchSwapV2Pair_Swap_event

PunchSwapV2Pair_Sync_event

PunchSwapV2Pair_Transfer_event