PREVIEW / etf_1hour / 2022-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-02.parquet
  size:    462 KB
  rows:    16,498

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-02 04:00:00	SPY	ETF	455.0	457.01	455.0	456.92	34615.0
2022-02-02 05:00:00	SPY	ETF	456.82	456.88	456.31	456.33	51604.0
2022-02-02 06:00:00	SPY	ETF	456.38	456.56	455.95	456.43	65381.0
2022-02-02 07:00:00	SPY	ETF	456.46	457.43	456.14	457.2	262308.0
2022-02-02 08:00:00	SPY	ETF	456.75	457.34	453.289	455.83	547143.0
2022-02-02 09:00:00	SPY	ETF	455.74	456.39	453.9808	454.51	9036604.0
2022-02-02 10:00:00	SPY	ETF	454.54	456.08	453.39	455.07	11221880.0
2022-02-02 11:00:00	SPY	ETF	455.08	455.31	453.05	454.76	8591594.0
2022-02-02 12:00:00	SPY	ETF	454.76	456.84	454.3	456.82	7509610.0
2022-02-02 13:00:00	SPY	ETF	456.82	456.87	455.24	456.2715	6534619.0
2022-02-02 14:00:00	SPY	ETF	456.27	457.7181	455.48	457.0	9324870.0
2022-02-02 15:00:00	SPY	ETF	456.99	458.12	456.59	457.3	19478994.0
2022-02-02 16:00:00	SPY	ETF	457.31	457.54	453.5	454.38	6649074.0
2022-02-02 17:00:00	SPY	ETF	454.37	457.35	453.84	453.98	202624.0
2022-02-02 18:00:00	SPY	ETF	454.01	457.35	452.53	452.61	258289.0
2022-02-02 19:00:00	SPY	ETF	452.61	453.28	452.54	452.69	116978.0
2022-02-02 04:00:00	QQQ	ETF	369.99	371.88	369.86	371.83	138894.0
2022-02-02 05:00:00	QQQ	ETF	371.7	371.7	370.66	370.76	47178.0
2022-02-02 06:00:00	QQQ	ETF	370.94	371.28	370.25	371.1	157812.0
2022-02-02 07:00:00	QQQ	ETF	371.19	372.05	370.78	371.74	344687.0
2022-02-02 08:00:00	QQQ	ETF	371.5996	372.0	365.794	369.93	789186.0
2022-02-02 09:00:00	QQQ	ETF	369.88	370.1	366.37	368.04	8296423.0
2022-02-02 10:00:00	QQQ	ETF	368.12	369.83	366.12	367.29	10598778.0
2022-02-02 11:00:00	QQQ	ETF	367.29	367.63	364.285	366.38	8887798.0
2022-02-02 12:00:00	QQQ	ETF	366.38	368.65	365.6	368.629	5021171.0
2022-02-02 13:00:00	QQQ	ETF	368.64	368.67	366.655	367.2	3505566.0
2022-02-02 14:00:00	QQQ	ETF	367.2	368.8057	366.02	368.04	4778864.0
2022-02-02 15:00:00	QQQ	ETF	368.02	369.41	367.46	368.54	8488058.0
2022-02-02 16:00:00	QQQ	ETF	368.53	368.7373	361.52	362.42	5929045.0
2022-02-02 17:00:00	QQQ	ETF	362.39	368.49	361.7	361.83	514802.0
2022-02-02 18:00:00	QQQ	ETF	361.87	362.4	359.83	359.96	384030.0
2022-02-02 19:00:00	QQQ	ETF	360.14	360.85	360.02	360.1701	365779.0
2022-02-02 04:00:00	IWM	ETF	203.18	204.25	203.18	204.12	15338.0
2022-02-02 05:00:00	IWM	ETF	204.1	204.49	203.99	204.22	16967.0
2022-02-02 06:00:00	IWM	ETF	204.3	204.34	203.73	203.89	11511.0
2022-02-02 07:00:00	IWM	ETF	203.94	204.38	203.77	204.18	55721.0
2022-02-02 08:00:00	IWM	ETF	203.3696	204.16	203.14	203.54	146376.0
2022-02-02 09:00:00	IWM	ETF	203.48	203.9	201.06	201.24	5900032.0
2022-02-02 10:00:00	IWM	ETF	201.28	202.45	199.6	201.14	7603573.0
2022-02-02 11:00:00	IWM	ETF	201.13	201.3	199.29	200.71	4327630.0
2022-02-02 12:00:00	IWM	ETF	200.7	201.57	200.23	201.57	2516947.0
2022-02-02 13:00:00	IWM	ETF	201.56	201.64	200.61	201.32	2000875.0
2022-02-02 14:00:00	IWM	ETF	201.32	201.89	200.64	201.42	2365968.0
2022-02-02 15:00:00	IWM	ETF	201.43	201.8	200.75	201.2998	4687260.0
2022-02-02 16:00:00	IWM	ETF	201.34	201.42	200.0	201.23	3129451.0
2022-02-02 17:00:00	IWM	ETF	200.91	201.12	200.72	200.96	64678.0
2022-02-02 18:00:00	IWM	ETF	200.96	201.34	199.76	199.98	52054.0
2022-02-02 19:00:00	IWM	ETF	200.15	200.31	199.79	199.82	32818.0
2022-02-02 04:00:00	DIA	ETF	353.74	354.16	353.74	354.16	1373.0
2022-02-02 05:00:00	DIA	ETF	354.45	354.57	354.2	354.37	2825.0

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

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