katana_v1_ronin

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
0xb255d6a720bb7c39fee173ce22113397119cb930	0x363475ce45aef7ce55850d51872639464f993dd4	false	8	0x1b918543b518e34902e1e8dd76052bee43c762ff	0xe514d9deb7966c8be0ca922de8a064264ea6bcd4	13	28850996	2023-10-27T04:21:26.000Z	0xb5796f2de1e57374a236b7702862463ff50cf08bea113cabafedca3e21189c59
0xb255d6a720bb7c39fee173ce22113397119cb930	0x306a28279d04a47468ed83d55088d0dcd1369294	false	2	0xa8754b9fa15fc18bb59458815510e40a12cd2014	0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5	46	7860922	2021-10-25T09:43:36.000Z	0x8489e5fe75bf1abee9fb2c36b083a6209a9b021583b9b1202b497075160efd8d
0xb255d6a720bb7c39fee173ce22113397119cb930	0xc6344bc1604fcab1a5aad712d766796e2b7a70b9	false	1	0x97a9107c1793bc407d6f527b77e7fff4d812bece	0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5	25	7860914	2021-10-25T09:43:12.000Z	0x8ce53adfedb66360bb3c0e17fe0d3211c2add586450398bc52740bc7bad03331

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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 of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount0`	`STRING`	Amount of the first token in the liquidity pair removed from the pool during this burn event. Value stored as a string representing the token quantity in its smallest unit (wei-equivalent).
`in__amount1`	`STRING`	Token amount of the second asset in the liquidity pair being burned from the pool. Represented in the token’s smallest unit (wei-equivalent) as a string to preserve precision for large values.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in__to	address	removed	log_index	in__sender	in__amount0	in__amount1	block_number	block_timestamp	transaction_hash
0x7d0556d55ca1a92708681e2e231733ebd922597d	0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	166830433072463865	389870042143814156383	25539277	2023-07-04T04:15:56.000Z	0x1c33b69cc99ef610087363522d56c01e7a02e86f96d80244fff2cf5bb3b5f888
0x7d0556d55ca1a92708681e2e231733ebd922597d	0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	164314124752041277	389306098542998623207	25551619	2023-07-04T14:33:04.000Z	0x1e7f42d80f16f52ae9d4d922fbb969bafa27dd7de06528b52ecb43db518289fe
0x7d0556d55ca1a92708681e2e231733ebd922597d	0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	22931462226413896	54328932030792434134	25551334	2023-07-04T14:18:49.000Z	0x1cdce89392a0f17074476c11f7eca8541284d5bcbd7908c945938a07dfbc357c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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 of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount0`	`STRING`	Amount of token0 added to the liquidity pool in this mint event, denominated in the token’s smallest unit (wei-equivalent). Values are stored as strings to preserve precision for large token amounts.
`in__amount1`	`STRING`	Amount of the second token (token1) added to the liquidity pool in this mint event. Denominated in the token’s smallest unit (wei equivalent).

Sample Data

