PREVIEW / etf_1hour / 2017-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-01-13.parquet
  size:    269 KB
  rows:    8,638

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
2017-01-13 04:00:00	SPY	ETF	226.53	226.54	226.53	226.54	200.0
2017-01-13 05:00:00	SPY	ETF	226.69	226.82	226.69	226.82	2004.0
2017-01-13 06:00:00	SPY	ETF	226.78	226.8	226.63	226.64	21484.0
2017-01-13 07:00:00	SPY	ETF	226.69	226.75	226.59	226.75	176166.0
2017-01-13 08:00:00	SPY	ETF	226.67	226.8	226.4	226.68	426754.0
2017-01-13 09:00:00	SPY	ETF	226.7	227.4	226.65	227.2	7438005.0
2017-01-13 10:00:00	SPY	ETF	227.19	227.31	226.9865	227.2062	6783086.0
2017-01-13 11:00:00	SPY	ETF	227.2	227.33	227.05	227.25	8436032.0
2017-01-13 12:00:00	SPY	ETF	227.26	227.29	226.81	227.085	4634975.0
2017-01-13 13:00:00	SPY	ETF	227.09	227.15	226.96	226.999	2963901.0
2017-01-13 14:00:00	SPY	ETF	227.0	227.0599	226.69	227.0	5495211.0
2017-01-13 15:00:00	SPY	ETF	226.99	227.2	226.85	227.03	11942037.0
2017-01-13 16:00:00	SPY	ETF	227.04	227.32	226.96	227.12	13417003.0
2017-01-13 17:00:00	SPY	ETF	227.17	227.3	227.05	227.15	150863.0
2017-01-13 18:00:00	SPY	ETF	227.14	227.22	227.13	227.16	20498.0
2017-01-13 19:00:00	SPY	ETF	227.16	227.22	227.16	227.22	6923.0
2017-01-13 05:00:00	QQQ	ETF	122.82	122.82	122.82	122.82	800.0
2017-01-13 06:00:00	QQQ	ETF	122.9	122.9	122.85	122.85	14996.0
2017-01-13 07:00:00	QQQ	ETF	122.86	122.92	122.83	122.88	90747.0
2017-01-13 08:00:00	QQQ	ETF	122.88	123.02	122.78	122.84	226516.0
2017-01-13 09:00:00	QQQ	ETF	122.87	123.28	122.8	123.15	2734470.0
2017-01-13 10:00:00	QQQ	ETF	123.15	123.31	122.99	123.23	1495705.0
2017-01-13 11:00:00	QQQ	ETF	123.24	123.37	123.11	123.35	1439623.0
2017-01-13 12:00:00	QQQ	ETF	123.35	123.36	123.11	123.26	1208549.0
2017-01-13 13:00:00	QQQ	ETF	123.27	123.32	123.23	123.24	575749.0
2017-01-13 14:00:00	QQQ	ETF	123.24	123.28	123.07	123.2165	1272789.0
2017-01-13 15:00:00	QQQ	ETF	123.21	123.22	123.08	123.16	2635672.0
2017-01-13 16:00:00	QQQ	ETF	123.16	123.32	123.13	123.29	2337487.0
2017-01-13 17:00:00	QQQ	ETF	123.3	123.3	123.26	123.29	1015.0
2017-01-13 18:00:00	QQQ	ETF	123.3	123.3	123.26	123.26	1384.0
2017-01-13 19:00:00	QQQ	ETF	123.26	123.28	123.1779	123.26	50030.0
2017-01-13 04:00:00	IWM	ETF	135.29	135.29	135.29	135.29	300.0
2017-01-13 05:00:00	IWM	ETF	135.34	135.46	135.34	135.46	1389.0
2017-01-13 06:00:00	IWM	ETF	135.3	135.3	135.3	135.3	1000.0
2017-01-13 07:00:00	IWM	ETF	135.32	135.4	135.32	135.4	8497.0
2017-01-13 08:00:00	IWM	ETF	135.47	135.53	135.29	135.51	48276.0
2017-01-13 09:00:00	IWM	ETF	135.54	136.97	135.52	136.56	5740798.0
2017-01-13 10:00:00	IWM	ETF	136.56	136.74	136.26	136.56	3048809.0
2017-01-13 11:00:00	IWM	ETF	136.565	136.79	136.36	136.74	2106618.0
2017-01-13 12:00:00	IWM	ETF	136.75	136.79	136.29	136.58	1902495.0
2017-01-13 13:00:00	IWM	ETF	136.59	136.65	136.34	136.435	1357476.0
2017-01-13 14:00:00	IWM	ETF	136.435	136.45	135.93	136.19	1986649.0
2017-01-13 15:00:00	IWM	ETF	136.2	136.36	136.08	136.29	3610657.0
2017-01-13 16:00:00	IWM	ETF	136.26	136.66	136.26	136.4	1872572.0
2017-01-13 17:00:00	IWM	ETF	136.48	136.5	136.45	136.45	3668.0
2017-01-13 18:00:00	IWM	ETF	136.45	136.49	136.45	136.49	1099.0
2017-01-13 19:00:00	IWM	ETF	136.45	136.5	136.273	136.45	1202000.0
2017-01-13 08:00:00	DIA	ETF	198.86	198.89	198.7	198.8	16756.0
2017-01-13 09:00:00	DIA	ETF	198.89	199.35	198.88	198.98	582337.0
2017-01-13 10:00:00	DIA	ETF	199.04	199.16	198.78	198.9	424092.0

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

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