PREVIEW / etf_1hour / 2025-08-22

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-22.parquet
  size:    665 KB
  rows:    25,473

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-22 04:00:00	SPY	ETF	636.02	637.42	635.97	637.03	51551.0
2025-08-22 05:00:00	SPY	ETF	637.22	637.26	636.93	637.26	7254.0
2025-08-22 06:00:00	SPY	ETF	637.3	637.54	637.22	637.41	6419.0
2025-08-22 07:00:00	SPY	ETF	637.42	637.54	636.87	636.97	148646.0
2025-08-22 08:00:00	SPY	ETF	637.43	637.57	633.85	637.02	258255.0
2025-08-22 09:00:00	SPY	ETF	636.99	639.72	636.92	638.41	5647635.0
2025-08-22 10:00:00	SPY	ETF	638.41	646.17	638.41	645.6458	19165761.0
2025-08-22 11:00:00	SPY	ETF	645.65	646.5	645.3	645.41	7590962.0
2025-08-22 12:00:00	SPY	ETF	645.415	645.91	644.295	644.72	4334754.0
2025-08-22 13:00:00	SPY	ETF	644.7	646.4	644.7	645.77	4250148.0
2025-08-22 14:00:00	SPY	ETF	645.785	646.04	645.255	645.45	4962591.0
2025-08-22 15:00:00	SPY	ETF	645.45	645.64	644.295	645.27	14651021.0
2025-08-22 16:00:00	SPY	ETF	645.25	645.59	644.94	645.4	2480139.0
2025-08-22 17:00:00	SPY	ETF	645.43	645.58	645.15	645.29	81829.0
2025-08-22 18:00:00	SPY	ETF	645.29	645.61	645.25	645.61	40053.0
2025-08-22 19:00:00	SPY	ETF	645.6	645.72	645.44	645.5	20240.0
2025-08-22 04:00:00	QQQ	ETF	563.01	564.43	562.91	564.36	74223.0
2025-08-22 05:00:00	QQQ	ETF	564.32	564.42	563.89	564.37	22056.0
2025-08-22 06:00:00	QQQ	ETF	564.36	564.91	564.36	564.64	62905.0
2025-08-22 07:00:00	QQQ	ETF	564.66	565.0	564.13	564.33	142663.0
2025-08-22 08:00:00	QQQ	ETF	564.72	564.99	560.45	564.14	288783.0
2025-08-22 09:00:00	QQQ	ETF	564.16	566.54	563.27	564.71	4151347.0
2025-08-22 10:00:00	QQQ	ETF	564.76	573.88	564.75	572.885	12245479.0
2025-08-22 11:00:00	QQQ	ETF	572.9	573.99	571.965	572.05	4017913.0
2025-08-22 12:00:00	QQQ	ETF	572.07	572.59	570.57	571.075	3279373.0
2025-08-22 13:00:00	QQQ	ETF	571.07	573.41	571.07	572.9499	3494498.0
2025-08-22 14:00:00	QQQ	ETF	572.985	573.21	572.38	572.4792	2019005.0
2025-08-22 15:00:00	QQQ	ETF	572.47	572.64	571.14	571.99	5577326.0
2025-08-22 16:00:00	QQQ	ETF	571.98	572.5	571.62	572.4	1316356.0
2025-08-22 17:00:00	QQQ	ETF	572.39	572.42	572.16	572.25	50248.0
2025-08-22 18:00:00	QQQ	ETF	572.24	572.49	572.12	572.49	14774.0
2025-08-22 19:00:00	QQQ	ETF	572.46	572.8	572.35	572.64	34576.0
2025-08-22 04:00:00	IWM	ETF	226.81	227.1	226.72	227.09	37898.0
2025-08-22 05:00:00	IWM	ETF	227.09	227.16	227.02	227.09	8222.0
2025-08-22 06:00:00	IWM	ETF	227.12	227.36	227.11	227.33	13064.0
2025-08-22 07:00:00	IWM	ETF	227.29	227.33	227.03	227.08	34755.0
2025-08-22 08:00:00	IWM	ETF	227.04	227.32	225.59	227.04	380308.0
2025-08-22 09:00:00	IWM	ETF	227.04	228.04	226.98	227.51	2486862.0
2025-08-22 10:00:00	IWM	ETF	227.56	234.965	227.51	234.87	14441721.0
2025-08-22 11:00:00	IWM	ETF	234.875	235.42	234.54	234.58	5269021.0
2025-08-22 12:00:00	IWM	ETF	234.6	235.2201	234.24	234.4901	3582083.0
2025-08-22 13:00:00	IWM	ETF	234.49	235.025	234.48	234.53	1892994.0
2025-08-22 14:00:00	IWM	ETF	234.52	234.78	234.25	234.485	3215100.0
2025-08-22 15:00:00	IWM	ETF	234.49	235.33	234.35	234.79	7976772.0
2025-08-22 16:00:00	IWM	ETF	234.79	235.12	234.75	234.98	2486784.0
2025-08-22 17:00:00	IWM	ETF	235.04	235.28	234.9	235.07	17779.0
2025-08-22 18:00:00	IWM	ETF	235.07	235.19	235.02	235.19	8446.0
2025-08-22 19:00:00	IWM	ETF	235.19	235.25	235.14	235.15	14959.0
2025-08-22 04:00:00	DIA	ETF	448.74	449.2	448.65	449.06	2350.0
2025-08-22 05:00:00	DIA	ETF	449.37	449.45	449.36	449.43	700.0

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

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