lyra_v1_optimism

Tables

LyraDistributor_Claimed_event

LYRA token claim events from the Lyra protocol distributor contract on Optimism. Tracks when users claim their LYRA token allocations with claimer addresses and amounts (in wei) for analyzing token distribution and vesting schedules.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_claimer`	`STRING`	Address of the account initiating the claim transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x0bfb21f64e414ff616ac54853e52679eedb22dd2	false	21432297950817620000	1	0x413642cafe68f1fe718d46ec32136e209fd7ee5b	1853278	2022-01-02T17:38:52.000Z	0x3e72548a16a13fbc42463b4d1de4cf10a61afd92d013ebab03bba3b678aed017
0x0bfb21f64e414ff616ac54853e52679eedb22dd2	false	73149654602173600000000	1	0x6e3aa85db95bba36276a37ed93b12b7ab0782afb	1847418	2022-01-02T12:58:36.000Z	0xe298d58cfe292ac2f2e38a8fcbba2916485a70cebc87d78df82da2dc501d4961
0x0bfb21f64e414ff616ac54853e52679eedb22dd2	false	41816758763828190000	1	0x935361eb81ffe4eef326902ac37e8aba82edf403	1836246	2022-01-02T00:22:04.000Z	0x2e8c66e929e617e52a5553b5664962b62c0e2df08dade4b65a48e6d1c972bae0

Example Query

Query with partition filter

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

SBTCLiquidityPool_Deposit_event

Deposit events from Lyra V1’s sBTC (synthetic Bitcoin) liquidity pool on Optimism, recording liquidity provider contributions with deposit amounts and issued certificate IDs. Used for tracking liquidity provision activity and certificate-based LP token issuance in the options protocol.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	3511550000000000000000	2	2051140	0x1863b6151c444cf0abae868a9a327adeb5632362	2022-01-07T12:48:48.000Z	1963	0x53396a87c3aa04759f9d9002213459e577c3efa2c3f8b24e43c8bdb02eb87f0a
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	443531856463258874215	2	2041602	0xb0987ca0d0cad19de9b5a1b0e7761a249254472f	2022-01-07T08:02:28.000Z	1938	0xfe95c7b513bf6b89888aa73306fd64a911a25cc695ecad46fc571e5f9ef51a26
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	32134146483361247846626	2	2045157	0x07e9aa40272429a4e2ee072208fdeb76407249a2	2022-01-07T09:32:04.000Z	1948	0xca65df369e016503dbae0c694cd43396583c94f10dde5e83d6fa8c3d3ca83158

Example Query

Query with partition filter

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

SBTCLiquidityPool_Withdraw_event

Liquidity provider withdrawal events from Lyra V1’s sBTC options liquidity pool on Optimism, tracking certificate redemptions with withdrawn amounts and pool reserve balances. Used for analyzing LP behavior, liquidity flows, and pool utilization over time.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_totalQuoteAmountReserved`	`STRING`	Total amount of quote asset (typically stablecoins like USDC) reserved across all liquidity positions in the pool at withdrawal time. Denominated in wei (18 decimals), representing aggregate collateral backing options in the Lyra AMM.

Sample Data

address	removed	in_value	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash	in_totalQuoteAmountReserved
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	44994774282941304798	2	12550280	0x5c4a64abd18c714bde447bf32a8a34edd3b63e25	2022-06-21T08:08:14.000Z	619	0x197e8922d8d5cb64defd3c92412f6399c596dd666acdb99f4e321c9f5a5764f3	147952875546232939689748
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	4611427489199088848555	2	12531045	0x58b13e4d37183bcc68d525c6c74f798b70e3cf01	2022-06-21T03:33:44.000Z	1300	0x388b99e45bddf95236b49c9ed613274f959ba597030a214c59bf9260729c9a29	147997870320515880994546
0x788843de0be1598155bffaab7cfa2ecbd542e7f1	false	571394541328361851178	2	12535330	0xa06b4f71b94ec6b59e0633c015772d3f1efdf7ca	2022-06-21T04:43:18.000Z	2099	0x563a8cae71faf2aee54d9d4a15ea4dba0a6b39c3e094914d6d3b2e3e2b7a8cfa	147997870320515880994546

Example Query

Query with partition filter

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

SBTCOptionMarket_ListingAdded_event

