Five DuckDB recipes for market data CSV exports
Check OHLCV CSV coverage, timestamp gaps, UTC daily bars, close returns and rolling means with five DuckDB SQL recipes.
Category · Developer Tutorials
Developer Tutorials
Practical guides for using the SiftingIO API and WebSocket streams.
Latest in Developer Tutorials
Google Sheets market data template: a watchlist you can copy
Copy a Google Sheets market data template to track up to 20 stock, crypto, forex and commodity prices with a SiftingIO API key, plus troubleshooting.
Move a Pipedream price alert to n8n
Move a scheduled price alert from Pipedream to n8n. Map credentials, timing and saved state, then verify the handover with an existing AAPL workflow.
WebSocket fan-out with Redis pub/sub: one market data connection for every service
Share one market data WebSocket across services: read max_conn and max_subs from the ack, republish ticks on Redis, snapshot for late joiners. Python code.
API key rotation: a safe cutover and what to do after a leak
A practical API key rotation checklist for REST jobs and WebSocket workers. Separate planned overlap from urgent revocation after a leak.
Market data API request calculator: estimate calls before choosing a plan
Estimate market data API calls from symbols, polling intervals, shared workers and backfill. Includes worked examples and a tested Python calculator.
Parse JSON numbers as decimals in Python, Go and JavaScript
Preserve market data decimals from JSON to your database with tested Python, Go and JavaScript examples, plus a precision regression test.
Excel Power Query: forex, gold and stock prices from an API
Pull forex, gold and stock quotes into Excel with Power Query. Keep timestamps and fallback prices visible, protect your API key, and budget refresh calls.
Market data API rate limits: handle HTTP 429 without a retry storm
Tell a burst 429 (rate_limit_exceeded) from a spent monthly quota (monthly_quota_exceeded), retry safely with jitter, and cut the polling that causes it.