PREVIEW / etf_1hour / 2016-10-31

all etf 1-hour files

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

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-31 04:00:00	SPY	ETF	212.88	213.24	212.88	213.0	8569.0
2016-10-31 05:00:00	SPY	ETF	213.1	213.1	212.88	213.0	17040.0
2016-10-31 06:00:00	SPY	ETF	213.0	213.18	212.88	212.88	5556.0
2016-10-31 07:00:00	SPY	ETF	212.9	213.11	212.85	213.11	59678.0
2016-10-31 08:00:00	SPY	ETF	213.07	213.308	212.84	213.14	696951.0
2016-10-31 09:00:00	SPY	ETF	213.14	213.17	212.62	212.62	7913796.0
2016-10-31 10:00:00	SPY	ETF	212.63	212.93	212.43	212.66	7859720.0
2016-10-31 11:00:00	SPY	ETF	212.66	213.19	212.55	213.115	6935168.0
2016-10-31 12:00:00	SPY	ETF	213.11	213.17	212.78	212.93	4249516.0
2016-10-31 13:00:00	SPY	ETF	212.93	212.98	212.66	212.68	3734490.0
2016-10-31 14:00:00	SPY	ETF	212.685	212.76	212.36	212.515	6804415.0
2016-10-31 15:00:00	SPY	ETF	212.52	212.78	212.39	212.51	15398239.0
2016-10-31 16:00:00	SPY	ETF	212.53	212.86	212.4	212.77	4576868.0
2016-10-31 17:00:00	SPY	ETF	212.74	212.78	212.55	212.78	222670.0
2016-10-31 18:00:00	SPY	ETF	212.78	212.83	212.55	212.7	529194.0
2016-10-31 19:00:00	SPY	ETF	212.72	212.8	212.7	212.71	46164.0
2016-10-31 04:00:00	QQQ	ETF	117.7	117.7	117.59	117.59	5577.0
2016-10-31 05:00:00	QQQ	ETF	117.61	117.61	116.87	117.52	8096.0
2016-10-31 06:00:00	QQQ	ETF	117.57	117.61	117.47	117.47	2398.0
2016-10-31 07:00:00	QQQ	ETF	117.47	117.58	117.45	117.57	26898.0
2016-10-31 08:00:00	QQQ	ETF	117.6	117.7	117.52	117.64	67137.0
2016-10-31 09:00:00	QQQ	ETF	117.62	117.64	117.18	117.18	2300201.0
2016-10-31 10:00:00	QQQ	ETF	117.18	117.4	117.04	117.22	2504742.0
2016-10-31 11:00:00	QQQ	ETF	117.22	117.45	117.11	117.43	1694913.0
2016-10-31 12:00:00	QQQ	ETF	117.434	117.48	117.22	117.22	1110415.0
2016-10-31 13:00:00	QQQ	ETF	117.22	117.25	117.06	117.09	814427.0
2016-10-31 14:00:00	QQQ	ETF	117.0999	117.13	116.96	117.05	1686626.0
2016-10-31 15:00:00	QQQ	ETF	117.05	117.18	116.93	116.97	3933346.0
2016-10-31 16:00:00	QQQ	ETF	116.98	117.16	116.97	117.15	853385.0
2016-10-31 17:00:00	QQQ	ETF	117.13	117.13	117.1	117.1	1200.0
2016-10-31 18:00:00	QQQ	ETF	117.13	117.16	117.1	117.11	7316.0
2016-10-31 19:00:00	QQQ	ETF	117.11	117.12	117.08	117.12	14109.0
2016-10-31 07:00:00	IWM	ETF	118.26	118.29	118.23	118.26	10960.0
2016-10-31 08:00:00	IWM	ETF	118.31	118.4	118.21	118.33	32527.0
2016-10-31 09:00:00	IWM	ETF	118.3	118.37	117.9	117.92	2413712.0
2016-10-31 10:00:00	IWM	ETF	117.93	118.25	117.7999	118.025	2333115.0
2016-10-31 11:00:00	IWM	ETF	118.02	118.47	118.01	118.43	1690992.0
2016-10-31 12:00:00	IWM	ETF	118.44	118.45	118.18	118.23	1380579.0
2016-10-31 13:00:00	IWM	ETF	118.23	118.39	118.13	118.26	1037834.0
2016-10-31 14:00:00	IWM	ETF	118.26	118.41	118.16	118.37	1650159.0
2016-10-31 15:00:00	IWM	ETF	118.37	118.64	118.335	118.48	4807656.0
2016-10-31 16:00:00	IWM	ETF	118.48	118.73	118.44	118.7	1716719.0
2016-10-31 17:00:00	IWM	ETF	118.7	118.73	118.61	118.61	28732.0
2016-10-31 19:00:00	IWM	ETF	118.69	118.69	118.69	118.69	100.0
2016-10-31 07:00:00	DIA	ETF	181.6	181.6	181.6	181.6	100.0
2016-10-31 08:00:00	DIA	ETF	181.7	181.7	181.65	181.7	2590.0
2016-10-31 09:00:00	DIA	ETF	181.47	181.59	181.21	181.21	181310.0
2016-10-31 10:00:00	DIA	ETF	181.21	181.54	181.06	181.35	226974.0
2016-10-31 11:00:00	DIA	ETF	181.34	181.7	181.22	181.59	145865.0
2016-10-31 12:00:00	DIA	ETF	181.58	181.63	181.35	181.5065	98482.0

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

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