# 1. List what exists
curl "https://api.gammaflip.io/api/v1/history/files/tradfi/QQQ?start=2026-10-01" \
  -H "X-API-Key: gex_sk_your_key_here"

# 2. Ask for the file: the response is a 302, the link is in redirect_url
URL=$(curl -s -o /dev/null -w '%{redirect_url}' \
  -H "X-API-Key: gex_sk_your_key_here" \
  "https://api.gammaflip.io/api/v1/history/files/tradfi/QQQ/2026-10-05/strikes_total")

# 3. Download from the link, without your API key
curl -sS -o 2026-10-05_strikes_total.csv.gz "$URL"

import pandas as pd
import requests

BASE = "https://api.gammaflip.io/api/v1/history/files"
H = {"X-API-Key": "gex_sk_your_key_here"}

# Do not follow the redirect automatically: that would send the API key to storage.
r = requests.get(f"{BASE}/tradfi/QQQ/2026-10-05/strikes_total",
                 headers=H, allow_redirects=False)
if r.status_code != 302:
    raise RuntimeError(r.json())
url = r.headers["Location"]

# The link has a query string, so pandas cannot infer the compression: say it.
df = pd.read_csv(url, compression="gzip")
print(df[["timestamp_utc", "strike", "strike_call_gex", "strike_put_gex"]].head())

import pandas as pd
import requests

BASE = "https://api.gammaflip.io/api/v1/history/files/tradfi/QQQ"
H = {"X-API-Key": "gex_sk_your_key_here"}

manifest = requests.get(BASE, headers=H, params={"start": "2026-09-01"}).json()["data"]
days = sorted({m["session_date"] for m in manifest if m["file"] == "levels"})

frames = []
for day in days:
    r = requests.get(f"{BASE}/{day}/levels", headers=H, allow_redirects=False)
    if r.status_code == 429:
        break                      # out of file credits: resume after X-History-Files-Reset
    frames.append(pd.read_csv(r.headers["Location"], compression="gzip"))

levels = pd.concat(frames, ignore_index=True)
total = levels[levels["expiration"] == "TOTAL"]

{
  "data": [
    { "session_date": "2026-10-05", "file": "levels", "rows": 1240,
      "bytes": 61234, "sha256": "9f2c...e1", "schema_version": 1 },
    { "session_date": "2026-10-05", "file": "strikes_total", "rows": 2700,
      "bytes": 148112, "sha256": "41ab...07", "schema_version": 1 },
    { "session_date": "2026-10-05", "file": "strikes_by_expiry", "rows": 64000,
      "bytes": 2210044, "sha256": "c07d...3a", "schema_version": 1 }
  ],
  "meta": {
    "timestamp": "2026-10-06T10:00:00.000000+00:00",
    "exchange": "tradfi",
    "coin": "QQQ",
    "symbol": "QQQ",
    "exchange_resolved": "tradfi",
    "market": "tradfi",
    "units": "USD per 1% move of the underlying",
    "docs_url": "https://docs.gammaflip.io/data-dictionary",
    "rate_limit": { "limit": 500, "remaining": 494, "reset": "2026-10-07T00:00:00+00:00" }
  }
}

HTTP/1.1 302 Found
Location: https://...presigned-link...
Cache-Control: no-store
X-History-Files-Limit: 200
X-History-Files-Remaining: 199
X-History-Files-Reset: 2026-10-07T00:00:00+00:00

{
  "error": "history_files_limit_exceeded",
  "message": "Daily limit of 200 history files reached.",
  "rate_limit": { "limit": 200, "remaining": 0, "reset": "2026-10-07T00:00:00+00:00" }
}

{
  "error": "no_file",
  "message": "No strikes_total file for QQQ on 2026-10-04."
}