PREVIEW / etf_1hour / 2024-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-25.parquet
  size:    539 KB
  rows:    19,686

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
2024-01-25 04:00:00	SPY	ETF	485.79	486.09	485.63	485.96	13926.0
2024-01-25 05:00:00	SPY	ETF	485.85	485.9	485.66	485.77	4351.0
2024-01-25 06:00:00	SPY	ETF	485.77	486.0	485.62	485.99	10653.0
2024-01-25 07:00:00	SPY	ETF	486.0	486.13	485.411	485.411	51294.0
2024-01-25 08:00:00	SPY	ETF	486.04	487.5	485.39	487.34	709294.0
2024-01-25 09:00:00	SPY	ETF	487.3401	487.71	486.77	487.32	5669829.0
2024-01-25 10:00:00	SPY	ETF	487.33	488.305	486.86	487.16	8433606.0
2024-01-25 11:00:00	SPY	ETF	487.17	488.11	486.82	487.61	6032647.0
2024-01-25 12:00:00	SPY	ETF	487.62	487.75	486.17	486.5807	6481990.0
2024-01-25 13:00:00	SPY	ETF	486.6	487.31	485.79	485.95	6097212.0
2024-01-25 14:00:00	SPY	ETF	485.95	486.665	485.39	486.66	6953624.0
2024-01-25 15:00:00	SPY	ETF	486.665	488.04	486.29	488.0	12805696.0
2024-01-25 16:00:00	SPY	ETF	488.01	488.2	487.2218	487.5895	3279591.0
2024-01-25 17:00:00	SPY	ETF	487.58	487.65	487.37	487.42	52044.0
2024-01-25 18:00:00	SPY	ETF	487.47	487.49	486.94	487.06	112741.0
2024-01-25 19:00:00	SPY	ETF	487.06	487.14	486.84	486.94	65074.0
2024-01-25 04:00:00	QQQ	ETF	426.12	426.4	425.8	426.27	60927.0
2024-01-25 05:00:00	QQQ	ETF	426.08	426.1	425.7	425.76	29358.0
2024-01-25 06:00:00	QQQ	ETF	425.92	426.58	425.71	426.58	71978.0
2024-01-25 07:00:00	QQQ	ETF	426.53	426.97	426.3	426.38	146465.0
2024-01-25 08:00:00	QQQ	ETF	426.83	428.2	425.511	427.97	637752.0
2024-01-25 09:00:00	QQQ	ETF	428.04	428.45	426.85	427.06	4685626.0
2024-01-25 10:00:00	QQQ	ETF	427.06	428.715	426.59	427.98	5133130.0
2024-01-25 11:00:00	QQQ	ETF	427.98	429.04	427.44	428.3701	3514815.0
2024-01-25 12:00:00	QQQ	ETF	428.39	428.57	426.18	426.63	4261808.0
2024-01-25 13:00:00	QQQ	ETF	426.6405	427.36	424.68	424.83	4841193.0
2024-01-25 14:00:00	QQQ	ETF	424.83	425.62	423.98	425.62	4848022.0
2024-01-25 15:00:00	QQQ	ETF	425.59	426.33	425.155	426.31	5705340.0
2024-01-25 16:00:00	QQQ	ETF	426.3	426.59	424.88	424.88	1350206.0
2024-01-25 17:00:00	QQQ	ETF	424.88	425.14	424.36	424.56	97686.0
2024-01-25 18:00:00	QQQ	ETF	424.57	424.59	423.7	424.0	204659.0
2024-01-25 19:00:00	QQQ	ETF	423.99	424.11	423.68	423.7	115519.0
2024-01-25 04:00:00	IWM	ETF	195.03	195.52	195.0	195.4	31673.0
2024-01-25 05:00:00	IWM	ETF	195.24	195.34	195.0	195.3	20161.0
2024-01-25 06:00:00	IWM	ETF	195.35	195.45	195.2	195.26	26276.0
2024-01-25 07:00:00	IWM	ETF	195.27	195.34	194.83	194.9	43950.0
2024-01-25 08:00:00	IWM	ETF	195.2212	196.82	194.5	196.6	769448.0
2024-01-25 09:00:00	IWM	ETF	196.65	197.6584	195.58	196.72	5521919.0
2024-01-25 10:00:00	IWM	ETF	196.74	197.17	195.18	195.38	5390453.0
2024-01-25 11:00:00	IWM	ETF	195.39	195.93	195.0	195.52	3504468.0
2024-01-25 12:00:00	IWM	ETF	195.54	195.59	194.41	194.74	3087286.0
2024-01-25 13:00:00	IWM	ETF	194.7513	195.59	194.71	194.84	3115182.0
2024-01-25 14:00:00	IWM	ETF	194.83	195.63	194.51	195.425	2772146.0
2024-01-25 15:00:00	IWM	ETF	195.43	195.92	195.02	195.91	5259156.0
2024-01-25 16:00:00	IWM	ETF	195.97	196.49	195.9	196.22	1952549.0
2024-01-25 17:00:00	IWM	ETF	196.22	196.5	196.22	196.3	35168.0
2024-01-25 18:00:00	IWM	ETF	196.3	196.35	196.0	196.05	43250.0
2024-01-25 19:00:00	IWM	ETF	195.98	196.1	195.8	196.0	63106.0
2024-01-25 04:00:00	DIA	ETF	379.08	379.22	378.89	379.19	1900.0
2024-01-25 05:00:00	DIA	ETF	378.97	379.2	378.97	379.13	989.0

> showing 50 of 19,686 rows — these rows as CSV

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