unidex_v1_fantom

Tables

Pool_Deposit_event

Liquidity pool deposit events recording user contributions to option pools (Premia) or trading pools (UniDex). Contains depositor address, deposit amount, and pool-specific parameters such as option type or currency token.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_clpAmount`	`STRING`	Amount of CLP (Concentrated Liquidity Pool) tokens minted or burned in the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_currency	block_number	in_clpAmount	block_timestamp	transaction_hash
0x7a494c755911ce06444c47248108439a06ac028c	0xbb1bf082b1a61131d3345c1f99da32af592da2fb	false	10000000000000000000	13	0x04068da6c83afcfa0e13ba15a6696662335d5b75	65126843	17415880808408043989	2023-07-04T17:17:04.000Z	0xc590b32026c4d819601b2e479375b2aa51fab7415cf5518f760db3ad2e3db96c
0xbec7d4561037e657830f78b87e780aee1d09fc7b	0xdbf4a4874e5bf633d8628e5272f9965ec1ee4dd9	false	38000000000000000000	23	0x0000000000000000000000000000000000000000	67413565	19238045055426849332	2023-08-25T17:29:22.000Z	0x797888bfdae6d1164e407b3309a3a426fbc0a660a26629c55304039a55d7b347
0x7a494c755911ce06444c47248108439a06ac028c	0x9ac3c1b5a436d2b6dda16c539550c15304208857	false	100000000000000000000	17	0x04068da6c83afcfa0e13ba15a6696662335d5b75	60411983	172425957405420089165	2023-04-20T21:43:13.000Z	0x29d032df8ad57ce5b46f02d453c7e5e572e4c2a711f4832aed1bedb3ae4a6e0b

Example Query

Query with partition filter

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

Pool_Withdraw_event

Withdrawal events from liquidity pools recording user withdrawals of reserve assets. Contains user address, withdrawn amount, reserve or currency identifier, and recipient address for tracking outbound pool liquidity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_clpAmount`	`STRING`	Amount of CLP (Concentrated Liquidity Pool) tokens minted or burned in the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_currency	block_number	in_clpAmount	block_timestamp	transaction_hash
0xbec7d4561037e657830f78b87e780aee1d09fc7b	0x5805641e589cf538004a0ccfc31a57ac1ba2cb02	false	6356301357363126697447	92	0x0000000000000000000000000000000000000000	53712831	3320555270551673556588	2023-01-13T21:32:27.000Z	0x3bc2220582c63ce9dd02a10f763cf68512f24c60d411d5ab697aa9893a87ca24
0xbec7d4561037e657830f78b87e780aee1d09fc7b	0xbd485523bb960b27c38d3f9ad47f0d3a384e69ce	false	257226000000000000000	17	0x0000000000000000000000000000000000000000	53718292	134200310641310566036	2023-01-13T23:23:46.000Z	0x44b17163c2c2465148f880d16c17fc0fdf264ded727793168a11731adfbc82c1
0x7a494c755911ce06444c47248108439a06ac028c	0x38d4a9758da0b6b4220f5353eed66c1fce2775e2	false	525826000000000000000	50	0x04068da6c83afcfa0e13ba15a6696662335d5b75	53666119	990747817809108216007	2023-01-13T02:50:46.000Z	0x6252fb96fceabfc52a04f59de4c0abb3400a323b2a21048f19a9e37b071dcdcf

Example Query

Query with partition filter

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

Settlement_Interaction_event

