PREVIEW / etf_1hour / 2025-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-28.parquet
  size:    629 KB
  rows:    24,320

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-04-28 04:00:00	SPY	ETF	548.92	549.78	548.56	549.7	33873.0
2025-04-28 05:00:00	SPY	ETF	549.78	550.62	549.39	550.08	13642.0
2025-04-28 06:00:00	SPY	ETF	550.02	550.07	548.83	549.07	27032.0
2025-04-28 07:00:00	SPY	ETF	549.02	550.41	548.77	550.02	105110.0
2025-04-28 08:00:00	SPY	ETF	549.11	551.09	547.39	550.97	479538.0
2025-04-28 09:00:00	SPY	ETF	550.84	553.55	550.13	550.29	5066657.0
2025-04-28 10:00:00	SPY	ETF	550.35	552.1	549.66	550.53	4233846.0
2025-04-28 11:00:00	SPY	ETF	550.51	551.16	547.03	547.48	4688263.0
2025-04-28 12:00:00	SPY	ETF	547.42	547.6338	545.7	546.47	3531711.0
2025-04-28 13:00:00	SPY	ETF	546.46	547.88	545.02	547.705	2893768.0
2025-04-28 14:00:00	SPY	ETF	547.72	549.04	547.3825	548.73	3022819.0
2025-04-28 15:00:00	SPY	ETF	548.75	552.28	548.64	550.94	8375998.0
2025-04-28 16:00:00	SPY	ETF	550.94	551.1136	549.0189	550.18	3019551.0
2025-04-28 17:00:00	SPY	ETF	550.3	550.3	549.9	550.04	64544.0
2025-04-28 18:00:00	SPY	ETF	550.0	550.2985	549.5	550.0999	104831.0
2025-04-28 19:00:00	SPY	ETF	550.02	551.2073	549.99	551.1	60723.0
2025-04-28 04:00:00	QQQ	ETF	470.22	471.93	470.0	471.88	68132.0
2025-04-28 05:00:00	QQQ	ETF	471.89	472.81	471.52	472.29	62885.0
2025-04-28 06:00:00	QQQ	ETF	472.28	472.35	471.1	471.29	40926.0
2025-04-28 07:00:00	QQQ	ETF	471.33	472.62	471.04	472.2	134291.0
2025-04-28 08:00:00	QQQ	ETF	471.2	473.01	469.48	472.76	279484.0
2025-04-28 09:00:00	QQQ	ETF	472.73	474.808	470.75	470.98	3675077.0
2025-04-28 10:00:00	QQQ	ETF	471.04	472.79	470.26	471.13	3053133.0
2025-04-28 11:00:00	QQQ	ETF	471.13	471.79	467.28	468.1688	3689114.0
2025-04-28 12:00:00	QQQ	ETF	468.09	468.38	466.2055	467.4401	2710957.0
2025-04-28 13:00:00	QQQ	ETF	467.42	468.94	466.03	468.74	2106749.0
2025-04-28 14:00:00	QQQ	ETF	468.77	470.4	468.42	470.13	1760182.0
2025-04-28 15:00:00	QQQ	ETF	470.18	473.735	470.0	472.45	3820095.0
2025-04-28 16:00:00	QQQ	ETF	472.43	472.48	471.32	471.45	935126.0
2025-04-28 17:00:00	QQQ	ETF	471.47	471.7	471.35	471.48	27617.0
2025-04-28 18:00:00	QQQ	ETF	471.34	471.6	470.86	471.52	102866.0
2025-04-28 19:00:00	QQQ	ETF	471.461	472.65	471.3612	472.4812	87522.0
2025-04-28 04:00:00	IWM	ETF	192.94	193.43	192.9	193.41	24645.0
2025-04-28 05:00:00	IWM	ETF	193.43	193.78	193.43	193.74	11321.0
2025-04-28 06:00:00	IWM	ETF	193.53	193.64	193.26	193.31	10180.0
2025-04-28 07:00:00	IWM	ETF	193.32	194.0	193.3	193.8	25926.0
2025-04-28 08:00:00	IWM	ETF	193.3285	194.21	192.35	194.15	107926.0
2025-04-28 09:00:00	IWM	ETF	194.14	196.15	194.1	194.83	2816088.0
2025-04-28 10:00:00	IWM	ETF	194.84	195.99	194.67	194.97	2318989.0
2025-04-28 11:00:00	IWM	ETF	194.98	195.19	193.37	193.59	2228438.0
2025-04-28 12:00:00	IWM	ETF	193.59	193.66	192.78	192.97	1757407.0
2025-04-28 13:00:00	IWM	ETF	192.96	193.28	192.53	193.205	1267983.0
2025-04-28 14:00:00	IWM	ETF	193.22	193.95	193.08	193.85	1221050.0
2025-04-28 15:00:00	IWM	ETF	193.86	195.28	193.83	194.92	3473083.0
2025-04-28 16:00:00	IWM	ETF	194.94	194.99	194.44	194.44	754245.0
2025-04-28 17:00:00	IWM	ETF	194.41	194.5	194.3	194.44	22838.0
2025-04-28 18:00:00	IWM	ETF	194.51	194.58	194.29	194.36	24037.0
2025-04-28 19:00:00	IWM	ETF	194.42	194.82	194.4	194.82	10673.0
2025-04-28 04:00:00	DIA	ETF	400.0	400.88	400.0	400.88	1200.0
2025-04-28 05:00:00	DIA	ETF	400.86	401.16	400.72	401.16	600.0

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

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