Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_requestIdSTRINGUnique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
in_playerSTRINGPlayer 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_payoutSTRINGPayout amount awarded to the player or winner. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_payoutin_playerlog_indexblock_numberin_requestIdblock_timestamptransaction_hash
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false503031411006062820x17c512e156fdb47721d966465773184c1937ad0f286507278491082800145859093685826864297902316533592163409725471054090145721620967420640872023-12-04T10:33:58.000Z0xcd9e310f8bb8235677366edbb2355740c2b17bfe8fd461440e4c511fdf9bbebf
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false15000000300000000x17c512e156fdb47721d966465773184c1937ad0f8150730716774393348330135243874857839857723824809617278955670170665257581279135112277732023-12-04T12:21:34.000Z0x15afee170424ac22e13928b3cb137592e0c9ce3ee59d60d1a81d4dd989e4255b
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false2000032000x2571efe93a93c2fc745f718eb94fe0168b6bb7f214750722005322298936709478915264155607130218816348174393178420438268597709178785354963582023-12-04T07:00:59.000Z0x1d933e40cf4c67d6b97fa3099e726101ce6562cfec711f5f05de48f3b516eb7f
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_playerSTRINGPolygon 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_requestIdSTRINGUnique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_playerlog_indexblock_numberin_requestIdblock_timestamptransaction_hash
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false100000000x17e5b07ebaced24618d42f5a9cec24b398e2c59f16042245587471194801827690777727701848377080052295347168579741151985522472581507427963722023-05-03T06:29:40.000Z0x0235a969a4eae249ea6f2304eb5b8b14a0a9912bf91000009ae83d87dfea6469
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false100000000x17e5b07ebaced24618d42f5a9cec24b398e2c59f8942246767633236376604858591786868217130483736317347958891045243288768804167394548299532023-05-03T07:12:30.000Z0x108b699c9e51888ee59ad925c97054e405f4178108c0b6111aa9ce26807886f8
0x40fe3b7d707d8243e7800db704a55d7aabe3b2d4false100000000x17e5b07ebaced24618d42f5a9cec24b398e2c59f150422728011099008172838722986306230957387858637688298879943876198672311349674171411281432023-05-03T22:54:36.000Z0x515e81eda8f35fe698b2d5fce30f9f1dc2a76845c67c15bb66e66ed42992019c
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