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

# Resolutions 🌱

> Resolved Polymarket markets with their onchain payouts and winning outcome.

The `polygon.predictions_onchain.resolutions` table lists every resolved Polymarket market with its reported payouts and winning outcome. Each row represents one resolved market.

This table contains no Polymarket API data.

### Table Details

| Property | Value |
| - | - |
| Table Name | `polygon.predictions_onchain.resolutions` |
| Table Status | Beta 🌱 |
| Unique Key | `condition_id` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR(16777216) | Project name (ex. polymarket). |
| protocol | VARCHAR(16777216) | Protocol name (ex. polymarket). |
| market\_unique\_id | VARCHAR(16777216) | Unique key for grouping related markets. |
| condition\_id | VARCHAR(16777216) | Unique condition identifier. |
| market\_id | VARCHAR(16777216) | Neg-risk market identifier. |
| question\_id | VARCHAR(16777216) | Unique question identifier. |
| question | VARCHAR(16777216) | Market question text published onchain. |
| neg\_risk | BOOLEAN | Whether this is a NegRisk market. |
| oracle | VARCHAR(42) | Address that reported the resolution. |
| outcome\_slot\_count | NUMBER(38,0) | Number of possible outcomes for the market. |
| payout\_numerators | VARCHAR(16777216) | Payouts reported for the first two outcomes, comma separated. |
| outcome | VARCHAR(16777216) | Resolution outcome: yes, no, 50/50, or unknown. |
| winning\_outcome\_index | NUMBER(38,0) | Outcome index (0-based) that won. |
| winning\_outcome | VARCHAR(16777216) | Name of the winning outcome. |
| resolved\_at | TIMESTAMP\_NTZ(9) | Resolution timestamp. |
| block\_number | NUMBER(38,0) | Block number of the resolution. |
| transaction\_hash | VARCHAR(66) | Hash of the resolution transaction. |

***

### Sample Query

```sql theme={null}
select *
from polygon.predictions_onchain.resolutions
where resolved_at >= '2026-10-18' and resolved_at < '2026-10-19'
limit 100
```