PREVIEW / etf_daily / 2012-03-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-29.parquet
  size:    38 KB
  rows:    925

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-29	SPY	ETF	139.64	140.49	139.09	140.23	164963700.0
2012-03-29	QQQ	ETF	67.61	67.93	67.2	67.68	53975298.0
2012-03-29	IWM	ETF	82.73	83.22	82.02	83.08	45615600.0
2012-03-29	DIA	ETF	130.27	131.24	130.04	131.13	4487400.0
2012-03-29	GLD	ETF	161.14	161.46	159.81	161.28	11026900.0
2012-03-29	TLT	ETF	114.02	114.19	113.58	114.13	7692900.0
2012-03-29	AADR	ETF	30.77	30.77	30.76	30.76	500.0
2012-03-29	AAXJ	ETF	55.87	56.01	55.23	55.9	323100.0
2012-03-29	ACTV	ETF	16.95	17.06	16.72	17.05	118428.0
2012-03-29	ACWI	ETF	46.79	46.95	46.48	46.86	1833400.0
2012-03-29	ACWV	ETF	53.91	54.35	53.8	54.35	11400.0
2012-03-29	ACWX	ETF	40.36	40.57	40.16	40.56	191566.0
2012-03-29	ADRE	ETF	41.62	41.97	41.38	41.96	30925.0
2012-03-29	AFK	ETF	29.05	29.39	29.0	29.37	13040.0
2012-03-29	AGEM	ETF	22.95	23.096	22.95	23.096	275.0
2012-03-29	AGG	ETF	109.95	110.06	109.84	110.02	1208100.0
2012-03-29	AGQ	ETF	213.24	217.8	209.28	217.68	447125.0
2012-03-29	AGZ	ETF	112.782	112.782	112.43	112.72	39295.0
2012-03-29	AIA	ETF	44.17	44.189	43.75	44.16	66956.0
2012-03-29	AIQ	ETF	7.25	7.45	7.15	7.2	6169.0
2012-03-29	AIS	ETF	3.21	3.24	3.15	3.2	888050.0
2012-03-29	AIVI	ETF	41.29	41.56	41.16	41.48	108100.0
2012-03-29	AMJ	ETF	39.14	39.14	38.55	38.89	1478920.0
2012-03-29	AMLP	ETF	82.8	83.05	82.15	82.65	380540.0
2012-03-29	AOA	ETF	36.15	36.29	36.05	36.29	6100.0
2012-03-29	AOK	ETF	30.11	30.16	30.0524	30.16	37407.0
2012-03-29	AOM	ETF	31.09	31.2	31.05	31.17	33972.0
2012-03-29	AOR	ETF	33.17	33.28	33.0695	33.28	19189.0
2012-03-29	ARB	ETF	36.38	36.92	36.03	36.72	234035.0
2012-03-29	ASEA	ETF	15.93	16.0	15.93	16.0	3000.0
2012-03-29	AWAY	ETF	25.37	25.44	25.0027	25.25	111876.0
2012-03-29	BAB	ETF	29.24	29.24	29.04	29.16	316181.0
2012-03-29	BAL	ETF	57.237	57.25	56.46	56.71	83596.0
2012-03-29	BALT	ETF	4.04	4.07	3.99	4.03	74790.0
2012-03-29	BBH	ETF	43.76	44.16	43.76	44.16	67400.0
2012-03-29	BCM	ETF	44.925	44.96	44.8599	44.94	838.0
2012-03-29	BIB	ETF	11.8262	11.8825	11.705	11.8825	11680.0
2012-03-29	BICK	ETF	26.07	26.07	25.78	26.0148	12708.0
2012-03-29	BIL	ETF	91.64	91.66	91.64	91.64	131050.0
2012-03-29	BIV	ETF	87.08	87.1	86.92	87.07	115500.0
2012-03-29	BJK	ETF	35.7	35.7	35.34	35.55	19400.0
2012-03-29	BKF	ETF	40.3	40.61	40.0	40.59	128973.0
2012-03-29	BKLN	ETF	24.57	24.59	24.52	24.56	332000.0
2012-03-29	BLNG	ETF	50.33	50.56	50.33	50.33	1900.0
2012-03-29	BLV	ETF	89.72	89.86	89.52	89.86	19300.0
2012-03-29	BMVP	ETF	15.45	15.5	15.4	15.5	4471.0
2012-03-29	BND	ETF	83.39	83.46	83.31	83.45	1040900.0
2012-03-29	BNO	ETF	43.615	43.68	42.685	43.035	62200.0
2012-03-29	BOIL	ETF	844000.0	848000.0	757000.0	774000.0	16.6
2012-03-29	BOND	ETF	101.87	101.87	101.69	101.76	184050.0

> showing 50 of 925 rows — these rows as CSV

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