ekubo_v1_starknet

Tables

Core_FeesAccumulated_event

Trading fee accumulation events from Ekubo decentralized exchange (DEX) on Starknet, showing fees collected per pool in token0 and token1 amounts. Used for analyzing protocol revenue, liquidity provider earnings, and trading volume across token 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`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	log_index	signature	event_name	in_amount0	in_amount1	in_pool_key	block_number	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	5	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	1498690	0	{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“17014118346046923173168730371588410570”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	663169	2024-07-28T20:05:28.000Z	0x3a6fe4c2e4c7a32700051ef4d4a997548c6b41b4681b1eb90a1877163b00d0
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	9	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	0	423141	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	634011	2024-04-19T02:48:41.000Z	0x35df57b8e0c13c90d696097338ce3fa92bdd3cc22234a9523f3cdbfdebe3a5d
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	24	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	24602791356890438	0	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	972049	2024-12-10T19:48:21.000Z	0x604193c773dd481c58786eca88e99ecc9dc710d5a08f46a2bba77f32e919098

Example Query

Query with partition filter

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

Core_LoadedBalance_event

Balance deposit events from Ekubo decentralized exchange (DEX) protocol on Starknet, tracking when users load tokens into their account positions. Used for analyzing liquidity provider deposits and capital flows by owner address and token.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_key	address	removed	in_amount	log_index	signature	event_name	block_number	block_timestamp	transaction_hash
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	32640068690840400229	2	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	958665	2024-12-06T00:01:25.000Z	0x1cfb5cf0307e50db024eca012c734dbe87cd3d5398bd08e3b70d6b0ead9519c
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	33349635401510843712	2	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	958671	2024-12-06T00:04:33.000Z	0x11748c911a247d1db940c577b7ebade109d4e91d04a871c4f2bb405f8d599f
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	33172243723843232841	3	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	958677	2024-12-06T00:07:40.000Z	0x1c9fe9e5fe783687ca4e46333c48317d628cb9bb3c9b382ba53310b3d23c54b

Example Query

Query with partition filter

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

Core_PoolInitialized_event

Liquidity pool creation events from Ekubo decentralized exchange (DEX) on Starknet, recording initial pool parameters including token pairs, starting price (sqrt_ratio), and initial tick position. Used for tracking new trading pair launches and analyzing DEX pool deployment patterns.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_initial_tick`	`STRING`	Initial tick index at pool creation, stored as a JSON object with magnitude and sign indicating the price position. Determines the starting price point for liquidity provision in the Ekubo AMM pool on Starknet.
`in_sqrt_ratio`	`STRING`	Square root of the price ratio between token0 and token1 at pool initialization, represented as a 128-bit fixed-point integer. This value determines the starting price for the liquidity pool in Ekubo’s automated market maker.

Sample Data

address	removed	log_index	signature	event_name	in_pool_key	block_number	in_sqrt_ratio	block_timestamp	in_initial_tick	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	5	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“0”,“tick_spacing”:“1043”,“extension”:“0x0”}	1076664	20076829960165790397025888085164770	2025-01-18T00:09:27.000Z	{“mag”:“19475939”,“sign”:true}	0x1cd4ad6cc0f5d7af9e69c6182475e02adee75e0e8a557dca6a5dd381a8fc38e
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	5	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“0”,“tick_spacing”:“1077”,“extension”:“0x0”}	1076664	229621528725893558422645740163482	2025-01-18T00:09:27.000Z	{“mag”:“28417722”,“sign”:true}	0x536d00ef5729e366b84d80859353eef4c3c82e3c5a4d847af764bb2b9a16051
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	8	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“0x25fd39a75116b5bf15364a54d2bdc6a8a834f380d8dad4bea208b49a303b16f”,“token1”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“fee”:“1020847100762815390390123822295304634”,“tick_spacing”:“5982”,“extension”:“0x0”}	1078977	373917972919990246485460241693637882	2025-01-18T20:29:12.000Z	{“mag”:“13626996”,“sign”:true}	0x2ea1b9fc2d9e7fb9c838c28b0284e3920e4608144bc3a3e1abacb00c35ce433

