Skip to main content

​
Tables

​
FeeDistributor_DepositFeeEvent_event

Fee deposit events from MerkleTrade protocol on Aptos, tracking distribution of collected fees across developer, liquidity provider (LP), and staking recipient pools. Used for analyzing protocol fee allocation and revenue distribution patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_lp_amountSTRINGAmount of fees allocated to liquidity providers (LP) in this distribution event. String-encoded integer value representing the LP share of collected protocol fees.
in_stake_amountSTRINGAmount of fees allocated to staking participants in this deposit event. String-encoded integer representing tokens distributed to the staking pool, may be zero if no staking rewards are distributed.
in_dev_amountSTRINGAmount of fees allocated to the development fund during this fee distribution event. String-encoded integer representing token units; can be zero if no dev fees were distributed in this transaction.
dataevent_typeevent_indexblock_heightin_lp_amountin_dev_amountblock_timestampin_stake_amountsequence_numbertransaction_hashevent_guid_account_addressevent_guid_creation_number
{“dev_amount”:“0”,“lp_amount”:“0”,“stake_amount”:“0”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent3191109635002024-06-16T04:36:10.500Z016781010x92a71b88239168741da7ffad1ff36bd64e272a6179c1c1a732cc8849d82e20a60x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0611
{“dev_amount”:“100650”,“lp_amount”:“587118”,“stake_amount”:“150973”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent31912404405871181006502024-06-16T13:57:45.466Z15097316793360x714bad1853387067a34a0e2e8b206ddfbe3838c7380ce4b67c532cb837a64e2b0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0611
{“dev_amount”:“106113”,“lp_amount”:“618991”,“stake_amount”:“159169”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent31912982616189911061132024-06-16T18:06:38.064Z15916916799010xa377de5c88d83d3a2bea3f2dfad83cb010c8d13eb092d23b9ef9c4ccac5180910x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0611
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.FeeDistributor_DepositFeeEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
MklToken_MklClaimEvent_event

MKL token claim events from MerkleTrade protocol on Aptos, recording community pool reward distributions with claim amounts and claimant addresses. Used for analyzing token distribution patterns and reward claiming behavior across the protocol.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_pool_typeSTRINGPool type identifier indicating the source of the claimed MKL tokens, such as COMMUNITY_POOL for community reward distributions. This field categorizes the pool from which tokens are being claimed on the Merkle Trade platform.
in_mkl_amountSTRINGAmount of MKL tokens claimed from the pool in this event. Stored as a string to preserve precision for large token amounts with decimals.
dataevent_typeevent_indexblock_heightin_pool_typein_mkl_amountblock_timestampsequence_numbertransaction_hashevent_guid_account_addressevent_guid_creation_number
{“mkl_amount”:“12183220”,“pool_type”:“COMMUNITY_POOL”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent0229235745COMMUNITY_POOL121832202024-09-21T00:25:03.033Z41350x297d0c2186d715a217df3b49233caf2aca8f9de7f86c62024d382c62a7496c0e0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0649
{“mkl_amount”:“587485”,“pool_type”:“COMMUNITY_POOL”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent0229466770COMMUNITY_POOL5874852024-09-21T13:47:23.352Z41820x31eece409e92864816e68e9f63983ee77e942fca3a813d581076683110c6b3060x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0649
{“mkl_amount”:“40165914”,“pool_type”:“COMMUNITY_POOL”}0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent0229281305COMMUNITY_POOL401659142024-09-21T03:03:02.277Z41430x5269406c486b84f92543ed40acf97b668182ec0dcb2edfee56b0f1540a3db64d0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0649
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.MklToken_MklClaimEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Referral_RebateEvent_event

Referral rebate distribution events from MerkleTrade perpetual futures protocol on Aptos, tracking rewards paid to referrers for referred trader activity. Records include rebate amounts, referrer-referee address pairs, rebate rates (basis points), and epoch timestamps for analyzing referral program performance.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_referrerSTRINGAddress that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_refereeSTRINGAptos account address of the user who was referred to the platform by a referrer. Hex-encoded, 0x-prefixed 64-character string identifying the referee in this rebate event.
in_rebateSTRINGRebate amount earned by the referrer in token base units from the referred user’s trading activity. Values typically range from millions of smallest token units, indicating fee-based rewards.
in_rebate_rateSTRINGPercentage rate applied to calculate the referral rebate, expressed in basis points where 100000 represents 100%. All sample values show 100000, indicating full rebate distribution to referrers.
in_epochSTRINGEpoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
in_extrasSTRINGAdditional metadata or flags associated with the rebate event, hex-encoded as a single byte. Consistently appears as ‘0x01’ in sample data.
datain_epochin_extrasin_rebateevent_typein_refereeevent_indexin_referrerblock_heightin_rebate_rateblock_timestampsequence_numbertransaction_hashevent_guid_account_addressevent_guid_creation_number
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“4925343”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}150x0149253430x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a50x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b2512016228891000002024-07-14T12:42:20.440Z9013620x07670b735e11504f3805f7a84cef3bf5943e92873d24ac5575d158d17d0b100c0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0622
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“7145467”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}150x0171454670x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a50x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b2512015727851000002024-07-14T09:42:40.284Z9011700xfdd72941ff4d6b0a6cc79f4cf8a83531d543bb801104b45df80537190ce39e460x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0622
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“3962695”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}150x0139626950x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a50x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b2512016357961000002024-07-14T13:29:24.651Z9014400x2fafb5526005f31d937450bb7fdbb3b1c4be0767c661f4cebe83293e2a4e1de00x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0622
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Referral_RebateEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_CancelOrderEvent_event

Order cancellation events from MerkleTrade perpetual futures protocol on Aptos. Tracks cancelled limit orders with price, size, collateral, and position direction (long/short) for analyzing order flow and trading behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_uidSTRINGUnique identifier for the position or order within the trading protocol. Numeric string representation.
in_event_typeSTRINGEvent type identifier for the canceled order, where ‘0’ represents a standard order cancellation on the MerkleTrade platform.
in_pair_typeSTRINGType identifier for the trading pair in the position or order. Structured type reference containing account address, module name, and struct name components specifying the asset pair being traded.
in_collateral_typeSTRINGType identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_order_idSTRINGInternal order identifier for the cancelled position on MerkleTrade. Unique numeric string identifying each trading order within the protocol.
in_size_deltaSTRINGPosition size change requested in the cancelled order, denominated in base units. String-encoded integer value typically representing leveraged position size on the MerkleTrade perpetuals platform.
in_collateral_deltaSTRINGAmount of collateral being cancelled from the order, denominated in the smallest unit of the collateral token. Sample values range from 2 million to 100 million units.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_is_longSTRINGBoolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
in_is_increaseSTRINGBoolean flag indicating whether the cancelled order was intended to increase position size. String-encoded (‘true’/‘false’), consistently ‘true’ in sample data representing position growth orders.
in_is_marketSTRINGIndicates whether the canceled order was a market order (true) or limit order (false). All sample values show ‘false’, suggesting limit orders are more commonly canceled.
datain_uidin_userin_priceevent_typein_is_longevent_indexin_order_idblock_heightin_is_marketin_pair_typein_event_typein_size_deltain_is_increaseblock_timestampsequence_numbertransaction_hashin_collateral_typein_collateral_deltaevent_guid_account_addressevent_guid_creation_number
{“collateral_delta”:“2000000”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“event_type”:“0”,“is_increase”:true,“is_long”:false,“is_market”:false,“order_id”:“10479”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4d454d455f555344”},“price”:“227821000”,“size_delta”:“280652400”,“uid”:“267739”,“user”:“0x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de14242371”}2677390x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de142423712278210000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEventfalse110479138056571false0280652400true2024-01-25T11:39:33.963Z159520x691b7383c9bc964a7a4bf64ac375b081fb314270ab5aaaca1f372a617a6fe9f320000000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0613
{“collateral_delta”:“2000000”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“event_type”:“0”,“is_increase”:true,“is_long”:false,“is_market”:false,“order_id”:“10479”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4d454d455f555344”},“price”:“227821000”,“size_delta”:“280652400”,“uid”:“267739”,“user”:“0x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de14242371”}2677390x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de142423712278210000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEventfalse210479138056571false0280652400true2024-01-25T11:39:33.963Z20x691b7383c9bc964a7a4bf64ac375b081fb314270ab5aaaca1f372a617a6fe9f320000000x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de1424237160
{“collateral_delta”:“100000000”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“event_type”:“0”,“is_increase”:true,“is_long”:true,“is_market”:false,“order_id”:“10618”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x424c55525f555344”},“price”:“5482000000”,“size_delta”:“1960784300”,“uid”:“245624”,“user”:“0xababd744e5bb7c95de65e643913152595dafe1d5ace02b82a2d33fd295f3a421”}2456240xababd744e5bb7c95de65e643913152595dafe1d5ace02b82a2d33fd295f3a42154820000000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEventtrue110618138203798false01960784300true2024-01-25T21:04:46.474Z160580x392b56b96144a7de8a29e8139a31a1498df430361060c410e4f1f60aaec720f81000000000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0613
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_CancelOrderEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_PlaceOrderEvent_event

