> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# azuro_v2_polygon

> Tables in tt-contracts.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.

<Accordion title="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.                                               |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.azuro_v2_polygon.Core_GameResultFulfilled_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                        |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.azuro_v2_polygon.Core_NewBet_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***