Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedlog_indexsignatureevent_namein_amount0in_amount1in_pool_keyblock_numberblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse50x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated14986900{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“17014118346046923173168730371588410570”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}6631692024-07-28T20:05:28.000Z0x3a6fe4c2e4c7a32700051ef4d4a997548c6b41b4681b1eb90a1877163b00d0
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse90x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated0423141{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}6340112024-04-19T02:48:41.000Z0x35df57b8e0c13c90d696097338ce3fa92bdd3cc22234a9523f3cdbfdebe3a5d
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse240x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated246027913568904380{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}9720492024-12-10T19:48:21.000Z0x604193c773dd481c58786eca88e99ecc9dc710d5a08f46a2bba77f32e919098
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_keyaddressremovedin_amountlog_indexsignatureevent_nameblock_numberblock_timestamptransaction_hash
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse3264006869084040022920x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance9586652024-12-06T00:01:25.000Z0x1cfb5cf0307e50db024eca012c734dbe87cd3d5398bd08e3b70d6b0ead9519c
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse3334963540151084371220x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance9586712024-12-06T00:04:33.000Z0x11748c911a247d1db940c577b7ebade109d4e91d04a871c4f2bb405f8d599f
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse3317224372384323284130x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance9586772024-12-06T00:07:40.000Z0x1c9fe9e5fe783687ca4e46333c48317d628cb9bb3c9b382ba53310b3d23c54b
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_initial_tickSTRINGInitial 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_ratioSTRINGSquare 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.
addressremovedlog_indexsignatureevent_namein_pool_keyblock_numberin_sqrt_ratioblock_timestampin_initial_ticktransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse50x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“0”,“tick_spacing”:“1043”,“extension”:“0x0”}1076664200768299601657903970258880851647702025-01-18T00:09:27.000Z{“mag”:“19475939”,“sign”:true}0x1cd4ad6cc0f5d7af9e69c6182475e02adee75e0e8a557dca6a5dd381a8fc38e
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse50x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“0”,“tick_spacing”:“1077”,“extension”:“0x0”}10766642296215287258935584226457401634822025-01-18T00:09:27.000Z{“mag”:“28417722”,“sign”:true}0x536d00ef5729e366b84d80859353eef4c3c82e3c5a4d847af764bb2b9a16051
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse80x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“0x25fd39a75116b5bf15364a54d2bdc6a8a834f380d8dad4bea208b49a303b16f”,“token1”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“fee”:“1020847100762815390390123822295304634”,“tick_spacing”:“5982”,“extension”:“0x0”}10789773739179729199902464854602416936378822025-01-18T20:29:12.000Z{“mag”:“13626996”,“sign”:true}0x2ea1b9fc2d9e7fb9c838c28b0284e3920e4608144bc3a3e1abacb00c35ce433
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_position_keySTRINGUnique 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_deltaSTRINGChange 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.
addressremovedin_deltalog_indexsignatureevent_namein_pool_keyblock_numberblock_timestampin_position_keytransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“1870766281127412140”,“sign”:true},“amount1”:{“mag”:“106233801824214”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“5982”,“extension”:“0x0”}3393512023-10-20T17:17:51.000Z{“salt”:“8766”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9804498”,“sign”:true},“upper”:{“mag”:“9565218”,“sign”:true}}}0x109231905e4980f0258d0ecea789c002db44e11d76b460d66be752ed8bb5fae
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“392771133853002965”,“sign”:true},“amount1”:{“mag”:“20409041669310”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}3395792023-10-20T23:28:39.000Z{“salt”:“142895”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9787000”,“sign”:true},“upper”:{“mag”:“9747000”,“sign”:true}}}0x36f158e097d40edc546597c243f05c16afcc31b646bf3deaf64270d53c7949
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“13216386664575791”,“sign”:true},“amount1”:{“mag”:“156290899340”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b49”,“token1”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}3395792023-10-20T23:28:39.000Z{“salt”:“175665”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“9787000”,“sign”:true},“upper”:{“mag”:“9747000”,“sign”:true}}}0x404a7bc0f2b693155a05337f32de738c592aaf677bd180735bfcc3fb206b031
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_lockerSTRINGAddress of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
in_deltaSTRINGChange 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.
addressremovedin_deltain_lockerin_paramslog_indexsignatureevent_namein_pool_keyblock_numberblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}70x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}6378062024-05-04T02:31:39.000Z0x2dd7138422289b1d5cfea017674ba941127c3ac9a5c094fc2b1f9bc0ed1b644
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}80x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}6378062024-05-04T02:31:39.000Z0x2dd7138422289b1d5cfea017674ba941127c3ac9a5c094fc2b1f9bc0ed1b644
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}70x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“token1”:“0x68f5c6a61780768455de69077e07e89787839bf8166decfbf92b645209c0fb8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}6378172024-05-04T03:39:09.000Z0x7861816633fff18cb27263ce14f290792a0fa4c416042f082521431f82c215c
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_position_keySTRINGUnique 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_deltaSTRINGChange 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.
addressremovedin_deltalog_indexsignatureevent_namein_pool_keyblock_numberblock_timestampin_position_keytransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“0”,“sign”:true},“amount1”:{“mag”:“10”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}6307322024-04-08T00:04:50.000Z{“salt”:“384442”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“19827000”,“sign”:true},“upper”:{“mag”:“19787000”,“sign”:true}}}0x705a3d3bbc8bb4024c291d3d751ccbd91047f6759227024d5a1201b4fc7b7cd
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“499228744590939448”,“sign”:true},“amount1”:{“mag”:“147004”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}6307332024-04-08T00:10:56.000Z{“salt”:“555180”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“26990000”,“sign”:true},“upper”:{“mag”:“26693000”,“sign”:true}}}0x523675fced66e80ab36917652c30f88da452313a9b20f897a6505bb5ac68a2e
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“0”,“sign”:true},“amount1”:{“mag”:“43311”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7”,“token1”:“0x53c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0x0”}6307342024-04-08T00:17:15.000Z{“salt”:“430627”,“owner”:“0x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e33722184067”,“bounds”:{“lower”:{“mag”:“19698000”,“sign”:true},“upper”:{“mag”:“19500000”,“sign”:true}}}0x153e47192ddbb70d76c3d3d9e1e4d8758f269e4c7214e50c40244dee9fa87
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_tokenin_amountlog_indexsignatureevent_nameblock_numberin_recipientblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d67171213585374884904610x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn24947270x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-09-28T00:14:51.000Z0x2bb09cf1e0f86de8a3f010bc7ede20bb6b92468279a763b4ac1665e57d7e528
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x49d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc71186759289400260610x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn24947150x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-09-28T00:14:12.000Z0x7b820fb85904d615df568a2e7fec7a1dfbb95b15d152fd9c966be799823aaa6
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d197563675899940629810x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn16903630x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-08-07T06:55:04.000Z0x586bf557edb563d5fb75b0fa245b472808ca6258b81751633d906d84f7fd3fd
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_keyaddressremovedin_amountlog_indexsignatureevent_nameblock_numberblock_timestamptransaction_hash
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse118117458886862940100x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6532952024-06-29T00:17:49.000Z0x5d1ce5c6489b5e72f12e5fb1c182a2923e68ac7c9101241f003ddedb5822ecb
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse295830377652233323150x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6533062024-06-29T01:14:03.000Z0x50a0207ae0360ceb3ea7d792ea545444ae5f6e204d0c741290429a420d52994
{“owner”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”,“token”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse6325049440898078550x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6533082024-06-29T01:26:06.000Z0x7d8de2e8f457987f7d0a2e3a37c8e10c8c6ddd0e003feb105caf75e06bb7052
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_lockerSTRINGAddress of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
in_deltaSTRINGChange 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_afterSTRINGSquare 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_afterSTRINGPool tick value after the swap execution. Represented as a JSON object with magnitude and sign indicating the logarithmic price position.
in_liquidity_afterSTRINGLiquidity 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.
addressremovedin_deltain_lockerin_paramslog_indexsignatureevent_namein_pool_keyblock_numberin_tick_afterblock_timestamptransaction_hashin_liquidity_afterin_sqrt_ratio_after
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}10x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“0”,“tick_spacing”:“354892”,“extension”:“0x5e470ff654d834983a46b8f29dfa99963d5044b993cb7b9c92243a69dab38f”}1152795{“mag”:“2733060”,“sign”:true}2025-02-15T00:00:13.000Z0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f2746792207667175137097786768783248280433245873418322592791868
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}60x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}1152795{“mag”:“2731855”,“sign”:true}2025-02-15T00:00:13.000Z0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f62909179397555685107086821057481920433509651128616420689639
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}20x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d”,“token1”:“0x75afe6402ad5a5c20dd25e10ec3b3986acaa647b77e4ae24b0cbc9a54a27a87”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“354892”,“extension”:“0x43e4f09c32d13d43a880e85f69f7de93ceda62d6cf2581a582c6db635548fdc”}1152795{“mag”:“2737454”,“sign”:true}2025-02-15T00:00:13.000Z0x579a2973f6e324d4e05910b0af55dca3b7dc2811faf0bffea32068d71ce73f62909179397555685107086578345861503672540468308019786032499
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedlog_indexsignatureevent_namein_amount0in_amount1in_pool_keyblock_numberblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse90x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated01010277{“token0”:“1890246610306140398956106158288649170637766465739242880050362284392785561707”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}31956512025-10-26T16:23:30.000Z0x392fd61cc9a10a9e319dd63fa2d53739f696f056730b7d4e963240781f2de52
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse30x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated43439136125660{“token0”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}6370252024-05-01T02:07:12.000Z0x565fd74764bc00c4e45c63bf63f4b1248f413d408c8c63c50e2fe4d05268386
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse240x237e5e0677822acfc9117ed0f7ba4810b2c6b539a2359e8d73f9025d56957aaFeesAccumulated016904629037307238{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“3326961915761608684706172774354379779379643886375680974453167906880707787399”,“fee”:“1020847100762815411640772995208708096”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}14042372025-05-15T19:18:08.000Z0x2c99191111f4b85db09dba1672c795a3742b413f9c4cea8c0fe7fec42a0e41a
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_keyaddressremovedin_amountlog_indexsignatureevent_nameblock_numberblock_timestamptransaction_hash
{“owner”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”,“token”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse3000190715677060100x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance14544682025-06-02T11:52:43.000Z0x5ae579ac4a938722ccfe5f65438bf72116fd965c09eaacb77f1fd4803bc5bf7
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse1024841748492720x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance14534302025-06-02T03:05:19.000Z0x639fa583ae2cd3eebe702bf42702ce69a59f60cbf28e0a0c156ba6808a22de
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse1046138972274549671320x305c746d1cf87085ae1abfe05967daa50048146e50e03fa41f7e41a91ee323dLoadedBalance14556472025-06-02T21:49:15.000Z0x12291adcc2529ede69fe2416d7cfe39038d605ab30b9146e6ba90a7d65d7e9b
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_initial_tickSTRINGInitial 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_ratioSTRINGSquare 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.
addressremovedlog_indexsignatureevent_namein_pool_keyblock_numberin_sqrt_ratioblock_timestampin_initial_ticktransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse80x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“948289733678578797136743739861107961246633566273948789873430176055002112509”,“token1”:“1058791659532449161430451918194064712082713418496106126152212012508339615493”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“354892”,“extension”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”}15044053402823669209384634633746074317682114562025-06-19T17:58:51.000Z{“mag”:“0”,“sign”:false}0x2a7018e2ae5bafd29a3bdba3b5117518819ae175dce850f79beb9652d8d526
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse00x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“1154528348897832322836383398094260276478746682240753657495317076362149579530”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}150409623254760175454753690900257024131965852025-06-19T15:22:18.000Z{“mag”:“9971707”,“sign”:true}0x53bd6adad6158899a344c35b66990323b556491d45bd0965397228350129d5b
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse00x25ccf80ee62b2ca9b97c76ccea317c7f450fd6efb6ed6ea56da21d7bb9da5f1PoolInitialized{“token0”:“517125115337780208081305629975956820263165114138824120841711207270231259977”,“token1”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“fee”:“34028236692093847977029636859101184”,“tick_spacing”:“200”,“extension”:“0”}6248591192374983002907894985142137582855001072024-03-21T16:44:45.000Z{“mag”:“2097318”,“sign”:true}0x6138b8f27ece27f6f3e373c92c35d7f1272fbd1e571dadfb1ba77aea04fe9c2
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_position_keySTRINGUnique 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_deltaSTRINGChange 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.
addressremovedin_deltalog_indexsignatureevent_namein_pool_keyblock_numberblock_timestampin_position_keytransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“3466404034387083419262317”,“sign”:true},“amount1”:{“mag”:“2628806824220”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}5456742024-02-14T09:11:28.000Z{“salt”:“387259”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27272000”,“sign”:true},“upper”:{“mag”:“27144000”,“sign”:true}}}0x52e852051ade816c63c4391a85cd2aeec66e511e928a204570f001f09b74ef1
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“28717852426695810844348019”,“sign”:true},“amount1”:{“mag”:“23574830099625”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}5467512024-02-14T17:29:42.000Z{“salt”:“386156”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27224000”,“sign”:true},“upper”:{“mag”:“27192000”,“sign”:true}}}0x1e2079af1a4de7ddda4045e24c29c6c4b7cba2e6ec1074fa8d5ada1a2b2292
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“804733120645821690470568512”,“sign”:true},“amount1”:{“mag”:“862528414177731”,“sign”:true}}00x96982abd597114bdaa4a60612f87fabfcc7206aa12d61c50e7ba1e6c291100PositionFeesCollected{“token0”:“1099036322765358208842757431902990657451942267241031202057476805442728292333”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“3402823669209384634633746074317682114”,“tick_spacing”:“19802”,“extension”:“0”}5458222024-02-14T10:03:58.000Z{“salt”:“330640”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“27623790”,“sign”:true},“upper”:{“mag”:“26990126”,“sign”:true}}}0x60559439ca95ff1ea5b213caedc3af18f7f5ca9164eaee3b53052f82ee35f11
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_lockerSTRINGAddress of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
in_deltaSTRINGChange 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.
addressremovedin_deltain_lockerin_paramslog_indexsignatureevent_namein_pool_keyblock_numberblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}10x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“0”,“tick_spacing”:“128”,“extension”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”}17038422025-08-09T12:48:23.000Z0x6cb48cc99605adb9c5b9ca725f9180fee5a3c1f9db543a129aa038f7210320
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}10x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“1154528348897832322836383398094260276478746682240753657495317076362149579530”,“token1”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“fee”:“0”,“tick_spacing”:“100”,“extension”:“0”}17052662025-08-09T19:01:30.000Z0x39fed309bfeeb3cb8a3965df96ba25ba117b42f829adaffeb95cba082dd4481
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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}}10x3a7adca3546c213ce791fabf3b04090c163e419c808c9830fb343a4a395946ePositionUpdated{“token0”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“0”,“tick_spacing”:“128”,“extension”:“2287781686080231923506676800804214270810635641489019268216440956177484031598”}17059622025-08-09T22:05:44.000Z0x52c9f3f0f1dfa89cb821771e836653717362f0dbd6b14363078b145a4aefa4
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_position_keySTRINGUnique 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_deltaSTRINGChange 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.
addressremovedin_deltalog_indexsignatureevent_namein_pool_keyblock_numberblock_timestampin_position_keytransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“167607250”,“sign”:true},“amount1”:{“mag”:“0”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“128046835014687671764701071103697248442191699810634328684734697634499627675”,“token1”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}6569142024-07-10T01:21:24.000Z{“salt”:“628534”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“10138000”,“sign”:true},“upper”:{“mag”:“9626000”,“sign”:true}}}0x9befc7961b1c29bf036a52edb603af954f6bee48ea16df4d7ff246995a72ca
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“45623151091”,“sign”:true},“amount1”:{“mag”:“810237616428”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“1401227761463704270887644213836074299174240908273187808525853276343372400144”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}6570452024-07-10T13:16:07.000Z{“salt”:“181083”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“66000”,“sign”:false},“upper”:{“mag”:“106000”,“sign”:false}}}0x112a553aed9c5acf84478f855ff36d29602e28d6e8c02a4dab2431f2a0cc658
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“amount0”:{“mag”:“2213440959077”,“sign”:true},“amount1”:{“mag”:“8417651116883”,“sign”:true}}30x5dacf59794364ad1555bb3c9b2346afa81e57e5c19bb6bae0d22721c96c4e5ProtocolFeesPaid{“token0”:“1401227761463704270887644213836074299174240908273187808525853276343372400144”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}6571502024-07-10T21:59:34.000Z{“salt”:“345958”,“owner”:“1301608360075471435988652873011016112527098238822505666695223302941012672615”,“bounds”:{“lower”:{“mag”:“79000”,“sign”:false},“upper”:{“mag”:“111000”,“sign”:false}}}0x7ac079dc2f6417b4f631e950762503b942f632041d599b023379fe6c4a7dd49
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_tokenin_amountlog_indexsignatureevent_nameblock_numberin_recipientblock_timestamptransaction_hash
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x124aeb495b947201f5fac96fd1138e326ad86195b98df6dec9009158a533b4920491281303008697016810x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn11205330x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-02-03T01:14:47.000Z0x5ec255aa4853375472f726f858fd8b07eb85857c94e9f77621ebfa04823dcce
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d143421234348688619453510x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn11205310x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-02-03T01:13:45.000Z0xd8be4926c66b78dd1761bc4d2d780ae35d7e9b001a991730ff4c3ed7e2c02c
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse0x4718f5a0fc34cc1af16a1cdee98ffb20c31f5cd61d6ab07201858f4287c938d61604565518549975013110x291697c8230383d5c3cc8dc39443356a7da6b0735605fb0ee0f7bfbb7b824aProtocolFeesWithdrawn11217890x2e0af29598b407c8716b17f6d2795eca1b471413fa03fb145a5e337221840672025-02-03T11:42:07.000Z0x784c9a056ec04d72787e1589a39194f773bfdc0fe25a1900b8192cb95648085
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_keySTRINGUnique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_keyaddressremovedin_amountlog_indexsignatureevent_nameblock_numberblock_timestamptransaction_hash
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse227696672460x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6454662024-06-02T07:09:35.000Z0x1c10722b9a0a588f5c0a27e1905483ac14f00b9c332495d22ac1bea52e8f8b
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse73559850462196551269300x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6454792024-06-02T08:26:50.000Z0x384280952f8d05a17d84333f22e5be68216e7c3315771cc8687cc80dcce3625
{“owner”:“1919341413504682506464537888213340599793174343085035697059721110464975114204”,“token”:“2009894490435840142178314390393166646092438090257831307886760648929397478285”,“salt”:“0”}0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse61935391400535041254190x48796a25e5ceac9caf95a4618ebfd1516b51e5d994a49d28e22f09c64ad2eeSavedBalance6454842024-06-02T08:49:04.000Z0x3d2bde51ef5a25442cfce607d1ae1f16ba2e057d51caa640951d08cd5070ef0
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_lockerSTRINGAddress of the locker contract managing the transaction state. Hex-encoded, 0x-prefixed, 66-character string.
in_pool_keySTRINGUnique identifier for a liquidity pool, encoded as a JSON object containing token0 and token1 contract addresses along with pool configuration parameters.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
in_deltaSTRINGChange 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_afterSTRINGPool’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_afterSTRINGCurrent 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_afterSTRINGAvailable 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.
addressremovedin_deltain_lockerin_paramslog_indexsignatureevent_namein_pool_keyblock_numberin_tick_afterblock_timestamptransaction_hashin_liquidity_afterin_sqrt_ratio_after
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}20x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“2967174050445828070862061291903957281356339325911846264948421066253307482040”,“fee”:“9868188640707215913324132688545205”,“tick_spacing”:“25”,“extension”:“0”}492383{“mag”:“141”,“sign”:true}2024-01-03T00:00:42.000Z0xcc7cc37a6bb04fa13a8e6dfb5c0aa5a36bfde56d274c0d6b8775b96a96ae310873967316386340258422529211499630181431663298949703
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}50x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“2067328389187055618280650078875645532094077784855137341496529282555987314926”,“token1”:“2087021424722619777119509474943472645767659996348769578120564519014510906823”,“fee”:“170141183460469235273462165868118016”,“tick_spacing”:“1000”,“extension”:“0”}492383{“mag”:“5777860”,“sign”:true}2024-01-03T00:00:42.000Z0x113fa45952f36667c6a40c9f70592d1bd03a8af2a2e177a291edb5dc716a7e418505837792053602624718931887778647831623049198854247569640
0x5dd3d2f4429af886cd1a3b08289dbcea99a294197e9eb43b0e0325b4bfalse{“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”}30x157717768aca88da4ac4279765f09f4d0151823d573537fbbeb950cdbd9a870Swapped{“token0”:“2368576823837625528275935341135881659748932889268308403712618244410713532584”,“token1”:“2967174050445828070862061291903957281356339325911846264948421066253307482040”,“fee”:“8507159232437450533281168781287096”,“tick_spacing”:“25”,“extension”:“0”}492383{“mag”:“147”,“sign”:true}2024-01-03T00:00:42.000Z0x7b69d0722ee50599c1ccb45468ae294bbf2ddde57ff4f0bc43a588058e5f7ca2024869206345539340257436489077047135683660064714088151
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