kodiak_v3_berachain

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	0xd84cbf0b02636e7f53db9e5e45a616e05d710990	0x47134dd940b4ff64c3e4fa60f0a3eb7f177d0702	false	0xcaa70d2aa873ef057980844e18d9a9560bdffcc0	0xd2c41bf4033a83c0fc3a7f58a392bf37d6dcdb58	52	5223020	60	2025-05-19T13:36:00.000Z	0xdfc32c8f7eaa25afb3b53228dc476c7b2b6b235de9b447c6517e1e6b8815cf1b
3000	0xd84cbf0b02636e7f53db9e5e45a616e05d710990	0x25a142065a38bac7f15c511b75b8875d84d748ca	false	0x549943e04f40284185054145c6e4e9568c1d3241	0xeab9814bd2bf57f284368bcbe9eb5a8394032ca8	0	5218319	60	2025-05-19T11:04:23.000Z	0xa961f349347a38c69b3b23d1ea29c65d0b963c68e62e722c767571a63d45a4e6
3000	0xd84cbf0b02636e7f53db9e5e45a616e05d710990	0x31e83b9bfd787c660f79cbba2b6e8f0ca8173762	false	0x6969696969696969696969696969696969696969	0xeab9814bd2bf57f284368bcbe9eb5a8394032ca8	118	5217992	60	2025-05-19T10:53:52.000Z	0xf6f4a52a6caddc5e43603bb3f38e252de01cbd23076afceade9ec148f33a0b5a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v3_berachain.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
0x2a7856fff3069bd2d551f94ac035fde1f544b4ef	false	0xfe5e8c83ffe4d9627a75eaa7fee864768db989bd	2421128071923067012	29	110561677011759850	53018923908240043285	1035257	-887270	887270	2025-02-12T08:06:09.000Z	0xd0ebc320e5dc4f35f0151cac90ef968908378efc8499f127b50799085f798c0c
0x1127f801cb3ab7bdf8923272949aa7dba94b5805	false	0x4a254b11810b8ebb63c5468e438fc561cb1bb1da	32091155506477665548	55	13359610107317261118	77086251280407619482	1022500	-887220	887220	2025-02-12T00:55:26.000Z	0xbd7d05c4c6af60048b543c035a4476aaba221a76c18b9d1cc77b21960c80a346
0x1127f801cb3ab7bdf8923272949aa7dba94b5805	false	0x3eff586be3a907d8dec40178eb35215215f58af7	0	57	0	0	1046180	-887220	17040	2025-02-12T14:15:32.000Z	0x72b8a46dc231b9347d5faacd5e524c5e749999c4571693e996eda5e07c79995e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v3_berachain.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
0x5bb06b78a434ed297cd474ebc79c28a20c20e5cd	false	0xd9a747880393f7c33cef1aea36909b36d421f7e5	54	27042827994838493294	3300004910	3626778	0xd9a747880393f7c33cef1aea36909b36d421f7e5	-232500	-205380	2025-04-13T00:28:50.000Z	0xa43527d4168722b812ed6647c29093060f365ebe54da283c0d45a980f914a48b
0x5bb06b78a434ed297cd474ebc79c28a20c20e5cd	false	0xd9a747880393f7c33cef1aea36909b36d421f7e5	24	182696478496781601904	21407756607	3657761	0xd9a747880393f7c33cef1aea36909b36d421f7e5	-232500	-205380	2025-04-13T17:28:09.000Z	0xabb2cecd6ed58703603999a1035eec9f720fa04a42c35f85c0b946a1030e7576
0x5bb06b78a434ed297cd474ebc79c28a20c20e5cd	false	0xd9a747880393f7c33cef1aea36909b36d421f7e5	45	125914327569283953622	15449351980	3630132	0xd9a747880393f7c33cef1aea36909b36d421f7e5	-232500	-205380	2025-04-13T02:18:44.000Z	0xa6804703b3061317b7d6767fafa99ac113d4112cdbd79dd9543c68fc6a317c73

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v3_berachain.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
0x952e2d2fe68b3a5d029c9326e6a379e4c5a0ce0e	false	10000000000	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	117	20000000000000	1689123	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	2025-02-27T20:52:46.000Z	0xf3532a4a57214f80871265981674bc1c216a49ece570eaee2dc20e375dea949b
0x952e2d2fe68b3a5d029c9326e6a379e4c5a0ce0e	false	10000000000	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	58	20000000000000	1693179	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	2025-02-27T23:07:50.000Z	0xec7d80791fed9f5768a15499f1b826c131af9492b8551e5e08289fdf00833ed7
0x952e2d2fe68b3a5d029c9326e6a379e4c5a0ce0e	false	10000000000	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	153	20000000000000	1692808	0x7f74e5a74f1ce5eb9e7595479ed22606e2c0da0d	2025-02-27T22:55:22.000Z	0x518881149bb9febc76c8fe1050057babf4cce0536c7b33254f85bd8a859d9528

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v3_berachain.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_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x545bea6ea7f8fd8dcc5c9a6802a8ebf3dbfc1c6e	false	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	548776275621658	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	335	1192009725486075572883	970617	343740	345180	2025-02-10T19:49:33.000Z	0xbae3cf75fd823ee4756ea01337847b08c40f7c0c5ff8cf3c11a7d8c038ce5e5d
0x545bea6ea7f8fd8dcc5c9a6802a8ebf3dbfc1c6e	false	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	637515849792545	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	287	1384763020674289799616	956048	343740	345180	2025-02-10T11:58:16.000Z	0x0214f99c15a47c5952eecabad1a47d133ad20b71305ff4d3a2e0b1ab7c4bc466
0x545bea6ea7f8fd8dcc5c9a6802a8ebf3dbfc1c6e	false	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	548853371297673	0x0fe958d31c0aa613a0b08901fb26a7761c5b14f4	306	1192177186798973438058	970153	343740	345180	2025-02-10T19:34:33.000Z	0xcb91fd43ca1c5658215696af56dd46414cff5fdd6dd4caacb720c220a6c5bbb5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v3_berachain.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
0xcc7b4964dfca0c16b3b2cb5bada3248feec86d2c	-62900	false	0x00000000005d9015daec362431766f26ccc4ce96	65	2806868894156769120	-5251216720760130	1811243	13868036856932455313	0x00000000005d9015daec362431766f26ccc4ce96	2025-03-02T16:09:31.000Z	3412766545503504209002489215	0xe72d030237532dee0394db5b1808e22b7d83897e83246bf1cc6dc31b6294febb
0xcc7b4964dfca0c16b3b2cb5bada3248feec86d2c	-62880	false	0x00000000005d9015daec362431766f26ccc4ce96	37	2491851002435807306	-4666767565177023	1824222	13868036856932455313	0x00000000005d9015daec362431766f26ccc4ce96	2025-03-02T23:10:12.000Z	3416230237307136179787946653	0x5fc9620a4157075a0e767a69ace833374073058fe5e4bd3e7bd8cf008ab419df
0xcc7b4964dfca0c16b3b2cb5bada3248feec86d2c	-62498	false	0x00000000005d9015daec362431766f26ccc4ce96	151	1442144639307345182	-2797054777454794	1807808	13868036856932455313	0x00000000005d9015daec362431766f26ccc4ce96	2025-03-02T14:16:54.000Z	3482090337867247697787553605	0x62098a6b1d174ddb1f58727eb5b248fec87cd7ce271cdf8a841839d5248860e6

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event