cellana_v1_aptos

Tables

LiquidityPool_AddLiquidityEvent_event

Liquidity provision events from Cellana decentralized exchange (DEX) on Aptos, recording dual-asset deposits with amounts, LP token issuance, and pool addresses. Used for tracking liquidity provider activity and pool growth analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount_1`	`STRING`	Amount of the first token deposited into the liquidity pool during this add liquidity operation. String-encoded to preserve precision for large token amounts with varying decimal places.
`in_amount_2`	`STRING`	Token amount of the second asset deposited into the Cellana liquidity pool. String-encoded integer representing raw token units (before decimal adjustment).

Sample Data

data	in_lp	in_pool	event_type	event_index	in_amount_1	in_amount_2	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“amount_1”:“908298490”,“amount_2”:“4833160”,“lp”:“0x655b3be65fa9e04fa5ad4a3f0437fca1327e43a405f7a3ed55d7715962b3fe54”,“pool”:“0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a”}	0x655b3be65fa9e04fa5ad4a3f0437fca1327e43a405f7a3ed55d7715962b3fe54	0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::AddLiquidityEvent	6	908298490	4833160	215243075	2024-08-18T07:28:17.881Z	0xc6e20f524de14b6919f9053099170315ba6eb261669d7038c89cf102446b753c	0x0
{“amount_1”:“2024322416”,“amount_2”:“10813645”,“lp”:“0xa84931057edafcdfd3356050ac935fba3a25698cf833ee4212640f61cd8b5fb5”,“pool”:“0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a”}	0xa84931057edafcdfd3356050ac935fba3a25698cf833ee4212640f61cd8b5fb5	0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::AddLiquidityEvent	6	2024322416	10813645	215276056	2024-08-18T09:28:19.539Z	0x4c172364e9ae957ee09d5861ab5a976bb04564894d85a247352b51af6890f93b	0x0
{“amount_1”:“14734193654”,“amount_2”:“78701214”,“lp”:“0xd0ced11b7be43755cfbe0733bcf3b475500302b2ec1b646f687e5370a8bc3e9”,“pool”:“0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a”}	0xd0ced11b7be43755cfbe0733bcf3b475500302b2ec1b646f687e5370a8bc3e9	0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::AddLiquidityEvent	6	14734193654	78701214	215274378	2024-08-18T09:22:13.210Z	0x7a72c79aeeae5cc5ab9c11578663be818e34ff58e2f0542e4baec475262835f8	0x0

Example Query

Query with partition filter

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

LiquidityPool_ClaimFeesEvent_event

Fee collection events from Cellana DEX (decentralized exchange) liquidity pools on Aptos, recording the amounts of both tokens claimed by liquidity providers. Useful for analyzing LP fee revenue, pool profitability, and liquidity provider behavior across trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount_1`	`STRING`	Amount of the first token in the trading pair claimed as fees from the liquidity pool, denominated in the token’s smallest unit. Stored as string to preserve precision for large token amounts with varying decimal places.
`in_amount_2`	`STRING`	Quantity of the second token claimed as fees from the liquidity pool, denominated in the token’s smallest unit. Values are stored as strings to preserve precision for large integer amounts.

Sample Data

data	in_pool	event_type	event_index	in_amount_1	in_amount_2	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“amount_1”:“4136901880462”,“amount_2”:“38724928802”,“pool”:“0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a”}	0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::ClaimFeesEvent	27	4136901880462	38724928802	208376406	2024-08-01T00:00:01.503Z	0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858	0x0
{“amount_1”:“765906252”,“amount_2”:“840026702”,“pool”:“0xf7d4a97f8a82b1454cd69f92b5a5bd5bcad609e44a6cf56377755adcfca5863a”}	0xf7d4a97f8a82b1454cd69f92b5a5bd5bcad609e44a6cf56377755adcfca5863a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::ClaimFeesEvent	47	765906252	840026702	208376406	2024-08-01T00:00:01.503Z	0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858	0x0
{“amount_1”:“140364466”,“amount_2”:“2730312”,“pool”:“0xe3939aa0732d67dc0a4e2b5072a7975a0d279c8e93a2756f39ae4c0e5b9abcca”}	0xe3939aa0732d67dc0a4e2b5072a7975a0d279c8e93a2756f39ae4c0e5b9abcca	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::ClaimFeesEvent	57	140364466	2730312	208376406	2024-08-01T00:00:01.503Z	0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858	0x0