Example Query

Query with partition filter

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

Core_PositionFeesCollected_event

Fee collection events from Ekubo decentralized exchange (DEX) liquidity positions on Starknet, recording token0 and token1 fee amounts earned by liquidity providers when withdrawing from concentrated liquidity 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_position_key`	`STRING`	Unique identifier for a liquidity position encoded as a JSON object containing the owner address, salt value, and price bounds with magnitude and sign indicators.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	signature	event_name	in_pool_key	block_number	block_timestamp	in_position_key	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“1870766281127412140”,“sign”:true},“amount1”:{“mag”:“106233801824214”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“5982”,“extension”:“0x0”}	339351	2023-10-20T17:17:51.000Z	{“salt”:“8766”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9804498”,“sign”:true},“upper”:{“mag”:“9565218”,“sign”:true}}}	0x109231905e4980f0258d0ecea789c002db44e11d76b460d66be752ed8bb5fae
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“392771133853002965”,“sign”:true},“amount1”:{“mag”:“20409041669310”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}	339579	2023-10-20T23:28:39.000Z	{“salt”:“142895”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9787000”,“sign”:true},“upper”:{“mag”:“9747000”,“sign”:true}}}	0x36f158e097d40edc546597c243f05c16afcc31b646bf3deaf64270d53c7949
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“13216386664575791”,“sign”:true},“amount1”:{“mag”:“156290899340”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}	339579	2023-10-20T23:28:39.000Z	{“salt”:“175665”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9787000”,“sign”:true},“upper”:{“mag”:“9747000”,“sign”:true}}}	0x404a7bc0f2b693155a05337f32de738c592aaf677bd180735bfcc3fb206b031

Example Query

Query with partition filter

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

Core_PositionUpdated_event

Liquidity position modification events from Ekubo DEX (decentralized exchange) on Starknet, recording adds and removals with tick bounds, liquidity deltas, and token amounts. Used for analyzing liquidity provider behavior and concentrated liquidity range strategies.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_locker`	`STRING`	Address of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	in_locker	in_params	log_index	signature	event_name	in_pool_key	block_number	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:false},“amount1”:{“mag”:“0”,“sign”:false}}	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	{“salt”:“0”,“bounds”:{“lower”:{“mag”:“88368108”,“sign”:true},“upper”:{“mag”:“88368108”,“sign”:false}},“liquidity_delta”:{“mag”:“0”,“sign”:false}}	7	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	637806	2024-05-04T02:31:39.000Z	0x2dd7138422289b1d5cfea017674ba941127c3ac9a5c094fc2b1f9bc0ed1b644
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“398627415”,“sign”:false},“amount1”:{“mag”:“399156429”,“sign”:false}}	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	{“salt”:“587390”,“bounds”:{“lower”:{“mag”:“88368108”,“sign”:true},“upper”:{“mag”:“88368108”,“sign”:false}},“liquidity_delta”:{“mag”:“398891834”,“sign”:false}}	8	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	637806	2024-05-04T02:31:39.000Z	0x2dd7138422289b1d5cfea017674ba941127c3ac9a5c094fc2b1f9bc0ed1b644
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:false},“amount1”:{“mag”:“0”,“sign”:false}}	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	{“salt”:“0”,“bounds”:{“lower”:{“mag”:“88368108”,“sign”:true},“upper”:{“mag”:“88368108”,“sign”:false}},“liquidity_delta”:{“mag”:“0”,“sign”:false}}	7	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	637817	2024-05-04T03:39:09.000Z	0x7861816633fff18cb27263ce14f290792a0fa4c416042f082521431f82c215c

Example Query

Query with partition filter

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

Core_ProtocolFeesPaid_event

