PREVIEW / etf_1hour / 2025-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-04.parquet
  size:    680 KB
  rows:    26,216

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-04 04:00:00	SPY	ETF	624.1	626.0	624.1	626.0	99830.0
2025-08-04 05:00:00	SPY	ETF	625.96	626.33	625.75	625.78	26538.0
2025-08-04 06:00:00	SPY	ETF	625.75	626.03	625.37	625.5	100245.0
2025-08-04 07:00:00	SPY	ETF	625.5	625.68	624.82	625.0	169205.0
2025-08-04 08:00:00	SPY	ETF	625.04	626.1304	623.7	625.38	326302.0
2025-08-04 09:00:00	SPY	ETF	625.4	629.205	625.24	629.01	8331085.0
2025-08-04 10:00:00	SPY	ETF	629.01	629.7	628.27	629.18	8615422.0
2025-08-04 11:00:00	SPY	ETF	629.19	630.05	628.59	629.87	6155077.0
2025-08-04 12:00:00	SPY	ETF	629.86	630.45	629.62	630.135	4390567.0
2025-08-04 13:00:00	SPY	ETF	630.13	630.52	629.39	629.81	4327954.0
2025-08-04 14:00:00	SPY	ETF	629.82	630.4	629.73	629.8802	4971626.0
2025-08-04 15:00:00	SPY	ETF	629.8968	631.215	629.74	631.09	12571692.0
2025-08-04 16:00:00	SPY	ETF	631.07	632.32	621.72	632.3	3773895.0
2025-08-04 17:00:00	SPY	ETF	632.26	632.4	632.14	632.33	62057.0
2025-08-04 18:00:00	SPY	ETF	632.35	632.47	631.7	631.9	70935.0
2025-08-04 19:00:00	SPY	ETF	631.9	632.3	631.64	631.79	51792.0
2025-08-04 04:00:00	QQQ	ETF	557.06	558.37	557.0	558.37	82338.0
2025-08-04 05:00:00	QQQ	ETF	558.32	558.7	558.17	558.17	46503.0
2025-08-04 06:00:00	QQQ	ETF	558.2	558.7	558.12	558.33	136105.0
2025-08-04 07:00:00	QQQ	ETF	558.34	558.64	557.65	557.92	120343.0
2025-08-04 08:00:00	QQQ	ETF	557.95	558.76	555.7	558.6002	336380.0
2025-08-04 09:00:00	QQQ	ETF	558.64	563.01	558.5199	562.755	6981826.0
2025-08-04 10:00:00	QQQ	ETF	562.77	563.13	561.51	562.02	5463701.0
2025-08-04 11:00:00	QQQ	ETF	562.01	563.2	561.35	562.97	3670404.0
2025-08-04 12:00:00	QQQ	ETF	562.97	563.58	562.84	563.37	3035819.0
2025-08-04 13:00:00	QQQ	ETF	563.36	563.735	562.69	563.3354	2335117.0
2025-08-04 14:00:00	QQQ	ETF	563.34	563.71	563.06	563.17	2430633.0
2025-08-04 15:00:00	QQQ	ETF	563.17	564.315	562.98	564.1	6501413.0
2025-08-04 16:00:00	QQQ	ETF	564.1	565.4	563.8	565.4	2052101.0
2025-08-04 17:00:00	QQQ	ETF	565.34	565.49	565.2	565.38	101905.0
2025-08-04 18:00:00	QQQ	ETF	565.5	565.52	564.61	564.86	105716.0
2025-08-04 19:00:00	QQQ	ETF	564.86	565.3	564.58	564.97	64883.0
2025-08-04 04:00:00	IWM	ETF	216.42	217.07	216.25	216.89	41769.0
2025-08-04 05:00:00	IWM	ETF	216.96	217.05	216.69	216.7	19430.0
2025-08-04 06:00:00	IWM	ETF	216.73	216.89	216.41	216.49	69944.0
2025-08-04 07:00:00	IWM	ETF	216.44	216.54	216.05	216.16	52451.0
2025-08-04 08:00:00	IWM	ETF	216.25	216.63	215.59	216.33	97301.0
2025-08-04 09:00:00	IWM	ETF	216.32	217.0199	216.08	216.74	4344096.0
2025-08-04 10:00:00	IWM	ETF	216.75	217.74	216.75	217.53	4269742.0
2025-08-04 11:00:00	IWM	ETF	217.53	218.265	217.35	218.2125	2598434.0
2025-08-04 12:00:00	IWM	ETF	218.22	218.965	218.095	218.57	2670636.0
2025-08-04 13:00:00	IWM	ETF	218.56	218.79	218.38	218.42	1556924.0
2025-08-04 14:00:00	IWM	ETF	218.41	219.07	218.4	218.94	1908105.0
2025-08-04 15:00:00	IWM	ETF	218.94	219.74	218.91	219.69	5640574.0
2025-08-04 16:00:00	IWM	ETF	219.69	220.37	219.54	220.37	1650270.0
2025-08-04 17:00:00	IWM	ETF	220.39	220.72	220.25	220.41	92489.0
2025-08-04 18:00:00	IWM	ETF	220.4	220.42	220.05	220.1726	44876.0
2025-08-04 19:00:00	IWM	ETF	220.11	220.35	220.04	220.159	20097.0
2025-08-04 04:00:00	DIA	ETF	437.88	438.68	437.73	438.61	6050.0
2025-08-04 05:00:00	DIA	ETF	438.66	438.94	438.63	438.7	5500.0

> showing 50 of 26,216 rows — these rows as CSV

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