---

name: tushare-duckdb description: Query Chinese stock data from local DuckDB cache. Use when user wants local data access instead of direct Tushare API calls.

tushare-duckdb

Local DuckDB cache layer for Tushare Pro data. For API parameter details, use /tushare-finance <api_name>.

Quick Start

Read Data (no network, concurrent-safe)

Copyfrom tushare_db import DataReader

reader = DataReader(db_path="tushare.db")

# Single stock with forward adjustment
df = reader.get_stock_daily('000001.SZ', '20240101', adj='qfq')

# Multiple stocks
df = reader.get_multiple_stocks_daily(['000001.SZ', '600519.SH'], '20240101')

# Trade calendar
df = reader.get_trade_calendar('20240101', '20241231')

# Stock list
df = reader.get_stock_basic(list_status='L')

# Custom SQL
df = reader.query("SELECT * FROM daily WHERE ts_code = ?", ['000001.SZ'])

reader.close()

Download Data (requires TUSHARE_TOKEN env var)

Copyfrom tushare_db import DataDownloader

downloader = DataDownloader(db_path="tushare.db", rate_limit_profile="standard")

# Basic data
downloader.download_trade_calendar()
downloader.download_stock_basic()

# Daily data for all stocks
downloader.download_all_stocks_daily(start_date='20200101')

# Daily update (single date)
downloader.download_daily_data_by_date('20241218')

downloader.close()

Key Notes

• Date format: YYYYMMDD string (e.g., '20240101')
• Adjustment types:
  • adj_factor table stores raw Tushare adjustment factors
  • qfq (forward): price * (factor / latest_factor) — latest price = market price
  • hfq (backward): price * factor — historical prices stay fixed
  • DataReader handles calculation automatically via adj='qfq' or adj='hfq'
• Rate limit profiles: 'trial', 'standard', 'pro'

Implemented Tables

For column details and parameter meanings, invoke /tushare-finance <api_name>.