PREVIEW / etf_daily / 2013-11-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-05.parquet
  size:    42 KB
  rows:    1,041

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2013-11-05	SPY	ETF	176.14	176.75	175.57	176.27	85825000.0
2013-11-05	QQQ	ETF	82.59	83.22	82.37	83.02	27975601.0
2013-11-05	IWM	ETF	109.55	109.93	108.86	109.59	26643500.0
2013-11-05	DIA	ETF	155.28	156.18	154.87	155.89	5442800.0
2013-11-05	GLD	ETF	126.71	126.86	126.0	126.56	4941200.0
2013-11-05	TLT	ETF	105.79	105.83	104.99	105.02	8753400.0
2013-11-05	AAXJ	ETF	59.98	59.98	59.58	59.77	1851100.0
2013-11-05	ACTV	ETF	14.46	14.48	14.45	14.48	1144048.0
2013-11-05	ACWI	ETF	55.92	56.06	55.7	55.94	1185800.0
2013-11-05	ACWV	ETF	64.18	64.18	63.8	64.02	82800.0
2013-11-05	ACWX	ETF	45.86	46.02	45.744	45.92	278775.0
2013-11-05	ADRE	ETF	38.21	38.21	37.88	37.9215	4667.0
2013-11-05	AFK	ETF	31.55	31.55	31.27	31.3	27124.0
2013-11-05	AGG	ETF	107.4	107.43	107.22	107.24	873100.0
2013-11-05	AGQ	ETF	79.2	79.64	78.72	79.48	155150.0
2013-11-05	AGZ	ETF	111.618	111.69	111.3301	111.51	5130.0
2013-11-05	AIA	ETF	47.77	47.89	47.64	47.71	35672.0
2013-11-05	AIQ	ETF	23.42	25.74	23.42	25.27	58157.0
2013-11-05	AIVI	ETF	46.99	47.08	46.81	46.99	16800.0
2013-11-05	ALTL	ETF	31.576	31.576	31.576	31.576	840.0
2013-11-05	AMJ	ETF	45.94	46.06	45.7	45.94	644978.0
2013-11-05	AMLP	ETF	89.15	89.4	88.9	89.25	425020.0
2013-11-05	ANGL	ETF	27.01	27.01	26.79	26.79	300.0
2013-11-05	AOA	ETF	43.28	43.36	43.14	43.28	28600.0
2013-11-05	AOK	ETF	31.77	31.77	31.681	31.71	14135.0
2013-11-05	AOM	ETF	33.89	33.91	33.8199	33.88	30404.0
2013-11-05	AOR	ETF	37.72	37.77	37.64	37.72	14277.0
2013-11-05	ARGT	ETF	20.46	20.78	20.39	20.72	14700.0
2013-11-05	ASEA	ETF	16.9	16.92	16.82	16.82	4900.0
2013-11-05	ATMP	ETF	26.62	26.84	26.62	26.84	121800.0
2013-11-05	AVIV	ETF	25.97	25.97	25.13	25.16	60942.0
2013-11-05	AWAY	ETF	29.41	29.79	29.05	29.72	987074.0
2013-11-05	BAB	ETF	27.66	27.71	27.6094	27.62	102156.0
2013-11-05	BAL	ETF	48.28	48.51	47.97	48.3699	28886.0
2013-11-05	BALT	ETF	5.05	5.3	5.04	5.19	1341531.0
2013-11-05	BBH	ETF	82.07	82.35	81.17	81.99	74900.0
2013-11-05	BCM	ETF	39.22	39.22	39.22	39.22	249.0
2013-11-05	BFOR	ETF	7.115	7.1225	7.055	7.1075	195200.0
2013-11-05	BIB	ETF	31.25	31.7682	30.957	31.7425	147140.0
2013-11-05	BICK	ETF	24.69	24.69	24.51	24.51	1205.0
2013-11-05	BIL	ETF	91.58	91.58	91.56	91.56	85150.0
2013-11-05	BIS	ETF	1032.0	1032.0	1010.76	1012.56	131.0
2013-11-05	BIV	ETF	83.82	83.83	83.55	83.63	445000.0
2013-11-05	BIZD	ETF	20.71	20.71	20.57	20.64	1900.0
2013-11-05	BJK	ETF	49.91	49.91	49.56	49.64	17400.0
2013-11-05	BKF	ETF	38.28	38.3672	38.13	38.13	58908.0
2013-11-05	BKLN	ETF	24.84	24.87	24.83	24.86	2514800.0
2013-11-05	BLV	ETF	83.21	83.21	82.75	82.8	84700.0
2013-11-05	BMVP	ETF	21.55	21.63	21.49	21.63	4536.0
2013-11-05	BND	ETF	81.0	81.0	80.81	80.81	2158400.0

> showing 50 of 1,041 rows — these rows as CSV

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