apollox_v2_arbitrum

Tables

ApolloX3_CloseFee_event

Position close fee distribution records from ApolloX perpetual futures protocol on Arbitrum. Tracks fee splits between brokers and DAO treasury when traders close positions, used for analyzing fee revenue allocation and broker incentive structures.

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.

Sample Data

address	removed	in_token	log_index	in_brokerId	in_totalFee	block_number	block_timestamp	in_brokerAmount	transaction_hash
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2	1	18728656	134366582	2023-09-25T05:49:08.000Z	9364328	0x5a44bd07eb024db5f12607d5e51dba8a87cda2c34a4234115befd8766fa3cafb
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2	1	18873633	134329257	2023-09-25T02:58:16.000Z	9436816	0x8980c5de75a4b9f10a78013c968505c0f71e154eded7bbcf1d50a0b2f31cfc73
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	3	1	18889318	134329269	2023-09-25T02:58:19.000Z	9444659	0x6a6dfe0f86d9551c81a35cba562c0f8bc1a2cc8437f7a2d6b997098d8afd3b8f

Example Query

Query with partition filter

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

ApolloX3_CloseTradeSuccessful_event

Perpetual futures position closure events from ApolloX v2 protocol on Arbitrum, capturing realized PnL (profit and loss), close price, fees (close, funding, holding), and trader addresses. Used for tracking trading outcomes and fee analysis across settled positions.

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
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x04af263e9d5e1f8c517b3e1eff4600008760fe51	false	19	222726007	{“pnl”:“-223684”,“closeFee”:“198866”,“closePrice”:“6610870959952”,“fundingFee”:“-303”,“holdingFee”:“52”}	0xcb6d14284e7823b575e61284990c5262299ee4e76c32513e9dc3a20d1f328070	2024-06-17T07:07:42.000Z	0x34b708eeb861fc90b50d6ace48e8d3d3db6838e5834831f762422647654788fc
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x15f3f0e210e41b67e37e1ae02cce988db63ee4a4	false	9	222870457	{“pnl”:“-1991914588014453”,“closeFee”:“98866513807019”,“closePrice”:“6598173930369”,“fundingFee”:“20309636709344”,“holdingFee”:“3461701157976”}	0x4bc495fc6149535801633088ec40e460b5149c27195200aac57c3fe25f5657d9	2024-06-17T17:11:38.000Z	0xdec0190a70bd124a6f453701837952af77bc9f7cf506428b338307f6edf78917
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x15f3f0e210e41b67e37e1ae02cce988db63ee4a4	false	14	222888076	{“pnl”:“1370114970461861”,“closeFee”:“111493027571779”,“closePrice”:“6691880667519”,“fundingFee”:“-6017655854700”,“holdingFee”:“1004972884699”}	0x5ae5fbfd04862c6e96e0522ccb836e5bd4f63878fcc6cefa58cee611b66e1b14	2024-06-17T18:25:32.000Z	0x7ab54eb41542641395851b476600c6b868e1f2e2fa72108f6ef83120d050d062

Example Query

Query with partition filter

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

ApolloX3_ExecuteCloseSuccessful_event