Settlement interaction events from the UniDex V1 protocol recording contract calls with function selectors, target addresses, and value parameters. Used for tracking cross-protocol settlement operations and DEX aggregator interactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_selector`	`STRING`	Function selector identifying the smart contract method being called. 10-character hex string including 0x prefix representing the first 4 bytes of the keccak256 hash of the function signature.

Sample Data

address	removed	in_target	log_index	in_selector	block_number	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x1111111254eeb25477b68fb85ed929f73a960582	57	0x12aa3caf	56767845	2023-03-02T03:05:16.000Z	0x46334d83f3a24464f9e806aebd9726d4fc138da6c7430929f5a3789d26430ece
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x1111111254eeb25477b68fb85ed929f73a960582	12	0x12aa3caf	56793130	2023-03-02T12:56:37.000Z	0xc848aa408a5c80005b588e0266138865237cd81c41af7486e27dfd2677bc1342
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x1111111254eeb25477b68fb85ed929f73a960582	17	0x12aa3caf	56900939	2023-03-04T02:59:23.000Z	0x5f620adc6475e06a6d242146cd9983c9ad64914ba2c0307ce216328b45caa259

Example Query

Query with partition filter

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

Settlement_Settlement_event

Settlement execution events from the UniDex v1 protocol containing solver addresses authorized to execute settlements. Records when solvers are added to or removed from the settlement allow list across multiple chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_solver`	`STRING`	Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_solver	log_index	block_number	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	29	59391602	2023-04-08T10:28:37.000Z	0x740347a0109dbb1467c5161102aaf0dc9bd3ae1183fe810c54e949fff6fba15c
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	16	59391175	2023-04-08T10:22:09.000Z	0x47c93791d798cc5f3f23408c7cec92cae8710f85232cc632352f63770abadae1
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	37	57993197	2023-03-20T16:26:23.000Z	0x24798acbd4015075b09ae32f42e4b92d31f3b5e89f9e35af9f2d379c4247bd2e

Example Query

Query with partition filter

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

Settlement_Trade_event

Trade execution events from UniDex V1 settlement contracts containing order identifiers, token swap details (buy/sell tokens and amounts), owner addresses, and fee information. Used for tracking DEX (Decentralized Exchange) order settlement and trade volume analysis across multiple chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellToken`	`STRING`	Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyToken`	`STRING`	Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellAmount`	`STRING`	Amount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
`in_buyAmount`	`STRING`	Amount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_orderUid`	`STRING`	Unique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.

Sample Data

address	removed	in_owner	log_index	in_buyToken	in_orderUid	block_number	in_buyAmount	in_feeAmount	in_sellToken	in_sellAmount	block_timestamp	transaction_hash
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xfbbe90dd04250b5e789ed9d1bfba2476e524a852	4	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0xada526752497210214d7a52fb2665504466298f6c8b87990a083b69d32916d1afbbe90dd04250b5e789ed9d1bfba2476e524a8526402bb03	56900939	19931053	65711290541762304	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	20000000000000000000	2023-03-04T02:59:23.000Z	0x5f620adc6475e06a6d242146cd9983c9ad64914ba2c0307ce216328b45caa259
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xfbbe90dd04250b5e789ed9d1bfba2476e524a852	0	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x8680f0b341a1d9c99ecdb6ab524d728570c0ba5fcdc518fc3b9c2c9005300497fbbe90dd04250b5e789ed9d1bfba2476e524a8526412bfae	57684859	229946369	7346824690567010	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	230000000000000000000	2023-03-16T06:35:42.000Z	0x0be57dd39179868d291b5049a4f59371615fc81a166b236a490ea6794a735710
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xb2d41414f387ab85970182d30510b19b61f0a071	0	0x2130d2a1e51112d349ccf78d2a1ee65843ba36e0	0x221445b94d3291fde1d957ac158498bae229dd271c837b271f59233f21858f5db2d41414f387ab85970182d30510b19b61f0a07164431642	60496161	5749103372581581752	153636	0x04068da6c83afcfa0e13ba15a6696662335d5b75	35931184	2023-04-21T22:34:16.000Z	0xb7614ba5da7467d1b1a8fc55479294e5ebdf1adfe4068c10a60e51f37f0de1d7

Example Query

Query with partition filter

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

Trading_ClosePosition_event

