Skip to main content

​
Tables

​
LiquidityPool_DepositProcessed_event

Processed liquidity pool deposit events from Lyra v2 options protocol on Arbitrum, recording deposit amounts, LP tokens received, token prices, and queue identifiers. Enables analysis of liquidity provision patterns, deposit/LP token exchange rates, and pool participation timing.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_depositQueueIdSTRINGSequential identifier assigned to the deposit in the liquidity pool’s processing queue. Used to track and match deposit requests with their corresponding processed events.
in_amountDepositedSTRINGQuantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.
in_tokenPriceSTRINGPrice of the liquidity pool token at the time of the operation. Integer string representation of the token price in wei (18 decimal places).
in_tokensReceivedSTRINGNumber of liquidity pool tokens minted and allocated to the beneficiary for their deposit. Denominated in the pool’s native token units with 18 decimal precision.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
addressremovedin_callerlog_indexblock_numberin_timestampin_tokenPricein_beneficiaryblock_timestamptransaction_hashin_depositQueueIdin_tokensReceivedin_amountDeposited
0xb619913921356904bf62aba7271e694fd95aa10dfalse0xa2bcad247c64da44739e141b491fe4238a4d04802115878712169057346710365346266220434800x2e8fba7125cfad75b8bc750832b06acae9729b162023-07-28T19:44:27.000Z0x8698d4a96bb6b3fb7802babfe646983fe50032f41723edadd0c70e6854e340e6400554979398214334639895698805000000000000
0xb619913921356904bf62aba7271e694fd95aa10dfalse0xa2bcad247c64da44739e141b491fe4238a4d04802115809770169055366510365656634849387410xaf806997a51a29ad14905e322d81154ba81aaa042023-07-28T14:14:25.000Z0x80141d963bad1dcb4df19f983c9177b156a84c2cb055a03983883835712810c2400497003020206120292360100550000000000000000
0xec6f3ef9481e7b8484290edbae2cedcdb0ce790efalse0xa2bcad247c64da44739e141b491fe4238a4d0480211582399416905572809758599166846187310xa24c247c1c7157e6582df88682918d345e2adfc02023-07-28T15:14:40.000Z0x8d5b5ea1c9066a9d5e10b9548209db352cd9dd0b14951149ce463c9843b0065237110247372424081057239511000000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.lyra_v2_arbitrum.LiquidityPool_DepositProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
LiquidityPool_WithdrawProcessed_event

