thales_v1_base

Tables

ParlayAMM_ParlayMarketCreated_event

Parlay bet creation events from Thales automated market maker (AMM) on Base, recording multi-leg betting positions with sUSD payment amounts, market quotes, and skew impact factors. Used for analyzing parlay betting behavior and pricing dynamics in the Thales prediction markets 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_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 in sUSD (Synthetix USD stablecoin) the user receives after protocol fees are deducted from the paid amount. Typically represents 95% of in_sUSDPaid, with values denominated in 6-decimal precision (e.g., 4750000 = 4.75 sUSD).
`in_totalQuote`	`STRING`	Combined price quote for the parlay bet as a decimal-scaled integer (18 decimals). Represents the multiplied probability of all individual market positions in the parlay succeeding.
`in_skewImpact`	`STRING`	Market skew impact adjustment applied to the parlay bet price, expressed in basis points (e.g., 100000 = 10% adjustment). Reflects the price modification based on market imbalance at the time of bet placement.
`in_marketQuotes`	`ARRAY<STRING>`	Array of individual odds for each market included in the parlay bet, represented as 18-decimal fixed-point integers where higher values indicate lower probability outcomes. Each element corresponds to one leg of the parlay, with multiple quotes combined to calculate the overall parlay odds.

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
0x5625c3233b52206a5f23c5fc1ce16f6a7e3874dd	false	11909023675381546694	0xf01069c722afb2c8485889d42d3d492344dfe344	38	0x5ecc25d1f658af69d9b59fcaedb2d9ee38254036	5000000	4750155	100000	398857213611830136	2023-10-02T23:34:17.000Z	[“609056116251870227”,“654877609745381761”]	4750000	0x3b651c52d6e57c22d8866631611955534e07d497b2f645db8badda87f4891c2d
0x5625c3233b52206a5f23c5fc1ce16f6a7e3874dd	false	68305162533674732015	0xcbc903b7076f0a95c3a879bc319b21d51996c077	50	0x64436861f8aa5fd6d1064c3670a7a139bbcdae77	7000000	4730880	140000	97357209225898878	2023-10-02T12:51:47.000Z	[“323953656991964643”,“300528199403267516”]	6650000	0x1d5711a61df664b6ea9cec730278eb42fe6aadf3c1eacf433e0d4898765f7e2a
0x5625c3233b52206a5f23c5fc1ce16f6a7e3874dd	false	14650326195056125446	0x4563e4411f5319278ebd5056a2b31745f4b58a05	56	0xdba4a4d79c3be8e27c3e91f530bfef66e50c8230	7000000	4728763	140000	453914807865786488	2023-10-02T11:41:13.000Z	[“658110480451622342”,“689724326460036881”]	6650000	0x12293a45ea39c296ae826c40cf7840439b0f60b7d66bdbe04daed691e8e43131

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xca1ea40d43a73118804ec27dc903069ebdc68ad8	0x191dc09def85abf9ab4f9f76d802708229bb2ccc	5165789078912566400	0x0e8423d9e72883a2091b34f48acb2c8f349e9cdd	49	2505652	4257235	2023-09-21T13:43:37.000Z	0xcf48961d39ceec499c422a2222b67dfc4f7fe8ff245790849e0671c581885a15
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x6c1259edac5bbf174c6569fa719015b90329b4b6	0x191dc09def85abf9ab4f9f76d802708229bb2ccc	8722646552521600000	0x2b5f4006bb4447a9f4807964a9d29b2bac7f2c2d	67	3920031	4253922	2023-09-21T11:53:11.000Z	0x8697d034062c0f62302240c8733d1b465cc1d3f8ed20782f3bc893826ddfd884
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xec814ddbc4bf4cea4118c6f7ec20df357857fca6	0x191dc09def85abf9ab4f9f76d802708229bb2ccc	10019049452560752000	0x2ed920f7444987c6816bf7835a4174a10229de0e	58	5000027	4257097	2023-09-21T13:39:01.000Z	0x2845e881c1035a6e9bd454121e8363a59350205eccd4a48bcbff1f9846ddba43

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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_position	in_sUSDPaid	block_number	block_timestamp	transaction_hash
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xbb23806279a785b8a7bf2bc4b91c7e6842e0ee92	500000000000000000	0xf5afecabcbafce158f3c7a58a926e44a2f5ea4e7	0x9841484a4a6c0b61c4eea71376d76453fd05ec9c	90	1	331761	2706949	2023-08-16T16:27:25.000Z	0x3d277d886427ecbcf949cf2b4997a24751917a46481fcb8f525731e05a50c202
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x993b1f4dd9c00d94234553bfda742eeba6575095	1335546824230504900	0x79b1b7eaf71f3d9e5d78c9208eb33f93fac76f61	0x9841484a4a6c0b61c4eea71376d76453fd05ec9c	42	0	880397	2706960	2023-08-16T16:27:47.000Z	0xbd866a5cb1f9be6676a18333d108cdad34d6fcdb19c947322aea5312954ac609
0xb8109ac56ee572990e6d2c6b4648042bb1c33317	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x6c1259edac5bbf174c6569fa719015b90329b4b6	8722646552521600000	0x2b5f4006bb4447a9f4807964a9d29b2bac7f2c2d	0x191dc09def85abf9ab4f9f76d802708229bb2ccc	65	0	2549920	4257204	2023-09-21T13:42:35.000Z	0x4552ef6ac9c05bd858b1376d723550a8b1c9714b1221a3684d9d08cb2c7c2bfe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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_direction	in_strikeTime	in_buyinAmount	in_strikePrice	block_timestamp	transaction_hash
0x85b827d133fedc36b844b20f4a198da583b25baa	0x5ff0fe2733f85d160be97b0e3e53e6661c2ef06a	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x1ab1ccb0b60d12778e12bc54562570cdfdfe7372	6	7429544	0	1701649335	10000000	4001050488365	2023-12-04T00:07:15.000Z	0xd8ecc46b62fcd9a6e982d46685e8783bd599d4e33e0968d8663759aadff2cecd
0x85b827d133fedc36b844b20f4a198da583b25baa	0x5ff0fe2733f85d160be97b0e3e53e6661c2ef06a	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x450a44237c61fc4f3fc0ac3392101267c02482fe	8	7431797	1	1701656541	20000000	4038101000000	2023-12-04T01:22:21.000Z	0x7df358b701614eba5370c2a60bc6e8cf8f6e7669d85f7b96b1777f921f670a63
0x85b827d133fedc36b844b20f4a198da583b25baa	0x5ff0fe2733f85d160be97b0e3e53e6661c2ef06a	false	0x4254430000000000000000000000000000000000000000000000000000000000	0xbb2cf48d161383326d30cddb352738749a243d5b	6	7429559	1	1701650265	20000000	4002399000000	2023-12-04T00:07:45.000Z	0xf83b3c703d70e6c7dc8613038c2317a14f081d2f08ceb9391759e5712738c523

