PREVIEW / etf_1hour / 2025-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-04-30.parquet
  size:    636 KB
  rows:    24,669

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-30 04:00:00	SPY	ETF	553.29	554.08	552.79	553.0	19851.0
2025-04-30 05:00:00	SPY	ETF	553.11	553.9	553.11	553.48	8240.0
2025-04-30 06:00:00	SPY	ETF	553.4	553.51	552.34	553.15	64800.0
2025-04-30 07:00:00	SPY	ETF	553.1	553.86	552.14	552.3	267887.0
2025-04-30 08:00:00	SPY	ETF	553.6	553.8	546.17	547.19	1665322.0
2025-04-30 09:00:00	SPY	ETF	547.11	547.67	541.52	541.94	8015037.0
2025-04-30 10:00:00	SPY	ETF	541.925	547.4597	541.63	546.97	8105801.0
2025-04-30 11:00:00	SPY	ETF	546.98	549.84	546.89	549.4869	5009886.0
2025-04-30 12:00:00	SPY	ETF	549.43	550.24	547.41	549.5558	3642519.0
2025-04-30 13:00:00	SPY	ETF	549.555	551.12	547.14	550.47	3345862.0
2025-04-30 14:00:00	SPY	ETF	550.48	553.1	549.11	549.6	6956194.0
2025-04-30 15:00:00	SPY	ETF	549.59	556.52	549.38	554.35	18933365.0
2025-04-30 16:00:00	SPY	ETF	554.36	558.44	552.81	557.8	6598240.0
2025-04-30 17:00:00	SPY	ETF	557.75	558.26	557.5	557.64	278144.0
2025-04-30 18:00:00	SPY	ETF	557.72	559.74	557.45	558.71	376346.0
2025-04-30 19:00:00	SPY	ETF	558.85	559.46	558.32	559.2785	188658.0
2025-04-30 04:00:00	QQQ	ETF	473.52	474.95	473.37	473.81	52807.0
2025-04-30 05:00:00	QQQ	ETF	473.87	474.68	473.87	474.11	30637.0
2025-04-30 06:00:00	QQQ	ETF	474.1	474.2	473.03	473.67	43564.0
2025-04-30 07:00:00	QQQ	ETF	473.7	474.33	472.3	472.65	108590.0
2025-04-30 08:00:00	QQQ	ETF	473.93	475.174	466.15	466.82	1094978.0
2025-04-30 09:00:00	QQQ	ETF	466.77	467.26	462.47	462.8	4784848.0
2025-04-30 10:00:00	QQQ	ETF	462.67	468.5	462.43	467.9398	5388839.0
2025-04-30 11:00:00	QQQ	ETF	467.9	470.87	467.84	470.57	3481596.0
2025-04-30 12:00:00	QQQ	ETF	470.5	471.31	468.54	470.45	2782811.0
2025-04-30 13:00:00	QQQ	ETF	470.47	472.22	468.02	471.445	2230497.0
2025-04-30 14:00:00	QQQ	ETF	471.48	473.93	470.72	471.3964	3904440.0
2025-04-30 15:00:00	QQQ	ETF	471.35	477.2	471.2	475.49	5067728.0
2025-04-30 16:00:00	QQQ	ETF	475.46	481.21	468.795	480.35	3539638.0
2025-04-30 17:00:00	QQQ	ETF	480.3	480.4792	476.15	479.65	316646.0
2025-04-30 18:00:00	QQQ	ETF	479.71	482.45	479.55	481.72	565960.0
2025-04-30 19:00:00	QQQ	ETF	481.7	482.42	480.9	482.06	132839.0
2025-04-30 04:00:00	IWM	ETF	196.09	196.26	195.87	196.06	10473.0
2025-04-30 05:00:00	IWM	ETF	196.05	196.47	196.05	196.4	5932.0
2025-04-30 06:00:00	IWM	ETF	196.4	196.43	195.88	196.11	42228.0
2025-04-30 07:00:00	IWM	ETF	196.12	196.33	195.82	195.84	39001.0
2025-04-30 08:00:00	IWM	ETF	195.92	196.3704	192.41	193.06	552802.0
2025-04-30 09:00:00	IWM	ETF	193.09	193.26	190.8	191.0	3155250.0
2025-04-30 10:00:00	IWM	ETF	191.035	192.51	190.721	192.31	2983130.0
2025-04-30 11:00:00	IWM	ETF	192.31	193.99	192.28	193.84	1822697.0
2025-04-30 12:00:00	IWM	ETF	193.825	194.15	192.96	193.78	1304544.0
2025-04-30 13:00:00	IWM	ETF	193.76	194.49	193.18	194.1	1324174.0
2025-04-30 14:00:00	IWM	ETF	194.11	195.06	193.86	193.895	1898862.0
2025-04-30 15:00:00	IWM	ETF	193.91	195.48	193.65	194.73	5841972.0
2025-04-30 16:00:00	IWM	ETF	194.72	195.29	194.0	194.67	3119351.0
2025-04-30 17:00:00	IWM	ETF	194.88	195.23	194.73	195.05	44355.0
2025-04-30 18:00:00	IWM	ETF	194.96	195.15	194.51	194.87	120344.0
2025-04-30 19:00:00	IWM	ETF	194.86	195.1	194.76	195.1	65431.0
2025-04-30 04:00:00	DIA	ETF	405.26	405.67	405.09	405.2	3900.0
2025-04-30 05:00:00	DIA	ETF	405.43	405.43	405.43	405.43	100.0

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

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