apollox_v2_bsc

Tables

ApolloX_CloseTradeSuccessful_event

Position closure records from ApolloX perpetual futures protocol on BSC (BNB Smart Chain). Contains realized PnL (profit and loss), close prices, funding fees, and trading fees for analyzing trader performance and protocol fee revenue.

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	0x115667fb60cd06e20b73899eb6d0bfbecc55b063	false	25	28219535	{“pnl”:“-10763341877835961786”,“closeFee”:“799578373955662581”,“closePrice”:“2721374257887”,“fundingFee”:“196246482179742211”}	0xa3ee58d7d3c2784317067dd2d18ccfc1ddf15d8e051299603c021a4eea150253	2023-05-15T02:10:43.000Z	0xaebf897368fd8b482e962472da057dc7454fed2866f8bde22db11bcc5ef31683
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x126ff9300ab4a9c9208afc9d9103ddffc1729a90	false	68	28233820	{“pnl”:“84819271950571542106”,“closeFee”:“38302602647341315523”,“closePrice”:“182360820396”,“fundingFee”:“1352415838754255433”}	0xe2194c5396b470513820b62135edb1e9198a80ec5ad2450447498f03508329fb	2023-05-15T14:06:28.000Z	0x512902c0a240bbf908cb3fea29e7e01154fba99620e3fa78bedd7b9056f0c9a2
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x126ff9300ab4a9c9208afc9d9103ddffc1729a90	false	88	28234881	{“pnl”:“148818282709891597768”,“closeFee”:“38266304849280507953”,“closePrice”:“182643775899”,“fundingFee”:“266078062407870738”}	0x93db7b7646ee4cdc7eda7a2a01dc0bbb9eca14f84c65ac672298822427003484	2023-05-15T15:00:28.000Z	0x3e6502de03cc58677259df6609042e4896d6e1d70d764a8476c9fb19f16a230d

Example Query

Query with partition filter

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

ApolloX_ExecuteCloseSuccessful_event

Position closure records from ApolloX perpetual futures protocol on BNB Smart Chain. Contains PnL, fees, close prices, and funding fees for analyzing trader performance and protocol fee revenue.

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	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x796f3ab11545c29aadc05d0a6278d442d3890741	false	301	28223834	{“pnl”:“2020061443428936696”,“closeFee”:“305221682118075792”,“closePrice”:“2735860053663”,“fundingFee”:“22889559750965554”}	0x5c54b6d367e30f3a547faf0da4d11843dce8d402e7016499775632e5ce9a7aba	2023-05-15T05:46:09.000Z	0x014aecb1686e066b58dbd78c18ea8b32c9c115c42d17a32b0edb8560d88d114c
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x4a001306b26b33b4e7c54faedb02c4abc525529f	false	109	28245362	{“pnl”:“4650619538930261934”,“closeFee”:“429546608017502860”,“closePrice”:“2716914123762”,“fundingFee”:“-117821964527974008”}	0xadb1e25fe077f510c810893e01aad18d6d7df0de1170262f5311046a21e6a6c3	2023-05-15T23:45:43.000Z	0x02323f780f23996cdd861bc54c9a9ed7d40088f4084169732ba44953b14ec1f0
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0xc66d1bc13dd9dbc0a3ea3569af8b9f2f47e7fd6a	false	320	28231287	{“pnl”:“753766028246013291815”,“closeFee”:“47014550947450603663”,“closePrice”:“120672247”,“fundingFee”:“-16586716565772380554”}	0x1479cdaf75301adcc14946a48b65ce796e2c7a67bac010e40ce2e8aa718157c5	2023-05-15T11:59:42.000Z	0x0b470bb04b08c3b755f4443eb494b08ff0097e08b0a38065be270b3419075566

Example Query

Query with partition filter

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

ApolloX_OpenMarketTrade_event

