Source
Query Manifold Markets with SQL
The full Manifold prediction-market corpus — every market, every bet, every comment — queryable with read-only SQL and kept minutes-fresh from the live API.
Query surfaces
manifold.marketsmanifold.betsmanifold.comments
Public Manifold v0 API; source-native market, bet, and comment records.
Best for
probability time series for any market from per-bet prob_before/prob_after
trader-level activity and market-moving bets across ~23M bets
market discussion with each commenter's live position attached
Fields
market_idsearch_keysourceexternal_typekindentity_idslugurititlepayloadtext_descriptioncreator_idcreator_usernamecreator_namecreator_avatar_urlclose_timecreated_at_sourceupdated_at_sourcelast_bet_atlast_comment_atresolution_timeoutcome_typemechanismvisibilityis_resolvedprobabilitypoolpvolumevolume_24htotal_liquidityunique_bettor_countresolutionraw_marketmetadatablake3_hashword_countis_deletedcreated_atupdated_atarchived_at
Read live from the schema registry for manifold.markets — 41 columns. Every relation's full contract is served by /v1/scry/schema.
Queries
Most-traded open markets, latest state
Collapse observation-append state rows to the latest per market, then rank open markets by volume.
SELECT market_id, title, probability, volume, unique_bettor_count
FROM (
SELECT * FROM manifold.markets
ORDER BY updated_at DESC
LIMIT 1 BY market_id
)
WHERE is_resolved = 0
ORDER BY volume DESC
LIMIT 20;
A market's probability path, bet by bet
Every bet carries the market probability before and after it — the full price path of a question.
SELECT created_at_source, prob_before, prob_after, amount, outcome
FROM manifold.bets
WHERE contract_id = '<market-id>'
AND is_redemption = 0
ORDER BY created_at_source
LIMIT 1000;