PREVIEW / etf_1hour / 2016-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-14.parquet
  size:    277 KB
  rows:    8,960

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-14 04:00:00	SPY	ETF	227.83	227.86	227.72	227.75	7204.0
2016-12-14 05:00:00	SPY	ETF	227.75	227.81	227.68	227.81	5734.0
2016-12-14 06:00:00	SPY	ETF	227.76	227.84	227.62	227.84	18889.0
2016-12-14 07:00:00	SPY	ETF	227.86	227.92	227.72	227.78	123989.0
2016-12-14 08:00:00	SPY	ETF	227.8	227.91	227.47	227.61	431295.0
2016-12-14 09:00:00	SPY	ETF	227.59	227.81	227.34	227.54	5932846.0
2016-12-14 10:00:00	SPY	ETF	227.55	227.62	227.21	227.4	9275624.0
2016-12-14 11:00:00	SPY	ETF	227.4	227.49	227.06	227.235	7994582.0
2016-12-14 12:00:00	SPY	ETF	227.245	227.67	227.24	227.63	10078369.0
2016-12-14 13:00:00	SPY	ETF	227.63	227.86	227.56	227.82	14425023.0
2016-12-14 14:00:00	SPY	ETF	227.8287	228.23	226.25	226.33	36025110.0
2016-12-14 15:00:00	SPY	ETF	226.33	227.03	225.365	225.92	44499162.0
2016-12-14 16:00:00	SPY	ETF	225.92	226.37	225.88	226.23	9587113.0
2016-12-14 17:00:00	SPY	ETF	226.21	226.33	225.88	226.23	850895.0
2016-12-14 18:00:00	SPY	ETF	226.22	226.29	225.9	226.29	210758.0
2016-12-14 19:00:00	SPY	ETF	226.29	226.64	226.29	226.38	176147.0
2016-12-14 04:00:00	QQQ	ETF	120.62	120.62	120.62	120.62	1800.0
2016-12-14 05:00:00	QQQ	ETF	120.58	120.6	120.54	120.57	4299.0
2016-12-14 06:00:00	QQQ	ETF	120.56	120.61	120.5	120.61	3099.0
2016-12-14 07:00:00	QQQ	ETF	120.55	120.61	120.55	120.56	63813.0
2016-12-14 08:00:00	QQQ	ETF	120.6	120.62	120.47	120.58	65472.0
2016-12-14 09:00:00	QQQ	ETF	120.58	120.849	120.47	120.77	2105993.0
2016-12-14 10:00:00	QQQ	ETF	120.77	120.9	120.62	120.69	1925752.0
2016-12-14 11:00:00	QQQ	ETF	120.68	120.72	120.445	120.6365	1412185.0
2016-12-14 12:00:00	QQQ	ETF	120.63	120.79	120.61	120.76	910393.0
2016-12-14 13:00:00	QQQ	ETF	120.75	120.91	120.6901	120.87	1164667.0
2016-12-14 14:00:00	QQQ	ETF	120.87	121.0	119.87	120.34	8175028.0
2016-12-14 15:00:00	QQQ	ETF	120.35	120.85	119.86	120.17	7287491.0
2016-12-14 16:00:00	QQQ	ETF	120.17	120.48	120.1452	120.35	1720355.0
2016-12-14 17:00:00	QQQ	ETF	120.39	120.41	120.39	120.39	11550.0
2016-12-14 18:00:00	QQQ	ETF	120.34	120.34	120.18	120.31	31428.0
2016-12-14 19:00:00	QQQ	ETF	120.41	120.5	120.29	120.32	56900.0
2016-12-14 04:00:00	IWM	ETF	136.88	136.88	136.88	136.88	100.0
2016-12-14 06:00:00	IWM	ETF	136.85	136.85	136.85	136.85	1000.0
2016-12-14 07:00:00	IWM	ETF	136.87	136.92	136.73	136.76	89159.0
2016-12-14 08:00:00	IWM	ETF	136.72	136.75	136.46	136.6	96689.0
2016-12-14 09:00:00	IWM	ETF	136.6	137.35	136.3	136.3	3365715.0
2016-12-14 10:00:00	IWM	ETF	136.31	136.48	135.84	136.4389	5525911.0
2016-12-14 11:00:00	IWM	ETF	136.43	136.49	135.75	135.8058	3356978.0
2016-12-14 12:00:00	IWM	ETF	135.81	135.98	135.64	135.9225	2527323.0
2016-12-14 13:00:00	IWM	ETF	135.93	136.32	135.86	136.29	3037705.0
2016-12-14 14:00:00	IWM	ETF	136.33	136.7	135.16	135.251	9366921.0
2016-12-14 15:00:00	IWM	ETF	135.25	135.79	134.81	135.12	9525836.0
2016-12-14 16:00:00	IWM	ETF	135.13	135.49	135.13	135.41	1941199.0
2016-12-14 17:00:00	IWM	ETF	135.46	135.58	135.44	135.52	34448.0
2016-12-14 18:00:00	IWM	ETF	135.49	135.5	135.38	135.48	3158.0
2016-12-14 19:00:00	IWM	ETF	135.48	135.64	135.48	135.64	6797.0
2016-12-14 04:00:00	DIA	ETF	199.28	199.28	199.28	199.28	200.0
2016-12-14 07:00:00	DIA	ETF	199.22	199.31	199.22	199.25	1100.0
2016-12-14 08:00:00	DIA	ETF	199.21	199.27	199.08	199.17	3950.0

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

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