PREVIEW / etf_1hour / 2013-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-07.parquet
  size:    198 KB
  rows:    6,112

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
2013-02-07 04:00:00	SPY	ETF	150.93	151.06	150.93	151.06	3790.0
2013-02-07 05:00:00	SPY	ETF	151.22	151.38	151.22	151.36	43852.0
2013-02-07 06:00:00	SPY	ETF	151.37	151.47	151.26	151.27	68298.0
2013-02-07 07:00:00	SPY	ETF	151.27	151.38	151.12	151.17	184668.0
2013-02-07 08:00:00	SPY	ETF	151.18	151.4	150.99	151.23	1928746.0
2013-02-07 09:00:00	SPY	ETF	151.22	151.45	150.92	151.03	11639145.0
2013-02-07 10:00:00	SPY	ETF	151.03	151.09	149.92	150.27	32389352.0
2013-02-07 11:00:00	SPY	ETF	150.28	150.37	149.86	150.05	18699190.0
2013-02-07 12:00:00	SPY	ETF	150.05	151.2591	150.02	150.39	19280336.0
2013-02-07 13:00:00	SPY	ETF	150.4	150.77	150.29	150.75	10800598.0
2013-02-07 14:00:00	SPY	ETF	150.75	150.89	150.48	150.8	13926379.0
2013-02-07 15:00:00	SPY	ETF	150.8	150.99	150.62	150.94	29347929.0
2013-02-07 16:00:00	SPY	ETF	150.97	151.06	150.7	150.99	19990552.0
2013-02-07 17:00:00	SPY	ETF	150.99	150.99	150.86	150.9	108196.0
2013-02-07 18:00:00	SPY	ETF	150.9	150.9	150.82	150.88	82604.0
2013-02-07 19:00:00	SPY	ETF	150.86	151.0	150.85	150.93	31360.0
2013-02-07 04:00:00	QQQ	ETF	67.16	67.2	67.12	67.2	16600.0
2013-02-07 07:00:00	QQQ	ETF	67.23	67.24	67.15	67.16	78400.0
2013-02-07 08:00:00	QQQ	ETF	67.17	67.39	67.12	67.35	773378.0
2013-02-07 09:00:00	QQQ	ETF	67.36	67.42	67.13	67.22	3319664.0
2013-02-07 10:00:00	QQQ	ETF	67.23	67.25	66.56	66.7	9972219.0
2013-02-07 11:00:00	QQQ	ETF	66.71	66.8301	66.63	66.7	3835703.0
2013-02-07 12:00:00	QQQ	ETF	66.7	67.01	66.69	66.949	2552483.0
2013-02-07 13:00:00	QQQ	ETF	66.94	67.03	66.83	67.01	2428637.0
2013-02-07 14:00:00	QQQ	ETF	67.01	67.09	66.82	67.0	3336014.0
2013-02-07 15:00:00	QQQ	ETF	67.0	67.32	66.87	67.29	7436461.0
2013-02-07 16:00:00	QQQ	ETF	67.3	67.38	66.726	67.38	4681905.0
2013-02-07 17:00:00	QQQ	ETF	67.35	67.35	67.26	67.26	13716.0
2013-02-07 18:00:00	QQQ	ETF	67.27	67.28	67.26	67.28	10529.0
2013-02-07 19:00:00	QQQ	ETF	67.25	67.29	67.25	67.26	5923.0
2013-02-07 07:00:00	IWM	ETF	90.47	90.52	90.47	90.52	7500.0
2013-02-07 08:00:00	IWM	ETF	90.39	90.52	90.35	90.4	1091354.0
2013-02-07 09:00:00	IWM	ETF	90.4	90.55	90.22	90.27	4217563.0
2013-02-07 10:00:00	IWM	ETF	90.28	90.33	89.55	89.77	6114203.0
2013-02-07 11:00:00	IWM	ETF	89.77	89.82	89.57	89.61	3303624.0
2013-02-07 12:00:00	IWM	ETF	89.61	90.07	89.6	89.91	2152048.0
2013-02-07 13:00:00	IWM	ETF	89.9	90.155	89.785	90.14	1999590.0
2013-02-07 14:00:00	IWM	ETF	90.14	90.24	89.96	90.15	3020953.0
2013-02-07 15:00:00	IWM	ETF	90.15	90.2	90.0	90.13	5172983.0
2013-02-07 16:00:00	IWM	ETF	90.13	90.21	89.9573	90.19	802855.0
2013-02-07 17:00:00	IWM	ETF	90.17	90.17	90.16	90.16	1800.0
2013-02-07 18:00:00	IWM	ETF	90.11	90.11	90.11	90.11	4999.0
2013-02-07 19:00:00	IWM	ETF	90.12	90.13	90.12	90.13	2100.0
2013-02-07 08:00:00	DIA	ETF	139.64	139.71	139.48	139.62	8254.0
2013-02-07 09:00:00	DIA	ETF	139.63	139.73	139.14	139.27	556271.0
2013-02-07 10:00:00	DIA	ETF	139.27	139.291	138.42	138.68	2156418.0
2013-02-07 11:00:00	DIA	ETF	138.69	138.75	138.32	138.42	851802.0
2013-02-07 12:00:00	DIA	ETF	138.438	138.82	138.39	138.762	486779.0
2013-02-07 13:00:00	DIA	ETF	138.77	139.15	138.7	139.14	395245.0
2013-02-07 14:00:00	DIA	ETF	139.14	139.28	138.98	139.23	797063.0

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

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