PREVIEW / etf_daily / 2011-09-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-08.parquet
  size:    36 KB
  rows:    863

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-09-08	SPY	ETF	119.57	120.94	118.77	119.04	250568200.0
2011-09-08	QQQ	ETF	54.37	55.1684	54.21	54.39	61422788.0
2011-09-08	IWM	ETF	70.34	71.3	69.18	69.55	71124100.0
2011-09-08	DIA	ETF	113.38	114.68	112.73	112.87	7772800.0
2011-09-08	GLD	ETF	181.39	182.12	179.77	181.81	20741300.0
2011-09-08	TLT	ETF	112.3	112.63	111.34	112.51	11480900.0
2011-09-08	AADR	ETF	28.93	28.93	28.9	28.9	59800.0
2011-09-08	AAXJ	ETF	55.0	55.62	54.72	54.93	213100.0
2011-09-08	ACTV	ETF	15.5	15.75	15.08	15.32	53813.0
2011-09-08	ACWI	ETF	42.33	42.77	42.05	42.16	580200.0
2011-09-08	ACWX	ETF	38.42	38.76	38.084	38.16	63478.0
2011-09-08	ADRE	ETF	41.38	41.78	41.21	41.32	63710.0
2011-09-08	AFK	ETF	29.48	29.74	29.32	29.33	13786.0
2011-09-08	AGEM	ETF	23.22	23.38	22.96	23.06	2401.0
2011-09-08	AGG	ETF	110.16	110.17	109.86	110.01	1169400.0
2011-09-08	AGQ	ETF	471.48	471.94	459.78	465.6	443500.0
2011-09-08	AGZ	ETF	112.86	112.86	112.4	112.42	130389.0
2011-09-08	AIA	ETF	41.52	42.0085	41.32	41.39	18560.0
2011-09-08	AIQ	ETF	6.7495	6.7495	6.4	6.4	31052.0
2011-09-08	AIS	ETF	2.33	2.35	2.28	2.32	658550.0
2011-09-08	AIVI	ETF	40.63	41.18	40.37	40.48	94200.0
2011-09-08	AMJ	ETF	35.0	35.39	34.9129	35.11	800384.0
2011-09-08	AMLP	ETF	76.95	77.55	76.95	77.4	81400.0
2011-09-08	AOA	ETF	32.3	32.48	32.02	32.07	45400.0
2011-09-08	AOK	ETF	29.09	29.1	29.026	29.05	32123.0
2011-09-08	AOM	ETF	29.72	29.7856	29.63	29.63	54139.0
2011-09-08	AOR	ETF	30.61	30.85	30.56	30.58	27471.0
2011-09-08	ARB	ETF	35.11	35.8	34.97	35.11	138402.0
2011-09-08	ARGT	ETF	24.38	24.38	24.38	24.38	500.0
2011-09-08	ASEA	ETF	16.12	16.12	15.89	16.0	133900.0
2011-09-08	AWAY	ETF	41.28	41.91	39.11	41.54	69364.0
2011-09-08	BAB	ETF	28.18	28.23	28.05	28.14	145998.0
2011-09-08	BAL	ETF	70.55	71.69	70.38	70.64	330458.0
2011-09-08	BALT	ETF	4.96	5.17	4.96	5.07	138438.0
2011-09-08	BBH	ETF	32.63	32.75	32.61	32.61	16200.0
2011-09-08	BCM	ETF	49.99	49.99	48.3335	48.36	2610.0
2011-09-08	BIB	ETF	7.5088	7.7825	7.4875	7.6262	38712.0
2011-09-08	BICK	ETF	26.89	26.89	26.54	26.67	159605.0
2011-09-08	BIL	ETF	91.68	91.7	91.68	91.68	698000.0
2011-09-08	BIS	ETF	6539.2	6541.44	6452.8	6541.44	7.8
2011-09-08	BITS	ETF	22.08	22.92	21.28	21.28	5839.0
2011-09-08	BIV	ETF	88.3	88.46	88.14	88.41	102100.0
2011-09-08	BJK	ETF	33.18	33.48	32.75	32.87	7500.0
2011-09-08	BKF	ETF	41.02	41.3855	40.76	40.9101	108028.0
2011-09-08	BKLN	ETF	23.35	23.42	23.27	23.27	159700.0
2011-09-08	BLNG	ETF	58.91	58.91	58.58	58.68	2505.0
2011-09-08	BLV	ETF	89.53	89.68	88.88	89.64	34300.0
2011-09-08	BMVP	ETF	13.6	13.61	13.37	13.39	2419.0
2011-09-08	BND	ETF	83.87	83.87	83.64	83.81	973600.0
2011-09-08	BNO	ETF	38.57	38.8	38.05	38.05	32800.0

> showing 50 of 863 rows — these rows as CSV

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