Prediction markets (Finance/Politics)
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.
613 rowsCSV — whole table, not this view
Sources in this table
uw_predictions613 rowsexportable
| asset_idtext | as_of ↑date | markettext | outcometext | categorytext | resolves_attimestamp with time zone | mid_pricenumeric | best_bidnumeric | best_asknumeric | 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 |