PREVIEW / etf_1hour / 2026-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-07-13.parquet
  size:    715 KB
  rows:    28,574

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-13 04:00:00	SPY	ETF	752.01	752.86	749.85	752.7	105098.0
2026-07-13 05:00:00	SPY	ETF	752.77	753.27	752.4	753.0316	38404.0
2026-07-13 06:00:00	SPY	ETF	753.06	753.07	752.58	752.63	37051.0
2026-07-13 07:00:00	SPY	ETF	752.7	753.29	752.12	752.33	257825.0
2026-07-13 08:00:00	SPY	ETF	752.3603	752.71	751.55	752.59	275306.0
2026-07-13 09:00:00	SPY	ETF	752.66	753.91	751.92	753.62	3128238.0
2026-07-13 10:00:00	SPY	ETF	753.63	753.9105	750.3	752.7401	5382677.0
2026-07-13 11:00:00	SPY	ETF	752.74	753.055	751.0945	751.235	2116183.0
2026-07-13 12:00:00	SPY	ETF	751.23	751.81	748.93	749.87	3919628.0
2026-07-13 13:00:00	SPY	ETF	749.9	750.64	749.21	749.235	2621521.0
2026-07-13 14:00:00	SPY	ETF	749.26	750.21	748.9702	749.56	3475507.0
2026-07-13 15:00:00	SPY	ETF	749.58	749.97	748.0	749.1	9432456.0
2026-07-13 16:00:00	SPY	ETF	749.12	749.17	747.59	748.32	2003951.0
2026-07-13 17:00:00	SPY	ETF	748.43	748.5	748.15	748.36	45166.0
2026-07-13 18:00:00	SPY	ETF	748.41	749.07	747.94	748.02	134508.0
2026-07-13 19:00:00	SPY	ETF	748.0	748.25	747.08	748.13	76323.0
2026-07-13 04:00:00	QQQ	ETF	716.85	718.79	713.96	718.49	477577.0
2026-07-13 05:00:00	QQQ	ETF	718.6	719.35	717.95	719.24	84766.0
2026-07-13 06:00:00	QQQ	ETF	719.23	719.36	718.35	718.77	59492.0
2026-07-13 07:00:00	QQQ	ETF	718.89	719.91	718.19	718.51	263728.0
2026-07-13 08:00:00	QQQ	ETF	718.51	726.054	716.4801	717.8917	434925.0
2026-07-13 09:00:00	QQQ	ETF	717.9401	718.66	713.15	715.77	5229098.0
2026-07-13 10:00:00	QQQ	ETF	715.85	718.1	712.56	717.91	4470320.0
2026-07-13 11:00:00	QQQ	ETF	717.93	718.74	715.0	715.36	1991168.0
2026-07-13 12:00:00	QQQ	ETF	715.3301	715.975	711.7	713.26	2970130.0
2026-07-13 13:00:00	QQQ	ETF	713.25	714.55	711.8	712.05	2618340.0
2026-07-13 14:00:00	QQQ	ETF	712.11	713.51	711.525	712.42	2807452.0
2026-07-13 15:00:00	QQQ	ETF	712.46	713.2288	710.08	711.77	5272393.0
2026-07-13 16:00:00	QQQ	ETF	711.79	711.96	709.88	711.0	1621835.0
2026-07-13 17:00:00	QQQ	ETF	711.04	711.74	710.88	711.42	87898.0
2026-07-13 18:00:00	QQQ	ETF	711.35	712.05	710.15	710.22	88199.0
2026-07-13 19:00:00	QQQ	ETF	710.2	710.62	708.5	710.55	138988.0
2026-07-13 04:00:00	IWM	ETF	295.2	295.94	293.25	295.91	43509.0
2026-07-13 05:00:00	IWM	ETF	295.82	296.01	295.7	295.7	15886.0
2026-07-13 06:00:00	IWM	ETF	295.65	295.68	295.34	295.47	50955.0
2026-07-13 07:00:00	IWM	ETF	295.5	295.7	294.83	294.83	42970.0
2026-07-13 08:00:00	IWM	ETF	294.91	295.29	294.6	295.15	264086.0
2026-07-13 09:00:00	IWM	ETF	295.16	295.78	294.37	295.375	1651366.0
2026-07-13 10:00:00	IWM	ETF	295.34	295.59	292.89	294.64	2852308.0
2026-07-13 11:00:00	IWM	ETF	294.64	294.82	293.92	294.0189	752095.0
2026-07-13 12:00:00	IWM	ETF	294.01	294.32	292.9	293.56	1862125.0
2026-07-13 13:00:00	IWM	ETF	293.58	294.05	292.87	293.01	2021975.0
2026-07-13 14:00:00	IWM	ETF	293.02	293.68	292.6	293.26	2119250.0
2026-07-13 15:00:00	IWM	ETF	293.28	293.56	292.68	293.46	3780870.0
2026-07-13 16:00:00	IWM	ETF	293.48	293.53	292.76	293.02	829897.0
2026-07-13 17:00:00	IWM	ETF	292.9348	293.08	292.7	293.01	4519.0
2026-07-13 18:00:00	IWM	ETF	293.08	293.38	292.64	292.65	126493.0
2026-07-13 19:00:00	IWM	ETF	292.64	292.95	292.38	292.95	43333.0
2026-07-13 04:00:00	DIA	ETF	523.54	525.84	523.47	525.84	2169.0
2026-07-13 05:00:00	DIA	ETF	526.09	526.37	526.09	526.37	200.0

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

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