polymarket_v1_polygon

Tables

CTFExchange_FeeCharged_event

Fee collection events from Polymarket’s CTF (Conditional Token Framework) Exchange on Polygon. Records trading fees charged per outcome token with amounts, token IDs, and fee receiver addresses for analyzing platform revenue and market maker costs.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_tokenId	in_receiver	block_number	block_timestamp	transaction_hash
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	1320000	353	57068498856794602558575008534670270025475324489647007815016958633007405843713	0x56c79347e95530c01a2fc76e732f9566da16e113	47762442	2023-09-20T07:59:51.000Z	0xab0da3e45b02fb4bdeb4a7d368ef44852575327e281f98a637636e8a5f89672b
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	5000000	194	57068498856794602558575008534670270025475324489647007815016958633007405843713	0x56c79347e95530c01a2fc76e732f9566da16e113	47762426	2023-09-20T07:59:17.000Z	0xf9d45bf0cef793f2eee9bbac3323cc9bee2b3d1319d353caca3aed90eeed35e6
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	600000	169	57068498856794602558575008534670270025475324489647007815016958633007405843713	0x56c79347e95530c01a2fc76e732f9566da16e113	47762446	2023-09-20T07:59:59.000Z	0x18593308575d17dee5fdf66d889749a6f5a028dde8221c21f3bd452f16cb1402

Example Query

Query with partition filter

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

CTFExchange_NewAdmin_event

Administrative role change events from Polymarket’s CTF (Conditional Token Framework) Exchange contract on Polygon. Records transitions of admin addresses for tracking platform governance and access control modifications.

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_newAdminAddress`	`STRING`	Polygon address of the newly assigned administrator for the Polymarket CTF Exchange contract. Hex-encoded, 0x-prefixed 40-character string representing the address that will receive admin privileges.
`in_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	transaction_hash	in_newAdminAddress
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x665057d2bdc8f83722435712a98747ee4a7b8aeb	56	35938611	2022-11-22T20:04:43.000Z	0xdc8938e54a953ccc9f5c5704e2bb8f0401ad3c8ddd27d3a093aca972b1ea48cc	0x3dce0a29139a851da1dfca56af8e8a6440b4d952
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x665057d2bdc8f83722435712a98747ee4a7b8aeb	23	35893284	2022-11-21T17:44:45.000Z	0xbd648f493e68eb33aae776e0ae7a2ac0be30e3b10ef67a159933db6b35443144	0xe378ba2dc3f7a55b92d330696dfd92583616a688
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25	2	33605403	2022-09-26T21:38:59.000Z	0x8dedda12c2ee8a8893c436e726bb0112d542455e3db12bddb9a5cd097d8a6d16	0x665057d2bdc8f83722435712a98747ee4a7b8aeb

Example Query

Query with partition filter

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

CTFExchange_NewOperator_event

Operator authorization events from Polymarket’s Conditional Token Framework (CTF) exchange contract on Polygon, recording when admins grant or revoke operator privileges. Used for tracking exchange permission changes and governance 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_newOperatorAddress`	`STRING`	Address of the newly authorized operator being granted permissions by the admin. Hex-encoded, 0x-prefixed 40-character string representing the Polygon address receiving operator rights.
`in_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	transaction_hash	in_newOperatorAddress
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x665057d2bdc8f83722435712a98747ee4a7b8aeb	4	42303731	2023-05-04T17:27:30.000Z	0x6a7ee8aae55623b315769afd4c7da5ca7bb3f21d88b6c582a385d8a6b4fa1c12	0x56c79347e95530c01a2fc76e732f9566da16e113
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25	4	33605403	2022-09-26T21:38:59.000Z	0x2f62b1db98a1173317d27d8ea06fc8c657b456b4c7c16b0c4955a06d70d9ee3a	0x665057d2bdc8f83722435712a98747ee4a7b8aeb
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x665057d2bdc8f83722435712a98747ee4a7b8aeb	8	33605689	2022-09-26T21:48:47.000Z	0x54870e226c5909c5af6cd557927efd5871a5498b3f911af381a7d2f11d1263b9	0x38e0e0f3187f0bb8188fa83d90a234f68e1c275e

