PREVIEW / etf_daily / 2011-06-16

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-16.parquet
  size:    36 KB
  rows:    861

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-16	SPY	ETF	127.06	127.97	126.32	127.3	308032800.0
2011-06-16	QQQ	ETF	54.33	54.5	53.615	54.08	66316185.0
2011-06-16	IWM	ETF	78.09	78.88	77.23	78.21	81849500.0
2011-06-16	DIA	ETF	118.84	119.85	118.69	119.53	7469900.0
2011-06-16	GLD	ETF	148.83	149.49	148.22	148.97	11035000.0
2011-06-16	TLT	ETF	97.1	97.53	96.8	97.36	10961200.0
2011-06-16	AADR	ETF	30.43	30.43	29.96	30.12	900.0
2011-06-16	AAXJ	ETF	60.19	60.47	59.77	60.16	401700.0
2011-06-16	ACTV	ETF	18.9	19.19	18.32	18.72	58090.0
2011-06-16	ACWI	ETF	46.55	46.89	46.29	46.65	232700.0
2011-06-16	ACWX	ETF	43.43	43.68	43.1	43.45	67394.0
2011-06-16	ADRE	ETF	44.66	44.936	44.13	44.51	80610.0
2011-06-16	AFK	ETF	31.89	31.89	31.5	31.6	18030.0
2011-06-16	AGG	ETF	107.4	107.57	107.37	107.39	1211900.0
2011-06-16	AGQ	ETF	346.56	352.38	340.12	347.2	457500.0
2011-06-16	AGZ	ETF	110.96	110.96	110.83	110.8997	17262.0
2011-06-16	AIA	ETF	45.85	46.02	45.53	45.85	26599.0
2011-06-16	AIQ	ETF	19.2	20.0	19.105	19.6	35682.0
2011-06-16	AIS	ETF	1.93	2.0099	1.88	1.94	847690.0
2011-06-16	AIVI	ETF	45.89	46.07	45.58	45.96	25700.0
2011-06-16	AMJ	ETF	35.95	36.1325	35.47	35.56	636312.0
2011-06-16	AMLP	ETF	78.85	79.0	77.85	78.05	146120.0
2011-06-16	AOA	ETF	34.57	34.77	34.36	34.36	6400.0
2011-06-16	AOK	ETF	29.09	29.16	29.06	29.1	10875.0
2011-06-16	AOM	ETF	30.33	30.379	30.25	30.2764	17455.0
2011-06-16	AOR	ETF	31.89	32.05	31.8372	31.9205	16074.0
2011-06-16	ARB	ETF	38.26	39.12	37.71	38.24	228016.0
2011-06-16	ARGT	ETF	28.24	28.24	27.9	27.9	2300.0
2011-06-16	ASEA	ETF	15.8	15.81	15.71	15.72	1600.0
2011-06-16	BAB	ETF	26.65	26.73	26.64	26.69	170925.0
2011-06-16	BAL	ETF	76.89	76.89	74.09	74.9	103690.0
2011-06-16	BALT	ETF	5.88	6.29	5.827	6.0	180399.0
2011-06-16	BBH	ETF	33.93	34.1	33.8667	34.0067	31500.0
2011-06-16	BIB	ETF	8.8475	8.9675	8.6875	8.8541	61912.0
2011-06-16	BICK	ETF	30.77	30.9288	30.51	30.68	9350.0
2011-06-16	BIL	ETF	91.72	91.72	91.7	91.72	101900.0
2011-06-16	BIS	ETF	6447.2	6630.4	6447.2	6553.6	15.75
2011-06-16	BITS	ETF	21.8	21.84	21.08	21.6	475.0
2011-06-16	BIV	ETF	84.92	85.05	84.73	84.91	123400.0
2011-06-16	BJK	ETF	32.04	32.19	31.79	31.94	11000.0
2011-06-16	BKF	ETF	46.21	46.59	45.7601	46.15	170251.0
2011-06-16	BKLN	ETF	24.83	24.83	24.74	24.74	70100.0
2011-06-16	BLNG	ETF	48.48	48.48	48.37	48.37	400.0
2011-06-16	BLV	ETF	82.0	82.27	81.75	82.01	61900.0
2011-06-16	BMVP	ETF	14.87	14.94	14.72	14.85	15373.0
2011-06-16	BND	ETF	81.8	81.88	81.7	81.75	885200.0
2011-06-16	BNO	ETF	37.975	38.22	37.75	38.04	146000.0
2011-06-16	BOSS	ETF	56.47	56.47	55.29	55.29	200.0
2011-06-16	BRF	ETF	55.5	55.93	55.02	55.6	626157.0
2011-06-16	BSCE	ETF	21.16	21.24	21.16	21.2135	39590.0

> showing 50 of 861 rows — these rows as CSV

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