Example Query

Query with partition filter

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

LiquidityPool_CreateGaugeEvent_event

Gauge creation events from Cellana DEX on Aptos tracking when liquidity pool voting gauges are initialized. Links creators, pools, and gauge addresses for analyzing liquidity mining program deployments and governance structure.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

data	in_pool	in_gauge	event_type	in_creator	event_index	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“creator”:“0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1”,“gauge”:{“inner”:“0x1bbb1d94fea385d211eac8d34cf9e085d90fcd5239ae2368a9f3985db22a7588”},“pool”:{“inner”:“0x6c2b2c3d5140ee973622ea3fa75a86d0706551864a33aa0feac06bdfc788841b”}}	0x6c2b2c3d5140ee973622ea3fa75a86d0706551864a33aa0feac06bdfc788841b	0x1bbb1d94fea385d211eac8d34cf9e085d90fcd5239ae2368a9f3985db22a7588	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote_manager::CreateGaugeEvent	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1	2	220177835	2024-08-30T10:02:13.655Z	0xb215e2323dea1f41989ae0129aeab7cd655f18cd352f1a11515d48c8db395604	0x0
{“creator”:“0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1”,“gauge”:{“inner”:“0x9bb9616fa9b575b9a6cc3536fa4dc4d202618a7b454f1d9249315efd5fa3ac84”},“pool”:{“inner”:“0x975042842df31e3d0b90e4f84169bb057190e385225b33cbbb2e98b98e3d67aa”}}	0x975042842df31e3d0b90e4f84169bb057190e385225b33cbbb2e98b98e3d67aa	0x9bb9616fa9b575b9a6cc3536fa4dc4d202618a7b454f1d9249315efd5fa3ac84	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote_manager::CreateGaugeEvent	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1	2	220195222	2024-08-30T11:01:41.492Z	0x92fdc0853d03043c04864d8c1a20dde4c4a650d7ccaa2c042c5ff2fd06bb618f	0x0
{“creator”:“0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1”,“gauge”:{“inner”:“0xead63a4c8829e5a06b166b1822a376341828af7490361615ec73b03dd47adb1c”},“pool”:{“inner”:“0x83d4b44ed8dadafdfa4d9343fe27826c507b8dfcd3633ac03c42878a1f752a4b”}}	0x83d4b44ed8dadafdfa4d9343fe27826c507b8dfcd3633ac03c42878a1f752a4b	0xead63a4c8829e5a06b166b1822a376341828af7490361615ec73b03dd47adb1c	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote_manager::CreateGaugeEvent	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1	2	220213801	2024-08-30T12:05:32.345Z	0xf75102aa3863812be372b4e021e8d921569b61995cbaea6a183e42fc7046c552	0x0

Example Query

Query with partition filter

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

LiquidityPool_CreatePoolEvent_event

