PREVIEW / etf_1hour / 2025-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-18.parquet
  size:    641 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-06-18 04:00:00	SPY	ETF	599.02	599.47	598.22	599.35	73543.0
2025-06-18 05:00:00	SPY	ETF	599.35	600.05	599.31	599.39	42666.0
2025-06-18 06:00:00	SPY	ETF	599.31	599.31	597.41	597.5	128654.0
2025-06-18 07:00:00	SPY	ETF	597.51	599.19	597.39	598.7	130306.0
2025-06-18 08:00:00	SPY	ETF	597.66	599.5	597.082	598.08	184636.0
2025-06-18 09:00:00	SPY	ETF	598.18	599.5882	597.36	599.12	4794490.0
2025-06-18 10:00:00	SPY	ETF	599.13	601.22	598.73	600.84	6110618.0
2025-06-18 11:00:00	SPY	ETF	600.83	600.9	599.62	599.7393	3293386.0
2025-06-18 12:00:00	SPY	ETF	599.72	600.32	599.38	599.465	3003769.0
2025-06-18 13:00:00	SPY	ETF	599.46	599.9699	598.04	599.52	3904120.0
2025-06-18 14:00:00	SPY	ETF	599.61	601.0	596.67	597.27	9861688.0
2025-06-18 15:00:00	SPY	ETF	597.27	598.93	596.47	597.46	14315897.0
2025-06-18 16:00:00	SPY	ETF	597.45	598.245	597.41	597.5	3886490.0
2025-06-18 17:00:00	SPY	ETF	597.5	597.7	596.6	597.35	175229.0
2025-06-18 18:00:00	SPY	ETF	597.39	597.57	596.54	596.9	118542.0
2025-06-18 19:00:00	SPY	ETF	596.97	597.3101	596.8	597.29	51213.0
2025-06-18 04:00:00	QQQ	ETF	530.46	531.15	529.62	531.01	50247.0
2025-06-18 05:00:00	QQQ	ETF	531.03	531.72	530.98	531.02	46943.0
2025-06-18 06:00:00	QQQ	ETF	530.98	531.03	529.15	529.27	55030.0
2025-06-18 07:00:00	QQQ	ETF	529.21	530.99	529.14	530.34	128903.0
2025-06-18 08:00:00	QQQ	ETF	530.88	531.5804	529.0	529.91	223534.0
2025-06-18 09:00:00	QQQ	ETF	529.95	530.86	528.48	530.28	3109726.0
2025-06-18 10:00:00	QQQ	ETF	530.29	532.55	529.78	532.11	5229639.0
2025-06-18 11:00:00	QQQ	ETF	532.1	532.24	531.0201	531.14	2645601.0
2025-06-18 12:00:00	QQQ	ETF	531.13	531.78	530.73	530.87	1817501.0
2025-06-18 13:00:00	QQQ	ETF	530.87	531.14	528.78	530.75	3245236.0
2025-06-18 14:00:00	QQQ	ETF	530.83	532.08	527.59	528.21	6457168.0
2025-06-18 15:00:00	QQQ	ETF	528.23	530.48	527.4	528.96	7045604.0
2025-06-18 16:00:00	QQQ	ETF	528.97	529.65	528.95	529.2	1236216.0
2025-06-18 17:00:00	QQQ	ETF	529.2	529.29	528.85	528.88	83497.0
2025-06-18 18:00:00	QQQ	ETF	528.99	529.28	528.03	528.6201	91123.0
2025-06-18 19:00:00	QQQ	ETF	528.68	529.1	528.4	528.96	41525.0
2025-06-18 04:00:00	IWM	ETF	208.81	209.16	208.68	209.02	51477.0
2025-06-18 05:00:00	IWM	ETF	209.03	209.33	209.02	209.12	29879.0
2025-06-18 06:00:00	IWM	ETF	209.01	209.04	208.0	208.08	60539.0
2025-06-18 07:00:00	IWM	ETF	208.08	209.04	208.06	208.67	77510.0
2025-06-18 08:00:00	IWM	ETF	208.67	209.09	208.05	208.33	111310.0
2025-06-18 09:00:00	IWM	ETF	208.4	209.47	207.78	209.155	3313464.0
2025-06-18 10:00:00	IWM	ETF	209.15	211.01	209.05	210.95	3528124.0
2025-06-18 11:00:00	IWM	ETF	210.94	211.12	210.49	210.56	1751387.0
2025-06-18 12:00:00	IWM	ETF	210.555	210.99	210.51	210.59	1222060.0
2025-06-18 13:00:00	IWM	ETF	210.59	210.745	210.01	210.4	1570601.0
2025-06-18 14:00:00	IWM	ETF	210.37	211.39	209.16	209.32	4003848.0
2025-06-18 15:00:00	IWM	ETF	209.32	210.25	209.04	209.62	6051793.0
2025-06-18 16:00:00	IWM	ETF	209.65	209.98	209.62	209.8	946630.0
2025-06-18 17:00:00	IWM	ETF	209.76	209.83	209.56	209.71	13193.0
2025-06-18 18:00:00	IWM	ETF	209.65	209.82	209.42	209.64	21257.0
2025-06-18 19:00:00	IWM	ETF	209.68	209.88	209.66	209.81	16104.0
2025-06-18 04:00:00	DIA	ETF	423.84	423.84	423.56	423.56	1040.0
2025-06-18 05:00:00	DIA	ETF	423.91	424.31	423.91	424.14	1800.0

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

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