Completed withdrawal records from Lyra v2 options protocol liquidity pools on Arbitrum, tracking queue IDs, LP token amounts burned, quote tokens received, and token pricing at execution. Used for analyzing liquidity provider exit activity and withdrawal queue dynamics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_withdrawalQueueIdSTRINGUnique identifier for this specific withdrawal request in the Lyra V2 liquidity pool’s withdrawal queue. Sequential numeric ID assigned when the withdrawal is initiated, used to track and process withdrawals in order.
in_amountWithdrawnSTRINGAmount of liquidity pool tokens withdrawn by the user from the queue, denominated in the pool’s native token. Values are stored as wei-denominated strings (18 decimal places) representing the LP token quantity being redeemed.
in_tokenPriceSTRINGPrice of the liquidity pool token at the time of the operation. Integer string representation of the token price in wei (18 decimal places).
in_quoteReceivedSTRINGQuote token amount received by the beneficiary from the liquidity pool withdrawal. Value is in the smallest denomination (wei-equivalent) of the quote asset, typically stored as an 18-decimal fixed-point integer.
in_totalQueuedWithdrawalsSTRINGTotal amount of liquidity pool tokens queued for withdrawal across all pending requests after processing this withdrawal. Denominated in the pool’s native token units with 18 decimal precision.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
addressremovedin_callerlog_indexblock_numberin_timestampin_tokenPricein_beneficiaryblock_timestampin_quoteReceivedtransaction_hashin_amountWithdrawnin_withdrawalQueueIdin_totalQueuedWithdrawals
0xb619913921356904bf62aba7271e694fd95aa10dfalse0xa2bcad247c64da44739e141b491fe4238a4d04802117741434169106666810334278202712293830x86a611704cafefa7dfcafed96f340114a07980342023-08-03T12:44:28.000Z1006851132379605357410xed128afee7cae84f150219124ba0f4d56bd4528cb9d6c8344aa4a10d60b6182d974282976159235956053079135214361717250450611353
0xb619913921356904bf62aba7271e694fd95aa10dfalse0xa2bcad247c64da44739e141b491fe4238a4d04802117648351169104326010334211892391766900x4ac3c9c67296646e57d43b60af2b6ed4170f71252023-08-03T06:14:20.000Z1114127769248943127350x2165dfd01938ba515ff05127ee60391ffce2a8fe6c15144476820e5c14c232d51078096502036293717313075178278723777798919538387
0xb619913921356904bf62aba7271e694fd95aa10dfalse0xa2bcad247c64da44739e141b491fe4238a4d04802117847545169109366910335096579957725070x607d2381afecbd80c4ad5cce8059205c2a2979662023-08-03T20:14:29.000Z7546173106608739249840xe85b2aa028ec2186db44f6b14882a472fb167e5dc839a0fc925eb48c308f86277301502262922835985293081196526680204379177081555
Query with partition filter
SELECT *
FROM `tt-contracts.lyra_v2_arbitrum.LiquidityPool_WithdrawProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
OptionMarket_Trade_event

Options trade execution and collateral adjustment events from Lyra V2 decentralized options protocol on Arbitrum. Records strike prices, expiries, option types (calls/puts), collateral positions, spot prices, and trader addresses for analyzing options flow and market activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_referrerSTRINGAddress that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tradeSTRUCT<strikeId STRING, expiry STRING, strikePrice STRING, optionType INT64, tradeDirection INT64, amount STRING, setCollateralTo STRING, isForceClose BOOL, spotPrice STRING, reservedFee STRING, totalCost STRING>Identifier or structured data representing the trade or swap operation. Specific format varies by protocol implementation.
in_tradeResultsARRAY<STRUCT<amount STRING, premium STRING, optionPriceFee STRING, spotPriceFee STRING, vegaUtilFee STRUCT<preTradeAmmNetStdVega STRING, postTradeAmmNetStdVega STRING, vegaUtil STRING, volTraded STRING, NAV STRING, vegaUtilFee STRING>, varianceFee STRUCT<varianceFeeCoefficient STRING, vega STRING, vegaCoefficient STRING, skew STRING, skewCoefficient STRING, ivVariance STRING, ivVarianceCoefficient STRING, varianceFee STRING>, totalFee STRING, totalCost STRING, volTraded STRING, newBaseIv STRING, newSkew STRING>>Structured output containing the financial results and fees from executing the option trade. Typically populated with premium amounts, trading fees, and profit/loss calculations when the trade executes.
in_liquidationSTRUCT<rewardBeneficiary STRING, caller STRING, returnCollateral STRING, lpPremiums STRING, lpFee STRING, liquidatorFee STRING, smFee STRING, insolventAmount STRING>Details of any liquidation that occurred with this trade, including fees, caller address, and collateral returned. All fields are zero when no liquidation is involved in the trade.
in_longScaleFactorSTRINGScaling factor applied to long option positions in this market, represented as an 18-decimal fixed-point number. Typically 1e18 (1.0) in standard conditions, as shown in all sample transactions.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
addressremovedin_tradein_traderlog_indexin_referrerblock_numberin_timestampin_positionIdin_liquidationblock_timestampin_tradeResultstransaction_hashin_longScaleFactor
0x919e5e0c096002cb8a21397d724c4e3ebe77bc15false{“amount”:“0”,“expiry”:“1689321600”,“strikeId”:“310”,“spotPrice”:“1882524000000000000000”,“totalCost”:“0”,“optionType”:2,“reservedFee”:“0”,“strikePrice”:“1900000000000000000000”,“isForceClose”:false,“tradeDirection”:0,“setCollateralTo”:“3920370274491289088”}0xc163747c81e90e9333b1e1e6e0a7b910f2fe90c7120x140afdec70495afdc123f7b700fd19903cf4af6c110543415168918970111207{“lpFee”:“0”,“smFee”:“0”,“caller”:“0x0000000000000000000000000000000000000000”,“lpPremiums”:“0”,“liquidatorFee”:“0”,“insolventAmount”:“0”,“returnCollateral”:“0”,“rewardBeneficiary”:“0x0000000000000000000000000000000000000000”}2023-07-12T19:21:41.000Z[]0x419c3fdf42f79cab32a98c4ad6e78848e1005f416586487a2ee975f25b1cc4101000000000000000000
0x919e5e0c096002cb8a21397d724c4e3ebe77bc15false{“amount”:“0”,“expiry”:“1689321600”,“strikeId”:“308”,“spotPrice”:“1873170000000000000000”,“totalCost”:“0”,“optionType”:4,“reservedFee”:“0”,“strikePrice”:“1850000000000000000000”,“isForceClose”:false,“tradeDirection”:0,“setCollateralTo”:“7360104171240590403613”}0xd74de22f8f569afd28400cf5b9178bd797f2891130x0000000000000000000000000000000000000000110603576168920565611928{“lpFee”:“0”,“smFee”:“0”,“caller”:“0x0000000000000000000000000000000000000000”,“lpPremiums”:“0”,“liquidatorFee”:“0”,“insolventAmount”:“0”,“returnCollateral”:“0”,“rewardBeneficiary”:“0x0000000000000000000000000000000000000000”}2023-07-12T23:47:36.000Z[]0x17ae7916272a28fc312d5b8d6f1678fa46c87e123b99c3a2cf88bc97ffc6f0611000000000000000000
0x919e5e0c096002cb8a21397d724c4e3ebe77bc15false{“amount”:“0”,“expiry”:“1689926400”,“strikeId”:“327”,“spotPrice”:“1871413000000000000000”,“totalCost”:“0”,“optionType”:2,“reservedFee”:“0”,“strikePrice”:“1850000000000000000000”,“isForceClose”:false,“tradeDirection”:0,“setCollateralTo”:“20000000000000000000”}0xf61dc7a230cafcd870abc9e80dcbe6416381c69c30x0000000000000000000000000000000000000000110594840168920328911416{“lpFee”:“0”,“smFee”:“0”,“caller”:“0x0000000000000000000000000000000000000000”,“lpPremiums”:“0”,“liquidatorFee”:“0”,“insolventAmount”:“0”,“returnCollateral”:“0”,“rewardBeneficiary”:“0x0000000000000000000000000000000000000000”}2023-07-12T23:08:09.000Z[]0xbd1c5abf0a5211e8f16e15bec81fe41c6b3a32e8725426b062be5cec5315e3c11000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.lyra_v2_arbitrum.OptionMarket_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
OptionMarketWrapper_PositionTraded_event

Options position trade events from Lyra v2 protocol on Arbitrum, capturing opens and closes with position size, fees, collateral costs, and long/short directionality. Used for analyzing options trading activity, fee structures, and trader position management behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_isOpenBOOLIndicates whether the trade opens or closes an options position. True represents opening a new position or adding to an existing one, false represents closing or reducing a position.
in_isLongBOOLBoolean 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_marketSTRINGTrading pair or market identifier specifying the assets being traded or operated on.
in_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_totalCostSTRINGTotal cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.
in_totalFeeSTRINGTotal fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
in_swapFeeSTRINGFee charged for executing the swap transaction. String-encoded integer value representing the fee amount in the smallest denomination of the token.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_ownerin_tokenin_amountin_isLongin_isOpenin_marketlog_indexin_swapFeein_totalFeeblock_numberin_totalCostin_positionIdblock_timestamptransaction_hash
0x4cdb992fdefcb840125dd344f87bdcbb8fefa3e7false0xc163747c81e90e9333b1e1e6e0a7b910f2fe90c70xff970a61a04b1ca14834a43f5de4533ebddb5cc85000000000000000000falsetrue0x919e5e0c096002cb8a21397d724c4e3ebe77bc1533076751995488924495696611731222441868192568106986222902023-03-02T16:38:09.000Z0xd33f416c2b12da18bc4efe1d12d840fb3898b5f5f8e2513165a6b28a6d470e96
0x4cdb992fdefcb840125dd344f87bdcbb8fefa3e7false0xc163747c81e90e9333b1e1e6e0a7b910f2fe90c70xff970a61a04b1ca14834a43f5de4533ebddb5cc85000000000000000000falsetrue0x919e5e0c096002cb8a21397d724c4e3ebe77bc1535068835999072137893556601479617082143035890468268512712023-03-02T09:19:57.000Z0xb0bca2205dd7fde55e18b2f78a87e3663a77cf489ebebb6bd999cb7bcd0c6154
0x4cdb992fdefcb840125dd344f87bdcbb8fefa3e7false0xc163747c81e90e9333b1e1e6e0a7b910f2fe90c70xff970a61a04b1ca14834a43f5de4533ebddb5cc85000000000000000000falsetrue0x919e5e0c096002cb8a21397d724c4e3ebe77bc1542071133250890225964266601484417013172884095142787012712023-03-02T09:20:09.000Z0x5fc69e9f00267a275d7b42e29d67666a577b90f140148e21e918002c4fb4a12c
Query with partition filter
SELECT *
FROM `tt-contracts.lyra_v2_arbitrum.OptionMarketWrapper_PositionTraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Registry_MarketUpdated_event

