PREVIEW / etf_1hour / 2025-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-28.parquet
  size:    671 KB
  rows:    25,274

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-28 04:00:00	SPY	ETF	647.61	647.91	647.13	647.2	31284.0
2025-08-28 05:00:00	SPY	ETF	647.19	647.41	646.99	647.05	10073.0
2025-08-28 06:00:00	SPY	ETF	646.91	647.14	646.5	646.74	18009.0
2025-08-28 07:00:00	SPY	ETF	646.8	646.97	646.29	646.97	142197.0
2025-08-28 08:00:00	SPY	ETF	646.87	647.67	645.92	647.1302	467670.0
2025-08-28 09:00:00	SPY	ETF	647.14	648.09	645.34	645.94	6719895.0
2025-08-28 10:00:00	SPY	ETF	645.93	647.17	645.58	646.89	5712751.0
2025-08-28 11:00:00	SPY	ETF	646.89	647.6558	646.08	647.02	4455975.0
2025-08-28 12:00:00	SPY	ETF	647.02	648.42	646.94	647.67	3828822.0
2025-08-28 13:00:00	SPY	ETF	647.67	648.515	647.45	648.38	3261432.0
2025-08-28 14:00:00	SPY	ETF	648.37	649.055	648.315	648.965	4896410.0
2025-08-28 15:00:00	SPY	ETF	648.96	649.48	648.73	648.89	10322422.0
2025-08-28 16:00:00	SPY	ETF	648.87	649.79	648.58	648.87	2305960.0
2025-08-28 17:00:00	SPY	ETF	648.9256	649.03	648.76	648.81	52492.0
2025-08-28 18:00:00	SPY	ETF	648.84	648.92	648.41	648.48	56861.0
2025-08-28 19:00:00	SPY	ETF	648.6	648.7	648.3905	648.65	13424.0
2025-08-28 04:00:00	QQQ	ETF	573.83	574.57	573.0	573.52	103120.0
2025-08-28 05:00:00	QQQ	ETF	573.52	573.79	573.37	573.43	33314.0
2025-08-28 06:00:00	QQQ	ETF	573.47	573.71	573.1	573.35	31509.0
2025-08-28 07:00:00	QQQ	ETF	573.37	573.52	572.68	573.52	37237.0
2025-08-28 08:00:00	QQQ	ETF	573.5	574.55	571.7	573.95	368718.0
2025-08-28 09:00:00	QQQ	ETF	573.94	576.53	572.46	573.348	6937938.0
2025-08-28 10:00:00	QQQ	ETF	573.34	576.22	572.97	575.85	5877678.0
2025-08-28 11:00:00	QQQ	ETF	575.87	576.77	574.67	575.2	3948598.0
2025-08-28 12:00:00	QQQ	ETF	575.21	577.09	575.09	576.26	3700939.0
2025-08-28 13:00:00	QQQ	ETF	576.26	577.24	576.04	577.1	2776048.0
2025-08-28 14:00:00	QQQ	ETF	577.1	577.73	576.99	577.6413	2445445.0
2025-08-28 15:00:00	QQQ	ETF	577.64	578.0	577.04	577.07	5908040.0
2025-08-28 16:00:00	QQQ	ETF	577.07	577.26	576.7	576.96	1547364.0
2025-08-28 17:00:00	QQQ	ETF	576.99	577.08	576.84	576.91	45738.0
2025-08-28 18:00:00	QQQ	ETF	576.92	576.95	576.35	576.41	53388.0
2025-08-28 19:00:00	QQQ	ETF	576.52	576.72	576.44	576.64	16848.0
2025-08-28 04:00:00	IWM	ETF	237.59	237.79	237.35	237.76	46672.0
2025-08-28 05:00:00	IWM	ETF	237.74	237.85	237.61	237.72	30908.0
2025-08-28 06:00:00	IWM	ETF	237.68	237.68	237.01	237.15	31029.0
2025-08-28 07:00:00	IWM	ETF	237.15	237.26	236.95	237.1	40509.0
2025-08-28 08:00:00	IWM	ETF	237.04	237.756	236.62	237.06	252472.0
2025-08-28 09:00:00	IWM	ETF	237.04	237.2492	235.48	236.17	3773953.0
2025-08-28 10:00:00	IWM	ETF	236.15	236.5	235.345	235.64	3288556.0
2025-08-28 11:00:00	IWM	ETF	235.64	236.32	235.42	236.28	2749469.0
2025-08-28 12:00:00	IWM	ETF	236.27	236.38	235.9701	235.9883	1611174.0
2025-08-28 13:00:00	IWM	ETF	235.985	236.19	235.7	236.09	1390263.0
2025-08-28 14:00:00	IWM	ETF	236.09	236.31	235.975	236.25	1654406.0
2025-08-28 15:00:00	IWM	ETF	236.25	236.71	236.04	236.24	3050298.0
2025-08-28 16:00:00	IWM	ETF	236.23	236.4299	236.13	236.339	983838.0
2025-08-28 17:00:00	IWM	ETF	236.31	236.36	236.23	236.31	10610.0
2025-08-28 18:00:00	IWM	ETF	236.3	236.47	236.18	236.2	20531.0
2025-08-28 19:00:00	IWM	ETF	236.26	236.34	236.26	236.27	8966.0
2025-08-28 04:00:00	DIA	ETF	457.68	457.68	457.16	457.16	700.0
2025-08-28 05:00:00	DIA	ETF	457.15	457.15	456.93	457.11	5130.0

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

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