PREVIEW / etf_1hour / 2025-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-08-07.parquet
  size:    674 KB
  rows:    25,897

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-07 04:00:00	SPY	ETF	634.99	636.5	634.48	636.21	89748.0
2025-08-07 05:00:00	SPY	ETF	635.87	637.5	635.87	637.35	94370.0
2025-08-07 06:00:00	SPY	ETF	637.32	638.18	636.73	636.77	93292.0
2025-08-07 07:00:00	SPY	ETF	636.76	637.28	636.17	636.29	105174.0
2025-08-07 08:00:00	SPY	ETF	636.75	638.14	633.92	636.35	502863.0
2025-08-07 09:00:00	SPY	ETF	636.37	636.98	632.93	636.48	6451581.0
2025-08-07 10:00:00	SPY	ETF	636.49	636.82	632.39	632.72	10104290.0
2025-08-07 11:00:00	SPY	ETF	632.73	633.14	631.35	631.8946	6595157.0
2025-08-07 12:00:00	SPY	ETF	631.86	632.61	630.07	631.24	6442558.0
2025-08-07 13:00:00	SPY	ETF	631.24	631.87	629.69	630.74	6309176.0
2025-08-07 14:00:00	SPY	ETF	630.74	631.0399	629.11	630.5107	5743809.0
2025-08-07 15:00:00	SPY	ETF	630.5213	632.36	630.01	632.3	9416959.0
2025-08-07 16:00:00	SPY	ETF	632.29	633.25	632.18	632.93	2887076.0
2025-08-07 17:00:00	SPY	ETF	632.8017	632.96	632.0938	632.87	384409.0
2025-08-07 18:00:00	SPY	ETF	632.85	633.83	632.8	633.53	136266.0
2025-08-07 19:00:00	SPY	ETF	633.48	633.6196	633.17	633.3	29513.0
2025-08-07 04:00:00	QQQ	ETF	569.4	570.96	569.27	570.6	123515.0
2025-08-07 05:00:00	QQQ	ETF	570.3	571.73	570.19	571.6	44990.0
2025-08-07 06:00:00	QQQ	ETF	571.6	572.19	571.55	571.91	82975.0
2025-08-07 07:00:00	QQQ	ETF	572.02	572.38	571.1	571.21	121029.0
2025-08-07 08:00:00	QQQ	ETF	571.9	572.5	566.895	571.52	277846.0
2025-08-07 09:00:00	QQQ	ETF	571.6201	573.02	570.8896	572.92	4562270.0
2025-08-07 10:00:00	QQQ	ETF	572.92	573.32	569.67	570.15	5748182.0
2025-08-07 11:00:00	QQQ	ETF	570.15	570.64	568.69	569.19	3700899.0
2025-08-07 12:00:00	QQQ	ETF	569.17	569.55	566.575	568.2701	3958588.0
2025-08-07 13:00:00	QQQ	ETF	568.27	568.8874	566.375	567.27	3305223.0
2025-08-07 14:00:00	QQQ	ETF	567.27	567.54	565.11	566.9601	3703590.0
2025-08-07 15:00:00	QQQ	ETF	566.96	569.31	566.345	569.2599	5000912.0
2025-08-07 16:00:00	QQQ	ETF	569.26	570.02	569.1599	569.75	1195817.0
2025-08-07 17:00:00	QQQ	ETF	569.58	569.7287	569.18	569.44	84249.0
2025-08-07 18:00:00	QQQ	ETF	569.48	570.79	569.48	570.48	159451.0
2025-08-07 19:00:00	QQQ	ETF	570.4	570.54	570.1	570.2	65238.0
2025-08-07 04:00:00	IWM	ETF	221.27	222.09	221.26	221.99	21184.0
2025-08-07 05:00:00	IWM	ETF	221.98	222.61	221.93	222.5	35348.0
2025-08-07 06:00:00	IWM	ETF	222.53	222.87	222.46	222.76	43996.0
2025-08-07 07:00:00	IWM	ETF	222.77	223.02	222.49	222.55	144998.0
2025-08-07 08:00:00	IWM	ETF	221.7	222.9401	220.72	222.69	190174.0
2025-08-07 09:00:00	IWM	ETF	222.75	222.93	221.11	221.54	4185760.0
2025-08-07 10:00:00	IWM	ETF	221.55	221.71	219.33	219.515	5092905.0
2025-08-07 11:00:00	IWM	ETF	219.51	219.83	218.8	219.25	4569667.0
2025-08-07 12:00:00	IWM	ETF	219.21	220.175	218.74	219.265	3589724.0
2025-08-07 13:00:00	IWM	ETF	219.275	219.66	218.62	219.29	3281934.0
2025-08-07 14:00:00	IWM	ETF	219.28	219.47	218.505	219.36	3130935.0
2025-08-07 15:00:00	IWM	ETF	219.355	219.9	218.88	219.86	4797276.0
2025-08-07 16:00:00	IWM	ETF	219.87	220.55	219.84	220.55	689571.0
2025-08-07 17:00:00	IWM	ETF	220.54	220.59	220.24	220.28	36457.0
2025-08-07 18:00:00	IWM	ETF	220.37	220.94	220.36	220.7601	37372.0
2025-08-07 19:00:00	IWM	ETF	220.76	220.837	220.68	220.7201	10338.0
2025-08-07 04:00:00	DIA	ETF	443.19	443.61	443.1	443.4	3622.0
2025-08-07 05:00:00	DIA	ETF	443.3	444.48	443.3	444.39	4200.0

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

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