thales_v1_optimism

Tables

LPStakingRewards_RewardPaid_event

Reward distribution events from Thales liquidity provider (LP) staking contract on Optimism, capturing token amounts paid to stakers. Used for analyzing staking yield distributions and LP incentive program performance.

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
0x31a20e5b7b1b067705419d57ab4f72e81cc1f6bf	0x2e2ea30ba045df4bc38e80cf11e119e12e06c1c2	false	1704579524779288705	1	107393360	2023-07-26T15:31:37.000Z	0x993c8170fdfa7fb63846762e6373a14cd8540af7633082bb9c7f48a11cc7cf0a
0x31a20e5b7b1b067705419d57ab4f72e81cc1f6bf	0x138a87c80d1659aee5e729221ca4872f51b2937d	false	145151459640343624400	5	107374533	2023-07-26T05:04:03.000Z	0xdddb90bfcc325bee676b416387ee4ec706828375556af20dac127c47c1719e7d
0x31a20e5b7b1b067705419d57ab4f72e81cc1f6bf	0xc50f1e59513c338a4d99e03f8b46e127a20c1110	false	68748974315957348522	8	107394536	2023-07-26T16:10:49.000Z	0xb2ec62b6538c9a2dfacf10f704074cb78cccaaab4e01008c8ed7c0ff05ab016e

Example Query

Query with partition filter

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

ParlayAMM_ParlayMarketCreated_event

Parlay bet creation events from Thales sports betting AMM (Automated Market Maker) on Optimism, tracking multi-leg wagers with sUSD stablecoin payments, individual leg quotes, and skew adjustments. Used for analyzing parlay betting patterns, pricing efficiency, and protocol fee structures.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_account`	`STRING`	Account address involved 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_sUSDAfterFees`	`STRING`	Amount of sUSD (Synthetix USD) remaining after protocol fees are deducted from the total paid amount. Typically represents 94% of in_sUSDPaid based on sample values.
`in_totalQuote`	`STRING`	Combined probability-weighted payout for the parlay bet, denominated in wei (18 decimals). Represents the total quote across all individual markets included in the parlay.
`in_skewImpact`	`STRING`	Skew impact adjustment applied to parlay pricing, representing the multiplier effect from market imbalance. Denominated in wei (18 decimals), consistently 0.15 (15%) across all sample transactions.
`in_marketQuotes`	`ARRAY<STRING>`	Array of individual odds for each market included in the parlay bet, represented as 18-decimal fixed-point values. Each quote corresponds to a single leg of the combined bet, with more legs resulting in longer arrays.

Sample Data

address	removed	in_amount	in_market	log_index	in_account	in_sUSDPaid	block_number	in_skewImpact	in_totalQuote	block_timestamp	in_marketQuotes	in_sUSDAfterFees	transaction_hash
0x82b3634c0518507d5d817be6dab6233ebe4d68d9	false	142424242424242424448	0x13028e910dcfb26520dd5018135b32e14b6aa871	30	0xebacc96ea6449db03732e11f807188e4e57cca97	5000000000000000000	57900725	150000000000000000	33000000000000000	2022-12-30T16:59:32.000Z	[“249069766825668281”,“490679347383969800”,“180650152750777605”]	4700000000000000000	0x10701abada6591caeac10d345242b4785367fc551eb257dbd8a66d5fb8987b16
0x82b3634c0518507d5d817be6dab6233ebe4d68d9	false	49597283674690050196	0xe6240a9dcbd1ee796e0c38d2b7a72b68a631e529	95	0x461783a831e6db52d68ba2f3194f6fd1e0087e04	5000000000000000000	57788890	150000000000000000	94763254190036484	2022-12-30T12:28:14.000Z	[“778278499874456664”,“689621567765579933”,“879748582525491922”,“599987805736771822”,“599556036516482025”,“557908936521045829”]	4700000000000000000	0x00cc297f655355cf6096a51520c67bbc12e900282e7e0683808239d37bf1804c
0x82b3634c0518507d5d817be6dab6233ebe4d68d9	false	27527311645970253214	0xc097cb24566ee4b8b2458b0383c161125549b88c	41	0xf3b4ade14d14504dd2520a0107d04cc3c0b8d4f3	5000000000000000000	57884125	150000000000000000	170739520823786548	2022-12-30T16:04:31.000Z	[“531741717870554224”,“761179861732531548”,“421838325299141452”]	4700000000000000000	0x37ae63239c17bdc1c1b773aed2b7615bd70125a8dd06c6461f3a4bd23750b0c0