Events emitted when new option strike listings are added to the Lyra V1 sBTC (Synthetic Bitcoin) option market on Optimism. Captures strike prices, volatility skew parameters, board and listing identifiers for tracking available option contracts over time.

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_boardId`	`STRING`	Unique identifier for the options board grouping multiple listings with the same expiry date. Numeric string representation.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_strike	log_index	in_boardId	block_number	in_listingId	block_timestamp	transaction_hash
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	1040000000000000000	false	60000000000000000000000	1	2	127400	37	2021-11-16T10:46:49.000Z	0x8a10081f4b6d0655b352c1ffc93310c1b5438174cead9464896dc347483a3a25
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	1170000000000000000	false	39000000000000000000000	1	15	3699508	545	2022-02-20T10:57:43.000Z	0xeaa72c61b2dd438ce43b8d182dee529d901e861b6a7d4f08d624da23b958f3f4
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	1230000000000000000	false	37000000000000000000000	1	15	3699498	541	2022-02-20T10:57:43.000Z	0x47a8f2f28f44ce25973cf8438bfb3680d3dba0327ecc58383998c8fbd7c7baef

Example Query

Query with partition filter

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

SBTCOptionMarket_PositionClosed_event

Closed options position events from Lyra v1’s synthetic Bitcoin (sBTC) market on Optimism, capturing trade closes with option amount, strike listing ID, total cost, and trade type (long/short call/put). Used for analyzing options trading activity, position lifecycle, and trader behavior in BTC-denominated options.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	block_timestamp	transaction_hash
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	1000000000000000000	0x0337dcbc6f5f2c2ca665fdd487f7d8f23c305b08	9	4047473	553	870208440216387874374	2022-03-02T07:02:43.000Z	0xc6cf9bc53d437a8453b30c32364bf925991fe7f7deb9137869338fbec48eb424
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	1000000000000000000	0x7302bc5b47f5588174a148c90747a88cb528a8c1	9	3560485	485	1163584478738099367317	2022-02-15T01:53:29.000Z	0xf7444c073e3b8c6be339905594d8c28340d39bf30bff11ac0440978bcd9bc96b
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	2500000000000000	0x5050da75b7b881f1e234d57bc3b625d68af65451	9	10703951	1029	3791318289057959007	2022-06-06T03:57:39.000Z	0xe6421e95b4b82a4311a12a72b306d76077d7943682a46716e9a936a7b6c641b8

Example Query

Query with partition filter

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

SBTCOptionMarket_PositionOpened_event

Option position opening events for sBTC (synthetic Bitcoin) options on Lyra V1 protocol on Optimism. Captures trader addresses, listing identifiers, position sizes, total costs, and trade types for analyzing options trading activity and premium flows.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	block_timestamp	transaction_hash
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	1000000000000000000	0x0c5a369be6d584d6b054494a22d71b61ef1fe9af	8	8440174	841	200522382090528751453	2022-05-17T01:03:58.000Z	0x05fe637e8f884f13f11adde2e2b95b9919cf3565423c0ef4f04a07183b778212
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	10000000000000000	0x2222461b23df755ce90771291749b40f7136ab0c	8	8495041	977	40848172695219717285	2022-05-17T23:21:49.000Z	0x2ef5100633767d39755752aa5471fc894f8320ce42fc57d0a455af76e3712031
0x47b5bb79f06f06db3d77c6cc4db1ad6e84faf1f4	false	10000000000000000	0x2222461b23df755ce90771291749b40f7136ab0c	8	8495026	977	40848473758694643483	2022-05-17T23:21:10.000Z	0xc4d71c22127419ee193ebe4386e2e331e3adcd0507714914811858e3980df212

Example Query

Query with partition filter

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

SETHLiquidityPool_Deposit_event

Liquidity deposit events for the sETH (Synthetix ETH) pool on Lyra V1 options protocol on Optimism, recording depositor addresses, deposit amounts in wei, and certificate IDs issued to liquidity providers. Used for tracking liquidity provision activity and LP token minting in the sETH market.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash
0x2935cd347b79c319a6464fe3b1087170f142418c	false	54712629133013777497	2	5517631	0xcabb32bc7832fc5bd51da6e4def3933ec0b0a1a1	2022-04-08T08:34:43.000Z	13431	0xf88970951251af1121a556f5f7ced5bd33d832d8d581524174e796ca3be8047f
0x2935cd347b79c319a6464fe3b1087170f142418c	false	17988865110456631634	2	5524669	0x84ecf15af6fec307afeab934b46947967bc02d5f	2022-04-08T11:53:37.000Z	13432	0xbf2ac650c4768dea1ceb4cdf3ebfc96a0fdc53df162b2c0fa9bc4bc8fd2a1cb5
0x2935cd347b79c319a6464fe3b1087170f142418c	false	1054000000000000000	2	5538863	0xa1622da220732bd59cde8de6ca6f07cb398bb1f7	2022-04-08T17:02:22.000Z	13436	0x6cf655fa66638099b17a7b12af83937c861663d05e8efdf3b123bdfdeb4dd131

Example Query

Query with partition filter

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

SETHLiquidityPool_Withdraw_event

Liquidity provider withdrawal events from Lyra V1’s sETH (Synthetic ETH) options liquidity pool on Optimism. Tracks LP certificate redemptions with withdrawn quote token amounts and reserved liquidity for analyzing LP exits and pool liquidity changes.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_totalQuoteAmountReserved`	`STRING`	Amount of quote currency (typically stablecoins like sUSD) reserved in the Lyra liquidity pool at the time of withdrawal. Represented as a wei-denominated integer value showing total pool reserves after the withdrawal event.