Position close execution events from ApolloX V2 perpetual futures protocol on Arbitrum. Records completed position closures with profit/loss, fees, close prices, and execution type for analyzing trading outcomes and protocol fee generation.

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	transaction_hash
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0xb8ffbc25854e4c5cdb27171b3cc74d5bd9f0cbee	false	9	153815579	{“pnl”:“2297815671499578”,“closeFee”:“434149989165501”,“closePrice”:“208407000000”,“fundingFee”:“-3133984055122”,“holdingFee”:“667029043507”}	0xe700571014d9c51097492051905e28eec2a716bfb8925922a7303dd64e3bba73	2023-11-25T04:51:10.000Z	0xba653c4548aca139c6eed19a40820facdabf021e66e1512bf911b305709ed447
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0xb8ffbc25854e4c5cdb27171b3cc74d5bd9f0cbee	false	9	153820253	{“pnl”:“1353447854224074”,“closeFee”:“269943423137101”,“closePrice”:“208398000000”,“fundingFee”:“-873894221285”,“holdingFee”:“275143654539”}	0x9968e7b4c5103941cd68d17ce1a7403d6b492345eebe42f3e0e5f262746e911c	2023-11-25T05:11:29.000Z	0xf69be57436a2186a2db1a55085ca0e11eaf15834f1b2ce7658a57af8b3a0357c
0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x6c5816e0c529f67f5de255488e72ab9ae00638fb	false	17	153993585	{“pnl”:“10199089”,“closeFee”:“4545625”,“closePrice”:“3777610000000”,“fundingFee”:“-18558”,“holdingFee”:“3940”}	0xd748d8fd1ff4f8f60eff0aa86da0ed3954ac5d9b1a097cc62c22c5089f8d7aa2	2023-11-25T17:06:49.000Z	0xb88a836ef013d16fc2651d694cfe42c0ac1eb2355cef65a81e9fa20ef9cb662c

Example Query

Query with partition filter

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

ApolloX3_OpenFee_event

Position opening fee events from ApolloX perpetual futures protocol on Arbitrum, capturing total fees, broker commissions, and DAO revenue splits by token and broker ID. Used for analyzing fee distribution mechanics and broker economics in derivatives trading.

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.

Sample Data

address	removed	in_token	log_index	in_brokerId	block_number	block_timestamp	transaction_hash
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	5	2	131812938	2023-09-17T04:46:18.000Z	0xdb622fe23e5962bbb4b05c33833b88100b95e74c4a6c720616568398df726aac
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	5	2	131798332	2023-09-17T03:26:18.000Z	0x2d0f9ca5be8b381fb563db72a002646675e75a0e20b70b6c84a2e5fd87268301
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2	1	132028562	2023-09-17T21:37:42.000Z	0xcef7a1e74d5517d9e6fbf6a0f65b6eefbc25938f4aaf9b5d93abe09c97e2ced5

Example Query

Query with partition filter

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

ApolloX3_OpenMarketTrade_event

