kittypunch_v3_flowevm

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0xf331959366032a634c7cacf5852fe01ffdb84af0	0x520582280d25c06f6fe00a3ee1dc797f0437bfbb	false	0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed	0xc52e820d2d6207d18667a97e2c6ac22eb26e803c	11	41089782	60	2025-09-22T18:33:28.000Z	0x87ba591511982a9e33a6b4d766cb0eee67f895f5a8ff1a3e5a84424b13e3c55e
3000	0xf331959366032a634c7cacf5852fe01ffdb84af0	0xac23277ed660f113e187304ab373946ed3ec639b	false	0xcbf9a7753f9d2d0e8141ebb36d99f87acef98597	0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e	5	41090197	60	2025-09-22T18:39:05.000Z	0x76eb86ecf10485ba17a2b1309dec2c5e344930e8289ef4329f60feab29387be8
100	0xf331959366032a634c7cacf5852fe01ffdb84af0	0xdedec644f0f3dd9cf0b023e526a166fedbd984eb	false	0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed	0xc52e820d2d6207d18667a97e2c6ac22eb26e803c	0	41186232	1	2025-09-23T16:28:50.000Z	0x4f0539b74c37784b975142a54035e65d1e0ec2be77d64f0280f5b4ee0c223e44

Example Query

Query with partition filter

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

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	3250921184298	7	5768	511785716315598572	44693395	287400	289200	2025-10-26T13:49:47.000Z	0x4b7c8b47f0d0e6601e3a5277acedd6bd03d8d03d4796e32c22b352b82f235995
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	1148624965276	3	603384	0	44693395	289200	887220	2025-10-26T13:49:47.000Z	0x4b7c8b47f0d0e6601e3a5277acedd6bd03d8d03d4796e32c22b352b82f235995
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	0	1	0	0	44693395	289200	887220	2025-10-26T13:49:47.000Z	0x4b7c8b47f0d0e6601e3a5277acedd6bd03d8d03d4796e32c22b352b82f235995

Example Query

Query with partition filter

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

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`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_owner	log_index	in_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x7854498d4d1b2970fcb4e6960ddf782a68463a43	false	0xdfa7829eb75b66790b6e9758df48e518c69ee34a	2	41812316552067493824	374197478520783521697	24622612	0xe0f3329b8594fc226127300abd9bafa5b44b522e	-927	574	2025-04-22T03:38:29.000Z	0x02df91fe45b0e697aa0bde7e2b60929cb72928248ea9650d534b5b3f6eeb4d75
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0xdfa7829eb75b66790b6e9758df48e518c69ee34a	2	29834	331323457674161090	24622503	0xe0f3329b8594fc226127300abd9bafa5b44b522e	276300	288240	2025-04-22T03:37:02.000Z	0x9add5255a20b43ac10a47bb7742851c6a94a33f468c32125d56085ee01373e2e
0xdedec644f0f3dd9cf0b023e526a166fedbd984eb	false	0x233519c9b008828a5cfb156b60009f031efbf14c	15	0	33457459490	47445948	0x233519c9b008828a5cfb156b60009f031efbf14c	45605	45619	2025-11-21T01:45:56.000Z	0xfb4773653d5cbb2188d8dc33a50ae8b54705b50270c48351d31f337eb8339b48

Example Query

Query with partition filter

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

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_paid1	in_sender	log_index	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x716e37098c753f51bf04f00982886ad2304a07f7	false	378961400030710000	0xbf7bb89cb0a720b5a98d8d55ae27ac31d31c02a7	14	757922800061420000000	42222004	0x3679f93f2d4d686ef8afb77321d2990d408fd300	2025-10-03T09:32:54.000Z	0x4f1944a19de9e50769f01b45e44f5fa4b78dd046487bbd128c87a3c895b7ee8b
0x716e37098c753f51bf04f00982886ad2304a07f7	false	3331800000270000	0xbf7bb89cb0a720b5a98d8d55ae27ac31d31c02a7	16	6663600000540000000	42251872	0x83de3a5e2e004a43fd3beac496f60ea90a575a1c	2025-10-03T16:11:28.000Z	0xa224b04378a30809ccfb60c51fba80cee27d42641fa5bdcf0eadbaa3f5fd3c14
0x716e37098c753f51bf04f00982886ad2304a07f7	false	3331800000270000	0xbf7bb89cb0a720b5a98d8d55ae27ac31d31c02a7	16	6663600000540000000	42251729	0x83de3a5e2e004a43fd3beac496f60ea90a575a1c	2025-10-03T16:09:34.000Z	0x3270b0098602a5a9c137579cf6043430ccc98e1a84510a895683604aee8696bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kittypunch_v3_flowevm.Pool_Flash_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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	1105844547939	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	17	575611	353687303256151	44937989	289380	887220	2025-10-28T20:12:51.000Z	0x27415e36ebcb5402e5d5b739a52021e6e88b5a45aca9f3d64e39250419487978
0x2e31d489279a095ff392bf285d2a232e9c18b459	false	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	3722033118157	0x1ced12a677aac28d055a3304d6f70cd43cb5bea6	19	0	634887761337779003	44937989	287520	289380	2025-10-28T20:12:51.000Z	0x27415e36ebcb5402e5d5b739a52021e6e88b5a45aca9f3d64e39250419487978
0x7854498d4d1b2970fcb4e6960ddf782a68463a43	false	0xdfa7829eb75b66790b6e9758df48e518c69ee34a	48917010506467344984131066	0xdfa7829eb75b66790b6e9758df48e518c69ee34a	3	2320124165876845027498009	999999999999999999999999	23959854	0	1397	2025-04-16T00:16:11.000Z	0x1c763e38bdef005b0ac994d96edbbb113fdde82020794d2ea34cbe8efafac5c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kittypunch_v3_flowevm.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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x7854498d4d1b2970fcb4e6960ddf782a68463a43	553	false	0xa8aeac66ea2876f66a02c98e179b35c0d494e494	7	701081348080224956	-740881998043552538	29018216	91446131021788166815814465	0x07ed817a823c1acdd8851347af90e0af33705ab2	2025-06-01T21:24:46.000Z	81450098249092428304615030083	0x0601d8a2325c8cc030941116846d82fbb0e5c192da8247b4e566775df06b2799
0x7854498d4d1b2970fcb4e6960ddf782a68463a43	553	false	0xa8aeac66ea2876f66a02c98e179b35c0d494e494	5	701145790575496175	-740958484652563835	29012385	91446131021788166815814465	0x07ed817a823c1acdd8851347af90e0af33705ab2	2025-06-01T20:06:51.000Z	81450559152756925813724193752	0x1b6c9b9a649c0d45f302507933ca24ee94ef45dc0ed9ed80690588c201c20fcb
0x7854498d4d1b2970fcb4e6960ddf782a68463a43	553	false	0xa8aeac66ea2876f66a02c98e179b35c0d494e494	5	701166724615355769	-740983363956000075	29010511	91446131021788166815814465	0x07ed817a823c1acdd8851347af90e0af33705ab2	2025-06-01T19:41:52.000Z	81450710657905455349109742243	0x23c8be904923b02441cb6b70a136fe0b53cd88a7b780f261b57ca82bb9ee7192

Example Query

Query with partition filter

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

StableKittyFactoryNG_BasePoolAdded_event

No description available.

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_base_pool`	`STRING`	Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StableKittyFactoryNG_LiquidityGaugeDeployed_event