Sample Data

address	removed	in_value	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash	in_totalQuoteAmountReserved
0x2935cd347b79c319a6464fe3b1087170f142418c	false	43147338612249630227363	2	1026362	0x654c775f20e4f0cb1eae929f8511dd94bc94504c	2021-12-10T23:20:12.000Z	7504	0x850bdd8a22fee438e24f5e980178526789fadabb20e5df28d1ad502edb2b0875	456104624604002353972022
0x2935cd347b79c319a6464fe3b1087170f142418c	false	10000000000000000000000	2	1026252	0x73c9306fe38fa1c5823345474ce20c94563003cb	2021-12-10T23:14:31.000Z	12083	0x4614beeac87cd0aa4a42519e068dc19d1c63d1e7b7bf3c6e14e65594323b9937	499251963216251984199385
0x2935cd347b79c319a6464fe3b1087170f142418c	false	1958717582603239348704	2	1025744	0xd63154abc9c6655626f16f0aed41c2e958410724	2021-12-10T22:51:16.000Z	8586	0x5b444e5c1735f15a19da464fc5af23343dffe19276b9c2043a2a4ed07c6d7a05	499807902716251984199385

Example Query

Query with partition filter

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

SETHOptionMarket_ListingAdded_event

New option listing events from Lyra V1’s sETH (Synthetix ETH) options market on Optimism, capturing when strike prices are added to option boards with their initial skew parameters. Used for tracking option product launches and market structure changes over time.

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_boardId`	`STRING`	Unique identifier for the options board grouping multiple listings with the same expiry date. Numeric string representation.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_strike	log_index	in_boardId	block_number	in_listingId	block_timestamp	transaction_hash
0x1f6d98638eee9f689684767c3021230dd68df419	970000000000000000	false	2800000000000000000000	1	22	4651928	797	2022-03-20T23:22:10.000Z	0x2600a07ff01e971b49f821dbbcb4ac48190061ac4b4839778713cdc245145a6b
0x1f6d98638eee9f689684767c3021230dd68df419	970000000000000000	false	3200000000000000000000	1	22	4651899	793	2022-03-20T23:21:36.000Z	0xbad7b7dad375c58b13968dbd087da5ba60d1e07e201e433341fe23e1bde74169
0x1f6d98638eee9f689684767c3021230dd68df419	1000000000000000	false	1000000000000000	3	51	84789217	1285	2023-03-30T08:01:09.000Z	0x89159a20f9dc3b65ce0e885d93da579481b5db4428ab0aa8daa5a49065ca0e0a

Example Query

Query with partition filter

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

SETHOptionMarket_PositionClosed_event

Closed position events from Lyra v1 synthetic ETH (sETH) options market on Optimism, recording when traders close options positions with amount, total cost, and trade type. Useful for analyzing options trading patterns, profit/loss calculations, and position lifecycle tracking.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	in_tradeType	block_timestamp	transaction_hash
0x1f6d98638eee9f689684767c3021230dd68df419	false	10000000000000000	0x4fd0cca805a22419ed0bc7d516da9a3d8bda28ff	9	10640668	1145	1192786367725116945	1	2022-06-05T12:00:06.000Z	0x3cc3e18443af40569d1873b2184d3302364232f53d129f58d3b51f516248a8d2
0x1f6d98638eee9f689684767c3021230dd68df419	false	1000000000000000000	0x1504c8a639d860857eb1588b1da3ace5580d607a	9	10670477	1157	10840800235874053255	0	2022-06-05T19:07:20.000Z	0xabdf953e3f426d698c37028f98c9a27513ec4903b99e89fb3f009faed65cb437
0x1f6d98638eee9f689684767c3021230dd68df419	false	1000000000000000000	0xb17e300fa3366775991a34988aa97e3511a5d480	9	10667794	1157	13353742121017536772	0	2022-06-05T18:08:47.000Z	0x192cca363be1a289383c907d74429e21c82ae482ba69e802f868858505f5d81f

Example Query

Query with partition filter

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

SETHOptionMarket_PositionOpened_event

Position opening events from Lyra V1’s sETH (Synthetix Ethereum) options market on Optimism. Captures trader addresses, option listing IDs, position sizes, total costs paid, and trade types for analyzing options market activity and user behavior.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	block_timestamp	transaction_hash
0x1f6d98638eee9f689684767c3021230dd68df419	false	50000000000000000	0xc1a9977bffc75c65a7eec88f3688a3a0e0ca8fa7	8	6358259	809	5480902593249008262	2022-04-24T10:07:11.000Z	0xa9f25ab519f9bcb6f25f665020201847a679a60974d95ceb54f7ea3f3d70bb5c
0x1f6d98638eee9f689684767c3021230dd68df419	false	200000000000000000	0x670ec52a4cfe19bf3df1c3f9df33e4105d55532b	8	6341744	813	2355249010776185511	2022-04-24T04:43:25.000Z	0xafcc72a6b04fafdcf1326ea675f153d1dbfe20f15a57bd30a371413c611ac162
0x1f6d98638eee9f689684767c3021230dd68df419	false	200000000000000000	0xbbcadc0a484f54989cb30da5e75140bb8186cf24	8	6341803	813	2356110961099084319	2022-04-24T04:44:30.000Z	0xb2b347376d08c0b3fd0352254df41b8850b44eb11203f97597b203b73dfcc26b

Example Query

Query with partition filter

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

SLINKLiquidityPool_Deposit_event

Deposit events from the sLINK (Synthetic LINK) liquidity pool in Lyra V1 options protocol on Optimism. Records liquidity provider deposits with deposited amounts, beneficiary addresses, and LP token certificate IDs for tracking pool participation.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	61093237678440975565912	2	1018044	0xc0506f0b197899f168e751218f91e975dadd9b37	2021-12-10T18:00:40.000Z	2447	0x7d82717b92802793a3fcb213228a4e5ad55a790f311566c15903af2aec7b705d
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	18780134936990644838931	2	1003073	0xdf67361193d52ee42cb759eb98ce2c7978dd440e	2021-12-10T11:14:56.000Z	2408	0xa1d2e1b384937d20cd397f1e2a59e3e474fd3a7927a084879511a5e32e958b3f
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	1666234935229600832915	2	994078	0x67bc76e8fd78cc59594c9f43c643ea7cafa48669	2021-12-10T06:36:16.000Z	2394	0x5e3f20aa5cb4ffb008e47e633a86419c4ae1d901e99a96265d9da76efa7f64d7

Example Query

Query with partition filter

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

SLINKLiquidityPool_Withdraw_event

Liquidity provider withdrawal events from the Lyra V1 sLINK (Synthetix LINK) options liquidity pool on Optimism. Tracks LP certificate redemptions with withdrawn amounts and beneficiary addresses for analyzing liquidity provider behavior and pool capital flows.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_certificateId`	`STRING`	Unique identifier for the liquidity pool certificate issued to depositors. Numeric string representing the certificate token ID.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_totalQuoteAmountReserved`	`STRING`	Total amount of quote currency (typically USD stablecoin) reserved in the Lyra sLINK liquidity pool at the time of withdrawal. Value is in wei (18 decimals), representing pool-wide reserves across all positions.

Sample Data

address	removed	in_value	log_index	block_number	in_beneficiary	block_timestamp	in_certificateId	transaction_hash	in_totalQuoteAmountReserved
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	209737211807498389978	77	108254615	0xf844989ab675cb7da9f2eaa3d274dfe66c9502ce	2023-08-15T14:00:07.000Z	2223	0x4996125d17c1b550b82e661703c168132fe93c5dbd10392b2fd4321209978c10	197357992152186616565070
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	1015639507189382097561	2	17142871	0xc3ae5d875ac4672c21fb88ca62098a7e04746a30	2022-08-01T20:41:24.000Z	2748	0x01e5304978f27003f33c1b487c03a06820eaaaba74a603c56676e76f77d50385	204603295013102628077526
0x69b4b35504a8c1d6179fef7addcdb37a8c663bc9	false	124115726534097585564	2	17041848	0x8f688a91695f7d2a1e93e57cedcbf5c5202f617b	2022-08-01T06:00:32.000Z	752	0xbabb958c278ea311ec3e26c9371a8dc63424e14e6b051ed9cd40772b4bbae376	204603295013102628077526

Example Query

Query with partition filter

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

SLINKOptionMarket_ListingAdded_event

New option listing creation events from Lyra v1 sLINK (synthetic LINK) options markets on Optimism. Captures strikes, skew parameters, and board assignments for tracking available strike prices and market structure evolution.

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_boardId`	`STRING`	Unique identifier for the options board grouping multiple listings with the same expiry date. Numeric string representation.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_strike	log_index	in_boardId	block_number	in_listingId	block_timestamp	transaction_hash
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	1000000000000000000	false	21000000000000000000	1	6	568744	209	2021-11-28T21:44:21.000Z	0xa888f24ad2bf957fd1f35a1ab9e384fc4bc7c20e1e12c94e7d305bf7908d52a1
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	1000000000000000000	false	23000000000000000000	1	7	569218	213	2021-11-28T21:56:46.000Z	0x9e7fa25631579269a6c082eb86514bf59fd60732cc018c36e84ad9bce6a8527b
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	1000000000000000000	false	22000000000000000000	1	7	569239	217	2021-11-28T21:56:46.000Z	0x05111ea8db4c1f0c9c6edeffa90766b9a04786ffe070289a331b2aaa1d5b0917

