kodiak_v2_berachain

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
0x5e705e184d233ff2a7cb1553793464a9d0c3028f	0x0488d196bd9fc82dd7d869e3269a98cbb26a624b	false	807	0x1b533cf64a82bb464e559f6dcbc7ba9fbd27839c	0x549943e04f40284185054145c6e4e9568c1d3241	203	3222723	2025-04-03T19:11:49.000Z	0xa41a48a4357845e5f49ccb7eeb7dd81cdb0581de11d207babf3410b33af9be7b
0x5e705e184d233ff2a7cb1553793464a9d0c3028f	0x01cbf8bf3da700a1196fdce3f4b5b441f1a013e5	false	806	0x6969696969696969696969696969696969696969	0xb7e448e5677d212b8c8da7d6312e8afc49800466	51	3211280	2025-04-03T12:48:19.000Z	0x16d02601043ce00e7881a49cdac01f60b9e220ecff7055c4972bdf5859c7287d
0x5e705e184d233ff2a7cb1553793464a9d0c3028f	0x9c64f6b329a0d75e19e340e7fb6d4a1b03bdb949	false	805	0x28e0e3b9817012b356119df9e217c25932d609c2	0x6969696969696969696969696969696969696969	98	3210843	2025-04-03T12:33:29.000Z	0x54266dd5eeea976d81cbe6fc050b0af55f3848e6d646e140762299ae851229e2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v2_berachain.Factory_PairCreated_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
0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	0x01cbf8bf3da700a1196fdce3f4b5b441f1a013e5	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	164	16286964418769295157	3018106942751526094943	3651254	2025-04-13T13:53:35.000Z	0x9952d13970a0e9c332ee1d6c46ce7510c6f31e5194e40a44afb22b4a1bf39a2a
0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	0x01cbf8bf3da700a1196fdce3f4b5b441f1a013e5	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	111	42810514668434127822	7925554269367529622139	3632426	2025-04-13T03:33:51.000Z	0x6b326deeb2f4f1118e4a9c2219b02c39a2426a6d9930e83e6bb2960832037abc
0x2346d15cecc52eeebbb2af464a414ae5629ba5f5	0x02037537799f6da47bfa8d8d573e2d1c092e8350	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	36	96323349731146399040	239983598272316084	3633453	2025-04-13T04:07:27.000Z	0x232728b19c223f0cc6c459d17957b88a124d2df10d6cae6b157666bab00e76c0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v2_berachain.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
0xac1d44f0284634eb04ffa56c76d47e839224b46f	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	11	26482200000000000000000	2483028052471334318	2396220	2025-03-16T01:36:01.000Z	0x6b6970ed8ad3e790dc9937a861d938b31f25f82925c2486d4c560694fd9d203f
0xcb42b9d09d8da230d0390728c6f236511fac403b	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	11	24843256631407657636	501743319393317476520346	2426609	2025-03-16T17:54:10.000Z	0x832ee04ca8b4e1e3e193bf0f295007004aa1503e01ee4c329b8e596a2b4fa0b5
0x22666d81a0b2aaa02deea7981c65dfc3c3839c61	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	34	331511364259602	639908002480652748	2408481	2025-03-16T08:11:20.000Z	0x7d9aa35c00d3576fb5bf6d4e07e9933d9918043787a0cae9b05a5fb684a53ed7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v2_berachain.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
0x12214205db6968ec235a98fbac183b5a57093b49	0x02037537799f6da47bfa8d8d573e2d1c092e8350	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	147	3014297	10000000000000000	40111338239665	2025-03-30T00:43:05.000Z	0xb4984ceeee567a5a3e31bee0d5ee7038fa9ac513b23adfc20725213be5375ff8
0x12214205db6968ec235a98fbac183b5a57093b49	0x02037537799f6da47bfa8d8d573e2d1c092e8350	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	70	3014367	1000000000000000000	4003415183701214	2025-03-30T00:45:22.000Z	0x1c44a57ac95344b9bc189e88d7551ebbc25f6c93c59c737660ae7f8ae462341d
0x12214205db6968ec235a98fbac183b5a57093b49	0x02037537799f6da47bfa8d8d573e2d1c092e8350	false	0xd91dd58387ccd9b66b390ae2d7c66dbd46bc6022	87	3013245	1000000000000000000	4019051551076489	2025-03-30T00:09:05.000Z	0xb4e403d326fbefd16fc4f7d8af02a3330b142fc52cfcf4b897434a808fa404b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v2_berachain.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
0x017e707458deb5184d638bc2c01978c63261cb0a	false	173	55483044031269816	4159971111549901	4626664	2025-05-06T00:02:46.000Z	0x87553bce0340a9edcae3a168b8f5ed79520ba3932c57b4725a6e7c86f2064e2d
0x017e707458deb5184d638bc2c01978c63261cb0a	false	158	55482751431592568	4159993116024797	4626830	2025-05-06T00:08:13.000Z	0xdb6b1069ae5194bde6de49fa9419610c16a60888c1a85d6ec5bf5712d72e1487
0x017e707458deb5184d638bc2c01978c63261cb0a	false	138	55420336277893372	4164692255562649	4626881	2025-05-06T00:09:53.000Z	0x8ba48721d5d3313e10d30909b0acf70ae295876c52285be585ead534a711a09f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kodiak_v2_berachain.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
0x7125dd987c6be96989dc43803559bdf578310d7f	0x22666d81a0b2aaa02deea7981c65dfc3c3839c61	0xa92e173259c12d6c17c8e91482a1f1b0a8c1fcf8	false	108516075972957386	37	2244934	2025-03-12T15:05:53.000Z	0xa44b23dcdbbf54541a422e2bfa73ae941070292a13bcc8b9555541c1ca7b7854
0xbc0f503e84994595d28bf120998c4dbac07477aa	0x22666d81a0b2aaa02deea7981c65dfc3c3839c61	0x0000000000000000000000000000000000000000	false	593351811533	28	2244934	2025-03-12T15:05:53.000Z	0xa44b23dcdbbf54541a422e2bfa73ae941070292a13bcc8b9555541c1ca7b7854
0xa92e173259c12d6c17c8e91482a1f1b0a8c1fcf8	0x22666d81a0b2aaa02deea7981c65dfc3c3839c61	0x0000000000000000000000000000000000000000	false	108516075972957386	29	2244934	2025-03-12T15:05:53.000Z	0xa44b23dcdbbf54541a422e2bfa73ae941070292a13bcc8b9555541c1ca7b7854

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event