Protocol fee collection events from Ekubo decentralized exchange (DEX) on Starknet. Records fee amounts paid in token pairs for each liquidity position, used for analyzing protocol revenue and fee accrual rates.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_position_key`	`STRING`	Unique identifier for a liquidity position encoded as a JSON object containing the owner address, salt value, and price bounds with magnitude and sign indicators.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	log_index	signature	event_name	in_pool_key	block_number	block_timestamp	in_position_key	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:true},“amount1”:{“mag”:“10”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}	630732	2024-04-08T00:04:50.000Z	{“salt”:“384442”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“19827000”,“sign”:true},“upper”:{“mag”:“19787000”,“sign”:true}}}	0x705a3d3bbc8bb4024c291d3d751ccbd91047f6759227024d5a1201b4fc7b7cd
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“499228744590939448”,“sign”:true},“amount1”:{“mag”:“147004”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}	630733	2024-04-08T00:10:56.000Z	{“salt”:“555180”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“26990000”,“sign”:true},“upper”:{“mag”:“26693000”,“sign”:true}}}	0x523675fced66e80ab36917652c30f88da452313a9b20f897a6505bb5ac68a2e
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:true},“amount1”:{“mag”:“43311”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}	630734	2024-04-08T00:17:15.000Z	{“salt”:“430627”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“19698000”,“sign”:true},“upper”:{“mag”:“19500000”,“sign”:true}}}	0x153e47192ddbb70d76c3d3d9e1e4d8758f269e4c7214e50c40244dee9fa87

Example Query

Query with partition filter

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

Core_ProtocolFeesWithdrawn_event

Protocol fee withdrawal events from Ekubo decentralized exchange (DEX) on Starknet. Tracks token amounts and recipients for analyzing protocol revenue collection and fee distribution patterns.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	signature	event_name	block_number	in_recipient	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d	671712135853748849046	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	2494727	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-09-28T00:14:51.000Z	0x2bb09cf1e0f86de8a3f010bc7ede20bb6b92468279a763b4ac1665e57d7e528
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7	11867592894002606	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	2494715	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-09-28T00:14:12.000Z	0x7b820fb85904d615df568a2e7fec7a1dfbb95b15d152fd9c966be799823aaa6
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d	1975636758999406298	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	1690363	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-08-07T06:55:04.000Z	0x586bf557edb563d5fb75b0fa245b472808ca6258b81751633d906d84f7fd3fd

Example Query

Query with partition filter

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

Core_SavedBalance_event

Token balance snapshots from Ekubo decentralized exchange (DEX) on Starknet, recording owner-token balance pairs. Used for tracking liquidity provider positions and token holdings across 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_key	address	removed	in_amount	log_index	signature	event_name	block_number	block_timestamp	transaction_hash
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	118117458886862940	10	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	653295	2024-06-29T00:17:49.000Z	0x5d1ce5c6489b5e72f12e5fb1c182a2923e68ac7c9101241f003ddedb5822ecb
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	295830377652233323	15	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	653306	2024-06-29T01:14:03.000Z	0x50a0207ae0360ceb3ea7d792ea545444ae5f6e204d0c741290429a420d52994
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	63250494408980785	5	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	653308	2024-06-29T01:26:06.000Z	0x7d8de2e8f457987f7d0a2e3a37c8e10c8c6ddd0e003feb105caf75e06bb7052

Example Query

Query with partition filter

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

Core_Swapped_event

Swap events from Ekubo DEX (decentralized exchange) on Starknet containing trade execution details including token amounts exchanged, pool state changes (liquidity, sqrt price ratio, tick position), and locker addresses for analyzing trading activity and liquidity dynamics.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_locker`	`STRING`	Address of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.
`in_sqrt_ratio_after`	`STRING`	Square root price ratio of the pool after the swap execution, represented as a large integer. This value determines the exchange rate between the two tokens in the liquidity pool.
`in_tick_after`	`STRING`	Pool tick value after the swap execution. Represented as a JSON object with magnitude and sign indicating the logarithmic price position.
`in_liquidity_after`	`STRING`	Liquidity available in the pool after the swap execution, measured in abstract liquidity units. Represents the active liquidity at the current price tick that can be used for subsequent trades.

Sample Data

