apollox_v1_bsc

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	in_daoAmount	block_timestamp	in_brokerAmount	in_alpPoolAmount	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	100	1	2520000000000000	34650186	252000000000000	2023-12-25T02:13:41.000Z	756000000000000	1008000000000000	0xaa35533935c8f5c3856e44a4488006d6f8112691d77abfbc9b4ead9e51dc2cd9
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	101	1	6000000000000000	34653576	600000000000000	2023-12-25T05:03:45.000Z	1800000000000000	2400000000000000	0x26d8dbe37d4ffc513f4adb6aba0465a1be81cadb05c0faecd7609d2bdd110531
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	176	1	15000000000000000	34647741	1500000000000000	2023-12-25T00:11:24.000Z	4500000000000000	6000000000000000	0xb5b9bde292660044c9e60be18ec0106e8fbc13520c91308e5ae55b2f46e769ba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v1_bsc.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_endPrice	block_number	block_timestamp	in_profitOrLoss	transaction_hash
4816	false	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	160	3732136643064	33540903	2023-11-16T10:43:42.000Z	50000000000000000	0x2d6460bad222d2d17944682b895c17ecead3c4790f849558a0e1e7b2342f262f
4817	false	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	237	3732589278159	33540937	2023-11-16T10:45:24.000Z	50000000000000000	0xf428099ce2756d75a68df772e2b743f195b893cadf3c5787b6bafb821d2ba7d2
4847	false	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	161	3727964493236	33542685	2023-11-16T12:12:50.000Z	100000000000000000	0x88d11863789883c91e4dbfb15f9a5c8712ef4d686b4ff2419c3084659a71e6eb

Example Query

Query with partition filter

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

ApolloXDiamond_CloseFee_event

Fee distribution records from position closures on ApolloX perpetual futures protocol on BSC. Tracks total fees, DAO allocation (10%), and broker commission (70%) split in USDT for analyzing revenue sharing and broker performance.

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	in_daoAmount	block_timestamp	in_brokerAmount	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	46	1	45639148225798097603	28184948	4563914822579809760	2023-05-13T21:18:54.000Z	31947403758058668322	0x3b1a4a8384672082ee0f22efe9b3408eab001fe9041cfa47837cb41be8dd07b7
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	17	1	96338108760233135699	28187948	9633810876023313569	2023-05-13T23:48:56.000Z	67436676132163194989	0x93735d629f72adf4b81a0bb01dba1957bcfb2fc0bcc013001b2043fc248adefc
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	80	1	2210296663662896316	28164506	221029666366289631	2023-05-13T04:15:35.000Z	1547207664564027421	0xf8cea0caaf7a0348396fa4916e0a6621b67fbe3100533e1a68405f1c066d9ef3

Example Query

Query with partition filter

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

ApolloXDiamond_CloseTradeSuccessful_event

Successful position closure events from ApolloX perpetual futures protocol on BNB Smart Chain (BSC). Records final profit/loss, closing price, fees paid, and funding rate charges for analyzing trader performance and platform 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_closeInfo`	`STRUCT<closePrice STRING, fundingFee STRING, closeFee STRING, pnl 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
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x08d5671abf5942387fcb95b55e14e27e1affe80f	false	56	28192395	{“pnl”:“-3681568097739574297”,“closeFee”:“555839174688735182”,“closePrice”:“2684311645263”,“fundingFee”:“54919996720091851”}	0xc48748993eb7af2a1a5ce1aa96e9a971a8eebc9361664bcc4785b5f5ad682096	2023-05-14T03:31:47.000Z	0x13bce02b9bd289cd5a5482626dfde3689a7e00129c6daa13615bbb6bf81826d0
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x115667fb60cd06e20b73899eb6d0bfbecc55b063	false	64	28204392	{“pnl”:“1702358549655077791”,“closeFee”:“791847606670240661”,“closePrice”:“2686056037746”,“fundingFee”:“-752670256439748442”}	0xba80ecebd2c865d22d821ed01089b23514689ea3d1cf609e2385fef9874ba2d4	2023-05-14T13:32:21.000Z	0x0b35f0d25ca86ad76cdb37ef565566b4435ded0e5e27c8d67e296cf04323f858
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x147bb7ce9a1d5464209ebe6bde90569af0eb7894	false	55	28208397	{“pnl”:“-229487890618891017976”,“closeFee”:“23101149863370740990”,“closePrice”:“2701436231566”,“fundingFee”:“213303350434559857”}	0x956239e802bc158f68feaadb7ae96a4502363fbdbc78fe95142e94995d35bdfd	2023-05-14T16:53:02.000Z	0x7e36cecd6754db7d5a94ee07a865559a08be30592c3236c254481f69cb49a6ba

Example Query

Query with partition filter

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

ApolloXDiamond_ExecuteCloseSuccessful_event

