PREVIEW / etf_daily / 2011-06-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-30.parquet
  size:    36 KB
  rows:    860

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-30	SPY	ETF	131.14	132.18	130.71	131.97	223322700.0
2011-06-30	QQQ	ETF	56.5	57.09	56.47	57.05	50483923.0
2011-06-30	IWM	ETF	82.41	83.05	82.28	82.8	59915500.0
2011-06-30	DIA	ETF	122.9	124.02	122.76	123.83	4754500.0
2011-06-30	GLD	ETF	147.18	147.41	145.98	146.0	12657100.0
2011-06-30	TLT	ETF	94.23	94.31	93.14	94.1	11555600.0
2011-06-30	AADR	ETF	31.38	31.71	31.38	31.71	1500.0
2011-06-30	AAXJ	ETF	61.4	62.06	61.34	62.01	258000.0
2011-06-30	ACTV	ETF	17.1	18.28	16.71	17.6	170174.0
2011-06-30	ACWI	ETF	47.93	48.3	47.8	48.25	677500.0
2011-06-30	ACWX	ETF	44.61	45.06	44.56	45.04	87574.0
2011-06-30	ADRE	ETF	46.29	46.59	46.29	46.59	36833.0
2011-06-30	AFK	ETF	31.88	32.4389	31.8228	32.26	42473.0
2011-06-30	AGEM	ETF	26.31	26.57	26.31	26.5618	2070.0
2011-06-30	AGG	ETF	106.87	106.91	106.4	106.67	1295600.0
2011-06-30	AGQ	ETF	336.46	336.84	324.9	329.86	541350.0
2011-06-30	AGZ	ETF	110.63	110.74	110.3813	110.71	16801.0
2011-06-30	AIA	ETF	46.3	46.74	46.3	46.7066	29404.0
2011-06-30	AIQ	ETF	18.8	19.0	18.6	19.0	13687.0
2011-06-30	AIS	ETF	2.22	2.23	2.16	2.21	878726.0
2011-06-30	AIVI	ETF	46.74	47.26	46.74	47.22	40300.0
2011-06-30	AMJ	ETF	37.26	37.27	36.94	37.13	1209206.0
2011-06-30	AMLP	ETF	80.4	80.5	79.9	80.2	228800.0
2011-06-30	AOA	ETF	35.67	35.91	35.65	35.91	7300.0
2011-06-30	AOK	ETF	29.35	29.392	29.31	29.35	66660.0
2011-06-30	AOM	ETF	30.54	30.63	30.51	30.5901	32047.0
2011-06-30	AOR	ETF	32.47	32.6	32.44	32.5899	53862.0
2011-06-30	ARB	ETF	40.13	41.62	39.98	41.33	141375.0
2011-06-30	ARGT	ETF	29.82	29.82	29.82	29.82	400.0
2011-06-30	ASEA	ETF	16.66	16.66	16.54	16.54	4300.0
2011-06-30	AWAY	ETF	39.51	40.26	38.21	38.7	721234.0
2011-06-30	BAB	ETF	26.12	26.172	25.94	25.99	241219.0
2011-06-30	BAL	ETF	72.04	74.7	71.5	74.29	119201.0
2011-06-30	BALT	ETF	5.86	5.9	5.7	5.74	152405.0
2011-06-30	BBH	ETF	35.9567	36.0033	35.73	35.7633	36300.0
2011-06-30	BCM	ETF	46.13	46.13	46.13	46.13	210.0
2011-06-30	BIB	ETF	9.66	9.6875	9.6086	9.6188	23776.0
2011-06-30	BICK	ETF	31.83	31.93	31.812	31.887	5994.0
2011-06-30	BIL	ETF	91.7	91.72	91.7	91.72	1730050.0
2011-06-30	BIS	ETF	5979.2	5986.24	5950.4	5986.24	7.65
2011-06-30	BITS	ETF	21.48	21.48	20.96	20.96	410.0
2011-06-30	BIV	ETF	84.31	84.34	83.68	83.95	207300.0
2011-06-30	BJK	ETF	34.3	34.75	34.3	34.73	6400.0
2011-06-30	BKF	ETF	47.57	47.93	47.54	47.8	99549.0
2011-06-30	BKLN	ETF	24.8	24.83	24.76	24.83	84600.0
2011-06-30	BLNG	ETF	49.19	49.19	49.14	49.14	510.0
2011-06-30	BLV	ETF	80.04	80.16	79.31	79.96	94700.0
2011-06-30	BMVP	ETF	15.61	15.7667	15.61	15.7516	8229.0
2011-06-30	BND	ETF	81.41	81.44	81.01	81.16	1808400.0
2011-06-30	BNO	ETF	37.48	37.785	37.095	37.38	75800.0

> showing 50 of 860 rows — these rows as CSV

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