Coverage
Data available for CL
Crude oil is a monthly contract, so rolls come twelve times a year. The continuous contracts card is the one most CL backtests need.
| Data | What it is | Granularity | Delivery | Plan | Details |
|---|---|---|---|---|---|
| OHLCV bars, intraday and daily | Per-contract bars with settlement and open interest on daily rows | 1 second to 1 day | API and CSV/Parquet file | Front-month daily on Free; 1-minute from Starter | Product page |
| Continuous and back-adjusted contracts | One long series per root, raw, back-adjusted or ratio-adjusted | 1 minute to 1 day | API and file | Daily on Starter; intraday on Pro | Product page |
| Trades and L1 quotes | Every trade with aggressor side and every best bid/offer change | Each event, nanoseconds where the venue sends them | API and file | 30 days of trades on Pro; full history and L1 on Business | Product page |
| Settlement, open interest, limits | The official daily numbers the exchange publishes per contract | 1 day | API and file | Prior-day front months on Free; full history on Starter | Product page |
| CFTC Commitments of Traders | Weekly long and short positions by trader category | Weekly (Tuesday data, Friday release) | API and free bulk file | Raw reports on Free; derived fields on Starter | Product page |
Sample data
Sample data preview
Oil and Natural Gas Spot Prices
We don't have a free CL futures file yet. The closest free data is the daily WTI spot price at Cushing, Oklahoma, the CL delivery point. Here are its first 10 rows.
symbol |
name |
date |
price |
unit |
source_series |
|---|---|---|---|---|---|
| WTI | WTI crude oil, Cushing OK | 2026-05-29 | 91.16 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-01 | 95.96 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-02 | 97.47 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-03 | 99.76 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-04 | 96.83 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-05 | 94.32 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-08 | 95 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-09 | 91.9 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-10 | 93.68 | USD/barrel | DCOILWTICO |
| WTI | WTI crude oil, Cushing OK | 2026-06-11 | 91.58 | USD/barrel | DCOILWTICO |
Source: U.S. Energy Information Administration via FRED
Spot and front-month futures track each other closely but not exactly, especially near expiry. Use this file to check your loaders and date handling; request a futures sample for real CL bars.
Schema
Schema
CL futures bars follow the schema below. Every row names its contract in symbol (for example CLF7) and its root in root, so you can stack many months in one table.
| Field | Type | Description |
|---|---|---|
symbol |
string | Contract in our format, e.g. ESZ6 |
root |
string | Product root, e.g. ES |
exchange |
string | Venue MIC or short code, e.g. CME |
interval |
string | 1s, 1m, 5m, 1h, 1d |
timestamp |
string | Bar start, ISO 8601 UTC (intraday) |
date |
string | Trading session date, YYYY-MM-DD (daily) |
session_date |
string | Trading day the bar belongs to; the Globex session opens the evening before (intraday) |
open |
number | First trade price |
high |
number | Highest trade price |
low |
number | Lowest trade price |
close |
number | Last trade price in the bar |
volume |
number | Contracts traded |
trade_count |
number | Number of trades (optional) |
vwap |
number | Volume-weighted average price (optional) |
settlement_price |
number | Official exchange settlement (daily, optional) |
open_interest |
number | Open contracts reported for the session (daily, optional) |
buy_aggressor_volume |
number | Volume where the buyer crossed the spread (optional) |
sell_aggressor_volume |
number | Volume where the seller crossed the spread (optional) |
API
Get it by API
An early access example for one Globex session of CL minute bars. We use January 2027 (CLF7), because the December contract expires around the third week of November.
curl (example)
curl -G "https://api.marketdata.co/v1/futures/bars" \
-H "Authorization: Bearer $MARKETDATA_API_KEY" \
--data-urlencode "symbol=CLF7" \
--data-urlencode "interval=1m" \
--data-urlencode "start=2026-11-17T23:00:00Z" \
--data-urlencode "end=2026-11-18T22:00:00Z"
Python (example)
import os
import requests
import pandas as pd
resp = requests.get( # CL minute bars, Wednesday inventory report
"https://api.marketdata.co/v1/futures/bars",
headers={"Authorization": f"Bearer {os.environ['MARKETDATA_API_KEY']}"},
params={"symbol": "CLF7", "interval": "1m",
"start": "2026-11-17T23:00:00Z", "end": "2026-11-18T22:00:00Z"},
timeout=30,
)
resp.raise_for_status()
bars = pd.DataFrame(resp.json()["results"])
bars["timestamp"] = pd.to_datetime(bars["timestamp"], utc=True)
eia = bars[(bars["timestamp"].dt.hour == 15) & (bars["timestamp"].dt.minute.between(25, 45))]
print(eia[["timestamp", "close", "volume"]])
The EIA weekly petroleum report comes out at 10:30 New York time on Wednesdays, 15:30 UTC in winter, and the Python tab pulls the minutes around it.
Datasets
Get it as a file
CL files are priced per root, with every monthly contract included:
- Formats: CSV and Parquet
- 1-minute bars: $12 per root per year, all expiries included
- Full daily history: $39 per root
- Continuous contracts: $29 per root, all three adjustments and the roll calendar
- Trades: $49 per root per year ($99 with L1 quotes)
- COT positioning: free bulk download
Because CL has twelve contracts a year, the per-root price is good value here. One year of minute bars covers all of them for $12.
Use cases
About WTI Crude Oil Futures (for traders)
CL is NYMEX light sweet crude oil, the main US oil benchmark. One contract is 1,000 barrels of West Texas Intermediate, delivered physically at Cushing, Oklahoma. A new contract lists for every calendar month.
Oil moves on supply and demand news: OPEC+ production decisions, US inventory data every Wednesday, refinery outages, sanctions, and anything that hints at global growth. Geopolitical events in producing regions cause the sharpest gaps.
Trading runs on Globex from Sunday 17:00 to Friday 16:00 Chicago time, with a one-hour daily break. Settlement is set at 14:30 New York time, and the last trading day falls around the 20th of the month before delivery.
One date breaks naive backtests. On 20 April 2020 the May 2020 contract settled at minus $37.63 a barrel, as holders with no storage paid to get out before delivery. Ratio-adjusted continuous series can't handle negative prices, so use back-adjusted or raw contract data for anything that spans that day.
Pricing
Pricing
CL sits in the futures plans like any other root:
| Free $0 | Starter $29/mo | Pro $79/mo | Business $249/mo | |
|---|---|---|---|---|
| Daily bars | Front month, 1 year | Full history | Full history | Full history |
| Intraday bars | No | 1-minute, 10-minute delay, 5 years | 1-second to daily, delayed | Real-time WebSocket bars |
| Continuous contracts | No | Daily, all three adjustments | Adds intraday and custom roll rule | As Pro |
| Settlement and OI | Prior day, front months | Full history | Adds preliminary settlements and limits | As Pro |
| Trades and L1 quotes | No | No | Last 30 days of trades, delayed | Full history, L1 quotes, real time |
| COT positioning | All raw reports | Adds net positions and percentiles | As Starter | As Starter |
Full plan details are on the pricing page.
FAQ
Frequently asked questions
Does your CL data include the negative price in April 2020?
Yes, contract-level bars keep the raw prices, including the minus $37.63 settlement on 20 April 2020. Ratio-adjusted continuous series can't represent it, so use back-adjusted or raw data for that period.
When does CL roll?
Each monthly contract stops trading around the 20th of the month before delivery, and volume usually moves to the next month a few days before that. Our continuous series lets you choose a volume, open interest or fixed-day roll.
Is there a free CL sample?
There's a free daily WTI spot price file from the EIA. A futures sample is available on request.
Where does CL COT data come from?
Crude oil is in the CFTC's disaggregated report, which splits holders into producers, swap dealers and managed money. It's included in our free COT data.
Can I get CL data in Excel?
Yes, as CSV. Intraday files for many contracts are easier to handle as Parquet.
Keep reading
Related
- All futures data
- Futures historical data
- Continuous futures data
- Futures tick data
- Other symbols: ES, NQ, YM, RTY, GC, SI
- Learn: Continuous futures and roll adjustment methods