Successful position closure events from ApolloX perpetual futures protocol on BNB Smart Chain. Records profit/loss, fees, and execution prices for analyzing trader performance and close order execution behavior.

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>`	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
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0xa1553d55343a2fce4150334a7da7b5656320d114	false	146	27583323	{“pnl”:“384054223202988423”,“closeFee”:“4273293794287023458”,“closePrice”:“2786187041727”,“fundingFee”:“1427005748154788”}	0xce00dcf867d8be54ea8fe8b1ca0cabc1325495264ebd418dd3f12389dbdb7bdb	2023-04-22T23:09:54.000Z	0	0xf94aae945513b8575d064139289037a5222393abf741a3c5d93aecfdd8d5c4a4
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x78569371de82cc723b9f65fad1575b52d7310173	false	114	27575969	{“pnl”:“772288286565510743942”,“closeFee”:“35394991764794351817”,“closePrice”:“32975599380”,“fundingFee”:“-50789663991681141855”}	0xa656d4ce4cb3c632df4f4922366e924c9c8fc05b19817cf4f3f7198600798167	2023-04-22T17:01:36.000Z	0	0xbe67e30f00556ea11809eec083b416ea944b61c66b1a9c26ab26b301aac286ad
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0xcf0dcc80f6e15604e258138cca455a040ecb4605	false	184	27573356	{“pnl”:“-7524177238925613006”,“closeFee”:“1679682039874380647”,“closePrice”:“2741133642090”,“fundingFee”:“13903523152905322”}	0xfc45f9410421a95e7e0c0e26fc2f8632ff81e9ac674a34b60c91818315306a1b	2023-04-22T14:50:50.000Z	1	0x484eca31e443c4d3e71d72b065342a2a9efaf0185f74be65e33bb3448b879c4f

Example Query

Query with partition filter

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

ApolloXDiamond_OpenFee_event

Position opening fee distribution events from ApolloX perpetual futures protocol on BSC, tracking total fees collected and their split between brokers and the DAO treasury. Used for analyzing fee revenue flows and broker commission 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	in_daoAmount	block_timestamp	in_brokerAmount	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	65	1	189187875316535331420	28254100	18918787531653533142	2023-05-16T07:02:59.000Z	132431512721574731994	0xf6fec3fcd9a51fbcf6f3d486d64ad2df6a5517f10a9ff35ac1bf028c950a3c68
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	57	1	218346945497346589	28254332	21834694549734658	2023-05-16T07:14:35.000Z	152842861848142612	0x32e66fa12a30626d6ac2d373f4291e803107cf6485785b38da0bbda5110ad73b
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	79	1	218353434442434848	28254423	21835343444243484	2023-05-16T07:19:08.000Z	152847404109704393	0x500b63171ea9a0023a81a5dad5c428aa592613fa994ecd4a13c0fec497d32669

Example Query

Query with partition filter

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

ApolloXDiamond_OpenMarketTrade_event

Perpetual futures trade opening events from ApolloX DEX on BNB Smart Chain (BSC). Contains margin position details including entry price, leverage, stop-loss/take-profit levels, and funding rates for analyzing trader behavior and risk parameters.

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>`	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”:“1282271443959”,“user”:“0x126ff9300ab4a9c9208afc9d9103ddffc1729a90”,“broker”:“1”,“isLong”:false,“margin”:“4807702533676508721612”,“openFee”:“191997466323491278388”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“stopLoss”:“0”,“timestamp”:“1685672020”,“entryPrice”:“187165388448”,“takeProfit”:“175926000000”,“executionFee”:“300000000000000000”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-30387471298169935”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x126ff9300ab4a9c9208afc9d9103ddffc1729a90	false	38	28737069	0xa4eb1f5df7f5d23f9c954ef15390fae41a6b521f507ac72e3fb3882871dbd81d	2023-06-02T02:13:40.000Z	0xa254e3cc6fd3429fda688cf5391fcd1af28d4e7fcc98fbf79ef6118b152d3d5c
{“qty”:“695758759316537”,“user”:“0x21082be93ab0f2dedfd20a7ef8f1d2b0250ea93b”,“broker”:“1”,“isLong”:false,“margin”:“12010385532721503778157”,“openFee”:“28814545258221493273”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe”,“stopLoss”:“67000000”,“timestamp”:“1685724630”,“entryPrice”:“51781664”,“takeProfit”:“10000000”,“executionFee”:“299922020274728570”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“-46380275826607165”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x21082be93ab0f2dedfd20a7ef8f1d2b0250ea93b	false	63	28754578	0x6f39a699c9029684701915ae648c68e3d7bebef78791c4b26eb89274d54031c6	2023-06-02T16:50:30.000Z	0xe5dc1039309171bce066ce826d8dcceba4bd0fc26000fddba5a4ebb321aac1d6
{“qty”:“214246998143”,“user”:“0x2dff97b6b8b9abd413efd97de8fe3d0ec1281134”,“broker”:“1”,“isLong”:true,“margin”:“5579606847875105062365”,“openFee”:“465093183870535296516”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“stopLoss”:“2694310000000”,“timestamp”:“1685683273”,“entryPrice”:“2713821014494”,“takeProfit”:“2726330000000”,“executionFee”:“299968254359641119”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-6972957628423904”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x2dff97b6b8b9abd413efd97de8fe3d0ec1281134	false	58	28740813	0x62cd6ca643b2148b69041fdbe6f81a7aa2290c6b7c57aa231fb0b59e0d76a41c	2023-06-02T05:21:13.000Z	0x5d5ea2f1f55f7cf6632f0e496871836864a728b51fe6f523132e53ac7de73f7d

Example Query

Query with partition filter

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

ApolloXDiamond_CloseFee_event

ApolloXDiamond_CloseTradeSuccessful_event

ApolloXDiamond_ExecuteCloseSuccessful_event

ApolloXDiamond_OpenFee_event

ApolloXDiamond_OpenMarketTrade_event

​Tables

​ApolloX5_PredictionCloseFee_event

​ApolloX5_SettlePredictionSuccessful_event

​ApolloXDiamond_CloseFee_event

​ApolloXDiamond_CloseTradeSuccessful_event

​ApolloXDiamond_ExecuteCloseSuccessful_event

​ApolloXDiamond_OpenFee_event

​ApolloXDiamond_OpenMarketTrade_event

Tables

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event

ApolloXDiamond_CloseFee_event

ApolloXDiamond_CloseTradeSuccessful_event

ApolloXDiamond_ExecuteCloseSuccessful_event

ApolloXDiamond_OpenFee_event

ApolloXDiamond_OpenMarketTrade_event