PREVIEW / etf_1hour / 2016-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-21.parquet
  size:    273 KB
  rows:    8,810

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-11-21 04:00:00	SPY	ETF	218.93	218.93	218.46	218.65	21646.0
2016-11-21 05:00:00	SPY	ETF	218.77	219.09	218.77	218.89	8711.0
2016-11-21 06:00:00	SPY	ETF	218.9	219.05	218.9	219.03	9663.0
2016-11-21 07:00:00	SPY	ETF	219.02	219.08	218.9	219.05	189263.0
2016-11-21 08:00:00	SPY	ETF	219.02	219.21	218.91	219.16	647416.0
2016-11-21 09:00:00	SPY	ETF	219.17	219.64	218.5	219.59	7845370.0
2016-11-21 10:00:00	SPY	ETF	219.5957	219.63	219.0	219.35	7983821.0
2016-11-21 11:00:00	SPY	ETF	219.35	219.68	219.3	219.68	6454027.0
2016-11-21 12:00:00	SPY	ETF	219.675	219.98	219.56	219.91	7368498.0
2016-11-21 13:00:00	SPY	ETF	219.91	220.04	219.88	219.91	5793102.0
2016-11-21 14:00:00	SPY	ETF	219.91	219.93	219.77	219.81	5706916.0
2016-11-21 15:00:00	SPY	ETF	219.81	220.18	219.77	220.11	17372972.0
2016-11-21 16:00:00	SPY	ETF	220.11	220.15	219.75	219.89	8680569.0
2016-11-21 17:00:00	SPY	ETF	219.89	220.15	219.84	219.87	543076.0
2016-11-21 18:00:00	SPY	ETF	219.91	219.97	219.86	219.9	85103.0
2016-11-21 19:00:00	SPY	ETF	219.95	220.15	219.95	220.14	117436.0
2016-11-21 04:00:00	QQQ	ETF	117.29	117.31	117.25	117.31	1059.0
2016-11-21 05:00:00	QQQ	ETF	117.55	117.59	117.55	117.58	860.0
2016-11-21 06:00:00	QQQ	ETF	117.56	117.67	117.56	117.61	5122.0
2016-11-21 07:00:00	QQQ	ETF	117.62	117.67	117.57	117.65	116339.0
2016-11-21 08:00:00	QQQ	ETF	117.61	117.71	117.6	117.67	41251.0
2016-11-21 09:00:00	QQQ	ETF	117.68	118.36	117.32	118.301	2543061.0
2016-11-21 10:00:00	QQQ	ETF	118.31	118.32	117.7	117.98	3414211.0
2016-11-21 11:00:00	QQQ	ETF	117.99	118.41	117.96	118.41	3128250.0
2016-11-21 12:00:00	QQQ	ETF	118.41	118.49	118.2627	118.42	1373946.0
2016-11-21 13:00:00	QQQ	ETF	118.41	118.525	118.35	118.4788	1082738.0
2016-11-21 14:00:00	QQQ	ETF	118.47	118.505	118.34	118.39	1059573.0
2016-11-21 15:00:00	QQQ	ETF	118.39	118.65	118.36	118.56	3946617.0
2016-11-21 16:00:00	QQQ	ETF	118.55	118.58	118.38	118.55	1105459.0
2016-11-21 17:00:00	QQQ	ETF	118.46	118.5	118.43	118.5	28726.0
2016-11-21 18:00:00	QQQ	ETF	118.53	118.58	118.52	118.58	22515.0
2016-11-21 19:00:00	QQQ	ETF	118.59	118.69	118.58	118.69	6200.0
2016-11-21 04:00:00	IWM	ETF	130.76	130.78	130.76	130.78	1658.0
2016-11-21 05:00:00	IWM	ETF	131.0	131.12	131.0	131.12	20100.0
2016-11-21 06:00:00	IWM	ETF	131.05	131.05	131.05	131.05	2000.0
2016-11-21 07:00:00	IWM	ETF	131.08	131.14	130.98	131.1	125224.0
2016-11-21 08:00:00	IWM	ETF	131.01	131.28	131.01	131.26	52579.0
2016-11-21 09:00:00	IWM	ETF	131.27	132.0	130.99	131.5033	4129729.0
2016-11-21 10:00:00	IWM	ETF	131.51	131.58	130.61	130.995	5337316.0
2016-11-21 11:00:00	IWM	ETF	130.99	131.21	130.72	131.21	4102796.0
2016-11-21 12:00:00	IWM	ETF	131.215	131.47	131.045	131.26	2495474.0
2016-11-21 13:00:00	IWM	ETF	131.26	131.47	131.21	131.3787	1977374.0
2016-11-21 14:00:00	IWM	ETF	131.37	131.6	131.33	131.5	2499544.0
2016-11-21 15:00:00	IWM	ETF	131.51	131.62	131.21	131.61	3734653.0
2016-11-21 16:00:00	IWM	ETF	131.61	131.69	131.51	131.69	900773.0
2016-11-21 17:00:00	IWM	ETF	131.7	131.73	131.6	131.7	37378.0
2016-11-21 18:00:00	IWM	ETF	131.67	131.7	131.55	131.55	2971.0
2016-11-21 19:00:00	IWM	ETF	131.58	131.74	131.58	131.74	1953.0
2016-11-21 07:00:00	DIA	ETF	188.68	188.74	188.68	188.74	2065.0
2016-11-21 08:00:00	DIA	ETF	188.78	188.86	188.73	188.85	3027.0

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

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