PREVIEW / etf_1hour / 2016-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-02.parquet
  size:    258 KB
  rows:    8,235

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-02 04:00:00	SPY	ETF	216.64	216.94	216.21	216.31	25197.0
2016-08-02 05:00:00	SPY	ETF	216.27	216.57	216.27	216.43	18750.0
2016-08-02 06:00:00	SPY	ETF	216.39	216.64	216.38	216.49	69068.0
2016-08-02 07:00:00	SPY	ETF	216.52	216.58	216.24	216.39	333441.0
2016-08-02 08:00:00	SPY	ETF	216.27	216.55	216.27	216.42	415423.0
2016-08-02 09:00:00	SPY	ETF	216.42	216.83	216.13	216.29	9408399.0
2016-08-02 10:00:00	SPY	ETF	216.29	216.34	214.93	214.971	19132229.0
2016-08-02 11:00:00	SPY	ETF	214.97	215.47	214.97	215.065	9190585.0
2016-08-02 12:00:00	SPY	ETF	215.06	215.344	214.76	214.86	8211038.0
2016-08-02 13:00:00	SPY	ETF	214.86	214.93	214.57	214.849	7726009.0
2016-08-02 14:00:00	SPY	ETF	214.845	215.57	214.76	215.33	11203371.0
2016-08-02 15:00:00	SPY	ETF	215.34	215.72	215.22	215.55	20133433.0
2016-08-02 16:00:00	SPY	ETF	215.57	215.78	215.4635	215.68	4268939.0
2016-08-02 17:00:00	SPY	ETF	215.68	215.69	215.57	215.6	171237.0
2016-08-02 18:00:00	SPY	ETF	215.61	215.66	215.5	215.55	111371.0
2016-08-02 19:00:00	SPY	ETF	215.56	215.61	215.52	215.53	41019.0
2016-08-02 04:00:00	QQQ	ETF	115.6	115.6	115.47	115.47	399.0
2016-08-02 07:00:00	QQQ	ETF	115.55	115.55	115.46	115.55	127784.0
2016-08-02 08:00:00	QQQ	ETF	115.54	115.62	115.5	115.57	96814.0
2016-08-02 09:00:00	QQQ	ETF	115.55	115.77	115.27	115.41	2624435.0
2016-08-02 10:00:00	QQQ	ETF	115.41	115.42	114.52	114.54	4375467.0
2016-08-02 11:00:00	QQQ	ETF	114.54	114.78	114.53	114.615	2205874.0
2016-08-02 12:00:00	QQQ	ETF	114.61	114.78	114.46	114.52	1375835.0
2016-08-02 13:00:00	QQQ	ETF	114.529	114.55	114.22	114.49	2371486.0
2016-08-02 14:00:00	QQQ	ETF	114.48	115.12	114.43	114.925	3201186.0
2016-08-02 15:00:00	QQQ	ETF	114.92	115.15	114.86	114.96	2643064.0
2016-08-02 16:00:00	QQQ	ETF	114.96	115.07	114.96	115.02	1269395.0
2016-08-02 17:00:00	QQQ	ETF	115.03	115.08	114.99	115.0	1635.0
2016-08-02 18:00:00	QQQ	ETF	114.98	114.99	114.88	114.89	20365.0
2016-08-02 19:00:00	QQQ	ETF	114.91	114.93	114.89	114.89	5800.0
2016-08-02 04:00:00	IWM	ETF	121.01	121.01	121.01	121.01	100.0
2016-08-02 05:00:00	IWM	ETF	120.84	120.96	120.84	120.96	4500.0
2016-08-02 07:00:00	IWM	ETF	121.05	121.05	120.84	120.95	90599.0
2016-08-02 08:00:00	IWM	ETF	120.96	121.04	120.92	120.94	258474.0
2016-08-02 09:00:00	IWM	ETF	120.94	121.21	120.63	120.72	3040496.0
2016-08-02 10:00:00	IWM	ETF	120.72	120.76	119.55	119.58	4831260.0
2016-08-02 11:00:00	IWM	ETF	119.59	119.89	119.52	119.56	3370874.0
2016-08-02 12:00:00	IWM	ETF	119.55	119.63	119.26	119.29	2087879.0
2016-08-02 13:00:00	IWM	ETF	119.29	119.44	119.1	119.32	2165523.0
2016-08-02 14:00:00	IWM	ETF	119.34	119.92	119.301	119.65	3511730.0
2016-08-02 15:00:00	IWM	ETF	119.655	119.78	119.4	119.46	4213744.0
2016-08-02 16:00:00	IWM	ETF	119.45	119.64	119.41	119.5	1778380.0
2016-08-02 17:00:00	IWM	ETF	119.5	119.5	119.46	119.46	4440.0
2016-08-02 18:00:00	IWM	ETF	119.46	119.47	119.46	119.47	600.0
2016-08-02 19:00:00	IWM	ETF	119.47	119.47	119.37	119.47	3302.0
2016-08-02 04:00:00	DIA	ETF	183.52	183.52	183.52	183.52	100.0
2016-08-02 05:00:00	DIA	ETF	183.7	183.7	183.7	183.7	100.0
2016-08-02 08:00:00	DIA	ETF	183.54	183.6	183.41	183.6	4602.0
2016-08-02 09:00:00	DIA	ETF	183.57	183.86	183.37	183.45	361922.0
2016-08-02 10:00:00	DIA	ETF	183.44	183.49	182.644	182.669	1232156.0

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

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