PREVIEW / etf_daily / 2012-09-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-18.parquet
  size:    39 KB
  rows:    943

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-18	SPY	ETF	146.49	146.81	146.25	146.62	98326600.0
2012-09-18	QQQ	ETF	70.04	70.3	70.02	70.27	27169767.0
2012-09-18	IWM	ETF	85.74	85.9	85.36	85.72	32991100.0
2012-09-18	DIA	ETF	135.15	135.79	135.15	135.61	3375400.0
2012-09-18	GLD	ETF	170.81	171.95	170.67	171.72	12486600.0
2012-09-18	TLT	ETF	120.71	120.9	119.96	120.32	5366200.0
2012-09-18	AADR	ETF	29.96	29.96	29.96	29.96	100.0
2012-09-18	AAXJ	ETF	56.14	56.54	56.14	56.35	129000.0
2012-09-18	ACTV	ETF	12.16	12.49	12.09	12.42	523594.0
2012-09-18	ACWI	ETF	47.78	47.79	47.6	47.77	556400.0
2012-09-18	ACWV	ETF	56.37	56.38	56.33	56.33	2500.0
2012-09-18	ACWX	ETF	40.49	40.63	40.43	40.54	88257.0
2012-09-18	ADRE	ETF	40.17	40.32	40.1	40.2	28815.0
2012-09-18	AFK	ETF	31.52	31.7	31.46	31.63	29411.0
2012-09-18	AGEM	ETF	22.63	22.7216	22.63	22.7216	641.0
2012-09-18	AGG	ETF	111.72	111.81	111.61	111.62	1133600.0
2012-09-18	AGQ	ETF	232.0	241.32	230.8	237.56	581850.0
2012-09-18	AGZ	ETF	113.49	113.77	113.47	113.76	14818.0
2012-09-18	AIA	ETF	44.64	44.8435	44.64	44.7	14366.0
2012-09-18	AIQ	ETF	7.1	7.15	6.95	7.15	12250.0
2012-09-18	AIVI	ETF	41.7	41.8	41.54	41.66	28400.0
2012-09-18	ALTL	ETF	26.2	26.2	26.116	26.143	5388.0
2012-09-18	AMJ	ETF	40.16	40.43	40.16	40.35	2005455.0
2012-09-18	AMLP	ETF	82.85	82.9	82.65	82.9	400600.0
2012-09-18	ANGL	ETF	26.83	26.83	26.4	26.55	2000.0
2012-09-18	AOA	ETF	37.38	37.4	37.27	37.29	6100.0
2012-09-18	AOK	ETF	30.65	30.67	30.6	30.64	15379.0
2012-09-18	AOM	ETF	31.86	31.92	31.8	31.89	12026.0
2012-09-18	AOR	ETF	34.17	34.19	34.0917	34.108	20810.0
2012-09-18	ARB	ETF	38.06	38.305	37.96	38.19	90129.0
2012-09-18	ARGT	ETF	18.16	18.16	18.16	18.16	100.0
2012-09-18	ASEA	ETF	16.84	16.84	16.77	16.82	5400.0
2012-09-18	AWAY	ETF	24.3	24.62	24.17	24.24	208317.0
2012-09-18	BAB	ETF	29.72	29.72	29.51	29.57	490077.0
2012-09-18	BAL	ETF	50.0998	50.446	49.98	50.04	8991.0
2012-09-18	BALT	ETF	3.31	3.5	3.3	3.44	56113.0
2012-09-18	BBH	ETF	53.59	54.18	53.59	54.13	32000.0
2012-09-18	BCM	ETF	46.5896	46.5896	46.5896	46.5896	100.0
2012-09-18	BIB	ETF	15.96	16.1924	15.8613	16.12	62456.0
2012-09-18	BICK	ETF	24.06	24.13	23.94	24.01	21453.0
2012-09-18	BIL	ETF	91.64	91.64	91.62	91.62	1879300.0
2012-09-18	BIS	ETF	2531.2	2598.4	2502.4	2502.4	88.0
2012-09-18	BIV	ETF	89.55	89.61	89.41	89.47	260200.0
2012-09-18	BJK	ETF	34.35	34.38	34.3	34.3	4800.0
2012-09-18	BKF	ETF	38.41	38.4658	38.21	38.29	139271.0
2012-09-18	BKLN	ETF	25.04	25.05	25.0	25.05	366800.0
2012-09-18	BLV	ETF	94.69	94.92	94.23	94.35	140600.0
2012-09-18	BMVP	ETF	16.2543	16.2543	16.2097	16.2333	2375.0
2012-09-18	BND	ETF	84.57	84.64	84.47	84.5	3447100.0
2012-09-18	BNO	ETF	41.095	41.13	40.34	40.47	172800.0

> showing 50 of 943 rows — these rows as CSV

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