PREVIEW / etf_1hour / 2026-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-09.parquet
  size:    713 KB
  rows:    28,253

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
2026-07-09 04:00:00	SPY	ETF	747.13	748.42	746.18	747.1117	61401.0
2026-07-09 05:00:00	SPY	ETF	746.93	747.17	746.03	746.74	34427.0
2026-07-09 06:00:00	SPY	ETF	746.79	747.07	745.4	746.2	57024.0
2026-07-09 07:00:00	SPY	ETF	746.14	747.2995	745.8	747.0075	186137.0
2026-07-09 08:00:00	SPY	ETF	747.04	748.08	745.98	747.17	269978.0
2026-07-09 09:00:00	SPY	ETF	747.14	749.23	745.68	748.67	3798297.0
2026-07-09 10:00:00	SPY	ETF	748.69	749.02	745.59	748.73	4349341.0
2026-07-09 11:00:00	SPY	ETF	748.72	750.25	748.6	749.87	2613499.0
2026-07-09 12:00:00	SPY	ETF	749.88	750.8999	749.87	750.44	2233511.0
2026-07-09 13:00:00	SPY	ETF	750.45	751.97	750.4	751.63	2551337.0
2026-07-09 14:00:00	SPY	ETF	751.625	751.865	750.86	751.05	3051476.0
2026-07-09 15:00:00	SPY	ETF	751.05	751.72	750.6601	751.64	6921704.0
2026-07-09 16:00:00	SPY	ETF	751.63	751.77	751.08	751.26	3097916.0
2026-07-09 17:00:00	SPY	ETF	751.69	751.69	751.01	751.16	262510.0
2026-07-09 18:00:00	SPY	ETF	751.24	751.44	750.9	751.18	71129.0
2026-07-09 19:00:00	SPY	ETF	751.25	751.69	751.06	751.4386	17742.0
2026-07-09 04:00:00	QQQ	ETF	716.79	718.01	711.5	716.2	300435.0
2026-07-09 05:00:00	QQQ	ETF	716.385	716.385	715.09	715.73	60955.0
2026-07-09 06:00:00	QQQ	ETF	715.87	716.41	713.94	714.76	88688.0
2026-07-09 07:00:00	QQQ	ETF	714.77	717.69	714.355	717.06	361736.0
2026-07-09 08:00:00	QQQ	ETF	717.17	719.24	711.973	718.02	443006.0
2026-07-09 09:00:00	QQQ	ETF	718.03	722.75	716.5	722.17	4396713.0
2026-07-09 10:00:00	QQQ	ETF	722.21	722.54	715.125	719.32	5328117.0
2026-07-09 11:00:00	QQQ	ETF	719.39	722.08	719.13	721.6644	2546474.0
2026-07-09 12:00:00	QQQ	ETF	721.66	722.56	721.12	721.94	1761825.0
2026-07-09 13:00:00	QQQ	ETF	721.935	724.23	721.86	723.78	2618211.0
2026-07-09 14:00:00	QQQ	ETF	723.77	724.04	722.74	722.96	1590751.0
2026-07-09 15:00:00	QQQ	ETF	722.99	723.42	721.97	723.19	3263287.0
2026-07-09 16:00:00	QQQ	ETF	723.2	723.8296	722.77	722.8	1835085.0
2026-07-09 17:00:00	QQQ	ETF	722.9	723.15	722.57	722.99	56983.0
2026-07-09 18:00:00	QQQ	ETF	723.0	723.5	722.25	722.66	74557.0
2026-07-09 19:00:00	QQQ	ETF	722.36	723.59	722.34	722.94	36443.0
2026-07-09 04:00:00	IWM	ETF	294.66	294.98	294.03	294.34	40106.0
2026-07-09 05:00:00	IWM	ETF	294.18	294.3	293.71	294.06	31001.0
2026-07-09 06:00:00	IWM	ETF	293.99	294.27	293.318	293.73	23577.0
2026-07-09 07:00:00	IWM	ETF	293.72	294.44	293.65	294.33	103755.0
2026-07-09 08:00:00	IWM	ETF	294.3	295.03	294.28	294.68	111928.0
2026-07-09 09:00:00	IWM	ETF	294.69	296.72	294.67	296.465	2653447.0
2026-07-09 10:00:00	IWM	ETF	296.52	297.55	295.57	297.48	2413818.0
2026-07-09 11:00:00	IWM	ETF	297.49	297.66	296.665	296.91	1136997.0
2026-07-09 12:00:00	IWM	ETF	296.92	297.36	296.92	297.23	541219.0
2026-07-09 13:00:00	IWM	ETF	297.25	297.88	297.19	297.63	955407.0
2026-07-09 14:00:00	IWM	ETF	297.63	297.87	297.32	297.69	846307.0
2026-07-09 15:00:00	IWM	ETF	297.7	297.745	296.99	297.26	2301768.0
2026-07-09 16:00:00	IWM	ETF	297.27	297.47	296.87	296.93	1150574.0
2026-07-09 17:00:00	IWM	ETF	296.93	297.25	296.73	297.08	29716.0
2026-07-09 18:00:00	IWM	ETF	297.08	297.28	296.92	296.93	11048.0
2026-07-09 19:00:00	IWM	ETF	296.99	297.08	296.86	296.97	3517.0
2026-07-09 04:00:00	DIA	ETF	523.53	523.83	523.25	523.25	6646.0
2026-07-09 05:00:00	DIA	ETF	522.96	522.96	522.51	522.75	1256.0

> showing 50 of 28,253 rows — these rows as CSV

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