merkletrade_v1_aptos

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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_amount`	`STRING`	Amount 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_amount`	`STRING`	Amount 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_amount`	`STRING`	Amount 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.

Sample Data

data	event_type	event_index	block_height	in_lp_amount	in_dev_amount	block_timestamp	in_stake_amount	sequence_number	transaction_hash	event_guid_account_address	event_guid_creation_number
{“dev_amount”:“0”,“lp_amount”:“0”,“stake_amount”:“0”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent	3	191109635	0	0	2024-06-16T04:36:10.500Z	0	1678101	0x92a71b88239168741da7ffad1ff36bd64e272a6179c1c1a732cc8849d82e20a6	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	11
{“dev_amount”:“100650”,“lp_amount”:“587118”,“stake_amount”:“150973”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent	3	191240440	587118	100650	2024-06-16T13:57:45.466Z	150973	1679336	0x714bad1853387067a34a0e2e8b206ddfbe3838c7380ce4b67c532cb837a64e2b	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	11
{“dev_amount”:“106113”,“lp_amount”:“618991”,“stake_amount”:“159169”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::fee_distributor::DepositFeeEvent	3	191298261	618991	106113	2024-06-16T18:06:38.064Z	159169	1679901	0xa377de5c88d83d3a2bea3f2dfad83cb010c8d13eb092d23b9ef9c4ccac518091	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	11

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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_type`	`STRING`	Pool 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_amount`	`STRING`	Amount of MKL tokens claimed from the pool in this event. Stored as a string to preserve precision for large token amounts with decimals.

Sample Data

data	event_type	block_height	in_pool_type	in_mkl_amount	block_timestamp	sequence_number	transaction_hash	event_guid_account_address	event_guid_creation_number
{“mkl_amount”:“12183220”,“pool_type”:“COMMUNITY_POOL”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent	229235745	COMMUNITY_POOL	12183220	2024-09-21T00:25:03.033Z	4135	0x297d0c2186d715a217df3b49233caf2aca8f9de7f86c62024d382c62a7496c0e	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	49
{“mkl_amount”:“587485”,“pool_type”:“COMMUNITY_POOL”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent	229466770	COMMUNITY_POOL	587485	2024-09-21T13:47:23.352Z	4182	0x31eece409e92864816e68e9f63983ee77e942fca3a813d581076683110c6b306	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	49
{“mkl_amount”:“40165914”,“pool_type”:“COMMUNITY_POOL”}	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::mkl_token::MklClaimEvent	229281305	COMMUNITY_POOL	40165914	2024-09-21T03:03:02.277Z	4143	0x5269406c486b84f92543ed40acf97b668182ec0dcb2edfee56b0f1540a3db64d	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	49

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_referee`	`STRING`	Aptos 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_rebate`	`STRING`	Rebate 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_rate`	`STRING`	Percentage 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_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_extras`	`STRING`	Additional metadata or flags associated with the rebate event, hex-encoded as a single byte. Consistently appears as ‘0x01’ in sample data.

Sample Data

data	in_epoch	in_extras	in_rebate	event_type	in_referee	event_index	in_referrer	block_height	in_rebate_rate	block_timestamp	sequence_number	transaction_hash	event_guid_account_address	event_guid_creation_number
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“4925343”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}	15	0x01	4925343	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent	0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a	5	0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251	201622889	100000	2024-07-14T12:42:20.440Z	901362	0x07670b735e11504f3805f7a84cef3bf5943e92873d24ac5575d158d17d0b100c	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	22
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“7145467”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}	15	0x01	7145467	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent	0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a	5	0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251	201572785	100000	2024-07-14T09:42:40.284Z	901170	0xfdd72941ff4d6b0a6cc79f4cf8a83531d543bb801104b45df80537190ce39e46	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	22
{“epoch”:“15”,“extras”:“0x01”,“rebate”:“3962695”,“rebate_rate”:“100000”,“referee”:“0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a”,“referrer”:“0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251”}	15	0x01	3962695	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::referral::RebateEvent	0x1121bdf3d7044b39f9e129ed4a1e5012fea6e64d96537d4f965b8a7736ce113a	5	0x8fd1bfca026784fb24a2c3640e738ec9e5afb8521800c768093d3a3104f2b251	201635796	100000	2024-07-14T13:29:24.651Z	901440	0x2fafb5526005f31d937450bb7fdbb3b1c4be0767c661f4cebe83293e2a4e1de0	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	22

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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`	`STRING`	Unique identifier for the position or order within the trading protocol. Numeric string representation.
`in_event_type`	`STRING`	Event type identifier for the canceled order, where ‘0’ represents a standard order cancellation on the MerkleTrade platform.
`in_pair_type`	`STRING`	Type 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_type`	`STRING`	Type identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_order_id`	`STRING`	Internal order identifier for the cancelled position on MerkleTrade. Unique numeric string identifying each trading order within the protocol.
`in_size_delta`	`STRING`	Position 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_delta`	`STRING`	Amount 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_is_long`	`STRING`	Boolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
`in_is_increase`	`STRING`	Boolean 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_market`	`STRING`	Indicates 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.

Sample Data

data	in_uid	in_user	in_price	event_type	in_is_long	event_index	in_order_id	block_height	in_is_market	in_size_delta	in_is_increase	block_timestamp	sequence_number	transaction_hash	in_collateral_delta	event_guid_account_address	event_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”}	267739	0x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de14242371	227821000	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEvent	false	1	10479	138056571	false	280652400	true	2024-01-25T11:39:33.963Z	15952	0x691b7383c9bc964a7a4bf64ac375b081fb314270ab5aaaca1f372a617a6fe9f3	2000000	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	13
{“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”}	267739	0x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de14242371	227821000	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEvent	false	2	10479	138056571	false	280652400	true	2024-01-25T11:39:33.963Z	2	0x691b7383c9bc964a7a4bf64ac375b081fb314270ab5aaaca1f372a617a6fe9f3	2000000	0x3b6785d978922e0e6d9ae91c1ab7d732139f162312c56eeefd608de14242371	60
{“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”}	245624	0xababd744e5bb7c95de65e643913152595dafe1d5ace02b82a2d33fd295f3a421	5482000000	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::CancelOrderEvent	true	1	10618	138203798	false	1960784300	true	2024-01-25T21:04:46.474Z	16058	0x392b56b96144a7de8a29e8139a31a1498df430361060c410e4f1f60aaec720f8	100000000	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	13

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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`	`STRING`	Unique identifier for the position or order within the trading protocol. Numeric string representation.
`in_pair_type`	`STRING`	Type 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_type`	`STRING`	Type identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_order_id`	`STRING`	Unique 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_delta`	`STRING`	Change 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_delta`	`STRING`	Change 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_is_long`	`STRING`	Boolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
`in_is_increase`	`STRING`	Indicates 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_market`	`STRING`	Boolean 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.

