PREVIEW / etf_1hour / 2016-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-26.parquet
  size:    241 KB
  rows:    7,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
2016-05-26 04:00:00	SPY	ETF	209.44	209.44	209.16	209.18	41202.0
2016-05-26 05:00:00	SPY	ETF	209.29	209.37	209.28	209.34	4863.0
2016-05-26 06:00:00	SPY	ETF	209.39	209.62	209.32	209.55	11756.0
2016-05-26 07:00:00	SPY	ETF	209.5	209.65	209.42	209.6	185235.0
2016-05-26 08:00:00	SPY	ETF	209.46	209.69	209.151	209.45	580893.0
2016-05-26 09:00:00	SPY	ETF	209.45	209.71	209.01	209.0499	8044044.0
2016-05-26 10:00:00	SPY	ETF	209.05	209.53	209.03	209.03	9398597.0
2016-05-26 11:00:00	SPY	ETF	209.03	209.3698	208.97	209.25	5716570.0
2016-05-26 12:00:00	SPY	ETF	209.26	209.4	209.08	209.13	3885886.0
2016-05-26 13:00:00	SPY	ETF	209.13	209.37	209.06	209.34	3664211.0
2016-05-26 14:00:00	SPY	ETF	209.34	209.52	209.29	209.39	4794965.0
2016-05-26 15:00:00	SPY	ETF	209.4	209.6	209.26	209.3264	11944911.0
2016-05-26 16:00:00	SPY	ETF	209.32	209.65	209.27	209.61	5376422.0
2016-05-26 17:00:00	SPY	ETF	209.62	209.64	209.59	209.62	49803.0
2016-05-26 18:00:00	SPY	ETF	209.61	209.62	209.53	209.6	63004.0
2016-05-26 19:00:00	SPY	ETF	209.62	209.7	209.58	209.67	94876.0
2016-05-26 04:00:00	QQQ	ETF	109.31	109.31	109.28	109.28	2014.0
2016-05-26 05:00:00	QQQ	ETF	109.28	109.28	109.28	109.28	110.0
2016-05-26 06:00:00	QQQ	ETF	109.37	109.46	109.37	109.46	1132.0
2016-05-26 07:00:00	QQQ	ETF	109.39	109.49	109.37	109.45	5836.0
2016-05-26 08:00:00	QQQ	ETF	109.37	109.5	109.24	109.4	44661.0
2016-05-26 09:00:00	QQQ	ETF	109.39	109.5	109.11	109.12	3072978.0
2016-05-26 10:00:00	QQQ	ETF	109.13	109.55	109.09	109.31	3061089.0
2016-05-26 11:00:00	QQQ	ETF	109.29	109.49	109.255	109.37	1974121.0
2016-05-26 12:00:00	QQQ	ETF	109.37	109.44	109.265	109.31	1138244.0
2016-05-26 13:00:00	QQQ	ETF	109.31	109.51	109.28	109.4799	1597087.0
2016-05-26 14:00:00	QQQ	ETF	109.47	109.62	109.46	109.55	1735240.0
2016-05-26 15:00:00	QQQ	ETF	109.55	109.7	109.49	109.54	5547585.0
2016-05-26 16:00:00	QQQ	ETF	109.54	109.73	109.54	109.7	261947.0
2016-05-26 17:00:00	QQQ	ETF	109.66	109.69	109.63	109.66	6952.0
2016-05-26 18:00:00	QQQ	ETF	109.68	109.68	109.66	109.66	4557.0
2016-05-26 19:00:00	QQQ	ETF	109.7	109.74	109.7	109.71	8674.0
2016-05-26 06:00:00	IWM	ETF	113.81	113.87	113.81	113.87	600.0
2016-05-26 07:00:00	IWM	ETF	113.82	113.9	113.82	113.86	3194.0
2016-05-26 08:00:00	IWM	ETF	113.91	113.94	113.74	113.76	19130.0
2016-05-26 09:00:00	IWM	ETF	113.76	114.015	113.45	113.46	2451921.0
2016-05-26 10:00:00	IWM	ETF	113.48	113.85	113.39	113.39	2285302.0
2016-05-26 11:00:00	IWM	ETF	113.38	113.5	113.25	113.46	2150739.0
2016-05-26 12:00:00	IWM	ETF	113.465	113.63	113.35	113.4	1147639.0
2016-05-26 13:00:00	IWM	ETF	113.41	113.69	113.35	113.54	1038929.0
2016-05-26 14:00:00	IWM	ETF	113.55	113.74	113.515	113.65	1360183.0
2016-05-26 15:00:00	IWM	ETF	113.65	113.77	113.46	113.47	3499556.0
2016-05-26 16:00:00	IWM	ETF	113.45	113.65	113.41	113.64	456340.0
2016-05-26 17:00:00	IWM	ETF	113.63	113.63	113.55	113.55	3078.0
2016-05-26 18:00:00	IWM	ETF	113.55	113.56	113.55	113.55	6082.0
2016-05-26 19:00:00	IWM	ETF	113.56	113.66	113.56	113.57	4600.0
2016-05-26 06:00:00	DIA	ETF	178.51	178.57	178.51	178.57	7500.0
2016-05-26 07:00:00	DIA	ETF	178.57	178.61	178.44	178.44	6200.0
2016-05-26 08:00:00	DIA	ETF	178.63	178.65	178.63	178.65	3767.0
2016-05-26 09:00:00	DIA	ETF	178.49	178.69	178.11	178.1501	552528.0

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

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