PREVIEW / etf_1hour / 2026-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-16.parquet
  size:    718 KB
  rows:    28,579

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-16 04:00:00	SPY	ETF	753.31	756.22	752.51	754.12	62911.0
2026-07-16 05:00:00	SPY	ETF	754.119	754.65	753.62	753.65	23699.0
2026-07-16 06:00:00	SPY	ETF	753.64	753.866	753.24	753.46	67807.0
2026-07-16 07:00:00	SPY	ETF	753.4298	753.7	751.25	752.84	295032.0
2026-07-16 08:00:00	SPY	ETF	752.84	752.97	751.25	751.8352	265054.0
2026-07-16 09:00:00	SPY	ETF	751.81	753.52	750.67	751.905	3681695.0
2026-07-16 10:00:00	SPY	ETF	751.9	754.57	751.64	754.17	4360897.0
2026-07-16 11:00:00	SPY	ETF	754.2	754.44	752.98	753.57	2218732.0
2026-07-16 12:00:00	SPY	ETF	753.6	753.6	751.45	752.86	3050332.0
2026-07-16 13:00:00	SPY	ETF	752.88	752.91	751.08	751.31	2219505.0
2026-07-16 14:00:00	SPY	ETF	751.33	751.71	749.92	750.23	3697430.0
2026-07-16 15:00:00	SPY	ETF	750.22	751.04	747.88	750.76	11170037.0
2026-07-16 16:00:00	SPY	ETF	750.83	750.87	749.72	750.11	2063822.0
2026-07-16 17:00:00	SPY	ETF	750.16	750.35	749.83	750.3	39731.0
2026-07-16 18:00:00	SPY	ETF	750.4	750.5	749.5	749.59	101508.0
2026-07-16 19:00:00	SPY	ETF	749.52	749.79	748.78	749.09	37540.0
2026-07-16 04:00:00	QQQ	ETF	715.23	719.84	712.41	715.14	215431.0
2026-07-16 05:00:00	QQQ	ETF	715.4	716.25	713.57	713.62	74924.0
2026-07-16 06:00:00	QQQ	ETF	713.6	714.34	713.0	713.55	96686.0
2026-07-16 07:00:00	QQQ	ETF	713.66	713.669	709.64	711.7	364631.0
2026-07-16 08:00:00	QQQ	ETF	711.68	718.278	709.65	710.35	340963.0
2026-07-16 09:00:00	QQQ	ETF	710.29	713.599	707.0	709.175	3967284.0
2026-07-16 10:00:00	QQQ	ETF	709.09	713.07	708.54	711.35	3319067.0
2026-07-16 11:00:00	QQQ	ETF	711.41	712.02	708.92	710.22	2597939.0
2026-07-16 12:00:00	QQQ	ETF	710.25	710.3	707.11	708.8672	3300491.0
2026-07-16 13:00:00	QQQ	ETF	708.92	709.01	706.04	706.6	2625191.0
2026-07-16 14:00:00	QQQ	ETF	706.58	708.06	705.5	705.8	2534347.0
2026-07-16 15:00:00	QQQ	ETF	705.78	706.56	702.61	706.02	6321486.0
2026-07-16 16:00:00	QQQ	ETF	706.03	706.26	704.63	705.09	1171305.0
2026-07-16 17:00:00	QQQ	ETF	705.25	705.94	704.89	705.46	359294.0
2026-07-16 18:00:00	QQQ	ETF	705.54	706.0697	703.56	703.85	157023.0
2026-07-16 19:00:00	QQQ	ETF	704.07	704.2	702.2	702.89	203957.0
2026-07-16 04:00:00	IWM	ETF	294.75	296.34	294.22	294.88	44159.0
2026-07-16 05:00:00	IWM	ETF	295.0	295.11	294.6	294.66	15536.0
2026-07-16 06:00:00	IWM	ETF	294.63	294.83	294.45	294.52	76788.0
2026-07-16 07:00:00	IWM	ETF	294.5	294.9	293.94	294.77	73264.0
2026-07-16 08:00:00	IWM	ETF	294.81	294.81	294.09	294.29	92638.0
2026-07-16 09:00:00	IWM	ETF	294.2538	296.79	294.2538	296.52	2149798.0
2026-07-16 10:00:00	IWM	ETF	296.52	297.81	296.39	297.17	2524373.0
2026-07-16 11:00:00	IWM	ETF	297.19	297.33	296.27	296.45	1797153.0
2026-07-16 12:00:00	IWM	ETF	296.46	296.6	295.36	296.1	2756954.0
2026-07-16 13:00:00	IWM	ETF	296.12	296.22	294.9	295.0	1620390.0
2026-07-16 14:00:00	IWM	ETF	295.0	295.79	294.76	295.0	1599525.0
2026-07-16 15:00:00	IWM	ETF	295.0	295.7	294.345	295.62	3686379.0
2026-07-16 16:00:00	IWM	ETF	295.62	295.7	295.26	295.7	1008872.0
2026-07-16 17:00:00	IWM	ETF	295.55	295.71	295.32	295.71	16451.0
2026-07-16 18:00:00	IWM	ETF	295.75	295.83	295.41	295.43	38958.0
2026-07-16 19:00:00	IWM	ETF	295.42	295.42	295.13	295.13	16287.0
2026-07-16 04:00:00	DIA	ETF	526.73	526.73	525.47	525.95	1918.0
2026-07-16 05:00:00	DIA	ETF	525.95	527.43	525.36	527.43	52800.0

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

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