PREVIEW / etf_1hour / 2026-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-15.parquet
  size:    750 KB
  rows:    29,231

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-06-15 04:00:00	SPY	ETF	750.12	751.53	748.0	751.05	97781.0
2026-06-15 05:00:00	SPY	ETF	751.05	751.43	750.24	750.7	38083.0
2026-06-15 06:00:00	SPY	ETF	750.57	751.17	750.57	751.17	16320.0
2026-06-15 07:00:00	SPY	ETF	751.08	752.1	751.0	751.47	328960.0
2026-06-15 08:00:00	SPY	ETF	751.49	751.77	750.7	751.36	361055.0
2026-06-15 09:00:00	SPY	ETF	751.33	754.09	751.1	753.32	5141760.0
2026-06-15 10:00:00	SPY	ETF	753.32	754.39	752.51	754.1922	4162492.0
2026-06-15 11:00:00	SPY	ETF	754.2	756.28	754.2	756.14	4259186.0
2026-06-15 12:00:00	SPY	ETF	756.155	756.68	755.525	755.85	3049450.0
2026-06-15 13:00:00	SPY	ETF	755.84	756.35	755.07	755.205	2961862.0
2026-06-15 14:00:00	SPY	ETF	755.21	755.47	754.42	755.0	3602259.0
2026-06-15 15:00:00	SPY	ETF	755.01	755.25	753.4	754.66	12180817.0
2026-06-15 16:00:00	SPY	ETF	754.64	754.9	754.18	754.29	4789054.0
2026-06-15 17:00:00	SPY	ETF	754.288	754.8	754.26	754.55	90093.0
2026-06-15 18:00:00	SPY	ETF	754.51	754.71	753.08	753.5599	169934.0
2026-06-15 19:00:00	SPY	ETF	753.54	753.95	753.31	753.9	44379.0
2026-06-15 04:00:00	QQQ	ETF	733.6	737.91	733.6	737.03	352653.0
2026-06-15 05:00:00	QQQ	ETF	737.1	737.28	735.12	736.06	148758.0
2026-06-15 06:00:00	QQQ	ETF	735.96	736.48	735.64	736.29	79368.0
2026-06-15 07:00:00	QQQ	ETF	736.27	737.75	736.01	737.2	353026.0
2026-06-15 08:00:00	QQQ	ETF	737.18	737.66	735.76	736.84	392990.0
2026-06-15 09:00:00	QQQ	ETF	736.72	742.0	736.39	739.6798	6162602.0
2026-06-15 10:00:00	QQQ	ETF	739.69	741.95	738.94	741.446	4245166.0
2026-06-15 11:00:00	QQQ	ETF	741.44	744.16	741.35	743.97	3407186.0
2026-06-15 12:00:00	QQQ	ETF	743.98	744.7599	743.27	743.67	2108048.0
2026-06-15 13:00:00	QQQ	ETF	743.68	744.24	742.77	743.44	1567531.0
2026-06-15 14:00:00	QQQ	ETF	743.47	744.28	742.65	743.53	2169255.0
2026-06-15 15:00:00	QQQ	ETF	743.52	743.94	742.43	743.84	5331972.0
2026-06-15 16:00:00	QQQ	ETF	743.74	744.24	742.69	742.86	2362216.0
2026-06-15 17:00:00	QQQ	ETF	742.91	743.42	742.91	743.4	36988.0
2026-06-15 18:00:00	QQQ	ETF	743.37	743.6	741.1	742.26	186560.0
2026-06-15 19:00:00	QQQ	ETF	742.25	743.1	742.0	742.91	73299.0
2026-06-15 04:00:00	IWM	ETF	296.76	298.1	296.76	297.33	75799.0
2026-06-15 05:00:00	IWM	ETF	297.33	297.48	296.66	296.9	40095.0
2026-06-15 06:00:00	IWM	ETF	296.77	297.26	296.77	297.05	57964.0
2026-06-15 07:00:00	IWM	ETF	297.011	298.12	296.99	297.66	96378.0
2026-06-15 08:00:00	IWM	ETF	297.659	297.659	297.05	297.3	122019.0
2026-06-15 09:00:00	IWM	ETF	297.37	297.91	296.38	296.81	3431999.0
2026-06-15 10:00:00	IWM	ETF	296.83	296.89	294.76	294.855	3321314.0
2026-06-15 11:00:00	IWM	ETF	294.84	296.215	294.77	296.03	2931200.0
2026-06-15 12:00:00	IWM	ETF	296.04	296.31	295.45	295.625	1700250.0
2026-06-15 13:00:00	IWM	ETF	295.62	295.77	295.04	295.2099	1014414.0
2026-06-15 14:00:00	IWM	ETF	295.21	295.31	294.635	294.7	1573352.0
2026-06-15 15:00:00	IWM	ETF	294.71	294.93	293.92	294.67	3172732.0
2026-06-15 16:00:00	IWM	ETF	294.64	294.95	294.45	294.59	982687.0
2026-06-15 17:00:00	IWM	ETF	294.63	294.94	294.53	294.85	7416.0
2026-06-15 18:00:00	IWM	ETF	294.72	294.73	293.85	294.26	42135.0
2026-06-15 19:00:00	IWM	ETF	294.19	294.44	294.14	294.44	19191.0
2026-06-15 04:00:00	DIA	ETF	517.89	518.49	517.44	517.78	6149.0
2026-06-15 05:00:00	DIA	ETF	517.53	517.6	517.41	517.41	632.0

> showing 50 of 29,231 rows — these rows as CSV

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