thales_v1_polygon

Tables

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
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x92c5c776b183e9423af1948940e19f08652fd01c	0xe3640eafb3b36761e0cab63a3044a28299493941	34240000000000000000	0xbc28778e8f15c11a755815eb13c375d9a746c692	163	20805737	32563700	2022-09-01T17:04:11.000Z	0xafc892db09bdf69817dc086a41ca3c28dd65243cb771754df567c5eed096939e
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x04966e1cadce53e6d5d863b0a95abbc2bc9c72a3	0x597bea912e8734e17ddc4f43a489a1472d9459cf	22000000000000000000	0x032a094c4d0e6075bd42aa382caa6cddfdbb0f7f	275	12872177	32272619	2022-08-24T15:57:14.000Z	0xb96b5f7b4dcdbdd758572458fe65c0ed3abdbd7f4f863d136a4cd48e0c7089c0
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x85be67da88bfca5391f5527a960d029feeb68c47	0xa02d6c1cb1e7018f9afbfd6a9a8dbfa344fd3732	500000000000000000000	0x89d87a7faf2636fbdde7e8df63536b837c60710f	421	347670876	32268871	2022-08-24T13:27:04.000Z	0x9b910835f78a4cbc2765d1da11b0fb0a8c2a346ef395b78710ecb0887dc624c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_polygon.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
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x2aaf9159f418d23c905db4c96d6dc3ee471f8178	74190000000000000000	0x90ac698012831ff049e0758624614119895ff11d	0x077a304e832f423c3cceb0d489b88e88b2e21fde	187	32553032	37870096	2023-01-09T17:11:33.000Z	0x030a9eaadfea61c10909fb15ab681de7fa5e7e94b42d9106ee6f265aa2ea235c
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x088c3c05cc0bfd17022bc545a49a280d9ded75c3	3000000000000000000	0xc7451b1f028d9f74ada7c7fcd30fa9bbb2bee5cf	0xdcf4fa1b9f8b992c990c11651c06063cbe7395af	199	585636	31690997	2022-08-09T09:45:47.000Z	0xa140bac2e746b012fde695a1c0cd4aac9440d1271a03a5d37bdb49eb8995dc95
0xe8e022405505a9f2b0b7452c844f1e64423849fc	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x1a9d74ec7f74f05c121bdb405fbe33fafa3cc758	5000000000000000000	0x7ef590334c606dc56d1d1a6852ea96f26291453c	0xdcf4fa1b9f8b992c990c11651c06063cbe7395af	223	513729	31698730	2022-08-09T14:52:13.000Z	0xc37178a6fbea124bda65b922854e225bb23b1db9112579245c934e788a800c8d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_polygon.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
0x4b1aed25f1877e1e9fbecbd77eee95bb1679c361	0xab1d48b99c8df04287334fd716d5ce26cba1ddd7	false	0x4254430000000000000000000000000000000000000000000000000000000000	0xc2e73b90f41831e4da1df5092d9997a3994798b7	57	49246808	1698483610	150000000	3405036462674	2023-10-28T08:00:10.000Z	0xe81a9862fa59da410dd8d6a96b127241d90844d6a070a7353bfe98649ef96a72
0x4b1aed25f1877e1e9fbecbd77eee95bb1679c361	0x68abc3e13b8fc66b14bb291d0ae3ef3218104424	false	0x4554480000000000000000000000000000000000000000000000000000000000	0x6449c8afee785a35807e7ca968c81a8b0ab994b4	33	49266824	1698526811	35000000	177716759770	2023-10-28T20:00:11.000Z	0x481cc919d0c74f931ec38a54dc5cdab04023911537c2de1a47e0f9d4edd43e3a
0x4b1aed25f1877e1e9fbecbd77eee95bb1679c361	0x41f0cc6264adedcb76aca10b941942a343be6c95	false	0x4254430000000000000000000000000000000000000000000000000000000000	0x90b82a556928085ef8a3708d6aa8970b7ff9da6e	270	49255240	1698501612	40000000	3401894701577	2023-10-28T13:00:12.000Z	0xdb328ee16b692e6623fb66d0dee1ed4a43ba208ef3a0ba7c4e35a3569cba2576

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_polygon.SpeedMarketsAMM_MarketCreated_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
0x9b6d76b1c6140fbb0abc9c4a348bff4e4e8a1213	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x8f058fd38dbc489f8bb1ee32522f9389b38a0117	0xb77aef4cb034d8ac3dd86f330b19c8c43a83f73a	15000000000000000000	0x4b3002f17a5ce853d21d34b4a4618f80fb6b904b	863	1	9920924	28506881	2022-05-19T11:54:21.000Z	0x39b17e84c166d4953e14095025773034a39e327bb5fa3a034e775781d6232707
0x9b6d76b1c6140fbb0abc9c4a348bff4e4e8a1213	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x7b84ac7aa180b12218dda35fb3d61b657474d44d	0xb77aef4cb034d8ac3dd86f330b19c8c43a83f73a	10000000000000000000	0x4cf962cc5717706910ddac3bc4bbedb71862198e	387	0	5707384	28506959	2022-05-19T11:57:01.000Z	0xd8f79e8039334952cfa72588188767233af5d6a4c85572ae407fcf4d61e5e83d
0x9b6d76b1c6140fbb0abc9c4a348bff4e4e8a1213	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0xe73e22a5e195d13ee9f15d3e2b730582588c78d6	0x865fc5c542280c9dba0d559f67112179e20574d2	150000000000000000000	0x8d1033891336f9eda3f34a4940af3b0941f09137	155	1	125993659	28961736	2022-05-30T18:05:31.000Z	0x63a942644ad3112fb6cac05ec4c89a4dc4255fe7fa33eb1672a5c365c4175c4e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.thales_v1_polygon.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
0xd52b865584c25febfcb676b9a87f32683356a063	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x697e6d2840cc807a962612a3ff33040ce556633b	180000000000000000000	0x8d8a51c34abf3c8f0177c12e0a22ca5b86ee1318	0xdd93091397e8e9ad85c414fc2d24e022bc547671	542	115041338	49070779	2023-10-23T21:33:09.000Z	0xa39a181ea234b9727e284c09b3556b4a2ab726676ac3b4cda38c100b2a4a40b2
0xd52b865584c25febfcb676b9a87f32683356a063	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x1c3dc6424ff387057475d4b8f2a17ef41132c36d	120000000000000000000	0x03b462c0838458455e18e325cdffbffd8564a432	0xdd93091397e8e9ad85c414fc2d24e022bc547671	215	46167033	49052986	2023-10-23T10:29:42.000Z	0xc7eaad5ab35100b8a03a890c327a7b92640899075ffca4bfa449dda3e5a04310
0xd52b865584c25febfcb676b9a87f32683356a063	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	false	0x1c3dc6424ff387057475d4b8f2a17ef41132c36d	145000000000000000000	0x03b462c0838458455e18e325cdffbffd8564a432	0xdd93091397e8e9ad85c414fc2d24e022bc547671	112	55988721	49068982	2023-10-23T20:24:50.000Z	0xca741534886e9f77612ed44ea0da6de6c2691022a65942e3c1b18d26702925bf

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​RangedMarketsAMM_BoughtFromAmm_event

​RangedMarketsAMM_SoldToAMM_event

​SpeedMarketsAMM_MarketCreated_event

​ThalesAMM_BoughtFromAmm_event

​ThalesAMM_SoldToAMM_event

Tables

RangedMarketsAMM_BoughtFromAmm_event

RangedMarketsAMM_SoldToAMM_event

SpeedMarketsAMM_MarketCreated_event

ThalesAMM_BoughtFromAmm_event

ThalesAMM_SoldToAMM_event