ramses_v2_arbitrum

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	block_number	in_tickSpacing	block_timestamp	transaction_hash
3000	0xaa2cd7477c451e703f3b9ba5663334914763edf8	0xd6618a8df0cf9c64c4f7d4d5dbe38719fac21556	false	0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8	0x5979d7b546e38e414f7e9822514be443a4800529	179312396	60	2024-02-10T11:38:07.000Z	0x51606ab73cd6b219cd2cb5ad0b87a6e0153b0ad3c3da05629c08c19367bdf744
3000	0xaa2cd7477c451e703f3b9ba5663334914763edf8	0x16246519fdfbea08b683e0829afdaf4acbfff97f	false	0x2ac2b254bc18cd4999f64773a966e4f4869c34ee	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	179313391	60	2024-02-10T11:42:28.000Z	0xdd7ae0372853dd6b32b32346f0f91817670aa52c1e82875d55706ebf336aec79
3000	0xaa2cd7477c451e703f3b9ba5663334914763edf8	0xb0ebb9554cc2ab6bcaa7c4a2ff86e5342fbcd3a3	false	0x178412e79c25968a32e89b11f63b33f733770c2a	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	101245573	60	2023-06-15T00:26:47.000Z	0x78cdd4c20f3a4a5f0f51551b85ac7e6389b4de20f9542ec8a432f7a6a9aa55d6

Example Query

Query with partition filter

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

Factory_SetFeeProtocol_event

Protocol fee configuration changes for Ramses V2 DEX (decentralized exchange) factory contract on Arbitrum. Tracks adjustments to fee parameters (feeProtocol0 and feeProtocol1) that determine protocol revenue split from trading fees.

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_feeProtocol0Old`	`INT64`	Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol1Old`	`INT64`	Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol0New`	`INT64`	New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
`in_feeProtocol1New`	`INT64`	New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.

Sample Data

address	removed	block_number	block_timestamp	transaction_hash	in_feeProtocol0New	in_feeProtocol0Old	in_feeProtocol1New	in_feeProtocol1Old
0xaa2cd7477c451e703f3b9ba5663334914763edf8	false	91096151	2023-05-15T23:37:32.000Z	0x84af7a2ff02141a284a49daef9ddb44bdd460d421353e463e78334d9c7e71eb0	85	6	85	6
0xaa2cd7477c451e703f3b9ba5663334914763edf8	false	91060611	2023-05-15T20:46:05.000Z	0x58bac49eb6608080da26dcb44521536a478f796b4d10bc3925769f4a4bb6e2b5	102	0	102	0
0xaa2cd7477c451e703f3b9ba5663334914763edf8	false	96903306	2023-06-02T04:22:46.000Z	0x242fc5b91d355018293ea17ebd04c39283ffc0ea913802b7cab117285c7fe4ce	102	5	102	5

Example Query

Query with partition filter

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

FeeCollector_FeesCollected_event

Fee collection events from Ramses V2 decentralized exchange (DEX) on Arbitrum, splitting trading fees between treasury and fee distribution contracts for each liquidity pool. Used for analyzing protocol revenue allocation and fee distribution mechanics across different 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeDistAmount0`	`STRING`	Amount of token0 fees allocated to the fee distribution contract from the pool. Expressed in the token’s smallest unit (wei for 18-decimal tokens), may be zero if no fees were collected.
`in_feeDistAmount1`	`STRING`	Amount of token1 allocated to the fee distribution contract from collected pool fees. Stored in raw token units (wei-equivalent) and may be zero when no fees were collected for that token.
`in_treasuryAmount0`	`STRING`	Amount of token0 allocated to the protocol treasury from the collected fees. Values are in the token’s smallest unit (wei for 18-decimal tokens) and can be zero if no treasury fees were collected.
`in_treasuryAmount1`	`STRING`	Amount of token1 allocated to the protocol treasury from fees collected in this event. Denominated in the token’s smallest unit (wei for 18-decimal tokens), can be zero if no treasury allocation occurred.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeDistAmount0	in_feeDistAmount1	in_treasuryAmount0	in_treasuryAmount1
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0x1d0c1241786c6830bb47e6645d62ebfcb06e6a3c	false	171	109173249	2023-07-08T17:16:21.000Z	0xd9b6392899068f4731553f8a14cf2b597de3ba7f3f71c4a4c489b25e666ae816	0	0	0	0
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0x9ff74cfb4a4dd7945c859305ed69b88cec1b0c27	false	904	109173249	2023-07-08T17:16:21.000Z	0xd9b6392899068f4731553f8a14cf2b597de3ba7f3f71c4a4c489b25e666ae816	582133506225469918	634820	38808900415031327	42321
0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	0x07b6699a5163e076498ed7511b7d4778e3949a31	false	695	109173249	2023-07-08T17:16:21.000Z	0xd9b6392899068f4731553f8a14cf2b597de3ba7f3f71c4a4c489b25e666ae816	0	0	0	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ramses_v2_arbitrum.FeeCollector_FeesCollected_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
0x2d4bfb17db454cf582a74902c91fb09a3883a5cc	false	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	14	0	0	276590213	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	485	495	2024-11-20T22:50:21.000Z	0x544eac2b6b0565bdf631d58322d9dd6d81c4fc1bd6b1234cfbe3f9287196187b
0x2d4bfb17db454cf582a74902c91fb09a3883a5cc	false	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	22	0	134358774665280994	276590213	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	485	495	2024-11-20T22:50:21.000Z	0x544eac2b6b0565bdf631d58322d9dd6d81c4fc1bd6b1234cfbe3f9287196187b
0x2d4bfb17db454cf582a74902c91fb09a3883a5cc	false	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	19	119273752528548854	158752523291440558	276590213	0x001d49f92d58c11c42b3e6ae0fe1dc60929f6068	485	515	2024-11-20T22:50:21.000Z	0x544eac2b6b0565bdf631d58322d9dd6d81c4fc1bd6b1234cfbe3f9287196187b

