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.

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	40	1	7419564624186834	9454416	2024-01-19T21:02:59.000Z	1854891156046708	3709782312093417	0x63b0079a98d1d6702a2ddab6d3363f051d7c4dfa33f1758760e7a490abc34e74
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	6	1	2374870339505840	9454794	2024-01-19T21:15:35.000Z	593717584876460	1187435169752920	0x6174cb38fbd7e3f2ccd12c970080455d4d148323fbd9c93ccde4f6ed8d6f5527
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0x4200000000000000000000000000000000000006	3	1	1953750826314373	9454478	2024-01-19T21:05:03.000Z	488437706578593	976875413157186	0x703fad3900aab856a5f00d87b3a769334f15420cdba1dce75c86742675036013

Example Query

Query with partition filter

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.

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

Example Query

Query with partition filter

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.

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

Example Query

Query with partition filter

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.

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	730652686830598	7973631	2023-12-16T14:23:29.000Z	182663171707649	365326343415299	0x3f68b66a4ffd5d0f8fbcf51fd05bc4f9de5dc1974c087f40223ab03697ba320c
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	1	1	0	7986744	2023-12-16T21:40:35.000Z	0	0	0x18db0ebede662f16dccab0fd860326ead206ae44745e980963294b8e3742a5c7
0x9d93e5b2364070bc9837e91833f162430246dd57	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	1	1	0	7985560	2023-12-16T21:01:07.000Z	0	0	0xcf1fe5c2aed7f55edf1eae78a3d39e04fca781b6678861eca530272c7370b310

Example Query

Query with partition filter

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.

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”:“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

Example Query

Query with partition filter

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

Overview

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

Tables

ApolloX4_CloseFee_event

ApolloX4_CloseTradeSuccessful_event

ApolloX4_ExecuteCloseSuccessful_event

ApolloX4_OpenFee_event

ApolloX4_OpenMarketTrade_event