PREVIEW / etf_daily / 2012-11-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-21.parquet
  size:    38 KB
  rows:    938

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
2012-11-21	SPY	ETF	139.31	139.57	139.03	139.45	81710800.0
2012-11-21	QQQ	ETF	63.83	64.02	63.6	63.93	19620058.0
2012-11-21	IWM	ETF	79.41	79.73	79.13	79.68	19254500.0
2012-11-21	DIA	ETF	127.65	128.22	127.54	128.15	4589400.0
2012-11-21	GLD	ETF	167.19	167.82	166.97	167.56	3810700.0
2012-11-21	TLT	ETF	124.19	124.42	124.02	124.33	2422800.0
2012-11-21	AADR	ETF	29.37	29.53	29.36	29.45	3500.0
2012-11-21	AAXJ	ETF	56.27	56.55	56.19	56.42	113000.0
2012-11-21	ACTV	ETF	5.04	5.04	4.78	4.78	359711.0
2012-11-21	ACWI	ETF	46.1	46.22	46.04	46.22	868900.0
2012-11-21	ACWV	ETF	55.67	55.94	55.5	55.69	18200.0
2012-11-21	ACWX	ETF	39.35	39.52	39.35	39.51	79067.0
2012-11-21	ADRE	ETF	37.79	37.9	37.7	37.9	24949.0
2012-11-21	AFK	ETF	30.78	30.9099	30.71	30.8775	34398.0
2012-11-21	AGEM	ETF	22.1	22.12	21.96	22.11	6749.0
2012-11-21	AGG	ETF	111.97	112.06	111.88	111.89	1160800.0
2012-11-21	AGQ	ETF	210.84	215.64	209.88	215.16	229700.0
2012-11-21	AGZ	ETF	113.8699	113.87	113.72	113.87	8857.0
2012-11-21	AIA	ETF	44.74	44.879	44.65	44.78	25227.0
2012-11-21	AIQ	ETF	6.3	6.45	6.05	6.05	8562.0
2012-11-21	AIVI	ETF	39.24	39.41	39.21	39.32	19200.0
2012-11-21	AMJ	ETF	39.52	39.75	39.0501	39.72	719507.0
2012-11-21	AMLP	ETF	80.8	80.85	80.35	80.85	398620.0
2012-11-21	ANGL	ETF	26.66	26.67	26.62	26.65	7800.0
2012-11-21	AOA	ETF	36.0	36.11	36.0	36.11	2300.0
2012-11-21	AOK	ETF	30.32	30.34	30.28	30.29	6335.0
2012-11-21	AOM	ETF	31.32	31.3499	31.294	31.3396	4262.0
2012-11-21	AOR	ETF	33.21	33.29	33.21	33.29	159010.0
2012-11-21	ARB	ETF	35.46	35.59	35.01	35.19	54882.0
2012-11-21	ARGT	ETF	15.88	15.88	15.7	15.76	6550.0
2012-11-21	ASEA	ETF	16.54	16.54	16.47	16.52	16700.0
2012-11-21	AWAY	ETF	20.69	20.86	20.25	20.81	270394.0
2012-11-21	BAB	ETF	30.3	30.38	30.25	30.321	240310.0
2012-11-21	BAL	ETF	47.1299	47.55	47.0901	47.38	3167.0
2012-11-21	BALT	ETF	2.81	2.9	2.76	2.9	92684.0
2012-11-21	BBH	ETF	54.0	54.1	53.66	53.92	15100.0
2012-11-21	BCM	ETF	44.32	44.32	44.3112	44.3112	320.0
2012-11-21	BIB	ETF	14.455	14.5365	14.3	14.3	70428.0
2012-11-21	BICK	ETF	23.21	23.28	23.21	23.28	1357.0
2012-11-21	BIL	ETF	91.62	91.64	91.62	91.62	69800.0
2012-11-21	BIS	ETF	2721.2	2721.2	2694.0	2696.004	45.2
2012-11-21	BIV	ETF	90.1	90.14	90.02	90.12	178300.0
2012-11-21	BJK	ETF	34.56	34.7	34.52	34.65	3100.0
2012-11-21	BKF	ETF	37.53	37.65	37.42	37.58	73173.0
2012-11-21	BKLN	ETF	24.62	24.63	24.62	24.63	462300.0
2012-11-21	BLNG	ETF	51.87	51.87	51.87	51.87	100.0
2012-11-21	BLV	ETF	96.41	96.73	96.41	96.61	46000.0
2012-11-21	BMVP	ETF	15.6733	15.7054	15.6707	15.7033	1570.0
2012-11-21	BND	ETF	84.75	84.77	84.7	84.73	643200.0
2012-11-21	BNO	ETF	40.575	40.68	40.13	40.61	143600.0

> showing 50 of 938 rows — these rows as CSV

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