dvcrn Congress Trades Tracker
Monitor US congressional stock trades via Quiver Quant API, store in a local SQLite database, and alert on new significant trades. Requires Python requests library and a Quiver Quant API key.
Requirements
- Python 3.10+ with
requests(pip install requests) - QUIVER_API_KEY environment variable (get a key at https://www.quiverquant.com/)
Environment Variables
| Variable | Required | Default | Description |
|---|---|---|---|
| QUIVER_API_KEY | Yes | — | Quiver Quant API token |
| CONGRESS_DB_PATH | No | data/congress_trades.db | SQLite database path |
| MIN_TRADE_AMOUNT | No | 15001 | Minimum trade amount to trigger alerts |
Set these in your shell profile, .env file, or cron environment. Never hard-code API keys in the script.
Setup
1. Install Python dependency
pip install requests
2. Set your API key
export QUIVER_API_KEY="your-api-key-here"
3. Schedule with user cron (no sudo needed)
Add your env vars to ~/.profile or a .env file sourced by your shell, then add the cron entry:
crontab -e
# Add this line (uses env vars from your profile):
* * * * * . "$HOME/.profile" && /usr/bin/python3 /path/to/scripts/scraper.py >> /path/to/logs/scraper.log 2>&1
Never inline API keys directly in crontab entries.
4. Set up OpenClaw alert pickup
Add to your HEARTBEAT.md:
## Check for congress trade alerts
- Read `congress_trades/data/pending_congress_alert.txt` — if it has content, send the alert to the user, then delete the file.
Or create an OpenClaw cron job (every 5 min) to check and forward alerts.
How It Works
- Scraper runs every minute, fetches latest 200 trades from
api.quiverquant.com - Inserts into local SQLite with unique trade_key deduplication
- First run initializes DB and reports newest trade
- Subsequent runs detect new trades, filter to buys/sells above threshold
- Writes formatted alert to
data/pending_congress_alert.txtfor OpenClaw pickup - Keeps last 50 alerts in
data/new_trades.json
Network and Data
- Only outbound connection:
api.quiverquant.com(Quiver Quant API) - Storage: local SQLite file + JSON alert files in
data/ - No external endpoints besides the Quiver API
- Restrict file permissions on data directory (
chmod 700 data/)
Alert Format
🏛️ 3 new congress trade(s) detected:
🟢 PURCHASE: Nancy Pelosi (D) [Rep]
$NVDA — $1,000,001 - $5,000,000
Trade: 2026-02-10 | Reported: 2026-02-14
🔴 SALE: Dan Crenshaw (R) [Rep]
$MSFT — $15,001 - $50,000
Trade: 2026-02-09 | Reported: 2026-02-14
Customization
- MIN_TRADE_AMOUNT: raise/lower via env var to change alert threshold
- Fetch limit: change
limit=200infetch_trades()for broader sweeps - Cron frequency: reduce to every 5 or 15 minutes if you prefer less polling