PREVIEW / etf_1hour / 2025-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-01.parquet
  size:    688 KB
  rows:    26,823

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-08-01 04:00:00	SPY	ETF	629.5	629.5	625.69	626.7	233930.0
2025-08-01 05:00:00	SPY	ETF	626.67	627.1	626.12	626.68	55834.0
2025-08-01 06:00:00	SPY	ETF	626.67	626.67	624.83	625.17	300074.0
2025-08-01 07:00:00	SPY	ETF	625.36	627.0	625.2	626.87	236804.0
2025-08-01 08:00:00	SPY	ETF	625.38	631.64	624.8696	625.84	1759894.0
2025-08-01 09:00:00	SPY	ETF	625.95	626.64	621.1	621.4815	12362619.0
2025-08-01 10:00:00	SPY	ETF	621.53	624.07	619.65	621.96	17458462.0
2025-08-01 11:00:00	SPY	ETF	621.96	624.035	621.38	624.0	10909823.0
2025-08-01 12:00:00	SPY	ETF	624.0	624.965	621.2	621.35	12047473.0
2025-08-01 13:00:00	SPY	ETF	621.34	621.79	620.21	620.6299	11991753.0
2025-08-01 14:00:00	SPY	ETF	620.61	623.11	619.29	621.4	12458919.0
2025-08-01 15:00:00	SPY	ETF	621.41	623.3	620.84	621.71	22220657.0
2025-08-01 16:00:00	SPY	ETF	621.71	623.7583	621.5	621.68	3214312.0
2025-08-01 17:00:00	SPY	ETF	621.71	622.11	621.5	622.11	127677.0
2025-08-01 18:00:00	SPY	ETF	622.1499	622.17	621.6	621.62	69288.0
2025-08-01 19:00:00	SPY	ETF	621.6007	621.6007	621.03	621.23	69282.0
2025-08-01 04:00:00	QQQ	ETF	562.78	562.78	558.23	559.41	254894.0
2025-08-01 05:00:00	QQQ	ETF	559.3	560.0	558.76	559.78	146239.0
2025-08-01 06:00:00	QQQ	ETF	559.7	559.7	557.45	558.01	195471.0
2025-08-01 07:00:00	QQQ	ETF	558.08	559.83	557.98	559.8	266158.0
2025-08-01 08:00:00	QQQ	ETF	558.31	564.587	557.867	558.3501	1093653.0
2025-08-01 09:00:00	QQQ	ETF	558.41	559.17	553.32	553.8002	9580693.0
2025-08-01 10:00:00	QQQ	ETF	553.73	557.26	551.88	555.035	10070794.0
2025-08-01 11:00:00	QQQ	ETF	555.03	557.16	554.23	556.915	4470147.0
2025-08-01 12:00:00	QQQ	ETF	556.92	557.841	553.68	553.84	4121161.0
2025-08-01 13:00:00	QQQ	ETF	553.83	554.3	552.6	553.01	4590330.0
2025-08-01 14:00:00	QQQ	ETF	552.99	555.3584	551.68	553.6009	4797319.0
2025-08-01 15:00:00	QQQ	ETF	553.62	555.43	552.81	553.85	7153115.0
2025-08-01 16:00:00	QQQ	ETF	553.85	554.18	553.53	553.62	1782607.0
2025-08-01 17:00:00	QQQ	ETF	553.63	554.2	553.51	554.19	45235.0
2025-08-01 18:00:00	QQQ	ETF	554.07	554.15	553.5017	553.79	30346.0
2025-08-01 19:00:00	QQQ	ETF	553.88	553.88	553.0	553.0492	22029.0
2025-08-01 04:00:00	IWM	ETF	216.93	218.0	216.07	216.41	160338.0
2025-08-01 05:00:00	IWM	ETF	216.52	216.78	216.22	216.46	29161.0
2025-08-01 06:00:00	IWM	ETF	216.42	216.44	215.69	216.02	58095.0
2025-08-01 07:00:00	IWM	ETF	216.01	216.9	215.96	216.61	166111.0
2025-08-01 08:00:00	IWM	ETF	216.02	219.46	214.13	215.46	1445813.0
2025-08-01 09:00:00	IWM	ETF	215.5	216.31	212.89	213.23	7989455.0
2025-08-01 10:00:00	IWM	ETF	213.265	215.22	212.34	214.18	8639862.0
2025-08-01 11:00:00	IWM	ETF	214.17	215.78	213.66	215.68	4986868.0
2025-08-01 12:00:00	IWM	ETF	215.67	216.56	214.87	214.9001	4390206.0
2025-08-01 13:00:00	IWM	ETF	214.9	215.25	214.34	214.55	4270329.0
2025-08-01 14:00:00	IWM	ETF	214.54	215.86	214.13	215.035	3901574.0
2025-08-01 15:00:00	IWM	ETF	215.02	215.55	214.7	214.96	9491488.0
2025-08-01 16:00:00	IWM	ETF	214.95	215.56	214.86	214.92	2674034.0
2025-08-01 17:00:00	IWM	ETF	215.23	215.27	215.0	215.2	48095.0
2025-08-01 18:00:00	IWM	ETF	215.22	215.29	214.94	215.11	11463.0
2025-08-01 19:00:00	IWM	ETF	215.1968	215.1968	215.03	215.19	41706.0
2025-08-01 04:00:00	DIA	ETF	437.89	438.42	437.16	437.62	26405.0
2025-08-01 05:00:00	DIA	ETF	437.76	437.98	437.48	437.62	3700.0

> showing 50 of 26,823 rows — these rows as CSV

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