Example Query

Query with partition filter

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

SLINKOptionMarket_PositionClosed_event

Position closure events from Lyra v1 sLINK (Synthetix LINK) options market on Optimism, capturing when traders exit long or short call/put positions with settlement amounts and trade types. Used for analyzing options trading patterns, profit/loss calculations, and market maker exit strategies.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	in_tradeType	block_timestamp	transaction_hash
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	1000000000000000000	0x1fa46b59c74e9bbd8bfe7feb935c69301ed5163e	9	6582309	749	242129742664858236	1	2022-04-27T09:08:33.000Z	0x41e0790732f1868d0522d70ce0e3a95786696a4af3c2ee169274f12a9c30467e
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	1000000000000000000	0x1fa46b59c74e9bbd8bfe7feb935c69301ed5163e	10	6582267	749	640033493837613507	3	2022-04-27T09:07:48.000Z	0x9ae361864c8b5887f4be6aa5d692330e221ce4a0020c6956e40401ba52d248b6
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	20000000000000000000	0x223ae404d269d29d09230615856f731a9bb2bb74	9	6602298	749	13335065942221054640	2	2022-04-27T14:21:50.000Z	0x16827acf02c8d5849460772382426d883a0f8e68e85d169a19074e46e0622e43

Example Query

Query with partition filter

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

