Polymarket Tables

Tables containing Polymarket prediction market data including order books, trades, and market information.

Last updated: 2026-05-23 21:01 UTC

Tables (3)

Table	Rows	Size
polymarket_order_filled_v3	1,348,948,406	217.49 GB
raw_event_meta	42,322	428.9 MB
raw_market_meta	2,330,697	2.09 GB

polymarket_order_filled_v3

Statistic	Value
Rows	1,348,948,406
Size	217.49 GB
Partition Key	`toYYYYMMDD(block_timestamp)`

Columns:

Column	Type	Description
`event_id`	`String`	Unique event identifier
`order_hash`	`String`	Hash of the order
`wallet`	`String`	Wallet address that placed the order
`asset`	`String`	Outcome token (condition ID + outcome index)
`amount_token`	`UInt256`	Token amount filled
`amount_usdc`	`UInt256`	USDC amount filled
`is_maker`	`Bool`	Whether this was the maker side
`side`	`FixedString(1)`	Order side (B=buy, S=sell)
`fee`	`UInt256`	Fee amount in USDC
`block_number`	`UInt64`	Polygon block number
`log_index`	`UInt32`	Log index within the transaction
`transaction_index`	`UInt32`	Transaction index in block
`contract_address`	`String`	CTF Exchange contract address
`block_hash`	`String`	Block hash
`block_timestamp`	`DateTime`	UTC timestamp of the block
`gas_used`	`UInt64`	Gas used by transaction
`gas_limit`	`UInt64`	Gas limit set for transaction
`base_fee_per_gas`	`UInt256`	Base fee per gas (EIP-1559)
`transaction_hash`	`String`	Transaction hash
`transaction_from`	`String`	Transaction sender
`transaction_to`	`String`	Transaction recipient
`transaction_value`	`UInt256`	ETH value transferred
`transaction_gas`	`UInt64`	Gas provided for transaction
`transaction_nonce`	`UInt64`	Transaction nonce
`max_fee_per_gas`	`UInt256`	Maximum fee per gas (EIP-1559)
`max_priority_fee_per_gas`	`UInt256`	Maximum priority fee (EIP-1559)
`inserted_at`	`DateTime`	Record insertion timestamp
`builder`	`String`	Default: `''`
`metadata`	`String`	Default: `''`

Example Query:

ClickHouse (polymarket)

raw_event_meta

Statistic	Value
Rows	42,322
Size	428.9 MB

Columns:

