📊 SGX Derivatives EOD Scraper

🚀 Export SGX derivatives EOD data in seconds. Structured records direct from the public api2.sgx.com endpoint to CSV, Excel, JSON, or XML.

🕒 Last updated: 2026-05-29 · 📊 12 fields per record · Public REST API · SGX derivatives EOD

The SGX Derivatives EOD Scraper turns the api2.sgx.com public REST endpoint into a clean, structured dataset. It calls the endpoint with the parameters you supply, parses the JSON, and flattens each record into one row.

Dataset coverage depends on the upstream source. All field names are clean snake_case / camelCase, numeric strings are auto-cast to numbers, and upstream rate-limit notes are surfaced as a clean error record instead of crashing your pipeline.

🎯 Target Audience	💡 Primary Use Cases
📊 Analysts	Pull structured records for analysis
🏢 Finance teams	Snapshot data for dashboards and reports
🤖 ML engineers	Build training sets from public sources
📰 Journalists	Verify numbers for stories with one click
👩‍💻 Developers	Mirror upstream data into your own DB without writing client code
🎓 Researchers	Run reproducible studies on public data

📋 What the SGX Derivatives EOD Scraper does

• Calls the public api2.sgx.com endpoint.
• Parses the JSON response and flattens each record into a clean row.
• Casts numeric fields to numbers so they import cleanly into Excel and BI tools.
• Surfaces upstream rate-limit or error notes as a single-row error record instead of crashing.
• Exports as CSV, Excel, JSON, JSONL, XML, RSS, or HTML.

💡 Why it matters: The raw SGX derivatives EOD JSON is verbose and hard to consume in spreadsheets. This actor normalizes the payload into one row per record so the data drops straight into pandas, BigQuery, or a Google Sheet.

🎬 Full Demo

🚧 Coming soon.

⚙️ Input

Field	Type	Required	Description
tradeDate	string	No	YYYYMMDD.
contract	string	No	Contract code filter.
maxItems	integer	No	Free users: 10. Paid users: up to 1,000,000. Prefill: 10.

Example 1:

{
  "maxItems": 100
}

Example 2:

{
  "tradeDate": "20260528",
  "contract": "CN",
  "maxItems": 200
}

⚠️ Good to Know: The SGX derivatives EOD API is rate-limited. This actor surfaces rate-limit notes as a clean error record so your downstream pipeline can decide how to retry.

📊 Output

Each record is a flat object. error is always last.

Field	Type	Description
📄 contract	string	Contract code.
⏳ expiry	string	Expiry month.
📅 tradeDate	string	EOD date.
🔓 open	number	Open price.
⬆️ high	number	High.
⬇️ low	number	Low.
🔒 close	number	Close.
⚖️ settle	number	Settlement price.
📊 volume	number	Volume traded.
🔓 openInterest	number	Open interest.
🕒 scrapedAt	string	Fetch timestamp.
❌ error	string	Set on upstream error.

Sample record:

{
  "contract": "CN",
  "expiry": "Jun26",
  "tradeDate": "20260528",
  "open": 4520,
  "high": 4548,
  "low": 4505,
  "close": 4530,
  "settle": 4532,
  "volume": 145238,
  "openInterest": 423500,
  "scrapedAt": "2026-05-29T12:00:00.000Z",
  "error": null
}

✨ Why choose this Actor

| 🆓 | Works with the free, public SGX derivatives EOD endpoint. | | 🧹 | Clean snake_case keys ready for BI. | | 🔢 | Auto-casts numeric strings to real numbers. | | 🛟 | Surfaces rate-limit notes as a clean error record. | | 🔌 | Drop-in dataset replacement for the raw API. | | 💾 | Push to dataset → instant CSV / Excel / JSON / XML / RSS / HTML export. |

📈 How it compares to alternatives

Approach	Setup time	Clean keys?	Numeric casting?	Rate-limit handling?
Roll your own fetch	30 min +	❌	❌	❌
Generic API client	1 hr install + script	partial	partial	partial
This Actor	5 sec, no install	✅	✅	✅

🚀 How to use

1. Click Try for free.
2. Adjust input fields (or leave defaults).
3. Click Start. Within seconds, your dataset is ready — download as CSV, Excel, JSON, or XML, or pipe to your warehouse.

💼 Business use cases

📊 Analytics & dashboards. Pull SGX derivatives EOD data into a single CSV, feed BI tools, share with stakeholders.

🤖 ML feature engineering. Build clean training sets from SGX derivatives EOD for downstream models.

📰 Newsroom fact-checking. Verify numbers for stories in 30 seconds.

🏢 Treasury / ops. Schedule daily runs and pipe to your dashboard.

🔌 Automating SGX Derivatives EOD Scraper

• Make / Zapier: trigger this actor on a schedule, push results to Airtable, Google Sheets, or Slack.
• Cron schedule: native Apify scheduler.
• Webhooks: POST to your endpoint the moment a run finishes.
• Pipe to BigQuery / Snowflake / Postgres: native Apify integrations.

🌟 Beyond business use cases

🎓 Education. Teach a class with real SGX derivatives EOD data instead of toy datasets.

🧪 Personal research. Track SGX derivatives EOD signals on your own schedule.

🤝 Non-profit & open data. Build public dashboards without writing client code.

🧰 Tinkering & prototyping. Spin up a feed in 5 seconds to test a new idea.

🤖 Ask an AI assistant about this scraper

Pop this README into ChatGPT, Claude, or any AI assistant and ask it to map your specific workflow to the actor's inputs.

❓ Frequently Asked Questions

❓ Do I need an API key? No. SGX historical EOD is public.

❓ What contracts are returned? All listed SGX derivatives for the trading day.

❓ Can I filter by contract? Yes. Use the contract input (e.g. CN for FTSE China A50).

❓ How fresh is the data? EOD — published after the market close.

❓ Why is some data missing? SGX omits fields for illiquid contracts; we leave those as null.

❓ What format can I download? CSV, Excel, JSON, JSONL, XML, RSS, or HTML.

🔌 Integrate with any app

Apify ships native integrations with Make, Zapier, Slack, Discord, Google Drive, Google Sheets, Gmail, Airbyte, Keboola, Telegram, GitHub, and any REST API or webhook endpoint.

🔗 Recommended Actors

Actor	What it does
ParseForge Alpha Vantage Scraper	Stocks, FX, crypto, indicators.
ParseForge Yahoo Finance Scraper	Equities, funds, indices.
ParseForge OurAirports Scraper	Global airport database.
ParseForge NBA Stats Scraper	Player and team stats from NBA.com.

💡 Pro Tip: browse the complete ParseForge collection for 900+ production-grade scrapers.

---

Disclaimer: This actor scrapes only publicly available data. ParseForge is not affiliated with, endorsed by, or sponsored by any of the third-party services referenced. Users are responsible for complying with the target site's terms of service and applicable law. Create a free account w/ $5 credit.