address	removed	in_delta	in_locker	in_params	log_index	signature	event_name	in_pool_key	block_number	in_tick_after	block_timestamp	transaction_hash	in_liquidity_after	in_sqrt_ratio_after
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“6904089074513253446”,“sign”:false},“amount1”:{“mag”:“448933843455981975”,“sign”:true}}	0x1247575ffe570ed1e47f22a7ca066d5ab1467f9229eb1326aec931733673d55	{“amount”:{“mag”:“6904089074513253446”,“sign”:false},“is_token1”:false,“sqrt_ratio_limit”:“18446748437148339061”,“skip_ahead”:“0”}	1	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“0”,“tick_spacing”:“354892”,“extension”:“0x5e470ff654d834983a46b8f29dfa99963d5044b993cb7b9c92243a69dab38f”}	1152795	{“mag”:“2733060”,“sign”:true}	2025-02-15T00:00:13.000Z	0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f	27467922076671751370977	86768783248280433245873418322592791868
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“6912094699830687892”,“sign”:true},“amount1”:{“mag”:“448933843455981975”,“sign”:false}}	0x1247575ffe570ed1e47f22a7ca066d5ab1467f9229eb1326aec931733673d55	{“amount”:{“mag”:“448933843455981975”,“sign”:false},“is_token1”:true,“sqrt_ratio_limit”:“6277100250585753475930931601400621808602321654880405518632”,“skip_ahead”:“0”}	6	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	1152795	{“mag”:“2731855”,“sign”:true}	2025-02-15T00:00:13.000Z	0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f	629091793975556851070	86821057481920433509651128616420689639
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“4441479822408081019”,“sign”:false},“amount1”:{“mag”:“287892673200798048”,“sign”:true}}	0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc	{“amount”:{“mag”:“4441479822408081019”,“sign”:false},“is_token1”:false,“sqrt_ratio_limit”:“18446748437148339061”,“skip_ahead”:“0”}	2	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}	1152795	{“mag”:“2737454”,“sign”:true}	2025-02-15T00:00:13.000Z	0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f	629091793975556851070	86578345861503672540468308019786032499

Example Query

Query with partition filter

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

Exchange_FeesAccumulated_event

Trading fee accumulation events from Ekubo DEX liquidity pools on Starknet. Tracks per-pool fee generation in token0 and token1 amounts for analyzing protocol revenue and liquidity provider earnings.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`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	log_index	signature	event_name	in_amount0	in_amount1	in_pool_key	block_number	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	9	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	0	1010277	{“token0”:“1890246610306140398956106158288649170637766465739242880050362284392785561707”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}	3195651	2025-10-26T16:23:30.000Z	0x392fd61cc9a10a9e319dd63fa2d53739f696f056730b7d4e963240781f2de52
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	3	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	4343913612566	0	{“token0”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}	637025	2024-05-01T02:07:12.000Z	0x565fd74764bc00c4e45c63bf63f4b1248f413d408c8c63c50e2fe4d05268386
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	24	0x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aa	FeesAccumulated	0	16904629037307238	{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“3326961915761608684706172774354379779379643886375680974453167906880707787399”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}	1404237	2025-05-15T19:18:08.000Z	0x2c99191111f4b85db09dba1672c795a3742b413f9c4cea8c0fe7fec42a0e41a

Example Query

Query with partition filter

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

Exchange_LoadedBalance_event

Token balance loading events from Ekubo DEX (decentralized exchange) on Starknet, tracking when users deposit tokens into the exchange contract. Contains owner addresses, token identifiers, and deposited amounts for analyzing liquidity provision and trading activity preparation.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_key	address	removed	in_amount	log_index	signature	event_name	block_number	block_timestamp	transaction_hash
{“owner”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”,“token”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	30001907156770601	0	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	1454468	2025-06-02T11:52:43.000Z	0x5ae579ac4a938722ccfe5f65438bf72116fd965c09eaacb77f1fd4803bc5bf7
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	10248417484927	2	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	1453430	2025-06-02T03:05:19.000Z	0x639fa583ae2cd3eebe702bf42702ce69a59f60cbf28e0a0c156ba6808a22de
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	10461389722745496713	2	0x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323d	LoadedBalance	1455647	2025-06-02T21:49:15.000Z	0x12291adcc2529ede69fe2416d7cfe39038d605ab30b9146e6ba90a7d65d7e9b

Example Query

Query with partition filter

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

Exchange_PoolInitialized_event

Liquidity pool creation events from Ekubo DEX (decentralized exchange) on Starknet, capturing initial token pair configurations with sqrt price ratios and tick positions. Used for tracking new market deployments and analyzing pool launch parameters across token 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_initial_tick`	`STRING`	Initial tick position of the liquidity pool at creation, encoded as JSON with magnitude and sign fields indicating price range starting point. Represents the discrete price level where the pool begins operating on Ekubo’s concentrated liquidity model.
`in_sqrt_ratio`	`STRING`	Square root of the price ratio between the two pool tokens, encoded as a 128-bit unsigned integer. This initial price determines the starting exchange rate when the liquidity pool is first created on Ekubo DEX.

