PREVIEW / etf_1hour / 2016-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-30.parquet
  size:    280 KB
  rows:    9,023

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-30 04:00:00	SPY	ETF	221.18	221.44	221.03	221.11	22827.0
2016-11-30 05:00:00	SPY	ETF	221.06	221.25	220.93	221.16	8969.0
2016-11-30 06:00:00	SPY	ETF	221.2	221.39	221.17	221.39	34991.0
2016-11-30 07:00:00	SPY	ETF	221.44	221.54	221.37	221.43	464598.0
2016-11-30 08:00:00	SPY	ETF	221.41	221.55	221.33	221.5	1293823.0
2016-11-30 09:00:00	SPY	ETF	221.52	221.84	221.39	221.45	10547937.0
2016-11-30 10:00:00	SPY	ETF	221.44	221.59	220.94	221.22	13347062.0
2016-11-30 11:00:00	SPY	ETF	221.22	221.65	221.01	221.07	8914975.0
2016-11-30 12:00:00	SPY	ETF	221.07	221.179	220.89	221.13	6200134.0
2016-11-30 13:00:00	SPY	ETF	221.13	221.3	221.08	221.1985	8051014.0
2016-11-30 14:00:00	SPY	ETF	221.195	221.2	220.5	220.58	11963935.0
2016-11-30 15:00:00	SPY	ETF	220.583	221.06	220.31	220.33	28718995.0
2016-11-30 16:00:00	SPY	ETF	220.34	220.54	220.26	220.39	19938998.0
2016-11-30 17:00:00	SPY	ETF	220.38	220.43	220.33	220.42	253875.0
2016-11-30 18:00:00	SPY	ETF	220.42	220.5	220.21	220.48	903641.0
2016-11-30 19:00:00	SPY	ETF	220.42	220.44	220.31	220.35	39329.0
2016-11-30 04:00:00	QQQ	ETF	119.04	119.04	119.03	119.03	1387.0
2016-11-30 05:00:00	QQQ	ETF	119.01	119.05	119.0	119.0	2719.0
2016-11-30 06:00:00	QQQ	ETF	119.07	119.07	119.07	119.07	250.0
2016-11-30 07:00:00	QQQ	ETF	119.08	119.15	119.06	119.06	91106.0
2016-11-30 08:00:00	QQQ	ETF	119.08	119.09	118.94	118.99	87252.0
2016-11-30 09:00:00	QQQ	ETF	119.0	119.17	118.68	118.75	3535247.0
2016-11-30 10:00:00	QQQ	ETF	118.75	118.78	118.12	118.295	3982688.0
2016-11-30 11:00:00	QQQ	ETF	118.29	118.52	117.87	117.9	3650585.0
2016-11-30 12:00:00	QQQ	ETF	117.89	118.01	117.71	118.01	2445545.0
2016-11-30 13:00:00	QQQ	ETF	118.0	118.05	117.9	117.94	1870933.0
2016-11-30 14:00:00	QQQ	ETF	117.94	117.95	117.5	117.6064	3049431.0
2016-11-30 15:00:00	QQQ	ETF	117.6	117.85	117.46	117.46	5983549.0
2016-11-30 16:00:00	QQQ	ETF	117.47	118.9442	117.4283	117.58	1932850.0
2016-11-30 17:00:00	QQQ	ETF	117.58	117.66	117.5	117.64	3645.0
2016-11-30 18:00:00	QQQ	ETF	117.63	117.69	117.5	117.67	888577.0
2016-11-30 19:00:00	QQQ	ETF	117.65	117.66	117.55	117.61	12130.0
2016-11-30 04:00:00	IWM	ETF	132.42	132.42	132.42	132.42	321.0
2016-11-30 06:00:00	IWM	ETF	132.37	132.37	132.37	132.37	3000.0
2016-11-30 07:00:00	IWM	ETF	132.46	132.59	132.45	132.49	152772.0
2016-11-30 08:00:00	IWM	ETF	132.47	132.59	132.41	132.59	167359.0
2016-11-30 09:00:00	IWM	ETF	132.6	133.09	132.24	132.51	3763033.0
2016-11-30 10:00:00	IWM	ETF	132.5	133.07	132.35	132.37	4587775.0
2016-11-30 11:00:00	IWM	ETF	132.38	132.71	132.105	132.19	3256626.0
2016-11-30 12:00:00	IWM	ETF	132.18	132.25	131.81	131.91	2326645.0
2016-11-30 13:00:00	IWM	ETF	131.91	132.03	131.76	132.0	2592286.0
2016-11-30 14:00:00	IWM	ETF	131.99	132.085	131.5	131.79	5014014.0
2016-11-30 15:00:00	IWM	ETF	131.79	132.02	131.6	131.61	5739428.0
2016-11-30 16:00:00	IWM	ETF	131.61	131.87	131.55	131.84	3027129.0
2016-11-30 17:00:00	IWM	ETF	131.85	131.88	131.81	131.82	15242.0
2016-11-30 18:00:00	IWM	ETF	131.85	131.85	131.61	131.61	200645.0
2016-11-30 19:00:00	IWM	ETF	131.8	131.8	131.8	131.8	100.0
2016-11-30 07:00:00	DIA	ETF	191.6	191.61	191.6	191.61	634.0
2016-11-30 08:00:00	DIA	ETF	191.65	191.74	191.54	191.73	12643.0
2016-11-30 09:00:00	DIA	ETF	191.74	192.25	191.74	192.01	749756.0

> showing 50 of 9,023 rows — these rows as CSV

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