Name: Limitless Exchange Markets
Creator: Limitless Exchange
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Limitless Exchange Markets

Core prediction market data from Limitless Exchange, organized into four tables:

markets – one row per market with identifiers, title, categories, tags, status, expiration, collateral, pricing, liquidity, volume and reward settings.
market_feed_events – real-time feed events per market, including new trades and other user activity, with rich user profile and trade payload details.
market_prices – historical price ticks per market, capturing the time series of prices used to analyse market evolution and volatility.
market_events – on-chain–style market events per market, including trades, matched orders, sizes, sides and profile-level metadata for participants.

Disclaimer: Limitless Exchange does not expose an API endpoint to retrieve historical (inactive) markets. This dataset therefore only includes markets that were active as of the end of November 2025 and any markets created thereafter, and does not represent the full historical universe of Limitless markets.

Tables

Feed Events

@limitless.markets.feed_events

315.62 MB
649,964 rows
34 columns

CREATE TABLE feed_events (
  "slug" VARCHAR,
  "event_type" VARCHAR,
  "timestamp" TIMESTAMP,
  "body_hash" VARCHAR,
  "user_id" BIGINT,
  "user_account" VARCHAR,
  "user_username" VARCHAR,
  "user_display_name" VARCHAR,
  "user_name" VARCHAR,
  "user_bio" VARCHAR,
  "user_client" VARCHAR,
  "user_pfp_url" VARCHAR,
  "user_smart_wallet" VARCHAR,
  "user_is_creator" BOOLEAN,
  "user_is_onboarded" BOOLEAN,
  "user_is_admin" BOOLEAN,
  "user_has_traded" BOOLEAN,
  "user_referral_code" VARCHAR,
  "user_mode" VARCHAR,
  "user_trade_wallet_option" VARCHAR,
  "user_trade_wallet_choosen" BOOLEAN,
  "user_embedded_account" VARCHAR,
  "user_image_uri" VARCHAR,
  "data_title" VARCHAR,
  "data_address" VARCHAR,
  "data_strategy" VARCHAR,
  "data_outcome" VARCHAR,
  "data_contracts" VARCHAR,
  "data_tx_hash" VARCHAR,
  "data_symbol" VARCHAR,
  "data_trade_amount" VARCHAR,
  "data_trade_amount_usd" VARCHAR,
  "data_market_id" BIGINT,
  "raw_event_json" VARCHAR
);

Market Events

@limitless.markets.market_events

183.59 MB
585,765 rows
24 columns

CREATE TABLE market_events (
  "slug" VARCHAR,
  "market_id" BIGINT,
  "created_at" TIMESTAMP,
  "price" DOUBLE,
  "side" BIGINT,
  "maker_amount" VARCHAR,
  "taker_amount" VARCHAR,
  "matched_size" VARCHAR,
  "title" VARCHAR,
  "token_id" VARCHAR,
  "tx_hash" VARCHAR,
  "profile_id" BIGINT,
  "profile_account" VARCHAR,
  "profile_username" VARCHAR,
  "profile_display_name" VARCHAR,
  "profile_pfp_url" VARCHAR,
  "profile_social_url" VARCHAR,
  "profile_rank_id" BIGINT,
  "profile_rank_name" VARCHAR,
  "profile_rank_fee_rate_bps" BIGINT,
  "profile_points" VARCHAR,
  "profile_leaderboard_position" VARCHAR,
  "profile_referred_users_count" VARCHAR,
  "raw_event_json" VARCHAR
);

Markets

@limitless.markets.markets

891.85 kB
2,568 rows
47 columns

CREATE TABLE markets (
  "market_id" BIGINT,
  "address" VARCHAR,
  "condition_id" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "collateral_token_address" VARCHAR,
  "collateral_token_decimals" BIGINT,
  "collateral_token_symbol" VARCHAR,
  "creator_name" VARCHAR,
  "creator_image_uri" VARCHAR,
  "creator_link" VARCHAR,
  "position_ids" VARCHAR,
  "price_yes" DOUBLE,
  "price_no" DOUBLE,
  "categories" VARCHAR,
  "tags" VARCHAR,
  "status" VARCHAR,
  "expired" BOOLEAN,
  "expiration_date_str" VARCHAR,
  "expiration_timestamp_ms" BIGINT,
  "expiration_time" TIMESTAMP,
  "created_at" TIMESTAMP,
  "updated_at" TIMESTAMP,
  "volume_raw" BIGINT,
  "volume_formatted" DOUBLE,
  "open_interest_raw" BIGINT,
  "open_interest_formatted" DOUBLE,
  "liquidity_raw" BIGINT,
  "liquidity_formatted" DOUBLE,
  "trade_type" VARCHAR,
  "market_type" VARCHAR,
  "priority_index" BIGINT,
  "is_rewardable" BOOLEAN,
  "tokens_yes" VARCHAR,
  "tokens_no" VARCHAR,
  "metadata_fee" BOOLEAN,
  "metadata_is_bannered" BOOLEAN,
  "metadata_is_poly_arbitrage" BOOLEAN,
  "metadata_should_market_make" BOOLEAN,
  "settings_min_size" BIGINT,
  "settings_max_spread" DOUBLE,
  "settings_daily_reward" BIGINT,
  "settings_rewards_epoch" DOUBLE,
  "settings_c" BIGINT,
  "trends_hourly_value" BIGINT,
  "trends_hourly_rank" BIGINT,
  "slug" VARCHAR
);

Prices

@limitless.markets.prices

15.12 MB
1,080,616 rows
7 columns

CREATE TABLE prices (
  "slug" VARCHAR,
  "market_id" BIGINT,
  "title" VARCHAR,
  "market_status" VARCHAR,
  "timestamp_ms" BIGINT,
  "timestamp" TIMESTAMP,
  "price" DOUBLE
);