Position closure events from UniDex v1 perpetual trading protocol on Fantom. Records profit and loss (PnL), fees, and liquidation status for analyzing trader performance and protocol trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`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_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_pnl`	`STRING`	Profit and loss realized from closing the position. String-encoded integer value representing the net gain or loss in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits.
`in_wasLiquidated`	`BOOL`	Boolean flag indicating whether the position was liquidated. True when the position was forcibly closed due to insufficient margin, false when voluntarily closed by the user.

Sample Data

in_fee	in_key	in_pnl	address	in_size	in_user	removed	in_price	in_isLong	in_margin	log_index	in_currency	block_number	in_productId	block_timestamp	in_wasLiquidated	transaction_hash
2700000000	0x37f1c8aef42c0046e9f1973103c675d4c2debd0cf4c5ba62c5431d831f7908e2	12922987723	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	2700000000000	0x08fc810c05bbe20b6b087e0df6d5cd4fa2e7ce7f	false	31813500	false	128571428571	76	0x04068da6c83afcfa0e13ba15a6696662335d5b75	53903444	0x46544d2d55534400000000000000000000000000000000000000000000000000	2023-01-17T00:32:48.000Z	false	0x4b36d4bab153b81ac335dc5708905cf256e8c6d48f3adcf00b202ecbc6329451
5000000000	0x37f1c8aef42c0046e9f1973103c675d4c2debd0cf4c5ba62c5431d831f7908e2	26549775850	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	5000000000000	0x08fc810c05bbe20b6b087e0df6d5cd4fa2e7ce7f	false	33414000	false	138888888889	2	0x04068da6c83afcfa0e13ba15a6696662335d5b75	53930258	0x46544d2d55534400000000000000000000000000000000000000000000000000	2023-01-17T15:37:53.000Z	false	0x127ed4f4f6717b3b911c26096e7f691d27dd3f88a17201fad721040f6c09efac
28571428572	0x37f1c8aef42c0046e9f1973103c675d4c2debd0cf4c5ba62c5431d831f7908e2	-142857142857	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	3000000000000	0x08fc810c05bbe20b6b087e0df6d5cd4fa2e7ce7f	false	32784999	false	142857142857	78	0x04068da6c83afcfa0e13ba15a6696662335d5b75	53919068	0x46544d2d55534400000000000000000000000000000000000000000000000000	2023-01-17T09:03:07.000Z	true	0x0cff9a810d8e467b7a0e8bcd5dc6a4932859c24f59421a166e99461c67846963

Example Query

Query with partition filter

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

Trading_NewOrder_event

