PREVIEW / etf_1hour / 2025-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-02.parquet
  size:    629 KB
  rows:    23,984

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-02 04:00:00	SPY	ETF	588.22	589.86	588.12	589.8	27462.0
2025-01-02 05:00:00	SPY	ETF	589.89	590.01	589.16	589.92	61367.0
2025-01-02 06:00:00	SPY	ETF	589.89	591.74	589.48	591.61	145369.0
2025-01-02 07:00:00	SPY	ETF	591.57	592.06	590.36	590.94	478361.0
2025-01-02 08:00:00	SPY	ETF	591.01	592.0113	586.08	590.34	194519.0
2025-01-02 09:00:00	SPY	ETF	590.4	590.52	586.14	590.17	5008197.0
2025-01-02 10:00:00	SPY	ETF	590.18	591.13	586.34	587.61	4698820.0
2025-01-02 11:00:00	SPY	ETF	587.59	588.77	585.2	587.88	3164740.0
2025-01-02 12:00:00	SPY	ETF	587.875	588.67	580.94	582.86	5576552.0
2025-01-02 13:00:00	SPY	ETF	582.86	583.09	580.5	581.9	5079786.0
2025-01-02 14:00:00	SPY	ETF	581.9	583.99	581.41	582.1305	3620473.0
2025-01-02 15:00:00	SPY	ETF	582.16	585.37	582.14	584.58	6563922.0
2025-01-02 16:00:00	SPY	ETF	584.57	585.379	584.5351	584.92	2393426.0
2025-01-02 17:00:00	SPY	ETF	584.95	585.09	584.85	585.0	46428.0
2025-01-02 18:00:00	SPY	ETF	585.0	585.0	584.11	584.4	42067.0
2025-01-02 19:00:00	SPY	ETF	584.35	585.86	584.3	585.86	77814.0
2025-01-02 04:00:00	QQQ	ETF	514.27	515.66	514.27	515.39	47172.0
2025-01-02 05:00:00	QQQ	ETF	515.75	515.76	514.64	515.53	28000.0
2025-01-02 06:00:00	QQQ	ETF	515.53	517.27	515.0	517.23	53305.0
2025-01-02 07:00:00	QQQ	ETF	517.18	517.7	515.93	516.63	205347.0
2025-01-02 08:00:00	QQQ	ETF	517.4	517.72	511.23	516.0	257540.0
2025-01-02 09:00:00	QQQ	ETF	516.0	516.0	510.02	515.39	4328917.0
2025-01-02 10:00:00	QQQ	ETF	515.44	516.64	511.11	512.7094	4246171.0
2025-01-02 11:00:00	QQQ	ETF	512.74	514.58	510.52	513.64	2610749.0
2025-01-02 12:00:00	QQQ	ETF	513.61	514.24	505.71	507.92	4805297.0
2025-01-02 13:00:00	QQQ	ETF	507.96	508.21	505.83	507.28	2995976.0
2025-01-02 14:00:00	QQQ	ETF	507.255	509.54	506.75	507.64	2537956.0
2025-01-02 15:00:00	QQQ	ETF	507.59	510.76	507.59	510.17	3929876.0
2025-01-02 16:00:00	QQQ	ETF	510.19	511.3785	510.19	510.54	772091.0
2025-01-02 17:00:00	QQQ	ETF	510.55	510.55	510.28	510.48	42348.0
2025-01-02 18:00:00	QQQ	ETF	510.49	510.54	509.7	510.0	73383.0
2025-01-02 19:00:00	QQQ	ETF	510.03	511.87	509.99	511.85	158372.0
2025-01-02 04:00:00	IWM	ETF	222.1	222.23	221.72	221.99	14462.0
2025-01-02 05:00:00	IWM	ETF	222.12	222.26	221.78	222.26	123307.0
2025-01-02 06:00:00	IWM	ETF	222.39	223.24	222.19	223.24	68114.0
2025-01-02 07:00:00	IWM	ETF	223.19	223.72	222.97	223.25	139125.0
2025-01-02 08:00:00	IWM	ETF	223.39	223.71	221.7596	223.1	139445.0
2025-01-02 09:00:00	IWM	ETF	223.11	224.37	221.61	224.11	3298440.0
2025-01-02 10:00:00	IWM	ETF	224.13	224.2	221.93	222.49	2717039.0
2025-01-02 11:00:00	IWM	ETF	222.5	223.33	221.64	222.91	2225704.0
2025-01-02 12:00:00	IWM	ETF	222.92	223.425	220.53	221.2	3120041.0
2025-01-02 13:00:00	IWM	ETF	221.19	221.2	219.596	220.12	2109844.0
2025-01-02 14:00:00	IWM	ETF	220.09	220.69	219.82	219.88	2029109.0
2025-01-02 15:00:00	IWM	ETF	219.9	221.31	219.9	221.13	3155168.0
2025-01-02 16:00:00	IWM	ETF	221.11	221.4	220.93	221.14	1126655.0
2025-01-02 17:00:00	IWM	ETF	221.15	221.17	221.11	221.11	21821.0
2025-01-02 18:00:00	IWM	ETF	221.11	221.21	220.9	220.97	26415.0
2025-01-02 19:00:00	IWM	ETF	220.93	221.5	220.93	221.44	11583.0
2025-01-02 04:00:00	DIA	ETF	427.0	427.44	427.0	427.35	2170.0
2025-01-02 06:00:00	DIA	ETF	427.63	428.79	427.63	428.79	3307.0

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

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