Liquidity pool creation events from Cellana decentralized exchange (DEX) on Aptos, capturing new pool deployments with token pairs, pool addresses, and stable/volatile pool type classification. Used for tracking DEX pool launches and analyzing token pair availability across the Cellana protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_1`	`STRING`	Token identifier for the first asset in the trading pair, specified in Aptos Move format (module_address::module_name::TokenType). Represents the primary token being paired with in_token_2 to create the liquidity pool.
`in_token_2`	`STRING`	Token type identifier for the second asset in the created liquidity pool. Formatted as an Aptos module path specifying the contract address, module name, and token struct.
`in_is_stable`	`STRING`	Boolean indicator of whether the created liquidity pool uses a stable swap curve optimized for low-slippage trades between like-valued assets. String-encoded as ‘true’ or ‘false’.

Sample Data

data	in_pool	event_type	in_token_1	in_token_2	block_height	in_is_stable	block_timestamp	transaction_hash	event_guid_account_address
{“is_stable”:false,“pool”:{“inner”:“0xb397a2f000a87078c32405907632fbd822c8d951f12df227aa3bfb6506c95512”},“token_1”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC”,“token_2”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MKL”}	0xb397a2f000a87078c32405907632fbd822c8d951f12df227aa3bfb6506c95512	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::CreatePoolEvent	0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MKL	226888800	false	2024-09-15T09:39:12.304Z	0x7071f5f0c5c6b4df22626670e6ed9558b1a46c1fbddddd68c448b248649210bd	0x0
{“is_stable”:false,“pool”:{“inner”:“0x49c2c1027936e5fdc9717aed2aa3a9801109c766aef960bfdbe01bcab40bc268”},“token_1”:“0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin”,“token_2”:“0x1::aptos_coin::AptosCoin”}	0x49c2c1027936e5fdc9717aed2aa3a9801109c766aef960bfdbe01bcab40bc268	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::CreatePoolEvent	0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin	0x1::aptos_coin::AptosCoin	192937903	false	2024-06-21T11:15:25.494Z	0x571832338c499aeb6ae00ae93b6d40412b3f50136435b2479297dd1676dbc9f2	0x0
{“is_stable”:false,“pool”:{“inner”:“0x8d63a3977efbfd835a5f163f01979e73a0e9658e98fdefa8e15c00b5baf8ade”},“token_1”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH”,“token_2”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WBTC”}	0x8d63a3977efbfd835a5f163f01979e73a0e9658e98fdefa8e15c00b5baf8ade	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::CreatePoolEvent	0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WETH	0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::WBTC	241998529	false	2024-10-21T19:08:26.012Z	0x38aadad48896e7e91a84b5c85b14bf713d6484193278acfef8bbbcf7494deb62	0x0

Example Query

Query with partition filter

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

LiquidityPool_RemoveLiquidityEvent_event

Liquidity removal events from Cellana DEX (decentralized exchange) pools on Aptos, capturing LP (liquidity provider) token burns and withdrawn token amounts. Used for tracking liquidity exits, pool composition changes, and LP position management across trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount_lp`	`STRING`	Amount of liquidity provider (LP) tokens burned in this removal transaction, represented as a string-encoded integer. This value determines the proportional share of both underlying assets withdrawn from the pool.
`in_amount_1`	`STRING`	Amount of the first token withdrawn from the liquidity pool, denominated in the token’s smallest unit (like wei). This value represents one side of the liquidity pair being removed.
`in_amount_2`	`STRING`	Quantity of the second token withdrawn from the liquidity pool, denominated in the token’s smallest unit. String-encoded to preserve precision for large integer values.

Sample Data

