PREVIEW / etf_1hour / 2025-08-25

all etf 1-hour files

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

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-25 04:00:00	SPY	ETF	644.41	644.55	644.13	644.13	21288.0
2025-08-25 05:00:00	SPY	ETF	644.1	644.13	643.79	644.04	30936.0
2025-08-25 06:00:00	SPY	ETF	644.04	644.04	643.37	643.43	67697.0
2025-08-25 07:00:00	SPY	ETF	643.44	643.94	643.38	643.83	98022.0
2025-08-25 08:00:00	SPY	ETF	643.55	645.14	643.14	643.48	277161.0
2025-08-25 09:00:00	SPY	ETF	643.5	644.369	643.41	644.34	5601596.0
2025-08-25 10:00:00	SPY	ETF	644.33	644.67	643.74	644.42	5521430.0
2025-08-25 11:00:00	SPY	ETF	644.41	645.065	644.23	644.97	3708370.0
2025-08-25 12:00:00	SPY	ETF	644.96	645.29	644.79	644.995	2748460.0
2025-08-25 13:00:00	SPY	ETF	644.9813	645.015	644.025	644.505	3168886.0
2025-08-25 14:00:00	SPY	ETF	644.5011	644.565	643.895	643.94	3397532.0
2025-08-25 15:00:00	SPY	ETF	643.97	644.15	642.35	642.47	9116286.0
2025-08-25 16:00:00	SPY	ETF	642.48	643.1499	642.34	642.93	2416384.0
2025-08-25 17:00:00	SPY	ETF	642.92	642.98	642.8	642.98	133432.0
2025-08-25 18:00:00	SPY	ETF	642.98	643.38	642.97	643.17	40597.0
2025-08-25 19:00:00	SPY	ETF	643.27	643.33	642.8319	643.01	44118.0
2025-08-25 04:00:00	QQQ	ETF	571.2	571.38	570.68	570.68	44088.0
2025-08-25 05:00:00	QQQ	ETF	570.66	570.79	570.17	570.54	78292.0
2025-08-25 06:00:00	QQQ	ETF	570.55	570.59	569.62	569.99	98176.0
2025-08-25 07:00:00	QQQ	ETF	570.03	570.48	569.8	570.41	51103.0
2025-08-25 08:00:00	QQQ	ETF	570.08	572.08	569.6	569.99	249124.0
2025-08-25 09:00:00	QQQ	ETF	570.01	570.9399	569.16	570.9399	4702077.0
2025-08-25 10:00:00	QQQ	ETF	570.95	572.27	570.59	572.195	4191288.0
2025-08-25 11:00:00	QQQ	ETF	572.18	573.2871	572.06	572.912	2904209.0
2025-08-25 12:00:00	QQQ	ETF	572.9	573.24	572.6299	572.8	1806138.0
2025-08-25 13:00:00	QQQ	ETF	572.8	572.85	571.88	572.365	1954395.0
2025-08-25 14:00:00	QQQ	ETF	572.38	572.51	571.67	571.76	1987559.0
2025-08-25 15:00:00	QQQ	ETF	571.76	572.26	570.18	570.35	4858806.0
2025-08-25 16:00:00	QQQ	ETF	570.36	570.89	570.14	570.54	1388155.0
2025-08-25 17:00:00	QQQ	ETF	570.5	570.5388	570.22	570.4502	22305.0
2025-08-25 18:00:00	QQQ	ETF	570.6	570.9201	570.48	570.72	27321.0
2025-08-25 19:00:00	QQQ	ETF	570.77	570.82	570.15	570.34	64334.0
2025-08-25 04:00:00	IWM	ETF	234.92	235.03	234.5	234.93	26209.0
2025-08-25 05:00:00	IWM	ETF	234.86	234.91	234.6	234.78	30988.0
2025-08-25 06:00:00	IWM	ETF	234.74	234.76	234.44	234.47	22419.0
2025-08-25 07:00:00	IWM	ETF	234.48	234.71	234.37	234.37	70690.0
2025-08-25 08:00:00	IWM	ETF	234.58	235.3	233.61	233.8991	258649.0
2025-08-25 09:00:00	IWM	ETF	233.88	234.27	233.385	233.99	3437415.0
2025-08-25 10:00:00	IWM	ETF	233.98	234.3	233.6804	233.94	4212664.0
2025-08-25 11:00:00	IWM	ETF	233.94	233.96	233.325	233.495	2521765.0
2025-08-25 12:00:00	IWM	ETF	233.49	233.775	233.2499	233.75	1777982.0
2025-08-25 13:00:00	IWM	ETF	233.75	233.797	233.19	233.305	1600942.0
2025-08-25 14:00:00	IWM	ETF	233.305	233.47	232.975	233.13	2094855.0
2025-08-25 15:00:00	IWM	ETF	233.13	233.19	232.36	232.39	5268697.0
2025-08-25 16:00:00	IWM	ETF	232.36	232.68	232.28	232.566	1216632.0
2025-08-25 17:00:00	IWM	ETF	232.54	232.65	232.42	232.65	24948.0
2025-08-25 18:00:00	IWM	ETF	232.67	232.84	232.6	232.83	20275.0
2025-08-25 19:00:00	IWM	ETF	232.84	232.93	232.7	232.8292	16632.0
2025-08-25 04:00:00	DIA	ETF	456.14	456.14	455.9	455.9	1660.0
2025-08-25 05:00:00	DIA	ETF	455.88	455.88	455.73	455.73	1300.0

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

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