PREVIEW / etf_1hour / 2016-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-29.parquet
  size:    255 KB
  rows:    8,133

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-07-29 04:00:00	SPY	ETF	216.42	216.72	216.37	216.55	17267.0
2016-07-29 05:00:00	SPY	ETF	216.53	216.63	216.41	216.6	6777.0
2016-07-29 06:00:00	SPY	ETF	216.6	216.7	216.46	216.53	64961.0
2016-07-29 07:00:00	SPY	ETF	216.57	216.6	216.46	216.57	125985.0
2016-07-29 08:00:00	SPY	ETF	216.58	216.92	216.2	216.5	1001927.0
2016-07-29 09:00:00	SPY	ETF	216.5	216.86	216.36	216.48	7994617.0
2016-07-29 10:00:00	SPY	ETF	216.49	217.09	216.13	216.95	12333677.0
2016-07-29 11:00:00	SPY	ETF	216.9489	217.44	216.945	217.345	9069889.0
2016-07-29 12:00:00	SPY	ETF	217.35	217.54	217.03	217.11	6434225.0
2016-07-29 13:00:00	SPY	ETF	217.12	217.34	217.0293	217.3	4328259.0
2016-07-29 14:00:00	SPY	ETF	217.3	217.41	217.02	217.19	6872481.0
2016-07-29 15:00:00	SPY	ETF	217.19	217.48	216.94	217.14	19584753.0
2016-07-29 16:00:00	SPY	ETF	217.12	217.5	217.11	217.48	9078652.0
2016-07-29 17:00:00	SPY	ETF	217.48	217.5	217.12	217.42	257805.0
2016-07-29 18:00:00	SPY	ETF	217.42	217.5	217.42	217.45	45274.0
2016-07-29 19:00:00	SPY	ETF	217.44	217.55	217.41	217.43	19924.0
2016-07-29 04:00:00	QQQ	ETF	115.04	115.15	115.03	115.04	12597.0
2016-07-29 05:00:00	QQQ	ETF	115.06	115.06	115.06	115.06	100.0
2016-07-29 06:00:00	QQQ	ETF	115.1	115.1	115.1	115.1	200.0
2016-07-29 07:00:00	QQQ	ETF	115.12	115.19	115.09	115.15	40879.0
2016-07-29 08:00:00	QQQ	ETF	115.12	115.26	115.12	115.23	182432.0
2016-07-29 09:00:00	QQQ	ETF	115.23	115.4	115.08	115.1	2688164.0
2016-07-29 10:00:00	QQQ	ETF	115.1	115.36	114.87	115.3	2865797.0
2016-07-29 11:00:00	QQQ	ETF	115.31	115.52	115.3	115.45	2178680.0
2016-07-29 12:00:00	QQQ	ETF	115.44	115.54	115.22	115.25	1483104.0
2016-07-29 13:00:00	QQQ	ETF	115.26	115.38	115.225	115.331	1261083.0
2016-07-29 14:00:00	QQQ	ETF	115.331	115.35	115.12	115.23	1804098.0
2016-07-29 15:00:00	QQQ	ETF	115.22	115.4	115.06	115.24	5959711.0
2016-07-29 16:00:00	QQQ	ETF	115.24	115.39	115.23	115.34	910288.0
2016-07-29 17:00:00	QQQ	ETF	115.39	115.4	115.23	115.23	268295.0
2016-07-29 18:00:00	QQQ	ETF	115.3	115.31	115.27	115.31	1445.0
2016-07-29 19:00:00	QQQ	ETF	115.3	115.32	115.3	115.32	1036.0
2016-07-29 07:00:00	IWM	ETF	120.65	120.66	120.64	120.64	27307.0
2016-07-29 08:00:00	IWM	ETF	120.67	120.69	120.52	120.63	77428.0
2016-07-29 09:00:00	IWM	ETF	120.69	120.949	120.18	120.3399	2582368.0
2016-07-29 10:00:00	IWM	ETF	120.32	120.87	120.05	120.73	5243574.0
2016-07-29 11:00:00	IWM	ETF	120.72	121.58	120.72	121.49	3883656.0
2016-07-29 12:00:00	IWM	ETF	121.5	121.76	120.825	120.84	4496428.0
2016-07-29 13:00:00	IWM	ETF	120.8301	121.22	120.745	121.2	1538711.0
2016-07-29 14:00:00	IWM	ETF	121.19	121.285	121.04	121.23	1135736.0
2016-07-29 15:00:00	IWM	ETF	121.23	121.28	121.06	121.09	5001418.0
2016-07-29 16:00:00	IWM	ETF	121.1	121.45	121.06	121.4	2639399.0
2016-07-29 17:00:00	IWM	ETF	121.43	121.47	121.07	121.4	74276.0
2016-07-29 18:00:00	IWM	ETF	121.41	121.41	121.37	121.37	1204.0
2016-07-29 19:00:00	IWM	ETF	121.4	121.4	121.37	121.37	4094.0
2016-07-29 05:00:00	DIA	ETF	184.0	184.0	184.0	184.0	600.0
2016-07-29 08:00:00	DIA	ETF	184.19	184.19	183.66	183.83	11482.0
2016-07-29 09:00:00	DIA	ETF	183.9	184.19	183.74	183.84	288073.0
2016-07-29 10:00:00	DIA	ETF	183.82	184.2	183.54	184.059	658912.0
2016-07-29 11:00:00	DIA	ETF	184.06	184.44	184.06	184.36	410833.0

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

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