PREVIEW / etf_1hour / 2016-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-12.parquet
  size:    266 KB
  rows:    8,575

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-09-12 04:00:00	SPY	ETF	211.7	211.76	211.3	211.59	113749.0
2016-09-12 05:00:00	SPY	ETF	211.59	211.83	211.45	211.49	54765.0
2016-09-12 06:00:00	SPY	ETF	211.52	211.64	211.36	211.6	78082.0
2016-09-12 07:00:00	SPY	ETF	211.6	212.21	211.41	212.11	1232936.0
2016-09-12 08:00:00	SPY	ETF	212.11	212.65	211.45	212.48	1491484.0
2016-09-12 09:00:00	SPY	ETF	212.47	213.66	212.31	213.46	23816184.0
2016-09-12 10:00:00	SPY	ETF	213.45	214.19	213.3865	213.95	18170726.0
2016-09-12 11:00:00	SPY	ETF	213.94	214.61	213.87	214.45	14341241.0
2016-09-12 12:00:00	SPY	ETF	214.4489	215.03	214.22	214.95	12981009.0
2016-09-12 13:00:00	SPY	ETF	214.96	215.6	214.3	215.5052	23929010.0
2016-09-12 14:00:00	SPY	ETF	215.5	216.62	215.44	216.31	27946293.0
2016-09-12 15:00:00	SPY	ETF	216.31	216.81	216.18	216.34	34049802.0
2016-09-12 16:00:00	SPY	ETF	216.34	216.64	215.05	216.37	5990888.0
2016-09-12 17:00:00	SPY	ETF	216.36	216.42	216.22	216.27	315639.0
2016-09-12 18:00:00	SPY	ETF	216.27	216.31	215.96	216.11	308172.0
2016-09-12 19:00:00	SPY	ETF	216.11	216.24	216.1	216.17	49731.0
2016-09-12 04:00:00	QQQ	ETF	113.6	113.6	113.08	113.18	22625.0
2016-09-12 05:00:00	QQQ	ETF	113.29	113.29	113.21	113.22	3000.0
2016-09-12 06:00:00	QQQ	ETF	113.13	113.19	113.08	113.17	11484.0
2016-09-12 07:00:00	QQQ	ETF	113.13	113.52	113.09	113.48	461850.0
2016-09-12 08:00:00	QQQ	ETF	113.48	113.81	113.14	113.72	260867.0
2016-09-12 09:00:00	QQQ	ETF	113.74	114.71	113.63	114.65	6176059.0
2016-09-12 10:00:00	QQQ	ETF	114.63	115.14	114.63	115.115	5225673.0
2016-09-12 11:00:00	QQQ	ETF	115.11	115.52	115.11	115.41	3843411.0
2016-09-12 12:00:00	QQQ	ETF	115.41	115.69	115.23	115.62	2898318.0
2016-09-12 13:00:00	QQQ	ETF	115.62	115.97	115.27	115.89	5210302.0
2016-09-12 14:00:00	QQQ	ETF	115.89	116.36	115.87	116.22	3574259.0
2016-09-12 15:00:00	QQQ	ETF	116.22	116.49	116.13	116.3	7121968.0
2016-09-12 16:00:00	QQQ	ETF	116.3	116.45	116.28	116.37	728975.0
2016-09-12 17:00:00	QQQ	ETF	116.33	116.37	116.33	116.34	105158.0
2016-09-12 18:00:00	QQQ	ETF	116.31	116.31	116.14	116.22	47431.0
2016-09-12 19:00:00	QQQ	ETF	116.22	116.3	116.22	116.25	32692.0
2016-09-12 04:00:00	IWM	ETF	120.2	120.2	119.97	120.04	7294.0
2016-09-12 05:00:00	IWM	ETF	120.24	120.27	120.08	120.09	4367.0
2016-09-12 06:00:00	IWM	ETF	120.01	120.13	120.01	120.13	5600.0
2016-09-12 07:00:00	IWM	ETF	120.14	120.55	120.03	120.51	146466.0
2016-09-12 08:00:00	IWM	ETF	120.05	120.78	120.05	120.71	292105.0
2016-09-12 09:00:00	IWM	ETF	120.69	121.245	120.58	121.075	5727992.0
2016-09-12 10:00:00	IWM	ETF	121.06	121.58	120.87	121.25	4769820.0
2016-09-12 11:00:00	IWM	ETF	121.24	122.02	121.24	121.84	2399959.0
2016-09-12 12:00:00	IWM	ETF	121.855	121.99	121.615	121.8332	1932491.0
2016-09-12 13:00:00	IWM	ETF	121.84	122.285	121.49	122.11	4653144.0
2016-09-12 14:00:00	IWM	ETF	122.11	122.77	122.09	122.5365	3721125.0
2016-09-12 15:00:00	IWM	ETF	122.54	122.97	122.515	122.92	5622842.0
2016-09-12 16:00:00	IWM	ETF	122.92	123.06	122.5968	122.97	1628949.0
2016-09-12 17:00:00	IWM	ETF	123.0	123.0	122.95	122.95	800.0
2016-09-12 18:00:00	IWM	ETF	122.8	122.99	122.8	122.99	59474.0
2016-09-12 19:00:00	IWM	ETF	122.83	122.92	122.82	122.92	3429.0
2016-09-12 04:00:00	DIA	ETF	180.11	180.11	179.31	179.43	1100.0
2016-09-12 05:00:00	DIA	ETF	179.38	179.38	179.38	179.38	100.0

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

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