PREVIEW / etf_daily / 2011-08-05

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-05.parquet
  size:    37 KB
  rows:    874

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-08-05	SPY	ETF	121.76	122.07	116.86	120.08	655619200.0
2011-08-05	QQQ	ETF	54.79	55.03	52.32	53.83	214111702.0
2011-08-05	IWM	ETF	73.52	73.85	69.66	71.33	188585600.0
2011-08-05	DIA	ETF	115.13	115.56	111.26	114.25	30450400.0
2011-08-05	GLD	ETF	161.64	162.37	160.48	161.75	24554700.0
2011-08-05	TLT	ETF	103.44	105.5	102.28	102.32	41677700.0
2011-08-05	AADR	ETF	28.55	28.55	28.45	28.45	7500.0
2011-08-05	AAXJ	ETF	57.91	58.27	55.86	57.19	653400.0
2011-08-05	ACTV	ETF	17.43	17.57	16.93	17.12	230471.0
2011-08-05	ACWI	ETF	43.97	44.03	42.07	43.38	1991200.0
2011-08-05	ACWX	ETF	40.57	40.68	38.8	40.12	439151.0
2011-08-05	ADRE	ETF	42.09	42.3	40.18	41.51	202151.0
2011-08-05	AFK	ETF	29.45	29.63	28.35	29.08	61739.0
2011-08-05	AGEM	ETF	23.62	23.63	23.05	23.24	5442.0
2011-08-05	AGG	ETF	108.97	109.26	108.42	108.55	2184400.0
2011-08-05	AGQ	ETF	411.48	414.96	373.92	390.06	985750.0
2011-08-05	AGZ	ETF	111.567	111.76	111.2713	111.42	12084.0
2011-08-05	AIA	ETF	42.87	42.94	41.37	42.35	103830.0
2011-08-05	AIQ	ETF	15.75	16.25	15.4	15.5	14167.0
2011-08-05	AIS	ETF	2.04	2.12	1.91	2.08	2006236.0
2011-08-05	AIVI	ETF	41.97	42.17	39.89	41.69	334000.0
2011-08-05	AMJ	ETF	35.18	35.65	32.65	34.46	3296094.0
2011-08-05	AMLP	ETF	76.65	77.1	65.5	75.9	895360.0
2011-08-05	AOA	ETF	33.03	33.04	31.72	32.48	54600.0
2011-08-05	AOK	ETF	29.06	29.06	28.79	28.9	32827.0
2011-08-05	AOM	ETF	29.87	29.87	29.43	29.71	30508.0
2011-08-05	AOR	ETF	31.02	31.03	30.25	30.69	47866.0
2011-08-05	ARB	ETF	37.36	37.9599	34.53	36.94	414610.0
2011-08-05	ARGT	ETF	27.32	27.32	25.44	26.36	3650.0
2011-08-05	ASEA	ETF	16.7	16.7	16.24	16.45	13500.0
2011-08-05	AWAY	ETF	33.97	35.0	30.07	32.24	557025.0
2011-08-05	BAB	ETF	27.48	27.69	27.03	27.1401	594208.0
2011-08-05	BAL	ETF	64.43	64.63	62.55	62.55	81385.0
2011-08-05	BALT	ETF	4.88	4.889	4.469	4.76	222599.0
2011-08-05	BBH	ETF	31.7	32.11	31.1067	31.7867	108300.0
2011-08-05	BCM	ETF	46.34	46.34	46.11	46.11	225.0
2011-08-05	BIB	ETF	6.8937	7.6738	6.3738	6.8063	540576.0
2011-08-05	BICK	ETF	28.56	28.56	27.1304	27.866	87550.0
2011-08-05	BIL	ETF	91.72	91.72	91.7	91.72	438750.0
2011-08-05	BIS	ETF	7888.0	8517.44	7888.0	8068.784	20.1
2011-08-05	BITS	ETF	19.88	20.6	19.84	19.9604	1624.0
2011-08-05	BIV	ETF	86.59	87.06	86.24	86.39	176100.0
2011-08-05	BJK	ETF	33.57	33.57	31.44	32.88	123400.0
2011-08-05	BKF	ETF	42.88	42.97	40.901	42.28	529951.0
2011-08-05	BKLN	ETF	24.24	24.25	23.71	23.93	195100.0
2011-08-05	BLV	ETF	86.27	87.39	85.02	85.23	77900.0
2011-08-05	BMVP	ETF	13.69	13.83	13.08	13.47	43540.0
2011-08-05	BND	ETF	82.94	83.17	82.56	82.67	1354000.0
2011-08-05	BNO	ETF	36.395	36.64	35.725	36.53	230400.0
2011-08-05	BOSS	ETF	64.0	64.0	60.2	61.57	100.0

> showing 50 of 874 rows — these rows as CSV

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