PREVIEW / etf_1hour / 2025-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-08.parquet
  size:    650 KB
  rows:    25,211

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-07-08 04:00:00	SPY	ETF	621.22	621.92	621.22	621.57	22404.0
2025-07-08 05:00:00	SPY	ETF	621.52	621.67	620.93	621.17	11487.0
2025-07-08 06:00:00	SPY	ETF	621.0	621.85	620.72	621.5	51590.0
2025-07-08 07:00:00	SPY	ETF	621.59	621.97	621.34	621.499	120847.0
2025-07-08 08:00:00	SPY	ETF	621.42	622.0	620.85	621.46	167597.0
2025-07-08 09:00:00	SPY	ETF	621.49	621.665	620.55	620.66	3985922.0
2025-07-08 10:00:00	SPY	ETF	620.68	621.495	619.52	620.43	7644612.0
2025-07-08 11:00:00	SPY	ETF	620.43	621.22	619.72	621.065	4730300.0
2025-07-08 12:00:00	SPY	ETF	621.0612	622.11	620.4	620.8	6581862.0
2025-07-08 13:00:00	SPY	ETF	620.79	621.31	619.84	621.17	4301819.0
2025-07-08 14:00:00	SPY	ETF	621.15	621.3022	620.3	620.52	4032826.0
2025-07-08 15:00:00	SPY	ETF	620.52	620.81	619.99	620.31	10312359.0
2025-07-08 16:00:00	SPY	ETF	620.3	620.65	620.14	620.4	2291930.0
2025-07-08 17:00:00	SPY	ETF	620.42	620.45	620.3	620.38	16690.0
2025-07-08 18:00:00	SPY	ETF	620.41	620.8	620.36	620.5412	31198.0
2025-07-08 19:00:00	SPY	ETF	620.6	620.83	620.26	620.26	91580.0
2025-07-08 04:00:00	QQQ	ETF	553.95	554.01	553.37	553.68	45868.0
2025-07-08 05:00:00	QQQ	ETF	553.45	553.78	553.04	553.14	19888.0
2025-07-08 06:00:00	QQQ	ETF	553.2	553.78	552.7	553.61	47396.0
2025-07-08 07:00:00	QQQ	ETF	553.59	553.86	553.251	553.53	36329.0
2025-07-08 08:00:00	QQQ	ETF	553.45	554.26	551.616	553.38	199462.0
2025-07-08 09:00:00	QQQ	ETF	553.45	553.84	552.1	552.11	2881103.0
2025-07-08 10:00:00	QQQ	ETF	552.11	553.53	551.1	552.359	5379547.0
2025-07-08 11:00:00	QQQ	ETF	552.35	552.86	551.4351	552.65	2947324.0
2025-07-08 12:00:00	QQQ	ETF	552.66	554.01	552.24	552.91	3294685.0
2025-07-08 13:00:00	QQQ	ETF	552.9	553.43	551.95	553.34	2338460.0
2025-07-08 14:00:00	QQQ	ETF	553.32	553.5	552.2908	552.49	2581454.0
2025-07-08 15:00:00	QQQ	ETF	552.48	552.58	551.82	552.32	5204571.0
2025-07-08 16:00:00	QQQ	ETF	552.32	552.71	552.22	552.58	1203724.0
2025-07-08 17:00:00	QQQ	ETF	552.57	552.69	552.34	552.59	125948.0
2025-07-08 18:00:00	QQQ	ETF	552.68	552.99	552.57	552.78	19155.0
2025-07-08 19:00:00	QQQ	ETF	552.84	553.05	552.42	552.55	57774.0
2025-07-08 04:00:00	IWM	ETF	220.57	220.65	220.25	220.45	14507.0
2025-07-08 05:00:00	IWM	ETF	220.36	220.65	220.25	220.33	4571.0
2025-07-08 06:00:00	IWM	ETF	220.22	220.6	220.1	220.5	7338.0
2025-07-08 07:00:00	IWM	ETF	220.42	220.76	220.42	220.46	46996.0
2025-07-08 08:00:00	IWM	ETF	220.7	220.75	220.13	220.57	76958.0
2025-07-08 09:00:00	IWM	ETF	220.61	221.44	220.33	221.24	3301571.0
2025-07-08 10:00:00	IWM	ETF	221.24	221.58	220.4	221.185	5078750.0
2025-07-08 11:00:00	IWM	ETF	221.2	221.88	220.99	221.74	2421313.0
2025-07-08 12:00:00	IWM	ETF	221.74	222.29	221.2	221.66	2769214.0
2025-07-08 13:00:00	IWM	ETF	221.68	222.01	221.23	221.9	1946015.0
2025-07-08 14:00:00	IWM	ETF	221.9	222.02	221.39	221.525	1877203.0
2025-07-08 15:00:00	IWM	ETF	221.52	221.665	221.07	221.27	4549035.0
2025-07-08 16:00:00	IWM	ETF	221.25	221.47	221.21	221.35	1358453.0
2025-07-08 17:00:00	IWM	ETF	221.27	221.43	221.24	221.42	13358.0
2025-07-08 18:00:00	IWM	ETF	221.33	221.53	221.24	221.34	13251.0
2025-07-08 19:00:00	IWM	ETF	221.32	221.44	220.5399	220.69	222212.0
2025-07-08 04:00:00	DIA	ETF	443.92	443.92	443.54	443.54	3602.0
2025-07-08 05:00:00	DIA	ETF	443.58	443.58	443.37	443.41	700.0

> showing 50 of 25,211 rows — these rows as CSV

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