SLINKOptionMarket_PositionOpened_event

Options position openings on Lyra v1’s sLINK (Synthetix LINK) market on Optimism. Records new position entries including option type (tradeType), contract amount, premium cost, and listing ID for analyzing trader behavior and option flow.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	in_tradeType	block_timestamp	transaction_hash
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	350000000000000000000	0x8541debdd03a78a2c29dcd9d1e588d30e1519b29	8	951305	125	90878600702352364650	0	2021-12-09T02:56:58.000Z	0x6929d3691ca9d521699c104e7b5c404d41bbf64923c41e06dfc1db7d86c4f3d4
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	500000000000000000000	0x8541debdd03a78a2c29dcd9d1e588d30e1519b29	8	950059	209	128697455171260009000	2	2021-12-09T02:00:42.000Z	0x17ddf939a64d8062068c717938981ed60b8b3bf8da039434d514e6a9304e7e3b
0xbcb01210bd1c0790ca45cc4c49d9a183be99824d	false	5000000000000000000	0xf41066a0dc01e073110fc690512048b1d2c85946	9	957023	209	749086135792857660	3	2021-12-09T07:31:23.000Z	0xf15af11e13ef607260decb02c5d4086f98b76ff189db319aefcce09e68f072d1

Example Query

Query with partition filter

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

