thales_v1_arbitrum

Tables

ParlayAMM_ParlayMarketCreated_event

Parlay bet creation events from Thales automated market maker (AMM) on Arbitrum, containing multi-leg bet combinations with individual market quotes, total odds, and sUSD (synthetic USD) amounts paid. Used for analyzing parlay betting patterns, fee structures, and combined odds calculations across sports 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_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`	Gross payment amount in sUSD after platform fees have been deducted. Typically represents 95% of the initial sUSD payment, with values like 4750000 corresponding to a 5000000 initial payment.
`in_totalQuote`	`STRING`	Combined odds multiplier for all markets in the parlay, represented as a decimal scaled by 1e18. Determines the total payout potential before fees and skew adjustments are applied.
`in_skewImpact`	`STRING`	Percentage impact applied to the parlay bet quote due to market skew conditions, expressed as a decimal multiplier (e.g., 100000 = 1.0x or no impact). Typically equals 100000 in the sample data, indicating neutral skew adjustment.
`in_marketQuotes`	`ARRAY<STRING>`	Array of individual quote values for each market included in the parlay bet, represented as 18-decimal fixed-point integers. Each quote indicates the odds or pricing for a single market leg within the combined parlay wager.

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
0x2bb7d689780e7a34dd365359bd7333ab24903268	false	137079319649647503163	0x7866f45c0c7359b2b652b0994c304d73be0577b4	110	0xfb85c9b9314c45661e0d553e271efefac154c839	5000000	99418945	100000	34651470492706188	2023-06-09T15:10:06.000Z	[“598438946312216959”,“513125577973213457”,“474266766753876650”,“596942766229957749”,“659747204780220292”,“604150598449563711”]	4750000	0x4c18a40aa8a3a355233816d3001dfec959023f7fd3813e5e353af1ea1be05b57
0x2bb7d689780e7a34dd365359bd7333ab24903268	false	94440158778231961761	0x298b040eceb4e51922436753b9688f8b6cc059b0	96	0xbfcc31100c6c35d44ec2aff4325958feefccb5f0	5000000	99271205	100000	50296399979103529	2023-06-09T04:52:10.000Z	[“674870376250568825”,“411356170228476735”,“604139883434918253”,“652236122006511105”,“459786446932702958”]	4750000	0xf1c37a94035aa0c139208ae1a0b0f4fa983b5997f0a570d70fb993c1764d307b
0x2bb7d689780e7a34dd365359bd7333ab24903268	false	181936272646236719319	0x6667efb01ac8f29c5b0a0a348f15fdac281d88d8	191	0x786f5f93db421a49d6906dd3f174d0778df758aa	5000000	99530024	100000	26108042837813144	2023-06-09T23:04:01.000Z	[“785538242157488085”,“688725567654917001”,“738595968393637243”,“696483270036811811”,“826421141464699811”,“609617530067274046”,“669066294893056143”,“662686705358349757”,“648042427843578899”,“648042427843578899”]	4750000	0x4b42dec3ee514bec85f12ef2a810c9ef6bec34487c1ad9cd3fb2fffbf33156e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_arbitrum.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
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xabbe054fbcf5b2ff26782b7e5fdee7123f6518eb	0x8aa077f5998d234ac8641d73d6bc4976e2a210fc	629067585295899600000	0xc74bbae3886c4471691a13b45931635f26db8e05	48	483123018	165030215	2023-12-29T18:16:49.000Z	0x1d490f23ec0d133a7abc9922c1335fab4c289ddeb3af2afb70e5fdc1c5a7dfb5
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xabbe054fbcf5b2ff26782b7e5fdee7123f6518eb	0xfc93c3010ea5668c1b6900a9fe87168b63dec145	692457161981362800000	0xc74bbae3886c4471691a13b45931635f26db8e05	49	531430232	165029107	2023-12-29T18:12:09.000Z	0xbb4fdd24b46b7f4e8cf37b79226cc99659a3aefbab0d048a7521ec55be376c01
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xf9470f4793ecd2cfff1f3ef29f0b48dde2df3e67	0x0ba43bae4613e03492e4c17af3b014b6c3202b9d	78511094521025830000	0xe2ff9f6a9906fa614a93881bea49f07b155acdeb	47	48076119	164884501	2023-12-29T08:06:04.000Z	0xee18c8fc56c7c922e685d4ee9de2ef4de7bfbc5ec574096f720f3515d0543dbb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_arbitrum.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
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xd76caab6fa307f3f8d03fe3595880eb12b13f971	84807793330152820000	0x30244f7310fc6b3d01b8c3bb3892b7783acd15f6	0xdfa3f3ad925e01672016b7fe08bd8804d551cc1f	48	21510787	107737491	2023-07-04T08:47:08.000Z	0xd90666913099277ea0e1570d38adef8cd4269284ea75841d1313a8b7a4b4628a
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x876f8c650a1e4738704f10b36f1094c943269c4a	3668189033354720000000	0x2d05ff6c3a31f4f3fedfe6d2ff6e5ad8b8a20366	0x4026b3da349c2952255ca9db4f055ea57f4e037c	47	1811714728	124657053	2023-08-25T00:30:05.000Z	0x761268e7680c6e58d60cc59a159eba68be8cc8f01fa592db277065b4c05848a6
0x5cf3b1882357bb66cf3cd2c85b81abbc85553962	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x2e6085af29ad4e18b24f2d110f136704018673fd	21238197433762250000	0xa8b478416c40edc0fa179b66f89139a168712744	0x060d2ed5c447e194e7a107d2009847e1e475da06	44	13165419	118414086	2023-08-05T13:29:58.000Z	0x0eebbf230ce00c43d09fe7d76d13860e8589de391b5113ef3efcd443b6db7560

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_arbitrum.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
0x02d0123a89ae6ef27419d5ebb158d1ed4cf24fa3	0x0c6a8ac4cbea16a47bde05f372987acae54b3601	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x8c259f89580b4fc4d536de6be6424f613a3e0441	24	264209412	1729033033	4385176	6677892915962	2024-10-15T22:27:13.000Z	0x198199f82050573db0081064f382b371cf0fe278dc24118819cb3d29048000e0
0x02d0123a89ae6ef27419d5ebb158d1ed4cf24fa3	0x4c2dcd269f68b404fdae6307d1c36e5fdfb6244c	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x0a087139cb640554df22be92cf83a719e17eed31	9	264063911	1729016203	7743362	6556044143313	2024-10-15T12:16:43.000Z	0x405993d3c418260dd6df64b5f31f6e64895778a02ac84fe08cc01bd2e15f97a4
0x02d0123a89ae6ef27419d5ebb158d1ed4cf24fa3	0x4c2dcd269f68b404fdae6307d1c36e5fdfb6244c	false	0x4254430000000000000000000000000000000000000000000000000000000000	0xd4928ebc7d9d88995360f8781bc3749b1c31cb11	14	263971127	1728985683	7079646	6532001315038	2024-10-15T05:48:03.000Z	0x6e8e38a2a57344be25b7ec04233505946f7de523497e4832fa89f646b7dca9c8

Example Query

Query with partition filter

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

SportsAMM_BoughtFromAmm_event

Sports betting position purchases from Thales AMM (Automated Market Maker) on Arbitrum, recording buyer addresses, position outcomes, bet amounts in sUSD stablecoin, and position tokens received for analyzing betting activity and AMM pricing dynamics.

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
0xae56177e405929c95e5d4b04c0c87e428cb6432b	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x9146fe6097df7c5cbb296203d9ebcab82affbf6c	0x02f11fe7a88805f3afbe76f28d0ee7b090d4e99b	224120000000000000000	0x5bc0fd68c0230e16ede18033dfab847294b9b498	18	1	124003946	149198015	2023-11-11T01:04:48.000Z	0x8eda0e21f2e2b6f4a11edb2435a518d437193c102a24a6099eedc312c78671e9
0xae56177e405929c95e5d4b04c0c87e428cb6432b	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x26ec7fb5f7756c34483e02346ccda74109759989	0x02f11fe7a88805f3afbe76f28d0ee7b090d4e99b	337440000000000000000	0x3788f00ca666c6a50f20c31a7c0830bce0b8a857	18	0	187002517	149197695	2023-11-11T01:03:20.000Z	0xf0279c4ecea3042d175225be7601a9b3766d7b1a26d7fc98ae128c3d1e335640
0xae56177e405929c95e5d4b04c0c87e428cb6432b	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xa8d5fb59ff4d7955db35024a48d3bb35e986792f	0x02f11fe7a88805f3afbe76f28d0ee7b090d4e99b	415470000000000000000	0xeb6ef90b8d5420bc90ae43400e692423ca9d3276	21	1	215002858	149194075	2023-11-11T00:46:50.000Z	0x97b8b9f0c24cff7b7b7ff7503bcc65191d0c720e23f24d9d7ed459cbdc40b57f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_arbitrum.SportsAMM_BoughtFromAmm_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_sUSDPaid	block_number	block_timestamp	transaction_hash
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x065f58d6b3e863017eea961c1ec9a866fac77324	0x024f2369e6c544e767ae33f72814167c7f535b17	20004573878031273000	0xa1655fa03880daffd867ffac48fb0ee84a390fc3	22	5003993	186272263	2024-03-02T07:15:35.000Z	0xb00876fa897468c80ca8738b3379f3236199e9610ae487c0b09ebc1f19068172
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x06ae12be00f2d0edc2b0acef8abcb713fbf52261	0xef7da3140a5f415a9fcad38feec00785c1f9500d	11573985526347537000	0xe186bf9c0adfbb0288ef71339a671551380bed16	16	3167894	186294686	2024-03-02T08:50:58.000Z	0x83ee18678940f53fa86f683212e37cb3d9e74f9108ac1a29dac92b5a8fa8df7f
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x0f41459b56827284c7591469ae91ca09896d6f51	0xc05b8bb9471d025a8c7312dc1272cbe0493f7236	3133678226096337000000	0xfed69f1f70ed89be71570a76c9928e87f95cd511	28	1000007051	186377030	2024-03-02T14:42:02.000Z	0xe88192d2b840b2349624649e53a2752aae72e65628fb24c017304b0dfbf05219

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_arbitrum.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
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0xe40e2d045504be28b5590a3f858be45663a35d85	1208985193372931700000	0xdc23fc9756f9dd45b07b7e8b3efab39150ef2735	0x4026b3da349c2952255ca9db4f055ea57f4e037c	16	1	253999606	128776008	2023-09-07T05:06:29.000Z	0x49598f6a4a85f5f95ac5b4cc438a73bfc1611521822ff2d341a8700084e9de4d
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x321eda0bef45369234505dd47639f2ae96e874da	15518022985411152000	0x036d45c14d1c4ff2cb0095315bf90886645ca22e	0xefad3bc5839d1b0d257b6b8786efe9b27d511417	11	1	9012045	224813390	2024-06-23T08:12:03.000Z	0x97e76e85771aa41b42e82351b9ce65c8532d38f1a36913426eca16b6a9ad2d0b
0x2b89275efb9509c33d9ad92a4586bdf8c4d21505	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	false	0x76522bf5b88578c35db84d5136bd35cc61787489	2491500045037401000	0x420ffd7200d4e7e8294fef55b163e3e6bc6af89f	0x2ee428af51b8ca8d0b4cd95ce2f7db1436f42719	17	0	1579330	207139580	2024-05-02T18:08:11.000Z	0x39fe0aace6b3da149010fc2563eb9c3a4761b9ad6eed4b1ec3a63a3c5c145343

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ParlayAMM_ParlayMarketCreated_event

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

SportsAMM_BoughtFromAmm_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ParlayAMM_ParlayMarketCreated_event

​RangedMarketsAMM_BoughtFromAmm_event

​RangedMarketsAMM_SoldToAMM_event

​SpeedMarketsAMM_MarketCreated_event

​SportsAMM_BoughtFromAmm_event

​ThalesAMM_BoughtFromAmm_event

​ThalesAMM_SoldToAMM_event

Tables

ParlayAMM_ParlayMarketCreated_event

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

SportsAMM_BoughtFromAmm_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event