PREVIEW / etf_1hour / 2026-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-13.parquet
  size:    717 KB
  rows:    28,168

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-08-13 04:00:00	SPY	ETF	772.85	773.86	772.85	773.75	67864.0
2026-08-13 05:00:00	SPY	ETF	773.78	774.01	773.36	774.0	20542.0
2026-08-13 06:00:00	SPY	ETF	774.0	774.12	773.85	774.04	18439.0
2026-08-13 07:00:00	SPY	ETF	774.07	774.41	773.83	773.93	54028.0
2026-08-13 08:00:00	SPY	ETF	774.02	774.5	773.35	774.3462	246281.0
2026-08-13 09:00:00	SPY	ETF	774.4	777.69	774.111	777.61	3384898.0
2026-08-13 10:00:00	SPY	ETF	777.6	779.37	777.38	777.76	4374269.0
2026-08-13 11:00:00	SPY	ETF	777.77	778.23	775.38	775.49	3977674.0
2026-08-13 12:00:00	SPY	ETF	775.48	776.8	775.46	776.7	2178313.0
2026-08-13 13:00:00	SPY	ETF	776.71	777.48	776.62	776.745	1406176.0
2026-08-13 14:00:00	SPY	ETF	776.75	777.93	776.66	777.74	2272863.0
2026-08-13 15:00:00	SPY	ETF	777.75	778.43	777.35	777.8	6611406.0
2026-08-13 16:00:00	SPY	ETF	777.8	778.02	777.0	777.95	3753881.0
2026-08-13 17:00:00	SPY	ETF	777.95	778.04	777.72	777.97	423280.0
2026-08-13 18:00:00	SPY	ETF	778.0	778.18	777.85	777.94	43196.0
2026-08-13 19:00:00	SPY	ETF	777.94	778.25	777.9246	778.12	35976.0
2026-08-13 04:00:00	QQQ	ETF	723.86	725.46	723.21	724.0572	147750.0
2026-08-13 05:00:00	QQQ	ETF	723.99	724.39	723.11	724.39	39380.0
2026-08-13 06:00:00	QQQ	ETF	724.37	724.56	724.05	724.49	38017.0
2026-08-13 07:00:00	QQQ	ETF	724.47	724.78	723.86	724.2	89296.0
2026-08-13 08:00:00	QQQ	ETF	724.22	724.69	722.8	724.42	240048.0
2026-08-13 09:00:00	QQQ	ETF	724.42	731.69	724.03	731.57	5883733.0
2026-08-13 10:00:00	QQQ	ETF	731.56	733.755	731.1	732.15	5055636.0
2026-08-13 11:00:00	QQQ	ETF	732.14	733.1	729.86	730.14	2700349.0
2026-08-13 12:00:00	QQQ	ETF	730.15	732.24	730.11	731.975	1489844.0
2026-08-13 13:00:00	QQQ	ETF	732.0	733.35	732.0	732.28	1576428.0
2026-08-13 14:00:00	QQQ	ETF	732.3	733.31	731.765	733.29	1662249.0
2026-08-13 15:00:00	QQQ	ETF	733.29	733.96	731.55	732.06	3278967.0
2026-08-13 16:00:00	QQQ	ETF	732.03	732.62	730.85	732.55	1498498.0
2026-08-13 17:00:00	QQQ	ETF	732.55	732.88	732.4	732.71	59422.0
2026-08-13 18:00:00	QQQ	ETF	732.71	732.71	732.0	732.307	61246.0
2026-08-13 19:00:00	QQQ	ETF	732.33	732.83	732.0	732.29	40319.0
2026-08-13 04:00:00	IWM	ETF	303.05	303.48	303.05	303.28	18790.0
2026-08-13 05:00:00	IWM	ETF	303.3	303.45	303.23	303.35	8101.0
2026-08-13 06:00:00	IWM	ETF	303.32	303.43	303.23	303.38	4509.0
2026-08-13 07:00:00	IWM	ETF	303.47	303.65	303.35	303.35	27498.0
2026-08-13 08:00:00	IWM	ETF	303.42	303.76	302.8	303.51	103601.0
2026-08-13 09:00:00	IWM	ETF	303.6	304.92	303.45	304.38	2549927.0
2026-08-13 10:00:00	IWM	ETF	304.36	305.05	303.65	303.76	1954492.0
2026-08-13 11:00:00	IWM	ETF	303.77	304.245	302.855	302.935	1319537.0
2026-08-13 12:00:00	IWM	ETF	302.945	303.335	302.72	303.23	1376870.0
2026-08-13 13:00:00	IWM	ETF	303.24	303.405	302.99	303.16	606842.0
2026-08-13 14:00:00	IWM	ETF	303.16	303.71	303.12	303.655	827642.0
2026-08-13 15:00:00	IWM	ETF	303.655	303.96	303.33	303.49	1991190.0
2026-08-13 16:00:00	IWM	ETF	303.5	303.62	303.35	303.51	568711.0
2026-08-13 17:00:00	IWM	ETF	303.4	303.8011	303.31	303.75	32817.0
2026-08-13 18:00:00	IWM	ETF	303.62	303.68	303.32	303.35	43186.0
2026-08-13 19:00:00	IWM	ETF	303.38	303.46	303.34	303.35	3161.0
2026-08-13 04:00:00	DIA	ETF	537.7	538.35	537.01	538.33	7540.0
2026-08-13 05:00:00	DIA	ETF	538.4	538.55	538.38	538.55	1926.0

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

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