PREVIEW / etf_1hour / 2025-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-11.parquet
  size:    648 KB
  rows:    24,946

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-11 04:00:00	SPY	ETF	622.74	624.7	622.21	622.77	70205.0
2025-07-11 05:00:00	SPY	ETF	622.73	622.99	621.66	621.74	38017.0
2025-07-11 06:00:00	SPY	ETF	621.65	622.27	621.4	621.77	88479.0
2025-07-11 07:00:00	SPY	ETF	621.76	623.25	621.71	622.81	269742.0
2025-07-11 08:00:00	SPY	ETF	621.9	624.71	621.49	622.62	339400.0
2025-07-11 09:00:00	SPY	ETF	622.6196	623.52	621.53	623.23	5670987.0
2025-07-11 10:00:00	SPY	ETF	623.24	624.37	622.98	623.86	5476979.0
2025-07-11 11:00:00	SPY	ETF	623.86	624.64	622.71	623.775	6290329.0
2025-07-11 12:00:00	SPY	ETF	623.78	624.425	623.15	624.3458	4177585.0
2025-07-11 13:00:00	SPY	ETF	624.35	624.58	623.75	624.5	4433788.0
2025-07-11 14:00:00	SPY	ETF	624.49	624.86	624.1	624.36	5017717.0
2025-07-11 15:00:00	SPY	ETF	624.35	624.72	623.13	623.61	13035012.0
2025-07-11 16:00:00	SPY	ETF	623.6	623.65	623.0	623.03	1862491.0
2025-07-11 17:00:00	SPY	ETF	623.18	623.24	623.0	623.14	50313.0
2025-07-11 18:00:00	SPY	ETF	623.1146	623.3	623.1	623.2	23599.0
2025-07-11 19:00:00	SPY	ETF	623.125	623.19	622.95	623.04	16547.0
2025-07-11 04:00:00	QQQ	ETF	553.0	554.17	552.24	553.02	72047.0
2025-07-11 05:00:00	QQQ	ETF	553.03	553.2	551.99	552.12	75979.0
2025-07-11 06:00:00	QQQ	ETF	552.07	552.76	551.86	552.3	62823.0
2025-07-11 07:00:00	QQQ	ETF	552.3	553.5	552.21	553.14	113091.0
2025-07-11 08:00:00	QQQ	ETF	552.35	554.68	551.92	553.06	236882.0
2025-07-11 09:00:00	QQQ	ETF	552.99	554.52	552.05	554.43	4170762.0
2025-07-11 10:00:00	QQQ	ETF	554.43	555.48	553.95	554.55	4454589.0
2025-07-11 11:00:00	QQQ	ETF	554.55	555.51	553.11	554.71	3828126.0
2025-07-11 12:00:00	QQQ	ETF	554.72	555.48	554.3	555.35	2774249.0
2025-07-11 13:00:00	QQQ	ETF	555.36	555.79	554.37	555.26	2552950.0
2025-07-11 14:00:00	QQQ	ETF	555.24	555.72	554.55	554.72	2762704.0
2025-07-11 15:00:00	QQQ	ETF	554.71	555.195	553.48	554.21	5585978.0
2025-07-11 16:00:00	QQQ	ETF	554.2	554.3359	553.61	553.7799	1680520.0
2025-07-11 17:00:00	QQQ	ETF	553.7	553.9	553.66	553.89	33222.0
2025-07-11 18:00:00	QQQ	ETF	553.73	553.8	553.54	553.55	18161.0
2025-07-11 19:00:00	QQQ	ETF	553.64	553.68	553.38	553.5	19537.0
2025-07-11 04:00:00	IWM	ETF	223.35	223.63	222.84	223.16	52087.0
2025-07-11 05:00:00	IWM	ETF	223.16	223.26	222.23	222.25	26652.0
2025-07-11 06:00:00	IWM	ETF	222.21	222.69	222.15	222.45	36104.0
2025-07-11 07:00:00	IWM	ETF	222.41	223.38	222.41	223.11	130284.0
2025-07-11 08:00:00	IWM	ETF	222.81	224.13	222.45	223.16	92893.0
2025-07-11 09:00:00	IWM	ETF	223.13	223.54	222.23	222.9191	4040874.0
2025-07-11 10:00:00	IWM	ETF	222.91	223.245	222.08	222.59	3956057.0
2025-07-11 11:00:00	IWM	ETF	222.58	222.727	222.03	222.11	2987368.0
2025-07-11 12:00:00	IWM	ETF	222.1	222.56	221.71	222.505	2822685.0
2025-07-11 13:00:00	IWM	ETF	222.5	222.67	221.98	222.4298	1827466.0
2025-07-11 14:00:00	IWM	ETF	222.425	222.7497	222.17	222.445	2269473.0
2025-07-11 15:00:00	IWM	ETF	222.44	222.455	221.5727	221.7	5882666.0
2025-07-11 16:00:00	IWM	ETF	221.7	221.9056	221.43	221.45	1265140.0
2025-07-11 17:00:00	IWM	ETF	221.51	221.54	221.2607	221.3624	25733.0
2025-07-11 18:00:00	IWM	ETF	221.57	221.57	221.3821	221.3821	8661.0
2025-07-11 19:00:00	IWM	ETF	221.45	221.5499	221.44	221.49	12071.0
2025-07-11 04:00:00	DIA	ETF	444.16	444.29	443.96	444.23	6200.0
2025-07-11 05:00:00	DIA	ETF	444.41	444.41	443.47	443.47	2635.0

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

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