Example Query

Query with partition filter

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

RangedMarketsAMM_BoughtFromAmm_event

Purchase events from the Thales Ranged Markets Automated Market Maker (AMM) recording ranged position acquisitions. Contains buyer address, position asset, market identifier, purchase amount, and sUSD stablecoin payment details for tracking ranged options trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_buyer	in_amount	in_market	log_index	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x41f7ec979bb16bc4d6f62c0597ed7d54c9581ebf	0xa4ef44e4c4ee1235484b414832e5bdb3754a87b1	10000000000000000000	0x5249e8d7c6416a6610c2bfb5c54819b272b909b2	28	8494367604199401354	87220333	2023-04-07T08:25:54.000Z	0xd0d3aa9b9d8bbc474aca4e5c9c473e7a51ea3fa4069bac672c98180498ed9b88
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x91aae0c82b063db493851ea7594f5ba4b21a616b	0x19655b64bc180742f8cc62129d2b29a4b76897de	90160000000000000000	0xd653a7bc8623f3e17981a136ec81fe084a5b5af9	28	15044132476509604582	87341462	2023-04-07T16:18:02.000Z	0xb17fcd086cb9033f2c6acf64dd2d6a2de4af3e015d1dc01c172342465049c180
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x1d93e7a5011b4e111374f37aea652eaa0ae573d2	0x12924049e2d21664e35387c69429c98e9891a820	7790000000000000000	0xaf5d5f5625e3d83f64be639db15085e10076611b	28	7377725005702483793	87325411	2023-04-07T14:54:10.000Z	0xdc22fa2fff8b0503104178129b81f73c1dea993446fb071b309c498198f6c706

Example Query

Query with partition filter

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

RangedMarketsAMM_SoldToAMM_event

Position sale events from the Thales Ranged Markets Automated Market Maker (AMM) contract recording sellers liquidating ranged position tokens back to the AMM for sUSD stablecoin payment. Contains seller address, position token details, quantity sold, market identifier, and sUSD proceeds received.

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_amount	in_market	in_seller	log_index	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x5e563ddd44f0fb8f94adbb601dba9b62a3b14cb3	2000000000000000000000	0x122f81323f1ec8d8790b858713a2a50e9745cca1	0xa2b33ce05f8ac6ba011f9e0aeb296be4c1f54bf7	41	1180182053516578482389	106967246	2023-07-16T18:47:49.000Z	0x09f28542062d5e07bd54f7613d89b2705a04fc4a30a753c69e5c66a97fc5a549
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x8ed14341d26a80fea38b9431572af703ada046e5	200000000000000000000	0xf3a5df59084a1e1cb00d6af5003f0d14fd84bea8	0x09fa38eba245bb68354b8950fa2fe71f02863393	27	100878403381825320111	79938755	2023-03-11T00:09:57.000Z	0x3b6192e8839010732d47924527747504a75a677a0d8c71a3caf764e725746b30
0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0xf5891c03d976e3ec8ec6fca3e73ee0ef40a2d823	872474692077669800000	0x4ec6cec40a7a38d838533b4acd097c8f22e9db09	0xe28cf04d1b34c88c2d9950da2357a1625b6c0309	48	159956706815087500972	105837923	2023-06-20T15:23:43.000Z	0x5bf502180b149d46a95db17bfdbc6847bd0759a2ef1ca890b18c8a1cd3105ea1

Example Query

Query with partition filter

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

SpeedMarketsAMM_MarketCreated_event

