数据文档

duckdb forever-beta.duckdb
SHOW TABLES;
SELECT * FROM dataset_meta ORDER BY key;

SELECT quote_type, price_basis, count(*) AS rows
FROM listings
GROUP BY 1, 2
ORDER BY rows DESC;

SELECT dt,
       median(unit_price) FILTER (WHERE quote_type = 'listing') AS median_copper,
       count(*) FILTER (WHERE quote_type = 'listing') AS listings,
       sum(quantity) AS units
FROM listings
WHERE realm = 'CAMWOWCN1Realm1PvE Horde'
  AND item_name = '魔纹布'
GROUP BY dt
ORDER BY dt;

SELECT i.item_name, d.dt,
       d.unit_price_median, d.listing_cnt
FROM daily_prices d
JOIN items i USING (item_id)
WHERE i.item_name = '魔纹布'
  AND d.quote_type = 'listing'
ORDER BY d.dt DESC
LIMIT 14;