PREVIEW / etf_1hour / 2025-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-23.parquet
  size:    624 KB
  rows:    23,764

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-23 04:00:00	SPY	ETF	604.85	605.39	604.67	605.29	11123.0
2025-01-23 05:00:00	SPY	ETF	605.29	605.66	605.07	605.07	15733.0
2025-01-23 06:00:00	SPY	ETF	605.22	605.73	605.22	605.67	22354.0
2025-01-23 07:00:00	SPY	ETF	605.65	605.88	605.19	605.88	78059.0
2025-01-23 08:00:00	SPY	ETF	605.55	606.38	604.9104	605.909	146222.0
2025-01-23 09:00:00	SPY	ETF	605.93	606.3	605.52	606.2259	2070985.0
2025-01-23 10:00:00	SPY	ETF	606.24	606.91	605.62	606.89	2682678.0
2025-01-23 11:00:00	SPY	ETF	606.9	607.87	606.38	607.25	4365080.0
2025-01-23 12:00:00	SPY	ETF	607.25	607.69	606.9	607.68	2649192.0
2025-01-23 13:00:00	SPY	ETF	607.68	608.3	607.5999	607.75	2066806.0
2025-01-23 14:00:00	SPY	ETF	607.73	608.01	607.31	607.825	1693145.0
2025-01-23 15:00:00	SPY	ETF	607.79	609.74	607.6	609.71	6541684.0
2025-01-23 16:00:00	SPY	ETF	609.71	609.75	609.05	609.26	4685077.0
2025-01-23 17:00:00	SPY	ETF	609.28	609.75	609.23	609.25	63310.0
2025-01-23 18:00:00	SPY	ETF	609.25	609.25	608.95	609.15	119581.0
2025-01-23 19:00:00	SPY	ETF	609.15	609.18	608.91	609.02	25702.0
2025-01-23 04:00:00	QQQ	ETF	529.39	529.39	528.15	529.07	76565.0
2025-01-23 05:00:00	QQQ	ETF	529.11	529.36	528.67	528.67	37480.0
2025-01-23 06:00:00	QQQ	ETF	528.81	529.34	528.63	529.17	113221.0
2025-01-23 07:00:00	QQQ	ETF	529.22	529.35	528.67	529.19	118514.0
2025-01-23 08:00:00	QQQ	ETF	529.35	531.908	528.61	529.19	332245.0
2025-01-23 09:00:00	QQQ	ETF	529.21	529.7	528.45	529.22	2005217.0
2025-01-23 10:00:00	QQQ	ETF	529.23	530.28	528.53	530.0323	1627742.0
2025-01-23 11:00:00	QQQ	ETF	530.06	531.0	529.22	530.38	1873267.0
2025-01-23 12:00:00	QQQ	ETF	530.38	530.38	529.3	530.17	1072329.0
2025-01-23 13:00:00	QQQ	ETF	530.19	531.3	530.04	530.58	1137478.0
2025-01-23 14:00:00	QQQ	ETF	530.57	530.7701	529.86	530.5599	1070761.0
2025-01-23 15:00:00	QQQ	ETF	530.54	532.76	530.34	532.72	3090554.0
2025-01-23 16:00:00	QQQ	ETF	532.71	532.86	531.96	532.19	986133.0
2025-01-23 17:00:00	QQQ	ETF	532.21	532.2954	532.02	532.05	41032.0
2025-01-23 18:00:00	QQQ	ETF	531.97	532.0	531.621	531.95	26958.0
2025-01-23 19:00:00	QQQ	ETF	532.009	532.03	531.7	531.87	37944.0
2025-01-23 04:00:00	IWM	ETF	227.72	227.81	227.46	227.68	20362.0
2025-01-23 05:00:00	IWM	ETF	227.82	227.93	227.5	227.52	11747.0
2025-01-23 06:00:00	IWM	ETF	227.52	227.77	227.48	227.59	10308.0
2025-01-23 07:00:00	IWM	ETF	227.6	227.6	227.34	227.42	47025.0
2025-01-23 08:00:00	IWM	ETF	227.47	228.2	226.77	227.04	145350.0
2025-01-23 09:00:00	IWM	ETF	227.07	227.63	226.645	226.92	2187171.0
2025-01-23 10:00:00	IWM	ETF	226.95	227.8899	226.55	227.78	1650686.0
2025-01-23 11:00:00	IWM	ETF	227.79	229.07	227.59	228.51	2690294.0
2025-01-23 12:00:00	IWM	ETF	228.52	229.025	228.2875	228.69	1069253.0
2025-01-23 13:00:00	IWM	ETF	228.68	229.29	228.63	228.78	1529404.0
2025-01-23 14:00:00	IWM	ETF	228.76	228.94	228.56	228.79	846981.0
2025-01-23 15:00:00	IWM	ETF	228.76	229.35	228.71	229.3101	2761247.0
2025-01-23 16:00:00	IWM	ETF	229.33	229.34	228.92	229.1	1011013.0
2025-01-23 17:00:00	IWM	ETF	229.0	229.1	228.9301	229.1	9180.0
2025-01-23 18:00:00	IWM	ETF	229.1	229.1	228.94	229.04	7490.0
2025-01-23 19:00:00	IWM	ETF	228.95	229.08	228.92	228.941	13547.0
2025-01-23 04:00:00	DIA	ETF	441.16	441.38	441.03	441.31	22676.0
2025-01-23 05:00:00	DIA	ETF	441.39	441.48	441.32	441.48	3332.0

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

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