data	in_lp	in_pool	event_type	event_index	in_amount_1	in_amount_2	block_height	in_amount_lp	block_timestamp	transaction_hash	event_guid_account_address
{“amount_1”:“9963155”,“amount_2”:“6604544”,“amount_lp”:“8280350”,“lp”:“0x4311149b5d90fea6056109862ff1fcd085a3894896242b2f6cbb927d798cc512”,“pool”:“0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6”}	0x4311149b5d90fea6056109862ff1fcd085a3894896242b2f6cbb927d798cc512	0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::RemoveLiquidityEvent	7	9963155	6604544	199021757	8280350	2024-07-07T21:25:00.707Z	0x05d3b6644bfce72228eda736b9f5dc8c32ca49167c99d49f0bfe7c8c1256c244	0x0
{“amount_1”:“1323769622”,“amount_2”:“878800052”,“amount_lp”:“1100825938”,“lp”:“0xf6f831cca28944f574bcfbe23cd0fb8f0375e2209e946fc5aed40dfae80e4047”,“pool”:“0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6”}	0xf6f831cca28944f574bcfbe23cd0fb8f0375e2209e946fc5aed40dfae80e4047	0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::RemoveLiquidityEvent	7	1323769622	878800052	198783970	1100825938	2024-07-07T06:59:02.102Z	0xd9de3fab149b8b9793fa989e0ac782363fb18681cc0d66b5b26d5f193c1a6f79	0x0
{“amount_1”:“1045439527”,“amount_2”:“17749160048”,“amount_lp”:“4220789327”,“lp”:“0x63e5d441ae98f34964dee05a40ce5171f94eb3e2c768476600969e355abab3af”,“pool”:“0x234f0be57d6acfb2f0f19c17053617311a8d03c9ce358bdf9cd5c460e4a02b7c”}	0x63e5d441ae98f34964dee05a40ce5171f94eb3e2c768476600969e355abab3af	0x234f0be57d6acfb2f0f19c17053617311a8d03c9ce358bdf9cd5c460e4a02b7c	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::RemoveLiquidityEvent	7	1045439527	17749160048	198852036	4220789327	2024-07-07T11:04:52.302Z	0x287f074eee0a8a1b071571a98714cbc950e5e7357e99fb1cfe82c42128411f6e	0x0

Example Query

Query with partition filter

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

LiquidityPool_StakeEvent_event

Liquidity pool (LP) token staking events from Cellana DEX (decentralized exchange) on Aptos, recording when users deposit LP tokens into gauges for yield farming. Used for tracking staking behavior, gauge deposit flows, and liquidity incentive program participation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. 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

data	in_lp	in_gauge	in_amount	event_type	event_index	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“amount”:“295191886”,“gauge”:{“inner”:“0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f”},“lp”:“0xb3c54eeb2e82fb11198632de53f47c3d2863994609b3b5ecd16698f7c3dc8ac0”}	0xb3c54eeb2e82fb11198632de53f47c3d2863994609b3b5ecd16698f7c3dc8ac0	0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f	295191886	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent	11	151672630	2024-02-29T19:47:26.525Z	0x630f6c2c154fca5c2f5a66e5663049a1c9b9c833c8c0c13e4f839bdf21822094	0x0
{“amount”:“6155534124”,“gauge”:{“inner”:“0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f”},“lp”:“0x3463bd086fd4e7cf583d6b59d7c1d0cf4194fc710945c1ef697078ca96d0d90d”}	0x3463bd086fd4e7cf583d6b59d7c1d0cf4194fc710945c1ef697078ca96d0d90d	0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f	6155534124	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent	11	151732370	2024-02-29T23:29:48.034Z	0xbc3571b93c01800489b149d4965a8663cd501ef521e4b1c26971e231d5184b89	0x0
{“amount”:“16204712690”,“gauge”:{“inner”:“0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f”},“lp”:“0x90f858a081eb07e0ea54c829ebd2d049a40257f0fb96015ef337dc2698ab4194”}	0x90f858a081eb07e0ea54c829ebd2d049a40257f0fb96015ef337dc2698ab4194	0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f	16204712690	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent	11	151522326	2024-02-29T10:25:56.922Z	0x18ce965d4e304b04052a2bcc6f494511861faa0a18a95ea098123124213db545	0x0

Example Query

Query with partition filter

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

LiquidityPool_SwapEvent_event

