PREVIEW / etf_1hour / 2025-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-02.parquet
  size:    711 KB
  rows:    27,368

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-02 04:00:00	SPY	ETF	669.26	670.0	669.24	669.92	42745.0
2025-10-02 05:00:00	SPY	ETF	669.89	669.96	669.16	669.59	15676.0
2025-10-02 06:00:00	SPY	ETF	669.66	670.03	669.66	669.73	11246.0
2025-10-02 07:00:00	SPY	ETF	669.73	670.35	669.72	670.32	123397.0
2025-10-02 08:00:00	SPY	ETF	669.93	670.62	668.97	670.46	251938.0
2025-10-02 09:00:00	SPY	ETF	670.47	670.74	668.75	669.42	7151013.0
2025-10-02 10:00:00	SPY	ETF	669.41	669.5299	667.54	667.565	6395579.0
2025-10-02 11:00:00	SPY	ETF	667.57	668.42	666.78	668.35	4968444.0
2025-10-02 12:00:00	SPY	ETF	668.35	668.59	667.55	668.42	3018753.0
2025-10-02 13:00:00	SPY	ETF	668.415	669.08	667.94	668.895	3507000.0
2025-10-02 14:00:00	SPY	ETF	668.89	669.73	668.85	669.39	3942786.0
2025-10-02 15:00:00	SPY	ETF	669.38	669.63	668.82	669.17	9574118.0
2025-10-02 16:00:00	SPY	ETF	669.15	669.4	668.9	669.04	2905588.0
2025-10-02 17:00:00	SPY	ETF	669.04	669.22	668.97	669.0409	34311.0
2025-10-02 18:00:00	SPY	ETF	669.05	669.14	668.5	669.07	39356.0
2025-10-02 19:00:00	SPY	ETF	669.06	669.5	668.95	669.45	31680.0
2025-10-02 04:00:00	QQQ	ETF	604.95	605.78	604.17	605.78	121873.0
2025-10-02 05:00:00	QQQ	ETF	605.79	605.87	604.96	605.37	117966.0
2025-10-02 06:00:00	QQQ	ETF	605.35	606.02	605.32	605.73	78426.0
2025-10-02 07:00:00	QQQ	ETF	605.74	606.7	605.68	606.66	77924.0
2025-10-02 08:00:00	QQQ	ETF	605.8	607.0	603.702	606.96	343604.0
2025-10-02 09:00:00	QQQ	ETF	606.98	607.39	603.44	604.645	5062067.0
2025-10-02 10:00:00	QQQ	ETF	604.63	605.31	603.54	603.5905	4853650.0
2025-10-02 11:00:00	QQQ	ETF	603.59	605.085	602.93	604.97	3934728.0
2025-10-02 12:00:00	QQQ	ETF	604.96	605.03	603.97	604.97	2442745.0
2025-10-02 13:00:00	QQQ	ETF	604.97	605.8	604.54	605.19	2450879.0
2025-10-02 14:00:00	QQQ	ETF	605.19	605.95	605.05	605.82	2449067.0
2025-10-02 15:00:00	QQQ	ETF	605.81	606.15	605.29	605.7	4525712.0
2025-10-02 16:00:00	QQQ	ETF	605.72	606.1	605.5	605.66	1917080.0
2025-10-02 17:00:00	QQQ	ETF	605.58	605.59	605.4054	605.5	29696.0
2025-10-02 18:00:00	QQQ	ETF	605.5	605.63	604.9	605.6	45632.0
2025-10-02 19:00:00	QQQ	ETF	605.55	606.06	605.47	606.05	37680.0
2025-10-02 04:00:00	IWM	ETF	243.14	243.59	243.13	243.55	41199.0
2025-10-02 05:00:00	IWM	ETF	243.56	243.56	243.02	243.34	44788.0
2025-10-02 06:00:00	IWM	ETF	243.31	243.6	243.31	243.52	29317.0
2025-10-02 07:00:00	IWM	ETF	243.5	243.75	243.46	243.56	39830.0
2025-10-02 08:00:00	IWM	ETF	243.47	243.83	242.63	243.31	157351.0
2025-10-02 09:00:00	IWM	ETF	243.24	243.52	242.49	243.15	3259021.0
2025-10-02 10:00:00	IWM	ETF	243.18	243.18	241.47	241.8299	3714881.0
2025-10-02 11:00:00	IWM	ETF	241.82	242.67	241.75	242.53	2590656.0
2025-10-02 12:00:00	IWM	ETF	242.53	242.92	242.2	242.76	1548032.0
2025-10-02 13:00:00	IWM	ETF	242.75	243.14	242.51	243.09	1755329.0
2025-10-02 14:00:00	IWM	ETF	243.09	243.8	243.08	243.55	2230485.0
2025-10-02 15:00:00	IWM	ETF	243.55	244.09	243.55	244.0	5306205.0
2025-10-02 16:00:00	IWM	ETF	244.0	244.09	243.84	243.96	976519.0
2025-10-02 17:00:00	IWM	ETF	243.98	244.0	243.72	243.92	14550.0
2025-10-02 18:00:00	IWM	ETF	243.9	244.12	243.8101	244.12	8810.0
2025-10-02 19:00:00	IWM	ETF	244.04	244.2	244.03	244.178	8462.0
2025-10-02 04:00:00	DIA	ETF	464.22	464.31	464.16	464.3	1700.0
2025-10-02 05:00:00	DIA	ETF	464.18	464.27	464.07	464.07	600.0

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

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