Order placement events from MerkleTrade perpetual futures protocol on Aptos, capturing market and limit orders with direction (long/short), position changes (increase/decrease), collateral amounts, and execution prices for analyzing trading patterns and user activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_uidSTRINGUnique identifier for the position or order within the trading protocol. Numeric string representation.
in_pair_typeSTRINGType identifier for the trading pair in the position or order. Structured type reference containing account address, module name, and struct name components specifying the asset pair being traded.
in_collateral_typeSTRINGType identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_order_idSTRINGUnique identifier for the trading order placed on Merkle Trade. Numeric string value assigned sequentially, as seen in examples ranging from 205 to 208.
in_size_deltaSTRINGChange in position size denominated in the smallest token unit. Typically represents the notional value being added or removed from a leveraged trading position.
in_collateral_deltaSTRINGChange in collateral amount for this order, denominated in the smallest units of the collateral token. Represents deposits when increasing positions or withdrawals when reducing positions.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_is_longSTRINGBoolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
in_is_increaseSTRINGIndicates whether the order increases or decreases the position size. Boolean value stored as string (‘true’/‘false’) showing if the trader is adding to or reducing their position.
in_is_marketSTRINGBoolean flag indicating whether this is a market order (true) or limit order (false). Market orders execute immediately at current price, while limit orders wait for specified price levels.
datain_uidin_userin_priceevent_typein_is_longevent_indexin_order_idblock_heightin_is_marketin_pair_typein_size_deltain_is_increaseblock_timestampsequence_numbertransaction_hashin_collateral_typein_collateral_deltaevent_guid_account_addressevent_guid_creation_number
{“collateral_delta”:“91965150”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_increase”:false,“is_long”:true,“is_market”:true,“order_id”:“208”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4554485f555344”},“price”:“15936247994305”,“size_delta”:“3034849950”,“uid”:“737”,“user”:“0xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea”}7370xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea159362479943050x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEventtrue120895645212true3034849950false2023-09-23T19:45:33.351Z1350xdb1792febaf60827cfdcf514609417d12e5ab31a36dde63e2c5a0c0a74e90738919651500xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea7
{“collateral_delta”:“91965150”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_increase”:false,“is_long”:true,“is_market”:true,“order_id”:“208”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4554485f555344”},“price”:“15936247994305”,“size_delta”:“3034849950”,“uid”:“737”,“user”:“0xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea”}7370xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea159362479943050x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEventtrue020895645212true3034849950false2023-09-23T19:45:33.351Z12350xdb1792febaf60827cfdcf514609417d12e5ab31a36dde63e2c5a0c0a74e90738919651500x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0612
{“collateral_delta”:“3809523”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_increase”:false,“is_long”:false,“is_market”:true,“order_id”:“207”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4554485f555344”},“price”:“15996032551500”,“size_delta”:“380952300”,“uid”:“753”,“user”:“0xf4fb925de70c7eeabded00153730f9d4aa5f7a401ca523984db68e4410f7a06d”}7530xf4fb925de70c7eeabded00153730f9d4aa5f7a401ca523984db68e4410f7a06d159960325515000x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEventfalse020795551047true380952300false2023-09-23T12:55:24.423Z12330xa86f175a6bc526407bd5b241a21edc8a97b2d6cd4167dbfdf383877a59e4ecfa38095230x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0612
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_PlaceOrderEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_PositionEvent_event

