PREVIEW / etf_1hour / 2025-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-03.parquet
  size:    658 KB
  rows:    25,992

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-02-03 04:00:00	SPY	ETF	593.91	594.6	590.36	592.11	228394.0
2025-02-03 05:00:00	SPY	ETF	592.3	593.77	591.8	593.36	148301.0
2025-02-03 06:00:00	SPY	ETF	593.61	594.3	592.78	593.21	253428.0
2025-02-03 07:00:00	SPY	ETF	593.15	593.45	591.55	591.83	322552.0
2025-02-03 08:00:00	SPY	ETF	592.9	594.15	589.5	592.54	847388.0
2025-02-03 09:00:00	SPY	ETF	592.4	594.37	591.6	592.036	6821866.0
2025-02-03 10:00:00	SPY	ETF	591.97	598.65	590.49	597.88	11187984.0
2025-02-03 11:00:00	SPY	ETF	597.86	599.25	595.76	597.3399	5513834.0
2025-02-03 12:00:00	SPY	ETF	597.32	598.7	595.97	597.38	4473306.0
2025-02-03 13:00:00	SPY	ETF	597.3435	599.0	596.08	598.835	3132790.0
2025-02-03 14:00:00	SPY	ETF	598.81	600.29	598.5	599.68	2914213.0
2025-02-03 15:00:00	SPY	ETF	599.7	600.0258	597.39	597.65	7834891.0
2025-02-03 16:00:00	SPY	ETF	597.65	601.44	597.41	600.84	5017860.0
2025-02-03 17:00:00	SPY	ETF	600.82	601.75	600.66	601.75	181861.0
2025-02-03 18:00:00	SPY	ETF	601.9	602.05	600.74	601.08	118008.0
2025-02-03 19:00:00	SPY	ETF	600.97	600.97	600.23	600.44	105325.0
2025-02-03 04:00:00	QQQ	ETF	513.3	513.84	512.42	512.71	183364.0
2025-02-03 05:00:00	QQQ	ETF	512.65	514.27	512.22	513.91	140441.0
2025-02-03 06:00:00	QQQ	ETF	514.13	514.94	513.16	513.73	108375.0
2025-02-03 07:00:00	QQQ	ETF	513.73	513.86	512.09	512.62	496346.0
2025-02-03 08:00:00	QQQ	ETF	512.61	521.899	507.5	513.15	918339.0
2025-02-03 09:00:00	QQQ	ETF	513.2	515.84	512.5	513.52	4589400.0
2025-02-03 10:00:00	QQQ	ETF	513.5	519.25	511.05	518.47	7244314.0
2025-02-03 11:00:00	QQQ	ETF	518.4401	519.63	516.54	517.6	3330819.0
2025-02-03 12:00:00	QQQ	ETF	517.64	519.29	516.51	518.0	2983585.0
2025-02-03 13:00:00	QQQ	ETF	518.0	519.692	516.81	519.58	2375082.0
2025-02-03 14:00:00	QQQ	ETF	519.53	520.8496	519.1302	520.0526	1784711.0
2025-02-03 15:00:00	QQQ	ETF	520.08	520.54	517.94	518.145	3532890.0
2025-02-03 16:00:00	QQQ	ETF	518.14	522.27	517.7	521.68	2000738.0
2025-02-03 17:00:00	QQQ	ETF	521.64	522.61	521.64	522.6	176448.0
2025-02-03 18:00:00	QQQ	ETF	522.65	522.75	521.8	522.16	244134.0
2025-02-03 19:00:00	QQQ	ETF	522.25	522.2992	521.4	521.69	211515.0
2025-02-03 04:00:00	IWM	ETF	221.31	221.97	221.23	221.64	179762.0
2025-02-03 05:00:00	IWM	ETF	221.49	222.03	221.46	221.74	40851.0
2025-02-03 06:00:00	IWM	ETF	221.87	222.09	221.47	221.79	45085.0
2025-02-03 07:00:00	IWM	ETF	221.75	222.06	221.04	221.22	248674.0
2025-02-03 08:00:00	IWM	ETF	221.39	222.32	219.48	221.57	449286.0
2025-02-03 09:00:00	IWM	ETF	221.59	222.08	220.79	221.535	4947192.0
2025-02-03 10:00:00	IWM	ETF	221.51	225.55	220.67	224.9	7520491.0
2025-02-03 11:00:00	IWM	ETF	224.89	225.21	223.44	224.01	2568407.0
2025-02-03 12:00:00	IWM	ETF	224.02	224.66	223.12	223.78	2448961.0
2025-02-03 13:00:00	IWM	ETF	223.77	224.24	223.12	223.89	1549356.0
2025-02-03 14:00:00	IWM	ETF	223.88	224.66	223.86	224.45	1406164.0
2025-02-03 15:00:00	IWM	ETF	224.45	224.68	223.615	223.85	3088634.0
2025-02-03 16:00:00	IWM	ETF	223.86	226.1	223.7	225.29	1709573.0
2025-02-03 17:00:00	IWM	ETF	225.32	226.18	225.3	225.66	46732.0
2025-02-03 18:00:00	IWM	ETF	225.66	225.98	225.37	225.78	122566.0
2025-02-03 19:00:00	IWM	ETF	225.65	225.65	225.13	225.3699	33735.0
2025-02-03 04:00:00	DIA	ETF	439.98	440.21	439.23	439.23	19924.0
2025-02-03 05:00:00	DIA	ETF	439.01	439.91	439.01	439.85	3036.0

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

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