PREVIEW / etf_1hour / 2025-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-16.parquet
  size:    637 KB
  rows:    24,301

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-16 04:00:00	SPY	ETF	591.13	591.95	590.53	591.64	35609.0
2025-05-16 05:00:00	SPY	ETF	591.68	591.79	591.28	591.31	19144.0
2025-05-16 06:00:00	SPY	ETF	591.22	591.96	591.17	591.63	29436.0
2025-05-16 07:00:00	SPY	ETF	591.65	592.34	591.47	592.23	149447.0
2025-05-16 08:00:00	SPY	ETF	591.97	592.57	589.42	591.27	405253.0
2025-05-16 09:00:00	SPY	ETF	591.26	591.82	590.01	591.36	4628789.0
2025-05-16 10:00:00	SPY	ETF	591.31	591.63	589.28	590.46	6343214.0
2025-05-16 11:00:00	SPY	ETF	590.46	591.62	590.385	591.045	3776920.0
2025-05-16 12:00:00	SPY	ETF	591.04	592.51	590.92	592.23	4092174.0
2025-05-16 13:00:00	SPY	ETF	592.25	593.48	592.0949	592.82	4365911.0
2025-05-16 14:00:00	SPY	ETF	592.82	594.0299	592.66	593.57	4390515.0
2025-05-16 15:00:00	SPY	ETF	593.565	594.5	593.19	594.29	10250941.0
2025-05-16 16:00:00	SPY	ETF	594.29	594.3897	590.7	591.55	4308276.0
2025-05-16 17:00:00	SPY	ETF	591.7	592.2	590.35	590.72	739801.0
2025-05-16 18:00:00	SPY	ETF	590.72	594.4197	588.43	588.87	969756.0
2025-05-16 19:00:00	SPY	ETF	588.87	589.5	588.2	588.25	143669.0
2025-05-16 04:00:00	QQQ	ETF	519.02	520.95	519.02	520.55	64417.0
2025-05-16 05:00:00	QQQ	ETF	520.6	520.65	520.0	520.0	44958.0
2025-05-16 06:00:00	QQQ	ETF	519.98	520.76	519.81	520.45	61879.0
2025-05-16 07:00:00	QQQ	ETF	520.48	521.13	520.24	520.93	115593.0
2025-05-16 08:00:00	QQQ	ETF	520.56	521.5	518.15	519.99	416176.0
2025-05-16 09:00:00	QQQ	ETF	520.0	522.0	518.79	519.97	4574957.0
2025-05-16 10:00:00	QQQ	ETF	520.0	520.37	517.1	518.7868	5867966.0
2025-05-16 11:00:00	QQQ	ETF	518.79	520.02	518.39	519.295	2917430.0
2025-05-16 12:00:00	QQQ	ETF	519.295	520.24	519.14	519.66	2708758.0
2025-05-16 13:00:00	QQQ	ETF	519.67	520.8791	519.49	520.09	2870006.0
2025-05-16 14:00:00	QQQ	ETF	520.1	521.25	519.88	520.8486	3078063.0
2025-05-16 15:00:00	QQQ	ETF	520.85	521.7	520.495	521.52	6043966.0
2025-05-16 16:00:00	QQQ	ETF	521.52	521.63	518.66	519.08	1803472.0
2025-05-16 17:00:00	QQQ	ETF	519.18	519.91	517.33	517.4301	326186.0
2025-05-16 18:00:00	QQQ	ETF	517.47	517.5	514.6	515.1021	279225.0
2025-05-16 19:00:00	QQQ	ETF	515.2	516.49	514.1	514.62	197480.0
2025-05-16 04:00:00	IWM	ETF	208.48	208.74	208.39	208.61	31186.0
2025-05-16 05:00:00	IWM	ETF	208.64	209.23	208.61	209.23	10985.0
2025-05-16 06:00:00	IWM	ETF	209.1	209.77	209.07	209.49	60700.0
2025-05-16 07:00:00	IWM	ETF	209.49	209.71	209.4	209.65	55492.0
2025-05-16 08:00:00	IWM	ETF	209.47	209.75	208.22	209.22	100840.0
2025-05-16 09:00:00	IWM	ETF	209.26	209.35	207.81	208.89	2818080.0
2025-05-16 10:00:00	IWM	ETF	208.87	208.89	207.78	208.3	3379070.0
2025-05-16 11:00:00	IWM	ETF	208.31	208.75	208.2	208.7	2090071.0
2025-05-16 12:00:00	IWM	ETF	208.69	209.375	208.685	209.215	1798464.0
2025-05-16 13:00:00	IWM	ETF	209.21	209.75	209.07	209.43	1843550.0
2025-05-16 14:00:00	IWM	ETF	209.42	209.99	209.375	209.82	1211608.0
2025-05-16 15:00:00	IWM	ETF	209.82	210.13	209.64	209.91	4007302.0
2025-05-16 16:00:00	IWM	ETF	209.85	209.93	208.19	208.69	1120642.0
2025-05-16 17:00:00	IWM	ETF	208.72	209.24	208.2	208.2	197899.0
2025-05-16 18:00:00	IWM	ETF	208.2	208.42	206.62	207.38	39565.0
2025-05-16 19:00:00	IWM	ETF	207.37	207.39	206.81	207.3	25394.0
2025-05-16 04:00:00	DIA	ETF	423.98	424.27	423.98	424.27	796.0
2025-05-16 05:00:00	DIA	ETF	424.39	424.49	424.33	424.43	1051.0

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

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