Free Stock Data CSV
Sources, Fields & Downloads免费股票数据 CSV
来源、字段与下载方法
Find free stock data, export analysis-ready CSV files, and avoid common problems with symbols, dates, adjustments, and licenses.
查找免费股票数据并导出可直接分析的 CSV，
同时避开股票代码、日期、复权与许可陷阱。
Free stock data CSV: quick summary免费股票数据 CSV：核心摘要
CSV is ideal for spreadsheets, notebooks, backtests, database imports, and one-off research without SDK setup.
Most files include date, open, high, low, close, adjusted close, and volume, with one row per interval.
Free does not mean unrestricted: confirm redistribution rights, delays, symbol coverage, and request limits.
Validate timezone, trading calendar, duplicates, missing rows, splits, dividends, and adjustment policy.
CSV 适合电子表格、Notebook、回测、数据库导入，以及无需配置 SDK 的一次性研究。
文件通常包含日期、开盘、最高、最低、收盘、复权收盘价和成交量，每个周期一行。
免费不代表无限制：需要确认再分发权、延迟、股票覆盖范围和请求限额。
核对时区、交易日历、重复行、缺失行、拆股、分红与复权方法。
Stock CSV fields you should understand需要理解的股票 CSV 字段
A useful stock CSV has a stable schema, explicit interval, unambiguous timezone, and documented adjustment rules. Do not assume two providers define close or volume in exactly the same way.
可用的股票 CSV 应具备稳定结构、明确周期、清晰时区和有文档说明的复权规则。不要默认不同供应商对收盘价或成交量的定义完全一致。
Confirm whether rows use exchange time or UTC and whether the period is daily, minute, or tick data.
OHLC values describe the price range for each interval. Check whether prices are raw or adjusted.
Adjusted close may account for splits and dividends, but methodologies vary. It is useful for return calculations only when documented.
A ticker alone is not a permanent identifier. Preserve exchange and currency, and keep a stable instrument ID when the source provides one.
Check whether volume represents shares, contracts, or estimated activity. Empty cells, zero, NA, and null must not be treated as equivalent without a rule.
Detect comma versus semicolon delimiters, decimal points versus commas, quoted line breaks, byte-order marks, and UTF-8 before importing at scale.
确认数据使用交易所本地时间还是 UTC，并明确周期是日线、分钟线还是逐笔数据。
OHLC 描述每个周期内的价格范围，还要确认价格是原始值还是复权值。
复权价可能处理拆股和分红，但不同供应商方法不一；只有规则清晰时才适合计算收益率。
股票代码本身不是永久标识。应同时保留交易所和币种；来源提供稳定标的 ID 时，也要一并保存。
确认成交量表示股数、合约数还是估算活跃度。空单元格、0、NA 和 null 含义不同，不能在没有规则时混为一谈。
批量导入前，应识别逗号或分号分隔、小数点或小数逗号、带引号的换行、字节顺序标记以及 UTF-8 编码。
Where to find free stock data CSV downloads在哪里查找免费的股票数据 CSV
| Source type来源类型 | Best for适合场景 | Strength优势 | Check first优先核对 |
|---|---|---|---|
| Direct CSV download直接 CSV 下载 | Fast manual research.快速手动研究。 | No code or API key.无需代码或 API Key。 | Freshness and license.更新频率与许可。 |
| Market data API市场数据 API | Repeatable exports.可重复导出。 | Symbols and dates are programmable.可编程控制代码与日期。 | Rate limits and pagination.限流与分页。 |
| Exchange or regulator交易所或监管机构 | Authoritative reference data.权威参考数据。 | Clear provenance.数据来源清晰。 | Format and market scope.格式与市场范围。 |
| Research dataset研究数据集 | Education and reproducibility.教学与复现实验。 | Often ready for notebooks.通常可直接用于 Notebook。 | Update date and survivorship bias.更新时间与幸存者偏差。 |
For repeatable work, prefer a source that lets you request a fixed symbol, interval, and date range rather than exporting whatever a web screen currently displays. Save the request parameters next to the file, and record whether the export is a full snapshot or an incremental slice.
需要重复运行时，优先选择能固定股票代码、周期和日期范围的来源，不要只导出网页当时显示的内容。请求参数应与文件一同保存，并明确这次导出是完整快照还是增量片段。
A reliable CSV download workflow可靠的 CSV 下载流程
Write down market, symbols, date range, interval, currency, timezone, and whether prices must be adjusted.
Verify personal, commercial, and redistribution rights before building the data into a product or publishing a derived file.
Use UTF-8, ISO 8601 dates, stable column names, explicit null values, and one consistent sort order.
Test row counts, duplicates, missing sessions, split events, and extreme returns; retain the source URL and retrieval time.
Use symbol, interval, and timestamp as a candidate key, replace overlapping recent periods, and keep the latest retrieval as the winner only after validation.
Providers can revise historical bars. Keep immutable raw files or checksums so you can identify what changed instead of silently rewriting research inputs.
先写清市场、股票代码、日期范围、周期、币种、时区，以及是否需要复权价格。
在用于产品或发布衍生文件前，确认个人使用、商业使用和再分发权限。
使用 UTF-8、ISO 8601 日期、稳定列名、明确空值和一致的排序方式。
检查行数、重复值、缺失交易日、拆股事件和异常收益，并记录来源 URL 与采集时间。
可用“股票代码、周期、时间戳”作为候选主键，重新拉取并覆盖近期重叠区间；只有通过校验后，才采用最新采集版本。
供应商可能修正历史 K 线。保存不可变的原始文件或校验值，才能看清具体变化，而不是悄悄改写研究输入。
Use QVeris to find stock data capabilities使用 QVeris 查找股票数据能力
There is no single verified QVeris result for every CSV export workflow. When static files stop being enough, use the QVeris documentation to understand execution and the Playground to inspect repeatable data capabilities.
目前没有一个经过核实的 QVeris 结果，可以覆盖所有 CSV 导出流程。当静态文件已经不够用时，可先通过 QVeris 文档了解调用方式，再到 Playground 检查可重复执行的数据能力。
- Search by capability instead of guessing provider names.
- Inspect field schemas and provider constraints before integrating an endpoint.
- Move from manual CSV research to repeatable API calls when the workflow becomes recurring.
- 按能力搜索，而不是猜测供应商名称。
- 接入端点前先检查字段结构与供应商限制。
- 当流程需要重复运行时，从手动 CSV 研究升级为可复现的 API 调用。
FAQ常见问题
Look for direct downloads, free API tiers, exchange data, regulator datasets, or research repositories. Always verify coverage and licensing.
A practical daily file includes date, symbol, open, high, low, close, adjusted close, and volume, plus currency and exchange metadata when needed.
Keep raw OHLC plus explicit split and dividend fields when possible. Add adjusted values as separate columns and document the adjustment method.
Fetch only a recent overlap, validate it, merge on a stable key, deduplicate deterministically, and write a new version before replacing the current file.
可查找直接下载、免费 API 套餐、交易所或监管数据，以及研究数据集；使用前务必确认覆盖范围和许可。
实用的日线文件通常包含日期、代码、开盘、最高、最低、收盘、复权收盘价与成交量，并按需保留币种和交易所。
条件允许时保留原始 OHLC，并单独保存拆股、分红字段；复权值作为独立列，同时写明计算方法。
只拉取近期重叠区间，校验后按稳定主键合并，以确定性规则去重，并先生成新版本，再替换当前文件。
References and next steps参考资料与下一步
Stooq data download
Alpha Vantage API documentation
Twelve Data API documentation
Free Stock Data API Guide
QVeris Playground
Stooq 数据下载
Alpha Vantage API 文档
Twelve Data API 文档
免费股票数据 API 指南
QVeris Playground