> ## 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.
# apollox_v2_base
> Tables in tt-contracts.apollox_v2_base
## Tables
### ApolloX4\_CloseFee\_event
Position closing fee distribution events from ApolloX perpetual futures trading, showing total fees collected and allocations to ALP (ApolloX Liquidity Pool), brokers, and DAO participants. Used for tracking fee revenue streams and protocol economics across trading activity.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_totalFee` | `STRING` | Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token. |
| `in_daoAmount` | `STRING` | Fee amount allocated to the decentralized autonomous organization (DAO). String-encoded integer value representing the DAO's portion of the total fee in the smallest denomination of the token. |
| `in_brokerId` | `STRING` | Unique identifier for the broker associated with the fee transaction. String-encoded integer value. |
| `in_brokerAmount` | `STRING` | Fee amount allocated to the broker. String-encoded integer value representing the broker's portion of the total fee in the smallest denomination of the token. |
| `in_alpPoolAmount` | `STRING` | Fee amount allocated to the ALP (ApolloX Liquidity Pool). String-encoded integer value representing the pool's portion of the total fee in the smallest denomination of the token. |
| address | removed | in\_token | log\_index | in\_brokerId | in\_totalFee | block\_number | in\_daoAmount | block\_timestamp | in\_brokerAmount | in\_alpPoolAmount | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ---------------- | ------------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0x4200000000000000000000000000000000000006 | 40 | 1 | 7419564624186834 | 9454416 | 0 | 2024-01-19T21:02:59.000Z | 1854891156046708 | 3709782312093417 | 0x63b0079a98d1d6702a2ddab6d3363f051d7c4dfa33f1758760e7a490abc34e74 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0x4200000000000000000000000000000000000006 | 6 | 1 | 2374870339505840 | 9454794 | 0 | 2024-01-19T21:15:35.000Z | 593717584876460 | 1187435169752920 | 0x6174cb38fbd7e3f2ccd12c970080455d4d148323fbd9c93ccde4f6ed8d6f5527 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0x4200000000000000000000000000000000000006 | 3 | 1 | 1953750826314373 | 9454478 | 0 | 2024-01-19T21:05:03.000Z | 488437706578593 | 976875413157186 | 0x703fad3900aab856a5f00d87b3a769334f15420cdba1dce75c86742675036013 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.apollox_v2_base.ApolloX4_CloseFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ApolloX4\_CloseTradeSuccessful\_event
Successful trade closures from ApolloX perpetual futures protocol on Base, capturing profit/loss, fees (close, funding, holding), and execution prices. Used for analyzing trading performance, fee economics, and position settlement patterns.
| Column | Type | Description |
| ------------------ | ---------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tradeHash` | `STRING` | Unique identifier for a trading position within the ApolloX protocol. 66-character hex string including 0x prefix. |
| `in_closeInfo` | `STRUCT` | Structured data containing financial details of a closed trading position in the ApolloX protocol. Includes close price, profit and loss, close fee, funding fee, and holding fee as string-encoded numeric values. |
| address | in\_user | removed | log\_index | block\_number | in\_closeInfo | in\_tradeHash | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ----------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0x58ce825776ae7a7cdd17868b114162e36a503574 | false | 6 | 7790499 | \{"pnl":"-1232116","closeFee":"704572","closePrice":"4186577016889","fundingFee":"-1590","holdingFee":"57"} | 0xb98f901c2be3dbdfcfa3809074c7c90234491b6570eeb38f7484ac1b3e4d2bb3 | 2023-12-12T08:39:05.000Z | 0x85d84b13b66db869ff3bcac21c88a9320e702fd5961d6e30c03e3a15535942b4 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0x58ce825776ae7a7cdd17868b114162e36a503574 | false | 6 | 7793166 | \{"pnl":"-75880","closeFee":"390141","closePrice":"4180162034780","fundingFee":"-1527","holdingFee":"163"} | 0xf0c52fa8b6595b249138188d260f97b804c1c86011a299a35e9fd0cf4ac75a2d | 2023-12-12T10:07:59.000Z | 0xcfae0845444b4ed29a5a72ec3c26e435145e7ba08ffe51b8db006ab39ff6dde2 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0xf517f1a147fbfd5737872cb48fadf0a60c713777 | false | 6 | 7790838 | \{"pnl":"-100824","closeFee":"318253","closePrice":"4199749814242","fundingFee":"-202","holdingFee":"21"} | 0x70c76aa699b14303585fb50de7cf454677365c2c718cc3cae66709838cef91d5 | 2023-12-12T08:50:23.000Z | 0x560be43467dd9c9b043e6fee30b8473fc386571ce1b3ace68a62ebcd6c02848c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.apollox_v2_base.ApolloX4_CloseTradeSuccessful_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ApolloX4\_ExecuteCloseSuccessful\_event
Successful position close events from ApolloX perpetual futures protocol on Base, capturing profit and loss (PNL), closing fees, funding fees, and execution prices. Used for analyzing trade outcomes and fee structures across different execution types.
| Column | Type | Description |
| ------------------ | ---------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tradeHash` | `STRING` | Unique identifier for a trading position within the ApolloX protocol. 66-character hex string including 0x prefix. |
| `in_executionType` | `INT64` | Enumerated code indicating the method by which a trading position was closed in the ApolloX protocol. Integer value where 0 represents user-initiated close, 1 represents stop-loss execution, and 2 represents liquidation. |
| `in_closeInfo` | `STRUCT` | Structured data containing financial details of a closed trading position in the ApolloX protocol. Includes close price, profit and loss, close fee, funding fee, and holding fee as string-encoded numeric values. |
| address | in\_user | removed | log\_index | block\_number | in\_closeInfo | in\_tradeHash | block\_timestamp | in\_executionType | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0xdc997b543326f5e1434edd7847cff385f96ce6aa | false | 12 | 9445910 | \{"pnl":"3962385980436408","closeFee":"806893255891058","closePrice":"4073457305000","fundingFee":"-29075646311146","holdingFee":"1872728325991"} | 0x215355d3265a9ffd2fb8eef4990c3069618029437807e5d780f50bb2b74e7873 | 2024-01-19T16:19:27.000Z | 0 | 0x28e56279cd0aff83d83bc4ae5280a4e3b8dc581576878c87c9e9dc3310d8b444 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0xfeebbb97c4763be9b1647edb32de60c9d670ebd0 | false | 8 | 9454794 | \{"pnl":"-17483197817532522","closeFee":"2374870339505840","closePrice":"4162016545089","fundingFee":"-21050862375124","holdingFee":"0"} | 0x9dbba25838cca6f295c28e7f6c7b519328f2c42c51319be86fe40619ea194334 | 2024-01-19T21:15:35.000Z | 2 | 0x6174cb38fbd7e3f2ccd12c970080455d4d148323fbd9c93ccde4f6ed8d6f5527 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0xfeebbb97c4763be9b1647edb32de60c9d670ebd0 | false | 5 | 9454478 | \{"pnl":"-45870131804080563","closeFee":"1953750826314373","closePrice":"4167422615027","fundingFee":"-55236389018550","holdingFee":"0"} | 0x69b166170daccac5af07d9149d11d9aa337b3a78b391c00b95bc92710a892418 | 2024-01-19T21:05:03.000Z | 2 | 0x703fad3900aab856a5f00d87b3a769334f15420cdba1dce75c86742675036013 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.apollox_v2_base.ApolloX4_ExecuteCloseSuccessful_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ApolloX4\_OpenFee\_event
Trading position opening fee events from the ApolloX perpetual futures protocol, recording total fees and their distribution across ALP (ApolloX Liquidity Pool), broker, and DAO recipients.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_totalFee` | `STRING` | Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token. |
| `in_daoAmount` | `STRING` | Fee amount allocated to the decentralized autonomous organization (DAO). String-encoded integer value representing the DAO's portion of the total fee in the smallest denomination of the token. |
| `in_brokerId` | `STRING` | Unique identifier for the broker associated with the fee transaction. String-encoded integer value. |
| `in_brokerAmount` | `STRING` | Fee amount allocated to the broker. String-encoded integer value representing the broker's portion of the total fee in the smallest denomination of the token. |
| `in_alpPoolAmount` | `STRING` | Fee amount allocated to the ALP (ApolloX Liquidity Pool). String-encoded integer value representing the pool's portion of the total fee in the smallest denomination of the token. |
| address | removed | in\_token | log\_index | in\_brokerId | in\_totalFee | block\_number | in\_daoAmount | block\_timestamp | in\_brokerAmount | in\_alpPoolAmount | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | --------------- | ------------- | ------------- | ------------------------ | ---------------- | ----------------- | ------------------------------------------------------------------ |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0x4200000000000000000000000000000000000006 | 1 | 1 | 730652686830598 | 7973631 | 0 | 2023-12-16T14:23:29.000Z | 182663171707649 | 365326343415299 | 0x3f68b66a4ffd5d0f8fbcf51fd05bc4f9de5dc1974c087f40223ab03697ba320c |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 1 | 1 | 0 | 7986744 | 0 | 2023-12-16T21:40:35.000Z | 0 | 0 | 0x18db0ebede662f16dccab0fd860326ead206ae44745e980963294b8e3742a5c7 |
| 0x9d93e5b2364070bc9837e91833f162430246dd57 | false | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 1 | 1 | 0 | 7985560 | 0 | 2023-12-16T21:01:07.000Z | 0 | 0 | 0xcf1fe5c2aed7f55edf1eae78a3d39e04fca781b6678861eca530272c7370b310 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.apollox_v2_base.ApolloX4_OpenFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ApolloX4\_OpenMarketTrade\_event
Perpetual futures position openings on ApolloX v2 protocol on Base, capturing margin, entry price, quantity, and stop-loss/take-profit levels. Used for analyzing trader behavior, leverage patterns, and market sentiment across long and short positions.
| Column | Type | Description |
| ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tradeHash` | `STRING` | Unique identifier for a trading position within the ApolloX protocol. 66-character hex string including 0x prefix. |
| `in_ot` | `STRUCT` | Structured data representing an open trade position in the ApolloX protocol. Contains user address, trade parameters (entry price, margin, quantity), token addresses, position direction, fees, and timestamps as string-encoded values except for the boolean isLong field. |
| in\_ot | address | in\_user | removed | log\_index | block\_number | in\_tradeHash | block\_timestamp | transaction\_hash |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| \{"qty":"100000000","user":"0xe90f9596e3bfd49e9f4c2e0ea48830dc47e6997b","broker":"1","isLong":true,"margin":"1855107","openFee":"344905","tokenIn":"0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca","pairBase":"0x236aa50979d5f3de3bd1eeb40e81137f22ab794b","stopLoss":"0","openBlock":"7596159","timestamp":"1701981665","entryPrice":"4311478372708","takeProfit":"4320000000000","executionFee":"299988","holdingFeeRate":"3022","userOpenTradeIndex":"0","longAccFundingFeePerShare":"0"} | 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0xe90f9596e3bfd49e9f4c2e0ea48830dc47e6997b | false | 3 | 7596159 | 0x497a74f76080ec590b4f7b145395ef542c6e577027811a2ed44494a7da34c368 | 2023-12-07T20:41:05.000Z | 0x67a62e83d112f8e823a7140b0e63b62867e853669f40137420c6a436627cdce8 |
| \{"qty":"994076981","user":"0x410c0c5ac86d1fd53e163cc29f0be3fddd12ad91","broker":"1","isLong":true,"margin":"38332035979551780","openFee":"1532892356826369","tokenIn":"0x4200000000000000000000000000000000000006","pairBase":"0x236aa50979d5f3de3bd1eeb40e81137f22ab794b","stopLoss":"0","openBlock":"8762627","timestamp":"1704314601","entryPrice":"4281132410435","takeProfit":"4366640000000","executionFee":"135071663621851","holdingFeeRate":"3022","userOpenTradeIndex":"0","longAccFundingFeePerShare":"0"} | 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0x410c0c5ac86d1fd53e163cc29f0be3fddd12ad91 | false | 2 | 8762627 | 0xe0ce70c0c07a870762419c28eb15f123d9e43836c53e3aada20ef7f2112a9088 | 2024-01-03T20:43:21.000Z | 0x1965330472de92f87aae9281f8ad96f04b10b1dcd35c12d18f56fe98639a6ea6 |
| \{"qty":"73816637818","user":"0x53daccec0fda34c30f89cd64ad29a9bbe84d275e","broker":"1","isLong":true,"margin":"77703450129895329","openFee":"5900318749467473","tokenIn":"0x4200000000000000000000000000000000000006","pairBase":"0x4200000000000000000000000000000000000006","stopLoss":"0","openBlock":"8748165","timestamp":"1704285677","entryPrice":"220027088659","takeProfit":"231645000000","executionFee":"136231120637198","holdingFeeRate":"3022","userOpenTradeIndex":"0","longAccFundingFeePerShare":"0"} | 0x9d93e5b2364070bc9837e91833f162430246dd57 | 0x53daccec0fda34c30f89cd64ad29a9bbe84d275e | false | 2 | 8748165 | 0xefaafe9e3e37b72dab4268553ea4662426915530cbc418789b58973784f5e903 | 2024-01-03T12:41:17.000Z | 0x46b1cfc70ded9a20dc00e57fae9be50cb2099e16feef1522269c60555d897c64 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.apollox_v2_base.ApolloX4_OpenMarketTrade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***