Sample Data

address	removed	log_index	signature	event_name	in_pool_key	block_number	in_sqrt_ratio	block_timestamp	in_initial_tick	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	8	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“948289733678578797136743739861107961246633566273948789873430176055002112509”,“token1”:“1058791659532449161430451918194064712082713418496106126152212012508339615493”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}	1504405	340282366920938463463374607431768211456	2025-06-19T17:58:51.000Z	{“mag”:“0”,“sign”:false}	0x2a7018e2ae5bafd29a3bdba3b5117518819ae175dce850f79beb9652d8d526
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“1154528348897832322836383398094260276478746682240753657495317076362149579530”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	1504096	2325476017545475369090025702413196585	2025-06-19T15:22:18.000Z	{“mag”:“9971707”,“sign”:true}	0x53bd6adad6158899a344c35b66990323b556491d45bd0965397228350129d5b
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0	0x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1	PoolInitialized	{“token0”:“517125115337780208081305629975956820263165114138824120841711207270231259977”,“token1”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“fee”:“34028236692093847977029636859101184”,“tick_spacing”:“200”,“extension”:“0”}	624859	119237498300290789498514213758285500107	2024-03-21T16:44:45.000Z	{“mag”:“2097318”,“sign”:true}	0x6138b8f27ece27f6f3e373c92c35d7f1272fbd1e571dadfb1ba77aea04fe9c2

Example Query

Query with partition filter

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

Exchange_PositionFeesCollected_event