Speed market creation events emitted when users open directional positions on asset price movements. Records user address, market identifier, buy-in amount, strike price, strike time, and position direction for short-term binary options trading.

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_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_strikeTime`	`STRING`	Unix timestamp when the speed market position was opened. String representation of seconds since epoch.
`in_strikePrice`	`STRING`	Price at which the speed market position was opened. String representation of an integer value.
`in_direction`	`INT64`	Direction indicator for the swap or market position. Integer value where 0 represents one side of the position and 1 represents the opposite side.
`in_buyinAmount`	`STRING`	Amount committed by the user to enter the speed market position. String representation of an integer value.

Sample Data

address	in_user	removed	in_asset	in_market	log_index	block_number	in_strikeTime	in_buyinAmount	in_strikePrice	block_timestamp	transaction_hash
0xe16b8a01490835ec1e76babbb3cadd8921b32001	0x21f6f13f78a18c3b12616e7ebe8b3fdff869b14f	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x6ab214fe69f36853f4d7bce0ee378684eb719ea7	198	116516011	1708631399	66000000000000000000	5151701737648	2024-02-22T19:39:59.000Z	0xc97a4b5a050fcedbceed1ce83b804fb74ef11a55bdacc0e5b729fb99b9751fd8
0xe16b8a01490835ec1e76babbb3cadd8921b32001	0x88ca98958a97a139884d49336fbc8d588fdb5af1	false	0x4254430000000000000000000000000000000000000000000000000000000000	0xbfb4ac1cf7ce3ee2cfee23d71c0d87df707f14d8	59	116518821	1708637379	50000000000000000000	5172347500000	2024-02-22T21:13:39.000Z	0x99457d551d59b146b1e19b2d23a60c32c998c8de5c3f2e93e00e0c9a571c0177
0xe16b8a01490835ec1e76babbb3cadd8921b32001	0x88ca98958a97a139884d49336fbc8d588fdb5af1	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x13a3730b8d9d0ec44510ab634cc5d0e71e417427	175	116519148	1708637973	50000000000000000000	5162413710625	2024-02-22T21:24:33.000Z	0x0ff833360a8c1a2096a0b3dcb9334fcca3147b2f22d053449abd788f9a4bde74

Example Query

Query with partition filter

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

SportsAMM_BoughtFromAmm_event

Sports market position purchases from Thales automated market maker (AMM) on Optimism, paid in sUSD stablecoin. Tracks buyer addresses, market contracts, position types, token amounts, and sUSD prices for analyzing sports betting liquidity and AMM trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_buyer	in_amount	in_market	log_index	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x01722ee355988ee62c540510d00da3846f62acc9	0xa606d5a85a6da3743f5e27ae1844847c39ed1fbd	494210000000000000000	0xb00eb9e4b51387d3b1f950ff8e983bb2a5b64b5f	78	310000156941576305501	115428460	2024-01-28T15:28:17.000Z	0x91748e48b5f324a62d40f607dd3ec570de945f174b95c57cadd0e59e2ac72892
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x03c5c05f90eb2de0d9eb7619430197a91d2648db	0xbf0ae1aae3d3018b3f311620fa512d7498ead8b7	2662440000000000000000	0xc244ad3b16024ec0474a3ec8c53ed051155f5cf4	187	1499996489079410763651	115426764	2024-01-28T14:31:45.000Z	0xad51d83fd74e2b4c4e7d063103a4730b3258a2e1f5e6549a67031ce1fbdc144e
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x03c5c05f90eb2de0d9eb7619430197a91d2648db	0x8cd509e416d0e6f5fde5b22c660746c36a69ace3	3390000000000000000	0xc244ad3b16024ec0474a3ec8c53ed051155f5cf4	167	1999422766593859610	115428283	2024-01-28T15:22:23.000Z	0x54e5c20578efa27950bb6f0a816f9354bd4366d07e4367f5ec5fe202e496a8c5

Example Query

Query with partition filter

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

SportsAMM_SoldToAMM_event

Sell transactions where users sold sports betting positions back to Thales Sports AMM (Automated Market Maker) on Optimism, receiving sUSD stablecoin payment. Used for tracking position exits, liquidity provision analysis, and calculating realized returns on sports betting outcomes.

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_amount	in_market	in_seller	log_index	in_position	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x19515f7c5f5647428fb2d819f0919e6422322786	244000000000000000000	0xa2a697dd3a1fd7d5b79b0f20cdbbefe80c3c76fb	0x7b7d6ca0bf9aeb1744e98701ea777744eae280af	10	0	90556426841243862287	15528764	2022-07-23T19:13:43.000Z	0x9f582f662eb52147d13be9a4d8978e17e36d703d34efe7e6fcb0d74119c2c636
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0xcded214a678c331e8ef1d7ea835ac0e8db92fca3	1000000000000000000	0x660b42f99c54fbed189705540b0d778c979f1180	0xaa32a69dcc7f0fb97312ab9fc3a96326dda124c4	12	0	401200277659515391	15531871	2022-07-23T20:00:54.000Z	0x4d41e425a24281b5d6bfc6fb9153df1a7674a0e5d4226a6b9f623cc4c7df11c1
0x170a5714112daeff20e798b6e92e25b86ea603c1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x8fecb1ebd5d47acb87f04810accf68482bcd7907	1000000000000000000	0x660b42f99c54fbed189705540b0d778c979f1180	0xaa32a69dcc7f0fb97312ab9fc3a96326dda124c4	4	1	299763227878868782	15531831	2022-07-23T19:59:33.000Z	0x9c9a2c4cb373fee1f3dfc4d3635d76985d0a460742006d57136028932c9cc488

Example Query

Query with partition filter

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

StakingThales_RewardsClaimed_event

Staking reward claim events from Thales protocol on Optimism, recording base rewards, SNX (Synthetix) bonuses, and protocol bonuses distributed to stakers. Useful for analyzing reward distribution patterns and staker earning activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_unclaimedReward`	`STRING`	Total rewards claimed by the staker, including base rewards and any bonuses (protocol and SNX). Value is denominated in wei (10^18 smallest units of the reward token).
`in_baseRewards`	`STRING`	Base staking rewards earned by the account during the reward period, denominated in the smallest unit of the reward token (wei). This value excludes any protocol or SNX bonuses that may be included in the total unclaimed reward.
`in_snxBonus`	`STRING`	Additional bonus rewards denominated in SNX (Synthetix Network Token) claimed by the staker. Represented as a wei-denominated integer string, often zero when no SNX bonus is applicable.
`in_protocolBonus`	`STRING`	Bonus rewards earned from protocol participation or activity, denominated in wei (smallest token unit). Frequently zero, with non-zero values indicating additional incentivization beyond base staking rewards.

