PREVIEW / etf_1hour / 2016-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-19.parquet
  size:    248 KB
  rows:    8,046

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-07-19 04:00:00	SPY	ETF	215.81	215.84	215.6	215.73	21024.0
2016-07-19 05:00:00	SPY	ETF	215.71	215.84	215.7	215.73	18594.0
2016-07-19 06:00:00	SPY	ETF	215.7	215.94	215.63	215.9	45846.0
2016-07-19 07:00:00	SPY	ETF	215.91	216.03	215.82	215.92	167358.0
2016-07-19 08:00:00	SPY	ETF	215.93	216.08	215.85	215.9	369218.0
2016-07-19 09:00:00	SPY	ETF	215.91	216.16	215.71	215.84	7634512.0
2016-07-19 10:00:00	SPY	ETF	215.84	216.1	215.7	216.04	7196140.0
2016-07-19 11:00:00	SPY	ETF	216.049	216.23	215.68	215.77	6935036.0
2016-07-19 12:00:00	SPY	ETF	215.77	216.01	215.68	215.97	4240512.0
2016-07-19 13:00:00	SPY	ETF	215.96	215.97	215.63	215.7	3531894.0
2016-07-19 14:00:00	SPY	ETF	215.7	216.0	215.69	215.8701	3069687.0
2016-07-19 15:00:00	SPY	ETF	215.88	216.16	215.805	216.15	9539828.0
2016-07-19 16:00:00	SPY	ETF	216.15	216.38	216.0	216.32	9250429.0
2016-07-19 17:00:00	SPY	ETF	216.29	216.34	216.19	216.27	185821.0
2016-07-19 18:00:00	SPY	ETF	216.29	216.37	216.24	216.24	119421.0
2016-07-19 19:00:00	SPY	ETF	216.24	216.28	216.2	216.22	40247.0
2016-07-19 04:00:00	QQQ	ETF	112.1	112.12	112.1	112.12	200.0
2016-07-19 05:00:00	QQQ	ETF	112.13	112.14	112.11	112.11	2812.0
2016-07-19 06:00:00	QQQ	ETF	112.1	112.1	112.08	112.08	5599.0
2016-07-19 07:00:00	QQQ	ETF	112.13	112.19	112.11	112.13	9171.0
2016-07-19 08:00:00	QQQ	ETF	112.13	112.24	112.11	112.19	324959.0
2016-07-19 09:00:00	QQQ	ETF	112.18	112.48	111.97	112.06	5092798.0
2016-07-19 10:00:00	QQQ	ETF	112.07	112.3	112.01	112.26	1586880.0
2016-07-19 11:00:00	QQQ	ETF	112.25	112.36	112.06	112.1144	1583364.0
2016-07-19 12:00:00	QQQ	ETF	112.12	112.22	112.03	112.18	1037664.0
2016-07-19 13:00:00	QQQ	ETF	112.17	112.17	111.93	111.9699	838480.0
2016-07-19 14:00:00	QQQ	ETF	111.97	112.1	111.96	112.04	765324.0
2016-07-19 15:00:00	QQQ	ETF	112.05	112.12	111.99	112.12	1909950.0
2016-07-19 16:00:00	QQQ	ETF	112.12	112.47	112.08	112.39	798989.0
2016-07-19 17:00:00	QQQ	ETF	112.35	112.38	112.35	112.35	5973.0
2016-07-19 18:00:00	QQQ	ETF	112.38	112.45	112.38	112.43	18790.0
2016-07-19 19:00:00	QQQ	ETF	112.36	112.4	112.33	112.33	8158.0
2016-07-19 04:00:00	IWM	ETF	119.7	119.7	119.48	119.57	13244.0
2016-07-19 05:00:00	IWM	ETF	119.55	119.57	119.55	119.55	300.0
2016-07-19 06:00:00	IWM	ETF	119.55	119.6	119.55	119.6	300.0
2016-07-19 07:00:00	IWM	ETF	119.62	119.77	119.57	119.69	106300.0
2016-07-19 08:00:00	IWM	ETF	119.67	119.77	119.58	119.74	170711.0
2016-07-19 09:00:00	IWM	ETF	119.74	119.97	119.5209	119.58	1989675.0
2016-07-19 10:00:00	IWM	ETF	119.58	119.89	119.46	119.645	1666534.0
2016-07-19 11:00:00	IWM	ETF	119.63	119.93	119.58	119.6	1476716.0
2016-07-19 12:00:00	IWM	ETF	119.6	119.6	119.25	119.38	1339433.0
2016-07-19 13:00:00	IWM	ETF	119.38	119.385	118.93	119.065	2264487.0
2016-07-19 14:00:00	IWM	ETF	119.07	119.35	119.065	119.2301	986081.0
2016-07-19 15:00:00	IWM	ETF	119.23	119.31	119.1105	119.25	2443031.0
2016-07-19 16:00:00	IWM	ETF	119.26	119.46	119.26	119.4	924062.0
2016-07-19 17:00:00	IWM	ETF	119.39	119.49	119.38	119.4	4225.0
2016-07-19 18:00:00	IWM	ETF	119.46	119.46	119.46	119.46	500.0
2016-07-19 19:00:00	IWM	ETF	119.34	119.4	119.34	119.4	1665.0
2016-07-19 04:00:00	DIA	ETF	184.76	184.8	184.76	184.8	300.0
2016-07-19 05:00:00	DIA	ETF	184.8	184.8	184.8	184.8	200.0

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

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