> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# cellana_v1_aptos

> Tables in tt-contracts.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.

<Accordion title="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).                                 |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                                     | in\_lp                                                             | in\_pool                                                           | event\_type                                                                                            | event\_index | in\_amount\_1 | in\_amount\_2 | block\_height | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------ | ------------ | ------------- | ------------- | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"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 | 0                | 0xc6e20f524de14b6919f9053099170315ba6eb261669d7038c89cf102446b753c | 0x0                           | 0                             |
  | \{"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 | 0                | 0x4c172364e9ae957ee09d5861ab5a976bb04564894d85a247352b51af6890f93b | 0x0                           | 0                             |
  | \{"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 | 0                | 0x7a72c79aeeae5cc5ab9c11578663be818e34ff58e2f0542e4baec475262835f8 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_AddLiquidityEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                 | in\_pool                                                           | event\_type                                                                                         | event\_index | in\_amount\_1 | in\_amount\_2 | block\_height | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------- | ------------ | ------------- | ------------- | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"amount\_1":"4136901880462","amount\_2":"38724928802","pool":"0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a"} | 0x85d3337c4ca94612f278c5164d2b21d0d83354648bf9555272b5f9d8f1f33b2a | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::ClaimFeesEvent | 27           | 4136901880462 | 38724928802   | 208376406     | 2024-08-01T00:00:01.503Z | 0                | 0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858 | 0x0                           | 0                             |
  | \{"amount\_1":"765906252","amount\_2":"840026702","pool":"0xf7d4a97f8a82b1454cd69f92b5a5bd5bcad609e44a6cf56377755adcfca5863a"}       | 0xf7d4a97f8a82b1454cd69f92b5a5bd5bcad609e44a6cf56377755adcfca5863a | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::ClaimFeesEvent | 47           | 765906252     | 840026702     | 208376406     | 2024-08-01T00:00:01.503Z | 0                | 0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858 | 0x0                           | 0                             |
  | \{"amount\_1":"140364466","amount\_2":"2730312","pool":"0xe3939aa0732d67dc0a4e2b5072a7975a0d279c8e93a2756f39ae4c0e5b9abcca"}         | 0xe3939aa0732d67dc0a4e2b5072a7975a0d279c8e93a2756f39ae4c0e5b9abcca | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::ClaimFeesEvent | 57           | 140364466     | 2730312       | 208376406     | 2024-08-01T00:00:01.503Z | 0                | 0x671be6e6bee0055001748ba542901bfae83e788e737e2ed5e261816d19a42858 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_ClaimFeesEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                                                                   |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                                                                                             | in\_pool                                                           | in\_gauge                                                          | event\_type                                                                                         | in\_creator                                                        | event\_index | block\_height | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"creator":"0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1","gauge":\{"inner":"0x1bbb1d94fea385d211eac8d34cf9e085d90fcd5239ae2368a9f3985db22a7588"},"pool":\{"inner":"0x6c2b2c3d5140ee973622ea3fa75a86d0706551864a33aa0feac06bdfc788841b"}} | 0x6c2b2c3d5140ee973622ea3fa75a86d0706551864a33aa0feac06bdfc788841b | 0x1bbb1d94fea385d211eac8d34cf9e085d90fcd5239ae2368a9f3985db22a7588 | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote\_manager::CreateGaugeEvent | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1 | 2            | 220177835     | 2024-08-30T10:02:13.655Z | 0                | 0xb215e2323dea1f41989ae0129aeab7cd655f18cd352f1a11515d48c8db395604 | 0x0                           | 0                             |
  | \{"creator":"0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1","gauge":\{"inner":"0x9bb9616fa9b575b9a6cc3536fa4dc4d202618a7b454f1d9249315efd5fa3ac84"},"pool":\{"inner":"0x975042842df31e3d0b90e4f84169bb057190e385225b33cbbb2e98b98e3d67aa"}} | 0x975042842df31e3d0b90e4f84169bb057190e385225b33cbbb2e98b98e3d67aa | 0x9bb9616fa9b575b9a6cc3536fa4dc4d202618a7b454f1d9249315efd5fa3ac84 | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote\_manager::CreateGaugeEvent | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1 | 2            | 220195222     | 2024-08-30T11:01:41.492Z | 0                | 0x92fdc0853d03043c04864d8c1a20dde4c4a650d7ccaa2c042c5ff2fd06bb618f | 0x0                           | 0                             |
  | \{"creator":"0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1","gauge":\{"inner":"0xead63a4c8829e5a06b166b1822a376341828af7490361615ec73b03dd47adb1c"},"pool":\{"inner":"0x83d4b44ed8dadafdfa4d9343fe27826c507b8dfcd3633ac03c42878a1f752a4b"}} | 0x83d4b44ed8dadafdfa4d9343fe27826c507b8dfcd3633ac03c42878a1f752a4b | 0xead63a4c8829e5a06b166b1822a376341828af7490361615ec73b03dd47adb1c | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::vote\_manager::CreateGaugeEvent | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1 | 2            | 220213801     | 2024-08-30T12:05:32.345Z | 0                | 0xf75102aa3863812be372b4e021e8d921569b61995cbaea6a183e42fc7046c552 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_CreateGaugeEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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'.                                            |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                                                                                                                                       | in\_pool                                                           | event\_type                                                                                          | in\_token\_1                                                                             | in\_token\_2                                                                        | event\_index | block\_height | in\_is\_stable | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------- | ------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"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 | 0            | 226888800     | false          | 2024-09-15T09:39:12.304Z | 0                | 0x7071f5f0c5c6b4df22626670e6ed9558b1a46c1fbddddd68c448b248649210bd | 0x0                           | 0                             |
  | \{"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                                                         | 0            | 192937903     | false          | 2024-06-21T11:15:25.494Z | 0                | 0x571832338c499aeb6ae00ae93b6d40412b3f50136435b2479297dd1676dbc9f2 | 0x0                           | 0                             |
  | \{"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     | 0            | 241998529     | false          | 2024-10-21T19:08:26.012Z | 0                | 0x38aadad48896e7e91a84b5c85b14bf713d6484193278acfef8bbbcf7494deb62 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_CreatePoolEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                              |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                                                                  | in\_lp                                                             | in\_pool                                                           | event\_type                                                                                               | event\_index | in\_amount\_1 | in\_amount\_2 | block\_height | in\_amount\_lp | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------- | ------------ | ------------- | ------------- | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"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 | 0                | 0x05d3b6644bfce72228eda736b9f5dc8c32ca49167c99d49f0bfe7c8c1256c244 | 0x0                           | 0                             |
  | \{"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 | 0                | 0xd9de3fab149b8b9793fa989e0ac782363fb18681cc0d66b5b26d5f193c1a6f79 | 0x0                           | 0                             |
  | \{"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 | 0                | 0x287f074eee0a8a1b071571a98714cbc950e5e7357e99fb1cfe82c42128411f6e | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_RemoveLiquidityEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                                              |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                        | in\_lp                                                             | in\_gauge                                                          | in\_amount  | event\_type                                                                           | event\_index | block\_height | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ----------- | ------------------------------------------------------------------------------------- | ------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"amount":"295191886","gauge":\{"inner":"0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f"},"lp":"0xb3c54eeb2e82fb11198632de53f47c3d2863994609b3b5ecd16698f7c3dc8ac0"}   | 0xb3c54eeb2e82fb11198632de53f47c3d2863994609b3b5ecd16698f7c3dc8ac0 | 0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f | 295191886   | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent | 11           | 151672630     | 2024-02-29T19:47:26.525Z | 0                | 0x630f6c2c154fca5c2f5a66e5663049a1c9b9c833c8c0c13e4f839bdf21822094 | 0x0                           | 0                             |
  | \{"amount":"6155534124","gauge":\{"inner":"0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f"},"lp":"0x3463bd086fd4e7cf583d6b59d7c1d0cf4194fc710945c1ef697078ca96d0d90d"}  | 0x3463bd086fd4e7cf583d6b59d7c1d0cf4194fc710945c1ef697078ca96d0d90d | 0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f | 6155534124  | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent | 11           | 151732370     | 2024-02-29T23:29:48.034Z | 0                | 0xbc3571b93c01800489b149d4965a8663cd501ef521e4b1c26971e231d5184b89 | 0x0                           | 0                             |
  | \{"amount":"16204712690","gauge":\{"inner":"0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f"},"lp":"0x90f858a081eb07e0ea54c829ebd2d049a40257f0fb96015ef337dc2698ab4194"} | 0x90f858a081eb07e0ea54c829ebd2d049a40257f0fb96015ef337dc2698ab4194 | 0x8a390be85b126c6aa4c239216dbeb0bfa70e286d045697e1d7a7eb7a6c8da88f | 16204712690 | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::StakeEvent | 11           | 151522326     | 2024-02-29T10:25:56.922Z | 0                | 0x18ce965d4e304b04052a2bcc6f494511861faa0a18a95ea098123124213db545 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_StakeEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                                                  |
</Accordion>

<Accordion title="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         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------- | ------------ | ------------------------------------------------------------------------------------------ | ------------- | -------------- | --------------- | --------------------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"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 | 0                | 0xbbc6ba3527eba1282d113219023ab5bd44c8b43b7381c2f3364819d148ac8f41 | 0x0                           | 0                             |
  | \{"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 | 0                | 0xc787832e1aa08d16a4bc61e44cf1f72bddb207cd3087ac90404c047309600ca4 | 0x0                           | 0                             |
  | \{"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 | 0                | 0x7e325f084bd1572abaa2ea2c90a44174c68d78737a1b87b54e571e03af6c0384 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_SwapEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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). |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                | in\_pool                                                           | event\_type                                                                                    | event\_index | block\_height | in\_reserves\_1 | in\_reserves\_2 | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ----------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------- | ------------ | ------------- | --------------- | --------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"pool":"0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a","reserves\_1":"163750227637","reserves\_2":"2648561"} | 0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::SyncEvent | 6            | 194542489     | 163750227637    | 2648561         | 2024-06-26T02:15:20.529Z | 0                | 0x2efa33e4ba71ea09f95a6b19b0dc896e172fb568e913e31b8ca923bf5d6d5c3b | 0x0                           | 0                             |
  | \{"pool":"0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a","reserves\_1":"163850127637","reserves\_2":"2646947"} | 0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::SyncEvent | 6            | 194542955     | 163850127637    | 2646947         | 2024-06-26T02:17:19.007Z | 0                | 0xacff4785b24e7ace3db96468381ff774f943bf1eb733a8fad694690b8f5a877e | 0x0                           | 0                             |
  | \{"pool":"0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a","reserves\_1":"163846227933","reserves\_2":"2647010"} | 0x1e9cf70ab184026fa1eafc3cc4a4bd0012418425049e60856ea249f72f94ba8a | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::liquidity\_pool::SyncEvent | 12           | 194637254     | 163846227933    | 2647010         | 2024-06-26T08:48:52.159Z | 0                | 0x0d8636287e3373b289da5ed074ce4022eb9d30036fff934f942f4d5c4038abbb | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_SyncEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

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

<Accordion title="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.                                                              |
</Accordion>

<Accordion title="Sample Data">
  | data                                                                                                                                                                                       | in\_lp                                                             | in\_gauge                                                          | in\_amount | event\_type                                                                             | event\_index | block\_height | block\_timestamp         | sequence\_number | transaction\_hash                                                  | event\_guid\_account\_address | event\_guid\_creation\_number |
  | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ---------- | --------------------------------------------------------------------------------------- | ------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ----------------------------- | ----------------------------- |
  | \{"amount":"54565980","gauge":\{"inner":"0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114"},"lp":"0xcf6d5e85f9f503f863e4fe6e39ca3d605203c5bb33b2552d902cc85ecaa22f17"}   | 0xcf6d5e85f9f503f863e4fe6e39ca3d605203c5bb33b2552d902cc85ecaa22f17 | 0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114 | 54565980   | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent | 3            | 175734087     | 2024-05-03T14:57:35.613Z | 0                | 0xcae114eb6071d31cd452006143a8973b187c88002fa801f4e76a33d53d6f9ed2 | 0x0                           | 0                             |
  | \{"amount":"120718764","gauge":\{"inner":"0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114"},"lp":"0xb50301b298bbfaadd4bfacdff6eaec23feb0e4e0ba8645041e0a3c9ad8b98285"}  | 0xb50301b298bbfaadd4bfacdff6eaec23feb0e4e0ba8645041e0a3c9ad8b98285 | 0x4f81cbf057a883074d751d725a1c9a37e8faf4e6f16c11b97ade43874ef8d114 | 120718764  | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent | 3            | 175833418     | 2024-05-03T21:45:24.114Z | 0                | 0x578a2ab8815341131a6215b0747f91560f40dba461a179ebd9a4cb59149f773a | 0x0                           | 0                             |
  | \{"amount":"1078656623","gauge":\{"inner":"0x57e66358ff75a7035adfe5ff04e94dde42971021c79b5c4bb004e01454caf78a"},"lp":"0xf6389da6174f5a9d900ef05ac40562b608a87d056018094e8fe56ef164360e35"} | 0xf6389da6174f5a9d900ef05ac40562b608a87d056018094e8fe56ef164360e35 | 0x57e66358ff75a7035adfe5ff04e94dde42971021c79b5c4bb004e01454caf78a | 1078656623 | 0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1::gauge::UnstakeEvent | 3            | 175642746     | 2024-05-03T08:41:01.038Z | 0                | 0xcf86cd7ce56d548692b37e2da6acdff493f3e090f3515afaff9e55377e14a590 | 0x0                           | 0                             |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.cellana_v1_aptos.LiquidityPool_UnstakeEvent_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***