PREVIEW / etf_1hour / 2020-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-21.parquet
  size:    419 KB
  rows:    14,678

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
2020-12-21 04:00:00	SPY	ETF	369.18	369.18	365.38	365.7	100707.0
2020-12-21 05:00:00	SPY	ETF	365.45	365.45	358.0	360.1	636102.0
2020-12-21 06:00:00	SPY	ETF	360.0	363.98	359.9	363.1	546324.0
2020-12-21 07:00:00	SPY	ETF	363.31	364.47	362.5	363.63	1047153.0
2020-12-21 08:00:00	SPY	ETF	363.63	370.15	361.35	364.2	1421036.0
2020-12-21 09:00:00	SPY	ETF	364.25	366.47	363.85	364.86	9249752.0
2020-12-21 10:00:00	SPY	ETF	364.86	365.0	362.03	363.4	16736707.0
2020-12-21 11:00:00	SPY	ETF	363.385	365.67	363.28	365.32	8474784.0
2020-12-21 12:00:00	SPY	ETF	365.32	367.5	365.32	367.29	6554993.0
2020-12-21 13:00:00	SPY	ETF	367.31	378.46	367.129	368.07	9134459.0
2020-12-21 14:00:00	SPY	ETF	368.08	368.805	367.63	368.0399	7360526.0
2020-12-21 15:00:00	SPY	ETF	368.04	368.27	366.6	367.93	16921943.0
2020-12-21 16:00:00	SPY	ETF	367.93	368.03	367.25	367.8	14250663.0
2020-12-21 17:00:00	SPY	ETF	367.63	367.98	367.61	367.9	876859.0
2020-12-21 18:00:00	SPY	ETF	367.9	368.22	367.51	367.65	188732.0
2020-12-21 19:00:00	SPY	ETF	367.85	368.02	366.97	367.12	195936.0
2020-12-21 04:00:00	QQQ	ETF	310.06	310.06	307.89	308.12	42140.0
2020-12-21 05:00:00	QQQ	ETF	307.88	307.88	303.68	304.67	135703.0
2020-12-21 06:00:00	QQQ	ETF	304.58	306.36	304.51	306.11	157361.0
2020-12-21 07:00:00	QQQ	ETF	306.07	306.81	305.75	306.41	491712.0
2020-12-21 08:00:00	QQQ	ETF	306.42	310.96	305.3504	306.46	296648.0
2020-12-21 09:00:00	QQQ	ETF	306.56	308.14	306.07	306.4928	4165554.0
2020-12-21 10:00:00	QQQ	ETF	306.43	306.78	303.6	304.39	5395028.0
2020-12-21 11:00:00	QQQ	ETF	304.41	306.95	304.32	306.5432	3375225.0
2020-12-21 12:00:00	QQQ	ETF	306.54	308.37	306.54	308.17	2062522.0
2020-12-21 13:00:00	QQQ	ETF	308.17	309.4	307.98	309.11	2279637.0
2020-12-21 14:00:00	QQQ	ETF	309.12	309.47	308.6516	308.94	1748934.0
2020-12-21 15:00:00	QQQ	ETF	308.96	309.12	307.85	309.01	4478996.0
2020-12-21 16:00:00	QQQ	ETF	309.0	309.18	305.4673	309.17	1361138.0
2020-12-21 17:00:00	QQQ	ETF	309.12	309.6	309.1	309.55	104996.0
2020-12-21 18:00:00	QQQ	ETF	309.5	309.75	309.24	309.4	79231.0
2020-12-21 19:00:00	QQQ	ETF	309.5	309.63	309.0	309.07	36103.0
2020-12-21 04:00:00	IWM	ETF	193.47	194.0	191.66	192.11	59775.0
2020-12-21 05:00:00	IWM	ETF	191.85	191.86	187.0	187.6	82475.0
2020-12-21 06:00:00	IWM	ETF	187.51	190.51	187.51	190.27	192019.0
2020-12-21 07:00:00	IWM	ETF	190.3	191.41	189.32	190.1	392094.0
2020-12-21 08:00:00	IWM	ETF	190.0	194.35	188.76	191.15	477036.0
2020-12-21 09:00:00	IWM	ETF	191.19	193.89	191.0	193.19	3908322.0
2020-12-21 10:00:00	IWM	ETF	193.19	193.58	191.52	193.26	5330274.0
2020-12-21 11:00:00	IWM	ETF	193.25	195.63	193.18	193.58	2354443.0
2020-12-21 12:00:00	IWM	ETF	193.6	194.61	193.24	194.5099	2048082.0
2020-12-21 13:00:00	IWM	ETF	194.51	194.99	193.9	194.83	1635074.0
2020-12-21 14:00:00	IWM	ETF	194.845	195.78	194.5	195.0	1926165.0
2020-12-21 15:00:00	IWM	ETF	195.0	195.53	194.24	195.31	4611196.0
2020-12-21 16:00:00	IWM	ETF	195.24	195.53	195.01	195.16	3329579.0
2020-12-21 17:00:00	IWM	ETF	195.13	195.22	195.11	195.22	9587.0
2020-12-21 18:00:00	IWM	ETF	195.23	195.5	194.88	194.94	28171.0
2020-12-21 19:00:00	IWM	ETF	195.05	195.24	194.44	194.54	37272.0
2020-12-21 04:00:00	DIA	ETF	300.94	300.99	299.22	299.29	5313.0
2020-12-21 05:00:00	DIA	ETF	299.0	299.0	294.22	295.02	14490.0

> showing 50 of 14,678 rows — these rows as CSV

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