Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Daily Polymarket open interest per wallet and token, valued with onchain prices.
polygon.predictions_onchain.open_interest_daily table contains the open interest of each wallet in each Polymarket outcome token, valued in USD with onchain daily prices. Each row represents one wallet, token and day.
This table contains no Polymarket API data. The equivalent table with Polymarket API metadata is polygon.predictions.open_interest_daily.
| Property | Value |
|---|---|
| Table Name | polygon.predictions_onchain.open_interest_daily |
| Table Status | Beta 🌱 |
| Unique Key | day, address, token_id |
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Project name (ex. polymarket). |
| protocol | VARCHAR(16777216) | Protocol name (ex. polymarket). |
| day | DATE | Date for the open interest snapshot. |
| address | VARCHAR(42) | Wallet address holding the position. |
| condition_id | VARCHAR(16777216) | Unique condition identifier for the market. |
| market_unique_id | VARCHAR(16777216) | Unique key for grouping related markets. |
| market_id | VARCHAR(16777216) | Neg-risk market identifier. |
| market_name | VARCHAR(16777216) | Market name: the neg-risk event name, the question for single markets, or the combo name for V3 positions. |
| market_description | VARCHAR(16777216) | Neg-risk event description published onchain. |
| question_id | VARCHAR(16777216) | Unique question identifier. |
| question | VARCHAR(16777216) | Market question text published onchain. |
| question_description | VARCHAR(16777216) | Market resolution description published onchain. |
| token_id | VARCHAR(16777216) | Token ID for the specific outcome token. |
| token_outcome | VARCHAR(16777216) | Outcome name for the token, such as Yes, No, Up or Down. |
| neg_risk | BOOLEAN | Whether this is a NegRisk market. |
| resolution_outcome | VARCHAR(16777216) | Market resolution outcome if resolved. |
| resolved_at | TIMESTAMP_NTZ(9) | Market resolution timestamp. |
| open_interest | FLOAT | Number of outcome tokens held (position size). |
| token_price | FLOAT | Token price for the day. |
| open_interest_usd | FLOAT | USD value of the open interest position. |
| is_price_known | BOOLEAN | Whether the token has an onchain price for the day. |
| is_winner | BOOLEAN | Whether this outcome won the market. |
| unique_id | VARCHAR(16777216) | Unique identifier combining day, address, and token_id (format ‘day-YYYY-MM-DD_address-_token_id-’). |
select *
from polygon.predictions_onchain.open_interest_daily
where day = '2026-10-17'
and token_id = '73245421796922750466829041889725203633090129283314240032365966286987444361172'
order by open_interest_usd desc
limit 100
Was this page helpful?