PREVIEW / etf_1hour / 2025-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-15.parquet
  size:    652 KB
  rows:    25,128

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-15 04:00:00	SPY	ETF	646.81	647.02	645.73	645.79	59335.0
2025-08-15 05:00:00	SPY	ETF	645.75	645.99	645.52	645.52	6590.0
2025-08-15 06:00:00	SPY	ETF	645.55	646.47	645.34	646.3	30746.0
2025-08-15 07:00:00	SPY	ETF	646.21	646.5	646.19	646.28	50413.0
2025-08-15 08:00:00	SPY	ETF	646.28	647.04	645.55	646.13	235637.0
2025-08-15 09:00:00	SPY	ETF	646.1	646.33	643.72	644.1	5434624.0
2025-08-15 10:00:00	SPY	ETF	643.78	644.65	643.21	643.575	5608500.0
2025-08-15 11:00:00	SPY	ETF	643.58	644.28	642.5153	643.415	5186842.0
2025-08-15 12:00:00	SPY	ETF	643.4	644.28	643.08	644.0808	3960630.0
2025-08-15 13:00:00	SPY	ETF	644.08	644.81	643.74	644.7708	3847553.0
2025-08-15 14:00:00	SPY	ETF	644.77	644.88	643.81	644.26	4829304.0
2025-08-15 15:00:00	SPY	ETF	644.25	644.28	643.13	643.44	9581346.0
2025-08-15 16:00:00	SPY	ETF	643.45	643.52	642.73	643.09	2299597.0
2025-08-15 17:00:00	SPY	ETF	643.08	643.1999	642.85	643.1999	140098.0
2025-08-15 18:00:00	SPY	ETF	643.24	643.5699	643.15	643.5695	34200.0
2025-08-15 19:00:00	SPY	ETF	643.51	643.8	643.2294	643.2294	82209.0
2025-08-15 04:00:00	QQQ	ETF	580.45	580.84	579.06	579.2	24404.0
2025-08-15 05:00:00	QQQ	ETF	579.22	579.5	579.11	579.17	14241.0
2025-08-15 06:00:00	QQQ	ETF	579.05	580.01	578.91	579.87	15189.0
2025-08-15 07:00:00	QQQ	ETF	579.78	580.22	579.72	580.07	39514.0
2025-08-15 08:00:00	QQQ	ETF	579.78	581.02	579.02	579.72	160417.0
2025-08-15 09:00:00	QQQ	ETF	579.6	580.2	576.44	577.29	4606727.0
2025-08-15 10:00:00	QQQ	ETF	577.2	579.09	576.4	577.145	4844730.0
2025-08-15 11:00:00	QQQ	ETF	577.13	577.97	575.5743	576.84	3815328.0
2025-08-15 12:00:00	QQQ	ETF	576.83	577.7494	576.24	577.57	3323205.0
2025-08-15 13:00:00	QQQ	ETF	577.58	578.16	576.79	578.0743	2684447.0
2025-08-15 14:00:00	QQQ	ETF	578.08	578.27	576.94	577.3943	2757633.0
2025-08-15 15:00:00	QQQ	ETF	577.38	577.8	576.535	577.23	4668667.0
2025-08-15 16:00:00	QQQ	ETF	577.23	577.38	576.59	577.03	1088296.0
2025-08-15 17:00:00	QQQ	ETF	577.03	577.17	576.93	577.17	19033.0
2025-08-15 18:00:00	QQQ	ETF	577.16	577.48	577.0	577.4799	25541.0
2025-08-15 19:00:00	QQQ	ETF	577.46	577.46	577.03	577.06	35421.0
2025-08-15 04:00:00	IWM	ETF	229.28	229.3	228.78	228.9	11655.0
2025-08-15 05:00:00	IWM	ETF	228.82	228.84	228.41	228.45	10407.0
2025-08-15 06:00:00	IWM	ETF	228.44	228.97	228.4	228.97	20678.0
2025-08-15 07:00:00	IWM	ETF	228.95	229.18	228.8	229.01	38651.0
2025-08-15 08:00:00	IWM	ETF	229.13	229.71	228.56	229.0404	166844.0
2025-08-15 09:00:00	IWM	ETF	229.01	229.24	227.25	227.75	2830595.0
2025-08-15 10:00:00	IWM	ETF	227.72	227.75	226.035	226.94	4179850.0
2025-08-15 11:00:00	IWM	ETF	226.95	227.17	226.435	226.84	2739881.0
2025-08-15 12:00:00	IWM	ETF	226.84	227.46	226.8	227.32	2429854.0
2025-08-15 13:00:00	IWM	ETF	227.32	227.78	227.155	227.675	1865585.0
2025-08-15 14:00:00	IWM	ETF	227.67	227.71	227.19	227.44	1692992.0
2025-08-15 15:00:00	IWM	ETF	227.44	227.465	226.95	227.13	4228112.0
2025-08-15 16:00:00	IWM	ETF	227.13	227.2	226.88	226.96	919295.0
2025-08-15 17:00:00	IWM	ETF	227.02	227.15	226.9	227.0	16301.0
2025-08-15 18:00:00	IWM	ETF	227.13	227.28	226.86	226.98	26259.0
2025-08-15 19:00:00	IWM	ETF	227.2734	227.39	227.04	227.15	9147.0
2025-08-15 04:00:00	DIA	ETF	451.88	452.69	451.88	452.16	7400.0
2025-08-15 05:00:00	DIA	ETF	452.12	452.15	451.94	451.94	810.0

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

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