Position modification events from MerkleTrade perpetual futures protocol on Aptos, capturing size and collateral changes, fees, profit/loss, and open interest for long and short positions. Useful for analyzing trader behavior, fee generation, and position-level profit and loss (PnL) tracking.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_uidSTRINGUnique identifier for the position or order within the trading protocol. Numeric string representation.
in_event_typeSTRINGType identifier for the position event indicating the nature of the action. Numeric code where ‘0’ represents position opening events based on sample data.
in_pair_typeSTRINGType identifier for the trading pair in the position or order. Structured type reference containing account address, module name, and struct name components specifying the asset pair being traded.
in_collateral_typeSTRINGType identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_order_idSTRINGIdentifier for the trading order associated with this position event. Numeric string that links position modifications to their originating order.
in_is_longSTRINGBoolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_original_sizeSTRINGInitial position size in smallest denomination units before any position modifications. Stored as string-encoded integer, value is 0 for new positions opening and non-zero when position is being modified.
in_size_deltaSTRINGChange in position size for this trading event, denominated in the quote currency’s smallest unit. String-encoded numeric value representing the increase or decrease in leveraged exposure.
in_original_collateralSTRINGPosition collateral amount before the current operation in base units. Typically zero for new positions or non-zero for position modifications or closures.
in_collateral_deltaSTRINGChange in collateral amount for this position, denominated in the smallest unit of the collateral token. Positive values indicate collateral additions, while the magnitude represents the raw token amount without decimal adjustment.
in_is_increaseSTRINGIndicates whether the position event represents an increase in position size. Boolean value stored as string (‘true’/‘false’), where ‘true’ means collateral or size was added to an existing position.
in_is_partialSTRINGIndicates whether the position modification represents a partial close or adjustment of an existing position. Boolean value stored as string (‘true’/‘false’), typically false for full position opens or closes.
in_pnl_without_feeSTRINGProfit and loss (PnL) amount for the position excluding all fees and funding costs. Represented as a string-encoded integer, typically zero for new positions and populated upon position closure or modification.
in_is_profitSTRINGIndicates whether the position change resulted in a realized profit for the trader. String boolean (‘true’/‘false’) showing profitability status at position modification or closure.
in_entry_exit_feeSTRINGFee charged for opening or closing a position, denominated in smallest token units. Typically a small percentage of the position size, ranging from hundreds to millions of units depending on trade size.
in_funding_feeSTRINGFunding fee amount charged or earned on this position based on market conditions. String-encoded integer value representing the fee in the smallest unit of the collateral token.
in_is_funding_fee_profitSTRINGBoolean flag indicating whether the funding fee resulted in a profit for the position holder. Typically false for position increases where funding fees haven’t yet accrued.
in_rollover_feeSTRINGFee charged for rolling over or maintaining the leveraged position over time. String-encoded numeric value representing the rollover cost in the smallest unit of the collateral token.
in_long_open_interestSTRINGTotal open interest amount for long positions after this position event. String-encoded integer value, typically zero in position opening events.
in_short_open_interestSTRINGAggregated notional value of all open short positions after this position event occurred. Stored as string-encoded integer; typically zero for new positions.
datain_uidin_userin_priceevent_typein_is_longevent_indexin_order_idblock_heightin_is_profitin_pair_typein_event_typein_is_partialin_size_deltain_funding_feein_is_increaseblock_timestampin_rollover_feesequence_numberin_original_sizetransaction_hashin_entry_exit_feein_collateral_typein_pnl_without_feein_collateral_deltain_long_open_interestin_original_collateralin_short_open_interestin_is_funding_fee_profitevent_guid_account_addressevent_guid_creation_number
{“collateral_delta”:“9689923”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“entry_exit_fee”:“310077”,“event_type”:“0”,“funding_fee”:“0”,“is_funding_fee_profit”:false,“is_increase”:true,“is_long”:true,“is_partial”:false,“is_profit”:false,“long_open_interest”:“0”,“order_id”:“225”,“original_collateral”:“0”,“original_size”:“0”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4554485f555344”},“pnl_without_fee”:“0”,“price”:“16245064433820”,“rollover_fee”:“0”,“short_open_interest”:“0”,“size_delta”:“310077504”,“uid”:“868”,“user”:“0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712”}8680xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712162450644338200x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEventtrue9225100238037false0false3100775040true2023-10-06T12:34:22.800Z05000x054d6ca99e4a9a1845d70a69c71fa1109eeb0fd2554eec9aba093dc90d2432ad31007709689923000false0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a71251
{“collateral_delta”:“9689923”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“entry_exit_fee”:“310077”,“event_type”:“0”,“funding_fee”:“0”,“is_funding_fee_profit”:false,“is_increase”:true,“is_long”:true,“is_partial”:false,“is_profit”:false,“long_open_interest”:“0”,“order_id”:“225”,“original_collateral”:“0”,“original_size”:“0”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4554485f555344”},“pnl_without_fee”:“0”,“price”:“16245064433820”,“rollover_fee”:“0”,“short_open_interest”:“0”,“size_delta”:“310077504”,“uid”:“868”,“user”:“0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712”}8680xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712162450644338200x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEventtrue8225100238037false0false3100775040true2023-10-06T12:34:22.800Z0174500x054d6ca99e4a9a1845d70a69c71fa1109eeb0fd2554eec9aba093dc90d2432ad31007709689923000false0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0614
{“collateral_delta”:“9806065”,“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“entry_exit_fee”:“193935”,“event_type”:“0”,“funding_fee”:“0”,“is_funding_fee_profit”:false,“is_increase”:true,“is_long”:true,“is_partial”:false,“is_profit”:false,“long_open_interest”:“0”,“order_id”:“77”,“original_collateral”:“0”,“original_size”:“0”,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4742505f555344”},“pnl_without_fee”:“0”,“price”:“12199401892”,“rollover_fee”:“0”,“short_open_interest”:“0”,“size_delta”:“1551487502”,“uid”:“867”,“user”:“0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712”}8670xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712121994018920x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEventtrue1077100165112false0false15514875020true2023-10-06T07:48:50.038Z04600x1c1e31883a39071680da380cd3bf5f0fccc904c5c9bc47d09ba1c7586bf324a919393509806065000false0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a71251
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_PositionEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_TradingEvents_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_uid_sequenceSTRING-
in_place_order_eventsSTRING-
in_cancel_order_eventsSTRING-
in_position_eventsSTRING-
in_update_tp_sl_eventsSTRING-
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_TradingEvents_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_UpdateTPSLEvent_event

