PREVIEW / etf_daily / 2011-07-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-01.parquet
  size:    36 KB
  rows:    859

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-07-01	SPY	ETF	132.09	134.1	131.78	133.92	202385700.0
2011-07-01	QQQ	ETF	57.1	57.985	56.92	57.91	53203803.0
2011-07-01	IWM	ETF	82.88	84.23	82.62	84.09	63908100.0
2011-07-01	DIA	ETF	124.09	125.72	123.8	125.58	8692000.0
2011-07-01	GLD	ETF	144.76	145.07	143.97	144.93	16366500.0
2011-07-01	TLT	ETF	94.13	94.23	93.36	93.63	6637200.0
2011-07-01	AAXJ	ETF	61.91	62.81	61.91	62.7	156600.0
2011-07-01	ACTV	ETF	17.75	18.28	17.38	18.01	99239.0
2011-07-01	ACWI	ETF	48.26	48.94	48.09	48.9	481800.0
2011-07-01	ACWX	ETF	44.93	45.49	44.82	45.49	368212.0
2011-07-01	ADRE	ETF	46.48	47.18	46.41	47.15	37112.0
2011-07-01	AFK	ETF	32.1	32.59	32.1	32.59	6179.0
2011-07-01	AGEM	ETF	27.5	27.5	26.514	26.9	5663.0
2011-07-01	AGG	ETF	106.5	106.54	106.27	106.4	1970000.0
2011-07-01	AGQ	ETF	313.8	317.44	306.12	313.2	672250.0
2011-07-01	AGZ	ETF	110.46	110.51	110.228	110.38	159035.0
2011-07-01	AIA	ETF	46.76	47.42	46.76	47.3316	18314.0
2011-07-01	AIQ	ETF	19.0	19.0	18.75	18.8	13382.0
2011-07-01	AIS	ETF	2.2	2.32	2.17	2.32	1921630.0
2011-07-01	AIVI	ETF	46.92	47.55	46.83	47.55	72600.0
2011-07-01	AMJ	ETF	37.21	37.32	37.0	37.3	940829.0
2011-07-01	AMLP	ETF	80.0	80.45	79.95	80.4	126100.0
2011-07-01	AOA	ETF	35.96	36.3	35.85	36.28	16200.0
2011-07-01	AOK	ETF	29.38	29.48	29.34	29.48	33473.0
2011-07-01	AOM	ETF	30.77	31.18	30.5825	30.77	31613.0
2011-07-01	AOR	ETF	32.84	32.87	32.56	32.86	33033.0
2011-07-01	ARB	ETF	41.2	41.45	40.81	41.26	258089.0
2011-07-01	ARGT	ETF	29.9	30.18	29.84	30.12	2250.0
2011-07-01	ASEA	ETF	16.7	16.85	16.7	16.85	3800.0
2011-07-01	AWAY	ETF	38.35	39.0	37.88	38.42	437113.0
2011-07-01	BAB	ETF	26.06	26.22	25.96	26.0285	124826.0
2011-07-01	BAL	ETF	73.61	73.87	72.52	73.38	62034.0
2011-07-01	BALT	ETF	5.74	5.84	5.61	5.76	104950.0
2011-07-01	BBH	ETF	35.8	36.0233	35.8	36.0067	28800.0
2011-07-01	BCM	ETF	46.38	46.38	45.51	45.596	1252.0
2011-07-01	BIB	ETF	9.7363	9.815	9.6662	9.815	50320.0
2011-07-01	BICK	ETF	32.0	32.53	32.0	32.5	27225.0
2011-07-01	BIL	ETF	91.72	91.72	91.7	91.7	496400.0
2011-07-01	BIS	ETF	6043.2	6043.2	5849.2	5875.2	24.55
2011-07-01	BITS	ETF	20.96	21.4	20.8	21.4	630.0
2011-07-01	BIV	ETF	83.7	83.83	83.42	83.61	142500.0
2011-07-01	BJK	ETF	34.66	35.32	34.66	35.24	20500.0
2011-07-01	BKF	ETF	47.84	48.5	47.82	48.37	101270.0
2011-07-01	BKLN	ETF	24.75	24.91	24.75	24.88	100800.0
2011-07-01	BLNG	ETF	46.97	47.19	46.92	46.94	11235.0
2011-07-01	BLV	ETF	80.02	80.02	79.45	79.62	43500.0
2011-07-01	BMVP	ETF	15.7	15.97	15.67	15.97	7121.0
2011-07-01	BND	ETF	81.04	81.12	80.88	80.98	922700.0
2011-07-01	BNO	ETF	36.85	37.29	36.605	37.215	115200.0
2011-07-01	BRF	ETF	57.1	57.7591	56.83	57.58	272632.0

> showing 50 of 859 rows — these rows as CSV

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