PREVIEW / etf_1hour / 2016-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-07.parquet
  size:    251 KB
  rows:    8,139

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-06-07 04:00:00	SPY	ETF	211.89	212.1	211.89	212.04	25070.0
2016-06-07 05:00:00	SPY	ETF	212.04	212.16	212.02	212.03	13948.0
2016-06-07 06:00:00	SPY	ETF	212.0	212.0	211.87	211.87	34918.0
2016-06-07 07:00:00	SPY	ETF	211.87	211.95	211.81	211.84	85049.0
2016-06-07 08:00:00	SPY	ETF	211.82	211.87	211.35	211.65	282966.0
2016-06-07 09:00:00	SPY	ETF	211.64	211.83	211.48	211.78	6439594.0
2016-06-07 10:00:00	SPY	ETF	211.78	212.11	211.75	211.9	8325418.0
2016-06-07 11:00:00	SPY	ETF	211.9	212.21	211.87	212.04	7552774.0
2016-06-07 12:00:00	SPY	ETF	212.04	212.285	212.03	212.24	3354957.0
2016-06-07 13:00:00	SPY	ETF	212.24	212.34	212.08	212.1005	3740124.0
2016-06-07 14:00:00	SPY	ETF	212.11	212.2801	212.02	212.035	4406756.0
2016-06-07 15:00:00	SPY	ETF	212.03	212.1	211.54	211.67	18534433.0
2016-06-07 16:00:00	SPY	ETF	211.66	211.71	211.52	211.58	7178473.0
2016-06-07 17:00:00	SPY	ETF	211.6	211.63	211.56	211.6	50098.0
2016-06-07 18:00:00	SPY	ETF	211.59	211.59	211.47	211.57	46821.0
2016-06-07 19:00:00	SPY	ETF	211.57	211.63	211.5	211.53	84272.0
2016-06-07 04:00:00	QQQ	ETF	110.77	110.92	110.77	110.92	3578.0
2016-06-07 05:00:00	QQQ	ETF	110.96	110.96	110.96	110.96	1100.0
2016-06-07 06:00:00	QQQ	ETF	110.89	110.89	110.84	110.84	5199.0
2016-06-07 07:00:00	QQQ	ETF	110.85	110.85	110.72	110.72	4300.0
2016-06-07 08:00:00	QQQ	ETF	110.67	110.7	110.58	110.59	29091.0
2016-06-07 09:00:00	QQQ	ETF	110.57	110.63	110.41	110.55	1794240.0
2016-06-07 10:00:00	QQQ	ETF	110.555	110.63	110.27	110.34	1926073.0
2016-06-07 11:00:00	QQQ	ETF	110.33	110.53	110.3025	110.4	1658706.0
2016-06-07 12:00:00	QQQ	ETF	110.39	110.62	110.39	110.59	1127456.0
2016-06-07 13:00:00	QQQ	ETF	110.585	110.63	110.42	110.43	901441.0
2016-06-07 14:00:00	QQQ	ETF	110.43	110.5	110.33	110.35	933746.0
2016-06-07 15:00:00	QQQ	ETF	110.345	110.4	110.13	110.19	2845914.0
2016-06-07 16:00:00	QQQ	ETF	110.2	110.22	110.17	110.17	472171.0
2016-06-07 17:00:00	QQQ	ETF	110.15	110.2	110.15	110.2	5481.0
2016-06-07 18:00:00	QQQ	ETF	110.17	110.17	110.14	110.15	2754.0
2016-06-07 19:00:00	QQQ	ETF	110.18	110.21	110.14	110.14	14546.0
2016-06-07 04:00:00	IWM	ETF	117.42	117.42	117.42	117.42	319.0
2016-06-07 05:00:00	IWM	ETF	117.58	117.58	117.55	117.58	4000.0
2016-06-07 06:00:00	IWM	ETF	117.52	117.54	117.52	117.52	5800.0
2016-06-07 07:00:00	IWM	ETF	117.51	117.55	117.47	117.47	20661.0
2016-06-07 08:00:00	IWM	ETF	117.55	117.55	117.33	117.41	70481.0
2016-06-07 09:00:00	IWM	ETF	117.37	117.45	116.96	117.11	2729180.0
2016-06-07 10:00:00	IWM	ETF	117.11	117.54	117.02	117.4522	2810265.0
2016-06-07 11:00:00	IWM	ETF	117.45	117.75	117.34	117.6511	1784195.0
2016-06-07 12:00:00	IWM	ETF	117.66	117.88	117.647	117.815	1507875.0
2016-06-07 13:00:00	IWM	ETF	117.815	117.96	117.8	117.855	1239952.0
2016-06-07 14:00:00	IWM	ETF	117.86	117.98	117.78	117.79	1892476.0
2016-06-07 15:00:00	IWM	ETF	117.79	117.8	117.48	117.53	3937375.0
2016-06-07 16:00:00	IWM	ETF	117.52	117.6	117.5	117.58	681051.0
2016-06-07 17:00:00	IWM	ETF	117.59	117.64	117.59	117.64	18600.0
2016-06-07 18:00:00	IWM	ETF	117.56	117.56	117.56	117.56	370.0
2016-06-07 19:00:00	IWM	ETF	117.59	117.63	117.56	117.59	1800.0
2016-06-07 05:00:00	DIA	ETF	179.7	179.9	179.7	179.87	1538.0
2016-06-07 08:00:00	DIA	ETF	179.61	179.66	179.52	179.52	700.0

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

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