PREVIEW / etf_daily / 2011-06-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-29.parquet
  size:    36 KB
  rows:    857

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
2011-06-29	SPY	ETF	130.2	130.93	129.63	130.72	244295500.0
2011-06-29	QQQ	ETF	56.23	56.41	55.9	56.3	65417186.0
2011-06-29	IWM	ETF	82.1	82.4	81.44	82.2	68230200.0
2011-06-29	DIA	ETF	122.0	122.61	121.49	122.45	5712400.0
2011-06-29	GLD	ETF	146.77	147.42	146.44	147.18	12624600.0
2011-06-29	TLT	ETF	94.95	95.2	94.02	94.25	11084900.0
2011-06-29	AADR	ETF	31.32	31.4	31.32	31.4	1200.0
2011-06-29	AAXJ	ETF	60.81	61.2	60.61	61.05	331000.0
2011-06-29	ACTV	ETF	17.08	17.55	17.0	17.11	164647.0
2011-06-29	ACWI	ETF	47.52	47.72	47.15	47.69	570000.0
2011-06-29	ACWX	ETF	44.07	44.41	43.9	44.35	61515.0
2011-06-29	ADRE	ETF	45.7	46.204	45.68	46.09	39057.0
2011-06-29	AFK	ETF	31.42	31.84	31.42	31.75	14770.0
2011-06-29	AGEM	ETF	25.99	26.29	25.99	26.1901	63995.0
2011-06-29	AGG	ETF	107.03	107.09	106.68	106.69	2533800.0
2011-06-29	AGQ	ETF	320.42	333.82	317.76	332.82	686750.0
2011-06-29	AGZ	ETF	110.7	110.7	110.44	110.51	46439.0
2011-06-29	AIA	ETF	45.95	46.2271	45.72	46.0709	8249.0
2011-06-29	AIQ	ETF	19.25	19.3	18.8	18.85	12045.0
2011-06-29	AIS	ETF	2.19	2.22	2.07	2.19	1281971.0
2011-06-29	AIVI	ETF	46.16	46.49	45.94	46.47	28700.0
2011-06-29	AMJ	ETF	36.85	37.14	36.69	37.06	920361.0
2011-06-29	AMLP	ETF	79.75	80.25	79.5	80.2	201080.0
2011-06-29	AOA	ETF	35.31	35.58	35.31	35.58	16800.0
2011-06-29	AOK	ETF	29.31	29.33	29.29	29.32	24664.0
2011-06-29	AOM	ETF	30.46	30.49	30.41	30.49	14505.0
2011-06-29	AOR	ETF	32.32	32.4	32.23	32.38	111031.0
2011-06-29	ARB	ETF	40.56	40.56	39.6	39.96	74158.0
2011-06-29	ARGT	ETF	29.64	29.66	29.54	29.54	6350.0
2011-06-29	ASEA	ETF	16.29	16.34	16.29	16.32	1100.0
2011-06-29	AWAY	ETF	36.1	42.3	34.92	40.21	9416231.0
2011-06-29	BAB	ETF	26.25	26.3199	26.07	26.11	134049.0
2011-06-29	BAL	ETF	76.5	76.6279	75.32	75.63	46420.0
2011-06-29	BALT	ETF	6.01	6.01	5.68	5.82	163608.0
2011-06-29	BBH	ETF	36.0533	36.0533	35.7467	35.7933	58200.0
2011-06-29	BCM	ETF	46.51	46.51	46.51	46.51	1052.0
2011-06-29	BIB	ETF	9.5	9.585	9.449	9.5195	14808.0
2011-06-29	BICK	ETF	31.22	31.69	31.22	31.6041	8072.0
2011-06-29	BIL	ETF	91.7	91.72	91.7	91.72	1148950.0
2011-06-29	BIS	ETF	6065.6	6065.6	6001.6	6044.8	7.75
2011-06-29	BITS	ETF	21.52	21.52	21.24	21.44	502.0
2011-06-29	BIV	ETF	84.36	84.47	84.03	84.24	183300.0
2011-06-29	BJK	ETF	33.86	34.22	33.8	34.13	22800.0
2011-06-29	BKF	ETF	47.15	47.48	46.96	47.41	159546.0
2011-06-29	BKLN	ETF	24.74	24.75	24.7	24.75	92700.0
2011-06-29	BLNG	ETF	47.39	47.62	47.39	47.62	1149.0
2011-06-29	BLV	ETF	80.36	80.54	79.93	80.03	31300.0
2011-06-29	BMVP	ETF	15.47	15.596	15.44	15.5614	1622.0
2011-06-29	BND	ETF	81.45	81.5	81.27	81.33	1438900.0
2011-06-29	BNO	ETF	36.555	37.56	36.555	37.475	99600.0

> showing 50 of 857 rows — these rows as CSV

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