PREVIEW / etf_1hour / 2016-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-19.parquet
  size:    252 KB
  rows:    8,166

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-19 04:00:00	SPY	ETF	214.28	214.6	214.2	214.45	34266.0
2016-09-19 05:00:00	SPY	ETF	214.42	214.63	214.42	214.43	13966.0
2016-09-19 06:00:00	SPY	ETF	214.43	214.43	214.35	214.35	106470.0
2016-09-19 07:00:00	SPY	ETF	214.34	214.55	214.25	214.47	312969.0
2016-09-19 08:00:00	SPY	ETF	214.46	214.55	214.26	214.36	444077.0
2016-09-19 09:00:00	SPY	ETF	214.36	214.81	214.09	214.7759	8294104.0
2016-09-19 10:00:00	SPY	ETF	214.78	214.88	214.26	214.37	9662945.0
2016-09-19 11:00:00	SPY	ETF	214.3692	214.59	214.27	214.535	5563042.0
2016-09-19 12:00:00	SPY	ETF	214.54	214.585	213.63	213.6799	8251276.0
2016-09-19 13:00:00	SPY	ETF	213.67	213.85	213.03	213.531	9555914.0
2016-09-19 14:00:00	SPY	ETF	213.53	214.1452	213.48	214.1158	9609162.0
2016-09-19 15:00:00	SPY	ETF	214.12	214.14	213.2899	213.39	22636476.0
2016-09-19 16:00:00	SPY	ETF	213.4	213.65	213.36	213.61	3946809.0
2016-09-19 17:00:00	SPY	ETF	213.61	213.64	213.57	213.63	73609.0
2016-09-19 18:00:00	SPY	ETF	213.65	213.66	213.56	213.58	46070.0
2016-09-19 19:00:00	SPY	ETF	213.58	213.71	213.37	213.42	78663.0
2016-09-19 04:00:00	QQQ	ETF	117.7	117.86	117.7	117.86	1305.0
2016-09-19 05:00:00	QQQ	ETF	117.82	117.93	117.82	117.82	3999.0
2016-09-19 06:00:00	QQQ	ETF	117.78	117.78	117.72	117.72	1199.0
2016-09-19 07:00:00	QQQ	ETF	117.73	117.76	117.66	117.74	123036.0
2016-09-19 08:00:00	QQQ	ETF	117.71	117.78	117.64	117.67	35695.0
2016-09-19 09:00:00	QQQ	ETF	117.66	117.9293	117.56	117.92	2050165.0
2016-09-19 10:00:00	QQQ	ETF	117.92	117.95	117.26	117.33	2151353.0
2016-09-19 11:00:00	QQQ	ETF	117.34	117.53	117.2762	117.51	1380908.0
2016-09-19 12:00:00	QQQ	ETF	117.5007	117.53	116.91	116.94	1815067.0
2016-09-19 13:00:00	QQQ	ETF	116.92	117.05	116.55	116.86	2117360.0
2016-09-19 14:00:00	QQQ	ETF	116.85	117.22	116.83	117.19	1383236.0
2016-09-19 15:00:00	QQQ	ETF	117.2	117.21	116.71	116.78	3175298.0
2016-09-19 16:00:00	QQQ	ETF	116.8	116.89	116.75	116.88	332827.0
2016-09-19 17:00:00	QQQ	ETF	116.88	116.88	116.81	116.88	2574.0
2016-09-19 18:00:00	QQQ	ETF	116.88	116.88	116.82	116.82	9226.0
2016-09-19 19:00:00	QQQ	ETF	116.86	116.87	116.77	116.77	1881.0
2016-09-19 05:00:00	IWM	ETF	122.59	122.6	122.59	122.6	5000.0
2016-09-19 06:00:00	IWM	ETF	122.53	122.53	122.53	122.53	100.0
2016-09-19 07:00:00	IWM	ETF	122.46	122.6	122.36	122.6	197176.0
2016-09-19 08:00:00	IWM	ETF	122.54	122.62	122.43	122.43	99914.0
2016-09-19 09:00:00	IWM	ETF	122.43	123.41	122.29	123.4	3761972.0
2016-09-19 10:00:00	IWM	ETF	123.41	123.55	123.13	123.24	2998879.0
2016-09-19 11:00:00	IWM	ETF	123.25	123.43	123.09	123.32	2117377.0
2016-09-19 12:00:00	IWM	ETF	123.33	123.39	122.55	122.57	2168962.0
2016-09-19 13:00:00	IWM	ETF	122.545	122.6	121.99	122.47	2652390.0
2016-09-19 14:00:00	IWM	ETF	122.47	122.88	122.4125	122.83	1675931.0
2016-09-19 15:00:00	IWM	ETF	122.82	122.89	122.29	122.68	3745144.0
2016-09-19 16:00:00	IWM	ETF	122.67	122.87	122.66	122.83	1371769.0
2016-09-19 17:00:00	IWM	ETF	122.81	122.84	122.79	122.84	10080.0
2016-09-19 18:00:00	IWM	ETF	122.86	122.86	122.86	122.86	700.0
2016-09-19 19:00:00	IWM	ETF	122.77	122.8	122.67	122.67	66460.0
2016-09-19 04:00:00	DIA	ETF	181.56	181.84	181.56	181.84	220.0
2016-09-19 05:00:00	DIA	ETF	181.92	181.92	181.92	181.92	301.0
2016-09-19 06:00:00	DIA	ETF	181.9	181.9	181.9	181.9	1000.0

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

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