PMDataDocs
Data Schemas

Overview

PMData Parquet schemas, shared fields, and timestamp conventions.

PMData historical data is delivered as Apache Parquet files. Schema pages define the fields and row semantics of each downloaded file.

Available schemas

SchemaData typeDescriptionUse case
L2l2Incremental L2 order book and market eventsOrder book replay and liquidity analysis
TradestradesPolymarket WebSocket trade executionsPrice, volume, and trade-flow analysis
On-Chain Fillsonchain_fillsPolygon fills with maker and taker walletsWallet and on-chain flow analysis
Chainlink StreamsstreamsRaw price data received from the Chainlink WebSocket stream, not the Polymarket proxy.Reference-price and latency analysis
Chainlink TWAPstreams_twap30s, streams_twap60sTWAP 30s/60s data received from the Chainlink WebSocket stream.Resolution and benchmark analysis

Common fields

Polymarket WebSocket files in the l2 and trades schemas share these fields:

FieldTypeDescription
market_slugstringPolymarket market slug.
timestamptimestamp[us]Polymarket event timestamp.
local_timestamptimestamp[us]PMData receive timestamp.
event_typestringSource event represented by the row.

On-Chain Fills and Chainlink use source-specific fields described on their schema pages.

Timestamps

All timestamps use UTC and microsecond precision.

  • timestamp in L2 and Trades is the timestamp supplied by Polymarket.
  • local_timestamp is when the PMData collector received the WebSocket event.
  • timestamp in On-Chain Fills is the Polygon block timestamp.
  • observationsTimestamp in Chainlink is the source observation time.
  • receiveMicrosecondTimestamp is when PMData received the Chainlink report.

The difference between a source timestamp and its PMData receive timestamp represents delivery and processing latency.

File conventions

  • L2 contains several event types in one schema. Fields that do not apply to a row's event_type are null.
  • Order book prices and sizes use Parquet list columns.
  • Chainlink price values are stored as scaled integers in string columns. See the Chainlink schema.