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.Columns
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_bettor | STRING | Wallet address of the user who placed the bet on the Azuro prediction market. Hex-encoded, 0x-prefixed 40-character Ethereum address. |
in_affiliate | STRING | Address of the affiliate who referred the transaction. 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. |
in_tokenId | STRING | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID. |
in_outcomeId | STRING | Identifier for the specific outcome being wagered on within a betting condition. Numeric string representation. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
in_odds | STRING | Betting 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_funds | ARRAY<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. |
Sample Data
Sample Data
| address | in_odds | removed | in_funds | in_amount | in_bettor | log_index | in_tokenId | block_number | in_affiliate | in_outcomeId | in_conditionId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 2032709089067 | false | [“9588826050”,“8410683314”] | 15000000 | 0xbed68b342ac006cf71cb521d12c513fdff0064ce | 154 | 18548 | 40784309 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 10 | 506878586506878587 | 2023-03-26T08:52:36.000Z | 0x6f59d81af7c3e388aad3c288966027d202e999ed4e528e631a127cd3f65a0ac1 |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 1392014321819 | false | [“1224423263”,“591785636”] | 26660000 | 0xde3453e7006ea93172f0a20a1f7bf90fa52ad601 | 293 | 18755 | 40803545 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 101 | 507403284507403285 | 2023-03-26T22:35:14.000Z | 0xbb201d0dd6c4a4e43b8f545f6788ffea27cb32fbfdc33f730db8dc73ee45723f |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 1408897567305 | false | [“1203356962”,“607828470”] | 18923000 | 0xde3453e7006ea93172f0a20a1f7bf90fa52ad601 | 263 | 18680 | 40797079 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 106 | 506879053506880572 | 2023-03-26T18:07:56.000Z | 0xb548bc3fc2604456a589644ea2f84d7a02cb4beb2b828c7c2df017a9258e5657 |
Example Query
Example Query
Query with partition filter
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.Columns
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_lp | STRING | Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string. |
in_core | STRING | Contract 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_coreType | STRING | Contract 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_access | STRING | Contract 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. |
Sample Data
Sample Data
| in_lp | address | in_core | removed | in_access | log_index | in_coreType | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x0b0858fed279629c525d33c898c3a3855a42aa36 | 0xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d | 0x5ddd1991095bf1cee44ae303c190c76a8700c99e | false | 0xde3bec33ac4d11da9c1529c0e2b167aeaefae820 | 172 | 0x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806 | 41590995 | 2023-04-16T08:19:45.000Z | 0xe54367f66cc9e1bacd475364c3a1f24800d50f8bd0512cabe1d64e0542ae8d6d |
| 0xfd7e4856d2d7a84bde4e99dd62d960953022e389 | 0xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d | 0x59411eba4d3d1ba98ac66d8c84b8ba3d0ee8e165 | false | 0xddf0d4b917539354dce576ac134d14085ba02adf | 331 | 0x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806 | 41591058 | 2023-04-16T08:21:59.000Z | 0xf9fbfa8428abc574ae606430f60fa4cab18d17929158810066fe6b5e302a9f62 |
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 0xde3e9a39af548b5daa8365d30a5f6e7a7fa0203d | 0x3b182e9fbf50398a412d17d7969561e3bfcc4fa4 | false | 0x76c3b2971ad1e68e6325bcdc5720b3f4843591c2 | 214 | 0x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806 | 41594860 | 2023-04-16T10:45:09.000Z | 0xe59773d0d208ed23e4972dd339c01b4eef5ea1abb616da1044c5f4a67b27d961 |
Example Query
Example Query
Query with partition filter
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.Columns
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_conditionId | STRING | Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol. |
in_state | INT64 | State 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_outcomeWin | STRING | Identifier 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_lpProfit | STRING | Profit 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. |
Sample Data
Sample Data
| address | removed | in_state | log_index | in_lpProfit | block_number | in_outcomeWin | in_conditionId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x7182e00567b580733bd32c69ec5069ef00280721 | false | 1 | 116 | 0 | 40630616 | 626 | 505426093505426094 | 2023-03-22T08:23:58.000Z | 0x0373fa685e31804ac5465233a2e7c213ad5f975cc111f227b7408399ba80ea5a |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | false | 1 | 485 | 0 | 40621753 | 39 | 505567451000000000 | 2023-03-22T02:38:44.000Z | 0x03b749226e93da886bbf6796e039df0dcf5c26f3247d9afd01860c722102a5b2 |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | false | 1 | 481 | 0 | 40621753 | 40 | 505567449000000000 | 2023-03-22T02:38:44.000Z | 0x03b749226e93da886bbf6796e039df0dcf5c26f3247d9afd01860c722102a5b2 |
Example Query
Example Query
Query with partition filter
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.Columns
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_bettor | STRING | Wallet address of the user placing the bet on the Azuro prediction market. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the bettor. |
in_affiliate | STRING | Address of the affiliate who referred the transaction. 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. |
in_tokenId | STRING | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID. |
in_outcomeId | STRING | Identifier for the specific outcome being wagered on within a betting condition. Numeric string representation. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
in_odds | STRING | Betting 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_funds | ARRAY<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. |
Sample Data
Sample Data
| address | in_odds | removed | in_funds | in_amount | in_bettor | log_index | in_tokenId | block_number | in_affiliate | in_outcomeId | in_conditionId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 2205399674873 | false | [“7920225282”,“9971496703”] | 500000000 | 0x0eedef2ac828db3e53c11ba87d4a902942e3ada8 | 599 | 16622 | 40531733 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 1 | 500871392500871393 | 2023-03-19T15:28:53.000Z | 0xb4d9750b4fb61775a7deb33a23d80f5fb326510627584a9e63a57b305694e151 |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 1706470272249 | false | [“10269230769”,“7818828150”] | 300000000 | 0x0eedef2ac828db3e53c11ba87d4a902942e3ada8 | 243 | 16620 | 40531670 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 1 | 500919745500919746 | 2023-03-19T15:26:27.000Z | 0x8c98045a22c0671891649d6c4ec9ea476d7603797912410c51d1ebd0b092b07d |
| 0x7182e00567b580733bd32c69ec5069ef00280721 | 1803566371697 | false | [“1354459720”,“1088672391”] | 219576000 | 0x0eedef2ac828db3e53c11ba87d4a902942e3ada8 | 291 | 16624 | 40531878 | 0x82875517c2b4bd534de4b2c0d21bff5f40b25da6 | 1 | 501242831501242832 | 2023-03-19T15:34:21.000Z | 0x4bc13ed9d540bb73cf2a5cfbd008708d0a5a60a29c4ff1f12ec6d64a862477b7 |
Example Query
Example Query
Query with partition filter
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.Columns
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_feeType | INT64 | Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes. |
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
Sample Data
| in_fee | address | removed | log_index | in_feeType | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 700000000000 | 0x7043e4e1c4045424858ecbced80989feafc11b36 | false | 301 | 1 | 46940942 | 2023-08-30T15:33:52.000Z | 0xcd2ff82e1211d44752333b692e0cc6fa2ae11aed521b201c2440c25d5f0be4df |
| 100000000000 | 0x7043e4e1c4045424858ecbced80989feafc11b36 | false | 453 | 1 | 48044752 | 2023-09-27T12:23:10.000Z | 0xa83f4957701f5c7164bc4420a94643580f132ab4517f31c740dbf7ab9f0c7e14 |
| 600000000000 | 0x7043e4e1c4045424858ecbced80989feafc11b36 | false | 454 | 2 | 48044752 | 2023-09-27T12:23:10.000Z | 0xa83f4957701f5c7164bc4420a94643580f132ab4517f31c740dbf7ab9f0c7e14 |
Example Query
Example Query
Query with partition filter
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.Columns
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_gameId | STRING | Unique 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_newStart | STRING | Updated start time for the game in Unix timestamp format. Represents the rescheduled time when the betting event begins after the GameShifted event occurs. |
Sample Data
Sample Data
| address | removed | in_gameId | log_index | in_newStart | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x2a838ab9b037db117576db8d0dcc3b686748ef7c | false | 1566918855 | 254 | 1677090908 | 39596881 | 2023-02-22T18:46:20.000Z | 0xff557c39768f8e581712035900795ac5100771d6945c739957bb4017f6f0e294 |
| 0x2a838ab9b037db117576db8d0dcc3b686748ef7c | false | 1566940199 | 97 | 1677368400 | 39580732 | 2023-02-22T08:28:15.000Z | 0x25a43c9b612748fc1790d0b2dbd3803ea6246998b42af45e6b07fac64e7f1912 |
| 0x2a838ab9b037db117576db8d0dcc3b686748ef7c | false | 1566940200 | 40 | 1677362400 | 39580719 | 2023-02-22T08:27:47.000Z | 0x4cc9866275414f9299921caa5fcfac9cf850d69ccb7f1033f23a2cd8686c7518 |
Example Query
Example Query
Query with partition filter
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.Columns
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_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_leaf | STRING | Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| address | in_leaf | removed | in_amount | log_index | in_account | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511636884 | false | 99900000000 | 195 | 0xaff43766bb7a39985573b2f5d673b673da63c90a | 67280394 | 2025-01-29T08:00:19.000Z | 0x2211652a79fc13a6559cdc4710be5c09199987f6fa36a7086db6e3734435e8e8 |
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511632414 | false | 100000000 | 180 | 0x5cfad8dd102c1b256490287e6cc0a3ac42079987 | 52893997 | 2024-01-29T17:45:46.000Z | 0x07a34f24a9b6f4069986a424b4233372a27ecad905b8bad48abacbb4f641d3e3 |
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511632410 | false | 1000000000 | 288 | 0x59087efe1c2de9a18d58af192b0c7947cdb021f7 | 52890873 | 2024-01-29T15:49:51.000Z | 0x2be3877e87e4fb7644ef641d669df0083755a7dbe57d4ab383e2b35fb1d66235 |
Example Query
Example Query
Query with partition filter
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.Columns
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_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_leaf | STRING | Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| address | in_leaf | removed | in_amount | log_index | in_account | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511636834 | false | 8629639 | 350 | 0x09cc0ee72e18651e45554c990739970fc1ffd05c | 64752020 | 2024-11-26T11:13:59.000Z | 0xae7ee372bc924600ea68a8823403cc9cadb9e2d56fa0277a97c5485e803d05b7 |
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511636739 | false | 1802933720 | 316 | 0x10981f03bda67342b272036571ca008fd53af4df | 64767453 | 2024-11-26T21:29:55.000Z | 0x0cce2339a752c0f4c2bebbc62801f9a98b0f17e66b19c72021a4d96b10b3c4b7 |
| 0x7043e4e1c4045424858ecbced80989feafc11b36 | 1099511628584 | false | 37947586 | 445 | 0x268127c6cc64e7c8365eac6645b3f3aca0e1db10 | 64733770 | 2024-11-26T00:20:16.000Z | 0x12b333314acba37f1bded9275bb1b731a404fc8a0eaf4130360f7ff059ffc25f |
Example Query
Example Query
Query with partition filter