PREVIEW / etf_1hour / 2025-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-16.parquet
  size:    712 KB
  rows:    27,747

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2025-12-16 04:00:00	SPY	ETF	677.48	679.08	677.48	678.04	60822.0
2025-12-16 05:00:00	SPY	ETF	677.91	679.88	677.86	679.49	29298.0
2025-12-16 06:00:00	SPY	ETF	679.42	680.34	679.23	680.28	11989.0
2025-12-16 07:00:00	SPY	ETF	680.33	680.91	680.14	680.48	82147.0
2025-12-16 08:00:00	SPY	ETF	680.39	682.22	676.38	679.77	1094175.0
2025-12-16 09:00:00	SPY	ETF	679.79	681.02	677.68	680.79	9811032.0
2025-12-16 10:00:00	SPY	ETF	680.82	681.08	676.44	679.0	12267927.0
2025-12-16 11:00:00	SPY	ETF	678.99	679.3218	676.61	678.28	7027583.0
2025-12-16 12:00:00	SPY	ETF	678.3	678.94	675.42	675.6	6668426.0
2025-12-16 13:00:00	SPY	ETF	675.61	678.61	674.98	677.86	9004743.0
2025-12-16 14:00:00	SPY	ETF	677.85	678.58	675.86	677.94	8965558.0
2025-12-16 15:00:00	SPY	ETF	677.94	680.56	677.63	678.86	18906000.0
2025-12-16 16:00:00	SPY	ETF	678.86	679.1114	677.83	678.05	2802774.0
2025-12-16 17:00:00	SPY	ETF	678.25	678.87	678.1	678.72	44603.0
2025-12-16 18:00:00	SPY	ETF	678.42	678.83	677.6501	677.92	91087.0
2025-12-16 19:00:00	SPY	ETF	677.8	678.1	676.88	677.69	72188.0
2025-12-16 04:00:00	QQQ	ETF	606.12	608.78	605.8	607.0	204438.0
2025-12-16 05:00:00	QQQ	ETF	606.98	609.14	606.65	608.49	87495.0
2025-12-16 06:00:00	QQQ	ETF	608.55	609.64	608.25	609.6	129085.0
2025-12-16 07:00:00	QQQ	ETF	609.65	610.36	609.37	609.77	167553.0
2025-12-16 08:00:00	QQQ	ETF	609.74	611.9	604.5	608.77	1069278.0
2025-12-16 09:00:00	QQQ	ETF	608.62	612.25	607.585	612.11	6025705.0
2025-12-16 10:00:00	QQQ	ETF	612.21	612.49	606.97	610.45	7183422.0
2025-12-16 11:00:00	QQQ	ETF	610.44	610.945	607.85	610.76	4970968.0
2025-12-16 12:00:00	QQQ	ETF	610.76	611.2	607.37	607.569	4636902.0
2025-12-16 13:00:00	QQQ	ETF	607.53	611.13	606.9101	610.3	5120869.0
2025-12-16 14:00:00	QQQ	ETF	610.28	611.21	608.17	610.47	4452956.0
2025-12-16 15:00:00	QQQ	ETF	610.46	613.51	610.26	611.8	7269351.0
2025-12-16 16:00:00	QQQ	ETF	611.8	612.0894	610.3	610.6	1931306.0
2025-12-16 17:00:00	QQQ	ETF	610.5169	611.75	610.5	610.9	62320.0
2025-12-16 18:00:00	QQQ	ETF	610.88	611.48	610.0	610.54	175925.0
2025-12-16 19:00:00	QQQ	ETF	610.35	610.6796	609.29	610.19	143802.0
2025-12-16 04:00:00	IWM	ETF	250.24	250.42	249.95	250.03	20185.0
2025-12-16 05:00:00	IWM	ETF	249.96	250.52	249.96	250.33	10889.0
2025-12-16 06:00:00	IWM	ETF	250.3	250.75	250.24	250.75	13196.0
2025-12-16 07:00:00	IWM	ETF	250.77	250.98	250.73	250.83	33647.0
2025-12-16 08:00:00	IWM	ETF	250.9	252.4	249.72	250.9	478137.0
2025-12-16 09:00:00	IWM	ETF	250.89	252.16	250.21	251.2299	3540524.0
2025-12-16 10:00:00	IWM	ETF	251.24	251.64	249.7	250.725	3070474.0
2025-12-16 11:00:00	IWM	ETF	250.72	250.76	249.27	249.81	2260082.0
2025-12-16 12:00:00	IWM	ETF	249.82	250.08	248.74	248.85	1914407.0
2025-12-16 13:00:00	IWM	ETF	248.84	250.19	248.47	249.51	2450995.0
2025-12-16 14:00:00	IWM	ETF	249.495	249.78	248.51	249.36	2321931.0
2025-12-16 15:00:00	IWM	ETF	249.35	250.645	249.285	249.885	5549825.0
2025-12-16 16:00:00	IWM	ETF	249.88	250.18	249.4	249.41	1892563.0
2025-12-16 17:00:00	IWM	ETF	249.35	249.8651	249.35	249.73	22270.0
2025-12-16 18:00:00	IWM	ETF	249.73	249.73	249.37	249.41	27191.0
2025-12-16 19:00:00	IWM	ETF	249.28	249.4	248.93	249.27	56389.0
2025-12-16 04:00:00	DIA	ETF	484.33	484.37	483.66	483.66	3346.0
2025-12-16 05:00:00	DIA	ETF	483.97	484.7	483.97	484.7	2733.0

> showing 50 of 27,747 rows — these rows as CSV

> unlock the full archive -- $79 one-time