Order creation and closure events from UniDex V1 perpetual futures DEX on Fantom, capturing position opens/closes with margin, size, direction (long/short), and trading pair identifiers (BNB-USD, SOL-USD, ETH-USD). Used for tracking user trading activity, position management, and leveraged trading patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_isClose`	`BOOL`	Boolean flag indicating whether this order is closing an existing position. True for position closures, false for new position openings.

Sample Data

in_key	address	in_size	in_user	removed	in_isLong	in_margin	log_index	in_isClose	in_currency	block_number	in_productId	block_timestamp	transaction_hash
0xbde434e75dbc5bf0b16150b9d8a27478e941efd3658e18464dea4bd22bc88207	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	2000000000000	0x3065c93bc0b645d4bd06fee143e9202905f6fecf	false	false	400000000000	14	true	0x04068da6c83afcfa0e13ba15a6696662335d5b75	63944177	0x424e422d55534400000000000000000000000000000000000000000000000000	2023-06-11T14:38:40.000Z	0xd35157db3184d2a86182bd05e535c58712fb5e7e362ee3ece47b4e23bff8ab91
0x5ad1b043d50c56abc9ac87186ceacf2e297c8f8fd4910fbabcb6163650184bb8	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	8000000000	0x3c7ac2ff76a1b4dcb2b69b1121fef5fb8dcdec43	false	false	160000000	0	true	0x0000000000000000000000000000000000000000	63921165	0x534f4c2d55534400000000000000000000000000000000000000000000000000	2023-06-11T03:21:30.000Z	0xfd35c7a031cd038473949b3902a4187fe54a5c31dfc132f85016c0ede12260a8
0x5ad1b043d50c56abc9ac87186ceacf2e297c8f8fd4910fbabcb6163650184bb8	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	8000000000	0x3c7ac2ff76a1b4dcb2b69b1121fef5fb8dcdec43	false	false	160000000	1	false	0x0000000000000000000000000000000000000000	63917873	0x534f4c2d55534400000000000000000000000000000000000000000000000000	2023-06-11T01:48:00.000Z	0x3bba91c4338baecb5fc95bd090d488771facaa0e3ef66cdc5799377dd284333e

Example Query

Query with partition filter

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

Trading_PositionUpdated_event

Position update events from UniDEX V1 perpetual futures protocol on Fantom, capturing long/short positions with margin, size, fees, and entry prices for trading pairs like ETH-USD and BTC-USD. Used for tracking trader activity, leverage usage, and position-level profit/loss analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_productId`	`STRING`	Identifier for the financial product or trading pair involved in the transaction. Numeric string representation of the product ID in the protocol’s internal indexing system.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_margin`	`STRING`	Margin amount posted or held for the trading position. String-encoded integer value representing collateral in the smallest unit of the relevant token or currency.
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_key	address	in_size	in_user	removed	in_price	in_isLong	in_margin	log_index	in_currency	block_number	in_productId	block_timestamp	transaction_hash
50000	0x3fda7593def133fdf2bb26836dccd0a7d679dbd20555cb21881678e925050d66	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	50000000	0x54ea47c19221eb65491985794a6280a86dd3b5fc	false	164710000000	true	1000000	43	0x0000000000000000000000000000000000000000	45589471	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-08-24T14:45:33.000Z	0xe2cb3dce94604382f3981abde1621394e7ee04f5b220604bba9aaffe985d3b66
50000	0xa417848b3c62025651b8a85148c871fc6831856b69983b4fcaf48a6fc0acef89	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	50000000	0x54ea47c19221eb65491985794a6280a86dd3b5fc	false	165338000000	false	1666666	93	0x0000000000000000000000000000000000000000	45581369	0x4554482d55534400000000000000000000000000000000000000000000000000	2022-08-24T12:01:46.000Z	0x4c44d139936aa11e1b7ccd442a2aae7eb5cf3ed7080460d2e1274778054b8df4
1000000	0x60f2988639c92081d045b366f06ac3d7f52e9718e16c4e6923506a0aa3c4a622	0xd296169a91c8ed59c08eb2f7d831bd646a8af2c8	1000000000	0xc38b756916676b2a91cee9709dacb51d41feae39	false	99562000	true	20000000	0	0x04068da6c83afcfa0e13ba15a6696662335d5b75	45594272	0x4555522d55534400000000000000000000000000000000000000000000000000	2022-08-24T16:26:48.000Z	0x3bd73b6ac9f981ee364aa5f6578b5291e0b2e9378dc3ecb0d1070583f31c7ae4

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Pool_Deposit_event

Pool_Withdraw_event

Settlement_Interaction_event

Settlement_Settlement_event

Settlement_Trade_event

Trading_ClosePosition_event

Trading_NewOrder_event

Trading_PositionUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Pool_Deposit_event

​Pool_Withdraw_event

​Settlement_Interaction_event

​Settlement_Settlement_event

​Settlement_Trade_event

​Trading_ClosePosition_event

​Trading_NewOrder_event

​Trading_PositionUpdated_event

Tables

Pool_Deposit_event

Pool_Withdraw_event

Settlement_Interaction_event

Settlement_Settlement_event

Settlement_Trade_event

Trading_ClosePosition_event

Trading_NewOrder_event

Trading_PositionUpdated_event