Sample Data

data	in_uid	in_user	in_price	event_type	in_is_long	event_index	in_order_id	block_height	in_is_market	in_size_delta	in_is_increase	block_timestamp	sequence_number	transaction_hash	in_collateral_delta	event_guid_account_address	event_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”}	737	0xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea	15936247994305	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEvent	true	1	208	95645212	true	3034849950	false	2023-09-23T19:45:33.351Z	135	0xdb1792febaf60827cfdcf514609417d12e5ab31a36dde63e2c5a0c0a74e90738	91965150	0xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea	7
{“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”}	737	0xee98f3a751a772d8d785e9665f6155ce5906629272225aecaa25c5514615eaea	15936247994305	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEvent	true	0	208	95645212	true	3034849950	false	2023-09-23T19:45:33.351Z	1235	0xdb1792febaf60827cfdcf514609417d12e5ab31a36dde63e2c5a0c0a74e90738	91965150	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	12
{“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”}	753	0xf4fb925de70c7eeabded00153730f9d4aa5f7a401ca523984db68e4410f7a06d	15996032551500	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PlaceOrderEvent	false	0	207	95551047	true	380952300	false	2023-09-23T12:55:24.423Z	1233	0xa86f175a6bc526407bd5b241a21edc8a97b2d6cd4167dbfdf383877a59e4ecfa	3809523	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	12

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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`	`STRING`	Unique identifier for the position or order within the trading protocol. Numeric string representation.
`in_event_type`	`STRING`	Type 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_type`	`STRING`	Type 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_type`	`STRING`	Type identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_order_id`	`STRING`	Identifier for the trading order associated with this position event. Numeric string that links position modifications to their originating order.
`in_is_long`	`STRING`	Boolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_original_size`	`STRING`	Initial 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_delta`	`STRING`	Change 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_collateral`	`STRING`	Position collateral amount before the current operation in base units. Typically zero for new positions or non-zero for position modifications or closures.
`in_collateral_delta`	`STRING`	Change 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_increase`	`STRING`	Indicates 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_partial`	`STRING`	Indicates 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_fee`	`STRING`	Profit 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_profit`	`STRING`	Indicates 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_fee`	`STRING`	Fee 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_fee`	`STRING`	Funding 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_profit`	`STRING`	Boolean 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_fee`	`STRING`	Fee 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_interest`	`STRING`	Total open interest amount for long positions after this position event. String-encoded integer value, typically zero in position opening events.
`in_short_open_interest`	`STRING`	Aggregated notional value of all open short positions after this position event occurred. Stored as string-encoded integer; typically zero for new positions.

Sample Data