Column	Type	Description
`event_id`	`String`	Unique event identifier
`ticker`	`Nullable(String)`	Event ticker symbol (URL-safe)
`slug`	`Nullable(String)`	URL-friendly event slug
`title`	`Nullable(String)`	Event title
`subtitle`	`Nullable(String)`	Event subtitle
`description`	`Nullable(String)`	Event description / resolution rules text
`resolution_source`	`Nullable(String)`	Source URL/reference used for event resolution
`start_dttm`	`Nullable(DateTime64(3))`	Event start datetime
`creation_dttm`	`Nullable(DateTime64(3))`	Event creation datetime
`end_dttm`	`Nullable(DateTime64(3))`	Event end datetime
`image`	`Nullable(String)`	Event image URL
`icon`	`Nullable(String)`	Event icon URL
`is_active`	`Nullable(Bool)`	Whether event is active
`is_closed`	`Nullable(Bool)`	Whether event is closed
`is_archived`	`Nullable(Bool)`	Whether event is archived
`is_new`	`Nullable(Bool)`	Whether event is flagged as new
`is_featured`	`Nullable(Bool)`	Whether event is featured
`is_restricted`	`Nullable(Bool)`	Whether event has access restrictions (e.g., geo-blocked)
`liquidity`	`Nullable(Float64)`	Total event liquidity (aggregated across markets)
`volume`	`Nullable(Float64)`	Total event trading volume
`open_interest`	`Nullable(Float64)`	Open interest for the event
`sort_by`	`Nullable(String)`	Sort key used for event ordering
`category`	`Nullable(String)`	Event category
`subcategory`	`Nullable(String)`	Event subcategory
`is_template`	`Nullable(Bool)`	Whether event is a template
`template_variables`	`Nullable(String)`	Template variables for templated events (JSON)
`published_at`	`Nullable(String)`	Publication timestamp
`created_by`	`Nullable(String)`	User ID who created the event
`updated_by`	`Nullable(String)`	User ID who last updated the event
`created_dttm`	`Nullable(DateTime64(3))`	Event record creation datetime
`updated_dttm`	`Nullable(DateTime64(3))`	Event record last update datetime
`is_comments_enabled`	`Nullable(Bool)`	Whether comments are enabled
`competitive`	`Nullable(Float64)`	Event competitiveness score
`volume_24hr`	`Nullable(Float64)`	24-hour event trading volume
`volume_1wk`	`Nullable(Float64)`	7-day event trading volume
`volume_1mo`	`Nullable(Float64)`	30-day event trading volume
`volume_1yr`	`Nullable(Float64)`	1-year event trading volume
`featured_image`	`Nullable(String)`	Featured image URL
`disqus_thread`	`Nullable(String)`	Disqus comment thread ID
`parent_event`	`Nullable(String)`	Parent event identifier (for nested events)
`is_enable_order_book`	`Nullable(Bool)`	Whether order book is enabled
`liquidity_amm`	`Nullable(Float64)`	AMM liquidity for the event
`liquidity_clob`	`Nullable(Float64)`	CLOB liquidity for the event
`is_neg_risk`	`Nullable(Bool)`	Whether event uses negative risk markets
`neg_risk_market_id`	`Nullable(String)`	Negative risk market identifier
`neg_risk_fee_bips`	`Nullable(Int64)`	Negative risk fee in basis points
`comment_count`	`Nullable(Int64)`	Number of comments on the event
`image_optimized`	`Nullable(String)`	Optimized image URL
`icon_optimized`	`Nullable(String)`	Optimized icon URL
`featured_image_optimized`	`Nullable(String)`	Optimized featured image URL
`sub_events`	`Nullable(String)`	JSON array of sub-events
`markets`	`Nullable(String)`	JSON array of markets belonging to this event
`series`	`Nullable(String)`	JSON array of series the event belongs to
`categories`	`Nullable(String)`	JSON array of categories
`collections`	`Nullable(String)`	JSON array of collections
`tags`	`Nullable(String)`	JSON array of tags
`is_cyom`	`Nullable(Bool)`	Whether event is 'create your own market' (CYOM)
`closed_dttm`	`Nullable(DateTime64(3))`	Event closing datetime
`is_show_all_outcomes`	`Nullable(Bool)`	Whether to show all outcomes in UI
`is_show_market_images`	`Nullable(Bool)`	Whether to show market images in UI
`is_automatically_resolved`	`Nullable(Bool)`	Whether event is auto-resolved
`is_enable_neg_risk`	`Nullable(Bool)`	Whether negative risk is enabled
`is_automatically_active`	`Nullable(Bool)`	Whether event is auto-activated
`event_date`	`Nullable(String)`	Event date string (display format)
`start_time`	`Nullable(DateTime64(3))`	Event start time
`event_week`	`Nullable(Int64)`	Week number of event (for recurring events)
`series_slug`	`Nullable(String)`	Slug of the series the event belongs to
`score`	`Nullable(String)`	Event score (sports events)
`elapsed`	`Nullable(String)`	Elapsed time string (sports events)
`period`	`Nullable(String)`	Period indicator (sports events, e.g., Q1, H2)
`is_live`	`Nullable(Bool)`	Whether event is currently live (sports events)
`is_ended`	`Nullable(Bool)`	Whether event has ended (sports events)
`finished_timestamp`	`Nullable(DateTime64(3))`	Timestamp the event finished
`gmp_chart_mode`	`Nullable(String)`	GMP chart display mode
`event_creators`	`Nullable(String)`	Event creators metadata
`tweet_count`	`Nullable(Int64)`	Number of associated tweets
`chats`	`Nullable(String)`	Chat metadata
`featured_order`	`Nullable(Int64)`	Display order when featured
`is_estimate_value`	`Nullable(Bool)`	Whether value is estimated
`is_cant_estimate`	`Nullable(Bool)`	Whether value cannot be estimated
`estimated_value`	`Nullable(String)`	Estimated value (free-form string)
`templates`	`Nullable(String)`	Templates associated with the event
`spreads_main_line`	`Nullable(Float64)`	Main spread line (sports betting)
`totals_main_line`	`Nullable(Float64)`	Main totals line (sports betting)
`carousel_map`	`Nullable(String)`	Carousel display metadata
`is_pending_deployment`	`Nullable(Bool)`	Whether event is pending deployment
`is_deploying`	`Nullable(Bool)`	Whether event is currently deploying
`deploying_timestamp`	`Nullable(DateTime64(3))`	Deployment timestamp
`scheduled_deployment_timestamp`	`Nullable(DateTime64(3))`	Scheduled deployment time
`game_status`	`Nullable(String)`	Game status (sports events)
`raw_json`	`String`	Raw JSON response from Polymarket API
`inserted_at`	`DateTime`	Record insertion timestamp

