ForecastEx Prediction Markets
Daily pairs and price candles
@forecastex.markets
Daily pairs and price candles
@forecastex.markets
Daily snapshots of ForecastEx prediction markets, including:
pairs table: individual YES/NO pairs for each event contract, with quotes, quantities and pair timestamps.prices table: daily OHLC-style price candles and open interest for each event contract and side (YES / NO).CREATE TABLE pairs (
"pair_id" VARCHAR,
"event_contract" VARCHAR,
"expiration_date" TIMESTAMP,
"quantity" BIGINT,
"yes_price" DOUBLE,
"no_price" DOUBLE,
"pair_time" TIMESTAMP
);CREATE TABLE prices (
"event_contract" VARCHAR,
"subtype" VARCHAR,
"expiration_date" TIMESTAMP,
"date" TIMESTAMP,
"start_price" DOUBLE,
"high_price" DOUBLE,
"low_price" DOUBLE,
"end_price" DOUBLE,
"settlement_price" DOUBLE,
"pair_quantity" BIGINT,
"open_interest" BIGINT,
"vwap" DOUBLE
);Anyone who has the link will be able to view this.