PREVIEW / etf_1hour / 2016-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-20.parquet
  size:    275 KB
  rows:    8,943

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-12-20 04:00:00	SPY	ETF	225.94	225.98	225.82	225.9	2355.0
2016-12-20 05:00:00	SPY	ETF	225.9	225.98	225.85	225.96	7799.0
2016-12-20 06:00:00	SPY	ETF	225.95	226.08	225.92	226.04	29957.0
2016-12-20 07:00:00	SPY	ETF	226.02	226.33	226.02	226.32	254839.0
2016-12-20 08:00:00	SPY	ETF	226.27	226.4	226.09	226.24	273052.0
2016-12-20 09:00:00	SPY	ETF	226.24	226.57	226.06	226.42	7560952.0
2016-12-20 10:00:00	SPY	ETF	226.43	226.48	226.13	226.45	12690522.0
2016-12-20 11:00:00	SPY	ETF	226.46	226.48	225.97	226.12	9152244.0
2016-12-20 12:00:00	SPY	ETF	226.13	226.3	226.04	226.2411	6787249.0
2016-12-20 13:00:00	SPY	ETF	226.2471	226.4	226.2	226.34	10809027.0
2016-12-20 14:00:00	SPY	ETF	226.33	226.35	225.88	226.05	9925979.0
2016-12-20 15:00:00	SPY	ETF	226.05	226.39	226.02	226.37	21327058.0
2016-12-20 16:00:00	SPY	ETF	226.36	226.41	226.22	226.35	7289893.0
2016-12-20 17:00:00	SPY	ETF	226.34	226.4	226.33	226.37	37290.0
2016-12-20 18:00:00	SPY	ETF	226.39	226.4	226.31	226.34	83804.0
2016-12-20 19:00:00	SPY	ETF	226.33	226.38	226.27	226.38	81309.0
2016-12-20 06:00:00	QQQ	ETF	120.31	120.31	120.31	120.31	750.0
2016-12-20 07:00:00	QQQ	ETF	120.3	120.41	120.3	120.4	8662.0
2016-12-20 08:00:00	QQQ	ETF	120.33	120.5	120.33	120.47	65170.0
2016-12-20 09:00:00	QQQ	ETF	120.48	120.77	120.39	120.59	1609521.0
2016-12-20 10:00:00	QQQ	ETF	120.59	120.6633	120.39	120.645	1797215.0
2016-12-20 11:00:00	QQQ	ETF	120.645	120.66	120.408	120.5	1257790.0
2016-12-20 12:00:00	QQQ	ETF	120.49	120.62	120.45	120.595	945648.0
2016-12-20 13:00:00	QQQ	ETF	120.59	120.66	120.51	120.58	912844.0
2016-12-20 14:00:00	QQQ	ETF	120.58	120.59	120.33	120.427	938575.0
2016-12-20 15:00:00	QQQ	ETF	120.425	120.57	120.4035	120.56	2566136.0
2016-12-20 16:00:00	QQQ	ETF	120.56	120.62	120.5	120.62	357964.0
2016-12-20 17:00:00	QQQ	ETF	120.58	120.61	120.58	120.61	550.0
2016-12-20 19:00:00	QQQ	ETF	120.58	120.63	120.58	120.63	2730.0
2016-12-20 06:00:00	IWM	ETF	137.12	137.12	137.08	137.08	1996.0
2016-12-20 07:00:00	IWM	ETF	137.07	137.4	137.07	137.38	52692.0
2016-12-20 08:00:00	IWM	ETF	137.38	137.45	137.29	137.39	78902.0
2016-12-20 09:00:00	IWM	ETF	137.39	138.16	136.99	138.01	4064408.0
2016-12-20 10:00:00	IWM	ETF	138.02	138.21	137.5	137.65	4936963.0
2016-12-20 11:00:00	IWM	ETF	137.66	137.68	137.08	137.28	4271550.0
2016-12-20 12:00:00	IWM	ETF	137.2899	137.74	137.19	137.59	3289050.0
2016-12-20 13:00:00	IWM	ETF	137.59	137.96	137.56	137.76	2895184.0
2016-12-20 14:00:00	IWM	ETF	137.76	137.78	137.32	137.41	2160731.0
2016-12-20 15:00:00	IWM	ETF	137.41	137.94	137.39	137.93	4834108.0
2016-12-20 16:00:00	IWM	ETF	137.92	137.96	137.72	137.88	643357.0
2016-12-20 18:00:00	IWM	ETF	137.81	137.92	137.81	137.92	1536.0
2016-12-20 19:00:00	IWM	ETF	137.89	137.9	137.87	137.88	2400.0
2016-12-20 07:00:00	DIA	ETF	198.97	199.14	198.97	199.11	4375.0
2016-12-20 08:00:00	DIA	ETF	199.29	199.32	199.05	199.18	6839.0
2016-12-20 09:00:00	DIA	ETF	199.15	199.61	199.06	199.55	583835.0
2016-12-20 10:00:00	DIA	ETF	199.55	199.55	199.31	199.4961	450417.0
2016-12-20 11:00:00	DIA	ETF	199.5	199.5134	199.06	199.22	479408.0
2016-12-20 12:00:00	DIA	ETF	199.22	199.41	199.16	199.37	230689.0
2016-12-20 13:00:00	DIA	ETF	199.37	199.56	199.37	199.51	253381.0
2016-12-20 14:00:00	DIA	ETF	199.506	199.506	199.12	199.2	292313.0

> showing 50 of 8,943 rows — these rows as CSV

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