PREVIEW / etf_1hour / 2026-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-17.parquet
  size:    727 KB
  rows:    28,859

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-17 04:00:00	SPY	ETF	777.27	777.88	777.0	777.47	45950.0
2026-08-17 05:00:00	SPY	ETF	777.53	777.61	777.26	777.26	10199.0
2026-08-17 06:00:00	SPY	ETF	777.37	778.23	777.11	777.52	28886.0
2026-08-17 07:00:00	SPY	ETF	777.47	777.65	777.12	777.15	144917.0
2026-08-17 08:00:00	SPY	ETF	777.17	777.31	776.0	776.19	259087.0
2026-08-17 09:00:00	SPY	ETF	776.2	776.775	775.18	775.2906	2483106.0
2026-08-17 10:00:00	SPY	ETF	775.265	775.77	774.89	775.27	3174684.0
2026-08-17 11:00:00	SPY	ETF	775.27	775.86	774.71	775.3	2335208.0
2026-08-17 12:00:00	SPY	ETF	775.295	775.61	774.61	774.68	1787768.0
2026-08-17 13:00:00	SPY	ETF	774.67	774.78	773.1	773.41	3245675.0
2026-08-17 14:00:00	SPY	ETF	773.42	773.82	773.23	773.535	2693953.0
2026-08-17 15:00:00	SPY	ETF	773.535	773.59	772.51	772.68	8067436.0
2026-08-17 16:00:00	SPY	ETF	772.67	772.8	772.22	772.4	2130825.0
2026-08-17 17:00:00	SPY	ETF	772.41	772.67	772.39	772.5338	635626.0
2026-08-17 18:00:00	SPY	ETF	772.54	772.71	772.17	772.44	53697.0
2026-08-17 19:00:00	SPY	ETF	772.31	772.7	772.24	772.7	63536.0
2026-08-17 04:00:00	QQQ	ETF	735.21	735.64	733.34	734.85	161898.0
2026-08-17 05:00:00	QQQ	ETF	734.85	734.85	734.14	734.45	50934.0
2026-08-17 06:00:00	QQQ	ETF	734.4	735.86	734.32	735.15	78780.0
2026-08-17 07:00:00	QQQ	ETF	735.23	735.43	734.54	734.54	202026.0
2026-08-17 08:00:00	QQQ	ETF	734.59	734.59	730.522	732.52	259276.0
2026-08-17 09:00:00	QQQ	ETF	732.56	734.08	731.64	733.3	2612110.0
2026-08-17 10:00:00	QQQ	ETF	733.3395	733.62	731.51	733.56	3026147.0
2026-08-17 11:00:00	QQQ	ETF	733.57	734.58	732.73	733.4999	3105003.0
2026-08-17 12:00:00	QQQ	ETF	733.47	733.55	731.9513	732.135	2097913.0
2026-08-17 13:00:00	QQQ	ETF	732.13	732.22	729.8	730.17	2811620.0
2026-08-17 14:00:00	QQQ	ETF	730.18	731.0	729.63	730.66	1587016.0
2026-08-17 15:00:00	QQQ	ETF	730.66	730.72	729.27	729.85	3424310.0
2026-08-17 16:00:00	QQQ	ETF	729.82	729.9862	729.02	729.52	768776.0
2026-08-17 17:00:00	QQQ	ETF	729.47	729.78	729.3	729.53	97178.0
2026-08-17 18:00:00	QQQ	ETF	729.54	729.84	729.31	729.5414	57456.0
2026-08-17 19:00:00	QQQ	ETF	729.55	730.1	729.34	729.96	57755.0
2026-08-17 04:00:00	IWM	ETF	304.94	305.2	304.57	304.7	32385.0
2026-08-17 05:00:00	IWM	ETF	304.73	304.82	304.63	304.64	13768.0
2026-08-17 06:00:00	IWM	ETF	304.67	305.53	304.66	304.86	21599.0
2026-08-17 07:00:00	IWM	ETF	304.8499	304.89	304.43	304.56	55659.0
2026-08-17 08:00:00	IWM	ETF	304.55	304.63	303.65	303.91	125344.0
2026-08-17 09:00:00	IWM	ETF	303.93	304.2	303.47	303.485	1452547.0
2026-08-17 10:00:00	IWM	ETF	303.49	304.33	303.23	304.07	1784706.0
2026-08-17 11:00:00	IWM	ETF	304.05	304.25	303.415	303.925	1433963.0
2026-08-17 12:00:00	IWM	ETF	303.925	304.24	303.89	304.145	1175665.0
2026-08-17 13:00:00	IWM	ETF	304.16	304.295	303.26	303.42	1491654.0
2026-08-17 14:00:00	IWM	ETF	303.41	303.78	303.23	303.7	1347963.0
2026-08-17 15:00:00	IWM	ETF	303.71	304.15	303.56	304.07	2524177.0
2026-08-17 16:00:00	IWM	ETF	304.06	304.11	303.88	304.03	681976.0
2026-08-17 17:00:00	IWM	ETF	304.07	304.16	303.93	304.05	69325.0
2026-08-17 18:00:00	IWM	ETF	304.01	304.04	303.73	303.95	23921.0
2026-08-17 19:00:00	IWM	ETF	303.94	304.07	303.81	304.07	10995.0
2026-08-17 04:00:00	DIA	ETF	536.32	536.35	535.77	535.77	6337.0
2026-08-17 05:00:00	DIA	ETF	536.2	536.2	535.9	535.9	186.0

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

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