core.prediction_snapshots
One price per market per day, from first sighting on UW's unusual list to resolution. seen_via says whether the market was on the list that day.
Simplify Analyticsuw_predictions759 rowsexportable| spreadnumeric |
|---|
| total_liquiditynumeric |
|---|
| book_tstimestamp with time zone |
|---|
| last_pricenumeric |
|---|
| volumenumeric |
|---|
| unusual_scorenumeric |
|---|
| seen_viatext |
|---|
| sourcetext |
|---|
| endpointtext |
|---|
| request_paramsjsonb |
|---|
| vintage_tstimestamp with time zone |
|---|
| retrieved_attimestamp with time zone |
|---|
| 209487012212681185769927766836850283089010514127683546135… | 2026-09-14 | WTI Crude Oil (WTI) Up or Down on September 14? | Up | Finance | 2026-09-14 17:00 | — | 0.999000 | — | — | 108682.85 | 2026-09-14 18:32 | 0.999000 | 6538.5356 | 1.381905 | unusual | uw_predictions | /api/predictions/market/{asset_id}/liquidity | {"asset_id":"20948701221268118576992776683685028308901051412768354613538604440666205764757"} | 2026-09-14 18:32 | 2026-09-14 18:32 |