No description available.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StableKittyFactoryNG_MetaPoolDeployed_event

No description available.

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_coin`	`STRING`	Contract address of the token used in the metapool deployment. Hex-encoded, 0x-prefixed, 42-character string.
`in_base_pool`	`STRING`	Contract address of the base pool used in the metapool architecture. Hex-encoded, 0x-prefixed, 42-character string.
`in_A`	`STRING`	Amplification coefficient parameter used in Curve’s StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StableKittyFactoryNG_PlainPoolDeployed_event

StableSwap liquidity pool deployment events from KittyPunch’s Next Generation factory contract on Flow EVM, capturing pool creation with amplification coefficient (A), fee parameters, and constituent token addresses. Used for tracking new liquidity pool launches and analyzing pool configuration strategies across stablecoin 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_coins`	`ARRAY<STRING>`	Array of token contract addresses included in the liquidity pool. Hex-encoded, 0x-prefixed, 42-character strings representing ERC-20 token contracts.
`in_A`	`STRING`	Amplification coefficient parameter used in Curve’s StableSwap invariant algorithm. String-encoded integer value that controls the concentration of liquidity around the target price.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_deployer`	`STRING`	Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_A	in_fee	address	removed	in_coins	log_index	in_deployer	block_number	block_timestamp	transaction_hash
1000	1000000	0x4412140d52c1f5834469a061927811abb6026db7	false	[“0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed”,“0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52”]	1	0x97722d3322274b172b4c5883e5a26de0b1cb5353	16581209	2025-02-05T22:53:02.000Z	0xcc8038d2c88885f9db844fb9e8f750c0e82be660b67b0539b8a108699b514542
1000	1000000	0x4412140d52c1f5834469a061927811abb6026db7	false	[“0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed”,“0xf1815bd50389c46847f0bda824ec8da914045d14”]	1	0x97722d3322274b172b4c5883e5a26de0b1cb5353	16565202	2025-02-05T19:19:14.000Z	0xf0fd0e8f4ea6d60d5da633c931db0e76d767059594e38c61311973e0ac50f40e
1000	1000000	0x4412140d52c1f5834469a061927811abb6026db7	false	[“0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed”,“0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52”]	1	0x97722d3322274b172b4c5883e5a26de0b1cb5353	16565529	2025-02-05T19:23:36.000Z	0xba574afcadb729b21a7f70a1ef5374220c61458765ec169d22226964150d32f7

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

StableKittyFactoryNG_BasePoolAdded_event

StableKittyFactoryNG_LiquidityGaugeDeployed_event

StableKittyFactoryNG_MetaPoolDeployed_event

StableKittyFactoryNG_PlainPoolDeployed_event

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

​StableKittyFactoryNG_BasePoolAdded_event

​StableKittyFactoryNG_LiquidityGaugeDeployed_event

​StableKittyFactoryNG_MetaPoolDeployed_event

​StableKittyFactoryNG_PlainPoolDeployed_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

StableKittyFactoryNG_BasePoolAdded_event

StableKittyFactoryNG_LiquidityGaugeDeployed_event

StableKittyFactoryNG_MetaPoolDeployed_event

StableKittyFactoryNG_PlainPoolDeployed_event