Align stock and crypto returns in Python: use the same closing time
Compare stock and crypto close-to-close returns on one session calendar. A tested pandas example handles DST, early closes and missing observations.
The SiftingIO Blog
SubscribeBlog
Engineering deep-dives, market analysis, and product updates from the SiftingIO team. How we build real-time market data infrastructure across crypto, FX, and equities.
Latest posts
API key 401 Unauthorized: fix headers, keys and access errors
Diagnose SiftingIO API key errors with a 401/403 comparison table, curl checks and a Python test that keeps credentials out of logs.
Home Assistant stock price sensor: REST and YAML setup
Build a Home Assistant stock price sensor with YAML, market-hours polling and freshness labels. Includes a request budget for a three-stock watchlist.
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.
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.
Wallet portfolio API: handle spam, dust and unpriced tokens honestly
Build a clearer wallet balance screen with separate buckets for priced, dust, unpriced and unrecognised tokens, using a tested decimal-based classifier.
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.