Example Query

Query with partition filter

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

CTFExchange_OrderFilled_event

Order fill events from Polymarket’s Conditional Token Framework (CTF) exchange on Polygon. Records completed trades between makers and takers with outcome token IDs, filled amounts, and fees for analyzing prediction market liquidity and trading patterns.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_maker	in_taker	log_index	block_number	in_orderHash	block_timestamp	in_makerAssetId	transaction_hash	in_makerAmountFilled	in_takerAmountFilled
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x6916cc00aa1c3e75ecf4081df7cae7d2f3592fd4	0x19db7258c8d0cd79f34ed7df506947ad5057dc1e	1268	76619650	0x1f676f9234f15fdaf6836769e67f65d0ba32e1db26916d00729e7414d36752c6	2025-09-19T00:00:08.000Z	81425397446351426621727450375895254607015946433493851514616485979278175609514	0x3f3bf3b8c0e9dbcd4bfee04d5a172f16b3dcb313595353dc080cf0167e72a19f	36186045	15559999
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0xb0f943f18acd480b30c08f78e876e46911420468	0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	767	76619652	0xe653f94251489fe452ac626cea44eedc364bd3474939ea728ea7993a5b560766	2025-09-19T00:00:12.000Z	25535985536287968013265295429181911285049157796068849182472599988330182691515	0x0f8cb3d6c871377ae84f73899be8892b90de95f2a83abcbc46f3b1cdf8d976f7	4160000	4118400
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x51373c6b56e4a38bf97c301efbff840fc8451556	0xc1b8c09f482f16c6bfc70a599158b1bc5d9c8be5	664	76619656	0xc9fdc43e6ef32639136f9e2e90a9dc05975db534f55e3a5f037cc7866b59c72a	2025-09-19T00:00:20.000Z	48836596349328094130820633373325351228861666348510467589562015606023847420265	0x7886357527bf7d0117638c835f157e049c3517d651e1e28c37866e8c29f219ea	10204080	4999999

Example Query

Query with partition filter

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

CTFExchange_OrdersMatched_event

