Skip to main content

Tables

Core_NewBet_event

Individual bet placements on Azuro decentralized prediction market protocol on Polygon, capturing bettor addresses, wager amounts, odds, outcome selections, and affiliate tracking for sports betting and event wagering analysis.
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_bettorSTRINGWallet address of the user who placed the bet on the Azuro prediction market. Hex-encoded, 0x-prefixed 40-character Ethereum address.
in_affiliateSTRINGAddress of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_conditionIdSTRINGUnique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_outcomeIdSTRINGIdentifier for the specific outcome being wagered on within a betting condition. Numeric string representation.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_oddsSTRINGBetting odds offered for the wager at the time of bet placement. Numeric string representation scaled by 10^12 (fixed-point decimal with 12 decimal places of precision).
in_fundsARRAY<STRING>Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.
addressin_oddsremovedin_fundsin_amountin_bettorlog_indexin_tokenIdblock_numberin_affiliatein_outcomeIdin_conditionIdblock_timestamptransaction_hash
0x7182e00567b580733bd32c69ec5069ef002807212032709089067false[“9588826050”,“8410683314”]150000000xbed68b342ac006cf71cb521d12c513fdff0064ce15418548407843090x82875517c2b4bd534de4b2c0d21bff5f40b25da6105068785865068785872023-03-26T08:52:36.000Z0x6f59d81af7c3e388aad3c288966027d202e999ed4e528e631a127cd3f65a0ac1
0x7182e00567b580733bd32c69ec5069ef002807211392014321819false[“1224423263”,“591785636”]266600000xde3453e7006ea93172f0a20a1f7bf90fa52ad60129318755408035450x82875517c2b4bd534de4b2c0d21bff5f40b25da61015074032845074032852023-03-26T22:35:14.000Z0xbb201d0dd6c4a4e43b8f545f6788ffea27cb32fbfdc33f730db8dc73ee45723f
0x7182e00567b580733bd32c69ec5069ef002807211408897567305false[“1203356962”,“607828470”]189230000xde3453e7006ea93172f0a20a1f7bf90fa52ad60126318680407970790x82875517c2b4bd534de4b2c0d21bff5f40b25da61065068790535068805722023-03-26T18:07:56.000Z0xb548bc3fc2604456a589644ea2f84d7a02cb4beb2b828c7c2df017a9258e5657
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.Core_NewBet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_NewPool_event

Liquidity pool creation events from the Azuro prediction markets protocol on Polygon, capturing pool deployments with core contract, liquidity provider (LP) token, and access control addresses. Useful for tracking protocol expansion and identifying new betting 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_lpSTRINGLiquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
in_coreSTRINGContract address of the Azuro core betting pool logic contract deployed for this liquidity pool. Hex-encoded, 0x-prefixed Polygon address that handles the betting mechanics for the associated LP token.
in_coreTypeSTRINGContract address or identifier hash specifying the type or category of the Azuro core pool being created. Appears as a keccak256 hash with two common values indicating different pool type configurations.
in_accessSTRINGContract address of the access controller managing permissions for this Azuro liquidity pool. Hex-encoded, 0x-prefixed 40-character Polygon address that governs access rights to pool operations.
in_lpaddressin_coreremovedin_accesslog_indexin_coreTypeblock_numberblock_timestamptransaction_hash
0x0b0858fed279629c525d33c898c3a3855a42aa360xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d0x5ddd1991095bf1cee44ae303c190c76a8700c99efalse0xde3bec33ac4d11da9c1529c0e2b167aeaefae8201720x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806415909952023-04-16T08:19:45.000Z0xe54367f66cc9e1bacd475364c3a1f24800d50f8bd0512cabe1d64e0542ae8d6d
0xfd7e4856d2d7a84bde4e99dd62d960953022e3890xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d0x59411eba4d3d1ba98ac66d8c84b8ba3d0ee8e165false0xddf0d4b917539354dce576ac134d14085ba02adf3310x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806415910582023-04-16T08:21:59.000Z0xf9fbfa8428abc574ae606430f60fa4cab18d17929158810066fe6b5e302a9f62
0x7043e4e1c4045424858ecbced80989feafc11b360xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d0x3b182e9fbf50398a412d17d7969561e3bfcc4fa4false0x76c3b2971ad1e68e6325bcdc5720b3f4843591c22140x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806415948602023-04-16T10:45:09.000Z0xe59773d0d208ed23e4972dd339c01b4eef5ea1abb616da1044c5f4a67b27d961
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.Factory_NewPool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FactoryCreatedCore_ConditionResolved_event

