PREVIEW / etf_1hour / 2017-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-28.parquet
  size:    272 KB
  rows:    8,825

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-04-28 04:00:00	SPY	ETF	238.65	238.83	238.65	238.71	10227.0
2017-04-28 05:00:00	SPY	ETF	238.73	238.93	238.73	238.93	13922.0
2017-04-28 06:00:00	SPY	ETF	238.92	238.93	238.82	238.83	5113.0
2017-04-28 07:00:00	SPY	ETF	238.9	238.95	238.75	238.82	172878.0
2017-04-28 08:00:00	SPY	ETF	238.9	238.95	238.73	238.8	262765.0
2017-04-28 09:00:00	SPY	ETF	238.8	238.96	238.44	238.525	5268322.0
2017-04-28 10:00:00	SPY	ETF	238.53	238.6	238.16	238.375	7497767.0
2017-04-28 11:00:00	SPY	ETF	238.38	238.44	238.03	238.12	5487000.0
2017-04-28 12:00:00	SPY	ETF	238.12	238.345	238.12	238.225	3523263.0
2017-04-28 13:00:00	SPY	ETF	238.22	238.28	238.03	238.11	3373169.0
2017-04-28 14:00:00	SPY	ETF	238.1	238.2	237.93	238.05	5392685.0
2017-04-28 15:00:00	SPY	ETF	238.04	238.25	237.99	238.1	16553275.0
2017-04-28 16:00:00	SPY	ETF	238.11	238.29	238.04	238.14	10940314.0
2017-04-28 17:00:00	SPY	ETF	238.14	238.14	237.83	237.89	2105103.0
2017-04-28 18:00:00	SPY	ETF	237.89	237.95	237.83	237.88	48001.0
2017-04-28 19:00:00	SPY	ETF	237.9	237.96	237.85	237.93	20967.0
2017-04-28 04:00:00	QQQ	ETF	136.2	136.2	136.18	136.18	2070.0
2017-04-28 05:00:00	QQQ	ETF	136.23	136.23	136.23	136.23	500.0
2017-04-28 06:00:00	QQQ	ETF	136.28	136.28	136.27	136.27	988.0
2017-04-28 07:00:00	QQQ	ETF	136.31	136.4	136.24	136.24	105167.0
2017-04-28 08:00:00	QQQ	ETF	136.36	136.36	136.11	136.16	146179.0
2017-04-28 09:00:00	QQQ	ETF	136.14	136.34	135.91	135.91	3690290.0
2017-04-28 10:00:00	QQQ	ETF	135.92	136.07	135.86	136.07	2414456.0
2017-04-28 11:00:00	QQQ	ETF	136.07	136.0736	135.8	135.86	1460094.0
2017-04-28 12:00:00	QQQ	ETF	135.86	136.11	135.86	136.02	860681.0
2017-04-28 13:00:00	QQQ	ETF	136.0293	136.08	135.92	135.93	894308.0
2017-04-28 14:00:00	QQQ	ETF	135.92	135.958	135.77	135.86	1323875.0
2017-04-28 15:00:00	QQQ	ETF	135.86	136.06	135.821	135.975	4249635.0
2017-04-28 16:00:00	QQQ	ETF	135.97	136.06	135.97	136.0	933121.0
2017-04-28 17:00:00	QQQ	ETF	135.96	135.99	135.91	135.91	2266425.0
2017-04-28 18:00:00	QQQ	ETF	135.91	135.96	135.91	135.95	2276.0
2017-04-28 19:00:00	QQQ	ETF	135.95	135.97	135.88	135.96	3782.0
2017-04-28 04:00:00	IWM	ETF	141.17	141.17	141.13	141.13	800.0
2017-04-28 05:00:00	IWM	ETF	141.2	141.2	141.15	141.15	500.0
2017-04-28 06:00:00	IWM	ETF	141.25	141.26	141.18	141.25	5003.0
2017-04-28 07:00:00	IWM	ETF	141.27	141.32	141.14	141.2	91996.0
2017-04-28 08:00:00	IWM	ETF	141.13	141.18	140.95	140.96	17245.0
2017-04-28 09:00:00	IWM	ETF	140.94	141.17	140.46	140.53	2438383.0
2017-04-28 10:00:00	IWM	ETF	140.53	140.6	139.75	139.9	3974905.0
2017-04-28 11:00:00	IWM	ETF	139.91	139.95	139.39	139.5	2684703.0
2017-04-28 12:00:00	IWM	ETF	139.52	139.745	139.38	139.54	1863064.0
2017-04-28 13:00:00	IWM	ETF	139.54	139.72	139.44	139.45	2002481.0
2017-04-28 14:00:00	IWM	ETF	139.45	139.49	139.25	139.33	2207357.0
2017-04-28 15:00:00	IWM	ETF	139.33	139.63	139.04	139.06	5576791.0
2017-04-28 16:00:00	IWM	ETF	139.06	139.31	139.04	139.06	2473981.0
2017-04-28 17:00:00	IWM	ETF	139.06	139.1	138.21	138.93	639475.0
2017-04-28 18:00:00	IWM	ETF	138.96	139.0	138.96	139.0	1774.0
2017-04-28 19:00:00	IWM	ETF	138.95	139.2061	138.95	139.06	649602.0
2017-04-28 07:00:00	DIA	ETF	209.38	209.5	209.38	209.5	1235.0
2017-04-28 08:00:00	DIA	ETF	209.49	209.6	209.49	209.6	1200.0

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

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