PREVIEW / etf_1hour / 2025-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-02.parquet
  size:    698 KB
  rows:    27,510

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-09-02 04:00:00	SPY	ETF	640.74	643.88	640.6	641.8	58351.0
2025-09-02 05:00:00	SPY	ETF	641.8	642.05	641.42	641.5	16586.0
2025-09-02 06:00:00	SPY	ETF	641.39	641.71	639.86	640.32	54288.0
2025-09-02 07:00:00	SPY	ETF	640.35	640.48	639.79	640.02	334548.0
2025-09-02 08:00:00	SPY	ETF	644.49	644.71	636.44	637.34	818743.0
2025-09-02 09:00:00	SPY	ETF	637.34	639.36	636.05	639.07	10105026.0
2025-09-02 10:00:00	SPY	ETF	639.01	640.14	637.23	637.65	7477086.0
2025-09-02 11:00:00	SPY	ETF	637.65	637.94	634.92	635.21	5835211.0
2025-09-02 12:00:00	SPY	ETF	635.215	636.97	635.0301	636.95	4531973.0
2025-09-02 13:00:00	SPY	ETF	636.95	639.035	636.53	638.35	5274186.0
2025-09-02 14:00:00	SPY	ETF	638.33	638.94	637.32	638.0518	4363830.0
2025-09-02 15:00:00	SPY	ETF	638.06	640.49	638.04	640.31	13191637.0
2025-09-02 16:00:00	SPY	ETF	640.33	642.45	640.17	642.4	3768070.0
2025-09-02 17:00:00	SPY	ETF	642.32	642.45	642.1701	642.4	153531.0
2025-09-02 18:00:00	SPY	ETF	642.42	642.42	641.35	641.38	127199.0
2025-09-02 19:00:00	SPY	ETF	641.43	641.47	641.07	641.18	50715.0
2025-09-02 04:00:00	QQQ	ETF	565.6	569.69	565.44	566.4	95841.0
2025-09-02 05:00:00	QQQ	ETF	566.44	566.89	565.97	566.0	68537.0
2025-09-02 06:00:00	QQQ	ETF	565.96	566.44	564.59	565.0	160433.0
2025-09-02 07:00:00	QQQ	ETF	565.07	565.19	564.23	564.36	125115.0
2025-09-02 08:00:00	QQQ	ETF	564.77	570.827	560.57	561.29	721548.0
2025-09-02 09:00:00	QQQ	ETF	561.25	565.23	559.535	564.585	10435163.0
2025-09-02 10:00:00	QQQ	ETF	564.61	565.7	562.19	562.85	9444388.0
2025-09-02 11:00:00	QQQ	ETF	562.86	563.25	559.57	560.09	6039459.0
2025-09-02 12:00:00	QQQ	ETF	560.09	562.1	559.84	561.99	4403565.0
2025-09-02 13:00:00	QQQ	ETF	562.0	564.36	561.45	563.48	4887445.0
2025-09-02 14:00:00	QQQ	ETF	563.47	564.53	562.74	563.505	4510655.0
2025-09-02 15:00:00	QQQ	ETF	563.51	565.965	563.47	565.62	7144526.0
2025-09-02 16:00:00	QQQ	ETF	565.62	568.26	563.8289	568.12	2164966.0
2025-09-02 17:00:00	QQQ	ETF	568.15	568.3	567.99	568.2	207925.0
2025-09-02 18:00:00	QQQ	ETF	568.2	568.2928	567.07	567.22	157230.0
2025-09-02 19:00:00	QQQ	ETF	567.19	567.3	566.8702	567.06	77563.0
2025-09-02 04:00:00	IWM	ETF	232.66	235.0	232.5	233.47	81418.0
2025-09-02 05:00:00	IWM	ETF	233.4	233.64	233.33	233.46	45150.0
2025-09-02 06:00:00	IWM	ETF	233.41	233.54	232.68	232.76	35732.0
2025-09-02 07:00:00	IWM	ETF	232.76	233.0	232.67	233.0	154904.0
2025-09-02 08:00:00	IWM	ETF	232.96	235.06	230.86	231.38	439616.0
2025-09-02 09:00:00	IWM	ETF	231.39	233.8477	231.28	233.76	5216818.0
2025-09-02 10:00:00	IWM	ETF	233.71	234.4	232.76	233.15	4491639.0
2025-09-02 11:00:00	IWM	ETF	233.16	233.32	231.575	231.69	2694031.0
2025-09-02 12:00:00	IWM	ETF	231.68	232.67	231.68	232.67	2289039.0
2025-09-02 13:00:00	IWM	ETF	232.67	233.39	232.6	233.179	2482882.0
2025-09-02 14:00:00	IWM	ETF	233.17	233.38	232.69	233.05	2251525.0
2025-09-02 15:00:00	IWM	ETF	233.045	234.035	233.035	233.91	4808623.0
2025-09-02 16:00:00	IWM	ETF	233.9	234.12	233.44	233.44	1027426.0
2025-09-02 17:00:00	IWM	ETF	233.6	233.75	233.4	233.51	8794.0
2025-09-02 18:00:00	IWM	ETF	233.52	233.52	233.16	233.22	11164.0
2025-09-02 19:00:00	IWM	ETF	233.23	233.28	233.09	233.1	18728.0
2025-09-02 04:00:00	DIA	ETF	453.13	454.47	453.13	454.35	10175.0
2025-09-02 05:00:00	DIA	ETF	454.21	454.41	454.13	454.13	1400.0

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

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