PREVIEW / etf_1hour / 2025-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-28.parquet
  size:    724 KB
  rows:    27,913

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-10-28 04:00:00	SPY	ETF	684.9	685.21	684.69	685.12	27157.0
2025-10-28 05:00:00	SPY	ETF	685.18	685.3	684.94	685.27	24922.0
2025-10-28 06:00:00	SPY	ETF	685.25	685.55	685.18	685.28	56720.0
2025-10-28 07:00:00	SPY	ETF	685.28	685.9	685.2	685.83	68274.0
2025-10-28 08:00:00	SPY	ETF	685.28	686.33	684.72	686.09	190021.0
2025-10-28 09:00:00	SPY	ETF	686.1309	687.23	685.12	685.6201	6104494.0
2025-10-28 10:00:00	SPY	ETF	685.71	686.37	685.5	685.85	4718739.0
2025-10-28 11:00:00	SPY	ETF	685.86	686.21	684.83	685.58	3271857.0
2025-10-28 12:00:00	SPY	ETF	685.58	688.32	685.58	686.9	5071298.0
2025-10-28 13:00:00	SPY	ETF	686.88	687.71	686.86	687.6017	3720753.0
2025-10-28 14:00:00	SPY	ETF	687.61	688.4	687.54	688.155	4284192.0
2025-10-28 15:00:00	SPY	ETF	688.148	688.905	686.905	686.98	11506169.0
2025-10-28 16:00:00	SPY	ETF	686.98	687.21	686.1	687.19	2406035.0
2025-10-28 17:00:00	SPY	ETF	687.21	687.34	687.01	687.34	51678.0
2025-10-28 18:00:00	SPY	ETF	687.27	687.53	686.96	687.01	41538.0
2025-10-28 19:00:00	SPY	ETF	687.0299	687.33	686.9	687.28	40452.0
2025-10-28 04:00:00	QQQ	ETF	628.09	628.58	627.74	628.33	118663.0
2025-10-28 05:00:00	QQQ	ETF	628.35	628.62	628.22	628.56	52850.0
2025-10-28 06:00:00	QQQ	ETF	628.53	629.0	628.34	628.57	84125.0
2025-10-28 07:00:00	QQQ	ETF	628.58	629.2	628.57	629.03	165263.0
2025-10-28 08:00:00	QQQ	ETF	627.91	629.7	627.619	629.42	411469.0
2025-10-28 09:00:00	QQQ	ETF	629.37	631.36	629.37	630.585	5343252.0
2025-10-28 10:00:00	QQQ	ETF	630.66	630.9084	629.28	629.9071	4553427.0
2025-10-28 11:00:00	QQQ	ETF	629.91	630.535	629.25	630.5299	2548536.0
2025-10-28 12:00:00	QQQ	ETF	630.55	632.58	630.5484	631.665	4978104.0
2025-10-28 13:00:00	QQQ	ETF	631.66	632.87	631.55	632.75	4367039.0
2025-10-28 14:00:00	QQQ	ETF	632.76	633.79	632.61	633.78	3635724.0
2025-10-28 15:00:00	QQQ	ETF	633.775	634.68	632.86	632.89	7678635.0
2025-10-28 16:00:00	QQQ	ETF	632.91	633.37	632.68	633.23	2338544.0
2025-10-28 17:00:00	QQQ	ETF	633.28	633.86	633.07	633.75	103578.0
2025-10-28 18:00:00	QQQ	ETF	633.75	633.75	633.2	633.27	168627.0
2025-10-28 19:00:00	QQQ	ETF	633.3	633.63	633.05	633.51	71701.0
2025-10-28 04:00:00	IWM	ETF	249.5	249.59	249.25	249.41	52447.0
2025-10-28 05:00:00	IWM	ETF	249.47	249.55	249.3	249.51	34661.0
2025-10-28 06:00:00	IWM	ETF	249.43	249.53	249.25	249.41	30650.0
2025-10-28 07:00:00	IWM	ETF	249.44	249.74	249.35	249.74	50261.0
2025-10-28 08:00:00	IWM	ETF	249.45	249.93	249.3496	249.69	119245.0
2025-10-28 09:00:00	IWM	ETF	249.76	250.01	248.11	248.75	3668665.0
2025-10-28 10:00:00	IWM	ETF	248.7464	250.23	248.51	249.8075	2709725.0
2025-10-28 11:00:00	IWM	ETF	249.8	250.07	249.085	249.58	1772169.0
2025-10-28 12:00:00	IWM	ETF	249.58	250.9	249.5501	250.4	2704002.0
2025-10-28 13:00:00	IWM	ETF	250.39	250.62	249.6848	249.98	1746905.0
2025-10-28 14:00:00	IWM	ETF	249.98	250.26	249.49	249.61	1649188.0
2025-10-28 15:00:00	IWM	ETF	249.585	249.595	248.46	248.92	5380497.0
2025-10-28 16:00:00	IWM	ETF	248.92	249.1	248.62	248.66	878388.0
2025-10-28 17:00:00	IWM	ETF	248.63	248.81	248.3	248.81	49135.0
2025-10-28 18:00:00	IWM	ETF	248.8	248.87	248.5302	248.68	52987.0
2025-10-28 19:00:00	IWM	ETF	248.63	248.76	248.57	248.69	25715.0
2025-10-28 04:00:00	DIA	ETF	475.25	475.46	475.25	475.46	1103.0
2025-10-28 05:00:00	DIA	ETF	475.55	476.23	475.27	476.22	4350.0

> showing 50 of 27,913 rows — these rows as CSV

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