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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`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.

Sample Data

address	removed	in_token	log_index	in_brokerId	in_totalFee	block_number	block_timestamp	in_brokerAmount	in_alpPoolAmount	transaction_hash
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	3	1	592771805666995	7934750	2023-12-15T16:47:27.000Z	148192951416748	296385902833497	0xf769ad99a777cece6663fbf7c2a3b0942c1e41619ad80fc8cc2a77df3a8a152d
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	4	1	379711330472466	7941188	2023-12-15T20:22:03.000Z	94927832618116	189855665236233	0xb8fcfa20494dda556ca04e8f5d25edeec145ed857ce6dd4db6aad719cd523160
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	4	2	711948968740052	7933331	2023-12-15T16:00:09.000Z	177987242185013	355974484370026	0x5ae54e8fe8dfa07e3d7016860e79a807fb15dd150c23841ba2fa1ed819989a50

Example Query

Query with partition filter

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

ApolloX4_CloseTradeSuccessful_event

Trade position closure events from ApolloX perpetual futures protocol on Base, capturing profit/loss, fees (close, funding, holding), and final execution prices. Used for analyzing trader performance, fee structures, and position settlement outcomes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`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<closePrice STRING, fundingFee STRING, closeFee STRING, pnl STRING, holdingFee STRING>`	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.

Sample Data

address	in_user	removed	log_index	block_number	in_closeInfo	in_tradeHash	block_timestamp	transaction_hash
0x9d93e5b2364070bc9837e91833f162430246dd57	0x7c16bb273156b75f02123f3ee156e54813b036d6	false	13	7994840	{“pnl”:“1915750249140541”,“closeFee”:“880116138534285”,“closePrice”:“222619839956”,“fundingFee”:“-57095792550732”,“holdingFee”:“2694905644641”}	0xcc25ebe2f22fa01831a2a29b1453e32eb2bc11a7f58d0f82b47f012b6e2a62ac	2023-12-17T02:10:27.000Z	0x853d0d4b7ea0519c086ee280461dbd9e20cf5a7321ec02a5ca0086e5a8f5b18f
0x9d93e5b2364070bc9837e91833f162430246dd57	0x7c16bb273156b75f02123f3ee156e54813b036d6	false	7	8026621	{“pnl”:“5219246472464156”,“closeFee”:“515817138830278”,“closePrice”:“223303788191”,“fundingFee”:“-495785326096607”,“holdingFee”:“23331876469993”}	0x0ceb1277174b1512f40aaf5233e70b6a952fe828855c2e99b2cbbb8b0be31e39	2023-12-17T19:49:49.000Z	0x97b02ee9868fa31cc26d89841808afb7fc8bb9b2c64317365c7ae7958386f8f8
0x9d93e5b2364070bc9837e91833f162430246dd57	0x7c16bb273156b75f02123f3ee156e54813b036d6	false	63	8014214	{“pnl”:“770425240761111”,“closeFee”:“1773419844403255”,“closePrice”:“221664696313”,“fundingFee”:“-2823406267206”,“holdingFee”:“134028433746”}	0x545ab4676fe224acd7ef6ce8987fea7559795b23567699784aaf3f1add508333	2023-12-17T12:56:15.000Z	0x3a2e20c500add92f3549e713db0d0e827843195e82b0af74d37f2ebe723c4ae9

Example Query

Query with partition filter

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

ApolloX4_ExecuteCloseSuccessful_event

Successful position closure events from ApolloX perpetual futures protocol on Base, recording profit/loss, fees (close, funding, holding), and execution prices. Used for analyzing trader performance, fee impact, and position exit patterns across different execution types.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`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<closePrice STRING, fundingFee STRING, closeFee STRING, pnl STRING, holdingFee STRING>`	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.

Sample Data

address	in_user	removed	log_index	block_number	in_closeInfo	in_tradeHash	block_timestamp	in_executionType	transaction_hash
0x9d93e5b2364070bc9837e91833f162430246dd57	0xb3ba3e63d62db825840475c341823215b1a596c3	false	8	8387406	{“pnl”:“-738551”,“closeFee”:“49014”,“closePrice”:“4338291354966”,“fundingFee”:“-21543”,“holdingFee”:“0”}	0x1b44fe3c0fa52c6fec56f4ae7a11b37e44debd4726a26ac00782869360b49988	2023-12-26T04:15:59.000Z	2	0x89fc869230453c41e3a0d37a6338d65431aa6ad651c27a9ea8cd174fe9d1280c
0x9d93e5b2364070bc9837e91833f162430246dd57	0x478683278e0f1093baf890f9a53d9cc5b5a55369	false	18	8411477	{“pnl”:“-3705012793259844”,“closeFee”:“69718810593444”,“closePrice”:“220130265861”,“fundingFee”:“-628885648726876”,“holdingFee”:“37985561417402”}	0x963b30fa320fcb960b35fd737da36b95b70d3a41e48d615a8524f4269d8d82ba	2023-12-26T17:38:21.000Z	2	0xba4906b9817450f8a10851da2769d35f71770ecf6f5c9abbd650abf469207bad
0x9d93e5b2364070bc9837e91833f162430246dd57	0x50889b88d800cd8939ca6adb36e9d02ca259aa06	false	149	7946651	{“pnl”:“-5350925”,“closeFee”:“156001”,“closePrice”:“221405930278”,“fundingFee”:“-849063”,“holdingFee”:“43092”}	0xd554d4e4b96c77d0d7c3c000ab583aab585180d93b4c89f75e1c382ce9c52866	2023-12-15T23:24:09.000Z	1	0x87580eeea4fe7d128e641d7245437105c1878762894dd4f1fb69148739e8f833

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v1_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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`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.

