PREVIEW / etf_1hour / 2022-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-01.parquet
  size:    460 KB
  rows:    16,469

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
2022-02-01 04:00:00	SPY	ETF	450.2	450.55	447.78	448.66	75361.0
2022-02-01 05:00:00	SPY	ETF	448.84	449.31	448.33	448.65	16345.0
2022-02-01 06:00:00	SPY	ETF	448.82	449.67	448.52	448.68	88918.0
2022-02-01 07:00:00	SPY	ETF	448.74	449.81	448.6	449.5	162419.0
2022-02-01 08:00:00	SPY	ETF	448.9	450.75	448.61	450.45	386389.0
2022-02-01 09:00:00	SPY	ETF	450.5	451.02	448.62	449.77	11787173.0
2022-02-01 10:00:00	SPY	ETF	449.76	450.04	446.9384	450.01	12289422.0
2022-02-01 11:00:00	SPY	ETF	450.0	451.02	448.98	450.68	9976793.0
2022-02-01 12:00:00	SPY	ETF	450.685	450.91	448.97	450.45	6573768.0
2022-02-01 13:00:00	SPY	ETF	450.43	450.7	449.53	450.43	5059702.0
2022-02-01 14:00:00	SPY	ETF	450.44	450.89	449.5	450.44	6259410.0
2022-02-01 15:00:00	SPY	ETF	450.43	453.63	450.26	452.97	20316203.0
2022-02-01 16:00:00	SPY	ETF	452.98	454.97	452.91	454.52	6474448.0
2022-02-01 17:00:00	SPY	ETF	454.5	454.75	452.95	454.75	759488.0
2022-02-01 18:00:00	SPY	ETF	454.7	454.8	452.95	454.6	140042.0
2022-02-01 19:00:00	SPY	ETF	454.67	455.16	454.67	455.11	86638.0
2022-02-01 04:00:00	QQQ	ETF	364.0	364.72	362.0	362.84	127258.0
2022-02-01 05:00:00	QQQ	ETF	362.9	363.6	362.5	362.76	80370.0
2022-02-01 06:00:00	QQQ	ETF	362.94	363.5	362.37	362.74	65001.0
2022-02-01 07:00:00	QQQ	ETF	362.67	364.27	362.61	363.98	367815.0
2022-02-01 08:00:00	QQQ	ETF	362.99	364.8	362.1504	364.47	509134.0
2022-02-01 09:00:00	QQQ	ETF	364.57	364.8	360.53	361.852	10318957.0
2022-02-01 10:00:00	QQQ	ETF	361.87	362.41	359.14	362.275	11283798.0
2022-02-01 11:00:00	QQQ	ETF	362.26	364.3199	361.91	363.88	6790880.0
2022-02-01 12:00:00	QQQ	ETF	363.8714	364.02	361.87	363.395	4797690.0
2022-02-01 13:00:00	QQQ	ETF	363.39	363.48	362.06	362.7591	3952950.0
2022-02-01 14:00:00	QQQ	ETF	362.76	363.3	361.39	362.49	4868231.0
2022-02-01 15:00:00	QQQ	ETF	362.48	366.19	362.27	365.5	10290612.0
2022-02-01 16:00:00	QQQ	ETF	365.54	369.06	365.33	368.52	4017326.0
2022-02-01 17:00:00	QQQ	ETF	368.52	368.95	365.52	368.92	247746.0
2022-02-01 18:00:00	QQQ	ETF	368.92	368.92	368.34	368.67	229852.0
2022-02-01 19:00:00	QQQ	ETF	368.68	369.1	368.66	369.1	190948.0
2022-02-01 04:00:00	IWM	ETF	201.31	201.55	200.01	200.4	31394.0
2022-02-01 05:00:00	IWM	ETF	200.39	200.65	200.16	200.34	9798.0
2022-02-01 06:00:00	IWM	ETF	200.36	200.98	200.29	200.33	63857.0
2022-02-01 07:00:00	IWM	ETF	200.37	200.85	200.2	200.73	78814.0
2022-02-01 08:00:00	IWM	ETF	200.4296	201.39	200.4	201.26	108778.0
2022-02-01 09:00:00	IWM	ETF	201.26	201.96	199.47	200.32	6326665.0
2022-02-01 10:00:00	IWM	ETF	200.37	202.255	197.965	202.24	7748276.0
2022-02-01 11:00:00	IWM	ETF	202.24	203.03	201.76	202.8	4235038.0
2022-02-01 12:00:00	IWM	ETF	202.8	202.94	201.27	202.55	2721908.0
2022-02-01 13:00:00	IWM	ETF	202.54	202.7389	201.17	201.74	2453669.0
2022-02-01 14:00:00	IWM	ETF	201.74	202.29	201.36	201.96	1797021.0
2022-02-01 15:00:00	IWM	ETF	201.97	203.57	201.85	203.24	6204702.0
2022-02-01 16:00:00	IWM	ETF	203.24	203.4216	202.5	202.81	1722955.0
2022-02-01 17:00:00	IWM	ETF	203.06	203.36	201.57	202.66	102489.0
2022-02-01 18:00:00	IWM	ETF	202.83	203.0	202.46	202.95	25718.0
2022-02-01 19:00:00	IWM	ETF	203.1	203.33	202.95	203.31	17785.0
2022-02-01 04:00:00	DIA	ETF	351.28	351.28	349.71	350.28	4623.0
2022-02-01 05:00:00	DIA	ETF	350.68	350.68	350.68	350.68	904.0

> showing 50 of 16,469 rows — these rows as CSV

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