PREVIEW / etf_daily / 2012-09-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-21.parquet
  size:    39 KB
  rows:    944

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-09-21	SPY	ETF	146.64	146.67	145.81	145.87	108737500.0
2012-09-21	QQQ	ETF	70.47	70.54	70.08	70.15	23681208.0
2012-09-21	IWM	ETF	86.04	86.08	85.47	85.5	38826000.0
2012-09-21	DIA	ETF	136.21	136.24	135.4	135.47	5318100.0
2012-09-21	GLD	ETF	172.93	173.18	171.54	171.96	13361300.0
2012-09-21	TLT	ETF	120.75	121.64	120.67	121.55	4144300.0
2012-09-21	AADR	ETF	30.31	30.31	30.3	30.3	1300.0
2012-09-21	AAXJ	ETF	56.58	56.68	56.33	56.33	67200.0
2012-09-21	ACTV	ETF	12.43	12.67	12.35	12.65	557079.0
2012-09-21	ACWI	ETF	47.85	47.91	47.55	47.55	227800.0
2012-09-21	ACWV	ETF	56.59	56.85	56.59	56.64	5900.0
2012-09-21	ACWX	ETF	40.68	40.68	40.4	40.41	38798.0
2012-09-21	ADRE	ETF	40.02	40.2	39.61	39.63	89081.0
2012-09-21	AFK	ETF	31.6	31.64	31.39	31.41	15069.0
2012-09-21	AGEM	ETF	22.63	22.74	22.5601	22.73	2340.0
2012-09-21	AGG	ETF	111.77	111.95	111.75	111.95	829200.0
2012-09-21	AGQ	ETF	241.72	242.52	231.52	234.2	602275.0
2012-09-21	AGZ	ETF	113.8	113.84	113.56	113.78	52378.0
2012-09-21	AIA	ETF	44.89	44.89	44.61	44.68	11033.0
2012-09-21	AIQ	ETF	7.1	7.1	6.55	6.65	53874.0
2012-09-21	AIVI	ETF	41.97	42.06	41.73	41.78	37900.0
2012-09-21	ALTL	ETF	26.39	26.39	26.33	26.33	2748.0
2012-09-21	AMJ	ETF	40.34	40.54	40.01	40.44	877994.0
2012-09-21	AMLP	ETF	82.75	83.1	82.6	83.1	429040.0
2012-09-21	ANGL	ETF	26.57	26.57	26.44	26.49	11500.0
2012-09-21	AOA	ETF	37.48	37.48	37.32	37.32	6500.0
2012-09-21	AOK	ETF	30.63	30.67	30.6	30.64	9192.0
2012-09-21	AOM	ETF	31.95	31.9599	31.85	31.88	46037.0
2012-09-21	AOR	ETF	34.18	34.22	34.1217	34.1217	10238.0
2012-09-21	ARB	ETF	38.27	38.27	37.9	38.02	162222.0
2012-09-21	ARGT	ETF	17.94	18.28	17.94	18.24	1800.0
2012-09-21	ASEA	ETF	16.83	16.87	16.81	16.81	9500.0
2012-09-21	AWAY	ETF	25.2	25.34	24.82	25.17	843154.0
2012-09-21	BAB	ETF	29.77	29.86	29.7	29.82	158664.0
2012-09-21	BAL	ETF	49.81	49.857	48.28	48.38	14722.0
2012-09-21	BALT	ETF	3.39	3.46	3.33	3.45	71843.0
2012-09-21	BBH	ETF	54.45	54.76	54.43	54.62	40600.0
2012-09-21	BCM	ETF	46.58	46.58	46.38	46.38	700.0
2012-09-21	BIB	ETF	16.1638	16.3588	16.125	16.2188	96320.0
2012-09-21	BICK	ETF	24.18	24.2	24.09	24.0988	21684.0
2012-09-21	BIL	ETF	91.62	91.64	91.62	91.62	1148750.0
2012-09-21	BIS	ETF	2505.6	2508.8	2489.6	2489.6	31.55
2012-09-21	BIV	ETF	89.56	89.79	89.51	89.78	254200.0
2012-09-21	BJK	ETF	34.17	34.18	33.94	33.94	3800.0
2012-09-21	BKF	ETF	38.48	38.501	38.22	38.22	92007.0
2012-09-21	BKLN	ETF	25.03	25.04	25.02	25.04	464200.0
2012-09-21	BLNG	ETF	53.9299	53.9299	53.9299	53.9299	150.0
2012-09-21	BLV	ETF	94.75	95.27	94.42	95.14	172800.0
2012-09-21	BMVP	ETF	16.3	16.3	16.2675	16.2841	1974.0
2012-09-21	BND	ETF	84.63	84.76	84.58	84.72	1264700.0

> showing 50 of 944 rows — these rows as CSV

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