CLOB Markets
CLOB market data and daily price history from Polymarket
@polymarket.clob
CLOB market data and daily price history from Polymarket
@polymarket.clob
CREATE TABLE daily_token_prices (
"date" TIMESTAMP,
"year" TIMESTAMP,
"month" VARCHAR,
"day" VARCHAR,
"price" DOUBLE,
"token_id" VARCHAR,
"question" VARCHAR,
"outcome" VARCHAR,
"condition_id" VARCHAR,
"question_id" VARCHAR,
"market_slug" VARCHAR
);
CREATE TABLE market_outcomes (
"condition_id" VARCHAR,
"question_id" VARCHAR,
"market_slug" VARCHAR,
"question" VARCHAR,
"token_id" VARCHAR,
"outcome" VARCHAR,
"price" DOUBLE,
"winner" BOOLEAN,
"accepting_order_timestamp" TIMESTAMP,
"end_date_iso" TIMESTAMP,
"game_start_time" TIMESTAMP
);
CREATE TABLE markets (
"condition_id" VARCHAR,
"question_id" VARCHAR,
"market_slug" VARCHAR,
"question" VARCHAR,
"description" VARCHAR,
"active" BOOLEAN,
"closed" BOOLEAN,
"archived" BOOLEAN,
"accepting_orders" BOOLEAN,
"enable_order_book" BOOLEAN,
"notifications_enabled" BOOLEAN,
"is_50_50_outcome" BOOLEAN,
"neg_risk" BOOLEAN,
"neg_risk_market_id" VARCHAR,
"neg_risk_request_id" VARCHAR,
"seconds_delay" BIGINT,
"maker_base_fee" BIGINT,
"taker_base_fee" BIGINT,
"minimum_order_size" DOUBLE,
"minimum_tick_size" DOUBLE,
"accepting_order_timestamp" TIMESTAMP,
"end_date_iso" TIMESTAMP,
"game_start_time" TIMESTAMP,
"icon" VARCHAR,
"image" VARCHAR,
"fpmm" VARCHAR,
"tags" VARCHAR,
"rewards_min_size" BIGINT,
"rewards_max_spread" DOUBLE,
"rewards_asset_address" VARCHAR,
"rewards_daily_rate" DOUBLE
);
Anyone who has the link will be able to view this.