Pricing

Rating

Developer

Actor stats

Categories

Share

👁 ParseForge Banner

📊 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.

📋 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

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.

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

🚀 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

💡 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.