PREVIEW / etf_1hour / 2025-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-25.parquet
  size:    717 KB
  rows:    27,854

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-11-25 04:00:00	SPY	ETF	667.9	668.53	667.2	667.77	31870.0
2025-11-25 05:00:00	SPY	ETF	667.69	668.49	667.42	668.29	24908.0
2025-11-25 06:00:00	SPY	ETF	668.28	668.41	667.67	668.09	46633.0
2025-11-25 07:00:00	SPY	ETF	668.13	670.24	668.08	668.71	415180.0
2025-11-25 08:00:00	SPY	ETF	667.8648	670.1704	667.24	668.78	417095.0
2025-11-25 09:00:00	SPY	ETF	668.8	669.98	664.48	668.87	10342843.0
2025-11-25 10:00:00	SPY	ETF	668.86	671.07	665.92	669.805	11885457.0
2025-11-25 11:00:00	SPY	ETF	669.8	671.94	668.86	671.72	6779595.0
2025-11-25 12:00:00	SPY	ETF	671.72	674.375	671.69	673.3099	7350518.0
2025-11-25 13:00:00	SPY	ETF	673.31	674.4	673.22	673.87	5088820.0
2025-11-25 14:00:00	SPY	ETF	673.87	674.11	672.44	673.94	6668114.0
2025-11-25 15:00:00	SPY	ETF	673.94	676.21	673.92	675.01	13767242.0
2025-11-25 16:00:00	SPY	ETF	675.0	675.38	674.84	675.01	2138492.0
2025-11-25 17:00:00	SPY	ETF	675.0	675.26	674.96	675.17	42254.0
2025-11-25 18:00:00	SPY	ETF	675.11	675.47	674.83	675.32	81343.0
2025-11-25 19:00:00	SPY	ETF	675.27	676.18	675.0075	675.929	65129.0
2025-11-25 04:00:00	QQQ	ETF	604.5	604.5	602.65	603.47	171182.0
2025-11-25 05:00:00	QQQ	ETF	603.58	604.33	603.0	604.2	105597.0
2025-11-25 06:00:00	QQQ	ETF	604.23	604.49	603.19	603.88	98143.0
2025-11-25 07:00:00	QQQ	ETF	603.89	606.37	603.74	604.8	383994.0
2025-11-25 08:00:00	QQQ	ETF	604.81	606.2	602.71	604.13	806155.0
2025-11-25 09:00:00	QQQ	ETF	604.16	604.55	597.32	602.52	10025990.0
2025-11-25 10:00:00	QQQ	ETF	602.58	603.9	598.6	602.56	9707881.0
2025-11-25 11:00:00	QQQ	ETF	602.54	604.85	601.5	604.52	4878910.0
2025-11-25 12:00:00	QQQ	ETF	604.51	608.42	604.4	606.61	6143475.0
2025-11-25 13:00:00	QQQ	ETF	606.63	608.17	606.54	607.54	3240131.0
2025-11-25 14:00:00	QQQ	ETF	607.54	607.78	605.46	607.3	3880291.0
2025-11-25 15:00:00	QQQ	ETF	607.31	610.26	607.28	608.91	7637379.0
2025-11-25 16:00:00	QQQ	ETF	608.89	609.35	608.32	608.5256	1363118.0
2025-11-25 17:00:00	QQQ	ETF	608.6	609.0	608.1	608.89	35257.0
2025-11-25 18:00:00	QQQ	ETF	608.84	609.22	608.52	609.05	69855.0
2025-11-25 19:00:00	QQQ	ETF	609.08	610.04	608.64	609.9	129203.0
2025-11-25 04:00:00	IWM	ETF	239.47	239.76	239.24	239.5	18713.0
2025-11-25 05:00:00	IWM	ETF	239.48	240.07	239.46	240.04	10419.0
2025-11-25 06:00:00	IWM	ETF	240.02	240.07	239.74	240.07	22013.0
2025-11-25 07:00:00	IWM	ETF	239.96	241.08	239.87	240.48	98718.0
2025-11-25 08:00:00	IWM	ETF	239.56	241.42	239.34	240.62	244649.0
2025-11-25 09:00:00	IWM	ETF	240.67	242.459	240.04	242.459	5688755.0
2025-11-25 10:00:00	IWM	ETF	242.415	243.87	241.46	243.16	7180356.0
2025-11-25 11:00:00	IWM	ETF	243.16	243.79	242.83	243.725	3768421.0
2025-11-25 12:00:00	IWM	ETF	243.71	244.95	243.71	244.47	4152131.0
2025-11-25 13:00:00	IWM	ETF	244.48	244.76	244.252	244.3947	3639161.0
2025-11-25 14:00:00	IWM	ETF	244.4	244.98	243.95	244.97	3262030.0
2025-11-25 15:00:00	IWM	ETF	244.98	245.55	244.907	245.13	6876698.0
2025-11-25 16:00:00	IWM	ETF	245.13	245.24	244.97	245.1601	1407923.0
2025-11-25 17:00:00	IWM	ETF	245.16	245.19	245.0	245.12	30004.0
2025-11-25 18:00:00	IWM	ETF	245.12	245.28	245.0	245.14	44904.0
2025-11-25 19:00:00	IWM	ETF	245.05	245.42	245.05	245.27	36418.0
2025-11-25 04:00:00	DIA	ETF	463.82	464.18	463.77	463.8	669.0
2025-11-25 05:00:00	DIA	ETF	463.75	464.14	463.72	464.14	625.0

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

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