一条 SQL,一份报告
这就是全部接口:对一张长表做一次聚合调用,不用写分组、也不需要 Python。右边是它给 GOOGL 出的报告(基准是标普 500)—— 真实输出,直接嵌在 iframe 里。
duckdb
-- once per session: INSTALL duckfn_quantstats FROM community; LOAD duckfn_quantstats;
WITH prices AS (
SELECT *
FROM read_csv('https://shijianjs.github.io/duckfn-quantstats/demo/prices.csv')
)
SELECT (r).symbol, (r).benchmark, length((r).html) AS html_bytes
FROM (
SELECT unnest(qs_html_reports_by_prices(
symbol, date, price,
{'benchmark': ['SPX'],
'benchmark_title': ['S&P 500'],
'title': symbol,
'strategy_title': symbol}::qs_html_report_options)) AS r
FROM prices
);