PREVIEW / etf_1hour / 2025-08-26

all etf 1-hour files

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

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-26 04:00:00	SPY	ETF	641.37	641.95	641.33	641.8	28290.0
2025-08-26 05:00:00	SPY	ETF	641.79	642.25	641.6	642.07	7278.0
2025-08-26 06:00:00	SPY	ETF	642.07	642.44	642.07	642.29	21474.0
2025-08-26 07:00:00	SPY	ETF	642.31	642.32	641.53	642.06	47386.0
2025-08-26 08:00:00	SPY	ETF	642.23	642.5	640.73	642.18	123061.0
2025-08-26 09:00:00	SPY	ETF	642.19	642.8499	641.57	642.555	4462147.0
2025-08-26 10:00:00	SPY	ETF	642.492	643.27	642.38	642.6919	4874845.0
2025-08-26 11:00:00	SPY	ETF	642.7	642.91	642.2914	642.75	2680230.0
2025-08-26 12:00:00	SPY	ETF	642.76	643.55	642.76	643.32	2683186.0
2025-08-26 13:00:00	SPY	ETF	643.3	643.59	642.435	642.86	2625137.0
2025-08-26 14:00:00	SPY	ETF	642.86	644.09	642.79	643.895	3341672.0
2025-08-26 15:00:00	SPY	ETF	643.89	645.51	643.615	645.13	10695133.0
2025-08-26 16:00:00	SPY	ETF	645.13	645.79	644.96	645.78	2666079.0
2025-08-26 17:00:00	SPY	ETF	645.78	645.78	645.61	645.72	43425.0
2025-08-26 18:00:00	SPY	ETF	645.73	645.9	645.6	645.7491	39723.0
2025-08-26 19:00:00	SPY	ETF	645.7499	645.84	645.68	645.71	29071.0
2025-08-26 04:00:00	QQQ	ETF	569.17	569.86	569.08	569.51	30544.0
2025-08-26 05:00:00	QQQ	ETF	569.58	570.08	569.44	569.94	34100.0
2025-08-26 06:00:00	QQQ	ETF	569.94	570.63	569.94	570.4	43953.0
2025-08-26 07:00:00	QQQ	ETF	570.32	570.39	569.2	569.81	43370.0
2025-08-26 08:00:00	QQQ	ETF	570.17	570.61	568.56	569.71	176058.0
2025-08-26 09:00:00	QQQ	ETF	569.7205	570.98	568.8	570.4726	4155297.0
2025-08-26 10:00:00	QQQ	ETF	570.42	571.81	570.17	571.08	3499009.0
2025-08-26 11:00:00	QQQ	ETF	571.09	571.42	570.37	570.972	2259453.0
2025-08-26 12:00:00	QQQ	ETF	570.97	571.885	570.97	571.49	1789711.0
2025-08-26 13:00:00	QQQ	ETF	571.48	571.59	570.05	570.6001	2301724.0
2025-08-26 14:00:00	QQQ	ETF	570.61	572.0	570.52	571.72	2518185.0
2025-08-26 15:00:00	QQQ	ETF	571.72	572.92	571.34	572.65	5586368.0
2025-08-26 16:00:00	QQQ	ETF	572.63	573.2046	572.3741	573.12	1025548.0
2025-08-26 17:00:00	QQQ	ETF	573.08	573.2	572.97	573.09	27855.0
2025-08-26 18:00:00	QQQ	ETF	573.09	573.42	573.02	573.35	84859.0
2025-08-26 19:00:00	QQQ	ETF	573.339	573.5	573.18	573.33	44865.0
2025-08-26 04:00:00	IWM	ETF	232.02	232.02	231.53	231.86	29318.0
2025-08-26 05:00:00	IWM	ETF	231.81	232.06	231.75	232.06	9145.0
2025-08-26 06:00:00	IWM	ETF	232.07	232.44	232.07	232.39	29567.0
2025-08-26 07:00:00	IWM	ETF	232.44	232.54	232.15	232.53	70126.0
2025-08-26 08:00:00	IWM	ETF	231.64	232.9	231.26	232.9	164659.0
2025-08-26 09:00:00	IWM	ETF	232.88	233.955	232.59	233.59	2825011.0
2025-08-26 10:00:00	IWM	ETF	233.62	234.45	233.6	233.89	2756247.0
2025-08-26 11:00:00	IWM	ETF	233.895	234.195	233.77	234.06	2117829.0
2025-08-26 12:00:00	IWM	ETF	234.05	234.81	234.02	234.68	2858211.0
2025-08-26 13:00:00	IWM	ETF	234.67	234.87	234.325	234.575	1306259.0
2025-08-26 14:00:00	IWM	ETF	234.56	234.65	234.23	234.405	1628332.0
2025-08-26 15:00:00	IWM	ETF	234.3999	234.63	233.96	234.27	4187036.0
2025-08-26 16:00:00	IWM	ETF	234.28	234.56	234.25	234.45	851080.0
2025-08-26 17:00:00	IWM	ETF	234.45	234.5499	234.44	234.51	9710.0
2025-08-26 18:00:00	IWM	ETF	234.6	234.7	234.5	234.5	9793.0
2025-08-26 19:00:00	IWM	ETF	234.5	234.61	234.44	234.449	10408.0
2025-08-26 04:00:00	DIA	ETF	452.22	452.22	452.22	452.22	100.0
2025-08-26 06:00:00	DIA	ETF	452.62	452.74	452.49	452.49	5271.0

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

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