PREVIEW / etf_1hour / 2023-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-21.parquet
  size:    477 KB
  rows:    17,220

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
2023-06-21 04:00:00	SPY	ETF	437.01	437.55	436.96	437.3	29001.0
2023-06-21 05:00:00	SPY	ETF	437.34	437.56	437.03	437.48	22760.0
2023-06-21 06:00:00	SPY	ETF	437.44	437.64	437.27	437.27	12522.0
2023-06-21 07:00:00	SPY	ETF	437.34	437.36	436.94	437.09	57109.0
2023-06-21 08:00:00	SPY	ETF	437.07	437.5696	435.95	436.15	501175.0
2023-06-21 09:00:00	SPY	ETF	436.15	436.31	434.84	435.24	5092771.0
2023-06-21 10:00:00	SPY	ETF	435.23	435.8106	434.33	435.2616	8993432.0
2023-06-21 11:00:00	SPY	ETF	435.265	436.02	434.41	435.115	6967495.0
2023-06-21 12:00:00	SPY	ETF	435.11	436.21	435.05	435.315	5797609.0
2023-06-21 13:00:00	SPY	ETF	435.33	435.89	434.87	435.8799	4813540.0
2023-06-21 14:00:00	SPY	ETF	435.88	436.99	435.7501	436.515	6890837.0
2023-06-21 15:00:00	SPY	ETF	436.52	436.52	434.625	434.93	15278670.0
2023-06-21 16:00:00	SPY	ETF	434.93	435.23	434.0	434.93	2972542.0
2023-06-21 17:00:00	SPY	ETF	434.94	435.01	434.86	434.9	45556.0
2023-06-21 18:00:00	SPY	ETF	434.97	435.18	434.76	434.89	53229.0
2023-06-21 19:00:00	SPY	ETF	434.93	435.13	434.92	435.0	32725.0
2023-06-21 04:00:00	QQQ	ETF	366.38	367.17	366.34	366.88	59453.0
2023-06-21 05:00:00	QQQ	ETF	366.85	367.02	366.54	366.9	18823.0
2023-06-21 06:00:00	QQQ	ETF	366.97	367.14	366.64	366.67	54220.0
2023-06-21 07:00:00	QQQ	ETF	366.76	366.83	366.26	366.41	89368.0
2023-06-21 08:00:00	QQQ	ETF	366.8082	367.18	362.3	365.7	467886.0
2023-06-21 09:00:00	QQQ	ETF	365.69	366.18	363.71	363.98	4075279.0
2023-06-21 10:00:00	QQQ	ETF	363.975	364.21	361.82	362.275	6868177.0
2023-06-21 11:00:00	QQQ	ETF	362.26	362.99	360.96	361.61	5864101.0
2023-06-21 12:00:00	QQQ	ETF	361.61	363.1	361.53	362.39	4247372.0
2023-06-21 13:00:00	QQQ	ETF	362.4	363.18	361.91	363.14	2719574.0
2023-06-21 14:00:00	QQQ	ETF	363.15	364.52	362.91	364.0613	4414600.0
2023-06-21 15:00:00	QQQ	ETF	364.03	364.04	361.73	362.02	6614003.0
2023-06-21 16:00:00	QQQ	ETF	362.01	362.4	361.8	361.81	1403407.0
2023-06-21 17:00:00	QQQ	ETF	361.86	361.95	361.76	361.82	46418.0
2023-06-21 18:00:00	QQQ	ETF	361.82	362.07	361.52	361.66	195400.0
2023-06-21 19:00:00	QQQ	ETF	361.74	361.95	361.74	361.88	79811.0
2023-06-21 04:00:00	IWM	ETF	185.1	185.43	185.03	185.2	7658.0
2023-06-21 05:00:00	IWM	ETF	185.27	185.5	185.1	185.43	4596.0
2023-06-21 06:00:00	IWM	ETF	185.41	185.64	185.4	185.44	11775.0
2023-06-21 07:00:00	IWM	ETF	185.41	185.45	185.18	185.261	20662.0
2023-06-21 08:00:00	IWM	ETF	185.16	185.4096	184.5	184.7	70917.0
2023-06-21 09:00:00	IWM	ETF	184.69	184.8291	183.59	184.38	3643107.0
2023-06-21 10:00:00	IWM	ETF	184.37	185.015	183.89	184.64	4061624.0
2023-06-21 11:00:00	IWM	ETF	184.64	184.895	184.01	184.5501	2667690.0
2023-06-21 12:00:00	IWM	ETF	184.55	185.06	184.405	184.47	2646279.0
2023-06-21 13:00:00	IWM	ETF	184.48	185.31	184.33	185.28	1997901.0
2023-06-21 14:00:00	IWM	ETF	185.29	185.91	185.2206	185.555	2748478.0
2023-06-21 15:00:00	IWM	ETF	185.56	185.57	184.67	184.74	4127887.0
2023-06-21 16:00:00	IWM	ETF	184.7	184.87	184.63	184.7	1090181.0
2023-06-21 17:00:00	IWM	ETF	184.7	184.7	184.6	184.62	8213.0
2023-06-21 18:00:00	IWM	ETF	184.65	184.85	184.62	184.72	143360.0
2023-06-21 19:00:00	IWM	ETF	184.74	184.85	184.71	184.75	10955.0
2023-06-21 04:00:00	DIA	ETF	340.53	340.53	340.53	340.53	600.0
2023-06-21 06:00:00	DIA	ETF	340.5	340.5	340.5	340.5	100.0

> showing 50 of 17,220 rows — these rows as CSV

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