PREVIEW / etf_1hour / 2016-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-20.parquet
  size:    255 KB
  rows:    8,151

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-20 04:00:00	SPY	ETF	216.4	216.85	216.4	216.75	19797.0
2016-07-20 05:00:00	SPY	ETF	216.75	217.09	216.75	217.03	46400.0
2016-07-20 06:00:00	SPY	ETF	217.05	217.05	216.93	216.93	17984.0
2016-07-20 07:00:00	SPY	ETF	216.93	216.99	216.8	216.83	144455.0
2016-07-20 08:00:00	SPY	ETF	216.83	216.96	215.9	216.68	517758.0
2016-07-20 09:00:00	SPY	ETF	216.69	216.84	216.24	216.505	7286875.0
2016-07-20 10:00:00	SPY	ETF	216.509	217.174	216.4	217.11	8972963.0
2016-07-20 11:00:00	SPY	ETF	217.12	217.37	217.08	217.15	6301254.0
2016-07-20 12:00:00	SPY	ETF	217.15	217.2	217.05	217.11	3226439.0
2016-07-20 13:00:00	SPY	ETF	217.11	217.34	217.09	217.21	5453752.0
2016-07-20 14:00:00	SPY	ETF	217.215	217.37	217.14	217.14	5848700.0
2016-07-20 15:00:00	SPY	ETF	217.145	217.265	217.0	217.09	12728882.0
2016-07-20 16:00:00	SPY	ETF	217.1	217.28	217.04	217.28	4469663.0
2016-07-20 17:00:00	SPY	ETF	217.26	217.28	217.12	217.18	112047.0
2016-07-20 18:00:00	SPY	ETF	217.19	217.23	217.14	217.15	92457.0
2016-07-20 19:00:00	SPY	ETF	217.14	217.18	217.06	217.11	228733.0
2016-07-20 04:00:00	QQQ	ETF	112.44	112.71	112.44	112.67	3598.0
2016-07-20 05:00:00	QQQ	ETF	112.77	112.84	112.77	112.8	4099.0
2016-07-20 06:00:00	QQQ	ETF	112.78	112.79	112.75	112.75	2200.0
2016-07-20 07:00:00	QQQ	ETF	112.74	112.76	112.69	112.73	40665.0
2016-07-20 08:00:00	QQQ	ETF	112.7	112.73	112.65	112.67	237558.0
2016-07-20 09:00:00	QQQ	ETF	112.67	112.97	112.6	112.94	2794619.0
2016-07-20 10:00:00	QQQ	ETF	112.95	113.4	112.9	113.3742	3461671.0
2016-07-20 11:00:00	QQQ	ETF	113.375	113.5	113.295	113.45	1815666.0
2016-07-20 12:00:00	QQQ	ETF	113.45	113.48	113.381	113.41	1274213.0
2016-07-20 13:00:00	QQQ	ETF	113.405	113.59	113.4	113.54	1251001.0
2016-07-20 14:00:00	QQQ	ETF	113.54	113.65	113.45	113.46	1452337.0
2016-07-20 15:00:00	QQQ	ETF	113.45	113.58	113.38	113.44	3610235.0
2016-07-20 16:00:00	QQQ	ETF	113.43	113.59	113.32	113.59	1771736.0
2016-07-20 17:00:00	QQQ	ETF	113.58	113.58	113.52	113.55	12556.0
2016-07-20 18:00:00	QQQ	ETF	113.53	113.55	113.5	113.5	23328.0
2016-07-20 19:00:00	QQQ	ETF	113.51	113.54	113.49	113.53	7148.0
2016-07-20 04:00:00	IWM	ETF	119.81	119.81	119.81	119.81	100.0
2016-07-20 05:00:00	IWM	ETF	119.92	120.0	119.89	119.98	3800.0
2016-07-20 06:00:00	IWM	ETF	119.97	119.97	119.87	119.87	1886.0
2016-07-20 07:00:00	IWM	ETF	119.89	119.9	119.78	119.81	30216.0
2016-07-20 08:00:00	IWM	ETF	119.8	119.8	119.47	119.51	147101.0
2016-07-20 09:00:00	IWM	ETF	119.51	119.66	118.94	119.21	2241112.0
2016-07-20 10:00:00	IWM	ETF	119.21	120.25	119.06	120.18	3546363.0
2016-07-20 11:00:00	IWM	ETF	120.18	120.32	120.03	120.2	1857256.0
2016-07-20 12:00:00	IWM	ETF	120.21	120.3	120.13	120.24	1422903.0
2016-07-20 13:00:00	IWM	ETF	120.245	120.38	120.18	120.28	1149551.0
2016-07-20 14:00:00	IWM	ETF	120.29	120.44	120.21	120.229	1040198.0
2016-07-20 15:00:00	IWM	ETF	120.22	120.24	120.04	120.11	2918747.0
2016-07-20 16:00:00	IWM	ETF	120.11	120.29	120.02	120.28	968500.0
2016-07-20 17:00:00	IWM	ETF	120.28	120.31	120.24	120.24	9228.0
2016-07-20 18:00:00	IWM	ETF	120.27	120.27	120.27	120.27	500.0
2016-07-20 19:00:00	IWM	ETF	120.18	120.23	120.16	120.23	2485.0
2016-07-20 04:00:00	DIA	ETF	185.99	185.99	185.99	185.99	200.0
2016-07-20 05:00:00	DIA	ETF	186.08	186.15	186.08	186.15	300.0

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

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