finance

Files (1)

• SKILL.md

SKILL.md (first lines)

# Financial Market Data

## Overview

Python libraries for querying financial market data are pre-installed with API keys already configured in the environment. Use them via the bash tool.

- **Polygon.io** — US equities, options, dividends, splits, ticker metadata
- **CoinGecko** — Cryptocurrency prices, market caps, historical data

---

## Polygon.io (Stocks & Options)

### Setup

```python
from polygon import RESTClient
import pandas as pd

client = RESTClient()  # API key is pre-configured via environment
```

### Aggregate Bars (OHLCV)

```python
# get_aggs returns a list directly
bars = client.get_aggs(
    ticker="AAPL",
    multiplier=1,
    timespan="day",       # "minute", "hour", "day", "week", "month"
    from_="2024-01-01",
    to="2024-12-31",
    adjusted=True,
    sort="asc",
    limit=50000,
)

# Convert to DataFrame
df = pd.DataFrame(bars)
df["timestamp"] = pd.to_datetime(df["timestamp"], unit="ms")
print(df[["timestamp", "open", "high", "low", "close", "volume"]].head())

# list_aggs is the paginated iterator version (preferred for large date ranges)
for agg in client.list_aggs("AAPL", 1, "day", "2024-01-01", "2024-12-31", limit=50000):
    print(f"{agg.timestamp}: O={agg.open} H={agg.high} L={agg.low} C={agg.close} V={agg.volume}")
```

### Ticker Details

```python
details = client.get_ticker_details("AAPL")
print(f"Name: {details.name}")
print(f"Ticker: {details.ticker}")
print(f"Market Cap: {details.market_cap}")
print(f"Description: {details.description}")
print(f"SIC Description: {details.sic_description}")

# Historical snapshot
details = client.get_ticker_details("AAPL", date="2024-01-01")
```

### Last Quote (NBBO)

```python
quote = client.get_last_quote(ticker="AAPL")
print(f"Bid: {quote.bid_price} x {quote.bid_size}")
print(f"Ask: {quote.ask_price} x {quote.ask_size}")
```

### Options Contracts

```python
# list_options_contracts returns a paginated iterator
contracts = list(client.list_options_contracts(
    underlying_ticker="AAPL",
    contract_type="call",           # "call", "put"
    expiration_date="2024-12-20",   # exact date, or use _gte/_lte
    expired=False,
    order="asc",
    sort="ticker",
    limit=100,
))

for c in contracts[:5]:
    print(f"{c.ticker}: strike={c.strike_price}, exp={c.expiration_date}, type={c.contract_type}")
```

### Stock Splits

```python
for s in client.list_splits(ticker="NVDA"):
    print(f"{s.ticker} split on {s.execution_date}: {s.split_from}:{s.split_to}")
```

### Dividends

```python
for d in client.list_dividends(ticker="MSFT"):
    print(f"{d.ticker} ex-date={d.ex_dividend_date}: ${d.cash_amount}")
```

### Polygon Quick Reference

| Task | Method | Key Parameters |
|------|--------|---------------|
| Daily/intraday bars | `get_aggs` / `list_aggs` | `ticker`, `multiplier`, `timespan`, `from_`, `to` |
| Ticker metadata | `get_ticker_details` | `ticker`, `date` (optional) |
| Last NBBO quote | `get_last_quote` | `ticker` |
| Options chain | `list_options_contracts` | `underlying_ticker`, `contract_type`, `expiration_date` |
| Stock splits | `list_splits` | `ticker` |
| Dividends | `list_dividends` | `ticker` |

---

## CoinGecko (Cryptocurrency)

### Setup

```python

From Matrixx0070/xclaw, MIT.

More from Matrixx0070/xclaw