PREVIEW / etf_1hour / 2016-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-10.parquet
  size:    248 KB
  rows:    7,952

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-08-10 04:00:00	SPY	ETF	218.1	218.4	218.1	218.4	105680.0
2016-08-10 05:00:00	SPY	ETF	218.44	218.55	218.28	218.28	54548.0
2016-08-10 06:00:00	SPY	ETF	218.28	218.38	218.27	218.27	16362.0
2016-08-10 07:00:00	SPY	ETF	218.25	218.53	218.25	218.37	69052.0
2016-08-10 08:00:00	SPY	ETF	218.38	218.51	218.37	218.47	197136.0
2016-08-10 09:00:00	SPY	ETF	218.47	218.52	217.94	217.94	6614958.0
2016-08-10 10:00:00	SPY	ETF	217.94	218.25	217.9	218.04	6938604.0
2016-08-10 11:00:00	SPY	ETF	218.031	218.19	217.43	217.52	9806851.0
2016-08-10 12:00:00	SPY	ETF	217.52	217.8199	217.45	217.8199	4321958.0
2016-08-10 13:00:00	SPY	ETF	217.8199	217.825	217.54	217.591	4418832.0
2016-08-10 14:00:00	SPY	ETF	217.592	217.74	217.23	217.345	6667600.0
2016-08-10 15:00:00	SPY	ETF	217.34	217.73	217.26	217.64	10948888.0
2016-08-10 16:00:00	SPY	ETF	217.64	218.2149	217.591	217.7	5117465.0
2016-08-10 17:00:00	SPY	ETF	217.64	217.7	217.61	217.62	245863.0
2016-08-10 18:00:00	SPY	ETF	217.63	217.64	217.43	217.48	111600.0
2016-08-10 19:00:00	SPY	ETF	217.55	217.62	217.5	217.56	22339.0
2016-08-10 04:00:00	QQQ	ETF	116.95	116.97	116.95	116.97	200.0
2016-08-10 05:00:00	QQQ	ETF	117.03	117.1	116.94	116.94	4700.0
2016-08-10 06:00:00	QQQ	ETF	116.96	116.96	116.95	116.96	700.0
2016-08-10 07:00:00	QQQ	ETF	116.94	117.09	116.94	116.99	66894.0
2016-08-10 08:00:00	QQQ	ETF	117.02	117.08	117.0	117.05	16492.0
2016-08-10 09:00:00	QQQ	ETF	117.08	117.08	116.74	116.74	1057992.0
2016-08-10 10:00:00	QQQ	ETF	116.75	116.99	116.71	116.765	2620741.0
2016-08-10 11:00:00	QQQ	ETF	116.765	116.84	116.31	116.4458	2391233.0
2016-08-10 12:00:00	QQQ	ETF	116.44	116.71	116.4299	116.69	637438.0
2016-08-10 13:00:00	QQQ	ETF	116.7	116.71	116.56	116.59	1462624.0
2016-08-10 14:00:00	QQQ	ETF	116.5834	116.66	116.4	116.5	955659.0
2016-08-10 15:00:00	QQQ	ETF	116.49	116.715	116.45	116.62	2015273.0
2016-08-10 16:00:00	QQQ	ETF	116.62	116.69	116.6	116.65	501957.0
2016-08-10 17:00:00	QQQ	ETF	116.65	116.69	116.64	116.64	1070.0
2016-08-10 18:00:00	QQQ	ETF	116.65	116.65	116.53	116.56	8751.0
2016-08-10 19:00:00	QQQ	ETF	116.57	116.6	116.57	116.6	1350.0
2016-08-10 07:00:00	IWM	ETF	122.5	122.55	122.44	122.45	24087.0
2016-08-10 08:00:00	IWM	ETF	122.45	122.47	122.42	122.47	52478.0
2016-08-10 09:00:00	IWM	ETF	122.5	122.599	121.923	121.94	1662344.0
2016-08-10 10:00:00	IWM	ETF	121.941	122.2497	121.8301	122.029	2928103.0
2016-08-10 11:00:00	IWM	ETF	122.02	122.14	121.15	121.38	4132092.0
2016-08-10 12:00:00	IWM	ETF	121.37	121.8	121.295	121.705	1807182.0
2016-08-10 13:00:00	IWM	ETF	121.715	121.78	121.5	121.57	839960.0
2016-08-10 14:00:00	IWM	ETF	121.56	121.71	121.29	121.36	1307082.0
2016-08-10 15:00:00	IWM	ETF	121.36	121.78	121.29	121.5	3601702.0
2016-08-10 16:00:00	IWM	ETF	121.49	121.68	121.48	121.53	533966.0
2016-08-10 17:00:00	IWM	ETF	121.54	121.55	121.5	121.55	2694.0
2016-08-10 18:00:00	IWM	ETF	121.5	121.5	121.5	121.5	44080.0
2016-08-10 19:00:00	IWM	ETF	121.53	121.53	121.48	121.5	2500.0
2016-08-10 04:00:00	DIA	ETF	185.39	185.39	185.39	185.39	200.0
2016-08-10 05:00:00	DIA	ETF	185.47	185.47	185.47	185.47	200.0
2016-08-10 07:00:00	DIA	ETF	185.47	185.47	185.47	185.47	300.0
2016-08-10 09:00:00	DIA	ETF	185.4	185.69	185.4	185.48	227674.0
2016-08-10 10:00:00	DIA	ETF	185.5	185.7819	185.46	185.49	233135.0

> showing 50 of 7,952 rows — these rows as CSV

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