PREVIEW / etf_1hour / 2025-08-05

all etf 1-hour files

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

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-05 04:00:00	SPY	ETF	631.62	632.96	631.33	631.74	53866.0
2025-08-05 05:00:00	SPY	ETF	631.69	632.27	631.64	631.96	61717.0
2025-08-05 06:00:00	SPY	ETF	632.1	632.87	632.05	632.73	33435.0
2025-08-05 07:00:00	SPY	ETF	632.7	632.88	632.11	632.65	178187.0
2025-08-05 08:00:00	SPY	ETF	632.67	633.1	631.62	631.86	452491.0
2025-08-05 09:00:00	SPY	ETF	631.86	632.6052	631.22	631.9	5054139.0
2025-08-05 10:00:00	SPY	ETF	631.63	631.85	627.04	627.91	11566040.0
2025-08-05 11:00:00	SPY	ETF	627.915	628.67	627.16	628.09	6479061.0
2025-08-05 12:00:00	SPY	ETF	628.075	629.8	627.8	628.92	5328989.0
2025-08-05 13:00:00	SPY	ETF	628.89	630.32	628.68	630.13	3344368.0
2025-08-05 14:00:00	SPY	ETF	630.14	630.225	627.87	628.43	6128459.0
2025-08-05 15:00:00	SPY	ETF	628.44	629.11	627.81	628.0	8817216.0
2025-08-05 16:00:00	SPY	ETF	628.02	628.85	627.58	627.89	2408783.0
2025-08-05 17:00:00	SPY	ETF	627.73	628.16	627.69	627.78	100751.0
2025-08-05 18:00:00	SPY	ETF	627.88	628.24	626.86	627.76	115588.0
2025-08-05 19:00:00	SPY	ETF	627.67	628.0596	627.12	627.23	65670.0
2025-08-05 04:00:00	QQQ	ETF	565.0	566.0	564.59	565.03	59461.0
2025-08-05 05:00:00	QQQ	ETF	565.07	565.47	564.98	565.4	28190.0
2025-08-05 06:00:00	QQQ	ETF	565.39	566.45	565.39	566.29	48733.0
2025-08-05 07:00:00	QQQ	ETF	566.25	566.57	565.8	566.26	119265.0
2025-08-05 08:00:00	QQQ	ETF	566.31	566.721	563.677	565.76	491008.0
2025-08-05 09:00:00	QQQ	ETF	565.72	566.5608	564.315	566.07	4142540.0
2025-08-05 10:00:00	QQQ	ETF	566.01	566.15	560.3	561.36	7119204.0
2025-08-05 11:00:00	QQQ	ETF	561.35	562.2671	559.73	560.76	5080342.0
2025-08-05 12:00:00	QQQ	ETF	560.74	562.41	560.3	561.33	3581434.0
2025-08-05 13:00:00	QQQ	ETF	561.31	563.07	561.01	562.79	2254530.0
2025-08-05 14:00:00	QQQ	ETF	562.8	562.97	559.785	560.55	3841312.0
2025-08-05 15:00:00	QQQ	ETF	560.56	561.26	559.89	560.19	4864970.0
2025-08-05 16:00:00	QQQ	ETF	560.2	560.97	559.0	559.07	1465716.0
2025-08-05 17:00:00	QQQ	ETF	559.2	559.7	559.07	559.15	69569.0
2025-08-05 18:00:00	QQQ	ETF	559.1	559.6	558.11	559.03	143283.0
2025-08-05 19:00:00	QQQ	ETF	559.02	559.27	558.24	558.24	102573.0
2025-08-05 04:00:00	IWM	ETF	220.63	220.63	219.86	220.04	76845.0
2025-08-05 05:00:00	IWM	ETF	220.04	220.51	220.01	220.4	22727.0
2025-08-05 06:00:00	IWM	ETF	220.46	220.8	220.43	220.75	17689.0
2025-08-05 07:00:00	IWM	ETF	220.65	221.0	220.55	220.94	34903.0
2025-08-05 08:00:00	IWM	ETF	220.76	221.2	220.14	220.56	213097.0
2025-08-05 09:00:00	IWM	ETF	220.53	221.26	219.9	221.11	3146531.0
2025-08-05 10:00:00	IWM	ETF	221.05	221.11	218.235	218.99	6447742.0
2025-08-05 11:00:00	IWM	ETF	218.99	219.52	218.81	219.45	2295007.0
2025-08-05 12:00:00	IWM	ETF	219.44	220.555	219.39	220.245	2752253.0
2025-08-05 13:00:00	IWM	ETF	220.24	221.01	220.075	220.93	1608739.0
2025-08-05 14:00:00	IWM	ETF	220.93	220.945	219.93	220.38	2424033.0
2025-08-05 15:00:00	IWM	ETF	220.39	221.04	220.35	220.86	4535340.0
2025-08-05 16:00:00	IWM	ETF	220.87	221.1	220.73	220.89	876491.0
2025-08-05 17:00:00	IWM	ETF	220.75	221.01	220.75	220.86	30928.0
2025-08-05 18:00:00	IWM	ETF	220.9	221.1	220.63	220.99	39008.0
2025-08-05 19:00:00	IWM	ETF	220.95	221.1	220.71	220.71	31198.0
2025-08-05 04:00:00	DIA	ETF	441.98	442.32	441.98	442.01	2671.0
2025-08-05 05:00:00	DIA	ETF	442.08	442.41	442.06	442.26	1400.0

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

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