Order matching events from Polymarket’s Conditional Token Framework (CTF) exchange on Polygon, recording maker and taker fills with asset IDs, amounts, and participant addresses for analyzing prediction market 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_takerOrderHash`	`STRING`	Order hash identifier for the taker’s side of the matched trade on Polymarket’s Conditional Token Framework exchange. Hex-encoded, 0x-prefixed 64-character string uniquely identifying the taker order.
`in_takerOrderMaker`	`STRING`	Address of the user who created the taker order in this matched trade on Polymarket’s CTF Exchange. Hex-encoded, 0x-prefixed 40-character Polygon address representing the order originator.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_makerAssetId	transaction_hash	in_takerOrderHash	in_takerOrderMaker	in_makerAmountFilled	in_takerAmountFilled
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	456	39403735	2023-02-17T18:25:05.000Z	80085489243215790077454313513728486445319747473476157602131800551595373270758	0xe79413bf1e35bc6ba24af6f8029a7909b0c36f29493e931476a36863de682bdf	0x9393c9b800d65b78da374b4791f7e2b0df5c69c401c8343d984ff2a7ab542d78	0x11fae40c66a22907a51c9b248e3dadd57e161f58	2000000	1300000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	143	39403575	2023-02-17T18:18:53.000Z	7499310772839000939827460818108209122328490677343888452292252718053799772723	0xf596d66fd56da51d951cae1bcc0071c4d2fc329f25598ccd1ed0f875a2006a91	0x4e1270dfc6bbd48cf7410e507806cda2e4e5de321f8a36151466bd0ca719fb60	0x11fae40c66a22907a51c9b248e3dadd57e161f58	15000000	7650000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	332	39403173	2023-02-17T18:03:28.000Z	7499310772839000939827460818108209122328490677343888452292252718053799772723	0x6e98ebee50e8d9e4ff0888067044d6719ff48a9c2551238f4340568904894644	0x5cccf1ec70fab3916eb82f46c77c2d6866cb3213d5fdea4d4527b713b7c21bbd	0x11fae40c66a22907a51c9b248e3dadd57e161f58	1000000	510000

Example Query

Query with partition filter

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

CTFExchange_RemovedAdmin_event

Administrative role removal events from Polymarket’s CTF (Conditional Token Framework) Exchange contract on Polygon. Tracks when admin addresses are added or removed from the exchange’s access control system.

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_removedAdmin`	`STRING`	Administrator address that was removed from the CTFExchange contract’s admin privileges. Hex-encoded, 0x-prefixed 40-character Polygon address.
`in_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	in_removedAdmin	transaction_hash
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25	6	33605403	2022-09-26T21:38:59.000Z	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25	0xde6e10751f2a3679109c25a571f210858da0812d6635e2702f61da15d5c5a71a

Example Query

Query with partition filter

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

CTFExchange_RemovedOperator_event

Operator removal events from Polymarket’s CTF (Conditional Token Framework) Exchange contract on Polygon, tracking when addresses lose operator permissions. Used for monitoring access control changes and protocol governance activities.

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_removedOperator`	`STRING`	Address of the operator being removed from or added to the admin’s authorized operator list in the CTF Exchange contract. Hex-encoded, 0x-prefixed 40-character string representing the Polygon address.
`in_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	transaction_hash	in_removedOperator
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25	0	33605404	2022-09-26T21:39:01.000Z	0x0e0391adbe52ad44a30ee682c4cf270896190b02931b5c421ddc0aafbec0590a	0x81fd0e5e7372ed171f421a7c33a4b263ea9dcc25

Example Query

Query with partition filter

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

CTFExchange_TokenRegistered_event

Conditional Token Framework (CTF) outcome token registration events from Polymarket’s exchange contract on Polygon. Each event records a binary outcome pair (token0/token1) for a prediction market condition, enabling analysis of new market creation and token listings.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.

Sample Data

address	removed	in_token0	in_token1	log_index	block_number	in_conditionId	block_timestamp	transaction_hash
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	62846114245563585461323854598700429186365839157231291108764959029391972480482	24077728556963012596914570504170595915437960667470047334073788429173017855599	10	45756711	0x1c316a815e2d0db790d90914e3b2aa86925998e3d12ac9fcbd6c63d02c68485e	2023-07-31T22:33:28.000Z	0x25d9397c3494deb36d3c13dfc39795d0c812ddd0ecc0757ea1ec23b421d3cb84
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	24077728556963012596914570504170595915437960667470047334073788429173017855599	62846114245563585461323854598700429186365839157231291108764959029391972480482	9	45756711	0x1c316a815e2d0db790d90914e3b2aa86925998e3d12ac9fcbd6c63d02c68485e	2023-07-31T22:33:28.000Z	0x25d9397c3494deb36d3c13dfc39795d0c812ddd0ecc0757ea1ec23b421d3cb84
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	40168037609668277939913775193329824657749932283208836752961671173155958317278	96668916275525489892882974831486009509037675286488614310725254930675093677599	13	45751627	0xa562efa95c1cf455d95daa0d9d553ca829558234120a1e77802a13b1b6267d24	2023-07-31T19:31:00.000Z	0x884acaa6ae468b974e7e890dac232238a52c7dcd56aa3f587f87ece6d1807f34

Example Query

Query with partition filter

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

Exchange_FeeCharged_event

Fee collection events from Polymarket’s Exchange contract on Polygon, recording trading fees charged on outcome token positions with fee amounts, token IDs, and recipient addresses. Used to analyze fee revenue distribution and trading volume economics across prediction 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	180000	157	0x56c79347e95530c01a2fc76e732f9566da16e113	42526361	2023-05-10T08:09:18.000Z	0xe462ce7c6f2701669fe092a9d4b91d819ce91a1a8659c70617de1c8e0b58963c
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	174921	302	0x56c79347e95530c01a2fc76e732f9566da16e113	42541201	2023-05-10T16:56:04.000Z	0xdceba2cf4d29708043d431906145017dedec2716d99c02e86d21afcc0f42e145
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	2903054	175	0x56c79347e95530c01a2fc76e732f9566da16e113	42526368	2023-05-10T08:09:34.000Z	0x2bc2bb7e631d6ffb09c9611a458799d19fba818d63fec99dd63323e0d736347b

Example Query

Query with partition filter

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

Exchange_OrderFilled_event

Order fill events from Polymarket’s Exchange contract on Polygon, recording completed trades between maker and taker addresses with outcome token identifiers and filled amounts. Used for tracking prediction market order execution and calculating trading volumes across binary outcome 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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_maker	in_taker	log_index	block_number	in_orderHash	block_timestamp	in_makerAssetId	transaction_hash	in_makerAmountFilled	in_takerAmountFilled
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0x7789806c754eb0af4c3abeb026c218b4ba78f823	0xc95cd16e8c0edcc9090b13030d3e492163db5e0b	137	44579376	0x9938af7f30194f356bc233358379dd23c298d60a28577793c53c4c9865e7106a	2023-07-02T03:29:47.000Z	1012943598023907390061808293289962870407753378304137167939555862347202534788	0x3c366d1775f1f1daf2be1e238b93863357068f01aedddc9a692dc011ab716fce	10000000	9890000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0xd6dfa912abf436c9b27f241da817adad37b61c32	0xb46ef1a548751c6b7398af601f5a555505668a4e	137	44580790	0x8eefecc197fb01c5794ccda535a3a2fce38cc446a1f9771e7041e784bdd50eba	2023-07-02T04:24:02.000Z	98589481106407518874018810303523461691501148872757303818890245008954329330186	0xc3b9e7a4222b6de3523a7c1471277c265be8d615fe6151118533a378294655a7	40000000	39840000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	0xd6a2e4cdc407c88f30a66e71ce95edba8763d272	0x073a1caba3c22e9e361ceae83aaa5405706f91e7	262	44581651	0x3f899365e11bc2dd79200d2e8b3065a5487d402b58f26cba81d8904ea74c9266	2023-07-02T04:56:03.000Z	77601808658570957917576211407244993250655406832281378731794620643549911430356	0xd407b9e2792fc1821c9e2c75bb6bfa772b379494e9ca1e8a8de544c32b446174	499990000	7999840

Example Query

Query with partition filter

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

Exchange_OrdersMatched_event

Order matching events from Polymarket’s Exchange contract on Polygon, recording maker-taker trades with filled amounts and Conditional Token (CTF) asset identifiers. Used for analyzing trade execution, liquidity provision, and outcome token price discovery in prediction 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_takerOrderHash`	`STRING`	Unique hash identifier for the taker’s order in the matched trade event. Hex-encoded, 0x-prefixed 64-character string used to reference the specific taker order being filled.
`in_takerOrderMaker`	`STRING`	Polygon address of the user who created the taker order being filled in this Polymarket exchange match. Hex-encoded, 0x-prefixed 40-character string representing the taker’s wallet.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_makerAssetId	transaction_hash	in_takerOrderHash	in_takerOrderMaker	in_makerAmountFilled	in_takerAmountFilled
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	218	45346282	2023-07-21T14:16:40.000Z	65444925001030765301716235225831870004029416420473938286937266311683806999986	0x1277a65160d80efe5457b471b8ba26d68328d421ced385506a5fc24e447d908a	0x631492712f35931d3fce5696561c7d4b252fcaba8dee65799281f05ca03295bf	0xfa1296c90a0b164c6b1370fe9e614b627d94c537	25000000	12500000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	263	45354439	2023-07-21T19:18:01.000Z	73354703085144715093690968399259467382467176193572082428159307302041403232590	0x53972762b3c56b604af4b0c8939845081acae568a411c41fbbd57a62aa13360f	0x0f633450f81a0d03a6fdeb85bed66744d496f437c6ac56c59c573707924814d7	0x8642a5a9feff1359d253152a76a183b4fec54f1d	198800000	81508000
0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e	false	723	45322907	2023-07-21T00:14:47.000Z	73354703085144715093690968399259467382467176193572082428159307302041403232590	0xe5b5aaab42c86ab9b96acf54deb5c1aa9637a980336fb8b661f791df5899e8cb	0xc5b950b8a795b8eb125a89d9eb97cf40be0ab43223dadc357f7e82e7c8baa722	0x44f686f5ab392d5183a61beabb89ccc0b66b4803	339795882	173295900

