sushiswap_v3_base

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	0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x2109b1c7e49ac733c1ba4d8eb8bd1fad853b52a5	false	0x4200000000000000000000000000000000000006	0xee33778a65d2ed9c81a3f5812723cf77a002095d	7	10527222	60	2024-02-13T17:03:11.000Z	0x81aa9f57b4cf4b9c4bb53988fe23dd0c3dc2cabd1e1ce180d4791fe0bb00cdbe
3000	0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x37600a74b7b259e74abaa24ed57f5665ff634ebf	false	0x2de4b86fa29dc508eeab7913d1a2439ab17d5eca	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	19	10501701	60	2024-02-13T02:52:29.000Z	0xff5c073ada5693240ecf34a7f056f3ec14863034e9668ff8f260b75b2bbc912d
10000	0xc35dadb65012ec5796536bd9864ed8773abc74c4	0x256f72260b7caa8dbf94126de8508d6ec850be9b	false	0x0c6cba341fb104442aa1a2492e1faf9e5a6bc99a	0x4200000000000000000000000000000000000006	16	2262411	200	2023-08-06T09:29:29.000Z	0xa2038ccb72dae27c9caf97fee5e8953a464df6fc7668cadb44fc897d6a4615ee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x5f0a153a64fd734c111b770da11de2c385ca8042	false	0x027be46864c635d4142cb67d628169a760fbc8f2	258076660458689916043	4	2272882571161269	2130440699624600001525959	4029251	188600	202800	2023-09-16T07:04:09.000Z	0x1303d015eb65f59c71d0130b8d67423b090352e633b12d384e0f5cc1bb68421e
0x019eff8e9b225d8cbc6127748f5f47ea3e2f28e5	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	49991429446116467114	4	24995681930833466600372	0	4029262	-276330	-276320	2023-09-16T07:04:31.000Z	0xe8f3a475bd565c2f7046ef982f0d353c8d522530454853860d41a59a7e58dad3
0x22ca6d83ab887a535ae1c6011cc36ea9d1255c31	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	0	12	0	0	4050923	-204470	-199820	2023-09-16T19:06:33.000Z	0xca87e386df79b6865978c26802fa2c8996554529ab11cbdaaa2dda6ea9169515

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x019eff8e9b225d8cbc6127748f5f47ea3e2f28e5	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	20	12537992342723136834	19861305	8618279	0xbddbd3ed479157180c1ea13b27b22b97f84b8530	-276350	-276310	2023-12-31T12:31:45.000Z	0x46da64d072f94b0ad745f39c15faa6a3babb1ee7f76259a0dc7647dc9d8d2ab4
0x22ca6d83ab887a535ae1c6011cc36ea9d1255c31	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	6	483593255184776	1117635	8626252	0x80c7dd17b01855a6d2347444a0fcc36136a314de	-205830	-191970	2023-12-31T16:57:31.000Z	0x2d7012bdf125015b3298047d135cf7d649fae19b0cbee2c7b90d6f721684e6ee
0x22ca6d83ab887a535ae1c6011cc36ea9d1255c31	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	7	152431375	0	8626243	0x3d042325ffbcc26df1b98fcadb2583484fa829c1	-205830	-191970	2023-12-31T16:57:13.000Z	0x3aad8dd507064391141eff4d89b9af4accf0bb0b835de6d963adcc1b12a1049c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x13bb5f5803074965b0686a42e5ad6f9bf8dd2bd8	false	0xcd03e2e276f6eedd424d41314437531f665187b9	223	679237161370070	330569043319496718127	21099592	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-10-15T10:35:31.000Z	0x06f91c71fc98c4b29a2227438d6a43bc884e0f419ef2ae56e10610a42a3878ea
0x27d8d938d9cfb97a85ca70defa4d44762a2e1884	false	0xcd03e2e276f6eedd424d41314437531f665187b9	235	1539547	1371456	21099592	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-10-15T10:35:31.000Z	0x06f91c71fc98c4b29a2227438d6a43bc884e0f419ef2ae56e10610a42a3878ea
0x1b9bfddf096188fe66805696197c008998d556c9	false	0xcd03e2e276f6eedd424d41314437531f665187b9	226	19660985243905876163	950866333441736	21099592	0x363ee06e3ee424060a726cb7f60153c9ee44cdc1	2024-10-15T10:35:31.000Z	0x06f91c71fc98c4b29a2227438d6a43bc884e0f419ef2ae56e10610a42a3878ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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_paid0	in_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x7aa3bc844710220272d9e14cb4b4bb067953d8ac	false	4412605915628664	0	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	32	8825211831257326513	0	3862798	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	2023-09-12T10:35:43.000Z	0x824b4bb58abef383c3e8392b36562d0bc3f34f769fc765188956f4ec988f96d2
0x7aa3bc844710220272d9e14cb4b4bb067953d8ac	false	3405263003197764	0	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	154	6810526006395527985	0	4704680	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	2023-10-01T22:18:27.000Z	0xea9b0eb4dc9f6762c0fcf83ea79884d50ce9ce9053d64a03500e5ae50e20b2fb
0x83c52776efe5f60efec721e5b3750993c514f817	false	0	23830184853597025	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	67	0	47660369707194049227	6246126	0x24656fde014d1e8aa5f1490197454d5b34d92c2b	2023-11-06T14:39:59.000Z	0x095058ceb16db9400c8119d93eccc9cbcd4abf014b28cc59456565f44cce2b29

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x019eff8e9b225d8cbc6127748f5f47ea3e2f28e5	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	27553804097215058	0x80c7dd17b01855a6d2347444a0fcc36136a314de	16	14336013139286133953	13209311	8091455	-276330	-276310	2023-12-19T07:50:57.000Z	0x86ea3f5754d8206b0a6b0a5dee3f01a90c4e3b59d26e11b463fcec5e102f03fc
0x0a7dc3d5746d97b659d2bf02b2b4fdf6dcef8822	false	0x80c7dd17b01855a6d2347444a0fcc36136a314de	2939197298	0x80c7dd17b01855a6d2347444a0fcc36136a314de	7	150000	57592538403024	8109682	-887270	887270	2023-12-19T17:58:31.000Z	0xa65f3fe5559136d2a68367424bfd69b97aea22bfa7638d4a100ab5e3ad6baf79
0x22ca6d83ab887a535ae1c6011cc36ea9d1255c31	false	0x11c4011772594c5f124a027da35329559447853d	154011206274545043	0x11c4011772594c5f124a027da35329559447853d	14	122378203444388872521	0	8109627	-199610	-198860	2023-12-19T17:56:41.000Z	0x9e235cc98bf151ed51ee7d464b34468af228fad66604171cebcd11f316858103

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x77e07f8047ca16b17bf3d938587425f96dbf65e9	false	181	27350864	2025-03-09T03:31:15.000Z	0x4e8bf1f29ddfb1db85abb326b9f948188848b5e2fb1da10fea557764cb2f9af1	4	4
0x4c25944edbefd1fb75ad9b1d78489a92a5196b0c	false	180	27350864	2025-03-09T03:31:15.000Z	0x4e8bf1f29ddfb1db85abb326b9f948188848b5e2fb1da10fea557764cb2f9af1	4	4
0x7ca304deef9ac7eccfaf7bbd33f37b0a5d3136bd	false	182	27350864	2025-03-09T03:31:15.000Z	0x4e8bf1f29ddfb1db85abb326b9f948188848b5e2fb1da10fea557764cb2f9af1	4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sushiswap_v3_base.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
0x0a7dc3d5746d97b659d2bf02b2b4fdf6dcef8822	196630	false	0x83ec81ae54dd8dca17c3dd4703141599090751d1	13	-24243	8371571312722	7366275	172554654363	0x0ed2553c0c8c8f0bdbdda2b13f35a5b618d2b281	2023-12-02T12:58:17.000Z	1473804870213739677184649556170382	0x686bbfdbb62d86e339b973753f5ee24a4249ea008d5596a2df03c4f9acec10a4
0xabeb18ffd5702e5855f0d7bc9b1db04ac851a16f	196941	false	0x83ec81ae54dd8dca17c3dd4703141599090751d1	19	-8481470	3000000000000000	7385180	12685376023211	0x9c3d907eb3f403df38522500c27d236e34897664	2023-12-02T23:28:27.000Z	1496897016136066918304849867612652	0x55c96d7f6a948717c1d1e766f40c39c4cbeb2fc20fd52e3209978e513f53e554
0xabeb18ffd5702e5855f0d7bc9b1db04ac851a16f	196539	false	0x83ec81ae54dd8dca17c3dd4703141599090751d1	5	-1522549	522715701633870	7342969	15212011118197	0x77bce35d8b97c089313dfc0899551a73727ce9c9	2023-12-02T00:01:25.000Z	1467155914866037882928620065991599	0x286a634615a880cda0dd4145be1a28a48174a9a30a84cbe3676047f367a9b323

Example Query

Query with partition filter

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

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CollectProtocol_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_SetFeeProtocol_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_CollectProtocol_event

Pool_Flash_event

Pool_Mint_event

Pool_SetFeeProtocol_event

Pool_Swap_event