> ## 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_v1_polygon
> Tables in tt-contracts.azuro_v1_polygon
## 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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.azuro_v1_polygon.LP_LiquidityRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***