SSOLOptionMarket_ListingAdded_event

Option listing creation events from Lyra V1 protocol’s sSOL (synthetic SOL) option market on Optimism. Captures new strike prices added to option boards with their initial skew parameters for analyzing available trading strikes and market structure evolution.

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_boardId`	`STRING`	Unique identifier for the options board grouping multiple listings with the same expiry date. Numeric string representation.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_strike`	`STRING`	Strike price for the options contract. Numeric string representation of the price level in smallest denomination.
`in_skew`	`STRING`	Market skew representing the imbalance between long and short positions in the derivative contract. Numeric string representation of the net directional exposure in the smallest unit of the underlying asset.

Sample Data

address	in_skew	removed	in_strike	log_index	in_boardId	block_number	in_listingId	block_timestamp	transaction_hash
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	550000000000000000	false	95000000000000000000	4	12	6762506	349	2022-04-29T23:13:27.000Z	0x52b0fba743ad2052aec6885657b9af713c162dd2ab70d6c53f7ba1e619fd8f63
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	560000000000000000	false	115000000000000000000	8	12	6762506	365	2022-04-29T23:13:27.000Z	0x52b0fba743ad2052aec6885657b9af713c162dd2ab70d6c53f7ba1e619fd8f63
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	560000000000000000	false	110000000000000000000	7	12	6762506	361	2022-04-29T23:13:27.000Z	0x52b0fba743ad2052aec6885657b9af713c162dd2ab70d6c53f7ba1e619fd8f63

Example Query

Query with partition filter

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

SSOLOptionMarket_PositionClosed_event

Position closure events from Lyra v1 SSOL (Synthetic SOL) options market on Optimism, capturing trade details including option amount, total cost, listing ID, and trade type (buy/sell/liquidation). Used for tracking options position lifecycle and settlement 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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	block_timestamp	transaction_hash
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	90000000000000000000	0xded9b882fb636878ca868d02f32bb39a0783d747	9	7485774	341	92251815762717334530	2022-05-09T15:46:40.000Z	0xbdee0c785507e77dc7a68186e376291f96fb486b9114921ace61417b9a13d7b2
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	110000000000000000000	0xded9b882fb636878ca868d02f32bb39a0783d747	9	7491098	341	79141113348740817440	2022-05-09T16:42:47.000Z	0xb9e20a9bcc207f1016c099f33d804c10588f624ddeebb5bb583ddaedf3268798
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	200000000000000000000	0x7d96562a21c80fcbbb9974316a881b3b998856e7	9	7528189	433	328894715675299448600	2022-05-09T21:46:57.000Z	0xec09d13456c997f003944a6181ff2b5f6be178b768361543abe7d799f84eb448

Example Query

Query with partition filter

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

SSOLOptionMarket_PositionOpened_event

Position opening events from Lyra V1’s SOL (Solana) option market on Optimism, capturing option purchases with listing ID, trade amount, total cost, and trader addresses. Used for analyzing trading activity and option buyer behavior in Lyra’s SOL markets.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_listingId`	`STRING`	Unique identifier for the listing on the marketplace. Numeric string representation.
`in_tradeType`	`INT64`	Enumerated identifier representing the type of options trade action. Integer value encoding the trade direction and position type (long/short, call/put).
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalCost`	`STRING`	Total cost of the options position including premium and fees. Numeric string representation in smallest denomination of the settlement token.

Sample Data