Token swap events from Cellana decentralized exchange (DEX) on Aptos blockchain. Captures trade executions with input/output amounts, token pairs, and pool identifiers for analyzing trading volume and liquidity pool activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_from_token`	`STRING`	Fully qualified type identifier of the token being swapped into the pool, following Aptos module path format (`address::module::resource`). Represents the input token in the swap transaction.
`in_to_token`	`STRING`	Aptos token type identifier for the output asset received in the swap, using the fully-qualified module path format. Follows the pattern `\{address\}::\{module\}::\{type\}` such as standard AptosCoin or liquid staking derivatives.
`in_amount_in`	`STRING`	Token quantity being swapped into the liquidity pool, denominated in the smallest unit of the source token. Represents the input side of the swap transaction before execution.
`in_amount_out`	`STRING`	Amount of tokens received from the swap, denominated in the destination token’s smallest unit. Always paired with `in_to_token` to identify which asset was received.

Sample Data

data	in_pool	event_type	event_index	in_to_token	block_height	in_amount_in	in_amount_out	in_from_token	block_timestamp	transaction_hash	event_guid_account_address
{“amount_in”:“9132599487”,“amount_out”:“9289466090”,“from_token”:“0x1::aptos_coin::AptosCoin”,“pool”:“0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6”,“to_token”:“0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt”}	0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SwapEvent	5	0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt	184981298	9132599487	9289466090	0x1::aptos_coin::AptosCoin	2024-05-29T19:29:26.805Z	0xbbc6ba3527eba1282d113219023ab5bd44c8b43b7381c2f3364819d148ac8f41	0x0
{“amount_in”:“15932844024”,“amount_out”:“16205603122”,“from_token”:“0x1::aptos_coin::AptosCoin”,“pool”:“0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6”,“to_token”:“0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt”}	0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SwapEvent	5	0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt	184994018	15932844024	16205603122	0x1::aptos_coin::AptosCoin	2024-05-29T20:19:40.795Z	0xc787832e1aa08d16a4bc61e44cf1f72bddb207cd3087ac90404c047309600ca4	0x0
{“amount_in”:“21216690320”,“amount_out”:“21552070197”,“from_token”:“0x1::aptos_coin::AptosCoin”,“pool”:“0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6”,“to_token”:“0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt”}	0x1ef2be2a92393c09ac5bc5e5b934a831611ebab5c4f2419d1d35f0552abec5f6	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SwapEvent	5	0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amapt_token::AmnisApt	184696241	21216690320	21552070197	0x1::aptos_coin::AptosCoin	2024-05-29T00:10:57.552Z	0x7e325f084bd1572abaa2ea2c90a44174c68d78737a1b87b54e571e03af6c0384	0x0

Example Query

Query with partition filter

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

LiquidityPool_SyncEvent_event

Liquidity pool reserve synchronization events from Cellana DEX on Aptos, recording updated reserve balances for two-token pools after swaps or liquidity changes. Used for tracking pool state changes, calculating real-time exchange rates, and analyzing liquidity depth fluctuations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_reserves_1`	`STRING`	Updated reserve balance of the first token in the liquidity pool after the sync event. Stored as a string to preserve precision for large token amounts with varying decimal places.
`in_reserves_2`	`STRING`	Updated reserve balance of the second token in the Cellana liquidity pool after a sync event. String-encoded integer representing the token quantity in its smallest denomination (e.g., with decimals).

Sample Data

data	in_pool	event_type	event_index	block_height	in_reserves_1	in_reserves_2	block_timestamp	transaction_hash	event_guid_account_address
{“pool”:“0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a”,“reserves_1”:“163750227637”,“reserves_2”:“2648561”}	0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SyncEvent	6	194542489	163750227637	2648561	2024-06-26T02:15:20.529Z	0x2efa33e4ba71ea09f95a6b19b0dc896e172fb568e913e31b8ca923bf5d6d5c3b	0x0
{“pool”:“0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a”,“reserves_1”:“163850127637”,“reserves_2”:“2646947”}	0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SyncEvent	6	194542955	163850127637	2646947	2024-06-26T02:17:19.007Z	0xacff4785b24e7ace3db96468381ff774f943bf1eb733a8fad694690b8f5a877e	0x0
{“pool”:“0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a”,“reserves_1”:“163846227933”,“reserves_2”:“2647010”}	0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity_pool::SyncEvent	12	194637254	163846227933	2647010	2024-06-26T08:48:52.159Z	0x0d8636287e3373b289da5ed074ce4022eb9d30036fff934f942f4d5c4038abbb	0x0

