PREVIEW / etf_1hour / 2026-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-08-14.parquet
  size:    706 KB
  rows:    27,691

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-14 04:00:00	SPY	ETF	778.08	778.64	777.82	778.48	46361.0
2026-08-14 05:00:00	SPY	ETF	778.41	778.54	778.21	778.525	6180.0
2026-08-14 06:00:00	SPY	ETF	778.55	778.72	778.38	778.63	14237.0
2026-08-14 07:00:00	SPY	ETF	778.631	778.84	778.41	778.66	63087.0
2026-08-14 08:00:00	SPY	ETF	778.67	778.92	777.91	778.77	195448.0
2026-08-14 09:00:00	SPY	ETF	778.81	778.82	777.66	778.29	2480391.0
2026-08-14 10:00:00	SPY	ETF	778.25	778.8	776.74	776.74	3151420.0
2026-08-14 11:00:00	SPY	ETF	776.745	777.11	775.81	776.22	3528767.0
2026-08-14 12:00:00	SPY	ETF	776.23	776.82	775.66	775.7	2410148.0
2026-08-14 13:00:00	SPY	ETF	775.7	776.13	775.4301	775.83	1834376.0
2026-08-14 14:00:00	SPY	ETF	775.835	776.4919	775.73	776.19	2239710.0
2026-08-14 15:00:00	SPY	ETF	776.19	776.42	775.83	776.3	4420463.0
2026-08-14 16:00:00	SPY	ETF	776.3	776.36	775.76	776.03	2113328.0
2026-08-14 17:00:00	SPY	ETF	776.0202	776.38	775.95	776.08	1061443.0
2026-08-14 18:00:00	SPY	ETF	776.09	776.2	776.045	776.1665	13015.0
2026-08-14 19:00:00	SPY	ETF	776.11	776.27	776.01	776.01	20495.0
2026-08-14 04:00:00	QQQ	ETF	732.5	733.39	730.87	733.1	135567.0
2026-08-14 05:00:00	QQQ	ETF	732.94	733.31	732.67	733.31	25947.0
2026-08-14 06:00:00	QQQ	ETF	733.28	733.67	733.06	733.65	34701.0
2026-08-14 07:00:00	QQQ	ETF	733.69	734.11	733.435	733.95	175725.0
2026-08-14 08:00:00	QQQ	ETF	733.99	734.34	731.521	734.05	212599.0
2026-08-14 09:00:00	QQQ	ETF	734.1	734.41	731.7201	733.05	2444344.0
2026-08-14 10:00:00	QQQ	ETF	733.03	734.16	730.6	730.6	2803148.0
2026-08-14 11:00:00	QQQ	ETF	730.6	731.05	728.32	729.225	2770091.0
2026-08-14 12:00:00	QQQ	ETF	729.22	730.215	728.86	729.02	1879901.0
2026-08-14 13:00:00	QQQ	ETF	729.04	729.61	728.75	729.545	1394192.0
2026-08-14 14:00:00	QQQ	ETF	729.53	730.08	729.09	729.69	1479680.0
2026-08-14 15:00:00	QQQ	ETF	729.7	731.125	729.4	731.03	3581717.0
2026-08-14 16:00:00	QQQ	ETF	731.04	731.23	730.65	731.19	1074626.0
2026-08-14 17:00:00	QQQ	ETF	731.1	731.25	730.8	730.99	45441.0
2026-08-14 18:00:00	QQQ	ETF	731.0	731.21	730.9	731.07	20535.0
2026-08-14 19:00:00	QQQ	ETF	731.0682	731.1	730.81	730.85	19797.0
2026-08-14 04:00:00	IWM	ETF	303.16	303.49	302.97	303.38	16530.0
2026-08-14 05:00:00	IWM	ETF	303.35	303.49	303.3	303.42	2765.0
2026-08-14 06:00:00	IWM	ETF	303.53	303.64	303.41	303.48	2947.0
2026-08-14 07:00:00	IWM	ETF	303.47	303.62	303.25	303.42	21794.0
2026-08-14 08:00:00	IWM	ETF	303.5047	303.86	303.11	303.74	78534.0
2026-08-14 09:00:00	IWM	ETF	303.74	304.38	302.74	304.16	1837460.0
2026-08-14 10:00:00	IWM	ETF	304.13	304.89	304.02	304.41	1757694.0
2026-08-14 11:00:00	IWM	ETF	304.41	304.76	303.78	304.22	1442848.0
2026-08-14 12:00:00	IWM	ETF	304.24	304.76	304.09	304.205	1182650.0
2026-08-14 13:00:00	IWM	ETF	304.21	304.76	304.15	304.43	910381.0
2026-08-14 14:00:00	IWM	ETF	304.435	304.64	304.265	304.45	728588.0
2026-08-14 15:00:00	IWM	ETF	304.45	305.18	304.28	305.075	2400467.0
2026-08-14 16:00:00	IWM	ETF	305.09	305.09	304.66	304.69	654288.0
2026-08-14 17:00:00	IWM	ETF	304.98	304.98	304.7	304.77	238803.0
2026-08-14 18:00:00	IWM	ETF	304.87	305.03	304.87	304.97	4793.0
2026-08-14 19:00:00	IWM	ETF	304.935	305.0194	304.85	304.9	8559.0
2026-08-14 04:00:00	DIA	ETF	537.54	538.42	537.24	537.43	2398.0
2026-08-14 06:00:00	DIA	ETF	537.4	537.4	537.21	537.21	610.0

> showing 50 of 27,691 rows — these rows as CSV

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