PREVIEW / etf_1hour / 2025-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-31.parquet
  size:    702 KB
  rows:    27,261

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-31 04:00:00	SPY	ETF	685.1	685.46	684.53	685.15	22250.0
2025-10-31 05:00:00	SPY	ETF	685.12	685.4	684.75	684.81	26096.0
2025-10-31 06:00:00	SPY	ETF	684.81	684.87	684.18	684.66	28739.0
2025-10-31 07:00:00	SPY	ETF	684.66	685.9	684.36	685.54	357541.0
2025-10-31 08:00:00	SPY	ETF	684.74	686.6	684.25	685.39	678630.0
2025-10-31 09:00:00	SPY	ETF	685.36	685.41	682.865	683.47	5734550.0
2025-10-31 10:00:00	SPY	ETF	683.46	684.75	682.21	684.47	5796850.0
2025-10-31 11:00:00	SPY	ETF	684.45	684.745	682.1	682.19	5891634.0
2025-10-31 12:00:00	SPY	ETF	682.19	682.45	680.13	680.38	6156127.0
2025-10-31 13:00:00	SPY	ETF	680.37	681.49	679.24	680.87	5558052.0
2025-10-31 14:00:00	SPY	ETF	680.86	682.75	680.81	682.615	5154669.0
2025-10-31 15:00:00	SPY	ETF	682.62	684.8	681.93	681.99	16588457.0
2025-10-31 16:00:00	SPY	ETF	681.96	682.25	681.47	682.0	3905761.0
2025-10-31 17:00:00	SPY	ETF	682.02	682.18	681.91	682.16	74348.0
2025-10-31 18:00:00	SPY	ETF	682.17	682.18	681.95	682.02	4831.0
2025-10-31 19:00:00	SPY	ETF	682.1269	682.1348	681.71	681.7501	28671.0
2025-10-31 04:00:00	QQQ	ETF	634.67	634.67	633.19	634.15	140036.0
2025-10-31 05:00:00	QQQ	ETF	634.22	634.48	633.26	633.8	88705.0
2025-10-31 06:00:00	QQQ	ETF	633.83	634.1	633.31	633.78	128241.0
2025-10-31 07:00:00	QQQ	ETF	633.79	634.93	633.45	634.69	229493.0
2025-10-31 08:00:00	QQQ	ETF	634.69	635.93	625.581	634.48	947293.0
2025-10-31 09:00:00	QQQ	ETF	634.47	634.61	631.35	631.8785	5137838.0
2025-10-31 10:00:00	QQQ	ETF	631.87	633.73	630.85	633.34	5807400.0
2025-10-31 11:00:00	QQQ	ETF	633.34	633.75	630.55	630.59	5360664.0
2025-10-31 12:00:00	QQQ	ETF	630.58	630.63	627.71	628.13	5328061.0
2025-10-31 13:00:00	QQQ	ETF	628.12	628.9	626.69	628.076	5484035.0
2025-10-31 14:00:00	QQQ	ETF	628.11	629.91	628.04	629.71	3615272.0
2025-10-31 15:00:00	QQQ	ETF	629.705	632.24	629.17	629.19	8549695.0
2025-10-31 16:00:00	QQQ	ETF	629.19	629.9283	628.59	629.01	1671639.0
2025-10-31 17:00:00	QQQ	ETF	629.1	629.2	628.8999	629.14	29665.0
2025-10-31 18:00:00	QQQ	ETF	629.14	629.24	629.1	629.2	6749.0
2025-10-31 19:00:00	QQQ	ETF	629.18	629.2	629.03	629.05	16373.0
2025-10-31 04:00:00	IWM	ETF	245.12	245.12	244.54	244.85	46997.0
2025-10-31 05:00:00	IWM	ETF	244.9	245.0	244.65	244.75	10924.0
2025-10-31 06:00:00	IWM	ETF	244.72	244.72	244.38	244.48	26258.0
2025-10-31 07:00:00	IWM	ETF	244.5	245.08	244.37	244.97	187087.0
2025-10-31 08:00:00	IWM	ETF	244.4991	245.51	244.34	244.97	337205.0
2025-10-31 09:00:00	IWM	ETF	244.93	246.015	243.7	246.0	4127876.0
2025-10-31 10:00:00	IWM	ETF	246.005	246.445	245.27	246.33	3638648.0
2025-10-31 11:00:00	IWM	ETF	246.34	246.46	245.12	245.12	3030373.0
2025-10-31 12:00:00	IWM	ETF	245.12	245.3488	243.99	244.22	2982514.0
2025-10-31 13:00:00	IWM	ETF	244.21	244.88	243.69	244.73	3083266.0
2025-10-31 14:00:00	IWM	ETF	244.72	245.83	244.71	245.73	2511917.0
2025-10-31 15:00:00	IWM	ETF	245.735	246.79	245.64	246.27	6254863.0
2025-10-31 16:00:00	IWM	ETF	246.23	246.5	245.95	246.34	1671203.0
2025-10-31 17:00:00	IWM	ETF	246.17	246.35	246.11	246.18	13607.0
2025-10-31 18:00:00	IWM	ETF	246.18	246.23	246.1199	246.16	14046.0
2025-10-31 19:00:00	IWM	ETF	246.19	246.25	246.02	246.11	5447.0
2025-10-31 04:00:00	DIA	ETF	475.87	475.92	475.55	475.55	2976.0
2025-10-31 05:00:00	DIA	ETF	475.57	475.57	475.46	475.5	1000.0

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

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