Example Query:

ClickHouse (polymarket)

raw_market_meta

Statistic	Value
Rows	2,330,697
Size	2.09 GB

Columns:

Column	Type	Description
`market_id`	`String`	Unique market identifier
`question`	`Nullable(String)`	Market question text
`condition_id`	`String`	Gnosis conditional token condition ID
`slug`	`Nullable(String)`	URL-friendly market slug
`twitter_card_image`	`Nullable(String)`	Twitter card image URL
`resolution_source`	`Nullable(String)`	Source for market resolution
`market_end_dttm`	`Nullable(DateTime64(3))`	Market end datetime
`market_start_dttm`	`Nullable(DateTime64(3))`	Market start datetime
`category`	`Nullable(String)`	Market category
`amm_type`	`Nullable(String)`	AMM type used
`sponsor_name`	`Nullable(String)`	Market sponsor name
`sponsor_image`	`Nullable(String)`	Sponsor image URL
`x_axis_value`	`Nullable(String)`	X-axis label for charts
`y_axis_value`	`Nullable(String)`	Y-axis label for charts
`denomination_token`	`Nullable(String)`	Token used for denomination
`fee`	`Nullable(Float64)`	Market fee percentage
`lower_bound`	`Nullable(String)`	Lower bound for scalar markets
`upper_bound`	`Nullable(String)`	Upper bound for scalar markets
`description`	`Nullable(String)`	Market description
`outcome`	`Nullable(String)`	Outcome name
`outcome_price`	`Nullable(Float64)`	Current outcome price (0-1)
`clob_token_id`	`String`	CLOB token identifier
`volume`	`Nullable(Float64)`	Total trading volume
`volume_num`	`Nullable(Float64)`	Numeric trading volume
`is_active`	`Nullable(Bool)`	Whether market is active
`market_type`	`Nullable(String)`	Type of market
`format_type`	`Nullable(String)`	Display format type
`lower_bound_dttm`	`Nullable(String)`	Lower bound datetime for time-based markets
`upper_bound_dttm`	`Nullable(String)`	Upper bound datetime for time-based markets
`is_closed`	`Nullable(Bool)`	Whether market is closed
`market_maker_address`	`Nullable(String)`	Market maker address
`created_by`	`Nullable(Int64)`	User ID who created the market
`updated_by`	`Nullable(Int64)`	User ID who last updated the market
`created_dttm`	`Nullable(DateTime64(3))`	Market creation datetime
`updated_dttm`	`Nullable(DateTime64(3))`	Market last update datetime
`closed_dttm`	`Nullable(DateTime64(3))`	Market close datetime
`is_wide_format`	`Nullable(Bool)`	Whether market uses wide display format
`is_new`	`Nullable(Bool)`	Whether market is flagged as new
`mailchimp_tag`	`Nullable(String)`	Mailchimp tag for notifications
`is_featured`	`Nullable(Bool)`	Whether market is featured
`is_archived`	`Nullable(Bool)`	Whether market is archived
`resolved_by`	`Nullable(String)`	Resolution source or resolver
`is_restricted`	`Nullable(Bool)`	Whether market has access restrictions
`market_group`	`Nullable(Int64)`	Market group identifier
`group_item_title`	`Nullable(String)`	Title within market group
`group_item_threshold`	`Nullable(String)`	Threshold for group item
`question_id`	`Nullable(String)`	Question identifier
`uma_end_dttm`	`Nullable(String)`	UMA oracle end datetime
`is_enable_order_book`	`Nullable(Bool)`	Whether order book is enabled
`order_price_min_tick_size`	`Nullable(Float64)`	Minimum price tick size
`order_min_size`	`Nullable(Float64)`	Minimum order size
`uma_resolution_status`	`Nullable(String)`	UMA resolution status
`curation_order`	`Nullable(Int64)`	Curation display order
`liquidity_num`	`Nullable(Float64)`	Numeric liquidity value
`end_date_iso_dt_str`	`Nullable(String)`	ISO format end date string
`start_date_iso_dt_str`	`Nullable(String)`	ISO format start date string
`uma_end_date_iso_dt_str`	`Nullable(String)`	UMA end date ISO string
`is_having_reviewed_dates`	`Nullable(Bool)`	Whether dates have been reviewed
`is_ready_for_cron`	`Nullable(Bool)`	Whether ready for cron processing
`is_comments_enabled`	`Nullable(Bool)`	Whether comments are enabled
`volume_24hr`	`Nullable(Float64)`	24-hour trading volume
`volume_1wk`	`Nullable(Float64)`	7-day trading volume
`volume_1mo`	`Nullable(Float64)`	30-day trading volume
`volume_1yr`	`Nullable(Float64)`	1-year trading volume
`game_start_time`	`Nullable(String)`	Game/event start time
`seconds_delay`	`Nullable(Int64)`	Delay in seconds
`disqus_thread`	`Nullable(String)`	Disqus comment thread ID
`short_outcome`	`Nullable(String)`	Short outcome label
`team_a_id`	`Nullable(String)`	Team A identifier (sports)
`team_b_id`	`Nullable(String)`	Team B identifier (sports)
`uma_bond`	`Nullable(String)`	UMA oracle bond amount
`uma_reward`	`Nullable(String)`	UMA oracle reward amount
`is_fpmm_live`	`Nullable(Bool)`	Whether FPMM is live
`volume_24hr_amm`	`Nullable(Float64)`	24-hour AMM volume
`volume_1wk_amm`	`Nullable(Float64)`	7-day AMM volume
`volume_1mo_amm`	`Nullable(Float64)`	30-day AMM volume
`volume_1yr_amm`	`Nullable(Float64)`	1-year AMM volume
`volume_24hr_clob`	`Nullable(Float64)`	24-hour CLOB volume
`volume_1wk_clob`	`Nullable(Float64)`	7-day CLOB volume
`volume_1mo_clob`	`Nullable(Float64)`	30-day CLOB volume
`volume_1yr_clob`	`Nullable(Float64)`	1-year CLOB volume
`volume_amm`	`Nullable(Float64)`	Total AMM volume
`volume_clob`	`Nullable(Float64)`	Total CLOB volume
`liquidity`	`Nullable(Float64)`	Total liquidity
`liquidity_amm`	`Nullable(Float64)`	AMM liquidity
`liquidity_clob`	`Nullable(Float64)`	CLOB liquidity
`maker_base_fee`	`Nullable(Int64)`	Maker base fee
`taker_base_fee`	`Nullable(Int64)`	Taker base fee
`custom_liveness`	`Nullable(Int64)`	Custom liveness period
`is_accepting_orders`	`Nullable(Bool)`	Whether accepting orders
`is_notifications_enabled`	`Nullable(Bool)`	Whether notifications enabled
`score`	`Nullable(Int64)`	Market score/ranking
`image_optimized`	`Nullable(String)`	Optimized image URL
`icon_optimized`	`Nullable(String)`	Optimized icon URL
`event`	`Nullable(String)`	Associated event
`tag`	`Nullable(String)`	Market tag
`category_meta`	`Nullable(String)`	Category metadata
`creator`	`Nullable(String)`	Creator information
`is_ready`	`Nullable(Bool)`	Whether market is ready
`is_funded`	`Nullable(Bool)`	Whether market is funded
`past_slugs`	`Nullable(String)`	Previous URL slugs
`ready_timestamp`	`Nullable(DateTime64(3))`	Ready status timestamp
`funded_timestamp`	`Nullable(DateTime64(3))`	Funded status timestamp
`accepting_orders_timestamp`	`Nullable(DateTime64(3))`	Orders acceptance timestamp
`competitive`	`Nullable(Float64)`	Competitiveness score
`rewards_min_size`	`Nullable(Float64)`	Minimum size for rewards
`rewards_max_spread`	`Nullable(Float64)`	Maximum spread for rewards
`spread`	`Nullable(Float64)`	Current bid-ask spread
`is_automatically_resolved`	`Nullable(Bool)`	Whether auto-resolved
`one_day_price_change`	`Nullable(Float64)`	24-hour price change
`one_hour_price_change`	`Nullable(Float64)`	1-hour price change
`one_week_price_change`	`Nullable(Float64)`	7-day price change
`one_month_price_change`	`Nullable(Float64)`	30-day price change
`one_year_price_change`	`Nullable(Float64)`	1-year price change
`last_trade_price`	`Nullable(Float64)`	Last trade price
`best_bid`	`Nullable(Float64)`	Best bid price
`best_ask`	`Nullable(Float64)`	Best ask price
`is_automatically_active`	`Nullable(Bool)`	Whether auto-activated
`is_clear_book_on_start`	`Nullable(Bool)`	Whether to clear order book on start
`chart_color`	`Nullable(String)`	Chart display color
`series_color`	`Nullable(String)`	Series display color
`is_showing_gmp_series`	`Nullable(Bool)`	Whether showing GMP series
`is_showing_gmp_outcome`	`Nullable(Bool)`	Whether showing GMP outcome
`is_manual_activation`	`Nullable(Bool)`	Whether manual activation required
`is_neg_risk_other`	`Nullable(Bool)`	Negative risk flag
`game_id`	`Nullable(String)`	Game identifier
`group_item_range`	`Nullable(String)`	Range for group item
`sports_market_type`	`Nullable(String)`	Sports market type
`line`	`Nullable(Float64)`	Betting line
`uma_resolution_statuses`	`Nullable(String)`	UMA resolution statuses
`is_pending_deployment`	`Nullable(Bool)`	Whether pending deployment
`is_deploying`	`Nullable(Bool)`	Whether currently deploying
`deploying_timestamp`	`Nullable(DateTime64(3))`	Deployment timestamp
`scheduled_deployment_timestamp`	`Nullable(DateTime64(3))`	Scheduled deployment time
`is_rfq_enabled`	`Nullable(Bool)`	Whether RFQ enabled
`event_start_time`	`Nullable(DateTime64(3))`	Event start datetime
`image`	`Nullable(String)`	Market image URL
`icon`	`Nullable(String)`	Market icon URL
`raw_json`	`String`	Raw JSON response from API
`inserted_at`	`DateTime`	Record insertion timestamp

Example Query:

ClickHouse (polymarket)