data	in_uid	in_user	in_price	event_type	in_is_long	event_index	in_order_id	block_height	in_is_profit	in_is_partial	in_size_delta	in_is_increase	block_timestamp	sequence_number	transaction_hash	in_entry_exit_fee	in_collateral_delta	in_is_funding_fee_profit	event_guid_account_address	event_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”}	868	0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712	16245064433820	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEvent	true	9	225	100238037	false	false	310077504	true	2023-10-06T12:34:22.800Z	50	0x054d6ca99e4a9a1845d70a69c71fa1109eeb0fd2554eec9aba093dc90d2432ad	310077	9689923	false	0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712	51
{“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”}	868	0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712	16245064433820	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEvent	true	8	225	100238037	false	false	310077504	true	2023-10-06T12:34:22.800Z	1745	0x054d6ca99e4a9a1845d70a69c71fa1109eeb0fd2554eec9aba093dc90d2432ad	310077	9689923	false	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	14
{“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”}	867	0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712	12199401892	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::PositionEvent	true	10	77	100165112	false	false	1551487502	true	2023-10-06T07:48:50.038Z	46	0x1c1e31883a39071680da380cd3bf5f0fccc904c5c9bc47d09ba1c7586bf324a9	193935	9806065	false	0xcef02d0bcc7177b67922cdd8b5d10c11e6af9fcc5d328c5cdc130bdec6a5a712	51

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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_sequence`	`STRING`	-
`in_place_order_events`	`STRING`	-
`in_cancel_order_events`	`STRING`	-
`in_position_events`	`STRING`	-
`in_update_tp_sl_events`	`STRING`	-

Sample Data

No sample data available.

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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`	`STRING`	Unique identifier for the position or order within the trading protocol. Numeric string representation.
`in_pair_type`	`STRING`	Type 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_type`	`STRING`	Type identifier for the collateral asset used in the position or order. Structured type reference containing account address, module name, and struct name components.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_is_long`	`STRING`	Boolean flag indicating whether the position or order is a long position. String representation of ‘true’ or ‘false’.
`in_take_profit_trigger_price`	`STRING`	Price 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_price`	`STRING`	Price 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.

Sample Data

data	in_uid	in_user	event_type	in_is_long	block_height	block_timestamp	sequence_number	transaction_hash	event_guid_account_address	event_guid_creation_number	in_stop_loss_trigger_price	in_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”}	136947	0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEvent	true	130662044	2024-01-04T02:21:57.515Z	13318	0x022fd04f81915ed47c1ab96f9d508fdd2599488d5582fb85c739fbdbc69cb41d	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	15	427600000000000	470297900000000
{“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”}	136947	0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEvent	true	130648237	2024-01-04T01:23:51.655Z	13301	0xbec696d6284fac328b608576f21981c72c24783aa334908c9c37027ee16611f3	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	15	423700000000000	470297900000000
{“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”}	137092	0x10e6d4bb92a75c9db37eb4689c2367f8cee019af7294cb159d74fc2060d90535	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06::trading::UpdateTPSLEvent	true	130671299	2024-01-04T02:59:19.582Z	13333	0x6ffc202c4243161e2dedd81e6d21fd98ec0e39bbe634565c36827e161030903f	0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06	15	428850000000000	470587100000000

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`sequence_number`	`STRING`	Sequential 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_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`event_index`	`INT64`	Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
`event_guid_account_address`	`STRING`	Account address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
`event_guid_creation_number`	`INT64`	Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
`data`	`JSON`	Raw 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_events`	`STRING`	-
`in_cancel_order_events`	`STRING`	-
`in_position_events`	`STRING`	-
`in_update_tp_sl_events`	`STRING`	-

Sample Data

No sample data available.

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

FeeDistributor_DepositFeeEvent_event

MklToken_MklClaimEvent_event

Referral_RebateEvent_event

Trading_CancelOrderEvent_event

Trading_PlaceOrderEvent_event

Trading_PositionEvent_event

Trading_TradingEvents_event

Trading_UpdateTPSLEvent_event

Trading_UserTradingEvents_event

​Tables

​FeeDistributor_DepositFeeEvent_event

​MklToken_MklClaimEvent_event

​Referral_RebateEvent_event

​Trading_CancelOrderEvent_event

​Trading_PlaceOrderEvent_event

​Trading_PositionEvent_event

​Trading_TradingEvents_event

​Trading_UpdateTPSLEvent_event

​Trading_UserTradingEvents_event

Tables

FeeDistributor_DepositFeeEvent_event

MklToken_MklClaimEvent_event

Referral_RebateEvent_event

Trading_CancelOrderEvent_event

Trading_PlaceOrderEvent_event

Trading_PositionEvent_event

Trading_TradingEvents_event

Trading_UpdateTPSLEvent_event

Trading_UserTradingEvents_event