PREVIEW / etf_daily / 2012-03-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-27.parquet
  size:    38 KB
  rows:    927

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-03-27	SPY	ETF	141.74	141.83	141.08	141.17	119868500.0
2012-03-27	QQQ	ETF	68.145	68.49	68.13	68.21	37278184.0
2012-03-27	IWM	ETF	84.42	84.66	83.75	83.81	41730700.0
2012-03-27	DIA	ETF	132.22	132.35	131.65	131.67	5777300.0
2012-03-27	GLD	ETF	164.52	164.89	163.13	163.24	10908700.0
2012-03-27	TLT	ETF	112.78	113.7	112.7	113.44	6972300.0
2012-03-27	AADR	ETF	31.47	31.47	31.33	31.37	6000.0
2012-03-27	AAXJ	ETF	57.15	57.2	56.86	56.91	139200.0
2012-03-27	ACTV	ETF	17.22	17.25	17.03	17.11	429687.0
2012-03-27	ACWI	ETF	47.65	47.65	47.36	47.39	503400.0
2012-03-27	ACWV	ETF	54.83	55.0	54.22	54.65	13000.0
2012-03-27	ACWX	ETF	41.37	41.406	41.1	41.13	142423.0
2012-03-27	ADRE	ETF	43.07	43.184	42.841	42.87	26125.0
2012-03-27	AFK	ETF	29.69	29.74	29.6	29.6	25107.0
2012-03-27	AGEM	ETF	23.81	23.81	23.66	23.72	2016.0
2012-03-27	AGG	ETF	109.69	109.8	109.61	109.74	2551700.0
2012-03-27	AGQ	ETF	227.96	229.56	220.68	221.12	433650.0
2012-03-27	AGZ	ETF	112.68	112.69	112.5	112.64	111534.0
2012-03-27	AIA	ETF	45.4	45.4	45.0108	45.0108	33113.0
2012-03-27	AIQ	ETF	7.6	7.638	7.25	7.25	16849.0
2012-03-27	AIS	ETF	3.34	3.36	3.25	3.27	1420750.0
2012-03-27	AIVI	ETF	42.27	42.3	42.0	42.02	64000.0
2012-03-27	AMJ	ETF	39.62	39.77	39.45	39.48	1976697.0
2012-03-27	AMLP	ETF	83.8	84.05	83.35	83.5	270120.0
2012-03-27	AOA	ETF	36.71	36.71	36.59	36.59	7800.0
2012-03-27	AOK	ETF	30.23	30.24	30.196	30.2043	15077.0
2012-03-27	AOM	ETF	31.35	31.35	31.27	31.27	27358.0
2012-03-27	AOR	ETF	33.51	33.51	33.39	33.39	8591.0
2012-03-27	ARB	ETF	37.19	37.19	36.51	36.53	230469.0
2012-03-27	ARGT	ETF	21.7	21.7	21.48	21.48	25450.0
2012-03-27	ASEA	ETF	16.07	16.16	16.04	16.04	4100.0
2012-03-27	AWAY	ETF	25.49	25.94	25.21	25.54	247790.0
2012-03-27	BAB	ETF	29.04	29.17	28.97	29.16	98041.0
2012-03-27	BAL	ETF	55.59	56.63	55.59	56.01	78541.0
2012-03-27	BALT	ETF	4.18	4.2	4.11	4.11	63142.0
2012-03-27	BBH	ETF	44.03	44.05	43.68	43.7	8100.0
2012-03-27	BCM	ETF	46.04	46.04	45.98	45.99	1413.0
2012-03-27	BIB	ETF	12.22	12.22	11.9712	11.9712	62496.0
2012-03-27	BICK	ETF	26.75	26.8	26.6354	26.655	11839.0
2012-03-27	BIL	ETF	91.66	91.66	91.64	91.64	185050.0
2012-03-27	BIS	ETF	3617.6	3648.0	3617.6	3636.8	13.1
2012-03-27	BIV	ETF	86.68	87.0	86.68	86.95	134700.0
2012-03-27	BJK	ETF	36.45	36.45	36.2	36.2	12700.0
2012-03-27	BKF	ETF	41.87	41.8955	41.55	41.6	36266.0
2012-03-27	BKLN	ETF	24.55	24.55	24.52	24.52	160900.0
2012-03-27	BLNG	ETF	51.52	51.8201	51.2499	51.2699	6036.0
2012-03-27	BLV	ETF	89.06	89.47	89.02	89.36	26700.0
2012-03-27	BMVP	ETF	15.63	15.71	15.61	15.61	5499.0
2012-03-27	BND	ETF	83.17	83.35	83.17	83.29	1095500.0
2012-03-27	BNO	ETF	44.21	44.305	43.925	43.975	27400.0

> showing 50 of 927 rows — these rows as CSV

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