Example Query

Query with partition filter

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

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.

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.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0xabc27aa4e47ce3b5591093de87ab7abeafb3afa0	false	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	132	901499271123019	174762991725401891	337785541	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	2025-05-17T23:50:15.000Z	0xfa28fe192ff6b8abf217019a5b8521596cc3ea46ee056e78e6617b2388439380
0x2760cc828b2e4d04f8ec261a5335426bb22d9291	false	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	67	150919	63805126373234621	337785541	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	2025-05-17T23:50:15.000Z	0xfa28fe192ff6b8abf217019a5b8521596cc3ea46ee056e78e6617b2388439380
0x6ce9bc2d8093d32adde4695a4530b96558388f7e	false	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	146	278424286501426329	1785535088823218679723	337785541	0xaa2ef8a3b34b414f8f7b47183971f18e4f367dc4	2025-05-17T23:50:15.000Z	0xfa28fe192ff6b8abf217019a5b8521596cc3ea46ee056e78e6617b2388439380

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ramses_v2_arbitrum.Pool_CollectProtocol_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
0x2ed095289b2116d7a3399e278d603a4e4015b19d	false	40694942	0x1bad969b80384d4addfb6853ce299cb712e33c12	46	904332034002	169484868	0x1bad969b80384d4addfb6853ce299cb712e33c12	2024-01-11T20:50:06.000Z	0x53dd41585754bf1e9f32eec797aef5cf59d4d3b33e7296e4b8211753085c2a43
0x2ed095289b2116d7a3399e278d603a4e4015b19d	false	15348727	0x1bad969b80384d4addfb6853ce299cb712e33c12	68	341082819191	169442664	0x1bad969b80384d4addfb6853ce299cb712e33c12	2024-01-11T17:50:13.000Z	0xc96c43747a5980a10b0c94166c74bdbfbb8088076b996c52283dcecddd74407d
0x2ed095289b2116d7a3399e278d603a4e4015b19d	false	24253955	0x1bad969b80384d4addfb6853ce299cb712e33c12	48	538976759964	169442664	0x1bad969b80384d4addfb6853ce299cb712e33c12	2024-01-11T17:50:13.000Z	0xc96c43747a5980a10b0c94166c74bdbfbb8088076b996c52283dcecddd74407d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ramses_v2_arbitrum.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
0x03c9567259411ffb9e4dcfd199db976b2c26eb97	false	0xaa277cb7914b7e5514946da92cb9de332ce610ef	72477932057827191937934	0xaa277cb7914b7e5514946da92cb9de332ce610ef	4	953715420651489523	2583870223212500848	209357792	-1002	-1001	2024-05-09T05:06:23.000Z	0xa254581a29bb998098f2b25e4fb15f0a59f39126a4722cf0ee9da565dee9fc0e
0x03c9567259411ffb9e4dcfd199db976b2c26eb97	false	0xaa277cb7914b7e5514946da92cb9de332ce610ef	58689657320355144240004	0xaa277cb7914b7e5514946da92cb9de332ce610ef	4	2039536599553093521	945811805642544046	209286238	-1002	-1001	2024-05-09T00:04:58.000Z	0x8d4e252f972e184f861587e6650ba9aa60f2d662cee98abfc24c0408b02247c5
0x03c9567259411ffb9e4dcfd199db976b2c26eb97	false	0xaa277cb7914b7e5514946da92cb9de332ce610ef	83731403692138617713470	0xaa277cb7914b7e5514946da92cb9de332ce610ef	4	2900221732658558241	1358007538687718028	209292270	-1002	-1001	2024-05-09T00:30:24.000Z	0x05f97bb17c625fdf45c904f393afbe6cea925bed9f9d8f2ade5f9732b206946b