Trade opening events from ApolloX perpetual futures DEX on BSC, capturing position entries with margin, leverage direction (long/short), entry price, stop-loss/take-profit levels, and funding fee rates for analyzing trader behavior and position 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>`	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”:“1114369229682”,“user”:“0x7c9cf9a8b9134bfb165fe03ebe25ca5292a88da0”,“broker”:“1”,“isLong”:false,“margin”:“10175716682391903302”,“openFee”:“24409264710313767”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0xa452dc8129bc7d39d4d297d3288b5483cf0fedc4”,“stopLoss”:“0”,“timestamp”:“1681833537”,“entryPrice”:“109566542”,“takeProfit”:“100000000”,“executionFee”:“299874052897782931”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-2164892100000000”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x7c9cf9a8b9134bfb165fe03ebe25ca5292a88da0	false	43	27459779	0xe2af95f3ae1e112355d88a9ab5998386607c853aa9348f371dab7739e9059bb8	2023-04-18T15:58:57.000Z	0x4fb431dc694e039664823e2d0e5bdfaf97edfcf9ac454bd4c40a19dff7bcf417
{“qty”:“1120387101973”,“user”:“0xb7ad297aef420cda48e5a319b11513d889cc8d95”,“broker”:“1”,“isLong”:false,“margin”:“7675563021612248975”,“openFee”:“24547805430509104”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0xa452dc8129bc7d39d4d297d3288b5483cf0fedc4”,“stopLoss”:“0”,“timestamp”:“1681834205”,“entryPrice”:“109591039”,“takeProfit”:“102000000”,“executionFee”:“299889172957241921”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-2169265500000000”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0xb7ad297aef420cda48e5a319b11513d889cc8d95	false	146	27460001	0x313f28c5aa2ad1b6b2390c16c815482e9cb7599651eb347fd2b10c2564353fa1	2023-04-18T16:10:05.000Z	0x8951b51e2fee731c1190e4df0e17ffcb623b5540d5fe4555176f98415d27a960
{“qty”:“2343732719190”,“user”:“0x6bc71979c3263585ab0eebe794a6e801c6f24022”,“broker”:“1”,“isLong”:false,“margin”:“7548791420140666287”,“openFee”:“51298552867431284”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0xa452dc8129bc7d39d4d297d3288b5483cf0fedc4”,“stopLoss”:“0”,“timestamp”:“1681825074”,“entryPrice”:“109470551”,“takeProfit”:“106000000”,“executionFee”:“299910026991902429”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-2109574500000000”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x6bc71979c3263585ab0eebe794a6e801c6f24022	false	15	27456971	0xf05e3dc179a4e51d908b956cff1858cd743ff3449773e5f6e18d91866bc35230	2023-04-18T13:37:54.000Z	0xa8a65e251e5db9b39997cebbd4943c862394ea9e0cba19f6cd781be78b7105f6

Example Query

Query with partition filter

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

ApolloX2_ClaimApxReward_event

APX token reward claim events from ApolloX v2 perpetual DEX on BNB Smart Chain. Tracks user reward withdrawals with amounts in wei for analyzing incentive distribution and user engagement 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x11d67fa925877813b744abc0917900c2b1d6eb81	false	2333835490246579743829	244	25961659	2023-02-25T02:46:17.000Z	0x5f913947c0c135e667e0895b79bbd55f9434533d635acb36a442c60f6a39d3b8
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x2dff97b6b8b9abd413efd97de8fe3d0ec1281134	false	3912841624081627665540	165	25971677	2023-02-25T11:15:27.000Z	0xee376f02830e0979e610805959554635a6ec6c9e773cb71f1f7246d7fb5762fe
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x6ed98e873437645904e9977291d8f3a6c4548c13	false	15583297560226036119998	51	25969116	2023-02-25T09:05:23.000Z	0x273efc5bc87ea702452ff222edf130523558c34ae1da11940d09aa3c43c144bb

Example Query

Query with partition filter

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

ApolloX2_CloseFee_event

Position closing fee distribution events from ApolloX perpetual futures protocol on BSC, showing total fees collected and splits between DAO treasury and broker referrals. Used for analyzing fee revenue, broker performance, and protocol economics.

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	10	1	22244870130239563697	28768246	2224487013023956369	2023-06-03T04:14:36.000Z	15571409091167694587	0xe9b2eeb811bf64b57da3a5cf6f06962252d510b6cf9f7153fcdf31ef3ca61ffd
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	16	1	22244164355443539088	28767944	2224416435544353908	2023-06-03T03:59:29.000Z	15570915048810477361	0x71e5e9bdb3c530821408cd62a3b0ef23add193a0e6de40bf1a1129a078eab94e
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	17	1	22243861261637313254	28767978	2224386126163731325	2023-06-03T04:01:11.000Z	15570702883146119277	0xfa1a72dc585b53585e101be99ab17104e872e69a9daece54249d0102d78807ea

Example Query

Query with partition filter

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

ApolloX2_CloseTradeSuccessful_event

Trade closure records from ApolloX v2 perpetual futures protocol on BSC. Contains profit/loss, fees, and execution prices for analyzing trader performance and position liquidations.

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	0x031f16aa9709bb662ad7216addf34efaffd4b076	false	115	28247306	{“pnl”:“258857198274346179777”,“closeFee”:“14892943521851538626”,“closePrice”:“2703678206207”,“fundingFee”:“-8221978210193324207”}	0x74a3fbc3377ab0e03d25b34015a31cde79f0daf84a1931f87f1f512cc891fe3d	2023-05-16T01:23:06.000Z	0x214c022dc19dc94c090bf756f144a86794e38f29df98dfc56b169f2077c07461
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x031f16aa9709bb662ad7216addf34efaffd4b076	false	41	28264403	{“pnl”:“170205370191143650527”,“closeFee”:“6770661402606496770”,“closePrice”:“66528202”,“fundingFee”:“-10652570484774101303”}	0xfdb7b2d4cb15eb1c211c684da44359b497a73369ed2aa46a3fe12d49ae4bff5d	2023-05-16T15:39:21.000Z	0xcd01ce6bcd3a234ca7b6a4593e12a616d7e6432b1d621b668b0f959821f850a4
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x126ff9300ab4a9c9208afc9d9103ddffc1729a90	false	74	28254413	{“pnl”:“150671988050868879451”,“closeFee”:“73675363969289385176”,“closePrice”:“181805390826”,“fundingFee”:“-1752866918739231653”}	0xbf4634b7036daac967c4deefdaf8504bd44370e607a7c5af77cfa8f3e370fc77	2023-05-16T07:18:38.000Z	0x22e95ac16bfff4ba12e4e8747729e1218ad93d817bc15f436ec4f9b564617418

Example Query

Query with partition filter

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

ApolloX2_ExecuteCloseSuccessful_event

Successful position close events from ApolloX V2 perpetual futures protocol on BNB Smart Chain. Contains PNL (profit and loss), close price, fees, and execution type data for analyzing trader profitability 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_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	0x438b1bf9b869e4b6af6c99e0f8e106b25ec8452d	false	154	27420701	{“pnl”:“-3922517585889358”,“closeFee”:“102605768455040870”,“closePrice”:“2994076393703”,“fundingFee”:“-425933509264946”}	0x3a1202706d81b758d7d8473a3e03b10f762cf08e4155e6d8194f7c900957d188	2023-04-17T07:19:39.000Z	0	0x4bdf15c727bd4a2390d55371daf489e4b632317580fb6b76299331f254284a2a
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x438b1bf9b869e4b6af6c99e0f8e106b25ec8452d	false	223	27425799	{“pnl”:“1729617119278093999”,“closeFee”:“101214123530619649”,“closePrice”:“2949596203981”,“fundingFee”:“-8763670737235722”}	0x0f3d355a75f1788aec24c2e15e9f523e2ca0cf8ef86a79a9ae143ae8062814c3	2023-04-17T11:35:01.000Z	0	0xb5dc90f4409b56d3e16e185bd9b58dd43bc9071d5032d5fb28856931c2c6870d
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x2ec12150d15e984b8ad62ff0afb6195ad17a1f76	false	230	27425799	{“pnl”:“-1855973151742078633”,“closeFee”:“82600348820374416”,“closePrice”:“2949006343726”,“fundingFee”:“-10918401910090549”}	0xe211aaf71318bb868f93cdc04c3f4e77e6871a9a21f70a9b8c8d89a74383a77e	2023-04-17T11:35:01.000Z	1	0xb5dc90f4409b56d3e16e185bd9b58dd43bc9071d5032d5fb28856931c2c6870d

Example Query

Query with partition filter

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

ApolloX2_OpenFee_event

Position opening fee events from ApolloX v2 perpetual futures protocol on BSC. Tracks fee distribution between brokers and DAO (decentralized autonomous organization) treasury across different collateral tokens for analyzing revenue sharing and trading costs.

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	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	23	1	4122102959201944831	29883112	412210295920194483	2023-07-11T23:56:23.000Z	2885472071441361381	0x88ad917f5f3c508611f98a89fc1e3782380061a156025343968664188141ef03
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	31	1	74639864237942013741	29856254	7463986423794201374	2023-07-11T01:29:12.000Z	52247904966559409618	0xa2e788dfbec505c95e8be6bd7548438219f9c0f5282ebfbcc5a62cce4afbc128
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	36	1	74624937757748679321	29856254	7462493775774867932	2023-07-11T01:29:12.000Z	52237456430424075524	0xa2e788dfbec505c95e8be6bd7548438219f9c0f5282ebfbcc5a62cce4afbc128

Example Query

Query with partition filter

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

ApolloX2_OpenMarketTrade_event

Trade opening events from ApolloX V2 perpetual futures protocol on BSC. Contains position entry data including margin, leverage, entry price, take-profit/stop-loss levels, and funding fees for tracking leveraged 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_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”:“125894227936”,“user”:“0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5”,“broker”:“2”,“isLong”:false,“margin”:“28944566909439190192”,“openFee”:“1155417687770030530”,“tokenIn”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“pairBase”:“0x8ff795a6f4d97e7887c79bea79aba5cc76444adf”,“stopLoss”:“0”,“timestamp”:“1685777326”,“entryPrice”:“11471518468”,“takeProfit”:“10783000000”,“executionFee”:“300015402790779278”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“0”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5	false	38	28772128	0x8cf56ec545f8a1f9129c3d047db90cb3673622f4e940bea555994bde9415baea	2023-06-03T07:28:46.000Z	0xe083aedee4dd5f562c173a8fd4fbc01bc52096c357043a14da6bb6122e3f9d2b
{“qty”:“82265459757”,“user”:“0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5”,“broker”:“2”,“isLong”:false,“margin”:“18943931410292524760”,“openFee”:“756038586707175210”,“tokenIn”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“pairBase”:“0x8ff795a6f4d97e7887c79bea79aba5cc76444adf”,“stopLoss”:“0”,“timestamp”:“1685781457”,“entryPrice”:“11486640096”,“takeProfit”:“10797000000”,“executionFee”:“300030003000300030”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“55768500000000”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5	false	71	28773505	0x68118953214c72293a8346c3326e018d9bc9842fc87759d56bcf707fe543d62c	2023-06-03T08:37:37.000Z	0x376755dd3f419200f951429fc475472b5cf48e3acb571e52c749c09f4fd29a41
{“qty”:“32096575964”,“user”:“0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5”,“broker”:“2”,“isLong”:false,“margin”:“7404834450657736126”,“openFee”:“295135546341963844”,“tokenIn”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“pairBase”:“0x8ff795a6f4d97e7887c79bea79aba5cc76444adf”,“stopLoss”:“0”,“timestamp”:“1685791043”,“entryPrice”:“11492893865”,“takeProfit”:“10806000000”,“executionFee”:“300030003000300030”,“userOpenTradeIndex”:“2”,“longAccFundingFeePerShare”:“184882500000000”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x1883159cd5ab29fecb338e0c4ee36d81dc0ec7f5	false	31	28776693	0x74db8a876039dc56c9630624e01491256e02e04ab718c4646ef70bbaac1e661a	2023-06-03T11:17:23.000Z	0x65b0d895eaca1cd4dcdbe98ca11076abbcf8226b2de07be90dee52bb4a641a25

Example Query

Query with partition filter

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

ApolloX3_CloseTradeSuccessful_event

Closed trade events from ApolloX perpetual futures protocol on BNB Smart Chain. Contains profit/loss calculations, fees (close, funding, holding), and execution prices for analyzing trading outcomes and fee structure.

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
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x01bd519a2e28af2f2d8f8763e9fbbbb2f2b4b751	false	80	32454464	{“pnl”:“143877387388290182346”,“closeFee”:“21581608108243527351”,“closePrice”:“2752471995012”,“fundingFee”:“-131584740468912169”,“holdingFee”:“65649643866166901”}	0x4322fbab0a7da114925bb68a71b1357293662ededcf89f1b301846da048d0669	2023-10-09T13:59:27.000Z	0x003e12402b19b97951a3a0d0b6b11c11f434ee15cb5af6dbfc6bd157dd7295bc
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x01bd519a2e28af2f2d8f8763e9fbbbb2f2b4b751	false	88	32439629	{“pnl”:“88479058862235296788”,“closeFee”:“19662792041609492342”,“closePrice”:“2785727469001”,“fundingFee”:“96026520858272892”,“holdingFee”:“86137675981064271”}	0x46f2823a56fcbcc388d693d5baf86b5977814bcb7ded2d827f14f19978455259	2023-10-09T01:34:34.000Z	0xf2f9ebcdfe69a8ffeb0efb01abbf3d72acc6d467baebf3e73240db47f1246e54
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x01bd519a2e28af2f2d8f8763e9fbbbb2f2b4b751	false	15	32441757	{“pnl”:“103548690526298613637”,“closeFee”:“28555540473503048542”,“closePrice”:“2792941438273”,“fundingFee”:“-125263637615631482”,“holdingFee”:“98147344110269220”}	0xaa40d46a6f47e37e12047dd39df66045e3bd598f158c0c1084abcf4b9b5d13ca	2023-10-09T03:21:17.000Z	0x08811c47c4337e3630fa2392e2019cc13a4fdaf389c70fa308ea1d1d39208f10

Example Query

Query with partition filter

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

ApolloX3_ExecuteCloseSuccessful_event

Successful position closure events from ApolloX perpetual futures protocol on BSC, including PnL (profit and loss), execution price, and fee breakdowns (close, funding, holding fees). Used for analyzing trader performance, fee impact, and execution types across perpetual futures 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_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
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x3c0b275cf0f23d6764ec451f14777255fa5ec3b1	false	916	29754670	{“pnl”:“166549265083127947083”,“closeFee”:“8794138369089450424”,“closePrice”:“156492”,“fundingFee”:“-1546027784867231226”,“holdingFee”:“237373588164606449”}	0x9bac640eaad677fd25b32bf8e0aa7ecd86bb6742510b45a671f582180c029c38	2023-07-07T12:34:44.000Z	0x2c33537cbffc110f5264790537157eb8ad3f76ccda03ffe9311668ddc8923c30
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x14f4e32455e394f4d45836b9befa524f798c49de	false	353	29754598	{“pnl”:“8200878435707714352”,“closeFee”:“1021454926116526575”,“closePrice”:“3024978462602”,“fundingFee”:“-73363308735831683”,“holdingFee”:“62886651933216456”}	0x96610b40eb3e157601b87ab3c2f4d0dafd9de6824fbc24dc517ce898aedbde83	2023-07-07T12:31:06.000Z	0x51971755949c69201cff18ab05d56997c5e92ac46ebe373c6ba48c197d991bfd
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0xa90e29825dbfd63bb51d02473ae995dd67377470	false	130	29756325	{“pnl”:“137468083106606328205”,“closeFee”:“8041368197373140524”,“closePrice”:“3039012021847”,“fundingFee”:“-2256048998704827847”,“holdingFee”:“0”}	0xc54591319a2ea6288df150f7dd6d031b08cf63c71c8c533560d0dbf2672ded69	2023-07-07T13:57:36.000Z	0xe8385c06edf1dde6b4f041a3cd61351a6334e471c681a23c0f229c86f99e399b

Example Query

Query with partition filter

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

ApolloX3_OpenMarketTrade_event

Perpetual futures position opening events from ApolloX v2 protocol on BSC. Records long and short trade executions with margin, leverage, entry price, stop-loss, take-profit levels, and funding fee data for trading activity analysis.

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”:“1736079486155”,“user”:“0x58ac8229c56be81fc34ee7ccd08260f17a9ceb89”,“broker”:“2”,“isLong”:true,“margin”:“8578376596585162332”,“openFee”:“171577811487144255”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82”,“stopLoss”:“0”,“openBlock”:“31429289”,“timestamp”:“1693773937”,“entryPrice”:“123519503”,“takeProfit”:“138340000”,“executionFee”:“300045591927693413”,“holdingFeeRate”:“9500”,“userOpenTradeIndex”:“1”,“longAccFundingFeePerShare”:“-16161009586860930”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x58ac8229c56be81fc34ee7ccd08260f17a9ceb89	false	28	31429289	0x357e7b9e57143d6c7b3338053acc6ed52f853f6a19fc2daea738c665ff6f8aac	2023-09-03T20:45:37.000Z	0x43d10e9e037753ca87de729980c27e1d3b58bb49f0b6f1330f738426199742af
{“qty”:“35983690433030”,“user”:“0x97053a3c91f09a44cf6ac15d9e6948c3c7b1d505”,“broker”:“2”,“isLong”:true,“margin”:“98803238128891405274”,“openFee”:“3556736017880822089”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82”,“stopLoss”:“0”,“openBlock”:“31413126”,“timestamp”:“1693725295”,“entryPrice”:“123543107”,“takeProfit”:“131770000”,“executionFee”:“300025853227772637”,“holdingFeeRate”:“9500”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-16344099444858494”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x97053a3c91f09a44cf6ac15d9e6948c3c7b1d505	false	45	31413126	0xc90d03daebbbe37d85a9e5beaa1829aa1c0429e48eab765f45c44808ffa3b1fc	2023-09-03T07:14:55.000Z	0x2ada29fce7b5ee616d20b27ca018a2cbfbfec14cd70f60f4f5cb631dbc580621
{“qty”:“1070495773383”,“user”:“0x813eff0f183826fcbf36feb3ab9322a646c6caca”,“broker”:“3”,“isLong”:true,“margin”:“35380687213524783601”,“openFee”:“849245484380029470”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“pairBase”:“0x1ce0c2827e2ef14d5c4f29a091d735a204794041”,“stopLoss”:“970000000”,“openBlock”:“31429477”,“timestamp”:“1693774501”,“entryPrice”:“991427323”,“takeProfit”:“1090000000”,“executionFee”:“300067302095186929”,“holdingFeeRate”:“9500”,“userOpenTradeIndex”:“0”,“longAccFundingFeePerShare”:“-94507638784382710”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x813eff0f183826fcbf36feb3ab9322a646c6caca	false	55	31429477	0xaec8deb9cb4f626f2f4ba0b3944666d6d35ba52946ada6d41ffa261abcbfdde3	2023-09-03T20:55:01.000Z	0x086ddc0872b8bb664932e28c7a00256efce0fa399b571aadb8b9541dc8524a17

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_bsc.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	in_daoAmount	block_timestamp	in_brokerAmount	in_alpPoolAmount	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	515	1	962726244548268659	32655029	96272624454826865	2023-10-16T13:44:10.000Z	481363122274134329	385090497819307463	0xbe940d5aded9927bdf3ebc82a6b330e38802c859f4864cdccf47f60b93962660
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	775	1	5886868307999019339	32655000	588686830799901933	2023-10-16T13:42:43.000Z	2943434153999509669	2354747323199607735	0x0d848c0dcc6d572b2ad40ec2c7ddf51d5cb37e63cae6d7bf9669c5e4434521d6
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	266	1	9503929095613989911	32660149	950392909561398991	2023-10-16T18:00:20.000Z	4751964547806994955	3801571638245595964	0x4206ca4161be0a235fd38d3214ee289273506a98e807667b9323d0f2de4db329

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_bsc.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
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	77	1	32473746	2023-10-10T06:05:55.000Z	0x8dabb5dc3bc342a3e4717242c45cc5fe88d8b9457310e83e9a4251a1eccc5b1e
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x2170ed0880ac9a755fd29b2688956bd959f933f8	40	1	32479241	2023-10-10T10:44:04.000Z	0xaf22286da5edee692bb9ce327d4320c66d516eac455a5577505925d2921c66a0
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0x55d398326f99059ff775485246999027b3197955	101	1	32487455	2023-10-10T17:36:59.000Z	0x032b22b5243b572956959d846a3da4de31d588326e2eed87f7812148028c0a6b

Example Query

Query with partition filter

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

ApolloX5_PredictAndBet_event

Price prediction bet placements from ApolloX binary options protocol on BNB Smart Chain. Records user wagers with direction (up/down), entry price, bet amount in USD stablecoins, 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>`	Nested record containing the full details of a prediction bet placed by the user, including direction (isUp/isDown), bet amount, entry price, and trading pair. Contains all parameters needed to track and settle the user’s price prediction wager.