address	removed	log_index	in__sender	in__amount0	in__amount1	block_number	block_timestamp	transaction_hash
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	363394830956979	1929999999999997222	19256717	2022-11-26T22:36:28.000Z	0xa1d60b4e472c31e277ac466cd1faef045890e9ca9a2559daf79208ba1a0e8e98
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	205712247652492	1087666301181934834	19232012	2022-11-26T01:56:35.000Z	0x0ec9bdd94858d23db2f9a981f9dee80d4babacd3fbb562acf960ef036b51fb61
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	5	0x7d0556d55ca1a92708681e2e231733ebd922597d	409465457055278	2166289761635888830	19234379	2022-11-26T03:55:17.000Z	0x8aa82dc529983720c29a45e1312b6a44f2f3d6e61f35bdf40ee8dacc87683749

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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 of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount0In`	`STRING`	Amount of token0 flowing into the liquidity pair during the swap transaction. String-formatted to preserve precision for high-decimal tokens; zero indicates token0 was received as output rather than provided as input.
`in__amount1In`	`STRING`	Amount of token1 deposited into the liquidity pair during the swap transaction. Non-zero values indicate token1 was part of the input, while zero means token0 was swapped for token1.
`in__amount0Out`	`STRING`	Amount of token0 sent out of the liquidity pool to the recipient during this swap. Zero when token0 is being traded in (amount0In is non-zero).
`in__amount1Out`	`STRING`	Amount of token1 sent out of the liquidity pair in this swap transaction. Stored as a string to preserve precision for large token amounts with varying decimal places.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in__to	address	removed	log_index	in__sender	block_number	in__amount0In	in__amount1Out	block_timestamp	transaction_hash
0x7d0556d55ca1a92708681e2e231733ebd922597d	0x8f1c5eda143fa3d1bea8b4e92f33562014d30e0d	false	3	0x7d0556d55ca1a92708681e2e231733ebd922597d	20866947	1	5191874354505243	2023-01-22T04:01:49.000Z	0x3595917317054f6655a1ba5fd6efadc38893b346b151948cb33012645aa3629e
0xc6344bc1604fcab1a5aad712d766796e2b7a70b9	0x306a28279d04a47468ed83d55088d0dcd1369294	false	3	0x7d0556d55ca1a92708681e2e231733ebd922597d	20869876	9	15126969282870	2023-01-22T06:29:37.000Z	0x1c86914f478289009be21c55b3dccbd019234cc46dca5f876495a2c40de39739
0x1ae48c6f0439716812b1a7022b384eaf72e25316	0x306a28279d04a47468ed83d55088d0dcd1369294	false	3	0x7d0556d55ca1a92708681e2e231733ebd922597d	20884376	12	21123390872169	2023-01-22T18:38:37.000Z	0x1eb28cd43f3fb21fb71323541c74adc02cccf99e293dc519f5d24f4bc85f51d9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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`	Updated reserve balance of the first token in the Katana DEX liquidity pair after a sync event. Value is represented in the token’s smallest unit (wei-equivalent) as an integer string.
`in__reserve1`	`STRING`	Updated reserve balance of token1 in the liquidity pool pair contract, represented in the smallest denomination (wei for EVM tokens). Emitted by Katana DEX (Ronin chain) whenever pool reserves are synchronized after swaps or liquidity changes.

Sample Data

address	removed	log_index	block_number	in__reserve0	in__reserve1	block_timestamp	transaction_hash
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	3	25070414	10135751474909549930310	20608166207392311177933426	2023-06-17T21:32:42.000Z	0x0da157907bb0382da2d59110b012af11efb05880b2d6647c8e72841821d90fc6
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	3	25068686	10134734511532380790834	20608086644702642278546066	2023-06-17T20:06:18.000Z	0x1a788bcfd78e4d22118ff3a6a5acac6c84e57d46453df1bb4141186860761d76
0x2ecb08f87f075b5769fe543d0e52e40140575ea7	false	3	25049593	10039053444251747493861	20735145743993194170414210	2023-06-17T04:11:39.000Z	0x99d71cb5582d29230fc22c0c89ad70023a4f0100c0466af3a0d3a5a633e6a445

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

in__to	address	removed	in__from	in__value	block_number	block_timestamp	transaction_hash
0xe432d61a90604aef42c65d2c7f6565006dd29fe6	0x306a28279d04a47468ed83d55088d0dcd1369294	false	0x3c27c7e21fbee4bc6c61d610d0263189fb0f3520	14059833	25056521	2023-06-17T09:58:03.000Z	0x92c480c77edd74ef049218a59aa0c84de46add4d762ca36dcb859dc4ee596ca3
0xe432d61a90604aef42c65d2c7f6565006dd29fe6	0x306a28279d04a47468ed83d55088d0dcd1369294	false	0xcca8fb1ccaeca624fce33081177131dbcce14a15	21810771	25056505	2023-06-17T09:57:15.000Z	0x74d7fbf3e32323bef656a7276c0052b7f1d47bb0378e3d600770cece37ec6458
0xd3c7b90a064f64e6987b3a0e95d0f71f10b12d8e	0x306a28279d04a47468ed83d55088d0dcd1369294	false	0x953e1b5200f961c49e68c2d4e23ac02326c3e8db	22850576	25055320	2023-06-17T08:58:00.000Z	0x7b3fba8cb38e9c4639f5ef9cad099db19dd3366336879119645973f484d60dae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.katana_v1_ronin.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