Example Query

Query with partition filter

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

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.

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_feeProtocol0Old`	`INT64`	Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol1Old`	`INT64`	Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
`in_feeProtocol0New`	`INT64`	New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
`in_feeProtocol1New`	`INT64`	New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_feeProtocol0New	in_feeProtocol1New
0x623045339808eb191bf7da9aefbde7b23e2787d9	false	1	108247508	2023-07-05T22:14:15.000Z	0x94eb7061593b41f5fbc8bd521d85512ae791ea9f40f75045747d064927f2419f	6	6
0xf346defbde56108294a7b39bb46d2440f178a937	false	2	108141941	2023-07-05T14:26:21.000Z	0xc8e009d2190b45fcd1dca2a41cd0b405f141a47eb0908c4f5468095bcd28d471	6	6
0x3ca631bbef7daf9dbb4d3f57a2de9038e7442b39	false	2	108235291	2023-07-05T21:16:10.000Z	0xc610118515ba5b5fad517c7984c0fd17c08d3ce1f832e1f165dd40cd22238371	6	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ramses_v2_arbitrum.Pool_SetFeeProtocol_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
0x57bda5d6c054e07d26d70023eef4bfc1ffafbb21	-202230	false	0x000000002804d90a2fb3f9da837800207c5d8549	10	299994875691007	-495240	126898700	2130181734461869	0x000000002804d90a2fb3f9da837800207c5d8549	2023-09-01T03:27:59.000Z	3219223477834564921698478	0x21021ceb481b36a117f0cc6fef93217b542bc15417fc4b6345e53dc4e04256a4
0x57bda5d6c054e07d26d70023eef4bfc1ffafbb21	-202364	false	0x000000002804d90a2fb3f9da837800207c5d8549	81	-22372911069372830	36439039	127055833	3777939465897172	0x000000002804d90a2fb3f9da837800207c5d8549	2023-09-01T14:49:17.000Z	3197658620525877793374954	0xbcde4f03517b532080af3cec60880a1a9b56d98013e5bf0676c1c78e0d402d90
0x1251ef3b87157b86f189bdea80b54673b0b59698	-202385	false	0x000000002804d90a2fb3f9da837800207c5d8549	80	-555195980456939784	902119423	127109990	23686891837338536	0x000000002804d90a2fb3f9da837800207c5d8549	2023-09-01T18:47:59.000Z	3194368067854174766587247	0xcac8754ec030897ba41d96435429b4c0bf36a758b08503256a26d6301dfa0cfe

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Factory_SetFeeProtocol_event

FeeCollector_FeesCollected_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

​Tables

​Factory_PoolCreated_event

​Factory_SetFeeProtocol_event

​FeeCollector_FeesCollected_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Factory_SetFeeProtocol_event

FeeCollector_FeesCollected_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event