PREVIEW / etf_1hour / 2025-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-11-06.parquet
  size:    709 KB
  rows:    27,688

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-06 04:00:00	SPY	ETF	676.9	678.03	676.5	677.62	45987.0
2025-11-06 05:00:00	SPY	ETF	677.71	678.56	677.54	678.16	58547.0
2025-11-06 06:00:00	SPY	ETF	678.09	678.59	677.98	678.08	35411.0
2025-11-06 07:00:00	SPY	ETF	678.06	679.01	678.06	678.85	122770.0
2025-11-06 08:00:00	SPY	ETF	678.82	679.57	675.74	678.399	390423.0
2025-11-06 09:00:00	SPY	ETF	678.45	678.6	674.09	674.1404	6717119.0
2025-11-06 10:00:00	SPY	ETF	674.13	675.37	670.76	670.95	14363425.0
2025-11-06 11:00:00	SPY	ETF	670.93	672.02	669.01	669.24	8143590.0
2025-11-06 12:00:00	SPY	ETF	669.24	671.58	668.72	671.13	7035241.0
2025-11-06 13:00:00	SPY	ETF	671.1	672.21	669.13	671.5	5987827.0
2025-11-06 14:00:00	SPY	ETF	671.51	673.7	671.28	672.99	7232933.0
2025-11-06 15:00:00	SPY	ETF	672.98	673.35	669.53	670.27	14949446.0
2025-11-06 16:00:00	SPY	ETF	670.25	672.18	670.11	671.8	3444387.0
2025-11-06 17:00:00	SPY	ETF	671.68	672.03	671.54	671.55	149911.0
2025-11-06 18:00:00	SPY	ETF	671.55	672.1846	670.92	671.81	172038.0
2025-11-06 19:00:00	SPY	ETF	671.77	672.41	671.1	671.92	156702.0
2025-11-06 04:00:00	QQQ	ETF	621.75	623.59	621.74	623.12	183142.0
2025-11-06 05:00:00	QQQ	ETF	623.15	624.34	623.09	623.74	201895.0
2025-11-06 06:00:00	QQQ	ETF	623.73	624.28	623.5	623.62	170162.0
2025-11-06 07:00:00	QQQ	ETF	623.61	624.67	623.61	624.37	287253.0
2025-11-06 08:00:00	QQQ	ETF	623.85	625.37	620.76	624.06	475238.0
2025-11-06 09:00:00	QQQ	ETF	624.08	624.23	617.81	617.905	7309140.0
2025-11-06 10:00:00	QQQ	ETF	617.89	618.68	612.53	612.83	13042550.0
2025-11-06 11:00:00	QQQ	ETF	612.81	614.46	610.37	610.84	8601081.0
2025-11-06 12:00:00	QQQ	ETF	610.84	614.15	610.3	613.69	6753165.0
2025-11-06 13:00:00	QQQ	ETF	613.69	614.49	610.99	613.48	4884576.0
2025-11-06 14:00:00	QQQ	ETF	613.47	616.13	613.28	615.3	5172655.0
2025-11-06 15:00:00	QQQ	ETF	615.28	615.54	610.9488	611.7	8612378.0
2025-11-06 16:00:00	QQQ	ETF	611.7	613.17	611.32	613.02	2024454.0
2025-11-06 17:00:00	QQQ	ETF	612.9607	613.1	612.58	612.78	170142.0
2025-11-06 18:00:00	QQQ	ETF	612.78	613.59	612.09	613.14	214803.0
2025-11-06 19:00:00	QQQ	ETF	613.19	613.95	612.36	613.36	147169.0
2025-11-06 04:00:00	IWM	ETF	243.89	244.64	243.87	244.45	69178.0
2025-11-06 05:00:00	IWM	ETF	244.46	244.84	244.28	244.74	33668.0
2025-11-06 06:00:00	IWM	ETF	244.73	245.04	244.63	244.85	60779.0
2025-11-06 07:00:00	IWM	ETF	244.8	245.24	244.79	245.21	115737.0
2025-11-06 08:00:00	IWM	ETF	244.36	245.46	243.66	245.02	227947.0
2025-11-06 09:00:00	IWM	ETF	245.05	245.09	242.93	242.985	3967270.0
2025-11-06 10:00:00	IWM	ETF	242.98	243.685	241.21	241.29	6191908.0
2025-11-06 11:00:00	IWM	ETF	241.28	241.8	240.27	240.515	4589455.0
2025-11-06 12:00:00	IWM	ETF	240.51	241.54	240.0	241.15	3585443.0
2025-11-06 13:00:00	IWM	ETF	241.14	241.77	240.34	241.36	3059820.0
2025-11-06 14:00:00	IWM	ETF	241.36	242.145	241.2	241.57	2517941.0
2025-11-06 15:00:00	IWM	ETF	241.57	241.63	240.11	240.35	5503565.0
2025-11-06 16:00:00	IWM	ETF	240.35	241.01	240.34	240.95	804796.0
2025-11-06 17:00:00	IWM	ETF	240.85	240.85	240.56	240.68	17009.0
2025-11-06 18:00:00	IWM	ETF	240.72	241.12	240.6	240.9	60194.0
2025-11-06 19:00:00	IWM	ETF	240.62	241.21	240.62	241.04	19941.0
2025-11-06 04:00:00	DIA	ETF	472.48	472.63	472.3	472.58	1403.0
2025-11-06 05:00:00	DIA	ETF	472.89	473.09	472.89	473.06	420.0

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

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