unidex_v1_optimism

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
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0x1cf49a2c24656ce6be770c92f2cbef871a247f51	false	1985156693862570000	1	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	38373017	1785153858670743826	2022-11-15T10:05:10.000Z	0x2729122239193c4ffe96884b50ccc642879660fde21aa0df74d26b031185ac09
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0x44d60c43aa495fa89c13efa2b5be734a12367f5f	false	124814000000000000000	1	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	38527594	112131925444172068910	2022-11-15T22:23:24.000Z	0x43d3354a06c244758a24bcce7686ced222b4df0e71f9aa9d1ba41086f5eb43d0
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0x6c2693f5a936f37ed03cfa8465bf2d8beff19a0f	false	200000000000000000000	1	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	38236540	179766876915696090957	2022-11-15T00:00:32.000Z	0x353982cf8f8acdde93361beddac14eec9a589723c04cf1f3132a3c7c48669c9b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_optimism.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
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0xc1d3aa543778b87f4c4e80bf1f4d3f13d9ffb43d	false	405552000000000000000	2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	68676326	343385724306011636044	2023-01-17T15:13:09.000Z	0x7262d2b5c35fdd6597bb7ab69ba76862ea8ea92ef56e6220e8555f59a83c5596
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0x266178a48c50f104b53ed78ca8e3582dfcfbb286	false	99400958646094565437	5	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	68221001	84216332988520294412	2023-01-17T01:09:28.000Z	0x9380f3daf70ccaf4adfd90548369a3ea0c35239f15a8a18a08ef5026babbb787
0xcddf71750e596b4c38785affec3bd4c9bff43f6f	0xf551c11c45f6e1f10c00b7c394d581dde5c77072	false	1220039105223574289027	2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	110419077	1012166135768697719233	2023-10-04T16:28:51.000Z	0xdb39ed533aaf14c7fc33388ea03924140c897c22e2d533172fca4e225129ef38

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_optimism.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	0x970a0575a3e5a1c76493b5744b90bd0a490b0886	1	0x4c84c1c8	106986019	2023-07-17T05:13:35.000Z	0xb02fbefacb7a732c88319a671cdfb8263ab3ed6cd2321f4ab938c6960f11e632
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	10	0xa6886da9	106986019	2023-07-17T05:13:35.000Z	0xb02fbefacb7a732c88319a671cdfb8263ab3ed6cd2321f4ab938c6960f11e632
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	38	0xa6886da9	107017308	2023-07-17T22:36:33.000Z	0xf12ab4a401d2b2b929208e959b54858f8db4f69f062b416b9ce2f7a0cdb64f9a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_optimism.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	14	111148029	2023-10-21T13:27:15.000Z	0x13fabee15e36cdefd7c28f4754ec3ce5cfc33da0761293d18059c7d08e80e6d1
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	32	111153769	2023-10-21T16:38:35.000Z	0x7c21eaec6e1b3f0509c330b202cb05717b0484252f11c8739ea47301dcc2edb1
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0xa82eb51c866fb85b28d3876c24505e07d6459dba	16	111149799	2023-10-21T14:26:15.000Z	0xadeea10303a1a0fe55aebd16f67739233e7b794533506e9cf233176a939078a0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_optimism.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	0x27a4adac09668c8e83d13451bac626b679421cef	36	0x4200000000000000000000000000000000000006	0x3a7482c3a752fb2863d764ae6e22ac4068ceb32763fb5d14fc2b8416eaaea70627a4adac09668c8e83d13451bac626b679421cef6491df72	105840543	6247938316230425	1	0x7f5c764cbc14f9669b88837ca1490cca17c31607	10903335	2023-06-20T16:51:03.000Z	0xdd63900db526802f49471e298cc193b5dd3a7194a8f1a98026d4f94cba0a0db7
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x27a4adac09668c8e83d13451bac626b679421cef	36	0x4200000000000000000000000000000000000006	0x57dc4e26824d2aa25a524bb388921e056f627f6c75507739216d3a4af2eff16327a4adac09668c8e83d13451bac626b679421cef6491debf	105840464	1764023067941147	138589652580	0x5d47baba0d66083c52009271faf3f50dcc01023c	611775042310000000	2023-06-20T16:48:25.000Z	0xc8e936a6adb5e218e9eda5bc2e96a0115fb7fc905a625ac72e672fb01525c293
0x103d0634ec6c9e1f633381b16f8e2fe56a2e7372	false	0x27a4adac09668c8e83d13451bac626b679421cef	32	0x4200000000000000000000000000000000000006	0x04bd291c9b0e8bbac6bcc5505ab307e6885764ce550b9e5b27b3d77894163ad227a4adac09668c8e83d13451bac626b679421cef6491df4c	105840529	1141975604350168	2	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	1998719	2023-06-20T16:50:35.000Z	0x4e0fd9f1fbefb030bd2c107e5cf0356fae6f938eb747f49d2fd49397a3ff307c

