PREVIEW / etf_1hour / 2016-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-16.parquet
  size:    270 KB
  rows:    8,678

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-16 04:00:00	SPY	ETF	218.27	218.28	217.98	218.07	19662.0
2016-11-16 05:00:00	SPY	ETF	218.01	218.2	218.0	218.2	14867.0
2016-11-16 06:00:00	SPY	ETF	218.18	218.18	217.76	217.82	45436.0
2016-11-16 07:00:00	SPY	ETF	217.85	217.85	217.43	217.73	715059.0
2016-11-16 08:00:00	SPY	ETF	217.73	217.82	217.48	217.55	604715.0
2016-11-16 09:00:00	SPY	ETF	217.55	218.04	217.38	217.57	8131279.0
2016-11-16 10:00:00	SPY	ETF	217.58	218.14	217.51	217.95	12935918.0
2016-11-16 11:00:00	SPY	ETF	217.95	217.99	217.55	217.69	7779649.0
2016-11-16 12:00:00	SPY	ETF	217.69	217.78	217.42	217.68	5877365.0
2016-11-16 13:00:00	SPY	ETF	217.6886	217.77	217.44	217.71	4692556.0
2016-11-16 14:00:00	SPY	ETF	217.715	217.96	217.67	217.87	6833332.0
2016-11-16 15:00:00	SPY	ETF	217.875	218.08	217.7	217.93	11637439.0
2016-11-16 16:00:00	SPY	ETF	217.93	217.96	217.72	217.75	4026968.0
2016-11-16 17:00:00	SPY	ETF	217.75	217.82	217.7	217.79	126728.0
2016-11-16 18:00:00	SPY	ETF	217.78	217.87	217.73	217.78	144041.0
2016-11-16 19:00:00	SPY	ETF	217.79	217.85	217.76	217.81	24791.0
2016-11-16 04:00:00	QQQ	ETF	116.22	116.22	116.07	116.09	3934.0
2016-11-16 05:00:00	QQQ	ETF	116.11	116.14	116.11	116.14	1300.0
2016-11-16 06:00:00	QQQ	ETF	116.2	116.2	115.93	115.93	5909.0
2016-11-16 07:00:00	QQQ	ETF	115.94	115.97	115.79	115.93	202908.0
2016-11-16 08:00:00	QQQ	ETF	115.93	115.99	115.68	115.7	287088.0
2016-11-16 09:00:00	QQQ	ETF	115.71	116.6	115.59	116.06	3218416.0
2016-11-16 10:00:00	QQQ	ETF	116.06	116.92	116.06	116.77	3115529.0
2016-11-16 11:00:00	QQQ	ETF	116.77	116.9932	116.48	116.8057	1914272.0
2016-11-16 12:00:00	QQQ	ETF	116.8	116.98	116.65	116.84	1201611.0
2016-11-16 13:00:00	QQQ	ETF	116.84	116.91	116.62	116.819	1121289.0
2016-11-16 14:00:00	QQQ	ETF	116.81	116.93	116.7	116.89	949633.0
2016-11-16 15:00:00	QQQ	ETF	116.88	116.99	116.79	116.92	2513753.0
2016-11-16 16:00:00	QQQ	ETF	116.91	116.9269	116.3481	116.75	1068347.0
2016-11-16 17:00:00	QQQ	ETF	116.75	116.75	116.69	116.69	200.0
2016-11-16 18:00:00	QQQ	ETF	116.71	116.73	116.67	116.72	7764.0
2016-11-16 19:00:00	QQQ	ETF	116.71	116.75	116.71	116.74	11254.0
2016-11-16 04:00:00	IWM	ETF	129.39	129.39	129.22	129.22	300.0
2016-11-16 05:00:00	IWM	ETF	129.19	129.21	129.19	129.2	3990.0
2016-11-16 06:00:00	IWM	ETF	129.19	129.19	128.99	129.0	12117.0
2016-11-16 07:00:00	IWM	ETF	129.03	129.06	128.82	128.99	218986.0
2016-11-16 08:00:00	IWM	ETF	129.04	129.31	128.9	129.29	205715.0
2016-11-16 09:00:00	IWM	ETF	129.27	129.62	128.91	129.14	4701116.0
2016-11-16 10:00:00	IWM	ETF	129.13	130.0	129.03	129.55	4658924.0
2016-11-16 11:00:00	IWM	ETF	129.55	129.91	129.25	129.6	3986818.0
2016-11-16 12:00:00	IWM	ETF	129.59	129.73	129.36	129.55	2921203.0
2016-11-16 13:00:00	IWM	ETF	129.55	129.62	129.28	129.51	2089149.0
2016-11-16 14:00:00	IWM	ETF	129.51	129.65	129.46	129.58	2751660.0
2016-11-16 15:00:00	IWM	ETF	129.58	129.72	129.51	129.58	5150372.0
2016-11-16 16:00:00	IWM	ETF	129.59	129.69	129.275	129.65	4846179.0
2016-11-16 17:00:00	IWM	ETF	129.62	129.67	129.6	129.6	32373.0
2016-11-16 18:00:00	IWM	ETF	129.56	129.59	129.5	129.57	1986.0
2016-11-16 19:00:00	IWM	ETF	129.58	129.65	129.5	129.6	99432.0
2016-11-16 04:00:00	DIA	ETF	189.19	189.19	189.19	189.19	100.0
2016-11-16 06:00:00	DIA	ETF	189.05	189.05	189.05	189.05	200.0

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

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