Example Query

Query with partition filter

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

FixedProductMarketMaker_FPMMBuy_event

Buy transaction events from Polymarket’s Fixed Product Market Maker (FPMM) contracts on Polygon. Records outcome token purchases with investment amounts, fees, and tokens received for analyzing prediction market trading activity and liquidity.

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_investmentAmount`	`STRING`	Total collateral amount invested in the buy transaction, denominated in the market’s base token. Stored as string-encoded wei/smallest unit (e.g., 1000000 = 1 USDC with 6 decimals).
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_outcomeIndex`	`STRING`	Index identifying which outcome in a binary or multi-outcome Polymarket prediction market the buyer is purchasing. Stored as a string representation of an integer, typically ‘0’ or ‘1’ for binary markets.
`in_outcomeTokensBought`	`STRING`	Quantity of outcome tokens purchased in this Fixed Product Market Maker (FPMM) buy transaction on Polymarket. Stored as a string-encoded integer representing the raw token amount before decimal adjustment.

Sample Data

address	removed	in_buyer	log_index	block_number	in_feeAmount	block_timestamp	transaction_hash	in_investmentAmount	in_outcomeTokensBought
0x7dc0c791ebe0ac2bf951782ceb46effbcebeed22	false	0x616ae7188096d775c9982c875d81e6db09c9fdef	16	9589864	20000	2021-01-14T19:04:21.000Z	0x8c105f6e7718ea75c44df6083bb0a878d0aef97c3a13ca1ae6e0d1c7886ff6ee	1000000	1635556
0xd2d782b095467a48e60a4eb858233db98b6c1dc8	false	0xc97314b910f6829b194d26c96e967696625d00a0	9	9585490	20000	2021-01-14T16:34:01.000Z	0x0ff6caebb4c876f66f36abad4a6482e6d5d08c88740f20508f7ff5439cdd41ba	1000000	1068754
0xe5e75925a57c3d121561f7471c46f9cd8257f090	false	0x404472145fef687e106982497d7f9b6a4634f94c	9	9588362	20000	2021-01-14T18:12:45.000Z	0x72e679291c5f487ed502be8899c8cc6b9c9e8347a27087ad285dbf43fc52b9b7	1000000	6749101

