PREVIEW / etf_1hour / 2016-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-22.parquet
  size:    271 KB
  rows:    8,781

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-22 04:00:00	SPY	ETF	225.6	225.74	225.55	225.74	5500.0
2016-12-22 05:00:00	SPY	ETF	225.55	225.64	225.54	225.64	2600.0
2016-12-22 06:00:00	SPY	ETF	225.64	225.64	225.54	225.54	3410.0
2016-12-22 07:00:00	SPY	ETF	225.54	225.69	225.5	225.65	24290.0
2016-12-22 08:00:00	SPY	ETF	225.65	225.82	225.53	225.65	268180.0
2016-12-22 09:00:00	SPY	ETF	225.65	225.74	225.17	225.41	6859931.0
2016-12-22 10:00:00	SPY	ETF	225.41	225.61	225.26	225.27	7762178.0
2016-12-22 11:00:00	SPY	ETF	225.27	225.38	224.92	225.01	6148806.0
2016-12-22 12:00:00	SPY	ETF	225.0	225.265	224.97	225.19	3864721.0
2016-12-22 13:00:00	SPY	ETF	225.1973	225.54	225.13	225.44	4605697.0
2016-12-22 14:00:00	SPY	ETF	225.45	225.53	225.32	225.41	4523340.0
2016-12-22 15:00:00	SPY	ETF	225.41	225.46	225.05	225.43	10989586.0
2016-12-22 16:00:00	SPY	ETF	225.44	225.63	225.3	225.56	8484641.0
2016-12-22 17:00:00	SPY	ETF	225.2789	225.54	225.2789	225.5	33826.0
2016-12-22 18:00:00	SPY	ETF	225.5	225.63	225.38	225.58	221521.0
2016-12-22 19:00:00	SPY	ETF	225.59	225.6	225.4119	225.57	941103.0
2016-12-22 04:00:00	QQQ	ETF	120.29	120.29	120.29	120.29	400.0
2016-12-22 05:00:00	QQQ	ETF	120.27	120.27	120.26	120.26	666.0
2016-12-22 06:00:00	QQQ	ETF	120.32	120.32	120.3	120.31	2600.0
2016-12-22 07:00:00	QQQ	ETF	120.31	120.4	120.31	120.38	9400.0
2016-12-22 08:00:00	QQQ	ETF	120.36	120.52	120.36	120.43	137662.0
2016-12-22 09:00:00	QQQ	ETF	120.43	120.52	119.92	120.21	1547555.0
2016-12-22 10:00:00	QQQ	ETF	120.215	120.33	120.01	120.0353	1357255.0
2016-12-22 11:00:00	QQQ	ETF	120.0375	120.15	119.65	119.7625	4674703.0
2016-12-22 12:00:00	QQQ	ETF	119.76	119.89	119.72	119.8305	2176804.0
2016-12-22 13:00:00	QQQ	ETF	119.8332	120.1115	119.8	120.025	849882.0
2016-12-22 14:00:00	QQQ	ETF	120.03	120.096	119.97	120.019	899805.0
2016-12-22 15:00:00	QQQ	ETF	120.02	120.11	119.735	120.1	2289726.0
2016-12-22 16:00:00	QQQ	ETF	120.1	120.14	120.05	120.05	502254.0
2016-12-22 17:00:00	QQQ	ETF	120.05	120.06	120.01	120.03	3500.0
2016-12-22 18:00:00	QQQ	ETF	120.08	120.09	120.05	120.05	6672.0
2016-12-22 19:00:00	QQQ	ETF	120.04	120.05	120.0	120.04	4453.0
2016-12-22 06:00:00	IWM	ETF	136.45	136.45	136.4	136.4	400.0
2016-12-22 07:00:00	IWM	ETF	136.4	136.5	136.4	136.5	53820.0
2016-12-22 08:00:00	IWM	ETF	136.53	136.75	136.53	136.63	133293.0
2016-12-22 09:00:00	IWM	ETF	136.61	136.75	136.16	136.33	2898444.0
2016-12-22 10:00:00	IWM	ETF	136.33	136.46	135.52	135.56	3557753.0
2016-12-22 11:00:00	IWM	ETF	135.55	135.68	134.81	135.01	4404882.0
2016-12-22 12:00:00	IWM	ETF	135.01	135.82	134.9	135.6801	3564320.0
2016-12-22 13:00:00	IWM	ETF	135.68	135.88	135.45	135.68	1646191.0
2016-12-22 14:00:00	IWM	ETF	135.67	135.7673	135.42	135.53	1499677.0
2016-12-22 15:00:00	IWM	ETF	135.54	135.55	135.14	135.32	5289909.0
2016-12-22 16:00:00	IWM	ETF	135.31	135.45	135.2125	135.39	1004818.0
2016-12-22 17:00:00	IWM	ETF	135.39	135.39	135.39	135.39	2200.0
2016-12-22 18:00:00	IWM	ETF	135.39	135.4	135.32	135.39	18243.0
2016-12-22 19:00:00	IWM	ETF	135.39	135.45	135.2006	135.36	501853.0
2016-12-22 08:00:00	DIA	ETF	199.39	199.39	199.21	199.23	3700.0
2016-12-22 09:00:00	DIA	ETF	199.23	199.23	198.745	198.93	359271.0
2016-12-22 10:00:00	DIA	ETF	198.91	199.04	198.825	198.825	248320.0
2016-12-22 11:00:00	DIA	ETF	198.825	198.91	198.5789	198.656	426037.0

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

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