PREVIEW / etf_1hour / 2016-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-28.parquet
  size:    272 KB
  rows:    8,783

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-28 04:00:00	SPY	ETF	220.76	220.95	220.72	220.82	30845.0
2016-11-28 05:00:00	SPY	ETF	221.12	221.17	220.97	220.97	21147.0
2016-11-28 06:00:00	SPY	ETF	221.03	221.06	220.84	220.99	84452.0
2016-11-28 07:00:00	SPY	ETF	220.97	221.26	220.92	221.2	250675.0
2016-11-28 08:00:00	SPY	ETF	221.19	221.24	220.61	221.1	395728.0
2016-11-28 09:00:00	SPY	ETF	221.11	221.34	221.01	221.2	6777665.0
2016-11-28 10:00:00	SPY	ETF	221.2	221.48	220.71	220.715	8359557.0
2016-11-28 11:00:00	SPY	ETF	220.71	221.0	220.66	220.96	7755772.0
2016-11-28 12:00:00	SPY	ETF	220.955	221.38	220.95	221.2	6474454.0
2016-11-28 13:00:00	SPY	ETF	221.2065	221.2065	221.03	221.0854	3354096.0
2016-11-28 14:00:00	SPY	ETF	221.085	221.22	220.87	220.94	6917558.0
2016-11-28 15:00:00	SPY	ETF	220.94	220.96	220.36	220.54	23120927.0
2016-11-28 16:00:00	SPY	ETF	220.52	220.71	220.48	220.53	11037045.0
2016-11-28 17:00:00	SPY	ETF	220.52	220.56	220.48	220.52	174999.0
2016-11-28 18:00:00	SPY	ETF	220.52	220.52	220.41	220.46	29148.0
2016-11-28 19:00:00	SPY	ETF	220.5	220.5	220.45	220.5	12670.0
2016-11-28 04:00:00	QQQ	ETF	118.39	118.43	118.39	118.43	1581.0
2016-11-28 05:00:00	QQQ	ETF	118.61	118.68	118.61	118.68	3661.0
2016-11-28 06:00:00	QQQ	ETF	118.57	118.57	118.5	118.5	1185.0
2016-11-28 07:00:00	QQQ	ETF	118.55	118.67	118.51	118.66	8249.0
2016-11-28 08:00:00	QQQ	ETF	118.65	118.66	118.57	118.66	31932.0
2016-11-28 09:00:00	QQQ	ETF	118.65	118.86	118.4101	118.84	1924027.0
2016-11-28 10:00:00	QQQ	ETF	118.83	119.08	118.67	118.69	1845948.0
2016-11-28 11:00:00	QQQ	ETF	118.6818	118.91	118.62	118.87	1134975.0
2016-11-28 12:00:00	QQQ	ETF	118.87	119.04	118.8059	118.95	1117022.0
2016-11-28 13:00:00	QQQ	ETF	118.9595	118.9595	118.7938	118.83	732891.0
2016-11-28 14:00:00	QQQ	ETF	118.83	118.92	118.65	118.71	727809.0
2016-11-28 15:00:00	QQQ	ETF	118.72	118.76	118.46	118.54	2346160.0
2016-11-28 16:00:00	QQQ	ETF	118.54	118.65	118.51	118.56	390086.0
2016-11-28 17:00:00	QQQ	ETF	118.53	118.53	118.53	118.53	1200.0
2016-11-28 18:00:00	QQQ	ETF	118.59	118.59	118.53	118.54	1500.0
2016-11-28 19:00:00	QQQ	ETF	118.57	118.58	118.54	118.58	6399.0
2016-11-28 04:00:00	IWM	ETF	133.63	133.63	133.57	133.61	1676.0
2016-11-28 05:00:00	IWM	ETF	133.7	133.81	133.65	133.65	6952.0
2016-11-28 06:00:00	IWM	ETF	133.65	133.66	133.56	133.59	21376.0
2016-11-28 07:00:00	IWM	ETF	133.65	133.94	133.63	133.91	41930.0
2016-11-28 08:00:00	IWM	ETF	133.92	133.97	133.84	133.93	90214.0
2016-11-28 09:00:00	IWM	ETF	133.93	134.0	133.4	133.44	3018187.0
2016-11-28 10:00:00	IWM	ETF	133.435	133.465	132.71	132.82	5037685.0
2016-11-28 11:00:00	IWM	ETF	132.82	133.13	132.54	132.89	4822967.0
2016-11-28 12:00:00	IWM	ETF	132.8911	133.16	132.89	132.91	2781767.0
2016-11-28 13:00:00	IWM	ETF	132.915	133.32	132.755	133.19	2058711.0
2016-11-28 14:00:00	IWM	ETF	133.19	133.21	132.71	132.77	1959047.0
2016-11-28 15:00:00	IWM	ETF	132.77	132.89	132.15	132.38	6025174.0
2016-11-28 16:00:00	IWM	ETF	132.38	132.54	132.28	132.5	1050739.0
2016-11-28 17:00:00	IWM	ETF	132.33	132.43	132.33	132.34	84289.0
2016-11-28 18:00:00	IWM	ETF	132.38	132.4	132.28	132.4	1346.0
2016-11-28 19:00:00	IWM	ETF	132.34	132.47	132.34	132.45	5519.0
2016-11-28 06:00:00	DIA	ETF	191.04	191.04	190.9	190.9	300.0
2016-11-28 07:00:00	DIA	ETF	190.96	190.99	190.96	190.99	300.0

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

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