PREVIEW / etf_1hour / 2025-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-09-22.parquet
  size:    710 KB
  rows:    27,339

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-09-22 04:00:00	SPY	ETF	661.87	662.71	661.75	662.05	29773.0
2025-09-22 05:00:00	SPY	ETF	662.04	662.18	661.54	661.86	65110.0
2025-09-22 06:00:00	SPY	ETF	661.9	662.38	661.67	661.75	28304.0
2025-09-22 07:00:00	SPY	ETF	661.75	661.95	661.48	661.95	231162.0
2025-09-22 08:00:00	SPY	ETF	661.7484	663.44	661.11	661.86	192836.0
2025-09-22 09:00:00	SPY	ETF	661.83	663.565	661.57	663.41	6488307.0
2025-09-22 10:00:00	SPY	ETF	663.41	665.075	663.175	665.02	7636314.0
2025-09-22 11:00:00	SPY	ETF	665.01	665.32	664.48	664.59	5275497.0
2025-09-22 12:00:00	SPY	ETF	664.5813	666.5	664.56	666.41	7869209.0
2025-09-22 13:00:00	SPY	ETF	666.41	666.78	666.11	666.355	4281143.0
2025-09-22 14:00:00	SPY	ETF	666.35	666.82	666.03	666.78	5280110.0
2025-09-22 15:00:00	SPY	ETF	666.78	667.29	666.71	666.76	10657141.0
2025-09-22 16:00:00	SPY	ETF	666.76	666.84	666.09	666.58	4355758.0
2025-09-22 17:00:00	SPY	ETF	666.3592	666.73	666.3592	666.6977	21317.0
2025-09-22 18:00:00	SPY	ETF	666.6	666.7	666.19	666.4	128413.0
2025-09-22 19:00:00	SPY	ETF	666.49	666.7564	666.42	666.71	26300.0
2025-09-22 04:00:00	QQQ	ETF	597.01	597.94	596.9	596.91	65083.0
2025-09-22 05:00:00	QQQ	ETF	596.98	597.09	596.42	596.9	58241.0
2025-09-22 06:00:00	QQQ	ETF	596.87	597.52	596.69	596.69	55233.0
2025-09-22 07:00:00	QQQ	ETF	596.77	597.1	596.58	597.08	102360.0
2025-09-22 08:00:00	QQQ	ETF	596.7489	599.191	596.22	597.26	192220.0
2025-09-22 09:00:00	QQQ	ETF	597.26	599.38	596.97	599.17	4700791.0
2025-09-22 10:00:00	QQQ	ETF	599.165	600.579	598.75	600.47	5213571.0
2025-09-22 11:00:00	QQQ	ETF	600.46	600.72	599.77	600.13	3965991.0
2025-09-22 12:00:00	QQQ	ETF	600.11	602.07	600.0907	601.89	6089670.0
2025-09-22 13:00:00	QQQ	ETF	601.895	602.205	601.56	601.94	3305188.0
2025-09-22 14:00:00	QQQ	ETF	601.93	602.65	601.88	602.5	3250540.0
2025-09-22 15:00:00	QQQ	ETF	602.515	602.87	602.0	602.24	6899999.0
2025-09-22 16:00:00	QQQ	ETF	602.19	602.31	601.8	602.15	1758784.0
2025-09-22 17:00:00	QQQ	ETF	602.2	602.5	602.19	602.3922	43334.0
2025-09-22 18:00:00	QQQ	ETF	602.26	602.26	601.68	601.93	43316.0
2025-09-22 19:00:00	QQQ	ETF	601.99	602.33	601.94	602.24	30453.0
2025-09-22 04:00:00	IWM	ETF	242.59	243.12	242.56	242.75	38224.0
2025-09-22 05:00:00	IWM	ETF	242.8	242.8	242.43	242.43	16552.0
2025-09-22 06:00:00	IWM	ETF	242.41	242.64	242.39	242.5	27944.0
2025-09-22 07:00:00	IWM	ETF	242.45	242.52	242.33	242.44	65355.0
2025-09-22 08:00:00	IWM	ETF	242.4798	243.13	242.02	242.4	125533.0
2025-09-22 09:00:00	IWM	ETF	242.4	243.07	241.11	243.03	4007148.0
2025-09-22 10:00:00	IWM	ETF	243.02	243.02	242.0	242.91	3055741.0
2025-09-22 11:00:00	IWM	ETF	242.91	243.45	242.835	242.92	2973158.0
2025-09-22 12:00:00	IWM	ETF	242.9201	243.725	242.75	243.51	3851370.0
2025-09-22 13:00:00	IWM	ETF	243.52	243.875	243.38	243.56	2040676.0
2025-09-22 14:00:00	IWM	ETF	243.56	244.345	243.45	244.3	2211541.0
2025-09-22 15:00:00	IWM	ETF	244.3	244.785	244.18	244.38	5642612.0
2025-09-22 16:00:00	IWM	ETF	244.39	244.44	243.0	244.369	1946627.0
2025-09-22 17:00:00	IWM	ETF	244.37	244.5	244.23	244.39	2707.0
2025-09-22 18:00:00	IWM	ETF	244.39	244.39	244.1888	244.22	11858.0
2025-09-22 19:00:00	IWM	ETF	244.33	244.55	244.3	244.5	28925.0
2025-09-22 04:00:00	DIA	ETF	461.54	461.99	461.54	461.96	1500.0
2025-09-22 05:00:00	DIA	ETF	461.71	461.71	461.39	461.42	1760.0

> showing 50 of 27,339 rows — these rows as CSV

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