PREVIEW / etf_1hour / 2016-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-18.parquet
  size:    268 KB
  rows:    8,636

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-18 04:00:00	SPY	ETF	218.5	218.51	218.2	218.51	51527.0
2016-11-18 05:00:00	SPY	ETF	218.53	218.53	218.45	218.5	12072.0
2016-11-18 06:00:00	SPY	ETF	218.52	218.63	218.52	218.61	28296.0
2016-11-18 07:00:00	SPY	ETF	218.67	219.19	218.67	219.14	147005.0
2016-11-18 08:00:00	SPY	ETF	218.68	219.17	218.67	218.95	267545.0
2016-11-18 09:00:00	SPY	ETF	218.98	219.27	218.8101	218.85	11827864.0
2016-11-18 10:00:00	SPY	ETF	218.86	219.09	218.36	218.44	15996839.0
2016-11-18 11:00:00	SPY	ETF	218.44	218.8881	218.29	218.37	14320131.0
2016-11-18 12:00:00	SPY	ETF	218.36	218.61	218.33	218.5989	5071338.0
2016-11-18 13:00:00	SPY	ETF	218.5989	218.75	218.53	218.58	7761513.0
2016-11-18 14:00:00	SPY	ETF	218.58	218.65	218.43	218.49	6104067.0
2016-11-18 15:00:00	SPY	ETF	218.5	218.79	218.29	218.52	14712449.0
2016-11-18 16:00:00	SPY	ETF	218.52	218.6205	218.41	218.56	8392406.0
2016-11-18 17:00:00	SPY	ETF	218.56	218.71	218.51	218.65	127594.0
2016-11-18 18:00:00	SPY	ETF	218.68	218.68	218.55	218.55	51241.0
2016-11-18 19:00:00	SPY	ETF	218.55	218.59	218.55	218.59	21183.0
2016-11-18 04:00:00	QQQ	ETF	117.67	117.67	117.55	117.61	2575.0
2016-11-18 05:00:00	QQQ	ETF	117.65	117.75	117.65	117.75	1300.0
2016-11-18 07:00:00	QQQ	ETF	117.75	118.03	117.75	117.99	23399.0
2016-11-18 08:00:00	QQQ	ETF	117.95	117.96	117.75	117.87	29165.0
2016-11-18 09:00:00	QQQ	ETF	117.88	118.1	117.6807	117.6807	2436303.0
2016-11-18 10:00:00	QQQ	ETF	117.6849	117.84	117.21	117.36	2690638.0
2016-11-18 11:00:00	QQQ	ETF	117.36	117.45	117.27	117.35	1904721.0
2016-11-18 12:00:00	QQQ	ETF	117.34	117.56	117.33	117.56	1219102.0
2016-11-18 13:00:00	QQQ	ETF	117.56	117.58	117.38	117.3999	871412.0
2016-11-18 14:00:00	QQQ	ETF	117.4	117.49	117.36	117.385	1262398.0
2016-11-18 15:00:00	QQQ	ETF	117.39	117.51	117.22	117.32	2909369.0
2016-11-18 16:00:00	QQQ	ETF	117.32	117.4	117.24	117.39	1181300.0
2016-11-18 17:00:00	QQQ	ETF	117.33	117.38	117.33	117.35	2400.0
2016-11-18 18:00:00	QQQ	ETF	117.38	117.44	117.38	117.44	26440.0
2016-11-18 19:00:00	QQQ	ETF	117.44	117.47	117.44	117.47	3902.0
2016-11-18 04:00:00	IWM	ETF	130.16	130.24	130.01	130.23	6361.0
2016-11-18 05:00:00	IWM	ETF	130.23	130.25	130.23	130.25	1100.0
2016-11-18 06:00:00	IWM	ETF	130.28	130.34	130.28	130.29	3394.0
2016-11-18 07:00:00	IWM	ETF	130.38	130.75	130.38	130.71	32663.0
2016-11-18 08:00:00	IWM	ETF	130.38	130.7	130.38	130.69	47310.0
2016-11-18 09:00:00	IWM	ETF	130.68	130.8	130.37	130.53	4195282.0
2016-11-18 10:00:00	IWM	ETF	130.54	130.83	130.35	130.43	7231760.0
2016-11-18 11:00:00	IWM	ETF	130.42	130.81	130.34	130.58	5254244.0
2016-11-18 12:00:00	IWM	ETF	130.58	130.705	130.5	130.7	2315474.0
2016-11-18 13:00:00	IWM	ETF	130.7	130.93	130.65	130.8	2444663.0
2016-11-18 14:00:00	IWM	ETF	130.7995	130.865	130.73	130.82	2255132.0
2016-11-18 15:00:00	IWM	ETF	130.82	131.09	130.81	130.94	6680341.0
2016-11-18 16:00:00	IWM	ETF	130.99	131.08	130.86	130.88	2398205.0
2016-11-18 17:00:00	IWM	ETF	130.9	130.96	130.9	130.92	7150.0
2016-11-18 18:00:00	IWM	ETF	130.99	131.05	130.96	130.96	4801.0
2016-11-18 19:00:00	IWM	ETF	130.99	130.99	130.99	130.99	2434.0
2016-11-18 04:00:00	DIA	ETF	188.84	188.84	188.4	188.4	925.0
2016-11-18 05:00:00	DIA	ETF	188.6	188.6	188.6	188.6	200.0
2016-11-18 07:00:00	DIA	ETF	188.84	188.84	188.79	188.84	3200.0

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

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