Registry configuration events from Lyra v2 options protocol on Arbitrum capturing market deployments and updates. Records include contract addresses for option markets, liquidity pools, oracles, and hedging components used to track protocol infrastructure changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_optionMarketSTRINGContract address of the Lyra option market being registered or updated in the protocol registry. Hex-encoded, 0x-prefixed 40-character string identifying the specific market contract on Arbitrum.
in_marketSTRUCT<liquidityPool STRING, liquidityToken STRING, greekCache STRING, optionMarket STRING, optionMarketPricer STRING, optionToken STRING, poolHedger STRING, shortCollateral STRING, gwavOracle STRING, quoteAsset STRING, baseAsset STRING>Trading pair or market identifier specifying the assets being traded or operated on.
addressremovedin_marketlog_indexblock_numberblock_timestampin_optionMarkettransaction_hash
0x6c87e4364fd44b0d425adfd0328e56b89b201329false{“baseAsset”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“greekCache”:“0x4b236ac3b8d4666cbdc4e725c4366382aa30d86b”,“gwavOracle”:“0xae6b4e307cbdc779f19d3965a7ddf8e4de307487”,“poolHedger”:“0x3f57359fec19e86323ddc5a1e74c072fffa0dc0f”,“quoteAsset”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“optionToken”:“0xe485155ce647157624c5e2a41db45a9cc88098c3”,“optionMarket”:“0x919e5e0c096002cb8a21397d724c4e3ebe77bc15”,“liquidityPool”:“0xb619913921356904bf62aba7271e694fd95aa10d”,“liquidityToken”:“0xbdf4e630ded14a129ae302f930d1ae1b40fd02aa”,“shortCollateral”:“0xef4a92fcde48c84ef2b5c4a141a4cd1988fc73a9”,“optionMarketPricer”:“0xdacee745b517c9cdfd7f749dff9eb03f51a27a13”}1567965392023-01-31T04:17:34.000Z0x919e5e0c096002cb8a21397d724c4e3ebe77bc150x991236e92dc06e7b105028a23e5dcd8c19c241767e9be46ffcf061aca80e7b1a
0x6c87e4364fd44b0d425adfd0328e56b89b201329false{“baseAsset”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“greekCache”:“0x4f7c8ee91d41867fe3fb564b4b293456f36a78e0”,“gwavOracle”:“0x339c589b18d70aeae86700d1717a88b521538498”,“poolHedger”:“0x8dcd2f1bb3380927bbe68530b6eb383b1e8c440a”,“quoteAsset”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“optionToken”:“0x0e97498f3d91756ec7f2d244ac97f6ea9f4ebbc3”,“optionMarket”:“0xe044919cf58dfb066fc9de7c69c7db19f336b20c”,“liquidityPool”:“0xec6f3ef9481e7b8484290edbae2cedcdb0ce790e”,“liquidityToken”:“0xbb6d72147280a2147a23ce196326e0547eaec401”,“shortCollateral”:“0x5a4842c0c1f81ebbae7bb3ec07edf7ae55aac631”,“optionMarketPricer”:“0x6d859a7d88d94870ee6510acaa48e3d8684e7b03”}1642685282023-02-25T00:25:03.000Z0xe044919cf58dfb066fc9de7c69c7db19f336b20c0x5669372c04d2e1f564cb6032dbd778c4a5a87cbea5b4517b23e9b86dd10db55d
0x6c87e4364fd44b0d425adfd0328e56b89b201329false{“baseAsset”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“greekCache”:“0x4b236ac3b8d4666cbdc4e725c4366382aa30d86b”,“gwavOracle”:“0xae6b4e307cbdc779f19d3965a7ddf8e4de307487”,“poolHedger”:“0x92a612729bf7e832072540222306aebd6ba0f891”,“quoteAsset”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“optionToken”:“0xe485155ce647157624c5e2a41db45a9cc88098c3”,“optionMarket”:“0x919e5e0c096002cb8a21397d724c4e3ebe77bc15”,“liquidityPool”:“0xb619913921356904bf62aba7271e694fd95aa10d”,“liquidityToken”:“0xbdf4e630ded14a129ae302f930d1ae1b40fd02aa”,“shortCollateral”:“0xef4a92fcde48c84ef2b5c4a141a4cd1988fc73a9”,“optionMarketPricer”:“0xdacee745b517c9cdfd7f749dff9eb03f51a27a13”}0549075992023-01-23T12:02:12.000Z0x919e5e0c096002cb8a21397d724c4e3ebe77bc150xc8b499d20c518eb918823583d91cf6fc313b5208d16ff80ce92ba9668ff3b222
Query with partition filter
SELECT *
FROM `tt-contracts.lyra_v2_arbitrum.Registry_MarketUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100