Sample Data

in_id	in_op	address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash
7451	{“isUp”:false,“user”:“0x05ea5175edff21aac32b7354b6df540ce56660fa”,“broker”:“5”,“period”:0,“openFee”:“0”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“betAmount”:“10000000000000000000”,“startTime”:“1700598553”,“entryPrice”:“3697746604788”,“betAmountUsd”:“10002218600000000000”,“predictionPairBase”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“userOpenPredictIndex”:“0”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x05ea5175edff21aac32b7354b6df540ce56660fa	false	41	33696033	2023-11-21T20:29:13.000Z	0x8dcaa0a8c7f17271c77b5b2b83ba9d1991e2eb8f0d70fe96ef3931a948d8a758
7452	{“isUp”:true,“user”:“0x05ea5175edff21aac32b7354b6df540ce56660fa”,“broker”:“5”,“period”:2,“openFee”:“0”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“betAmount”:“10000000000000000000”,“startTime”:“1700599163”,“entryPrice”:“3702355594312”,“betAmountUsd”:“10002218600000000000”,“predictionPairBase”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“userOpenPredictIndex”:“0”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x05ea5175edff21aac32b7354b6df540ce56660fa	false	78	33696236	2023-11-21T20:39:23.000Z	0x12ebf94d6187dc6e996d1f1f4b3ee01f36714f758a79602395e1ad42c4a1f3cb
7276	{“isUp”:false,“user”:“0x05ea5175edff21aac32b7354b6df540ce56660fa”,“broker”:“5”,“period”:1,“openFee”:“0”,“tokenIn”:“0x55d398326f99059ff775485246999027b3197955”,“betAmount”:“10000000000000000000”,“startTime”:“1700576997”,“entryPrice”:“3689498158876”,“betAmountUsd”:“10002991900000000000”,“predictionPairBase”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“userOpenPredictIndex”:“0”}	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	0x05ea5175edff21aac32b7354b6df540ce56660fa	false	47	33688870	2023-11-21T14:29:57.000Z	0x40daeca8a37be1a7ee0391bdf6654bfbd51d27a7a46a1b4aeaaa4e966aa3cb8d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_bsc.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	in_daoAmount	block_timestamp	in_brokerAmount	in_alpPoolAmount	transaction_hash
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	156	1	2688000000000000	33929959	268800000000000	2023-11-30T00:03:34.000Z	1344000000000000	1075200000000000	0x0780e46841d7531c23dbf8c940ca6291892d956834a41f3135459f3de4dfa610
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	136	1	3000000000000000	33937057	300000000000000	2023-11-30T06:02:16.000Z	1500000000000000	1200000000000000	0x84eab1fc278c67787bb5827633dd00a1d674c48312d08d7f93443e6a062af36e
0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	169	1	3000000000000000	33937635	300000000000000	2023-11-30T06:31:13.000Z	1500000000000000	1200000000000000	0x74cde405b58fb8a5a89b36c84312458a27fc3d635ad96c088d56fe4847ca2cf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apollox_v2_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_closeFee	in_endPrice	block_number	block_timestamp	in_profitOrLoss	transaction_hash
344	true	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	101	2017980000000000	3711939532229	33391637	2023-11-11T05:51:11.000Z	20197980000000000	0x8861d1b546a94e81e9dac927d4dfa173122e4eefa64520537592eb2a2906f413
356	true	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	154	2997000000000000	3696164396241	33398201	2023-11-11T11:20:21.000Z	29997000000000000	0xaab91de584c83dde118d37a688c354ff52c436dae366b5591d5fa7457ff5a8f5
362	true	0x1b6f2d3844c6ae7d56ceb3c3643b9060ba28feb0	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	280	7992000000000000	3704994424302	33399647	2023-11-11T12:33:04.000Z	79992000000000000	0x9dacd4a43b487a92c8aaf253f3aa4b4c4c2157d982c7363f860be5484e6511bf

Example Query

Query with partition filter

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

APXLPStaking_RewardClaimed_event

Reward claim events from ApolloX LP staking contract on BSC, capturing user addresses and claimed reward amounts in wei. Used for tracking liquidity provider earnings and analyzing staking reward distribution 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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x60d910f9de5c6fd2171716042af2fd3d2aa9d942	0xd03da3272d6197be9e13874ba6faa1a87a9b01c6	false	1153340247923510541291	112	27239867	2023-04-10T23:53:03.000Z	0xbbd5e5b56070a04edd1c2a2f190857bea79aa19d985667ebe3d729a227aae670
0x60d910f9de5c6fd2171716042af2fd3d2aa9d942	0x1a7e8bf2c5818933998de7cdb0314d915bcda4d0	false	146061006664004938979	158	27226124	2023-04-10T12:21:38.000Z	0x2c76b3b5bcde2e8b7243bad8bf3d82f2af1ad600a984c6674bd7528b95bd21c8
0x60d910f9de5c6fd2171716042af2fd3d2aa9d942	0x438b1bf9b869e4b6af6c99e0f8e106b25ec8452d	false	4747577794940602699072	130	30367090	2023-07-28T20:23:35.000Z	0x0ad1bc4101bd5971e97b865329b900af13c93072baa2beb75b551f5f6b84b80c

Example Query

Query with partition filter

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

DaoFeeDistributor_Claimed_event

Fee claim events from ApolloX DAO (Decentralized Autonomous Organization) fee distributor contract on BNB Smart Chain, tracking epoch-based reward distributions to token holders. Records individual claim transactions with token IDs, claimed amounts, and epoch parameters for analyzing DAO revenue sharing and participant 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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_claim_epoch`	`STRING`	Epoch number being claimed by the token holder in this distribution event. Represents the specific reward period for which fees are being distributed to the NFT position.
`in_max_epoch`	`STRING`	Highest epoch number available for claiming at the time of this claim event. Represents the maximum claimable period boundary for the token holder’s position.

Sample Data

address	removed	in_amount	log_index	in_tokenId	block_number	in_max_epoch	in_claim_epoch	block_timestamp	transaction_hash
0xca0e6dcc3b062b149ce5cb1545afa18bb9fb339c	false	866269126620435601470	221	261	20717686	1	1	2022-08-24T09:06:28.000Z	0xf00248f319d7d0ab0a000f00dd8c04502d420785bf57dd50574c5e9891455e2d
0xca0e6dcc3b062b149ce5cb1545afa18bb9fb339c	false	1460749582632460909445	120	256	20717650	1	1	2022-08-24T09:04:40.000Z	0x36e0851f37aba511d0aaf827f64019b3fd00c31bd728422c1c3ddf5b1f6c996c
0xca0e6dcc3b062b149ce5cb1545afa18bb9fb339c	false	4007063822757474136748	119	145	20717650	2	2	2022-08-24T09:04:40.000Z	0x36e0851f37aba511d0aaf827f64019b3fd00c31bd728422c1c3ddf5b1f6c996c

Example Query

Query with partition filter

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

TradingRewardDistributor_Claimed_event

Trading reward claim events from ApolloX perpetual futures protocol on BSC. Records user reward withdrawals including claim amounts, recipient addresses, and payout currency for analyzing incentive distribution and user engagement.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isETH`	`BOOL`	Flag indicating whether the claimed reward was distributed in native ETH rather than a token. Always false in these BSC samples, suggesting rewards are distributed as ERC-20 tokens.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_reservedAmount`	`STRING`	Amount of tokens reserved or withheld from the claim, specified in smallest token units (wei for 18-decimal tokens). Typically zero when full reward amounts are distributed to recipients.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.

Sample Data

in_id	in_to	address	removed	in_isETH	in_amount	log_index	in_currency	in_deadline	block_number	block_timestamp	transaction_hash
567240554517893120	0x4e4604992f744520e9b46b3c5ef36a62282710b2	0x6be863e01e17a226c945e3629d0d9cb6e52ce90e	false	false	14551527880000000000	229	0x78f5d389f5cdccfc41594abab4b0ed02f31398b3	1650005787	16960730	2022-04-15T06:51:44.000Z	0xfbed53878ef2b08fe26830b08883ba681152041c853af998e45ec3a2bbfe0d9a
567191679435653120	0x2dff97b6b8b9abd413efd97de8fe3d0ec1281134	0x6be863e01e17a226c945e3629d0d9cb6e52ce90e	false	false	3000033153550000000000	184	0x78f5d389f5cdccfc41594abab4b0ed02f31398b3	1649994134	16956851	2022-04-15T03:37:26.000Z	0x742da2ac5ab32b4d30a762f6afd68696002837a91fe524c9a434ad95762734d3
567195516957544448	0xe5fbbdfd081aad4913eb25e4b195ba15c2d64de5	0x6be863e01e17a226c945e3629d0d9cb6e52ce90e	false	false	1017488075660000000000	236	0x78f5d389f5cdccfc41594abab4b0ed02f31398b3	1649995049	16957156	2022-04-15T03:52:41.000Z	0x85d0540c84859c2710612205a85f52a247f61714ccb42d2b2dacb4f0fc9d278c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ApolloX_CloseTradeSuccessful_event

ApolloX_ExecuteCloseSuccessful_event

ApolloX_OpenMarketTrade_event

ApolloX2_ClaimApxReward_event

ApolloX2_CloseFee_event

ApolloX2_CloseTradeSuccessful_event

ApolloX2_ExecuteCloseSuccessful_event

ApolloX2_OpenFee_event

ApolloX2_OpenMarketTrade_event

ApolloX3_CloseTradeSuccessful_event

ApolloX3_ExecuteCloseSuccessful_event

ApolloX3_OpenMarketTrade_event

ApolloX4_CloseFee_event

ApolloX4_OpenFee_event

ApolloX5_PredictAndBet_event

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event

APXLPStaking_RewardClaimed_event

DaoFeeDistributor_Claimed_event

TradingRewardDistributor_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ApolloX_CloseTradeSuccessful_event

​ApolloX_ExecuteCloseSuccessful_event

​ApolloX_OpenMarketTrade_event

​ApolloX2_ClaimApxReward_event

​ApolloX2_CloseFee_event

​ApolloX2_CloseTradeSuccessful_event

​ApolloX2_ExecuteCloseSuccessful_event

​ApolloX2_OpenFee_event

​ApolloX2_OpenMarketTrade_event

​ApolloX3_CloseTradeSuccessful_event

​ApolloX3_ExecuteCloseSuccessful_event

​ApolloX3_OpenMarketTrade_event

​ApolloX4_CloseFee_event

​ApolloX4_OpenFee_event

​ApolloX5_PredictAndBet_event

​ApolloX5_PredictionCloseFee_event

​ApolloX5_SettlePredictionSuccessful_event

​APXLPStaking_RewardClaimed_event

​DaoFeeDistributor_Claimed_event

​TradingRewardDistributor_Claimed_event

Tables

ApolloX_CloseTradeSuccessful_event

ApolloX_ExecuteCloseSuccessful_event

ApolloX_OpenMarketTrade_event

ApolloX2_ClaimApxReward_event

ApolloX2_CloseFee_event

ApolloX2_CloseTradeSuccessful_event

ApolloX2_ExecuteCloseSuccessful_event

ApolloX2_OpenFee_event

ApolloX2_OpenMarketTrade_event

ApolloX3_CloseTradeSuccessful_event

ApolloX3_ExecuteCloseSuccessful_event

ApolloX3_OpenMarketTrade_event

ApolloX4_CloseFee_event

ApolloX4_OpenFee_event

ApolloX5_PredictAndBet_event

ApolloX5_PredictionCloseFee_event

ApolloX5_SettlePredictionSuccessful_event

APXLPStaking_RewardClaimed_event

DaoFeeDistributor_Claimed_event

TradingRewardDistributor_Claimed_event