Sample Data

address	removed	log_index	in_account	block_number	in_baseRewards	block_timestamp	transaction_hash	in_unclaimedReward
0xc392133eea695603b51a5d5de73655d571c2ce51	false	3	0x751cbd4b850d031f4f895278a5ca9f5e56fabb60	14876228	6313816065810492904	2022-07-18T14:05:26.000Z	0xeeb751f7ba6c5afe9106052495fb62133b75b91cfd83dc6908104b341759c757	6313816065810492904
0xc392133eea695603b51a5d5de73655d571c2ce51	false	3	0x6858a4d8d7d0297c138b403b6a34cb3b424b7f4a	14814113	1012038530995076686	2022-07-18T03:59:07.000Z	0x0c82f4373139db3fee54bccdc88071494e03cac20f48e524b61f66020cf571ed	1012038530995076686
0xc392133eea695603b51a5d5de73655d571c2ce51	false	3	0xa02a7a705c8776c58fc8f3f8df5189eaef8f26fd	14845539	8909729653474894493	2022-07-18T08:40:19.000Z	0xc66055964e68415716e8ba8f4e323adaffe7d5d9834847ca175acb76aaadcff1	8909729653474894493

Example Query

Query with partition filter

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

ThalesAMM_BoughtFromAmm_event

Purchase events from the Thales AMM (Automated Market Maker) recording position token acquisitions. Contains buyer address, position details, asset purchased, amount received, and sUSD (Synthetix USD) payment amount for tracking binary options market activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_buyer	in_amount	in_market	log_index	in_position	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x5ae7454827d83526261f3871c1029792644ef1b1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0xec8e0d186e1c981737a7950156d2512846ae6182	0x138a87c80d1659aee5e729221ca4872f51b2937d	40000000000000000000	0x885eda51c26b5829c1572a0c279dd986beaa019e	13	1	35157484144218854740	14558777	2022-07-15T08:52:08.000Z	0xa77901157aa021ea02a23340c4fa8e61a119d1790ce5278780118cb5038f1328
0x5ae7454827d83526261f3871c1029792644ef1b1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x22ad0dc1ea4f231d7ff4190b4db6d9e29f870c64	0x138a87c80d1659aee5e729221ca4872f51b2937d	112000000000000000000	0x44062918a043c7169f6ee63bf36e2cf89168a2d0	13	0	99298822417176364718	14562903	2022-07-15T09:32:53.000Z	0x82857d9bb34534f0417b353e47ed091bf41d5b77138f55ca9f0c117ab07c7674
0x5ae7454827d83526261f3871c1029792644ef1b1	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x5347af4b4829343095a35e83bf3aa9ea6987b33c	0x1930892b509e956150cc10d8325568f7ad305a48	44680000000000000000	0x663289b26d01c8d3516aed1a293e85796313d00a	11	0	9096972543979467193	14531424	2022-07-15T02:37:47.000Z	0xac12f67f78e5cde2951b4879811645e96aaae17b591df04efe7c381eb4d01ff3