Betting condition resolution events from Azuro prediction market protocol on Polygon, recording winning outcomes and liquidity provider (LP) profit/loss when market conditions are settled. Used for analyzing settlement outcomes, payout calculations, and LP performance tracking.
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_conditionIdSTRINGUnique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
in_stateINT64State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.
in_outcomeWinSTRINGIdentifier of the winning outcome for the resolved betting condition in the Azuro prediction market. Stored as a numeric string representing the outcome option that was determined as correct.
in_lpProfitSTRINGProfit or loss accrued to liquidity providers from the resolution of this betting condition, denominated in the protocol’s base token (wei). Typically zero when conditions resolve without LP exposure, non-zero when the outcome creates imbalances.
addressremovedin_statelog_indexin_lpProfitblock_numberin_outcomeWinin_conditionIdblock_timestamptransaction_hash
0x7182e00567b580733bd32c69ec5069ef00280721false11160406306166265054260935054260942023-03-22T08:23:58.000Z0x0373fa685e31804ac5465233a2e7c213ad5f975cc111f227b7408399ba80ea5a
0x7182e00567b580733bd32c69ec5069ef00280721false1485040621753395055674510000000002023-03-22T02:38:44.000Z0x03b749226e93da886bbf6796e039df0dcf5c26f3247d9afd01860c722102a5b2
0x7182e00567b580733bd32c69ec5069ef00280721false1481040621753405055674490000000002023-03-22T02:38:44.000Z0x03b749226e93da886bbf6796e039df0dcf5c26f3247d9afd01860c722102a5b2
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.FactoryCreatedCore_ConditionResolved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FactoryCreatedCore_NewBet_event

Individual bet placement events from Azuro prediction market protocol on Polygon, capturing bettor addresses, wager amounts, odds, outcome selections, and liquidity pool states. Used for tracking user betting behavior and market liquidity dynamics across prediction market conditions.
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_bettorSTRINGWallet address of the user placing the bet on the Azuro prediction market. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the bettor.
in_affiliateSTRINGAddress of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_conditionIdSTRINGUnique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_outcomeIdSTRINGIdentifier for the specific outcome being wagered on within a betting condition. Numeric string representation.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_oddsSTRINGBetting odds offered for the wager at the time of bet placement. Numeric string representation scaled by 10^12 (fixed-point decimal with 12 decimal places of precision).
in_fundsARRAY<STRING>Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.
addressin_oddsremovedin_fundsin_amountin_bettorlog_indexin_tokenIdblock_numberin_affiliatein_outcomeIdin_conditionIdblock_timestamptransaction_hash
0x7182e00567b580733bd32c69ec5069ef002807212205399674873false[“7920225282”,“9971496703”]5000000000x0eedef2ac828db3e53c11ba87d4a902942e3ada859916622405317330x82875517c2b4bd534de4b2c0d21bff5f40b25da615008713925008713932023-03-19T15:28:53.000Z0xb4d9750b4fb61775a7deb33a23d80f5fb326510627584a9e63a57b305694e151
0x7182e00567b580733bd32c69ec5069ef002807211706470272249false[“10269230769”,“7818828150”]3000000000x0eedef2ac828db3e53c11ba87d4a902942e3ada824316620405316700x82875517c2b4bd534de4b2c0d21bff5f40b25da615009197455009197462023-03-19T15:26:27.000Z0x8c98045a22c0671891649d6c4ec9ea476d7603797912410c51d1ebd0b092b07d
0x7182e00567b580733bd32c69ec5069ef002807211803566371697false[“1354459720”,“1088672391”]2195760000x0eedef2ac828db3e53c11ba87d4a902942e3ada829116624405318780x82875517c2b4bd534de4b2c0d21bff5f40b25da615012428315012428322023-03-19T15:34:21.000Z0x4bc13ed9d540bb73cf2a5cfbd008708d0a5a60a29c4ff1f12ec6d64a862477b7
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.FactoryCreatedCore_NewBet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LP_FeeChanged_event

Fee configuration change events from Azuro prediction market liquidity pools on Polygon. Records historical adjustments to different fee types with basis point values for tracking protocol economics and liquidity provider revenue models.
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_feeTypeINT64Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_feeaddressremovedlog_indexin_feeTypeblock_numberblock_timestamptransaction_hash
7000000000000x7043e4e1c4045424858ecbced80989feafc11b36false3011469409422023-08-30T15:33:52.000Z0xcd2ff82e1211d44752333b692e0cc6fa2ae11aed521b201c2440c25d5f0be4df
1000000000000x7043e4e1c4045424858ecbced80989feafc11b36false4531480447522023-09-27T12:23:10.000Z0xa83f4957701f5c7164bc4420a94643580f132ab4517f31c740dbf7ab9f0c7e14
6000000000000x7043e4e1c4045424858ecbced80989feafc11b36false4542480447522023-09-27T12:23:10.000Z0xa83f4957701f5c7164bc4420a94643580f132ab4517f31c740dbf7ab9f0c7e14
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.LP_FeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LP_GameShifted_event