address	removed	in_amount	in_trader	log_index	block_number	in_listingId	in_totalCost	block_timestamp	transaction_hash
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	12000000000000000000	0xb8d095b23282a6c5c94ac9d463f60511cece53c9	8	10174615	457	127349721409167091272	2022-06-02T04:05:38.000Z	0x9b119f51b46d20b84658326236df01508d8c42886aae18b1c5460cff71eeb140
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	1000000000000000000	0x08cdc58ec84f466903f5945fdcea6998badc7d3b	8	10123184	465	4392958951103545629	2022-06-02T00:37:43.000Z	0x6adedcaf6115f93952174a6cac8b1389ad889900d793d22b597ffbf9af3e46b0
0xa3562cac1c39f4d4166ce31005fc080ab41120ac	false	20000000000000000000	0x08cdc58ec84f466903f5945fdcea6998badc7d3b	8	10123547	465	88026336602613943300	2022-06-02T00:38:58.000Z	0x47725a2b5d47e19668c42c888aa3f3e3c7d44203e5120483115fc1fd18c183a5

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0xb02e538a08cfa00e9900cf94e33b161323d8d162	0xd83d6f32d0e7d498d513f4b9ddb029bc0b151612	false	259298840336283670339	1	7942414	2022-05-12T01:39:24.000Z	0xc28582eb9e82414de54b88019adaf4e94e7d53b3704c26093c1e842f26df1156
0xb02e538a08cfa00e9900cf94e33b161323d8d162	0x22e8c43b574df674c6082ceb3f415c4f7e1ced45	false	56349741369580755657	1	7930670	2022-05-12T00:18:56.000Z	0x6c3aaf3c114879721fa7616ef88f2285d56794b968dc8299089d108abbffb147
0xb02e538a08cfa00e9900cf94e33b161323d8d162	0xcf50fb42926b255747fb8b0ea8e26d4e66952ca4	false	2395768191273153145650	1	7947057	2022-05-12T02:08:49.000Z	0x889f147a092881dd96546be73fceaccec72593016d9bdceb8904e78f033d26a2

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LyraDistributor_Claimed_event

SBTCLiquidityPool_Deposit_event

SBTCLiquidityPool_Withdraw_event

SBTCOptionMarket_ListingAdded_event

SBTCOptionMarket_PositionClosed_event

SBTCOptionMarket_PositionOpened_event

SETHLiquidityPool_Deposit_event

SETHLiquidityPool_Withdraw_event

SETHOptionMarket_ListingAdded_event

SETHOptionMarket_PositionClosed_event

SETHOptionMarket_PositionOpened_event

SLINKLiquidityPool_Deposit_event

SLINKLiquidityPool_Withdraw_event

SLINKOptionMarket_ListingAdded_event

SLINKOptionMarket_PositionClosed_event

SLINKOptionMarket_PositionOpened_event

SSOLOptionMarket_ListingAdded_event

SSOLOptionMarket_PositionClosed_event

SSOLOptionMarket_PositionOpened_event

StakingRewards_RewardPaid_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LyraDistributor_Claimed_event

​SBTCLiquidityPool_Deposit_event

​SBTCLiquidityPool_Withdraw_event

​SBTCOptionMarket_ListingAdded_event

​SBTCOptionMarket_PositionClosed_event

​SBTCOptionMarket_PositionOpened_event

​SETHLiquidityPool_Deposit_event

​SETHLiquidityPool_Withdraw_event

​SETHOptionMarket_ListingAdded_event

​SETHOptionMarket_PositionClosed_event

​SETHOptionMarket_PositionOpened_event

​SLINKLiquidityPool_Deposit_event

​SLINKLiquidityPool_Withdraw_event

​SLINKOptionMarket_ListingAdded_event

​SLINKOptionMarket_PositionClosed_event

​SLINKOptionMarket_PositionOpened_event

​SSOLOptionMarket_ListingAdded_event

​SSOLOptionMarket_PositionClosed_event

​SSOLOptionMarket_PositionOpened_event

​StakingRewards_RewardPaid_event

Tables

LyraDistributor_Claimed_event

SBTCLiquidityPool_Deposit_event

SBTCLiquidityPool_Withdraw_event

SBTCOptionMarket_ListingAdded_event

SBTCOptionMarket_PositionClosed_event

SBTCOptionMarket_PositionOpened_event

SETHLiquidityPool_Deposit_event

SETHLiquidityPool_Withdraw_event

SETHOptionMarket_ListingAdded_event

SETHOptionMarket_PositionClosed_event

SETHOptionMarket_PositionOpened_event

SLINKLiquidityPool_Deposit_event

SLINKLiquidityPool_Withdraw_event

SLINKOptionMarket_ListingAdded_event

SLINKOptionMarket_PositionClosed_event

SLINKOptionMarket_PositionOpened_event

SSOLOptionMarket_ListingAdded_event

SSOLOptionMarket_PositionClosed_event

SSOLOptionMarket_PositionOpened_event

StakingRewards_RewardPaid_event