apollox_v1_arbitrum

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.

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
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0	2	600000	158499958	2023-12-09T19:45:14.000Z	45000	300000	0x96a47d7b3fe15e1c66565bf9ca809278cd6dab6f0e64d3f8f3eee3080bb48cb7
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0	2	600000	158513410	2023-12-09T20:44:05.000Z	45000	300000	0x591372bc881a0f4817a09070f466199ad9493f8c281502ea14ff93978ad70cbd
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	4	2	600000	158510216	2023-12-09T20:30:20.000Z	45000	300000	0x50aec4e173e86483a65eef3e5aecf9779494309f193f856592144ffda9ea2c88

Example Query

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.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_win`	`BOOL`	Boolean flag indicating whether the prediction position was profitable at settlement.
`in_endPrice`	`STRING`	Final price of the asset when the prediction position was settled. Numeric string representation of the price with implied decimal precision.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_profitOrLoss`	`STRING`	Profit or loss amount realized on the settled prediction position. Numeric string representation of the amount in the token’s smallest unit.
`in_closeFee`	`STRING`	Fee charged for closing the prediction position. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

in_id	in_win	address	removed	in_token	log_index	in_closeFee	in_endPrice	block_number	block_timestamp	in_profitOrLoss	transaction_hash
262	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	1000000000000000	223827009543	161056795	2023-12-17T22:00:31.000Z	9000000000000000	0xbf4ec9db9244a84c150de2c177385d85f47a899a842f45235a61af649b3879e2
263	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0	1000000000000000	223828594493	161056812	2023-12-17T22:00:36.000Z	9000000000000000	0x5d5c3f952664796663ddad7db0246ba4452892542d810f9152dc3b1e2124f48d
264	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	13	1000000000000000	223839904028	161056830	2023-12-17T22:00:41.000Z	9000000000000000	0xc1cb85820d75f4194ecb56773b9dd1cb7622bf6770d8f4c83f34162726003b24

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event

​Tables

​ApolloX5_PredictionCloseFee_event

​ApolloX5_SettlePredictionSuccessful_event

Tables

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event