Example Query

Query with partition filter

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

Trading_ClosePosition_event

Position closure records from UniDex v1 perpetual futures protocol on Optimism, capturing realized profit/loss, fees, and liquidation status. Used for analyzing trader performance, liquidation events, and market outcomes across crypto perpetual pairs.

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
20000000	0x18f9943633a98598967f37d624555301f6dd57fec0071107566f29c2ab6b8cdf	-100000000	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	10000000000	0xfbbe90dd04250b5e789ed9d1bfba2476e524a852	false	3035915000000	false	100000000	1	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	89152508	0x4254432d55534400000000000000000000000000000000000000000000000000	2023-04-11T19:15:41.000Z	true	0x63b8e620040f0bbb347257ab44592b58508fa9a077cd1c7b7f47d4a976cd9f55
120000	0xce83bde7fa46d89c3cbda3e78aeaf2d1cd6dd30a97774ad187528c6d7244f047	1036168	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	120000000	0xb73d499f70fdc40d875a2d2e73dc133de910ce32	false	200358042500	true	12000000	2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	89002622	0x5841552d55534400000000000000000000000000000000000000000000000000	2023-04-11T10:42:46.000Z	false	0xd88de96af94140c8421ae4d7242f38b9942e7285d1b2adeed2682446549c8677
1000000	0x936db894e884ceb5ccb4be55e6e72f7986ef8ca294ab4c93b8e0014a0211c250	-422450	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	1000000000	0x1f20d58ed7138e62deba721908002b3d7c350a53	false	189233666666	true	250000000	2	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	89183621	0x4554482d55534400000000000000000000000000000000000000000000000000	2023-04-11T22:07:09.000Z	false	0x751b75af6d73f423fb86c72ff24fc5b4109b1c8cb6cbb3c0e7636180aef29613

Example Query

Query with partition filter

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

Trading_PositionUpdated_event

Position update events from UniDEX V1 perpetual futures on Optimism, capturing changes to leveraged positions including entry price, size, margin, direction (long/short), and fees. Used for tracking position lifecycle, leverage ratios, and trader behavior across trading pairs like ETH-USD, BTC-USD, and ARB-USD.

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	in_currency	block_number	in_productId	block_timestamp	transaction_hash
100000000	0x6c547e51a3429b0c2f41700e3d867de243f7ba65528d3fb8ce650171c1a268a1	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	100000000000	0xe0eda505fe162a4319ee1b887b1b598906e8ec4c	false	178246245250	true	1000000000	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	97490293	0x4554482d55534400000000000000000000000000000000000000000000000000	2023-05-11T17:27:47.000Z	0xb50a60562e894268bfea6ffbb4c608396c36aeaea6f86e6f2124ac71094fbee0
100000000	0x6c547e51a3429b0c2f41700e3d867de243f7ba65528d3fb8ce650171c1a268a1	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	100000000000	0xe0eda505fe162a4319ee1b887b1b598906e8ec4c	false	181853047750	true	1000000000	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	97389939	0x4554482d55534400000000000000000000000000000000000000000000000000	2023-05-11T08:03:47.000Z	0x9562f566056f6a48dd7c3fd9827799b9903844e38316590ca8cc74c3cf518634
100000000	0x6c547e51a3429b0c2f41700e3d867de243f7ba65528d3fb8ce650171c1a268a1	0x21366a8960fd8f761b7596170f16bcfc1be8b8d6	200000000000	0xe0eda505fe162a4319ee1b887b1b598906e8ec4c	false	183372473750	true	2000000000	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	97333937	0x4554482d55534400000000000000000000000000000000000000000000000000	2023-05-11T00:49:12.000Z	0xd1a1bca4b9216ce5cc2e53cf14ff2a069dcb8d1889af9042f2bb81a83021415a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.unidex_v1_optimism.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_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_PositionUpdated_event

Tables

Pool_Deposit_event

Pool_Withdraw_event

Settlement_Interaction_event

Settlement_Settlement_event

Settlement_Trade_event

Trading_ClosePosition_event

Trading_PositionUpdated_event