PREVIEW / etf_1hour / 2026-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-15.parquet
  size:    706 KB
  rows:    28,176

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
2026-07-15 04:00:00	SPY	ETF	753.5	754.33	752.45	753.71	56921.0
2026-07-15 05:00:00	SPY	ETF	753.81	754.08	753.41	753.49	16417.0
2026-07-15 06:00:00	SPY	ETF	753.48	753.66	752.69	753.18	33497.0
2026-07-15 07:00:00	SPY	ETF	753.16	753.359	752.81	753.12	69719.0
2026-07-15 08:00:00	SPY	ETF	753.05	754.42	752.2	754.1195	368520.0
2026-07-15 09:00:00	SPY	ETF	754.12	755.58	753.18	754.45	3708284.0
2026-07-15 10:00:00	SPY	ETF	754.52	755.56	752.741	753.4607	5148776.0
2026-07-15 11:00:00	SPY	ETF	753.48	754.16	752.2	752.6695	3000975.0
2026-07-15 12:00:00	SPY	ETF	752.64	752.828	750.2	751.67	4152333.0
2026-07-15 13:00:00	SPY	ETF	751.68	754.55	751.58	754.1901	3223229.0
2026-07-15 14:00:00	SPY	ETF	754.2	754.92	753.1	753.19	3728360.0
2026-07-15 15:00:00	SPY	ETF	753.19	754.8	753.05	754.74	7837846.0
2026-07-15 16:00:00	SPY	ETF	754.74	754.95	753.85	754.54	3912355.0
2026-07-15 17:00:00	SPY	ETF	754.64	754.93	754.47	754.65	50152.0
2026-07-15 18:00:00	SPY	ETF	754.65	755.19	754.45	754.85	47706.0
2026-07-15 19:00:00	SPY	ETF	754.82	755.19	754.61	754.68	24344.0
2026-07-15 04:00:00	QQQ	ETF	724.12	726.27	721.8	723.3	190335.0
2026-07-15 05:00:00	QQQ	ETF	723.3393	723.98	722.84	723.06	49752.0
2026-07-15 06:00:00	QQQ	ETF	723.0464	723.57	722.25	723.15	75434.0
2026-07-15 07:00:00	QQQ	ETF	723.07	723.74	722.65	722.74	101193.0
2026-07-15 08:00:00	QQQ	ETF	722.7	724.73	721.45	724.37	315492.0
2026-07-15 09:00:00	QQQ	ETF	724.38	724.81	718.93	720.66	3035823.0
2026-07-15 10:00:00	QQQ	ETF	720.69	722.29	713.72	715.96	4668670.0
2026-07-15 11:00:00	QQQ	ETF	716.0	716.6999	713.58	714.74	2617989.0
2026-07-15 12:00:00	QQQ	ETF	714.71	715.14	710.23	713.02	4343902.0
2026-07-15 13:00:00	QQQ	ETF	713.02	717.7	712.58	717.2	2450051.0
2026-07-15 14:00:00	QQQ	ETF	717.235	718.59	715.05	715.46	2224240.0
2026-07-15 15:00:00	QQQ	ETF	715.44	717.84	714.9204	717.7	3134323.0
2026-07-15 16:00:00	QQQ	ETF	717.71	718.51	716.73	717.8	1393465.0
2026-07-15 17:00:00	QQQ	ETF	717.7403	717.98	717.35	717.7468	40490.0
2026-07-15 18:00:00	QQQ	ETF	717.74	718.75	717.12	718.1	68745.0
2026-07-15 19:00:00	QQQ	ETF	717.99	718.41	717.22	717.3799	63242.0
2026-07-15 04:00:00	IWM	ETF	294.43	295.09	294.26	294.99	39945.0
2026-07-15 05:00:00	IWM	ETF	295.03	295.34	294.67	294.67	13965.0
2026-07-15 06:00:00	IWM	ETF	294.7	294.81	294.41	294.46	12890.0
2026-07-15 07:00:00	IWM	ETF	294.57	294.72	294.29	294.45	36742.0
2026-07-15 08:00:00	IWM	ETF	294.38	295.65	294.17	295.38	215333.0
2026-07-15 09:00:00	IWM	ETF	295.49	296.09	294.54	295.75	2246746.0
2026-07-15 10:00:00	IWM	ETF	295.79	296.73	295.57	296.61	2190452.0
2026-07-15 11:00:00	IWM	ETF	296.61	297.14	295.55	295.7	1811193.0
2026-07-15 12:00:00	IWM	ETF	295.705	295.82	294.15	295.11	2794895.0
2026-07-15 13:00:00	IWM	ETF	295.11	296.34	295.02	296.3	1576447.0
2026-07-15 14:00:00	IWM	ETF	296.3	296.4	295.19	295.25	1326403.0
2026-07-15 15:00:00	IWM	ETF	295.26	295.88	295.11	295.77	2537467.0
2026-07-15 16:00:00	IWM	ETF	295.77	296.02	295.57	295.95	855332.0
2026-07-15 17:00:00	IWM	ETF	295.83	295.99	295.61	295.78	6456.0
2026-07-15 18:00:00	IWM	ETF	295.88	296.0	295.71	295.87	19872.0
2026-07-15 19:00:00	IWM	ETF	295.84	296.08	295.78	295.82	25150.0
2026-07-15 04:00:00	DIA	ETF	524.46	525.71	524.13	525.71	3338.0
2026-07-15 05:00:00	DIA	ETF	525.77	526.02	525.67	525.67	1433.0

> showing 50 of 28,176 rows — these rows as CSV

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