PREVIEW / etf_1hour / 2025-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-12-18.parquet
  size:    717 KB
  rows:    27,909

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-18 04:00:00	SPY	ETF	673.05	674.35	673.05	674.33	70249.0
2025-12-18 05:00:00	SPY	ETF	674.38	674.5	673.95	674.19	55676.0
2025-12-18 06:00:00	SPY	ETF	674.24	674.86	674.09	674.79	126857.0
2025-12-18 07:00:00	SPY	ETF	674.71	674.89	674.04	674.17	263244.0
2025-12-18 08:00:00	SPY	ETF	674.66	677.49	671.89	676.55	1380132.0
2025-12-18 09:00:00	SPY	ETF	676.51	678.59	675.69	678.06	11055536.0
2025-12-18 10:00:00	SPY	ETF	678.06	680.6	676.14	680.03	13306246.0
2025-12-18 11:00:00	SPY	ETF	680.03	680.74	679.325	679.56	7570552.0
2025-12-18 12:00:00	SPY	ETF	679.55	679.5707	674.9	678.37	14963448.0
2025-12-18 13:00:00	SPY	ETF	678.36	679.7	677.58	678.275	6881223.0
2025-12-18 14:00:00	SPY	ETF	678.23	678.31	675.32	675.72	10815054.0
2025-12-18 15:00:00	SPY	ETF	675.71	678.55	675.45	676.48	19181374.0
2025-12-18 16:00:00	SPY	ETF	676.48	676.6025	675.6	675.93	2723253.0
2025-12-18 17:00:00	SPY	ETF	675.95	676.21	675.71	676.21	143315.0
2025-12-18 18:00:00	SPY	ETF	676.17	676.59	675.61	676.59	151189.0
2025-12-18 19:00:00	SPY	ETF	676.65	676.68	675.96	676.43	31884.0
2025-12-18 04:00:00	QQQ	ETF	603.98	605.53	603.0	605.5	158580.0
2025-12-18 05:00:00	QQQ	ETF	605.5	605.56	604.8	605.09	79101.0
2025-12-18 06:00:00	QQQ	ETF	605.12	606.0	604.99	605.67	120603.0
2025-12-18 07:00:00	QQQ	ETF	605.66	605.91	605.25	605.44	168490.0
2025-12-18 08:00:00	QQQ	ETF	605.45	609.46	602.11	608.43	1522279.0
2025-12-18 09:00:00	QQQ	ETF	608.51	610.95	606.92	609.68	11658670.0
2025-12-18 10:00:00	QQQ	ETF	609.68	612.82	607.24	611.81	11590847.0
2025-12-18 11:00:00	QQQ	ETF	611.81	612.93	611.315	612.31	6980207.0
2025-12-18 12:00:00	QQQ	ETF	612.31	612.31	607.51	611.5599	10061646.0
2025-12-18 13:00:00	QQQ	ETF	611.56	612.7	610.67	611.215	4472834.0
2025-12-18 14:00:00	QQQ	ETF	611.21	611.24	607.75	608.09	5978064.0
2025-12-18 15:00:00	QQQ	ETF	608.09	611.28	607.72	609.15	8434260.0
2025-12-18 16:00:00	QQQ	ETF	609.15	609.22	607.82	608.29	2251696.0
2025-12-18 17:00:00	QQQ	ETF	608.29	609.12	608.27	609.11	109344.0
2025-12-18 18:00:00	QQQ	ETF	608.99	609.2339	608.16	609.23	142312.0
2025-12-18 19:00:00	QQQ	ETF	609.24	609.48	608.48	608.98	106663.0
2025-12-18 04:00:00	IWM	ETF	247.95	248.25	247.8	248.25	38771.0
2025-12-18 05:00:00	IWM	ETF	248.26	248.27	247.86	247.91	13170.0
2025-12-18 06:00:00	IWM	ETF	247.91	248.34	247.88	248.34	39411.0
2025-12-18 07:00:00	IWM	ETF	248.3	248.35	247.84	247.93	23177.0
2025-12-18 08:00:00	IWM	ETF	247.98	250.78	247.58	249.82	1151830.0
2025-12-18 09:00:00	IWM	ETF	249.82	251.355	249.11	250.45	4255376.0
2025-12-18 10:00:00	IWM	ETF	250.44	251.25	249.19	250.37	3735854.0
2025-12-18 11:00:00	IWM	ETF	250.38	250.73	249.87	249.94	2604772.0
2025-12-18 12:00:00	IWM	ETF	249.94	250.09	248.27	249.4	3283872.0
2025-12-18 13:00:00	IWM	ETF	249.4	250.14	249.12	249.55	2283442.0
2025-12-18 14:00:00	IWM	ETF	249.54	249.65	248.21	248.36	2896058.0
2025-12-18 15:00:00	IWM	ETF	248.355	249.68	248.305	248.71	5780647.0
2025-12-18 16:00:00	IWM	ETF	248.72	248.77	248.34	248.36	825346.0
2025-12-18 17:00:00	IWM	ETF	248.52	248.62	248.41	248.61	29201.0
2025-12-18 18:00:00	IWM	ETF	248.57	248.64	248.25	248.64	26542.0
2025-12-18 19:00:00	IWM	ETF	248.65	248.65	248.34	248.51	19012.0
2025-12-18 04:00:00	DIA	ETF	479.87	480.46	479.86	480.4	6344.0
2025-12-18 05:00:00	DIA	ETF	480.5	480.53	480.5	480.53	340.0

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

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