PREVIEW / etf_1hour / 2016-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-31.parquet
  size:    252 KB
  rows:    8,062

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-31 04:00:00	SPY	ETF	218.0	218.02	217.95	218.0	7162.0
2016-08-31 05:00:00	SPY	ETF	217.95	218.05	217.88	218.02	5307.0
2016-08-31 06:00:00	SPY	ETF	217.93	217.95	217.86	217.95	4284.0
2016-08-31 07:00:00	SPY	ETF	217.94	218.02	217.92	217.95	30381.0
2016-08-31 08:00:00	SPY	ETF	217.95	218.043	217.63	217.7	255205.0
2016-08-31 09:00:00	SPY	ETF	217.7	217.75	217.44	217.61	5764834.0
2016-08-31 10:00:00	SPY	ETF	217.615	217.73	217.07	217.08	8100061.0
2016-08-31 11:00:00	SPY	ETF	217.08	217.24	216.975	217.04	6417989.0
2016-08-31 12:00:00	SPY	ETF	217.045	217.7	216.465	216.71	10393995.0
2016-08-31 13:00:00	SPY	ETF	216.715	216.98	216.53	216.89	5855141.0
2016-08-31 14:00:00	SPY	ETF	216.9	217.27	216.87	216.96	10668874.0
2016-08-31 15:00:00	SPY	ETF	216.96	217.61	216.94	217.39	21274318.0
2016-08-31 16:00:00	SPY	ETF	217.38	217.63	217.33	217.4	12869675.0
2016-08-31 17:00:00	SPY	ETF	217.4	217.45	217.35	217.4	452403.0
2016-08-31 18:00:00	SPY	ETF	217.41	217.44	217.38	217.44	29338.0
2016-08-31 19:00:00	SPY	ETF	217.43	217.47	217.39	217.46	28852.0
2016-08-31 04:00:00	QQQ	ETF	116.49	116.49	116.48	116.48	1000.0
2016-08-31 05:00:00	QQQ	ETF	116.49	116.53	116.49	116.53	2000.0
2016-08-31 06:00:00	QQQ	ETF	116.48	116.48	116.44	116.44	1200.0
2016-08-31 07:00:00	QQQ	ETF	116.5	116.57	116.5	116.54	40721.0
2016-08-31 08:00:00	QQQ	ETF	116.54	116.54	116.36	116.38	43216.0
2016-08-31 09:00:00	QQQ	ETF	116.39	116.54	116.26	116.49	1752309.0
2016-08-31 10:00:00	QQQ	ETF	116.49	116.56	116.21	116.32	1212609.0
2016-08-31 11:00:00	QQQ	ETF	116.31	116.44	116.24	116.35	1569460.0
2016-08-31 12:00:00	QQQ	ETF	116.35	116.35	115.95	116.151	2699202.0
2016-08-31 13:00:00	QQQ	ETF	116.16	116.2998	116.09	116.24	928974.0
2016-08-31 14:00:00	QQQ	ETF	116.23	116.44	116.16	116.2	1767686.0
2016-08-31 15:00:00	QQQ	ETF	116.19	116.55	116.19	116.43	3986795.0
2016-08-31 16:00:00	QQQ	ETF	116.44	116.54	116.4	116.46	641911.0
2016-08-31 17:00:00	QQQ	ETF	116.45	116.46	116.44	116.46	96282.0
2016-08-31 18:00:00	QQQ	ETF	116.51	116.51	116.47	116.48	9011.0
2016-08-31 19:00:00	QQQ	ETF	116.49	116.51	116.45	116.45	4425.0
2016-08-31 07:00:00	IWM	ETF	124.0	124.0	124.0	124.0	200.0
2016-08-31 08:00:00	IWM	ETF	123.98	124.01	123.81	123.81	39284.0
2016-08-31 09:00:00	IWM	ETF	123.85	123.9	123.5699	123.69	2055673.0
2016-08-31 10:00:00	IWM	ETF	123.69	123.81	122.74	122.76	4244480.0
2016-08-31 11:00:00	IWM	ETF	122.76	123.02	122.62	122.86	3562640.0
2016-08-31 12:00:00	IWM	ETF	122.85	122.98	122.55	122.85	2271037.0
2016-08-31 13:00:00	IWM	ETF	122.86	122.985	122.63	122.901	1541879.0
2016-08-31 14:00:00	IWM	ETF	122.9	123.35	122.8828	122.96	2355996.0
2016-08-31 15:00:00	IWM	ETF	122.96	123.59	122.92	123.24	5488189.0
2016-08-31 16:00:00	IWM	ETF	123.23	123.43	122.655	123.32	1470005.0
2016-08-31 17:00:00	IWM	ETF	123.31	123.38	123.23	123.23	104137.0
2016-08-31 19:00:00	IWM	ETF	123.37	123.39	123.3	123.39	2710.0
2016-08-31 09:00:00	DIA	ETF	184.17	184.35	184.0599	184.29	331465.0
2016-08-31 10:00:00	DIA	ETF	184.29	184.36	183.79	183.8	252101.0
2016-08-31 11:00:00	DIA	ETF	183.79	183.91	183.68	183.74	140827.0
2016-08-31 12:00:00	DIA	ETF	183.72	183.72	183.27	183.49	231985.0
2016-08-31 13:00:00	DIA	ETF	183.48	183.697	183.35	183.613	106055.0
2016-08-31 14:00:00	DIA	ETF	183.61	183.86	183.5979	183.68	255345.0

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

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