PREVIEW / etf_1hour / 2016-12-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	225.9	225.9	225.47	225.49	98924.0
2016-12-16 05:00:00	SPY	ETF	225.49	225.95	225.48	225.95	17823.0
2016-12-16 06:00:00	SPY	ETF	225.89	226.07	225.81	225.97	111475.0
2016-12-16 07:00:00	SPY	ETF	225.91	226.14	225.88	226.01	238027.0
2016-12-16 08:00:00	SPY	ETF	225.87	226.16	225.87	226.03	539944.0
2016-12-16 09:00:00	SPY	ETF	226.02	226.08	225.53	225.77	17227532.0
2016-12-16 10:00:00	SPY	ETF	225.77	225.94	225.45	225.77	35329797.0
2016-12-16 11:00:00	SPY	ETF	225.78	225.78	224.96	225.545	19515949.0
2016-12-16 12:00:00	SPY	ETF	225.55	225.61	224.96	225.084	7593606.0
2016-12-16 13:00:00	SPY	ETF	225.085	225.11	224.721	224.96	11647434.0
2016-12-16 14:00:00	SPY	ETF	224.955	225.2	224.81	225.08	15796516.0
2016-12-16 15:00:00	SPY	ETF	225.08	225.66	224.67	225.07	24513913.0
2016-12-16 16:00:00	SPY	ETF	225.08	225.27	224.99	225.18	19884689.0
2016-12-16 17:00:00	SPY	ETF	225.17	225.2	225.04	225.12	2212366.0
2016-12-16 18:00:00	SPY	ETF	225.12	225.15	225.08	225.1	18094.0
2016-12-16 19:00:00	SPY	ETF	225.15	225.26	225.15	225.2	55348.0
2016-12-16 04:00:00	QQQ	ETF	120.34	120.34	119.94	120.01	4538.0
2016-12-16 05:00:00	QQQ	ETF	120.0	120.25	120.0	120.24	5297.0
2016-12-16 06:00:00	QQQ	ETF	120.2	120.27	120.16	120.27	4247.0
2016-12-16 07:00:00	QQQ	ETF	120.24	120.34	120.23	120.26	45296.0
2016-12-16 08:00:00	QQQ	ETF	120.33	120.42	120.25	120.33	54078.0
2016-12-16 09:00:00	QQQ	ETF	120.32	120.52	120.06	120.275	3224727.0
2016-12-16 10:00:00	QQQ	ETF	120.28	120.305	119.951	120.045	2311637.0
2016-12-16 11:00:00	QQQ	ETF	120.04	120.07	119.461	119.86	2614339.0
2016-12-16 12:00:00	QQQ	ETF	119.86	119.885	119.595	119.65	959506.0
2016-12-16 13:00:00	QQQ	ETF	119.65	119.66	119.44	119.56	1641387.0
2016-12-16 14:00:00	QQQ	ETF	119.55	119.73	119.5	119.64	1621533.0
2016-12-16 15:00:00	QQQ	ETF	119.64	119.6864	119.36	119.61	3893213.0
2016-12-16 16:00:00	QQQ	ETF	119.61	119.69	119.53	119.57	1672688.0
2016-12-16 17:00:00	QQQ	ETF	119.62	119.64	119.55	119.63	627135.0
2016-12-16 18:00:00	QQQ	ETF	119.65	119.66	119.59	119.64	8417.0
2016-12-16 19:00:00	QQQ	ETF	119.64	119.64	119.59	119.61	3884.0
2016-12-16 04:00:00	IWM	ETF	136.26	136.28	136.25	136.25	1500.0
2016-12-16 05:00:00	IWM	ETF	136.23	136.62	136.23	136.62	1300.0
2016-12-16 06:00:00	IWM	ETF	136.56	136.67	136.56	136.61	500.0
2016-12-16 07:00:00	IWM	ETF	136.65	136.74	136.6	136.61	146454.0
2016-12-16 08:00:00	IWM	ETF	135.0807	136.67	135.0807	136.44	382269.0
2016-12-16 09:00:00	IWM	ETF	136.43	136.87	136.08	136.81	3645245.0
2016-12-16 10:00:00	IWM	ETF	136.82	137.525	136.7	137.3897	5169319.0
2016-12-16 11:00:00	IWM	ETF	137.4	137.44	136.36	136.93	5215916.0
2016-12-16 12:00:00	IWM	ETF	136.93	137.02	136.47	136.63	3012693.0
2016-12-16 13:00:00	IWM	ETF	136.63	136.73	136.28	136.3	2674505.0
2016-12-16 14:00:00	IWM	ETF	136.29	136.5075	136.14	136.415	2706693.0
2016-12-16 15:00:00	IWM	ETF	136.4	136.44	135.63	135.88	6427277.0
2016-12-16 16:00:00	IWM	ETF	135.87	136.26	135.83	135.91	2433680.0
2016-12-16 17:00:00	IWM	ETF	135.96	136.0	135.9	135.9	1750862.0
2016-12-16 18:00:00	IWM	ETF	136.03	136.03	136.0	136.01	1223.0
2016-12-16 19:00:00	IWM	ETF	136.01	136.01	135.91	135.92	3584.0
2016-12-16 04:00:00	DIA	ETF	198.41	198.41	198.2	198.2	498.0
2016-12-16 07:00:00	DIA	ETF	198.77	198.8	198.76	198.8	399.0

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

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