swapxsonic_v1_sonic

Tables

AlgebraFactory_Pool_event

Pool creation events emitted by Algebra DEX (Decentralized Exchange) factory contracts, recording the deployment of new liquidity pools with their token pair addresses. Used for tracking pool deployments and identifying tradable pairs across Algebra-based DEX implementations.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x8121a3f8c4176e9765deea0b95fa2bdfd3016794	0x4586fa6c097f20155db32cc011c5fab0b8a6a566	false	0x29219dd400f2bf60e5a23d13be72b486d4038894	0xe185a87803c6161974666ddf39ed8c3c2e3c642e	2	20409976	2025-04-15T17:01:31.000Z	0x2440003c4460b393f9b685f7089e5dbc3905d1c0d9943b296e40608797757d27
0x8121a3f8c4176e9765deea0b95fa2bdfd3016794	0x518ad67c9c6a4a3b295aeae7adc9eb04a1ca6bf8	false	0x29219dd400f2bf60e5a23d13be72b486d4038894	0x336491f467eb001d5bfa30a829466b8d35c2a07a	5	20380716	2025-04-15T13:31:54.000Z	0x54de858f655bb0e04da663fb2ad6d45c9af36c2090d959047437dbd585d172a1
0x8121a3f8c4176e9765deea0b95fa2bdfd3016794	0x9255f31ef9b35d085ced6fe29f9e077eb1f513c6	false	0x5bff88ca1442c2496f7e475e9e7786383bc070c0	0xb1e25689d55734fd3fffc939c4c3eb52dff8a794	2	8359942	2025-02-17T23:39:51.000Z	0x31112404faa02db61bb2055776a53f18084feb209edd9c704fd940d11d65bdff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.swapxsonic_v1_sonic.AlgebraFactory_Pool_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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	13	304118804220	790682725689	7	24886194	-13	2025-05-07T01:11:19.000Z	0xf39227d00afe2b06fc4a70a5711c2d3d994808555ec5922c0fb35e8fc3983a73	1095148910812612
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	14	368106041985	750225309948	8	24907485	-12	2025-05-07T03:16:31.000Z	0xfcdd634fc090db64cca790099e6f952bd115c9e6c3a2392211bab2bbdffddeb9	1118672440537865
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	11	347881879	711012686	8	24949405	-12	2025-05-07T07:17:37.000Z	0x415c41d4fede452eaedc6103b545fae62b92b8c9db20a23d0a56b1b3b460d673	1059217432467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.swapxsonic_v1_sonic.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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`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	in_topTick	block_number	in_recipient	in_bottomTick	block_timestamp	transaction_hash
0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	26	0	20704203	-351060	19647605	0x73eb2dd6b08d47af3081486df9345bd334a1fe01	-352860	2025-04-11T19:32:23.000Z	0x9bc25a44b368099d3a328577c783174f4bcfe30aa8c1eb6b298128fcac59496a
0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	31	0	2925	-350940	19596468	0x1fab9d2d12c9aa65e23bb273c856d52ffba3afaf	-352800	2025-04-11T14:00:05.000Z	0x0e6de3151ae368f72bd2bc5afa6c667a74d03789439522ee318e3978274304db
0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	56	168754297924531092	8680	-350940	19618672	0x1fab9d2d12c9aa65e23bb273c856d52ffba3afaf	-352800	2025-04-11T16:19:57.000Z	0x13c757e7dedb1b30015081bf0269167e0302e7b70acbaa287d03671647a50911

Example Query

Query with partition filter

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

Pool_CommunityFee_event

Community fee rate update events from liquidity pools, recording the new fee percentages allocated to the protocol or community for each token in a trading pair. Used for tracking fee structure changes and protocol revenue distribution configurations.

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_communityFeeNew`	`STRING`	The updated community fee rate for the SwapXSonic pool, expressed in basis points. Values like ‘220’ represent 2.20% fee, while ‘0’ indicates no community fee is charged.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_communityFeeNew
0xce39d66872015a8d1b2070725e6bfc687a418bd0	false	8	2198915	2025-01-01T21:42:46.000Z	0x885222681e933102380b8a2e0df1cccb59bc1a1483dd01ead114fec26e0b16c9	0
0xa4b4325f3352758cdbd12d9fef021fb6f3fda7dd	false	8	22966969	2025-04-29T00:09:11.000Z	0x2fc77c24b70271cb4ebc30b477f1eaa08efbfe778979e82f67b99f0e01fc5e2d	220
0x300c140e4dc82be708c2a1ceb5a65cac8d472067	false	8	23036804	2025-04-29T08:35:39.000Z	0x9ae549c8e40470adf0df15f65b0e1124a20611a07c225600d74b8d142070a2f3	220

Example Query

Query with partition filter

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

Pool_Fee_event

Fee tier configuration events emitted by Automated Market Maker (AMM) pool contracts. Records updates to swap fee parameters measured in basis points for directional trades.

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_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.

