PREVIEW / etf_1hour / 2016-11-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	218.0	218.15	217.87	217.96	14286.0
2016-11-17 05:00:00	SPY	ETF	217.96	218.11	217.84	218.07	24180.0
2016-11-17 06:00:00	SPY	ETF	218.11	218.13	217.98	217.98	18202.0
2016-11-17 07:00:00	SPY	ETF	217.97	218.15	217.9	217.9	105292.0
2016-11-17 08:00:00	SPY	ETF	217.91	217.99	217.71	217.94	541590.0
2016-11-17 09:00:00	SPY	ETF	217.93	218.65	217.91	218.5808	7802776.0
2016-11-17 10:00:00	SPY	ETF	218.6	218.62	218.1	218.25	9711235.0
2016-11-17 11:00:00	SPY	ETF	218.25	218.89	218.24	218.805	7384959.0
2016-11-17 12:00:00	SPY	ETF	218.8	219.06	218.74	218.8301	7210775.0
2016-11-17 13:00:00	SPY	ETF	218.83	218.98	218.7	218.7	8088080.0
2016-11-17 14:00:00	SPY	ETF	218.71	218.83	218.54	218.71	7014985.0
2016-11-17 15:00:00	SPY	ETF	218.71	218.98	218.65	218.95	13597123.0
2016-11-17 16:00:00	SPY	ETF	218.96	219.01	218.83	219.0	6394935.0
2016-11-17 17:00:00	SPY	ETF	218.95	219.05	218.95	218.95	292597.0
2016-11-17 18:00:00	SPY	ETF	218.94	219.05	218.86	218.88	118680.0
2016-11-17 19:00:00	SPY	ETF	218.88	218.95	218.75	218.82	208155.0
2016-11-17 04:00:00	QQQ	ETF	117.0	117.1	116.98	117.05	4115.0
2016-11-17 05:00:00	QQQ	ETF	117.01	117.06	117.01	117.06	800.0
2016-11-17 06:00:00	QQQ	ETF	117.07	117.07	117.0	117.05	2715.0
2016-11-17 07:00:00	QQQ	ETF	117.08	117.18	116.95	116.95	64564.0
2016-11-17 08:00:00	QQQ	ETF	116.95	117.13	116.69	116.88	125306.0
2016-11-17 09:00:00	QQQ	ETF	116.86	117.13	116.61	117.06	3495964.0
2016-11-17 10:00:00	QQQ	ETF	117.08	117.22	116.88	117.06	2653272.0
2016-11-17 11:00:00	QQQ	ETF	117.07	117.53	117.0399	117.52	1939610.0
2016-11-17 12:00:00	QQQ	ETF	117.53	117.74	117.46	117.665	1629201.0
2016-11-17 13:00:00	QQQ	ETF	117.66	117.76	117.59	117.59	1438826.0
2016-11-17 14:00:00	QQQ	ETF	117.58	117.625	117.37	117.55	1779839.0
2016-11-17 15:00:00	QQQ	ETF	117.55	117.78	117.51	117.77	3835642.0
2016-11-17 16:00:00	QQQ	ETF	117.76	117.88	117.65	117.87	627150.0
2016-11-17 17:00:00	QQQ	ETF	117.88	117.9	117.83	117.87	12019.0
2016-11-17 18:00:00	QQQ	ETF	117.85	117.91	117.85	117.87	12151.0
2016-11-17 19:00:00	QQQ	ETF	117.8	117.9	117.74	117.81	23774.0
2016-11-17 04:00:00	IWM	ETF	129.9	130.0	129.9	130.0	1724.0
2016-11-17 05:00:00	IWM	ETF	129.98	130.03	129.98	130.03	1118.0
2016-11-17 06:00:00	IWM	ETF	130.06	130.06	129.87	129.87	500.0
2016-11-17 07:00:00	IWM	ETF	129.96	130.01	129.87	129.92	19790.0
2016-11-17 08:00:00	IWM	ETF	129.98	130.02	129.8	130.02	172409.0
2016-11-17 09:00:00	IWM	ETF	130.04	130.8	129.82	130.63	4287135.0
2016-11-17 10:00:00	IWM	ETF	130.64	130.74	129.75	130.05	6130534.0
2016-11-17 11:00:00	IWM	ETF	130.1	130.77	129.99	130.62	5057916.0
2016-11-17 12:00:00	IWM	ETF	130.62	130.83	130.44	130.45	3295550.0
2016-11-17 13:00:00	IWM	ETF	130.45	130.62	130.28	130.31	2588268.0
2016-11-17 14:00:00	IWM	ETF	130.3025	130.59	130.09	130.1978	3886696.0
2016-11-17 15:00:00	IWM	ETF	130.2	130.43	130.17	130.29	4644512.0
2016-11-17 16:00:00	IWM	ETF	130.3	130.43	130.26	130.43	1285852.0
2016-11-17 17:00:00	IWM	ETF	130.4	130.45	130.36	130.39	2343.0
2016-11-17 18:00:00	IWM	ETF	130.37	130.42	130.33	130.33	649.0
2016-11-17 19:00:00	IWM	ETF	130.33	130.45	130.33	130.45	4507.0
2016-11-17 07:00:00	DIA	ETF	188.97	189.02	188.96	189.0	3795.0
2016-11-17 08:00:00	DIA	ETF	188.82	188.93	188.82	188.93	526.0

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

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