Sample Data

address	removed	in_token	log_index	in_brokerId	in_totalFee	block_number	block_timestamp	in_brokerAmount	in_alpPoolAmount	transaction_hash
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	1	1	67359767412818	8696202	2024-01-02T07:49:11.000Z	16839941853204	33679883706409	0xc911eb76f10d248b6c5b96d713973ef963065b0a0f7397c185cb9425c95a686c
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	1	1	819064837200899	8721419	2024-01-02T21:49:45.000Z	204766209300224	409532418600449	0x7b581ba16fbdf9f62d6cbd98939d2c41a8ed61e82bac71e067eceb138c02274e
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	1	1	0	8702399	2024-01-02T11:15:45.000Z	0	0	0xb962e7dceb5b239657415c061c16b8fa0281b1ce1771096b2ec3765e1e8f227b

Example Query

Query with partition filter

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

ApolloX4_OpenMarketTrade_event

Market order opening events from ApolloX perpetual futures DEX on Base, capturing long/short positions with entry prices, margins, leverage details, and fee structures for analyzing trading patterns and position management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`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<user STRING, userOpenTradeIndex STRING, entryPrice STRING, pairBase STRING, tokenIn STRING, margin STRING, stopLoss STRING, takeProfit STRING, broker STRING, isLong BOOL, openFee STRING, longAccFundingFeePerShare STRING, executionFee STRING, timestamp STRING, qty STRING, holdingFeeRate STRING, openBlock STRING>`	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.

Sample Data

in_ot	address	in_user	removed	log_index	block_number	in_tradeHash	block_timestamp	transaction_hash
{“qty”:“141339608449”,“user”:“0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3”,“broker”:“1”,“isLong”:false,“margin”:“259869928313796706”,“openFee”:“0”,“tokenIn”:“0x4200000000000000000000000000000000000006”,“pairBase”:“0xbc76b3fd0d18c7496c0b04aea0fe7c3ed0e4d9c9”,“stopLoss”:“0”,“openBlock”:“8556528”,“timestamp”:“1703902403”,“entryPrice”:“4214457287407”,“takeProfit”:“4201840000000”,“executionFee”:“130071686203294”,“holdingFeeRate”:“1020”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“0”}	0x9d93e5b2364070bc9837e91833f162430246dd57	0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3	false	2	8556528	0x8e0e8cad7a3637d5a34cbb86b420d8822edfb17f3d1871586b4a9e12317806d4	2023-12-30T02:13:23.000Z	0x1da4e8d358a3a57841862d7fa81e40394f7562dcc2b83fa0335e4c9711311aef
{“qty”:“32598421380”,“user”:“0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3”,“broker”:“1”,“isLong”:false,“margin”:“59869705159714764”,“openFee”:“0”,“tokenIn”:“0x4200000000000000000000000000000000000006”,“pairBase”:“0xbc76b3fd0d18c7496c0b04aea0fe7c3ed0e4d9c9”,“stopLoss”:“0”,“openBlock”:“8560060”,“timestamp”:“1703909467”,“entryPrice”:“4203798664063”,“takeProfit”:“4191260000000”,“executionFee”:“130294840285236”,“holdingFeeRate”:“1020”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“0”}	0x9d93e5b2364070bc9837e91833f162430246dd57	0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3	false	2	8560060	0xa36b43b351bced16bed2f505fa6ee8cbc57e9bfef7f946e68dc797d6a37901d4	2023-12-30T04:11:07.000Z	0x2ed2e468541355bc5571dd592c679c2167d4c752d07d54f64079620a924d3932
{“qty”:“4830102635”,“user”:“0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3”,“broker”:“1”,“isLong”:true,“margin”:“8869551038156322”,“openFee”:“0”,“tokenIn”:“0x4200000000000000000000000000000000000006”,“pairBase”:“0xbc76b3fd0d18c7496c0b04aea0fe7c3ed0e4d9c9”,“stopLoss”:“0”,“openBlock”:“8558191”,“timestamp”:“1703905729”,“entryPrice”:“4200869943695”,“takeProfit”:“4213460000000”,“executionFee”:“130448961843678”,“holdingFeeRate”:“1020”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“0”}	0x9d93e5b2364070bc9837e91833f162430246dd57	0x4ec612ac2933d0e0a1194e2e63e6a05bc05259b3	false	2	8558191	0x7eb6ce4eecd337f016f266d22623f82fa9d5ab408e2e5a6ad52eb49557eebfc7	2023-12-30T03:08:49.000Z	0x6fa229f2fd65636aae16a4985802a36ed4ec1c1fa74c3344557eb6f482110705

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ApolloX4_CloseFee_event

ApolloX4_CloseTradeSuccessful_event

ApolloX4_ExecuteCloseSuccessful_event

ApolloX4_OpenFee_event

ApolloX4_OpenMarketTrade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ApolloX4_CloseFee_event

​ApolloX4_CloseTradeSuccessful_event

​ApolloX4_ExecuteCloseSuccessful_event

​ApolloX4_OpenFee_event

​ApolloX4_OpenMarketTrade_event

Tables

ApolloX4_CloseFee_event

ApolloX4_CloseTradeSuccessful_event

ApolloX4_ExecuteCloseSuccessful_event

ApolloX4_OpenFee_event

ApolloX4_OpenMarketTrade_event