Example Query

Query with partition filter

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

FixedProductMarketMaker_FPMMSell_event

Sell transaction events from Polymarket’s Fixed Product Market Maker (FPMM) smart contracts on Polygon, recording outcome token sales with prices, fees, and user addresses. Used for analyzing trading volume, price discovery, and market participant behavior on prediction 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_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_outcomeIndex`	`STRING`	Index identifying which outcome token was sold in the prediction market (e.g., 0 for “Yes”, 1 for “No”). This determines which side of the binary market position the seller is exiting.
`in_outcomeTokensSold`	`STRING`	Number of outcome tokens sold by the user in this transaction, denominated in the token’s smallest unit (wei-equivalent). Values typically range from tens of millions to hundreds of millions based on sample data.

Sample Data

address	removed	in_seller	log_index	block_number	in_feeAmount	block_timestamp	in_returnAmount	transaction_hash	in_outcomeTokensSold
0x0073357085d7bb8155b72df98ca41733c6bd5c2a	false	0x0393b7a4c1e4a72564bf8287c7d1471ac9a61130	36	26831743	1298029	2022-04-06T23:47:25.000Z	98550358	0xf565bcbc056401916ba33b9bd1285302877475d8b1c6d64ec49943ef9756c15f	267660913
0x0073357085d7bb8155b72df98ca41733c6bd5c2a	false	0x0393b7a4c1e4a72564bf8287c7d1471ac9a61130	21	26832042	441869	2022-04-06T23:59:51.000Z	33548065	0xd5899f9b4c80270d4d0c89a7f1ecd5b2555df9b59f8e77154c778542131daa5d	246052996
0x0073357085d7bb8155b72df98ca41733c6bd5c2a	false	0x0393b7a4c1e4a72564bf8287c7d1471ac9a61130	16	26831778	378312	2022-04-06T23:49:49.000Z	28722637	0xa4107b96548d9fa260508cc24c65e1fe102e32f8a6c9c61bb1ab253ed5281903	92552474

Example Query

Query with partition filter

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

FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event

Market creation events from Polymarket’s Fixed Product Market Maker (FPMM) factory contract on Polygon, recording when new prediction markets are deployed with their condition IDs, collateral token (USDC), creator address, and associated automated market maker (AMM) contract address. Used to track market initialization and link market maker addresses to their underlying conditional token positions.

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_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_fixedProductMarketMaker`	`STRING`	Contract address of the newly created Fixed Product Market Maker (FPMM) instance that manages liquidity and pricing for a Polymarket prediction market. This automated market maker contract is deployed when a new market is created on Polygon.
`in_conditionalTokens`	`STRING`	Contract address of the Conditional Tokens Framework contract that manages the outcome tokens for this prediction market. This address is consistent across all Polymarket markets on Polygon (`0x4d97dcd97ec945f40cf65f87097ace5ea0476045`).
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_conditionIds`	`ARRAY<STRING>`	Array of condition identifiers representing the prediction market outcomes associated with this newly created market maker. Each condition ID is a hex-encoded hash that uniquely identifies a specific market question or outcome set on Polymarket.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	log_index	in_creator	block_number	block_timestamp	in_conditionIds	transaction_hash	in_collateralToken	in_conditionalTokens	in_fixedProductMarketMaker
0x8b9805a2f595b6705e74f7310829f2d299d21522	false	0	0x91430cad2d3975766499717fa0d66a78d814e5c5	51871100	2024-01-02T23:55:35.000Z	[“0x01a9eea306780839c5cf9a15a572a438c23af6c49b57f67e8a379f5e48e0e4f8”]	0x9f9341892d8d29e5d4fe314bf767df0f3c4ed123cd6e37b3fce4a8da57b905b9	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x4d97dcd97ec945f40cf65f87097ace5ea0476045	0xc1b51879d4eed72a9638eb025b97e048ffb43736
0x8b9805a2f595b6705e74f7310829f2d299d21522	false	2	0x91430cad2d3975766499717fa0d66a78d814e5c5	51862773	2024-01-02T18:52:21.000Z	[“0xbe2059cebf75b900c3d77ceadf255e91cb7dc3c5f65135d0cd6f51c34431ec4e”]	0x7cbaf8d66779921751aeb0bbdc26fdf51e04b633f8a61f3ad2cde6ca8ac3c761	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x4d97dcd97ec945f40cf65f87097ace5ea0476045	0x5b56decc7e9797e59aed52cae6e7df1f9064ebe4
0x8b9805a2f595b6705e74f7310829f2d299d21522	false	2	0x91430cad2d3975766499717fa0d66a78d814e5c5	51862356	2024-01-02T18:36:40.000Z	[“0xa835f053e4ff50c67b1a1147ec79ad159da93a6a846671bf7a049c59d81e4dc8”]	0xdadffb60ccb563b3d8f65a62d3eecc9b4a4eabe86fb0469ee2060619a440f74d	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x4d97dcd97ec945f40cf65f87097ace5ea0476045	0xad6dd2342d8cd28c83d14e03a6659f388fd95448

Example Query

Query with partition filter

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

NegRiskCtfExchange_OrderFilled_event

Order fill events from Polymarket’s NegRisk Conditional Token Framework (CTF) exchange contract on Polygon, recording prediction market trades with maker/taker addresses, asset IDs, filled amounts, and order hashes. Used for analyzing trading activity, liquidity provision, and market maker behavior across binary outcome 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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

address	removed	in_maker	in_taker	log_index	block_number	in_orderHash	block_timestamp	in_makerAssetId	transaction_hash	in_makerAmountFilled	in_takerAmountFilled
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	0xb74be09132b377218794bedb596a6adf283af49e	0xc5d563a36ae78145c45a50134d48a1215220f80a	1088	78986753	0x6092b7691d6ca1b24585a7103a4cdbaf2dfaeab840c16ee4f0d672931daca52e	2025-11-14T00:00:04.000Z	90235318156174390107916613062725593492957057218815573793636376869202408014196	0xf20c7c2595994ecea588caae1729e6bc97913843e99754072ea46366bd20a0c1	182890000	181426880
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	0x7ca3f35801d777cdf9239a2e2fec536f8608259e	0xc5d563a36ae78145c45a50134d48a1215220f80a	721	78986755	0x2b3f64d0a4f7635ded826324b53ee48b841b1dda4039e67b252720b69bc809d9	2025-11-14T00:00:08.000Z	80746058984644290629624903019922696017323803605256698757445938534814122585786	0xc369a6423997066d39d10287e9ca37244e359be230a1225b97073d99bd71de56	5640000	2481600
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	0x91645cfb91bfb3ed6a1fd0bc3c0c66fb676d45d5	0xc5d563a36ae78145c45a50134d48a1215220f80a	1664	78986760	0x6e02c6f9d969a96bc88dcc015eff10ca721efd85774bbf9a041fcc0667831f65	2025-11-14T00:00:18.000Z	105134691322323565615831879054043168027913414000042547943201361115853277749482	0x5093af6bd067b2ccbd27623d987490d20030f0515ebc0489343b40a51846d299	6970000	6760900

Example Query

Query with partition filter

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

NegRiskCtfExchange_OrdersMatched_event

Order matching events from Polymarket’s NegRisk CTF (Conditional Token Framework) exchange on Polygon, recording maker and taker fills with asset IDs and amounts. Captures prediction market trades where makerAssetId=0 represents USDC collateral and takerAssetId represents outcome tokens for analyzing order flow and market depth.

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_takerOrderHash`	`STRING`	Order hash identifier for the taker’s order in this matched trade on Polymarket’s NegRisk CTF Exchange. Hex-encoded, 0x-prefixed 64-character string uniquely identifying the taker side of the order book match.
`in_takerOrderMaker`	`STRING`	Polygon address of the trader who submitted the taker order in this matched trade event. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the order taker’s wallet.
`in_makerAssetId`	`STRING`	Identifier for the asset being offered by the order maker. String-encoded integer representing the unique asset ID in the conditional token framework.
`in_takerAssetId`	`STRING`	Identifier for the asset being requested by the order taker. String-encoded integer representing the unique asset ID in the conditional token framework, with ‘0’ indicating the collateral token (USDC).
`in_makerAmountFilled`	`STRING`	Amount of the maker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the maker’s asset.
`in_takerAmountFilled`	`STRING`	Amount of the taker’s asset that was filled in the order execution. String-encoded integer value representing the quantity in the smallest unit of the taker’s asset.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_takerAssetId	transaction_hash	in_takerOrderHash	in_takerOrderMaker	in_makerAmountFilled	in_takerAmountFilled
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	355	67664138	2025-02-08T00:00:02.000Z	22535833765723427929773245088435042776045949943240943368073750664192788269527	0x0c423c956adbb958512ed68327cacfc0d599f1eb0b53a5d14c3fcb1941dbdaab	0x17849c52374d326de1ba716931638e4e822f0ef991d19608118a05fa6c233362	0x5be81e200cd63d69e1d1f3ba8319eaf50ed69ea9	1109998	2122368
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	883	67664140	2025-02-08T00:00:06.000Z	79992368230593363181711001558007704760805608401273323477280568017676781223445	0x326253b33a9611cea1a14e57a7e1c2e78fedb21c3fc63fcc6215ae7e4e410379	0xea0261bc544a89376a314d9c69645227441f20b8b981a5ae8da00dc4514f2c02	0xb4f5adf7a9af7f813c91071d37c95144b5a88c43	9569999	36813286
0xc5d563a36ae78145c45a50134d48a1215220f80a	false	402	67664144	2025-02-08T00:00:18.000Z	91416376047010624789509815944567714135624496925676598074916210489132578520112	0xbfee664e25035b22afe4262e18394695251c12ae30b010c388b43f6bdf1e38bb	0x1c797dd68926a38206ced4a90fb5a540e0c81199a47f88a13897834113f46628	0x9495d622ab74a601ad1668d3dd4f7a2e68c3468f	204810000	6827000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CTFExchange_FeeCharged_event

