PREVIEW / etf_1hour / 2025-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-31.parquet
  size:    627 KB
  rows:    23,934

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-01-31 04:00:00	SPY	ETF	606.27	608.06	606.25	607.62	21258.0
2025-01-31 05:00:00	SPY	ETF	607.65	607.88	607.59	607.59	5685.0
2025-01-31 06:00:00	SPY	ETF	607.69	608.1	607.66	608.07	7382.0
2025-01-31 07:00:00	SPY	ETF	608.1	608.15	607.7	607.81	236474.0
2025-01-31 08:00:00	SPY	ETF	607.8	608.15	606.43	607.9	244742.0
2025-01-31 09:00:00	SPY	ETF	607.85	608.16	606.97	608.11	2982099.0
2025-01-31 10:00:00	SPY	ETF	608.12	609.63	608.04	609.45	3694496.0
2025-01-31 11:00:00	SPY	ETF	609.46	609.96	608.53	608.89	2390753.0
2025-01-31 12:00:00	SPY	ETF	608.89	609.73	608.01	609.09	2538074.0
2025-01-31 13:00:00	SPY	ETF	609.1	609.345	604.81	605.385	6119143.0
2025-01-31 14:00:00	SPY	ETF	605.39	605.9	601.94	603.63	7667954.0
2025-01-31 15:00:00	SPY	ETF	603.6	603.6	601.05	601.8	13465690.0
2025-01-31 16:00:00	SPY	ETF	601.78	603.8626	601.1	601.83	5630902.0
2025-01-31 17:00:00	SPY	ETF	601.87	601.9575	601.32	601.5	73729.0
2025-01-31 18:00:00	SPY	ETF	601.49	601.5	600.6609	600.6638	30642.0
2025-01-31 19:00:00	SPY	ETF	600.67	600.68	598.81	598.98	50320.0
2025-01-31 04:00:00	QQQ	ETF	526.0	527.52	526.0	527.1	37380.0
2025-01-31 05:00:00	QQQ	ETF	527.14	527.32	526.9	527.12	33354.0
2025-01-31 06:00:00	QQQ	ETF	527.11	527.78	527.1	527.59	26863.0
2025-01-31 07:00:00	QQQ	ETF	527.64	527.83	527.16	527.2	82758.0
2025-01-31 08:00:00	QQQ	ETF	527.55	527.8299	522.658	527.34	339219.0
2025-01-31 09:00:00	QQQ	ETF	527.31	529.22	523.05	529.14	3043829.0
2025-01-31 10:00:00	QQQ	ETF	529.15	531.31	529.14	530.84	2991131.0
2025-01-31 11:00:00	QQQ	ETF	530.84	531.5178	529.41	530.06	2150094.0
2025-01-31 12:00:00	QQQ	ETF	530.0996	530.89	529.14	530.325	1863807.0
2025-01-31 13:00:00	QQQ	ETF	530.33	530.59	525.67	526.46	4013066.0
2025-01-31 14:00:00	QQQ	ETF	526.43	527.12	522.36	524.28	5025389.0
2025-01-31 15:00:00	QQQ	ETF	524.21	524.21	521.19	522.28	6540348.0
2025-01-31 16:00:00	QQQ	ETF	522.3	526.7618	521.16	521.95	1639200.0
2025-01-31 17:00:00	QQQ	ETF	521.9701	522.1	521.7797	521.78	62551.0
2025-01-31 18:00:00	QQQ	ETF	521.8599	521.875	521.11	521.123	12836.0
2025-01-31 19:00:00	QQQ	ETF	521.12	521.3	519.45	519.45	40835.0
2025-01-31 04:00:00	IWM	ETF	228.42	228.69	228.27	228.38	19892.0
2025-01-31 05:00:00	IWM	ETF	228.38	228.58	228.3	228.5	9043.0
2025-01-31 06:00:00	IWM	ETF	228.47	228.99	228.4	228.99	10964.0
2025-01-31 07:00:00	IWM	ETF	228.97	229.26	228.77	229.18	66363.0
2025-01-31 08:00:00	IWM	ETF	228.8901	229.64	228.27	229.14	164516.0
2025-01-31 09:00:00	IWM	ETF	229.08	229.1	228.18	228.61	1829086.0
2025-01-31 10:00:00	IWM	ETF	228.62	229.7	228.24	229.22	1771892.0
2025-01-31 11:00:00	IWM	ETF	229.26	229.59	228.95	229.16	1192718.0
2025-01-31 12:00:00	IWM	ETF	229.17	230.32	228.73	230.08	2325413.0
2025-01-31 13:00:00	IWM	ETF	230.08	230.19	226.54	226.92	5556856.0
2025-01-31 14:00:00	IWM	ETF	226.91	227.46	225.85	226.84	3797230.0
2025-01-31 15:00:00	IWM	ETF	226.82	227.29	225.535	226.43	5752114.0
2025-01-31 16:00:00	IWM	ETF	226.48	226.9	226.07	226.4	1895421.0
2025-01-31 17:00:00	IWM	ETF	226.39	226.48	226.1114	226.1114	8634.0
2025-01-31 18:00:00	IWM	ETF	226.11	226.37	225.82	225.82	2673.0
2025-01-31 19:00:00	IWM	ETF	225.83	226.1	225.04	225.35	7218.0
2025-01-31 04:00:00	DIA	ETF	450.14	450.65	450.07	450.29	2159.0
2025-01-31 05:00:00	DIA	ETF	450.35	450.35	450.35	450.35	100.0

> showing 50 of 23,934 rows — these rows as CSV

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