PREVIEW / etf_1hour / 2020-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-29.parquet
  size:    404 KB
  rows:    13,745

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-29 04:00:00	SPY	ETF	373.86	374.03	373.79	373.93	16270.0
2020-12-29 05:00:00	SPY	ETF	373.86	373.95	373.86	373.95	2333.0
2020-12-29 06:00:00	SPY	ETF	373.91	373.91	373.66	373.71	17609.0
2020-12-29 07:00:00	SPY	ETF	373.79	373.9	373.61	373.69	31271.0
2020-12-29 08:00:00	SPY	ETF	373.85	374.07	373.4	373.64	145679.0
2020-12-29 09:00:00	SPY	ETF	373.641	374.0	372.17	372.53	5627885.0
2020-12-29 10:00:00	SPY	ETF	372.52	372.89	371.775	372.74	7360467.0
2020-12-29 11:00:00	SPY	ETF	372.73	372.86	371.945	372.59	4580054.0
2020-12-29 12:00:00	SPY	ETF	372.59	372.63	370.83	371.55	7534003.0
2020-12-29 13:00:00	SPY	ETF	371.55	371.83	371.14	371.72	5076393.0
2020-12-29 14:00:00	SPY	ETF	371.7189	371.74	370.83	371.275	5502352.0
2020-12-29 15:00:00	SPY	ETF	371.27	371.97	371.04	371.48	9689265.0
2020-12-29 16:00:00	SPY	ETF	371.47	371.89	371.2	371.76	6658034.0
2020-12-29 17:00:00	SPY	ETF	371.71	371.71	371.53	371.7	50214.0
2020-12-29 18:00:00	SPY	ETF	371.7	371.96	371.31	371.66	120044.0
2020-12-29 19:00:00	SPY	ETF	371.48	371.55	371.05	371.33	71182.0
2020-12-29 04:00:00	QQQ	ETF	314.03	314.06	313.93	313.96	15796.0
2020-12-29 05:00:00	QQQ	ETF	313.96	313.99	313.82	313.94	9571.0
2020-12-29 06:00:00	QQQ	ETF	313.93	313.93	313.68	313.8	8346.0
2020-12-29 07:00:00	QQQ	ETF	313.82	314.1	313.82	313.96	44305.0
2020-12-29 08:00:00	QQQ	ETF	313.75	314.29	313.7204	314.02	91160.0
2020-12-29 09:00:00	QQQ	ETF	314.07	314.685	312.98	313.26	3596658.0
2020-12-29 10:00:00	QQQ	ETF	313.26	313.91	312.07	313.77	4916784.0
2020-12-29 11:00:00	QQQ	ETF	313.77	313.97	312.89	313.32	1751377.0
2020-12-29 12:00:00	QQQ	ETF	313.32	313.3295	312.03	312.9511	1999464.0
2020-12-29 13:00:00	QQQ	ETF	312.95	313.39	312.76	313.3	1064550.0
2020-12-29 14:00:00	QQQ	ETF	313.3	313.3	312.285	312.87	1374716.0
2020-12-29 15:00:00	QQQ	ETF	312.86	313.48	312.39	312.92	4291087.0
2020-12-29 16:00:00	QQQ	ETF	312.92	313.26	312.7	313.2	711963.0
2020-12-29 17:00:00	QQQ	ETF	313.05	313.2028	312.96	313.09	180735.0
2020-12-29 18:00:00	QQQ	ETF	313.1	313.28	312.82	313.02	35387.0
2020-12-29 19:00:00	QQQ	ETF	312.9	312.9	312.57	312.62	37853.0
2020-12-29 04:00:00	IWM	ETF	199.04	199.22	198.86	198.94	7433.0
2020-12-29 05:00:00	IWM	ETF	198.92	199.02	198.89	199.0	979.0
2020-12-29 06:00:00	IWM	ETF	198.95	198.95	198.74	198.82	19773.0
2020-12-29 07:00:00	IWM	ETF	198.84	199.0	198.54	198.56	26539.0
2020-12-29 08:00:00	IWM	ETF	198.75	198.83	198.35	198.56	26467.0
2020-12-29 09:00:00	IWM	ETF	198.56	199.0	195.5	195.57	3581756.0
2020-12-29 10:00:00	IWM	ETF	195.58	196.02	194.245	195.3425	5383758.0
2020-12-29 11:00:00	IWM	ETF	195.3374	195.38	194.58	194.73	2012022.0
2020-12-29 12:00:00	IWM	ETF	194.735	195.08	193.44	193.845	2656931.0
2020-12-29 13:00:00	IWM	ETF	193.84	194.42	193.68	194.15	1903749.0
2020-12-29 14:00:00	IWM	ETF	194.16	194.1689	193.55	193.89	2324698.0
2020-12-29 15:00:00	IWM	ETF	193.89	194.83	193.0143	194.37	4583444.0
2020-12-29 16:00:00	IWM	ETF	194.37	194.63	194.3536	194.51	3203228.0
2020-12-29 17:00:00	IWM	ETF	194.5	194.55	194.43	194.47	6754.0
2020-12-29 18:00:00	IWM	ETF	194.5	194.62	194.05	194.07	58280.0
2020-12-29 19:00:00	IWM	ETF	194.03	194.2	193.84	194.08	33791.0
2020-12-29 04:00:00	DIA	ETF	305.72	305.72	305.46	305.54	600.0
2020-12-29 05:00:00	DIA	ETF	305.51	305.58	305.51	305.58	300.0

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

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