Fee collection events from Ekubo decentralized exchange (DEX) liquidity positions on Starknet. Tracks amount0 and amount1 fees earned by liquidity providers across different pool pairs and position bounds for yield 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_position_key`	`STRING`	Unique identifier for a liquidity position encoded as a JSON object containing the owner address, salt value, and price bounds with magnitude and sign indicators.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	signature	event_name	in_pool_key	block_number	block_timestamp	in_position_key	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“3466404034387083419262317”,“sign”:true},“amount1”:{“mag”:“2628806824220”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	545674	2024-02-14T09:11:28.000Z	{“salt”:“387259”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27272000”,“sign”:true},“upper”:{“mag”:“27144000”,“sign”:true}}}	0x52e852051ade816c63c4391a85cd2aeec66e511e928a204570f001f09b74ef1
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“28717852426695810844348019”,“sign”:true},“amount1”:{“mag”:“23574830099625”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	546751	2024-02-14T17:29:42.000Z	{“salt”:“386156”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27224000”,“sign”:true},“upper”:{“mag”:“27192000”,“sign”:true}}}	0x1e2079af1a4de7ddda4045e24c29c6c4b7cba2e6ec1074fa8d5ada1a2b2292
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“804733120645821690470568512”,“sign”:true},“amount1”:{“mag”:“862528414177731”,“sign”:true}}	0x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100	PositionFeesCollected	{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“19802”,“extension”:“0”}	545822	2024-02-14T10:03:58.000Z	{“salt”:“330640”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27623790”,“sign”:true},“upper”:{“mag”:“26990126”,“sign”:true}}}	0x60559439ca95ff1ea5b213caedc3af18f7f5ca9164eaee3b53052f82ee35f11

Example Query

Query with partition filter

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

Exchange_PositionUpdated_event

Liquidity position updates from Ekubo decentralized exchange (DEX) on Starknet, tracking pool deposits/withdrawals with price bounds, liquidity deltas, and token pair identifiers. Used for analyzing liquidity provider behavior and concentrated liquidity range positioning.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_locker`	`STRING`	Address of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	in_locker	in_params	log_index	signature	event_name	in_pool_key	block_number	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:false},“amount1”:{“mag”:“109999999”,“sign”:true}}	0x50ed6ab03aef492cd062e25facf40ceef63294c53d12b514226f8fb4753266e	{“salt”:“0”,“bounds”:{“lower”:{“mag”:“29948544”,“sign”:true},“upper”:{“mag”:“29948416”,“sign”:true}},“liquidity_delta”:{“mag”:“5475697896079611002”,“sign”:true}}	1	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“0”,“tick_spacing”:“128”,“extension”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”}	1703842	2025-08-09T12:48:23.000Z	0x6cb48cc99605adb9c5b9ca725f9180fee5a3c1f9db543a129aa038f7210320
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:false},“amount1”:{“mag”:“13965000000000000000000”,“sign”:false}}	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	{“salt”:“1493997”,“bounds”:{“lower”:{“mag”:“48700”,“sign”:false},“upper”:{“mag”:“48800”,“sign”:false}},“liquidity_delta”:{“mag”:“272574503761801060760220358”,“sign”:false}}	1	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“1154528348897832322836383398094260276478746682240753657495317076362149579530”,“token1”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“fee”:“0”,“tick_spacing”:“100”,“extension”:“0”}	1705266	2025-08-09T19:01:30.000Z	0x39fed309bfeeb3cb8a3965df96ba25ba117b42f829adaffeb95cba082dd4481
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“0”,“sign”:false},“amount1”:{“mag”:“277999319”,“sign”:true}}	0x50ed6ab03aef492cd062e25facf40ceef63294c53d12b514226f8fb4753266e	{“salt”:“0”,“bounds”:{“lower”:{“mag”:“29607040”,“sign”:true},“upper”:{“mag”:“29606912”,“sign”:true}},“liquidity_delta”:{“mag”:“11666320773669327849”,“sign”:true}}	1	0x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946e	PositionUpdated	{“token0”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“0”,“tick_spacing”:“128”,“extension”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”}	1705962	2025-08-09T22:05:44.000Z	0x52c9f3f0f1dfa89cb821771e836653717362f0dbd6b14363078b145a4aefa4

Example Query

Query with partition filter

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

Exchange_ProtocolFeesPaid_event

