PREVIEW / etf_1hour / 2016-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-27.parquet
  size:    257 KB
  rows:    8,250

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-10-27 04:00:00	SPY	ETF	214.19	214.28	213.54	213.54	19613.0
2016-10-27 05:00:00	SPY	ETF	213.59	213.66	213.43	213.66	5707.0
2016-10-27 06:00:00	SPY	ETF	213.69	214.27	213.48	214.13	162089.0
2016-10-27 07:00:00	SPY	ETF	214.16	214.45	214.16	214.43	278516.0
2016-10-27 08:00:00	SPY	ETF	214.39	214.78	213.792	214.73	1215191.0
2016-10-27 09:00:00	SPY	ETF	214.72	214.76	213.85	214.08	9919912.0
2016-10-27 10:00:00	SPY	ETF	214.08	214.11	213.1	213.3079	14945272.0
2016-10-27 11:00:00	SPY	ETF	213.3	214.02	213.22	213.96	9112824.0
2016-10-27 12:00:00	SPY	ETF	213.95	214.06	213.45	213.625	9476985.0
2016-10-27 13:00:00	SPY	ETF	213.63	213.88	213.5	213.69	5506906.0
2016-10-27 14:00:00	SPY	ETF	213.7	213.9	213.394	213.5092	4990789.0
2016-10-27 15:00:00	SPY	ETF	213.51	213.57	213.08	213.18	13970546.0
2016-10-27 16:00:00	SPY	ETF	213.18	213.7435	212.68	213.19	6301348.0
2016-10-27 17:00:00	SPY	ETF	213.15	213.19	213.06	213.12	142010.0
2016-10-27 18:00:00	SPY	ETF	213.13	213.2	213.11	213.17	110426.0
2016-10-27 19:00:00	SPY	ETF	213.17	213.26	213.16	213.23	49768.0
2016-10-27 04:00:00	QQQ	ETF	118.33	118.59	118.17	118.17	14117.0
2016-10-27 05:00:00	QQQ	ETF	118.16	118.21	118.16	118.21	750.0
2016-10-27 06:00:00	QQQ	ETF	118.5	118.6	118.5	118.55	23822.0
2016-10-27 07:00:00	QQQ	ETF	118.6	118.73	118.59	118.73	123375.0
2016-10-27 08:00:00	QQQ	ETF	118.7	118.99	118.69	118.98	335674.0
2016-10-27 09:00:00	QQQ	ETF	118.99	119.0	118.6332	118.7889	2255358.0
2016-10-27 10:00:00	QQQ	ETF	118.78	118.78	118.04	118.15	2560522.0
2016-10-27 11:00:00	QQQ	ETF	118.15	118.46	118.09	118.41	2014760.0
2016-10-27 12:00:00	QQQ	ETF	118.41	118.47	118.08	118.14	1177190.0
2016-10-27 13:00:00	QQQ	ETF	118.14	118.231	117.9805	118.1349	1633045.0
2016-10-27 14:00:00	QQQ	ETF	118.13	118.29	117.95	118.0147	1088494.0
2016-10-27 15:00:00	QQQ	ETF	118.02	118.06	117.67	117.87	3986257.0
2016-10-27 16:00:00	QQQ	ETF	117.86	117.88	117.15	117.63	1905641.0
2016-10-27 17:00:00	QQQ	ETF	117.66	117.73	117.51	117.52	35550.0
2016-10-27 18:00:00	QQQ	ETF	117.54	117.6	117.53	117.54	34348.0
2016-10-27 19:00:00	QQQ	ETF	117.54	117.57	117.49	117.54	19393.0
2016-10-27 04:00:00	IWM	ETF	120.03	120.03	119.8	119.8	300.0
2016-10-27 06:00:00	IWM	ETF	119.75	120.0	119.75	119.99	4185.0
2016-10-27 07:00:00	IWM	ETF	119.97	120.15	119.97	120.15	33929.0
2016-10-27 08:00:00	IWM	ETF	120.12	120.3	120.07	120.3	178602.0
2016-10-27 09:00:00	IWM	ETF	120.3	120.33	119.63	119.78	2732144.0
2016-10-27 10:00:00	IWM	ETF	119.78	119.815	118.89	118.96	4435337.0
2016-10-27 11:00:00	IWM	ETF	118.95	119.19	118.63	119.1	3368644.0
2016-10-27 12:00:00	IWM	ETF	119.11	119.17	118.58	118.6801	2622004.0
2016-10-27 13:00:00	IWM	ETF	118.68	118.87	118.57	118.67	1447384.0
2016-10-27 14:00:00	IWM	ETF	118.67	118.81	118.36	118.4	2265072.0
2016-10-27 15:00:00	IWM	ETF	118.41	118.47	118.09	118.35	7099026.0
2016-10-27 16:00:00	IWM	ETF	118.36	118.36	117.9	118.23	1062478.0
2016-10-27 17:00:00	IWM	ETF	118.23	118.28	118.17	118.18	2143.0
2016-10-27 18:00:00	IWM	ETF	118.26	118.33	118.26	118.33	1297.0
2016-10-27 19:00:00	IWM	ETF	118.27	118.3	118.27	118.3	809.0
2016-10-27 04:00:00	DIA	ETF	181.97	181.97	181.97	181.97	100.0
2016-10-27 06:00:00	DIA	ETF	182.15	182.16	182.15	182.16	1970.0
2016-10-27 07:00:00	DIA	ETF	182.17	182.17	182.17	182.17	200.0

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

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