PREVIEW / etf_1hour / 2025-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-23.parquet
  size:    671 KB
  rows:    25,874

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-23 04:00:00	SPY	ETF	630.48	631.53	630.48	631.46	41887.0
2025-07-23 05:00:00	SPY	ETF	631.48	631.64	631.18	631.58	60469.0
2025-07-23 06:00:00	SPY	ETF	631.53	631.77	631.34	631.37	79659.0
2025-07-23 07:00:00	SPY	ETF	631.37	631.41	630.77	631.33	172599.0
2025-07-23 08:00:00	SPY	ETF	631.38	631.65	630.09	631.21	332512.0
2025-07-23 09:00:00	SPY	ETF	631.23	631.91	629.82	629.9992	5637958.0
2025-07-23 10:00:00	SPY	ETF	629.995	630.78	629.73	630.7	5022137.0
2025-07-23 11:00:00	SPY	ETF	630.7	632.79	630.325	632.065	6452000.0
2025-07-23 12:00:00	SPY	ETF	632.06	632.61	631.3495	631.86	4892265.0
2025-07-23 13:00:00	SPY	ETF	631.86	632.885	631.525	632.5118	5350385.0
2025-07-23 14:00:00	SPY	ETF	632.515	633.65	632.515	633.265	5175387.0
2025-07-23 15:00:00	SPY	ETF	633.28	634.16	632.94	634.16	10669558.0
2025-07-23 16:00:00	SPY	ETF	634.16	635.4	633.5	634.8	3168848.0
2025-07-23 17:00:00	SPY	ETF	634.8	635.0	634.39	634.58	240758.0
2025-07-23 18:00:00	SPY	ETF	634.61	634.66	634.3	634.35	75748.0
2025-07-23 19:00:00	SPY	ETF	634.37	634.71	634.3	634.6595	40109.0
2025-07-23 04:00:00	QQQ	ETF	562.27	562.81	562.21	562.79	30294.0
2025-07-23 05:00:00	QQQ	ETF	562.77	562.86	562.31	562.6	25361.0
2025-07-23 06:00:00	QQQ	ETF	562.64	562.84	562.42	562.53	33813.0
2025-07-23 07:00:00	QQQ	ETF	562.38	562.43	561.69	562.3	78199.0
2025-07-23 08:00:00	QQQ	ETF	562.35	562.79	561.59	561.67	234331.0
2025-07-23 09:00:00	QQQ	ETF	561.76	562.58	559.93	560.05	4616417.0
2025-07-23 10:00:00	QQQ	ETF	560.03	560.94	559.58	560.848	3629290.0
2025-07-23 11:00:00	QQQ	ETF	560.84	563.07	560.35	562.22	3995702.0
2025-07-23 12:00:00	QQQ	ETF	562.21	562.365	560.71	561.54	3703847.0
2025-07-23 13:00:00	QQQ	ETF	561.54	562.51	561.2	562.3607	2649353.0
2025-07-23 14:00:00	QQQ	ETF	562.36	563.8	562.36	563.27	2958424.0
2025-07-23 15:00:00	QQQ	ETF	563.29	563.84	562.5	563.83	4279029.0
2025-07-23 16:00:00	QQQ	ETF	563.85	566.03	563.36	565.87	2204332.0
2025-07-23 17:00:00	QQQ	ETF	565.88	566.27	565.31	565.55	166267.0
2025-07-23 18:00:00	QQQ	ETF	565.58	565.65	565.24	565.3181	70421.0
2025-07-23 19:00:00	QQQ	ETF	565.34	565.75	565.3	565.68	58686.0
2025-07-23 04:00:00	IWM	ETF	224.37	225.46	224.25	225.46	33375.0
2025-07-23 05:00:00	IWM	ETF	225.42	225.91	225.42	225.87	30236.0
2025-07-23 06:00:00	IWM	ETF	225.88	225.94	225.32	225.37	23524.0
2025-07-23 07:00:00	IWM	ETF	225.36	225.4	225.07	225.3	54229.0
2025-07-23 08:00:00	IWM	ETF	225.26	225.41	224.24	224.81	141102.0
2025-07-23 09:00:00	IWM	ETF	224.83	225.125	224.065	224.39	4821915.0
2025-07-23 10:00:00	IWM	ETF	224.38	225.8	224.35	225.645	5335222.0
2025-07-23 11:00:00	IWM	ETF	225.65	226.065	225.055	225.625	4347969.0
2025-07-23 12:00:00	IWM	ETF	225.61	226.13	225.36	225.54	2714501.0
2025-07-23 13:00:00	IWM	ETF	225.52	225.86	224.85	225.265	2822118.0
2025-07-23 14:00:00	IWM	ETF	225.26	226.015	225.235	225.715	1987825.0
2025-07-23 15:00:00	IWM	ETF	225.72	226.71	225.72	226.68	5498355.0
2025-07-23 16:00:00	IWM	ETF	226.68	226.8	226.11	226.38	1188692.0
2025-07-23 17:00:00	IWM	ETF	226.4	226.5	226.1509	226.5	17160.0
2025-07-23 18:00:00	IWM	ETF	226.42	226.67	226.15	226.15	10190.0
2025-07-23 19:00:00	IWM	ETF	226.12	226.58	226.09	226.21	33888.0
2025-07-23 04:00:00	DIA	ETF	446.21	446.89	446.2	446.88	1100.0
2025-07-23 05:00:00	DIA	ETF	447.18	447.39	447.18	447.31	900.0

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

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