Skip to main content

​
Tables

​
ApolloX5_PredictionCloseFee_event

Fee distribution events emitted when closing prediction positions on ApolloX perpetual futures platform. Records total fee breakdown across ALP (ApolloX Liquidity Pool), broker, and DAO recipients with token and broker identification.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_totalFeeSTRINGTotal fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
in_daoAmountSTRINGFee 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_brokerIdSTRINGUnique identifier for the broker associated with the fee transaction. String-encoded integer value.
in_brokerAmountSTRINGFee 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_alpPoolAmountSTRINGFee 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.
addressremovedin_tokenlog_indexin_brokerIdin_totalFeeblock_numberin_daoAmountblock_timestampin_brokerAmountin_alpPoolAmounttransaction_hash
0xb3879e95a4b8e3ee570c232b19d520821f540e48false0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb90260000015849995802023-12-09T19:45:14.000Z450003000000x96a47d7b3fe15e1c66565bf9ca809278cd6dab6f0e64d3f8f3eee3080bb48cb7
0xb3879e95a4b8e3ee570c232b19d520821f540e48false0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb90260000015851341002023-12-09T20:44:05.000Z450003000000x591372bc881a0f4817a09070f466199ad9493f8c281502ea14ff93978ad70cbd
0xb3879e95a4b8e3ee570c232b19d520821f540e48false0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb94260000015851021602023-12-09T20:30:20.000Z450003000000x50aec4e173e86483a65eef3e5aecf9779494309f193f856592144ffda9ea2c88
Query with partition filter
SELECT *
FROM `tt-contracts.apollox_v1_arbitrum.ApolloX5_PredictionCloseFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
ApolloX5_SettlePredictionSuccessful_event

Settlement events for price prediction positions on ApolloX, recording final outcome, settlement price, profit/loss amounts, and close fees. Used for tracking prediction market performance and user PnL (Profit and Loss) calculations.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_winBOOLBoolean flag indicating whether the prediction position was profitable at settlement.
in_endPriceSTRINGFinal price of the asset when the prediction position was settled. Numeric string representation of the price with implied decimal precision.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_profitOrLossSTRINGProfit or loss amount realized on the settled prediction position. Numeric string representation of the amount in the token’s smallest unit.
in_closeFeeSTRINGFee charged for closing the prediction position. Numeric string representation of the fee amount in the token’s smallest unit.
in_idin_winaddressremovedin_tokenlog_indexin_closeFeein_endPriceblock_numberblock_timestampin_profitOrLosstransaction_hash
262false0xb3879e95a4b8e3ee570c232b19d520821f540e48false0x82af49447d8a07e3bd95bd0d56f35241523fbab1010000000000000002238270095431610567952023-12-17T22:00:31.000Z90000000000000000xbf4ec9db9244a84c150de2c177385d85f47a899a842f45235a61af649b3879e2
263false0xb3879e95a4b8e3ee570c232b19d520821f540e48false0x82af49447d8a07e3bd95bd0d56f35241523fbab1010000000000000002238285944931610568122023-12-17T22:00:36.000Z90000000000000000x5d5c3f952664796663ddad7db0246ba4452892542d810f9152dc3b1e2124f48d
264false0xb3879e95a4b8e3ee570c232b19d520821f540e48false0x82af49447d8a07e3bd95bd0d56f35241523fbab11310000000000000002238399040281610568302023-12-17T22:00:41.000Z90000000000000000xc1cb85820d75f4194ecb56773b9dd1cb7622bf6770d8f4c83f34162726003b24
Query with partition filter
SELECT *
FROM `tt-contracts.apollox_v1_arbitrum.ApolloX5_SettlePredictionSuccessful_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100