PREVIEW / etf_1hour / 2025-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-24.parquet
  size:    699 KB
  rows:    27,027

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-10-24 04:00:00	SPY	ETF	673.21	673.86	672.95	673.51	125957.0
2025-10-24 05:00:00	SPY	ETF	673.52	674.34	673.48	673.91	17631.0
2025-10-24 06:00:00	SPY	ETF	673.9	674.23	673.74	673.74	30893.0
2025-10-24 07:00:00	SPY	ETF	673.78	674.38	673.72	674.18	72952.0
2025-10-24 08:00:00	SPY	ETF	673.7214	678.0	672.88	675.7	1081304.0
2025-10-24 09:00:00	SPY	ETF	675.73	677.79	671.76	677.29	6966197.0
2025-10-24 10:00:00	SPY	ETF	677.36	677.94	675.91	676.69	6239817.0
2025-10-24 11:00:00	SPY	ETF	676.68	678.42	676.475	677.945	5698281.0
2025-10-24 12:00:00	SPY	ETF	677.92	678.46	677.21	677.95	3655517.0
2025-10-24 13:00:00	SPY	ETF	677.94	678.43	677.63	678.0702	2376280.0
2025-10-24 14:00:00	SPY	ETF	678.07	678.34	677.75	678.1844	2979168.0
2025-10-24 15:00:00	SPY	ETF	678.19	678.47	676.765	677.12	12225187.0
2025-10-24 16:00:00	SPY	ETF	677.11	677.34	676.68	676.93	4068919.0
2025-10-24 17:00:00	SPY	ETF	677.0398	677.3	676.96	677.2	528045.0
2025-10-24 18:00:00	SPY	ETF	677.23	677.29	677.11	677.23	4813.0
2025-10-24 19:00:00	SPY	ETF	677.18	677.3	677.15	677.3	35938.0
2025-10-24 04:00:00	QQQ	ETF	612.8	613.68	612.6	613.25	118212.0
2025-10-24 05:00:00	QQQ	ETF	613.31	614.22	613.28	613.83	62831.0
2025-10-24 06:00:00	QQQ	ETF	613.85	614.17	613.58	613.59	63317.0
2025-10-24 07:00:00	QQQ	ETF	613.62	614.05	613.52	613.75	105283.0
2025-10-24 08:00:00	QQQ	ETF	613.6	617.28	610.123	615.8	1047215.0
2025-10-24 09:00:00	QQQ	ETF	615.83	617.53	615.13	616.97	5519401.0
2025-10-24 10:00:00	QQQ	ETF	617.02	617.9	615.18	616.045	6311086.0
2025-10-24 11:00:00	QQQ	ETF	616.04	617.89	615.76	617.3501	3972106.0
2025-10-24 12:00:00	QQQ	ETF	617.34	618.27	617.28	618.0	2976933.0
2025-10-24 13:00:00	QQQ	ETF	617.99	618.42	617.72	617.98	2262072.0
2025-10-24 14:00:00	QQQ	ETF	617.97	618.11	617.5	617.86	2375601.0
2025-10-24 15:00:00	QQQ	ETF	617.86	618.405	616.75	617.02	6752662.0
2025-10-24 16:00:00	QQQ	ETF	617.02	617.43	616.75	617.07	2005176.0
2025-10-24 17:00:00	QQQ	ETF	617.09	617.44	617.05	617.32	33601.0
2025-10-24 18:00:00	QQQ	ETF	617.43	617.43	617.21	617.23	9033.0
2025-10-24 19:00:00	QQQ	ETF	617.2301	617.52	617.23	617.52	26165.0
2025-10-24 04:00:00	IWM	ETF	247.1	247.34	246.72	247.03	59950.0
2025-10-24 05:00:00	IWM	ETF	246.99	247.5	246.96	247.35	24639.0
2025-10-24 06:00:00	IWM	ETF	247.39	247.6	247.31	247.49	20987.0
2025-10-24 07:00:00	IWM	ETF	247.5	248.04	247.46	247.93	49904.0
2025-10-24 08:00:00	IWM	ETF	247.49	251.49	247.0	249.81	930411.0
2025-10-24 09:00:00	IWM	ETF	249.81	250.65	248.97	250.62	4235926.0
2025-10-24 10:00:00	IWM	ETF	250.61	251.11	249.37	249.82	3792587.0
2025-10-24 11:00:00	IWM	ETF	249.83	250.735	249.795	250.445	2138404.0
2025-10-24 12:00:00	IWM	ETF	250.45	250.665	249.545	250.01	1639363.0
2025-10-24 13:00:00	IWM	ETF	250.0	250.35	249.9	250.1299	1230396.0
2025-10-24 14:00:00	IWM	ETF	250.12	250.27	249.5899	249.835	1262123.0
2025-10-24 15:00:00	IWM	ETF	249.84	250.07	249.38	249.45	4540264.0
2025-10-24 16:00:00	IWM	ETF	249.43	249.48	249.13	249.21	1059370.0
2025-10-24 17:00:00	IWM	ETF	249.2	249.7	249.17	249.54	28724.0
2025-10-24 18:00:00	IWM	ETF	249.66	249.66	249.3	249.43	19403.0
2025-10-24 19:00:00	IWM	ETF	249.43	249.59	249.33	249.59	14073.0
2025-10-24 04:00:00	DIA	ETF	467.24	467.74	467.24	467.53	700.0
2025-10-24 05:00:00	DIA	ETF	467.6	467.6	467.6	467.6	100.0

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

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