Example Query

Query with partition filter

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

SportsAMM_BoughtFromAmm_event

Sports betting position purchase events from Thales automated market maker (AMM) on Base. Records buyer addresses, market identifiers, position types (binary outcomes), amounts purchased, and sUSD (Synthetix USD) payment values for analyzing sports betting 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
0xafd339acf24813e8038bfdf19a8d87eb94b4605d	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x6aa0a5f625803187d3e068dabb7f2ab24657ee0c	0x223c381a3aae44f7e073e66a8295dce2955e0098	1852780000000000000000	0x1caac87c9004569ea90179cd6cf5fedabb70b554	28	0	1448008003	7716623	2023-12-10T15:36:33.000Z	0x33ff15b9cc276630aef8211cfdd172e053f03e8a609db41fa406e45438572bab
0xafd339acf24813e8038bfdf19a8d87eb94b4605d	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x755967659e264efc8e7d2527720c3d2081564711	0x8315f67ceaf52d9c4e03971d925af7cff2f5f8e1	9340000000000000000	0x0002b6ff8fcab5576145c472e96d546e1b8c937e	434	0	4696834	7728103	2023-12-10T21:59:13.000Z	0x36bf9016744bda3a83bd4baeebc651cf8808796cddd219e3bee56a124bc5bc71
0xafd339acf24813e8038bfdf19a8d87eb94b4605d	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xbe0e3f3145f8dd2aff9bbbc51ef3049a1feace1a	0x5625c3233b52206a5f23c5fc1ce16f6a7e3874dd	35375323637861541944	0xbe9e1e6207f6366cce5b2f6b749bbe885a6f8213	71	1	21953382	7704642	2023-12-10T08:57:11.000Z	0x57c3a6c7ca023824c41ad8fa0e079cc8d83d5ce8b48ba85e37b07d62b6fb1ea6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xfe65ee8858e873f413a4edbd52b46c270be8b89b	0x81d98c8fda0410ee3e9d7586cb949cd19fa4cf38	26206780544500198000	0x04449a0c6d025e969c6a628834954b8ca745cb23	38	2999858	7272827	2023-11-30T09:03:21.000Z	0x5cfe22d1ef71902bc6270b2a0bb964f791020ceeda684bf119abec142cf47ed9
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x7ca4efdeaf0b9f37b98ca47684343099a562fe15	0x30c2c8f1ded4f17873aa625b21cf1b7f31829cbe	235778112990060630000	0x8736e0bb965710f55c991240732f3144468b3000	41	24490050	6429120	2023-11-10T20:19:47.000Z	0xc5c476ad2a6d8547c0e7604e126308cd08550519be83f2fa47a1e6e71e653ae2
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0xd1cf264e7eeeb96f521dff934250547de63eb6a8	0x30c2c8f1ded4f17873aa625b21cf1b7f31829cbe	405996817367423660000	0x41f78a669c185e9d457e6673f27672ae8e550bdc	19	44213186	6428769	2023-11-10T20:08:05.000Z	0x0f000e4d7171c07bb24077daa526e30b90d8206ce9615ab635b2069f41fa90bb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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_sUSDPaid	block_number	block_timestamp	transaction_hash
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x01018aeabc4ee658626b39d106f93489c0822da5	200293226100000000000	0x418a16519fef0d707fe37219a3f164e6e55e9742	0x09fa38eba245bb68354b8950fa2fe71f02863393	34	146663461	10158330	2024-02-05T04:06:47.000Z	0x4ac1eb49d8e19cda464f8b9b824042a330b01d98bb35efb7a4ea5ec1907ad331
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x01018aeabc4ee658626b39d106f93489c0822da5	100571769120000000000	0x418a16519fef0d707fe37219a3f164e6e55e9742	0x851ef0a28922435675c77d505601e625f65ff088	64	73691281	10162793	2024-02-05T06:35:33.000Z	0xe75dd6c61fd009e98d285de49f5157af90c0b8a51c7f6dd35679837f107ab13c
0xe41cd3a25cbdeda0bc46d48c380393d953bd2034	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	false	0x6c1cfdf23cf79c31417f0563ab70650c67735176	210414121990000000000	0xa1d3a4127bb3db59326e03f44230232923e2bb67	0x851ef0a28922435675c77d505601e625f65ff088	37	192802459	10162823	2024-02-05T06:36:33.000Z	0x7e8565c6bef34f090c953bb16581d7e739e7891b87466bc340dfe4875c203ed3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_base.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