Event logs tracking game start time changes in Azuro v1 prediction markets on Polygon. Records rescheduled games with original game identifiers and updated start timestamps for monitoring fixture adjustments.
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_gameIdSTRINGUnique identifier for the game being rescheduled in the Azuro prediction market. Numeric string that maps to a specific betting event tracked by the liquidity pool contract.
in_newStartSTRINGUpdated start time for the game in Unix timestamp format. Represents the rescheduled time when the betting event begins after the GameShifted event occurs.
addressremovedin_gameIdlog_indexin_newStartblock_numberblock_timestamptransaction_hash
0x2a838ab9b037db117576db8d0dcc3b686748ef7cfalse15669188552541677090908395968812023-02-22T18:46:20.000Z0xff557c39768f8e581712035900795ac5100771d6945c739957bb4017f6f0e294
0x2a838ab9b037db117576db8d0dcc3b686748ef7cfalse1566940199971677368400395807322023-02-22T08:28:15.000Z0x25a43c9b612748fc1790d0b2dbd3803ea6246998b42af45e6b07fac64e7f1912
0x2a838ab9b037db117576db8d0dcc3b686748ef7cfalse1566940200401677362400395807192023-02-22T08:27:47.000Z0x4cc9866275414f9299921caa5fcfac9cf850d69ccb7f1033f23a2cd8686c7518
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.LP_GameShifted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LP_LiquidityAdded_event

Liquidity deposit events from Azuro protocol’s Liquidity Pool (LP) contract on Polygon, recording provider addresses, deposit amounts, and leaf identifiers for tracking liquidity provision activity. Used for analyzing liquidity provider behavior and pool growth patterns.
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_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_leafSTRINGUnique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_leafremovedin_amountlog_indexin_accountblock_numberblock_timestamptransaction_hash
0x7043e4e1c4045424858ecbced80989feafc11b361099511636884false999000000001950xaff43766bb7a39985573b2f5d673b673da63c90a672803942025-01-29T08:00:19.000Z0x2211652a79fc13a6559cdc4710be5c09199987f6fa36a7086db6e3734435e8e8
0x7043e4e1c4045424858ecbced80989feafc11b361099511632414false1000000001800x5cfad8dd102c1b256490287e6cc0a3ac42079987528939972024-01-29T17:45:46.000Z0x07a34f24a9b6f4069986a424b4233372a27ecad905b8bad48abacbb4f641d3e3
0x7043e4e1c4045424858ecbced80989feafc11b361099511632410false10000000002880x59087efe1c2de9a18d58af192b0c7947cdb021f7528908732024-01-29T15:49:51.000Z0x2be3877e87e4fb7644ef641d669df0083755a7dbe57d4ab383e2b35fb1d66235
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.LP_LiquidityAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LP_LiquidityRemoved_event

Liquidity withdrawal events from Azuro prediction market liquidity pools on Polygon, recording account addresses, leaf identifiers, and removal amounts. Used for tracking liquidity provider exits and pool depth changes over time.
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_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_leafSTRINGUnique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_leafremovedin_amountlog_indexin_accountblock_numberblock_timestamptransaction_hash
0x7043e4e1c4045424858ecbced80989feafc11b361099511636834false86296393500x09cc0ee72e18651e45554c990739970fc1ffd05c647520202024-11-26T11:13:59.000Z0xae7ee372bc924600ea68a8823403cc9cadb9e2d56fa0277a97c5485e803d05b7
0x7043e4e1c4045424858ecbced80989feafc11b361099511636739false18029337203160x10981f03bda67342b272036571ca008fd53af4df647674532024-11-26T21:29:55.000Z0x0cce2339a752c0f4c2bebbc62801f9a98b0f17e66b19c72021a4d96b10b3c4b7
0x7043e4e1c4045424858ecbced80989feafc11b361099511628584false379475864450x268127c6cc64e7c8365eac6645b3f3aca0e1db10647337702024-11-26T00:20:16.000Z0x12b333314acba37f1bded9275bb1b731a404fc8a0eaf4130360f7ff059ffc25f
Query with partition filter
SELECT *
FROM `tt-contracts.azuro_v1_polygon.LP_LiquidityRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100