PREVIEW / etf_1hour / 2014-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-29.parquet
  size:    211 KB
  rows:    6,771

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
2014-04-29 04:00:00	SPY	ETF	187.48	187.58	187.42	187.58	7314.0
2014-04-29 05:00:00	SPY	ETF	187.47	187.7	187.47	187.7	10368.0
2014-04-29 06:00:00	SPY	ETF	187.73	187.78	187.68	187.77	61952.0
2014-04-29 07:00:00	SPY	ETF	187.76	187.78	187.6	187.71	119038.0
2014-04-29 08:00:00	SPY	ETF	187.7	187.77	187.53	187.56	516489.0
2014-04-29 09:00:00	SPY	ETF	187.56	187.97	187.35	187.71	12829937.0
2014-04-29 10:00:00	SPY	ETF	187.7	187.86	187.08	187.54	18222594.0
2014-04-29 11:00:00	SPY	ETF	187.5301	187.845	187.34	187.73	8781538.0
2014-04-29 12:00:00	SPY	ETF	187.73	188.04	187.63	187.955	7994697.0
2014-04-29 13:00:00	SPY	ETF	187.96	187.985	187.66	187.94	7687296.0
2014-04-29 14:00:00	SPY	ETF	187.94	187.97	187.7701	187.815	4851444.0
2014-04-29 15:00:00	SPY	ETF	187.82	187.93	187.68	187.73	12705828.0
2014-04-29 16:00:00	SPY	ETF	187.73	187.8023	186.8954	187.56	7833815.0
2014-04-29 17:00:00	SPY	ETF	187.58	187.66	187.56	187.62	142935.0
2014-04-29 18:00:00	SPY	ETF	187.62	187.63	187.55	187.62	115650.0
2014-04-29 19:00:00	SPY	ETF	187.59	187.62	187.48	187.51	27810.0
2014-04-29 04:00:00	QQQ	ETF	86.75	86.87	86.75	86.87	399.0
2014-04-29 05:00:00	QQQ	ETF	86.87	86.95	86.87	86.95	5900.0
2014-04-29 06:00:00	QQQ	ETF	87.01	87.01	86.97	86.98	10300.0
2014-04-29 07:00:00	QQQ	ETF	86.98	87.02	86.87	86.92	59107.0
2014-04-29 08:00:00	QQQ	ETF	86.91	87.04	86.71	86.73	207027.0
2014-04-29 09:00:00	QQQ	ETF	86.74	87.04	86.505	86.77	8603066.0
2014-04-29 10:00:00	QQQ	ETF	86.7701	86.9	86.31	86.75	8632833.0
2014-04-29 11:00:00	QQQ	ETF	86.76	87.04	86.58	86.93	4319448.0
2014-04-29 12:00:00	QQQ	ETF	86.93	87.32	86.901	87.22	3122244.0
2014-04-29 13:00:00	QQQ	ETF	87.22	87.3	87.0599	87.27	2780380.0
2014-04-29 14:00:00	QQQ	ETF	87.27	87.3	87.18	87.24	2135978.0
2014-04-29 15:00:00	QQQ	ETF	87.24	87.297	87.1	87.16	5298495.0
2014-04-29 16:00:00	QQQ	ETF	87.15	87.17	86.676	86.98	1003983.0
2014-04-29 17:00:00	QQQ	ETF	87.0	87.06	86.97	87.0	22853.0
2014-04-29 18:00:00	QQQ	ETF	87.0	87.02	86.95	86.98	83726.0
2014-04-29 19:00:00	QQQ	ETF	86.99	86.99	86.94	86.94	26188.0
2014-04-29 07:00:00	IWM	ETF	111.42	111.47	111.38	111.42	48000.0
2014-04-29 08:00:00	IWM	ETF	111.42	111.55	111.35	111.41	170046.0
2014-04-29 09:00:00	IWM	ETF	111.4	111.97	111.29	111.73	5557254.0
2014-04-29 10:00:00	IWM	ETF	111.75	111.98	110.9	111.52	7353479.0
2014-04-29 11:00:00	IWM	ETF	111.53	111.73	111.19	111.47	3290058.0
2014-04-29 12:00:00	IWM	ETF	111.48	111.79	111.29	111.67	2423410.0
2014-04-29 13:00:00	IWM	ETF	111.66	111.71	111.3	111.63	1823146.0
2014-04-29 14:00:00	IWM	ETF	111.62	111.74	111.49	111.58	2013058.0
2014-04-29 15:00:00	IWM	ETF	111.57	111.71	111.14	111.26	6406096.0
2014-04-29 16:00:00	IWM	ETF	111.27	111.5368	110.9385	111.11	1776770.0
2014-04-29 17:00:00	IWM	ETF	111.11	111.2	111.07	111.2	44600.0
2014-04-29 18:00:00	IWM	ETF	111.1	111.29	110.9386	111.18	536243.0
2014-04-29 19:00:00	IWM	ETF	111.18	111.18	111.13	111.13	9282.0
2014-04-29 08:00:00	DIA	ETF	164.84	164.84	164.7	164.74	1426.0
2014-04-29 09:00:00	DIA	ETF	164.75	165.12	164.5899	164.99	853604.0
2014-04-29 10:00:00	DIA	ETF	164.99	165.11	164.49	164.91	891106.0
2014-04-29 11:00:00	DIA	ETF	164.92	165.12	164.73	165.06	732363.0
2014-04-29 12:00:00	DIA	ETF	165.06	165.27	164.95	165.1999	478586.0

> showing 50 of 6,771 rows — these rows as CSV

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