PREVIEW / etf_1hour / 2025-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-06.parquet
  size:    672 KB
  rows:    25,554

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-08-06 04:00:00	SPY	ETF	631.21	631.3	629.96	630.12	52765.0
2025-08-06 05:00:00	SPY	ETF	630.23	630.35	629.3	629.58	29503.0
2025-08-06 06:00:00	SPY	ETF	629.42	629.87	628.82	629.54	29200.0
2025-08-06 07:00:00	SPY	ETF	629.5	629.86	629.25	629.47	47373.0
2025-08-06 08:00:00	SPY	ETF	629.56	631.25	628.71	629.46	270297.0
2025-08-06 09:00:00	SPY	ETF	629.46	629.98	628.27	628.93	5553803.0
2025-08-06 10:00:00	SPY	ETF	628.92	631.01	628.13	630.885	7295108.0
2025-08-06 11:00:00	SPY	ETF	630.88	632.9104	630.41	632.66	6696447.0
2025-08-06 12:00:00	SPY	ETF	632.67	632.9799	631.85	632.25	3838565.0
2025-08-06 13:00:00	SPY	ETF	632.2401	632.7	631.94	632.23	3121755.0
2025-08-06 14:00:00	SPY	ETF	632.235	633.19	632.1798	632.62	3842367.0
2025-08-06 15:00:00	SPY	ETF	632.62	633.44	632.39	632.67	11015323.0
2025-08-06 16:00:00	SPY	ETF	632.67	632.78	632.3	632.56	2437224.0
2025-08-06 17:00:00	SPY	ETF	632.45	632.95	631.2603	632.64	286781.0
2025-08-06 18:00:00	SPY	ETF	632.64	634.14	632.0	633.77	197533.0
2025-08-06 19:00:00	SPY	ETF	633.81	634.21	633.478	633.61	107234.0
2025-08-06 04:00:00	QQQ	ETF	562.34	562.44	560.8	561.04	55515.0
2025-08-06 05:00:00	QQQ	ETF	561.07	561.35	560.23	560.58	42987.0
2025-08-06 06:00:00	QQQ	ETF	560.4	560.76	559.64	560.44	44940.0
2025-08-06 07:00:00	QQQ	ETF	560.51	561.63	560.34	561.3	73885.0
2025-08-06 08:00:00	QQQ	ETF	561.09	562.28	559.85	561.281	246477.0
2025-08-06 09:00:00	QQQ	ETF	561.38	562.93	560.63	561.92	4227890.0
2025-08-06 10:00:00	QQQ	ETF	561.91	563.93	561.0	563.8351	5290351.0
2025-08-06 11:00:00	QQQ	ETF	563.84	566.09	563.27	565.91	4533848.0
2025-08-06 12:00:00	QQQ	ETF	565.91	566.42	565.38	565.98	2986811.0
2025-08-06 13:00:00	QQQ	ETF	565.98	566.61	565.7	566.04	2029926.0
2025-08-06 14:00:00	QQQ	ETF	566.05	567.54	565.99	567.065	2883805.0
2025-08-06 15:00:00	QQQ	ETF	567.07	567.76	566.89	567.32	5295274.0
2025-08-06 16:00:00	QQQ	ETF	567.32	567.34	565.0	566.97	950702.0
2025-08-06 17:00:00	QQQ	ETF	567.0518	567.75	564.75	567.55	447348.0
2025-08-06 18:00:00	QQQ	ETF	567.56	568.65	566.41	568.24	285114.0
2025-08-06 19:00:00	QQQ	ETF	568.39	568.5	567.84	568.0	89249.0
2025-08-06 04:00:00	IWM	ETF	222.58	222.58	221.81	221.89	26424.0
2025-08-06 05:00:00	IWM	ETF	221.92	221.94	221.65	221.75	12946.0
2025-08-06 06:00:00	IWM	ETF	221.68	221.94	221.46	221.75	13868.0
2025-08-06 07:00:00	IWM	ETF	221.65	221.82	221.24	221.36	42133.0
2025-08-06 08:00:00	IWM	ETF	221.65	222.67	220.71	220.8599	155252.0
2025-08-06 09:00:00	IWM	ETF	220.95	221.25	219.67	219.94	2949950.0
2025-08-06 10:00:00	IWM	ETF	219.94	220.6	219.38	220.32	3089409.0
2025-08-06 11:00:00	IWM	ETF	220.32	220.81	219.84	220.55	3620527.0
2025-08-06 12:00:00	IWM	ETF	220.55	220.73	220.0	220.25	1685163.0
2025-08-06 13:00:00	IWM	ETF	220.26	220.48	220.075	220.225	1375619.0
2025-08-06 14:00:00	IWM	ETF	220.22	220.66	220.18	220.27	1394716.0
2025-08-06 15:00:00	IWM	ETF	220.26	220.87	220.25	220.58	3581309.0
2025-08-06 16:00:00	IWM	ETF	220.56	220.71	220.46	220.63	563497.0
2025-08-06 17:00:00	IWM	ETF	220.58	220.64	220.12	220.49	18685.0
2025-08-06 18:00:00	IWM	ETF	220.5	220.82	220.0	220.75	37997.0
2025-08-06 19:00:00	IWM	ETF	220.75	221.08	220.67	220.73	44890.0
2025-08-06 04:00:00	DIA	ETF	443.51	443.51	442.82	442.82	7400.0
2025-08-06 05:00:00	DIA	ETF	442.85	442.86	442.49	442.53	2432.0

> showing 50 of 25,554 rows — these rows as CSV

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