Take-profit and stop-loss (TP/SL) order modifications from Merkle Trade perpetual futures protocol on Aptos. Tracks user adjustments to risk management parameters including trigger prices, position direction, and unique position identifiers for analyzing trader risk management behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_uidSTRINGUnique identifier for the position or order within the trading protocol. Numeric string representation.
in_pair_typeSTRINGType identifier for the trading pair in the position or order. Structured type reference containing account address, module name, and struct name components specifying the asset pair being traded.
in_collateral_typeSTRINGType identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_is_longSTRINGBoolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
in_take_profit_trigger_priceSTRINGPrice level at which a take-profit order will be automatically executed for the position, denominated in the smallest unit of the trading pair. Typically set above entry price for long positions to lock in gains when the market reaches target levels.
in_stop_loss_trigger_priceSTRINGPrice level that triggers automatic position closure to limit losses, denominated in the smallest unit of the trading pair. Typically set below the entry price for long positions to prevent excessive downside exposure.
datain_uidin_userevent_typein_is_longevent_indexblock_heightin_pair_typeblock_timestampsequence_numbertransaction_hashin_collateral_typeevent_guid_account_addressevent_guid_creation_numberin_stop_loss_trigger_pricein_take_profit_trigger_price
{“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_long”:true,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4254435f555344”},“stop_loss_trigger_price”:“427600000000000”,“take_profit_trigger_price”:“470297900000000”,“uid”:“136947”,“user”:“0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535”}1369470x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d905350x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEventtrue01306620442024-01-04T02:21:57.515Z133180x022fd04f81915ed47c1ab96f9d508fdd2599488d5582fb85c739fbdbc69cb41d0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0615427600000000000470297900000000
{“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_long”:true,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4254435f555344”},“stop_loss_trigger_price”:“423700000000000”,“take_profit_trigger_price”:“470297900000000”,“uid”:“136947”,“user”:“0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535”}1369470x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d905350x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEventtrue01306482372024-01-04T01:23:51.655Z133010xbec696d6284fac328b608576f21981c72c24783aa334908c9c37027ee16611f30x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0615423700000000000470297900000000
{“collateral_type”:{“account_address”:“0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa”,“module_name”:“0x6173736574”,“struct_name”:“0x55534443”},“is_long”:true,“pair_type”:{“account_address”:“0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06”,“module_name”:“0x706169725f7479706573”,“struct_name”:“0x4254435f555344”},“stop_loss_trigger_price”:“428850000000000”,“take_profit_trigger_price”:“470587100000000”,“uid”:“137092”,“user”:“0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535”}1370920x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d905350x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEventtrue01306712992024-01-04T02:59:19.582Z133330x6ffc202c4243161e2dedd81e6d21fd98ec0e39bbe634565c36827e161030903f0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc0615428850000000000470587100000000
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_UpdateTPSLEvent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Trading_UserTradingEvents_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination).
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data.
in_place_order_eventsSTRING-
in_cancel_order_eventsSTRING-
in_position_eventsSTRING-
in_update_tp_sl_eventsSTRING-
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.merkletrade_v1_aptos.Trading_UserTradingEvents_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100