Example Query

Query with partition filter

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

LiquidityPool_UnstakeEvent_event

Liquidity pool (LP) token unstaking events from Cellana decentralized exchange (DEX) on Aptos, recording withdrawals from yield farming gauges. Tracks unstaked amounts, LP token addresses, and gauge identifiers for analyzing liquidity mining participation and reward harvesting behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
`in_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_gauge`	`STRING`	Contract address of the gauge contract. 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

data	in_lp	in_gauge	in_amount	event_type	event_index	block_height	block_timestamp	transaction_hash	event_guid_account_address
{“amount”:“54565980”,“gauge”:{“inner”:“0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114”},“lp”:“0xcf6d5e85f9f503f863e4fe6e39ca3d605203c5bb33b2552d902cc85ecaa22f17”}	0xcf6d5e85f9f503f863e4fe6e39ca3d605203c5bb33b2552d902cc85ecaa22f17	0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114	54565980	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent	3	175734087	2024-05-03T14:57:35.613Z	0xcae114eb6071d31cd452006143a8973b187c88002fa801f4e76a33d53d6f9ed2	0x0
{“amount”:“120718764”,“gauge”:{“inner”:“0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114”},“lp”:“0xb50301b298bbfaadd4bfacdff6eaec23feb0e4e0ba8645041e0a3c9ad8b98285”}	0xb50301b298bbfaadd4bfacdff6eaec23feb0e4e0ba8645041e0a3c9ad8b98285	0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114	120718764	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent	3	175833418	2024-05-03T21:45:24.114Z	0x578a2ab8815341131a6215b0747f91560f40dba461a179ebd9a4cb59149f773a	0x0
{“amount”:“1078656623”,“gauge”:{“inner”:“0x57e66358ff75a7035adfe5ff04e94dde42971021c79b5c4bb004e01454caf78a”},“lp”:“0xf6389da6174f5a9d900ef05ac40562b608a87d056018094e8fe56ef164360e35”}	0xf6389da6174f5a9d900ef05ac40562b608a87d056018094e8fe56ef164360e35	0x57e66358ff75a7035adfe5ff04e94dde42971021c79b5c4bb004e01454caf78a	1078656623	0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent	3	175642746	2024-05-03T08:41:01.038Z	0xcf86cd7ce56d548692b37e2da6acdff493f3e090f3515afaff9e55377e14a590	0x0

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LiquidityPool_AddLiquidityEvent_event

LiquidityPool_ClaimFeesEvent_event

LiquidityPool_CreateGaugeEvent_event

LiquidityPool_CreatePoolEvent_event

LiquidityPool_RemoveLiquidityEvent_event

LiquidityPool_StakeEvent_event

LiquidityPool_SwapEvent_event

LiquidityPool_SyncEvent_event

LiquidityPool_UnstakeEvent_event

​Tables

​LiquidityPool_AddLiquidityEvent_event

​LiquidityPool_ClaimFeesEvent_event

​LiquidityPool_CreateGaugeEvent_event

​LiquidityPool_CreatePoolEvent_event

​LiquidityPool_RemoveLiquidityEvent_event

​LiquidityPool_StakeEvent_event

​LiquidityPool_SwapEvent_event

​LiquidityPool_SyncEvent_event

​LiquidityPool_UnstakeEvent_event

Tables

LiquidityPool_AddLiquidityEvent_event

LiquidityPool_ClaimFeesEvent_event

LiquidityPool_CreateGaugeEvent_event

LiquidityPool_CreatePoolEvent_event

LiquidityPool_RemoveLiquidityEvent_event

LiquidityPool_StakeEvent_event

LiquidityPool_SwapEvent_event

LiquidityPool_SyncEvent_event

LiquidityPool_UnstakeEvent_event