azuro_v2_polygon

Tables

Core_GameResultFulfilled_event

Bet settlement records from Azuro v2 prediction market protocol on Polygon, showing fulfilled wagers with original stake amounts and payouts to player addresses. Used for analyzing betting outcomes, win rates, and payout distributions across prediction market games.

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_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`in_player`	`STRING`	Player address who placed the bet and receives the payout if winning. Hex-encoded, 0x-prefixed Ethereum address that submitted the original game prediction request.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_payout`	`STRING`	Payout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_payout	in_player	log_index	block_number	in_requestId	block_timestamp	transaction_hash
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	50303141	100606282	0x17c512e156fdb47721d966465773184c1937ad0f	286	50727849	108280014585909368582686429790231653359216340972547105409014572162096742064087	2023-12-04T10:33:58.000Z	0xcd9e310f8bb8235677366edbb2355740c2b17bfe8fd461440e4c511fdf9bbebf
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	15000000	30000000	0x17c512e156fdb47721d966465773184c1937ad0f	81	50730716	77439334833013524387485783985772382480961727895567017066525758127913511227773	2023-12-04T12:21:34.000Z	0x15afee170424ac22e13928b3cb137592e0c9ce3ee59d60d1a81d4dd989e4255b
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	20000320	0	0x2571efe93a93c2fc745f718eb94fe0168b6bb7f2	147	50722005	32229893670947891526415560713021881634817439317842043826859770917878535496358	2023-12-04T07:00:59.000Z	0x1d933e40cf4c67d6b97fa3099e726101ce6562cfec711f5f05de48f3b516eb7f

Example Query

Query with partition filter

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

Core_NewBet_event

Bet placement events from Azuro v2 decentralized prediction market protocol on Polygon, capturing player addresses, bet amounts, and unique request identifiers. Used for analyzing betting patterns, player activity, and wager distribution 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_player`	`STRING`	Polygon address of the player who placed the bet on the Azuro protocol. Hex-encoded, 0x-prefixed 40-character string representing the bettor’s wallet address.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`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	in_player	log_index	block_number	in_requestId	block_timestamp	transaction_hash
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	10000000	0x17e5b07ebaced24618d42f5a9cec24b398e2c59f	160	42245587	47119480182769077772770184837708005229534716857974115198552247258150742796372	2023-05-03T06:29:40.000Z	0x0235a969a4eae249ea6f2304eb5b8b14a0a9912bf91000009ae83d87dfea6469
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	10000000	0x17e5b07ebaced24618d42f5a9cec24b398e2c59f	89	42246767	63323637660485859178686821713048373631734795889104524328876880416739454829953	2023-05-03T07:12:30.000Z	0x108b699c9e51888ee59ad925c97054e405f4178108c0b6111aa9ce26807886f8
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4	false	10000000	0x17e5b07ebaced24618d42f5a9cec24b398e2c59f	150	42272801	109900817283872298630623095738785863768829887994387619867231134967417141128143	2023-05-03T22:54:36.000Z	0x515e81eda8f35fe698b2d5fce30f9f1dc2a76845c67c15bb66e66ed42992019c

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Core_GameResultFulfilled_event

Core_NewBet_event

​Tables

​Core_GameResultFulfilled_event

​Core_NewBet_event

Tables

Core_GameResultFulfilled_event

Core_NewBet_event