PREVIEW / etf_1hour / 2022-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-04.parquet
  size:    450 KB
  rows:    16,284

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-04-04 04:00:00	SPY	ETF	452.53	453.29	452.19	452.71	27451.0
2022-04-04 05:00:00	SPY	ETF	452.71	453.88	452.7	453.84	30225.0
2022-04-04 06:00:00	SPY	ETF	453.66	454.06	453.28	453.33	14506.0
2022-04-04 07:00:00	SPY	ETF	453.35	454.0	453.34	453.91	78933.0
2022-04-04 08:00:00	SPY	ETF	453.41	454.0	452.5	452.96	206601.0
2022-04-04 09:00:00	SPY	ETF	452.97	454.7	452.26	454.52	5294353.0
2022-04-04 10:00:00	SPY	ETF	454.5	454.95	453.46	454.48	6814426.0
2022-04-04 11:00:00	SPY	ETF	454.45	455.71	454.34	455.51	5481309.0
2022-04-04 12:00:00	SPY	ETF	455.5101	455.69	454.84	454.92	3959602.0
2022-04-04 13:00:00	SPY	ETF	454.91	455.78	454.68	455.715	2800516.0
2022-04-04 14:00:00	SPY	ETF	455.71	456.26	454.99	456.06	4744433.0
2022-04-04 15:00:00	SPY	ETF	456.04	456.83	455.73	456.78	11139623.0
2022-04-04 16:00:00	SPY	ETF	456.77	456.93	456.5	456.58	3741849.0
2022-04-04 17:00:00	SPY	ETF	456.51	456.75	456.51	456.62	52096.0
2022-04-04 18:00:00	SPY	ETF	456.68	456.8	456.4	456.49	119868.0
2022-04-04 19:00:00	SPY	ETF	456.5	456.62	456.33	456.35	58066.0
2022-04-04 04:00:00	QQQ	ETF	361.3	362.41	361.24	362.27	81078.0
2022-04-04 05:00:00	QQQ	ETF	362.32	363.44	362.3	363.26	39198.0
2022-04-04 06:00:00	QQQ	ETF	363.39	363.73	363.12	363.23	101470.0
2022-04-04 07:00:00	QQQ	ETF	363.26	363.6	363.0	363.43	111942.0
2022-04-04 08:00:00	QQQ	ETF	363.3301	363.61	361.3	362.43	378004.0
2022-04-04 09:00:00	QQQ	ETF	362.43	366.48	362.43	366.435	5446732.0
2022-04-04 10:00:00	QQQ	ETF	366.4	367.02	365.41	366.725	5239159.0
2022-04-04 11:00:00	QQQ	ETF	366.72	368.16	366.62	367.88	4009609.0
2022-04-04 12:00:00	QQQ	ETF	367.875	368.41	367.57	367.6	3048629.0
2022-04-04 13:00:00	QQQ	ETF	367.59	368.21	367.31	368.1328	2524895.0
2022-04-04 14:00:00	QQQ	ETF	368.135	368.66	366.8671	368.38	4391295.0
2022-04-04 15:00:00	QQQ	ETF	368.35	369.31	368.03	369.27	6837922.0
2022-04-04 16:00:00	QQQ	ETF	369.26	369.45	368.9924	369.06	1333866.0
2022-04-04 17:00:00	QQQ	ETF	369.16	369.26	369.0	369.11	35677.0
2022-04-04 18:00:00	QQQ	ETF	369.11	369.15	368.97	369.06	35343.0
2022-04-04 19:00:00	QQQ	ETF	369.1	369.19	368.95	368.95	68407.0
2022-04-04 04:00:00	IWM	ETF	207.22	207.49	207.04	207.3	18135.0
2022-04-04 05:00:00	IWM	ETF	207.35	207.81	207.35	207.76	7140.0
2022-04-04 06:00:00	IWM	ETF	207.73	207.85	207.42	207.48	8274.0
2022-04-04 07:00:00	IWM	ETF	207.52	207.83	207.49	207.8	11638.0
2022-04-04 08:00:00	IWM	ETF	207.65	208.04	207.56	207.68	53021.0
2022-04-04 09:00:00	IWM	ETF	207.7	208.43	207.04	207.21	2405144.0
2022-04-04 10:00:00	IWM	ETF	207.22	207.27	205.88	207.1	3268747.0
2022-04-04 11:00:00	IWM	ETF	207.11	208.14	206.99	208.12	1670802.0
2022-04-04 12:00:00	IWM	ETF	208.13	208.15	207.35	207.39	1398358.0
2022-04-04 13:00:00	IWM	ETF	207.37	207.74	207.17	207.715	852766.0
2022-04-04 14:00:00	IWM	ETF	207.71	208.18	207.39	208.015	1459251.0
2022-04-04 15:00:00	IWM	ETF	208.01	208.2	207.58	208.04	3100880.0
2022-04-04 16:00:00	IWM	ETF	208.05	208.24	207.81	208.03	1349822.0
2022-04-04 17:00:00	IWM	ETF	207.98	208.17	207.94	208.06	16453.0
2022-04-04 18:00:00	IWM	ETF	208.05	208.07	207.91	207.95	183876.0
2022-04-04 19:00:00	IWM	ETF	207.95	208.11	207.9	207.99	57529.0
2022-04-04 04:00:00	DIA	ETF	347.46	347.64	347.46	347.57	6840.0
2022-04-04 06:00:00	DIA	ETF	348.39	348.39	347.94	347.94	610.0

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

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