PREVIEW / etf_1hour / 2025-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-17.parquet
  size:    649 KB
  rows:    25,101

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-17 04:00:00	SPY	ETF	599.07	600.24	598.84	599.83	143750.0
2025-06-17 05:00:00	SPY	ETF	599.99	600.24	598.77	599.22	53681.0
2025-06-17 06:00:00	SPY	ETF	599.24	599.65	598.27	599.33	85913.0
2025-06-17 07:00:00	SPY	ETF	599.31	600.43	599.19	600.41	287143.0
2025-06-17 08:00:00	SPY	ETF	599.29	602.6181	598.4696	599.78	583873.0
2025-06-17 09:00:00	SPY	ETF	599.67	600.95	599.18	600.865	6034655.0
2025-06-17 10:00:00	SPY	ETF	600.86	601.64	600.3308	600.4799	5772994.0
2025-06-17 11:00:00	SPY	ETF	600.49	601.75	600.22	600.705	4859145.0
2025-06-17 12:00:00	SPY	ETF	600.74	601.59	599.5	599.78	6065523.0
2025-06-17 13:00:00	SPY	ETF	599.79	600.2	597.41	598.02	8326255.0
2025-06-17 14:00:00	SPY	ETF	598.02	598.18	596.76	598.12	9192923.0
2025-06-17 15:00:00	SPY	ETF	598.12	598.61	597.29	597.55	12860138.0
2025-06-17 16:00:00	SPY	ETF	597.57	598.15	597.09	597.5	6867730.0
2025-06-17 17:00:00	SPY	ETF	597.5596	597.5596	597.07	597.29	114708.0
2025-06-17 18:00:00	SPY	ETF	597.1	597.2	595.62	595.69	264959.0
2025-06-17 19:00:00	SPY	ETF	595.76	596.64	595.57	596.1104	140349.0
2025-06-17 20:00:00	SPY	ETF	596.2	596.2	596.2	596.2	100.0
2025-06-17 04:00:00	QQQ	ETF	531.11	532.09	530.67	531.66	67964.0
2025-06-17 05:00:00	QQQ	ETF	531.66	532.07	530.72	530.93	43866.0
2025-06-17 06:00:00	QQQ	ETF	530.85	531.35	530.0	531.03	45012.0
2025-06-17 07:00:00	QQQ	ETF	531.02	531.87	530.89	531.83	74386.0
2025-06-17 08:00:00	QQQ	ETF	531.04	533.0	530.4	531.52	305073.0
2025-06-17 09:00:00	QQQ	ETF	531.42	532.78	530.8051	532.41	3245527.0
2025-06-17 10:00:00	QQQ	ETF	532.41	533.32	531.81	531.95	3481060.0
2025-06-17 11:00:00	QQQ	ETF	531.94	533.325	531.88	532.44	2872511.0
2025-06-17 12:00:00	QQQ	ETF	532.43	533.24	530.715	530.97	3204361.0
2025-06-17 13:00:00	QQQ	ETF	530.94	531.47	528.69	529.2	4566448.0
2025-06-17 14:00:00	QQQ	ETF	529.17	529.59	527.91	529.559	4780468.0
2025-06-17 15:00:00	QQQ	ETF	529.56	530.08	528.78	529.0	5399686.0
2025-06-17 16:00:00	QQQ	ETF	529.02	529.65	528.57	528.9	995147.0
2025-06-17 17:00:00	QQQ	ETF	528.85	528.95	528.42	528.42	47199.0
2025-06-17 18:00:00	QQQ	ETF	528.45	528.54	526.85	527.08	187233.0
2025-06-17 19:00:00	QQQ	ETF	527.0417	528.3	526.9101	527.8099	163602.0
2025-06-17 04:00:00	IWM	ETF	208.48	209.23	208.35	208.98	47686.0
2025-06-17 05:00:00	IWM	ETF	209.02	209.23	208.7	208.91	20409.0
2025-06-17 06:00:00	IWM	ETF	208.91	209.23	208.65	209.22	28652.0
2025-06-17 07:00:00	IWM	ETF	209.19	209.57	208.98	209.54	60995.0
2025-06-17 08:00:00	IWM	ETF	209.13	209.7	208.16	209.07	215475.0
2025-06-17 09:00:00	IWM	ETF	209.04	210.27	208.74	210.21	3182617.0
2025-06-17 10:00:00	IWM	ETF	210.22	210.395	209.665	209.97	2546739.0
2025-06-17 11:00:00	IWM	ETF	209.96	210.45	209.66	209.73	2201782.0
2025-06-17 12:00:00	IWM	ETF	209.74	210.4197	209.43	209.465	2400644.0
2025-06-17 13:00:00	IWM	ETF	209.47	209.75	208.65	209.1	3463208.0
2025-06-17 14:00:00	IWM	ETF	209.09	209.2	208.43	208.98	2858620.0
2025-06-17 15:00:00	IWM	ETF	208.98	209.03	208.37	208.51	5240906.0
2025-06-17 16:00:00	IWM	ETF	208.55	208.9	208.27	208.5	3201892.0
2025-06-17 17:00:00	IWM	ETF	208.33	208.51	208.21	208.26	20889.0
2025-06-17 18:00:00	IWM	ETF	208.26	208.36	207.7	207.7	32682.0
2025-06-17 19:00:00	IWM	ETF	207.74	207.92	207.4197	207.47	51145.0
2025-06-17 04:00:00	DIA	ETF	423.77	423.94	423.77	423.94	600.0

> showing 50 of 25,101 rows — these rows as CSV

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