PREVIEW / etf_daily / 2012-05-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-08.parquet
  size:    38 KB
  rows:    934

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-05-08	SPY	ETF	136.28	136.77	134.92	136.55	213377700.0
2012-05-08	QQQ	ETF	64.34	64.74	63.48	64.52	72659690.0
2012-05-08	IWM	ETF	78.69	79.3	77.97	79.25	62939600.0
2012-05-08	DIA	ETF	129.17	129.33	127.91	129.08	7641700.0
2012-05-08	GLD	ETF	156.61	156.73	154.92	156.0	17852300.0
2012-05-08	TLT	ETF	118.69	119.51	118.66	118.79	6051600.0
2012-05-08	AADR	ETF	29.25	29.25	29.06	29.07	900.0
2012-05-08	AAXJ	ETF	55.11	55.13	54.27	54.83	337500.0
2012-05-08	ACTV	ETF	14.84	14.9	14.61	14.76	290225.0
2012-05-08	ACWI	ETF	45.17	45.26	44.69	45.14	330400.0
2012-05-08	ACWV	ETF	53.96	54.16	53.51	54.16	61400.0
2012-05-08	ACWX	ETF	38.8	38.8	38.24	38.64	145501.0
2012-05-08	ADRE	ETF	39.94	39.94	39.23	39.59	26098.0
2012-05-08	AFK	ETF	29.49	29.55	29.3201	29.54	6724.0
2012-05-08	AGEM	ETF	21.47	21.47	21.448	21.448	594.0
2012-05-08	AGG	ETF	110.84	110.95	110.78	110.79	580200.0
2012-05-08	AGQ	ETF	179.12	180.6	175.44	180.12	533275.0
2012-05-08	AGZ	ETF	113.18	113.22	113.066	113.1053	7912.0
2012-05-08	AIA	ETF	43.95	43.95	43.46	43.82	15696.0
2012-05-08	AIQ	ETF	7.1	7.1	6.9	6.95	6394.0
2012-05-08	AIS	ETF	3.25	3.25	3.08	3.19	1495512.0
2012-05-08	AIVI	ETF	39.74	39.78	39.24	39.66	36700.0
2012-05-08	AMJ	ETF	39.31	39.39	38.77	38.99	989121.0
2012-05-08	AMLP	ETF	81.45	82.05	81.0	81.55	715660.0
2012-05-08	ANGL	ETF	25.5	25.54	25.46	25.51	15100.0
2012-05-08	AOA	ETF	35.42	35.42	35.09	35.4	10900.0
2012-05-08	AOK	ETF	29.9508	29.99	29.91	29.99	16859.0
2012-05-08	AOM	ETF	30.9	30.94	30.79	30.939	13447.0
2012-05-08	AOR	ETF	32.7	32.75	32.5612	32.73	11132.0
2012-05-08	ARB	ETF	35.82	36.27	35.61	36.25	335356.0
2012-05-08	ARGT	ETF	17.42	17.5	17.24	17.5	4050.0
2012-05-08	ASEA	ETF	16.07	16.15	16.0	16.13	47100.0
2012-05-08	AWAY	ETF	25.26	25.75	25.26	25.44	342935.0
2012-05-08	BAB	ETF	29.65	29.749	29.61	29.641	191586.0
2012-05-08	BAL	ETF	54.02	54.02	53.48	53.63	23231.0
2012-05-08	BALT	ETF	4.08	4.08	3.95	4.03	102520.0
2012-05-08	BBH	ETF	45.88	46.22	45.28	46.16	82300.0
2012-05-08	BCM	ETF	42.79	43.11	42.79	43.02	29014.0
2012-05-08	BIB	ETF	12.0188	12.2625	11.8951	12.2625	8640.0
2012-05-08	BICK	ETF	24.25	24.25	23.94	24.19	2674.0
2012-05-08	BIL	ETF	91.66	91.66	91.64	91.66	282950.0
2012-05-08	BIS	ETF	3592.0	3666.88	3513.6	3513.6	9.45
2012-05-08	BIV	ETF	88.27	88.32	88.12	88.16	252500.0
2012-05-08	BJK	ETF	35.36	35.36	34.5	35.1	30100.0
2012-05-08	BKF	ETF	38.46	38.46	37.8101	38.12	127881.0
2012-05-08	BKLN	ETF	24.78	24.78	24.66	24.66	159800.0
2012-05-08	BLNG	ETF	47.87	47.87	47.87	47.87	700.0
2012-05-08	BLV	ETF	92.07	92.46	92.07	92.15	59200.0
2012-05-08	BMVP	ETF	15.11	15.11	14.99	15.0	8500.0
2012-05-08	BND	ETF	83.96	84.1	83.96	83.99	761300.0

> showing 50 of 934 rows — these rows as CSV

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