PREVIEW / etf_1hour / 2016-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-18.parquet
  size:    249 KB
  rows:    7,965

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-18 04:00:00	SPY	ETF	218.45	218.5	218.38	218.5	1043.0
2016-08-18 05:00:00	SPY	ETF	218.46	218.46	218.35	218.38	3301.0
2016-08-18 06:00:00	SPY	ETF	218.41	218.43	218.36	218.4	15975.0
2016-08-18 07:00:00	SPY	ETF	218.34	218.39	218.1	218.13	123768.0
2016-08-18 08:00:00	SPY	ETF	218.15	218.679	218.1	218.23	271292.0
2016-08-18 09:00:00	SPY	ETF	218.2	218.6	218.2	218.46	6457771.0
2016-08-18 10:00:00	SPY	ETF	218.46	218.86	218.38	218.84	8659135.0
2016-08-18 11:00:00	SPY	ETF	218.84	218.84	218.57	218.6	6382244.0
2016-08-18 12:00:00	SPY	ETF	218.59	218.59	218.24	218.39	5251033.0
2016-08-18 13:00:00	SPY	ETF	218.4	218.7	218.39	218.6	4211183.0
2016-08-18 14:00:00	SPY	ETF	218.6	218.67	218.49	218.605	5854154.0
2016-08-18 15:00:00	SPY	ETF	218.6	218.9	218.59	218.87	10629185.0
2016-08-18 16:00:00	SPY	ETF	218.87	218.9	218.7467	218.78	2903480.0
2016-08-18 17:00:00	SPY	ETF	218.77	218.84	218.74	218.82	342807.0
2016-08-18 18:00:00	SPY	ETF	218.82	218.86	218.79	218.84	152649.0
2016-08-18 19:00:00	SPY	ETF	218.84	218.86	218.81	218.86	35638.0
2016-08-18 04:00:00	QQQ	ETF	117.2	117.25	117.2	117.25	1198.0
2016-08-18 05:00:00	QQQ	ETF	117.15	117.15	117.13	117.13	2000.0
2016-08-18 06:00:00	QQQ	ETF	117.11	117.16	117.11	117.13	2359.0
2016-08-18 07:00:00	QQQ	ETF	117.14	117.14	116.97	116.97	8540.0
2016-08-18 08:00:00	QQQ	ETF	117.0	117.1	116.96	117.09	41755.0
2016-08-18 09:00:00	QQQ	ETF	117.07	117.34	117.0	117.24	1641854.0
2016-08-18 10:00:00	QQQ	ETF	117.24	117.46	117.19	117.43	2154604.0
2016-08-18 11:00:00	QQQ	ETF	117.44	117.45	117.2884	117.32	912375.0
2016-08-18 12:00:00	QQQ	ETF	117.32	117.32	116.945	117.1	1274717.0
2016-08-18 13:00:00	QQQ	ETF	117.11	117.35	117.11	117.285	456359.0
2016-08-18 14:00:00	QQQ	ETF	117.29	117.31	117.2	117.29	688618.0
2016-08-18 15:00:00	QQQ	ETF	117.29	117.399	117.23	117.3	1475563.0
2016-08-18 16:00:00	QQQ	ETF	117.31	117.36	117.2798	117.31	571418.0
2016-08-18 17:00:00	QQQ	ETF	117.3	117.32	117.25	117.32	4090.0
2016-08-18 18:00:00	QQQ	ETF	117.33	117.36	117.3	117.36	5387.0
2016-08-18 19:00:00	QQQ	ETF	117.33	117.35	117.33	117.33	4400.0
2016-08-18 06:00:00	IWM	ETF	122.02	122.02	122.02	122.02	100.0
2016-08-18 07:00:00	IWM	ETF	122.02	122.03	121.87	121.87	2800.0
2016-08-18 08:00:00	IWM	ETF	121.84	122.0	121.79	121.97	72356.0
2016-08-18 09:00:00	IWM	ETF	121.97	122.4	121.97	122.29	1562135.0
2016-08-18 10:00:00	IWM	ETF	122.3	122.92	122.28	122.85	2737793.0
2016-08-18 11:00:00	IWM	ETF	122.86	122.97	122.71	122.82	1554911.0
2016-08-18 12:00:00	IWM	ETF	122.83	122.835	122.21	122.5	1679829.0
2016-08-18 13:00:00	IWM	ETF	122.51	122.905	122.505	122.74	1195473.0
2016-08-18 14:00:00	IWM	ETF	122.74	122.79	122.6	122.695	1299228.0
2016-08-18 15:00:00	IWM	ETF	122.695	122.97	122.67	122.96	3767058.0
2016-08-18 16:00:00	IWM	ETF	122.95	123.0	122.9	122.96	529931.0
2016-08-18 17:00:00	IWM	ETF	122.97	123.06	122.97	123.0	21199.0
2016-08-18 18:00:00	IWM	ETF	123.02	123.02	122.96	122.96	2249.0
2016-08-18 19:00:00	IWM	ETF	122.96	123.03	122.95	122.97	5666.0
2016-08-18 07:00:00	DIA	ETF	186.1	186.1	186.1	186.1	400.0
2016-08-18 08:00:00	DIA	ETF	185.91	186.0	185.91	186.0	1274.0
2016-08-18 09:00:00	DIA	ETF	185.98	186.25	185.91	186.09	232436.0
2016-08-18 10:00:00	DIA	ETF	186.07	186.41	186.03	186.4	338710.0

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

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