Protocol fee collection events from Ekubo DEX (decentralized exchange) on Starknet, tracking fees earned by the protocol from liquidity pool positions. Contains token pair deltas, pool keys, and position identifiers for analyzing protocol revenue and liquidity provider 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_position_key`	`STRING`	Unique identifier for a liquidity position encoded as a JSON object containing the owner address, salt value, and price bounds with magnitude and sign indicators.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	removed	in_delta	log_index	signature	event_name	in_pool_key	block_number	block_timestamp	in_position_key	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“167607250”,“sign”:true},“amount1”:{“mag”:“0”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“128046835014687671764701071103697248442191699810634328684734697634499627675”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	656914	2024-07-10T01:21:24.000Z	{“salt”:“628534”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“10138000”,“sign”:true},“upper”:{“mag”:“9626000”,“sign”:true}}}	0x9befc7961b1c29bf036a52edb603af954f6bee48ea16df4d7ff246995a72ca
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“45623151091”,“sign”:true},“amount1”:{“mag”:“810237616428”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“1401227761463704270887644213836074299174240908273187808525853276343372400144”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	657045	2024-07-10T13:16:07.000Z	{“salt”:“181083”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“66000”,“sign”:false},“upper”:{“mag”:“106000”,“sign”:false}}}	0x112a553aed9c5acf84478f855ff36d29602e28d6e8c02a4dab2431f2a0cc658
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“2213440959077”,“sign”:true},“amount1”:{“mag”:“8417651116883”,“sign”:true}}	3	0x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5	ProtocolFeesPaid	{“token0”:“1401227761463704270887644213836074299174240908273187808525853276343372400144”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	657150	2024-07-10T21:59:34.000Z	{“salt”:“345958”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“79000”,“sign”:false},“upper”:{“mag”:“111000”,“sign”:false}}}	0x7ac079dc2f6417b4f631e950762503b942f632041d599b023379fe6c4a7dd49

Example Query

Query with partition filter

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

Exchange_ProtocolFeesWithdrawn_event

Protocol fee withdrawal events from Ekubo DEX on Starknet, recording token amounts collected by the protocol and transferred to designated recipients. Useful for tracking protocol revenue and fee distribution patterns.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	signature	event_name	block_number	in_recipient	block_timestamp	transaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49	204912813030086970168	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	1120533	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-02-03T01:14:47.000Z	0x5ec255aa4853375472f726f858fd8b07eb85857c94e9f77621ebfa04823dcce
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d	1434212343486886194535	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	1120531	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-02-03T01:13:45.000Z	0xd8be4926c66b78dd1761bc4d2d780ae35d7e9b001a991730ff4c3ed7e2c02c
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d	616045655185499750131	1	0x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824a	ProtocolFeesWithdrawn	1121789	0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067	2025-02-03T11:42:07.000Z	0x784c9a056ec04d72787e1589a39194f773bfdc0fe25a1900b8192cb95648085

Example Query

Query with partition filter

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

Exchange_SavedBalance_event

Balance checkpoint events from Ekubo DEX (decentralized exchange) on Starknet recording token amounts held by owner addresses. Used for tracking liquidity positions and wallet balances across different tokens in the protocol.

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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_key	address	removed	in_amount	log_index	signature	event_name	block_number	block_timestamp	transaction_hash
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	227696672	46	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	645466	2024-06-02T07:09:35.000Z	0x1c10722b9a0a588f5c0a27e1905483ac14f00b9c332495d22ac1bea52e8f8b
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	73559850462196551269	30	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	645479	2024-06-02T08:26:50.000Z	0x384280952f8d05a17d84333f22e5be68216e7c3315771cc8687cc80dcce3625
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}	0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	61935391400535041254	19	0x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2ee	SavedBalance	645484	2024-06-02T08:49:04.000Z	0x3d2bde51ef5a25442cfce607d1ae1f16ba2e057d51caa640951d08cd5070ef0

Example Query

Query with partition filter

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

Exchange_Swapped_event

Swap execution events from Ekubo DEX (decentralized exchange) on Starknet with token amounts, pool state changes, and price impact data. Used for analyzing trading activity, liquidity depth, and price movements across token 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.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`event_name`	`STRING`	Name of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
`in_locker`	`STRING`	Address of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
`in_pool_key`	`STRING`	Unique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.
`in_sqrt_ratio_after`	`STRING`	Pool’s square root price ratio after the swap execution. Expressed as a fixed-point integer representing the relative price between token0 and token1 in the liquidity pool.
`in_tick_after`	`STRING`	Current tick position of the liquidity pool after the swap execution. Represented as a signed integer magnitude indicating price level in Ekubo’s concentrated liquidity model.
`in_liquidity_after`	`STRING`	Available liquidity in the pool after the swap execution, represented as a string-encoded integer. Critical for understanding pool depth and capacity to absorb future trades at the current price level.

Sample Data

address	removed	in_delta	in_locker	in_params	log_index	signature	event_name	in_pool_key	block_number	in_tick_after	block_timestamp	transaction_hash	in_liquidity_after	in_sqrt_ratio_after
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“34951516”,“sign”:true},“amount1”:{“mag”:“34947500”,“sign”:false}}	0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	{“amount”:{“mag”:“34947500”,“sign”:false},“is_token1”:true,“sqrt_ratio_limit”:“340290869532774895418828709522310484269”,“skip_ahead”:“100”}	2	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“2967174050445828070862061291903957281356339325911846264948421066253307482040”,“fee”:“9868188640707215913324132688545205”,“tick_spacing”:“25”,“extension”:“0”}	492383	{“mag”:“141”,“sign”:true}	2024-01-03T00:00:42.000Z	0xcc7cc37a6bb04fa13a8e6dfb5c0aa5a36bfde56d274c0d6b8775b96a96ae3	10873967316386	340258422529211499630181431663298949703
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“705791293821349394”,“sign”:true},“amount1”:{“mag”:“2185296191280707”,“sign”:false}}	0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	{“amount”:{“mag”:“2185296191280707”,“sign”:false},“is_token1”:true,“sqrt_ratio_limit”:“19004979278609578728898886627461134937”,“skip_ahead”:“100”}	5	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“2067328389187055618280650078875645532094077784855137341496529282555987314926”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}	492383	{“mag”:“5777860”,“sign”:true}	2024-01-03T00:00:42.000Z	0x113fa45952f36667c6a40c9f70592d1bd03a8af2a2e177a291edb5dc716a7e4	185058377920536026247	18931887778647831623049198854247569640
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4b	false	{“amount0”:{“mag”:“1867722906”,“sign”:false},“amount1”:{“mag”:“1867404277”,“sign”:true}}	0x4270219d365d6b017231b52e92b3fb5d7c8378b05e9abc97724537a80e93b0f	{“amount”:{“mag”:“1867722906”,“sign”:false},“is_token1”:false,“sqrt_ratio_limit”:“340225381487406824744776032096146628499”,“skip_ahead”:“100”}	3	0x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870	Swapped	{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“2967174050445828070862061291903957281356339325911846264948421066253307482040”,“fee”:“8507159232437450533281168781287096”,“tick_spacing”:“25”,“extension”:“0”}	492383	{“mag”:“147”,“sign”:true}	2024-01-03T00:00:42.000Z	0x7b69d0722ee50599c1ccb45468ae294bbf2ddde57ff4f0bc43a588058e5f7ca	2024869206345539	340257436489077047135683660064714088151

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Core_FeesAccumulated_event

Core_LoadedBalance_event

Core_PoolInitialized_event

Core_PositionFeesCollected_event

Core_PositionUpdated_event

Core_ProtocolFeesPaid_event

Core_ProtocolFeesWithdrawn_event

Core_SavedBalance_event

Core_Swapped_event

Exchange_FeesAccumulated_event

Exchange_LoadedBalance_event

Exchange_PoolInitialized_event

Exchange_PositionFeesCollected_event

Exchange_PositionUpdated_event

Exchange_ProtocolFeesPaid_event

Exchange_ProtocolFeesWithdrawn_event

Exchange_SavedBalance_event

Exchange_Swapped_event

​Tables

​Core_FeesAccumulated_event

​Core_LoadedBalance_event

​Core_PoolInitialized_event

​Core_PositionFeesCollected_event

​Core_PositionUpdated_event

​Core_ProtocolFeesPaid_event

​Core_ProtocolFeesWithdrawn_event

​Core_SavedBalance_event

​Core_Swapped_event

​Exchange_FeesAccumulated_event

​Exchange_LoadedBalance_event

​Exchange_PoolInitialized_event

​Exchange_PositionFeesCollected_event

​Exchange_PositionUpdated_event

​Exchange_ProtocolFeesPaid_event

​Exchange_ProtocolFeesWithdrawn_event

​Exchange_SavedBalance_event

​Exchange_Swapped_event

Tables

Core_FeesAccumulated_event

Core_LoadedBalance_event

Core_PoolInitialized_event

Core_PositionFeesCollected_event

Core_PositionUpdated_event

Core_ProtocolFeesPaid_event

Core_ProtocolFeesWithdrawn_event

Core_SavedBalance_event

Core_Swapped_event

Exchange_FeesAccumulated_event

Exchange_LoadedBalance_event

Exchange_PoolInitialized_event

Exchange_PositionFeesCollected_event

Exchange_PositionUpdated_event

Exchange_ProtocolFeesPaid_event

Exchange_ProtocolFeesWithdrawn_event

Exchange_SavedBalance_event

Exchange_Swapped_event