Sample Data

in_fee	address	removed	log_index	block_number	block_timestamp	transaction_hash
2897	0x0db1717518c62fbc1422a49603c585c6043f5daf	false	4	24714461	2025-05-06T08:33:48.000Z	0x814edfb752c555119e84f1d473826bf39ddeac0d6c6416c26ad7450771d191db
3000	0x0db1717518c62fbc1422a49603c585c6043f5daf	false	7	24749599	2025-05-06T11:55:08.000Z	0x02594977436497000a66055710ff04639db467f7bf85f392cb2612a16ee3a231
2932	0x0db1717518c62fbc1422a49603c585c6043f5daf	false	13	24673815	2025-05-06T04:39:14.000Z	0xb180a54978ea54630678258d5becf3f8b87fc8d87316fcf22186c40231cc40de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.swapxsonic_v1_sonic.Pool_Fee_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_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0xd760791b29e7894fb827a94ca433254bb5afb653	false	10968281212147555	0x0d9def4428ccef14d93ef64564dec292bb01b826	11	109682812121475549696	30165306	0x0d9def4428ccef14d93ef64564dec292bb01b826	2025-05-28T11:05:22.000Z	0xc8af741769376969bb874d55e22a2812f341a3201d7ac607b5c5cbb2f0517267
0xd760791b29e7894fb827a94ca433254bb5afb653	false	12492872300635922	0x0d9def4428ccef14d93ef64564dec292bb01b826	22	124928723006359215554	30173337	0x0d9def4428ccef14d93ef64564dec292bb01b826	2025-05-28T11:53:19.000Z	0x2df170b1759b87da25035488fc7e02abbd0a0272e643c79c64559659da36d226
0xd760791b29e7894fb827a94ca433254bb5afb653	false	26778249569585112	0x0d9def4428ccef14d93ef64564dec292bb01b826	11	267782495695851117267	30181763	0x0d9def4428ccef14d93ef64564dec292bb01b826	2025-05-28T12:40:37.000Z	0xe36c3bd5d69113276e7b4f9d041a7397ea8f4f7156bd8edb0a7abf757ac26167

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.swapxsonic_v1_sonic.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_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`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_sender	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	0xd82fe82244ad01aad671576202f9b46b76fadfe2	33	1978879733393	1323530323413	12	17585529	-8	2025-04-02T01:31:24.000Z	0x9c02da8ef61e4653e63f6481ee080449e1a4ed54744d786ce520ecd5284bc64f	3303433868424021
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	0xd82fe82244ad01aad671576202f9b46b76fadfe2	37	96199273835	0	12	17585529	1	2025-04-02T01:31:24.000Z	0x9c02da8ef61e4653e63f6481ee080449e1a4ed54744d786ce520ecd5284bc64f	174973367910002
0x0d13400cc7c46d77a43957fe614ba58c827dfde6	false	0xd82fe82244ad01aad671576202f9b46b76fadfe2	0xd82fe82244ad01aad671576202f9b46b76fadfe2	55	1613651643049	1322204152369	11	17604357	-9	2025-04-02T03:37:13.000Z	0xd927f27818c44250c7525639c97b7c1bd670d37b74b6c760d1a2dbb2ea839e95	2936743950164436

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.swapxsonic_v1_sonic.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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`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_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	transaction_hash
0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81	-352476	false	1759336917487679176730	0x0000000000d44e72f506b4817cd08dc6757d0a8e	89	-2470502822133842243455	1219645	27696208	166700317302571920	0x0000000000d44e72f506b4817cd08dc6757d0a8e	2025-05-18T08:28:31.000Z	0x6f319e1caf9aded02a62dae0d32a8643da938a02940d3f5615d4cf1e5806f0b4
0xb96f401f789271bc14ade2229e6189084805c50c	26	false	79333738537699211915007444912	0x0000000000d44e72f506b4817cd08dc6757d0a8e	86	1216525	-1219648	27696208	810291051403	0x0000000000d44e72f506b4817cd08dc6757d0a8e	2025-05-18T08:28:31.000Z	0x6f319e1caf9aded02a62dae0d32a8643da938a02940d3f5615d4cf1e5806f0b4
0xbeca246a76942502f61bfe88f60bbc87dafefe80	14947	false	167279137357792615751603110081	0xa047e2abf8263fca7c368f43e2f960a06fd9949f	4	1000000000000000	-4413260749688529	27748159	4331543384405367913615496	0x002748db885d4ccfe3c7c92143f0805f4ebeec01	2025-05-18T13:26:31.000Z	0xea98426e7ac17ecf3581815f18a6384d5a6433551f8becdaa7f49804e83e1c00

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_Pool_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlgebraFactory_Pool_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_CommunityFee_event

​Pool_Fee_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

AlgebraFactory_Pool_event

Pool_Burn_event

Pool_Collect_event

Pool_CommunityFee_event

Pool_Fee_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event