PREVIEW / etf_1hour / 2026-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-14.parquet
  size:    704 KB
  rows:    28,296

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-14 04:00:00	SPY	ETF	747.89	750.42	746.91	748.41	74319.0
2026-07-14 05:00:00	SPY	ETF	748.18	749.2902	748.18	748.72	26528.0
2026-07-14 06:00:00	SPY	ETF	748.6681	749.54	748.4	748.64	50058.0
2026-07-14 07:00:00	SPY	ETF	748.72	749.4	747.37	748.48	341520.0
2026-07-14 08:00:00	SPY	ETF	748.5	754.24	747.51	750.9	1099835.0
2026-07-14 09:00:00	SPY	ETF	750.92	751.79	749.44	751.31	3534909.0
2026-07-14 10:00:00	SPY	ETF	751.32	753.34	748.66	751.71	4611380.0
2026-07-14 11:00:00	SPY	ETF	751.71	753.08	750.62	750.98	3227254.0
2026-07-14 12:00:00	SPY	ETF	750.99	751.85	750.0	751.85	2444520.0
2026-07-14 13:00:00	SPY	ETF	751.87	752.61	751.5	752.275	1712876.0
2026-07-14 14:00:00	SPY	ETF	752.28	752.77	751.66	752.1704	2327756.0
2026-07-14 15:00:00	SPY	ETF	752.19	752.52	751.71	751.85	6232308.0
2026-07-14 16:00:00	SPY	ETF	751.89	752.18	751.52	752.07	2053728.0
2026-07-14 17:00:00	SPY	ETF	751.99	752.1	751.84	751.89	57316.0
2026-07-14 18:00:00	SPY	ETF	751.92	752.11	751.3104	751.87	35764.0
2026-07-14 19:00:00	SPY	ETF	751.77	753.25	751.75	753.1	48590.0
2026-07-14 04:00:00	QQQ	ETF	713.43	716.16	709.6	714.53	284568.0
2026-07-14 05:00:00	QQQ	ETF	714.38	715.75	714.07	715.02	45400.0
2026-07-14 06:00:00	QQQ	ETF	715.01	715.83	714.52	715.15	63507.0
2026-07-14 07:00:00	QQQ	ETF	715.19	716.71	714.0	715.821	331163.0
2026-07-14 08:00:00	QQQ	ETF	715.8416	722.72	714.34	719.21	1141183.0
2026-07-14 09:00:00	QQQ	ETF	719.22	720.61	717.12	719.39	3368239.0
2026-07-14 10:00:00	QQQ	ETF	719.43	720.93	714.34	719.3	4521063.0
2026-07-14 11:00:00	QQQ	ETF	719.37	722.29	718.86	719.65	2904287.0
2026-07-14 12:00:00	QQQ	ETF	719.73	720.7106	717.72	720.62	1814132.0
2026-07-14 13:00:00	QQQ	ETF	720.63	721.57	720.14	721.51	1337390.0
2026-07-14 14:00:00	QQQ	ETF	721.51	721.87	720.07	720.592	1318178.0
2026-07-14 15:00:00	QQQ	ETF	720.59	720.91	719.29	719.65	2941261.0
2026-07-14 16:00:00	QQQ	ETF	719.69	720.1	719.25	719.91	1056232.0
2026-07-14 17:00:00	QQQ	ETF	719.91	720.1	719.78	719.78	30838.0
2026-07-14 18:00:00	QQQ	ETF	719.83	719.98	718.68	719.42	72446.0
2026-07-14 19:00:00	QQQ	ETF	719.34	722.35	719.0108	722.09	117318.0
2026-07-14 04:00:00	IWM	ETF	293.25	294.09	292.5	292.66	30980.0
2026-07-14 05:00:00	IWM	ETF	292.56	293.32	292.56	293.11	38715.0
2026-07-14 06:00:00	IWM	ETF	293.12	293.77	292.99	293.31	55469.0
2026-07-14 07:00:00	IWM	ETF	293.38	294.0	293.04	293.64	45995.0
2026-07-14 08:00:00	IWM	ETF	293.64	299.23	293.1	295.56	835361.0
2026-07-14 09:00:00	IWM	ETF	295.63	296.065	294.6101	294.91	2606159.0
2026-07-14 10:00:00	IWM	ETF	294.935	295.92	293.75	294.61	2593148.0
2026-07-14 11:00:00	IWM	ETF	294.62	295.41	293.99	294.68	1583845.0
2026-07-14 12:00:00	IWM	ETF	294.675	294.92	294.3	294.53	750537.0
2026-07-14 13:00:00	IWM	ETF	294.53	294.62	294.16	294.45	868762.0
2026-07-14 14:00:00	IWM	ETF	294.43	294.92	294.09	294.41	802885.0
2026-07-14 15:00:00	IWM	ETF	294.42	294.67	294.04	294.49	2166222.0
2026-07-14 16:00:00	IWM	ETF	294.51	294.7	294.2	294.53	746986.0
2026-07-14 17:00:00	IWM	ETF	294.63	294.63	294.3	294.49	15561.0
2026-07-14 18:00:00	IWM	ETF	294.49	294.6	293.96	294.37	17098.0
2026-07-14 19:00:00	IWM	ETF	294.41	294.94	294.41	294.9	18973.0
2026-07-14 04:00:00	DIA	ETF	523.23	524.23	522.67	522.68	10887.0
2026-07-14 05:00:00	DIA	ETF	522.85	523.45	522.85	523.268	710.0

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

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