PREVIEW / etf_1hour / 2025-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-10-07.parquet
  size:    704 KB
  rows:    27,155

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-07 04:00:00	SPY	ETF	670.87	671.22	670.35	671.19	15577.0
2025-10-07 05:00:00	SPY	ETF	671.2	671.55	671.14	671.52	12140.0
2025-10-07 06:00:00	SPY	ETF	671.52	671.84	671.37	671.5	35998.0
2025-10-07 07:00:00	SPY	ETF	671.42	672.02	671.39	672.02	59357.0
2025-10-07 08:00:00	SPY	ETF	670.8	672.79	670.47	672.7	225445.0
2025-10-07 09:00:00	SPY	ETF	672.72	673.1	672.07	672.23	5722110.0
2025-10-07 10:00:00	SPY	ETF	672.23	672.37	670.58	670.9	7075984.0
2025-10-07 11:00:00	SPY	ETF	670.93	671.09	667.67	668.25	16023667.0
2025-10-07 12:00:00	SPY	ETF	668.26	669.54	667.67	668.3692	7178246.0
2025-10-07 13:00:00	SPY	ETF	668.365	669.39	668.18	668.33	3806444.0
2025-10-07 14:00:00	SPY	ETF	668.34	669.0779	667.81	669.05	3882302.0
2025-10-07 15:00:00	SPY	ETF	669.035	669.4	668.53	669.13	8900549.0
2025-10-07 16:00:00	SPY	ETF	669.13	669.62	669.0622	669.39	3114270.0
2025-10-07 17:00:00	SPY	ETF	669.37	669.48	669.29	669.32	28656.0
2025-10-07 18:00:00	SPY	ETF	669.32	669.87	669.32	669.83	66873.0
2025-10-07 19:00:00	SPY	ETF	669.77	669.77	668.8	668.87	57932.0
2025-10-07 20:00:00	SPY	ETF	668.85	668.85	668.85	668.85	480.0
2025-10-07 04:00:00	QQQ	ETF	607.2	607.55	606.5	607.51	80189.0
2025-10-07 05:00:00	QQQ	ETF	607.53	608.0	607.42	607.98	66744.0
2025-10-07 06:00:00	QQQ	ETF	607.97	608.1	607.55	607.57	50620.0
2025-10-07 07:00:00	QQQ	ETF	607.59	608.45	607.5	608.44	57073.0
2025-10-07 08:00:00	QQQ	ETF	608.45	609.53	606.79	609.45	356488.0
2025-10-07 09:00:00	QQQ	ETF	609.46	609.94	608.58	609.16	4656356.0
2025-10-07 10:00:00	QQQ	ETF	609.17	609.54	607.53	607.84	5184181.0
2025-10-07 11:00:00	QQQ	ETF	607.85	607.96	603.03	604.14	11286932.0
2025-10-07 12:00:00	QQQ	ETF	604.13	605.63	603.36	604.01	5745404.0
2025-10-07 13:00:00	QQQ	ETF	604.01	604.97	603.74	603.79	3168341.0
2025-10-07 14:00:00	QQQ	ETF	603.8	604.7	603.21	604.69	3100251.0
2025-10-07 15:00:00	QQQ	ETF	604.68	605.12	604.06	604.47	4803168.0
2025-10-07 16:00:00	QQQ	ETF	604.48	605.1004	604.48	604.75	1129226.0
2025-10-07 17:00:00	QQQ	ETF	604.86	604.89	604.6	604.72	36923.0
2025-10-07 18:00:00	QQQ	ETF	604.73	605.35	604.72	605.28	64017.0
2025-10-07 19:00:00	QQQ	ETF	605.23	605.23	604.12	604.1999	68762.0
2025-10-07 04:00:00	IWM	ETF	246.36	246.44	245.98	246.44	35399.0
2025-10-07 05:00:00	IWM	ETF	246.45	246.67	246.45	246.63	17630.0
2025-10-07 06:00:00	IWM	ETF	246.65	246.98	246.64	246.82	33249.0
2025-10-07 07:00:00	IWM	ETF	246.8	247.07	246.71	247.04	11250.0
2025-10-07 08:00:00	IWM	ETF	246.28	247.33	246.09	247.32	95474.0
2025-10-07 09:00:00	IWM	ETF	247.33	247.64	246.74	246.84	1785396.0
2025-10-07 10:00:00	IWM	ETF	246.84	247.0	245.48	245.7499	2893305.0
2025-10-07 11:00:00	IWM	ETF	245.74	245.97	243.19	243.75	4829219.0
2025-10-07 12:00:00	IWM	ETF	243.76	244.55	243.365	243.97	2751464.0
2025-10-07 13:00:00	IWM	ETF	243.97	244.57	243.76	243.83	1514348.0
2025-10-07 14:00:00	IWM	ETF	243.84	244.105	243.42	244.06	1939314.0
2025-10-07 15:00:00	IWM	ETF	244.06	244.34	243.82	244.15	4669057.0
2025-10-07 16:00:00	IWM	ETF	244.14	244.54	244.14	244.35	1303752.0
2025-10-07 17:00:00	IWM	ETF	244.37	244.5	244.26	244.4	8596.0
2025-10-07 18:00:00	IWM	ETF	244.48	244.56	244.35	244.46	32429.0
2025-10-07 19:00:00	IWM	ETF	244.35	244.37	243.91	243.92	29396.0
2025-10-07 04:00:00	DIA	ETF	465.7	466.03	465.54	466.03	1600.0

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

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