Example Query

Query with partition filter

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

ThalesAMM_SoldToAMM_event

Event logs capturing position token sales to the Thales AMM (Automated Market Maker), recording seller addresses, position amounts, market identifiers, and sUSD payment amounts. Used for tracking liquidity provision and pricing data in Thales binary options 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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_market`	`STRING`	Trading pair or market identifier specifying the assets being traded or operated on.
`in_position`	`INT64`	Address of the position or market contract being traded or operated on. 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_sUSDPaid`	`STRING`	Amount paid in sUSD (Synthetix USD) stablecoin for the transaction. Numeric string representation of token quantity in smallest denomination.
`in_susd`	`STRING`	Contract address of the sUSD (Synthetix USD) stablecoin used in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_susd	removed	in_asset	in_amount	in_market	in_seller	log_index	in_position	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0x278b5a44397c9d8e52743fedec263c4760dc1a1a	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0xee1d284e588520c4bf6f9aed8dce53d951da9ba3	3172450765000000000	0x7608ae13cbec053d7e5214d461b2eea8e9946848	0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	71	1	1422639993660847770	113299759	2023-12-10T08:51:35.000Z	0x3733e224726a8ad3b029eacf905bc3d0e3cd58d33849f2bdc5086bd07a2d4a79
0x278b5a44397c9d8e52743fedec263c4760dc1a1a	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0x7abc10bb0115944c8725ba97d3c3d35c847f4061	3172450765000000000	0xf2a10a186d99d16fb73819485611a7898217b76b	0x2d356b114cbca8deff2d8783eac2a5a5324fe1df	62	0	2906916635969500000	113299759	2023-12-10T08:51:35.000Z	0x3733e224726a8ad3b029eacf905bc3d0e3cd58d33849f2bdc5086bd07a2d4a79
0x278b5a44397c9d8e52743fedec263c4760dc1a1a	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	false	0xe1342f5c3b8bb9596c664f1f830e4357105df037	375500045475422670000	0xa4b8883c9e7f12f6f5a8a30dcdd8351e04ac6ce2	0xd42d654d065ff9560c823f2d71411535d5e81132	39	1	216356995546102167167	113304142	2023-12-10T11:17:41.000Z	0xd5e727debd67f55a6c3c407cf4812bd35b8cafd05885319599047eb6655c9324

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LPStakingRewards_RewardPaid_event

ParlayAMM_ParlayMarketCreated_event

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

SportsAMM_BoughtFromAmm_event

SportsAMM_SoldToAMM_event

StakingThales_RewardsClaimed_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LPStakingRewards_RewardPaid_event

​ParlayAMM_ParlayMarketCreated_event

​RangedMarketsAMM_BoughtFromAmm_event

​RangedMarketsAMM_SoldToAMM_event

​SpeedMarketsAMM_MarketCreated_event

​SportsAMM_BoughtFromAmm_event

​SportsAMM_SoldToAMM_event

​StakingThales_RewardsClaimed_event

​ThalesAMM_BoughtFromAmm_event

​ThalesAMM_SoldToAMM_event

Tables

LPStakingRewards_RewardPaid_event

ParlayAMM_ParlayMarketCreated_event

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

SportsAMM_BoughtFromAmm_event

SportsAMM_SoldToAMM_event

StakingThales_RewardsClaimed_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event