PREVIEW / etf_daily / 2013-06-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-26.parquet
  size:    41 KB
  rows:    1,004

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-06-26	SPY	ETF	159.87	160.5	159.25	160.14	134848000.0
2013-06-26	QQQ	ETF	70.82	71.0	70.59	70.87	23746655.0
2013-06-26	IWM	ETF	96.52	96.63	95.65	96.07	33752300.0
2013-06-26	DIA	ETF	148.3	149.07	147.97	148.79	6326000.0
2013-06-26	GLD	ETF	119.88	119.9	118.06	118.28	24748800.0
2013-06-26	TLT	ETF	109.0	109.05	108.04	108.58	13582200.0
2013-06-26	AADR	ETF	32.0	32.3	32.0	32.3	600.0
2013-06-26	AAXJ	ETF	53.73	54.2	53.64	54.1	658300.0
2013-06-26	ACTV	ETF	6.81	7.11	6.73	7.0	480489.0
2013-06-26	ACWI	ETF	50.16	50.38	50.02	50.29	1398400.0
2013-06-26	ACWV	ETF	59.85	59.88	59.47	59.87	115300.0
2013-06-26	ACWX	ETF	40.91	40.95	40.72	40.89	281467.0
2013-06-26	ADRE	ETF	33.37	33.55	33.25	33.44	105635.0
2013-06-26	AFK	ETF	26.47	26.74	26.29	26.66	134338.0
2013-06-26	AGEM	ETF	19.9633	20.1428	19.9633	20.1428	4479.0
2013-06-26	AGG	ETF	106.72	106.88	106.55	106.75	995800.0
2013-06-26	AGQ	ETF	63.4	63.72	61.28	61.28	892750.0
2013-06-26	AGZ	ETF	110.69	110.7	110.4	110.47	10738.0
2013-06-26	AIA	ETF	41.2	41.47	41.1201	41.449	103692.0
2013-06-26	AIQ	ETF	16.16	16.16	15.77	15.97	35259.0
2013-06-26	AIVI	ETF	40.11	40.11	39.73	39.87	15600.0
2013-06-26	AMJ	ETF	45.08	46.75	44.86	46.75	1056655.0
2013-06-26	AMLP	ETF	87.5	88.35	87.1	88.35	679680.0
2013-06-26	ANGL	ETF	26.31	26.31	26.31	26.31	700.0
2013-06-26	AOA	ETF	39.7	39.7	39.47	39.64	88400.0
2013-06-26	AOK	ETF	30.59	30.642	30.5731	30.611	28951.0
2013-06-26	AOM	ETF	32.19	32.27	32.163	32.18	47609.0
2013-06-26	AOR	ETF	35.24	35.31	35.2	35.26	18270.0
2013-06-26	ARB	ETF	46.6	46.6	45.27	45.79	2532915.0
2013-06-26	ARGT	ETF	15.81	15.81	15.81	15.81	500.0
2013-06-26	ASEA	ETF	16.52	16.65	16.52	16.63	824700.0
2013-06-26	ATMP	ETF	25.55	25.58	25.55	25.58	1900.0
2013-06-26	AVIV	ETF	24.6	25.1899	24.445	24.8	304898.0
2013-06-26	AWAY	ETF	32.67	32.92	32.03	32.38	964358.0
2013-06-26	BAB	ETF	28.14	28.24	27.96	28.04	521073.0
2013-06-26	BAL	ETF	54.3301	54.42	53.81	53.91	62165.0
2013-06-26	BALT	ETF	3.45	3.53	3.41	3.53	76353.0
2013-06-26	BBH	ETF	67.02	68.75	66.65	68.39	136000.0
2013-06-26	BCM	ETF	38.604	38.68	38.604	38.68	1058.0
2013-06-26	BFOR	ETF	6.135	6.1625	6.1225	6.145	350400.0
2013-06-26	BIB	ETF	21.75	22.7425	21.7398	22.5575	134584.0
2013-06-26	BICK	ETF	20.64	20.6599	20.48	20.6599	1300.0
2013-06-26	BIL	ETF	91.6	91.62	91.6	91.62	473600.0
2013-06-26	BIS	ETF	1610.4	1610.4	1531.6	1538.0	562.5
2013-06-26	BIV	ETF	83.18	83.28	82.95	83.18	286200.0
2013-06-26	BIZD	ETF	19.35	19.54	19.35	19.47	113500.0
2013-06-26	BJK	ETF	39.91	40.01	39.86	39.97	5300.0
2013-06-26	BKF	ETF	33.95	34.25	33.88	34.13	68570.0
2013-06-26	BKLN	ETF	24.67	24.75	24.65	24.65	3886800.0
2013-06-26	BLV	ETF	83.79	84.34	83.45	84.03	113000.0

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

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