PREVIEW / etf_1hour / 2020-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-09.parquet
  size:    401 KB
  rows:    13,714

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-09 04:00:00	SPY	ETF	371.25	371.28	370.99	371.03	20044.0
2020-12-09 05:00:00	SPY	ETF	371.08	371.11	370.86	370.92	8860.0
2020-12-09 06:00:00	SPY	ETF	370.93	370.96	370.67	370.82	46403.0
2020-12-09 07:00:00	SPY	ETF	370.81	370.95	370.46	370.68	135009.0
2020-12-09 08:00:00	SPY	ETF	370.91	371.15	370.44	370.82	117114.0
2020-12-09 09:00:00	SPY	ETF	370.8	371.05	370.39	370.825	5391763.0
2020-12-09 10:00:00	SPY	ETF	370.81	370.83	369.41	369.94	7750785.0
2020-12-09 11:00:00	SPY	ETF	369.93	369.96	369.01	369.72	5252753.0
2020-12-09 12:00:00	SPY	ETF	369.72	369.73	367.75	368.5318	5928810.0
2020-12-09 13:00:00	SPY	ETF	368.51	368.58	365.97	366.05	8623439.0
2020-12-09 14:00:00	SPY	ETF	366.04	367.55	366.04	366.825	9141766.0
2020-12-09 15:00:00	SPY	ETF	366.82	367.99	365.95	366.89	18705597.0
2020-12-09 16:00:00	SPY	ETF	366.89	367.1795	366.1	367.15	10866956.0
2020-12-09 17:00:00	SPY	ETF	367.11	367.14	366.81	366.99	171016.0
2020-12-09 18:00:00	SPY	ETF	366.99	367.7	366.91	367.39	139014.0
2020-12-09 19:00:00	SPY	ETF	367.48	367.7	367.28	367.5	47712.0
2020-12-09 04:00:00	QQQ	ETF	308.14	308.36	308.05	308.35	41341.0
2020-12-09 05:00:00	QQQ	ETF	308.39	308.39	307.99	308.2	18832.0
2020-12-09 06:00:00	QQQ	ETF	308.18	308.21	307.96	308.01	15596.0
2020-12-09 07:00:00	QQQ	ETF	308.02	308.18	307.75	307.91	131994.0
2020-12-09 08:00:00	QQQ	ETF	308.11	308.49	307.75	308.04	186740.0
2020-12-09 09:00:00	QQQ	ETF	308.05	308.36	307.04	308.22	3052677.0
2020-12-09 10:00:00	QQQ	ETF	308.23	308.25	306.53	307.73	3978993.0
2020-12-09 11:00:00	QQQ	ETF	307.72	307.75	306.56	307.1	2235117.0
2020-12-09 12:00:00	QQQ	ETF	307.1	307.13	303.831	304.7805	4274802.0
2020-12-09 13:00:00	QQQ	ETF	304.78	304.955	300.96	301.0	7094685.0
2020-12-09 14:00:00	QQQ	ETF	301.0	302.69	300.91	301.85	6318191.0
2020-12-09 15:00:00	QQQ	ETF	301.81	302.31	300.21	301.4	7099210.0
2020-12-09 16:00:00	QQQ	ETF	301.37	302.1	300.9	301.3	2802972.0
2020-12-09 17:00:00	QQQ	ETF	301.35	301.35	301.08	301.17	20947.0
2020-12-09 18:00:00	QQQ	ETF	301.21	301.76	301.05	301.57	197073.0
2020-12-09 19:00:00	QQQ	ETF	301.6	301.8	301.46	301.54	44681.0
2020-12-09 04:00:00	IWM	ETF	192.08	192.41	192.08	192.35	12989.0
2020-12-09 05:00:00	IWM	ETF	192.39	192.47	192.21	192.3	9349.0
2020-12-09 06:00:00	IWM	ETF	192.32	192.32	191.84	191.88	23913.0
2020-12-09 07:00:00	IWM	ETF	191.91	192.09	191.8	191.95	35145.0
2020-12-09 08:00:00	IWM	ETF	191.94	192.1	191.69	191.97	53512.0
2020-12-09 09:00:00	IWM	ETF	191.98	192.81	191.85	192.465	2828400.0
2020-12-09 10:00:00	IWM	ETF	192.46	192.56	191.42	191.63	3219075.0
2020-12-09 11:00:00	IWM	ETF	191.61	191.72	191.18	191.685	2359557.0
2020-12-09 12:00:00	IWM	ETF	191.7	191.795	190.15	190.68	2386601.0
2020-12-09 13:00:00	IWM	ETF	190.68	190.685	187.94	187.99	3531703.0
2020-12-09 14:00:00	IWM	ETF	187.98	189.8	187.9	189.7	3003981.0
2020-12-09 15:00:00	IWM	ETF	189.67	189.85	188.845	189.35	4580708.0
2020-12-09 16:00:00	IWM	ETF	189.35	189.63	189.09	189.62	2707834.0
2020-12-09 17:00:00	IWM	ETF	189.33	189.59	189.33	189.41	7234.0
2020-12-09 18:00:00	IWM	ETF	189.56	189.81	189.51	189.6	30446.0
2020-12-09 19:00:00	IWM	ETF	189.66	189.81	189.55	189.72	12912.0
2020-12-09 04:00:00	DIA	ETF	303.04	303.13	303.04	303.08	350.0
2020-12-09 05:00:00	DIA	ETF	303.08	303.12	303.04	303.12	1100.0

> showing 50 of 13,714 rows — these rows as CSV

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