PREVIEW / etf_1hour / 2025-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-15.parquet
  size:    629 KB
  rows:    24,505

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
2025-05-15 04:00:00	SPY	ETF	584.88	584.97	583.52	583.73	90015.0
2025-05-15 05:00:00	SPY	ETF	583.66	584.82	583.4	584.8	25938.0
2025-05-15 06:00:00	SPY	ETF	584.63	584.75	584.22	584.56	43005.0
2025-05-15 07:00:00	SPY	ETF	584.57	585.56	584.48	585.08	131792.0
2025-05-15 08:00:00	SPY	ETF	584.56	586.48	584.0596	585.38	991163.0
2025-05-15 09:00:00	SPY	ETF	585.39	586.4699	585.0969	586.14	5331401.0
2025-05-15 10:00:00	SPY	ETF	586.13	587.13	585.31	586.64	6535713.0
2025-05-15 11:00:00	SPY	ETF	586.64	589.42	586.48	589.08	6696945.0
2025-05-15 12:00:00	SPY	ETF	589.09	590.2	588.7713	590.17	4636742.0
2025-05-15 13:00:00	SPY	ETF	590.1875	590.97	589.73	589.8999	4727705.0
2025-05-15 14:00:00	SPY	ETF	589.895	590.33	588.69	589.72	5187326.0
2025-05-15 15:00:00	SPY	ETF	589.73	590.44	588.305	590.41	13063183.0
2025-05-15 16:00:00	SPY	ETF	590.41	590.72	589.93	590.0	3057478.0
2025-05-15 17:00:00	SPY	ETF	590.05	590.2	589.98	590.08	61407.0
2025-05-15 18:00:00	SPY	ETF	590.08	590.189	589.76	589.76	91878.0
2025-05-15 19:00:00	SPY	ETF	589.78	590.24	589.6531	590.16	25535.0
2025-05-15 20:00:00	SPY	ETF	590.18	590.18	590.18	590.18	100.0
2025-05-15 04:00:00	QQQ	ETF	516.97	517.47	514.0	514.39	135314.0
2025-05-15 05:00:00	QQQ	ETF	514.31	515.53	513.81	515.42	118876.0
2025-05-15 06:00:00	QQQ	ETF	515.37	515.37	514.63	515.19	170277.0
2025-05-15 07:00:00	QQQ	ETF	515.19	516.66	515.1	515.79	205947.0
2025-05-15 08:00:00	QQQ	ETF	514.18	518.54	514.0596	516.18	594955.0
2025-05-15 09:00:00	QQQ	ETF	516.18	517.38	515.17	516.4	4297711.0
2025-05-15 10:00:00	QQQ	ETF	516.39	517.525	515.39	517.2409	4215275.0
2025-05-15 11:00:00	QQQ	ETF	517.26	519.92	517.075	519.5009	4565284.0
2025-05-15 12:00:00	QQQ	ETF	519.52	521.04	519.29	521.01	3515938.0
2025-05-15 13:00:00	QQQ	ETF	521.015	521.93	520.48	520.63	3248774.0
2025-05-15 14:00:00	QQQ	ETF	520.63	520.63	518.24	518.63	4461243.0
2025-05-15 15:00:00	QQQ	ETF	518.62	519.39	516.48	519.29	7559066.0
2025-05-15 16:00:00	QQQ	ETF	519.31	521.2773	518.75	518.75	1377244.0
2025-05-15 17:00:00	QQQ	ETF	518.77	519.02	518.75	518.8	80479.0
2025-05-15 18:00:00	QQQ	ETF	518.77	518.87	518.43	518.6	64920.0
2025-05-15 19:00:00	QQQ	ETF	518.47	519.18	518.46	519.17	43036.0
2025-05-15 04:00:00	IWM	ETF	206.19	206.47	206.03	206.15	31311.0
2025-05-15 05:00:00	IWM	ETF	206.15	206.5	206.02	206.47	20669.0
2025-05-15 06:00:00	IWM	ETF	206.22	206.35	206.05	206.31	8719.0
2025-05-15 07:00:00	IWM	ETF	206.34	206.6	206.04	206.59	115130.0
2025-05-15 08:00:00	IWM	ETF	206.25	207.22	206.1301	206.6	259315.0
2025-05-15 09:00:00	IWM	ETF	206.55	207.08	206.04	206.22	2486690.0
2025-05-15 10:00:00	IWM	ETF	206.25	206.53	205.39	206.2	2395875.0
2025-05-15 11:00:00	IWM	ETF	206.21	207.37	206.14	207.34	2096362.0
2025-05-15 12:00:00	IWM	ETF	207.33	207.655	207.06	207.64	1619739.0
2025-05-15 13:00:00	IWM	ETF	207.63	207.92	207.46	207.63	1258618.0
2025-05-15 14:00:00	IWM	ETF	207.635	207.885	207.455	207.79	1518413.0
2025-05-15 15:00:00	IWM	ETF	207.78	208.19	207.55	208.15	3595500.0
2025-05-15 16:00:00	IWM	ETF	208.13	208.47	208.08	208.25	1310125.0
2025-05-15 17:00:00	IWM	ETF	208.2	208.34	208.17	208.2	19791.0
2025-05-15 18:00:00	IWM	ETF	208.28	208.32	208.16	208.2	9525.0
2025-05-15 19:00:00	IWM	ETF	208.15	208.38	208.14	208.29	10742.0
2025-05-15 04:00:00	DIA	ETF	418.09	418.97	418.09	418.74	9063.0

> showing 50 of 24,505 rows — these rows as CSV

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