PREVIEW / etf_1hour / 2025-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-04.parquet
  size:    637 KB
  rows:    24,165

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-04 04:00:00	SPY	ETF	596.78	596.88	595.81	596.2	93220.0
2025-02-04 05:00:00	SPY	ETF	596.08	597.0	596.02	596.7	14543.0
2025-02-04 06:00:00	SPY	ETF	596.7	597.3	596.36	596.8	62483.0
2025-02-04 07:00:00	SPY	ETF	596.91	598.55	596.85	598.19	189341.0
2025-02-04 08:00:00	SPY	ETF	597.21	598.52	594.49	597.49	297057.0
2025-02-04 09:00:00	SPY	ETF	597.61	599.2	597.28	598.995	3293448.0
2025-02-04 10:00:00	SPY	ETF	598.9943	601.26	598.96	600.33	3568166.0
2025-02-04 11:00:00	SPY	ETF	600.375	602.09	600.375	601.37	2093818.0
2025-02-04 12:00:00	SPY	ETF	601.38	601.64	599.4054	600.99	2399744.0
2025-02-04 13:00:00	SPY	ETF	600.98	601.259	600.11	600.725	1112522.0
2025-02-04 14:00:00	SPY	ETF	600.7	602.3	600.57	601.48	2456999.0
2025-02-04 15:00:00	SPY	ETF	601.47	602.27	600.97	601.76	6036248.0
2025-02-04 16:00:00	SPY	ETF	601.76	602.09	599.75	600.0783	3114499.0
2025-02-04 17:00:00	SPY	ETF	600.01	600.18	599.57	599.6	230533.0
2025-02-04 18:00:00	SPY	ETF	599.8	600.2699	599.48	599.75	131056.0
2025-02-04 19:00:00	SPY	ETF	599.81	600.72	599.5119	600.4	61903.0
2025-02-04 04:00:00	QQQ	ETF	517.28	518.15	517.0	517.32	100938.0
2025-02-04 05:00:00	QQQ	ETF	517.33	518.07	517.11	517.8	31969.0
2025-02-04 06:00:00	QQQ	ETF	517.85	518.6	517.55	518.09	89059.0
2025-02-04 07:00:00	QQQ	ETF	518.17	520.43	518.16	519.48	200997.0
2025-02-04 08:00:00	QQQ	ETF	518.53	520.0	514.43	518.77	328742.0
2025-02-04 09:00:00	QQQ	ETF	518.91	522.31	518.23	521.94	2903966.0
2025-02-04 10:00:00	QQQ	ETF	521.97	524.79	521.94	523.645	3048411.0
2025-02-04 11:00:00	QQQ	ETF	523.68	525.11	523.6704	524.2152	1509356.0
2025-02-04 12:00:00	QQQ	ETF	524.2105	524.28	521.68	523.4001	2347588.0
2025-02-04 13:00:00	QQQ	ETF	523.4	523.94	522.1101	523.38	1401624.0
2025-02-04 14:00:00	QQQ	ETF	523.38	524.7488	523.12	523.75	1566306.0
2025-02-04 15:00:00	QQQ	ETF	523.8	524.95	523.48	524.54	2886567.0
2025-02-04 16:00:00	QQQ	ETF	524.53	525.0502	522.0	522.42	1570572.0
2025-02-04 17:00:00	QQQ	ETF	522.33	522.43	521.66	521.73	253885.0
2025-02-04 18:00:00	QQQ	ETF	521.75	522.62	521.67	522.0	197503.0
2025-02-04 19:00:00	QQQ	ETF	522.09	523.16	521.75	522.78	102261.0
2025-02-04 04:00:00	IWM	ETF	222.99	223.83	222.95	223.3	53078.0
2025-02-04 05:00:00	IWM	ETF	223.19	223.66	223.19	223.66	6928.0
2025-02-04 06:00:00	IWM	ETF	223.69	223.78	223.33	223.46	82903.0
2025-02-04 07:00:00	IWM	ETF	223.53	224.33	223.51	224.15	80950.0
2025-02-04 08:00:00	IWM	ETF	223.93	224.2901	222.73	223.64	150458.0
2025-02-04 09:00:00	IWM	ETF	223.71	224.7025	223.21	224.66	1772426.0
2025-02-04 10:00:00	IWM	ETF	224.7	226.0	224.65	225.17	2735418.0
2025-02-04 11:00:00	IWM	ETF	225.18	226.25	225.15	226.12	1172893.0
2025-02-04 12:00:00	IWM	ETF	226.12	226.295	225.24	226.2461	1254529.0
2025-02-04 13:00:00	IWM	ETF	226.23	226.3	225.78	225.94	644975.0
2025-02-04 14:00:00	IWM	ETF	225.94	226.74	225.91	226.48	1212341.0
2025-02-04 15:00:00	IWM	ETF	226.46	227.13	226.24	226.91	2748520.0
2025-02-04 16:00:00	IWM	ETF	226.93	227.33	226.89	227.21	1056814.0
2025-02-04 17:00:00	IWM	ETF	227.1725	227.22	226.77	226.81	47613.0
2025-02-04 18:00:00	IWM	ETF	226.81	227.22	226.81	227.04	45887.0
2025-02-04 19:00:00	IWM	ETF	227.07	227.37	227.01	227.34	27283.0
2025-02-04 04:00:00	DIA	ETF	443.14	443.26	442.97	442.97	2710.0
2025-02-04 05:00:00	DIA	ETF	443.18	443.18	443.18	443.18	118.0

> showing 50 of 24,165 rows — these rows as CSV

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