Trade opening events from ApolloX perpetual futures protocol on Arbitrum, capturing position entries with margin, leverage, entry price, and stop-loss/take-profit levels for analyzing trader behavior and position risk 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”:“9446014540”,“user”:“0xf974680f9a3d6a483c7125542567688c078243b1”,“broker”:“2”,“isLong”:false,“margin”:“17478987438893008”,“openFee”:“0”,“tokenIn”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“pairBase”:“0xdca8bdcca825db8e5b48ec26cd4eaa1b03e7c581”,“stopLoss”:“0”,“openBlock”:“190455871”,“timestamp”:“1710462855”,“entryPrice”:“7215730844949”,“takeProfit”:“7196670000000”,“executionFee”:“51012561106992”,“holdingFeeRate”:“170”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“-289005227218579”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0xf974680f9a3d6a483c7125542567688c078243b1	false	23	190455871	0x6441f576c7725469b1be56b5fde1e576c13e66dd768d14fa3a19fe6fdf1a9a58	2024-03-15T00:34:15.000Z	0x3bc178ad55e00bb520bb1a9542fde8fd20c20548abe33ed7f347f32f6cc1cc5e
{“qty”:“7769974105”,“user”:“0xf974680f9a3d6a483c7125542567688c078243b1”,“broker”:“2”,“isLong”:false,“margin”:“14388996740089809”,“openFee”:“0”,“tokenIn”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“pairBase”:“0xdca8bdcca825db8e5b48ec26cd4eaa1b03e7c581”,“stopLoss”:“0”,“openBlock”:“190456608”,“timestamp”:“1710463040”,“entryPrice”:“7223336280940”,“takeProfit”:“7203850000000”,“executionFee”:“51003259910191”,“holdingFeeRate”:“170”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“-289492135155027”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0xf974680f9a3d6a483c7125542567688c078243b1	false	21	190456608	0xbb66977dd2d990fca3e1dc20376c75dc9610c54661ee2845f9c00ba77bf61651	2024-03-15T00:37:20.000Z	0x419a72e7f9feddead1c1805dbd8726ebf482a98f8657accbaa98b3b678f068bd
{“qty”:“7526199288”,“user”:“0xf974680f9a3d6a483c7125542567688c078243b1”,“broker”:“2”,“isLong”:false,“margin”:“13948932618965359”,“openFee”:“0”,“tokenIn”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“pairBase”:“0xdca8bdcca825db8e5b48ec26cd4eaa1b03e7c581”,“stopLoss”:“0”,“openBlock”:“190457360”,“timestamp”:“1710463229”,“entryPrice”:“7223349525888”,“takeProfit”:“7200010000000”,“executionFee”:“51067381034641”,“holdingFeeRate”:“170”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“-290012704165263”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0xf974680f9a3d6a483c7125542567688c078243b1	false	6	190457360	0xe2bb2f9943bd292197849159c234989743acdf0a5bdf563e016c1511a3400f62	2024-03-15T00:40:29.000Z	0xbab8606a9033835c01b387003b2ca756724873b887b6f5163c9446eba16ac2c2

Example Query

Query with partition filter

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

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
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	251	1	58364	239379535	2024-08-04T14:54:49.000Z	11672	29182	0xfb986d6202a0072aa5ffcdd14fc08adee4a073670e6a10190da46e681d0d271b
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	74	1	10902352	239507281	2024-08-04T23:51:20.000Z	2180470	5451176	0x54e80eb1584b48d5068c30654bf7f8248a1d8d8916e5c48f6068ae9388ca8210
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	69	1	221044840329532	239438330	2024-08-04T19:02:15.000Z	44208968065906	110522420164766	0x013de352d526cecc635168f4e03c76709b98f60406ee801a48032ba3f303d925

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_arbitrum.ApolloX4_CloseFee_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	block_number	block_timestamp	transaction_hash
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1	2	170216204	2024-01-14T01:05:10.000Z	0x4c5c08fde9bd39adbe61e0bf932498d19022cb77f9e94e9bec3a14dd630b3102
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	1	2	170355235	2024-01-14T11:40:48.000Z	0x00a6446a431e45e220bbf64e7f8fd0df5a219cfb3bbce43e1e9fc235f034e953
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1	2	170412720	2024-01-14T15:56:28.000Z	0xde406319939a0868ece4fb3ee72755e27c7f02e4676431b3c468d252c020a4d8

Example Query

Query with partition filter

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

ApolloX5_PredictAndBet_event

Price prediction bet placements on ApolloX prediction market protocol on Arbitrum, recording user wagers with direction (up/down), entry price, bet amounts in tokens and USD, and time period for analyzing prediction market 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_op`	`STRUCT<tokenIn STRING, betAmount STRING, predictionPairBase STRING, openFee STRING, user STRING, betAmountUsd STRING, userOpenPredictIndex STRING, entryPrice STRING, startTime STRING, broker STRING, isUp BOOL, period INT64>`	Structured record containing prediction bet operation details including direction (isUp), bet amounts in token and USD, entry price, time period, and associated addresses. Core data structure capturing all parameters of a price prediction wager on the ApolloX platform.

Sample Data

in_id	in_op	address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
1426	{“isUp”:true,“user”:“0x76a365052757fed6cefbc5ab53dc5f3e30f1f865”,“broker”:“1”,“period”:1,“openFee”:“0”,“tokenIn”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“betAmount”:“6000000000000000”,“startTime”:“1707436769”,“entryPrice”:“4529226859832”,“betAmountUsd”:“14525502368940000000”,“predictionPairBase”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“userOpenPredictIndex”:“0”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x76a365052757fed6cefbc5ab53dc5f3e30f1f865	false	0	178830344	2024-02-08T23:59:29.000Z	0x16e7fe2ad9cf4dcb650e3e3fd117459b996d04dab88f6c4f858816d4e1cdef1e
1425	{“isUp”:true,“user”:“0x76a365052757fed6cefbc5ab53dc5f3e30f1f865”,“broker”:“1”,“period”:1,“openFee”:“0”,“tokenIn”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“betAmount”:“5000000000000000”,“startTime”:“1707368284”,“entryPrice”:“4447160936058”,“betAmountUsd”:“12140790240000000000”,“predictionPairBase”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“userOpenPredictIndex”:“0”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x76a365052757fed6cefbc5ab53dc5f3e30f1f865	false	0	178570390	2024-02-08T04:58:04.000Z	0x32636057e3d2de91d8ee679d2892d8cb7f960f38b227cfe71b5163c907ef62f4
1730	{“isUp”:false,“user”:“0x16e3a8d05dd429c603ea88d5c898d822ac5a7469”,“broker”:“1”,“period”:2,“openFee”:“0”,“tokenIn”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“betAmount”:“11000000”,“startTime”:“1711718671”,“entryPrice”:“7021497835490”,“betAmountUsd”:“10999809040000000000”,“predictionPairBase”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“userOpenPredictIndex”:“0”}	0xb3879e95a4b8e3ee570c232b19d520821f540e48	0x16e3a8d05dd429c603ea88d5c898d822ac5a7469	false	1	195447730	2024-03-29T13:24:31.000Z	0xa97402a40b948829052e714ca65ae442f168f6b038f335130f0482488a75794b

Example Query

Query with partition filter

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

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	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0	2	927600	193285121	2024-03-23T06:45:50.000Z	185520	463800	0xb1e976d3df4a31d221193661b5dc31ea2596a1d8004308ddc9e21be0fac999a4
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	5	1	3000000	236970223	2024-07-28T14:59:57.000Z	600000	1500000	0x120bc8dd92f914989c35329517b29ac15c63b639ffa96aeed0279d3930ef7195
0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0	1	6000000	237038572	2024-07-28T19:44:57.000Z	1200000	3000000	0xf5cbc292ad0bdc5053f37f578be1ce02372acc979dc4d5a0925137c79a9c4943

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_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
5719	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	7	2000000	348917864472	235052135	2024-07-23T01:15:31.000Z	18000000	0xc432910f07b5fd993a6e8e0fa9d19ef1937df1b997e4abbfe8859d2514fd8ad6
5715	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	3	4340000	347692730757	235051017	2024-07-23T01:10:51.000Z	39060000	0x489d3e31e573f5e351103dda6572cc1fbea9020934fcac9727aa2a8145af2b2b
5716	false	0xb3879e95a4b8e3ee570c232b19d520821f540e48	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2	4340000	347692730757	235051017	2024-07-23T01:10:51.000Z	39060000	0x489d3e31e573f5e351103dda6572cc1fbea9020934fcac9727aa2a8145af2b2b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ApolloX3_CloseFee_event

ApolloX3_CloseTradeSuccessful_event

ApolloX3_ExecuteCloseSuccessful_event

ApolloX3_OpenFee_event

ApolloX3_OpenMarketTrade_event

ApolloX4_CloseFee_event

ApolloX4_OpenFee_event

ApolloX5_PredictAndBet_event

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event

​Tables

​ApolloX3_CloseFee_event

​ApolloX3_CloseTradeSuccessful_event

​ApolloX3_ExecuteCloseSuccessful_event

​ApolloX3_OpenFee_event

​ApolloX3_OpenMarketTrade_event

​ApolloX4_CloseFee_event

​ApolloX4_OpenFee_event

​ApolloX5_PredictAndBet_event

​ApolloX5_PredictionCloseFee_event

​ApolloX5_SettlePredictionSuccessful_event

Tables

ApolloX3_CloseFee_event

ApolloX3_CloseTradeSuccessful_event

ApolloX3_ExecuteCloseSuccessful_event

ApolloX3_OpenFee_event

ApolloX3_OpenMarketTrade_event

ApolloX4_CloseFee_event

ApolloX4_OpenFee_event

ApolloX5_PredictAndBet_event

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event