CTFExchange_NewAdmin_event

CTFExchange_NewOperator_event

CTFExchange_OrderFilled_event

CTFExchange_OrdersMatched_event

CTFExchange_RemovedAdmin_event

CTFExchange_RemovedOperator_event

CTFExchange_TokenRegistered_event

Exchange_FeeCharged_event

Exchange_OrderFilled_event

Exchange_OrdersMatched_event

FixedProductMarketMaker_FPMMBuy_event

FixedProductMarketMaker_FPMMSell_event

FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event

NegRiskCtfExchange_OrderFilled_event

NegRiskCtfExchange_OrdersMatched_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CTFExchange_FeeCharged_event

​CTFExchange_NewAdmin_event

​CTFExchange_NewOperator_event

​CTFExchange_OrderFilled_event

​CTFExchange_OrdersMatched_event

​CTFExchange_RemovedAdmin_event

​CTFExchange_RemovedOperator_event

​CTFExchange_TokenRegistered_event

​Exchange_FeeCharged_event

​Exchange_OrderFilled_event

​Exchange_OrdersMatched_event

​FixedProductMarketMaker_FPMMBuy_event

​FixedProductMarketMaker_FPMMSell_event

​FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event

​NegRiskCtfExchange_OrderFilled_event

​NegRiskCtfExchange_OrdersMatched_event

Tables

CTFExchange_FeeCharged_event

CTFExchange_NewAdmin_event

CTFExchange_NewOperator_event

CTFExchange_OrderFilled_event

CTFExchange_OrdersMatched_event

CTFExchange_RemovedAdmin_event

CTFExchange_RemovedOperator_event

CTFExchange_TokenRegistered_event

Exchange_FeeCharged_event

Exchange_OrderFilled_event

Exchange_OrdersMatched_event

FixedProductMarketMaker_FPMMBuy_event

FixedProductMarketMaker_FPMMSell_event

FixedProductMarketMakerFactory_FixedProductMarketMakerCreation_event

NegRiskCtfExchange_OrderFilled_event

NegRiskCtfExchange_OrdersMatched_event