PREVIEW / etf_1hour / 2016-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-01.parquet
  size:    279 KB
  rows:    8,977

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-12-01 04:00:00	SPY	ETF	220.29	220.29	220.04	220.11	18733.0
2016-12-01 05:00:00	SPY	ETF	220.06	220.27	220.06	220.1	7166.0
2016-12-01 06:00:00	SPY	ETF	220.1	220.25	220.06	220.23	20501.0
2016-12-01 07:00:00	SPY	ETF	220.25	220.25	220.07	220.19	59786.0
2016-12-01 08:00:00	SPY	ETF	220.15	220.75	220.07	220.68	750990.0
2016-12-01 09:00:00	SPY	ETF	220.68	220.83	220.0	220.3328	9922523.0
2016-12-01 10:00:00	SPY	ETF	220.35	220.7075	219.79	220.0062	12593681.0
2016-12-01 11:00:00	SPY	ETF	220.01	220.39	219.85	220.18	9567765.0
2016-12-01 12:00:00	SPY	ETF	220.19	220.22	219.55	219.63	8990020.0
2016-12-01 13:00:00	SPY	ETF	219.63	219.64	219.27	219.29	7532318.0
2016-12-01 14:00:00	SPY	ETF	219.3	219.73	219.29	219.58	5601764.0
2016-12-01 15:00:00	SPY	ETF	219.57	220.11	219.15	219.52	16808190.0
2016-12-01 16:00:00	SPY	ETF	219.51	219.82	219.51	219.69	3840461.0
2016-12-01 17:00:00	SPY	ETF	219.62	219.63	219.54	219.59	139884.0
2016-12-01 18:00:00	SPY	ETF	219.56	219.57	219.37	219.5	108492.0
2016-12-01 19:00:00	SPY	ETF	219.52	219.68	219.52	219.55	44855.0
2016-12-01 04:00:00	QQQ	ETF	117.3	117.3	117.3	117.3	1000.0
2016-12-01 05:00:00	QQQ	ETF	117.32	117.44	117.32	117.36	2977.0
2016-12-01 06:00:00	QQQ	ETF	117.33	117.4	117.33	117.4	900.0
2016-12-01 07:00:00	QQQ	ETF	117.35	117.42	117.29	117.4	21401.0
2016-12-01 08:00:00	QQQ	ETF	117.4	117.61	117.29	117.56	113675.0
2016-12-01 09:00:00	QQQ	ETF	117.57	117.65	116.565	116.78	4878857.0
2016-12-01 10:00:00	QQQ	ETF	116.79	117.16	115.57	115.9	7189715.0
2016-12-01 11:00:00	QQQ	ETF	115.9	116.24	115.81	115.955	4434078.0
2016-12-01 12:00:00	QQQ	ETF	115.955	115.98	115.53	115.61	2848900.0
2016-12-01 13:00:00	QQQ	ETF	115.605	115.66	115.3655	115.41	3711907.0
2016-12-01 14:00:00	QQQ	ETF	115.42	115.76	115.39	115.675	2755236.0
2016-12-01 15:00:00	QQQ	ETF	115.67	115.719	115.29	115.52	7548103.0
2016-12-01 16:00:00	QQQ	ETF	115.54	115.89	115.47	115.55	2128646.0
2016-12-01 17:00:00	QQQ	ETF	115.58	115.6	115.53	115.56	21546.0
2016-12-01 18:00:00	QQQ	ETF	115.57	115.59	115.46	115.5	45294.0
2016-12-01 19:00:00	QQQ	ETF	115.51	115.55	115.49	115.49	13588.0
2016-12-01 05:00:00	IWM	ETF	131.87	131.87	131.73	131.73	7135.0
2016-12-01 06:00:00	IWM	ETF	131.75	131.89	131.75	131.89	7260.0
2016-12-01 07:00:00	IWM	ETF	131.79	131.87	131.76	131.87	15374.0
2016-12-01 08:00:00	IWM	ETF	131.87	132.29	131.87	132.24	142068.0
2016-12-01 09:00:00	IWM	ETF	132.23	132.55	131.61	132.13	4284747.0
2016-12-01 10:00:00	IWM	ETF	132.13	132.42	131.15	131.41	4967054.0
2016-12-01 11:00:00	IWM	ETF	131.4	131.71	131.3	131.48	3381877.0
2016-12-01 12:00:00	IWM	ETF	131.48	131.51	131.07	131.13	2582514.0
2016-12-01 13:00:00	IWM	ETF	131.12	131.12	130.53	130.5692	3365110.0
2016-12-01 14:00:00	IWM	ETF	130.57	130.875	130.51	130.67	3449053.0
2016-12-01 15:00:00	IWM	ETF	130.665	130.945	130.29	130.9	8123707.0
2016-12-01 16:00:00	IWM	ETF	130.91	131.2	130.8017	131.08	3583699.0
2016-12-01 17:00:00	IWM	ETF	131.05	131.05	130.97	130.98	5900.0
2016-12-01 18:00:00	IWM	ETF	130.93	131.05	130.92	130.92	2796.0
2016-12-01 19:00:00	IWM	ETF	130.97	131.02	130.97	130.97	2004.0
2016-12-01 07:00:00	DIA	ETF	191.45	191.45	191.45	191.45	100.0
2016-12-01 09:00:00	DIA	ETF	191.89	192.02	191.57	191.82	690219.0
2016-12-01 10:00:00	DIA	ETF	191.88	192.08	191.69	192.02	1633412.0

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

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