PREVIEW / etf_1hour / 2025-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-09.parquet
  size:    661 KB
  rows:    25,007

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-09 04:00:00	SPY	ETF	620.47	620.71	620.35	620.53	16913.0
2025-07-09 05:00:00	SPY	ETF	620.54	621.6	620.54	621.31	42925.0
2025-07-09 06:00:00	SPY	ETF	621.29	621.67	621.15	621.25	27966.0
2025-07-09 07:00:00	SPY	ETF	621.39	622.0	621.25	621.73	88184.0
2025-07-09 08:00:00	SPY	ETF	621.53	622.29	619.49	621.9	208976.0
2025-07-09 09:00:00	SPY	ETF	621.96	624.72	621.81	624.245	5592814.0
2025-07-09 10:00:00	SPY	ETF	624.23	624.54	621.07	621.44	9451341.0
2025-07-09 11:00:00	SPY	ETF	621.44	622.54	620.9105	621.93	6716806.0
2025-07-09 12:00:00	SPY	ETF	621.93	622.41	621.55	622.02	3662899.0
2025-07-09 13:00:00	SPY	ETF	622.01	622.79	621.62	622.465	4576201.0
2025-07-09 14:00:00	SPY	ETF	622.45	623.57	622.3932	623.4	5357323.0
2025-07-09 15:00:00	SPY	ETF	623.405	624.21	623.1	624.03	11187234.0
2025-07-09 16:00:00	SPY	ETF	624.01	625.8642	623.56	623.91	2496874.0
2025-07-09 17:00:00	SPY	ETF	623.9	624.02	623.83	623.99	97139.0
2025-07-09 18:00:00	SPY	ETF	623.96	624.46	623.6875	624.25	80882.0
2025-07-09 19:00:00	SPY	ETF	624.26	624.26	623.58	623.6788	74919.0
2025-07-09 04:00:00	QQQ	ETF	552.43	552.61	552.16	552.39	24387.0
2025-07-09 05:00:00	QQQ	ETF	552.4	553.55	552.4	553.14	27427.0
2025-07-09 06:00:00	QQQ	ETF	553.11	553.41	552.86	553.14	20783.0
2025-07-09 07:00:00	QQQ	ETF	553.14	553.84	553.1	553.53	35228.0
2025-07-09 08:00:00	QQQ	ETF	553.23	553.91	551.43	553.43	175771.0
2025-07-09 09:00:00	QQQ	ETF	553.45	557.2953	553.36	557.04	4138647.0
2025-07-09 10:00:00	QQQ	ETF	557.03	557.63	553.2899	553.74	6841522.0
2025-07-09 11:00:00	QQQ	ETF	553.74	554.74	553.1	553.785	4457005.0
2025-07-09 12:00:00	QQQ	ETF	553.78	555.205	553.54	554.605	2870252.0
2025-07-09 13:00:00	QQQ	ETF	554.6	555.02	554.09	554.63	3206357.0
2025-07-09 14:00:00	QQQ	ETF	554.6	555.92	554.56	555.755	3040372.0
2025-07-09 15:00:00	QQQ	ETF	555.76	556.38	555.54	556.26	5387579.0
2025-07-09 16:00:00	QQQ	ETF	556.25	556.45	554.876	556.05	1183729.0
2025-07-09 17:00:00	QQQ	ETF	555.99	556.09	555.89	556.06	21637.0
2025-07-09 18:00:00	QQQ	ETF	556.02	556.54	555.86	556.37	43055.0
2025-07-09 19:00:00	QQQ	ETF	556.4	556.41	555.8	555.86	46608.0
2025-07-09 04:00:00	IWM	ETF	221.04	221.35	220.69	220.96	45981.0
2025-07-09 05:00:00	IWM	ETF	221.0	221.63	220.99	221.43	9853.0
2025-07-09 06:00:00	IWM	ETF	221.33	221.54	221.23	221.36	8209.0
2025-07-09 07:00:00	IWM	ETF	221.35	222.0	221.28	221.87	76821.0
2025-07-09 08:00:00	IWM	ETF	221.49	221.9996	220.52	221.73	67615.0
2025-07-09 09:00:00	IWM	ETF	221.84	223.145	221.8	222.47	3532127.0
2025-07-09 10:00:00	IWM	ETF	222.475	222.65	221.175	221.45	4523979.0
2025-07-09 11:00:00	IWM	ETF	221.44	222.17	221.115	222.12	2781328.0
2025-07-09 12:00:00	IWM	ETF	222.12	222.425	221.96	222.29	2428665.0
2025-07-09 13:00:00	IWM	ETF	222.29	223.0	222.19	222.85	2715452.0
2025-07-09 14:00:00	IWM	ETF	222.84	223.41	222.64	222.92	2666410.0
2025-07-09 15:00:00	IWM	ETF	222.92	223.69	222.725	223.63	4777718.0
2025-07-09 16:00:00	IWM	ETF	223.65	223.85	223.47	223.65	1776652.0
2025-07-09 17:00:00	IWM	ETF	223.61	223.75	223.48	223.6	33566.0
2025-07-09 18:00:00	IWM	ETF	223.61	223.94	223.49	223.72	28221.0
2025-07-09 19:00:00	IWM	ETF	223.71	223.76	223.46	223.53	20301.0
2025-07-09 04:00:00	DIA	ETF	442.16	442.85	442.16	442.7	1000.0
2025-07-09 05:00:00	DIA	ETF	443.1	443.34	443.1	443.34	500.0

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

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