PREVIEW / etf_daily / 2012-09-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-27.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-27	SPY	ETF	143.89	144.97	143.51	144.64	111830300.0
2012-09-27	QQQ	ETF	68.35	69.3	68.25	69.14	25339433.0
2012-09-27	IWM	ETF	83.49	84.35	83.07	84.04	33252800.0
2012-09-27	DIA	ETF	134.44	134.94	133.85	134.6	4975500.0
2012-09-27	GLD	ETF	171.02	172.6	170.76	172.34	10539500.0
2012-09-27	TLT	ETF	124.55	124.8	123.77	124.15	5147700.0
2012-09-27	AADR	ETF	29.61	30.06	29.61	30.06	1500.0
2012-09-27	AAXJ	ETF	56.16	56.54	55.97	56.41	170000.0
2012-09-27	ACTV	ETF	12.46	12.65	12.33	12.55	327129.0
2012-09-27	ACWI	ETF	46.91	47.31	46.81	47.2	201800.0
2012-09-27	ACWV	ETF	56.6	56.97	56.52	56.81	29000.0
2012-09-27	ACWX	ETF	39.88	40.21	39.74	40.08	152234.0
2012-09-27	ADRE	ETF	39.31	39.5	39.13	39.5	24223.0
2012-09-27	AFK	ETF	31.02	31.37	30.961	31.35	44027.0
2012-09-27	AGEM	ETF	22.26	22.5	22.26	22.5	816.0
2012-09-27	AGG	ETF	112.3	112.38	112.27	112.29	1127100.0
2012-09-27	AGQ	ETF	230.28	236.56	228.56	235.08	364750.0
2012-09-27	AGZ	ETF	113.9	114.01	113.89	113.91	25179.0
2012-09-27	AIA	ETF	44.53	44.759	44.32	44.61	21688.0
2012-09-27	AIQ	ETF	6.85	7.125	6.7	6.85	13556.0
2012-09-27	AIVI	ETF	40.72	41.09	40.55	40.97	69600.0
2012-09-27	AMJ	ETF	40.0	40.33	39.99	40.32	659699.0
2012-09-27	AMLP	ETF	82.35	82.75	82.25	82.75	291880.0
2012-09-27	ANGL	ETF	26.37	26.37	26.25	26.33	2200.0
2012-09-27	AOA	ETF	36.67	36.93	36.63	36.87	4200.0
2012-09-27	AOK	ETF	30.5	30.61	30.5	30.56	7231.0
2012-09-27	AOM	ETF	31.55	31.6899	31.55	31.67	11774.0
2012-09-27	AOR	ETF	33.71	33.87	33.662	33.8264	93315.0
2012-09-27	ARB	ETF	37.84	38.22	37.3677	38.1	89333.0
2012-09-27	ARGT	ETF	17.98	17.98	17.92	17.98	2350.0
2012-09-27	ASEA	ETF	16.62	16.7	16.6	16.69	2700.0
2012-09-27	AWAY	ETF	23.54	23.72	23.21	23.3	732210.0
2012-09-27	BAB	ETF	30.16	30.16	30.05	30.11	480549.0
2012-09-27	BAL	ETF	46.73	47.03	46.46	46.91	20762.0
2012-09-27	BALT	ETF	3.1945	3.26	3.165	3.23	20460.0
2012-09-27	BBH	ETF	53.45	54.11	53.4	54.06	10800.0
2012-09-27	BCM	ETF	45.75	45.9699	45.67	45.9524	2368.0
2012-09-27	BIB	ETF	15.3488	15.8174	15.2315	15.75	40280.0
2012-09-27	BICK	ETF	23.77	23.879	23.58	23.8117	7710.0
2012-09-27	BIL	ETF	91.62	91.64	91.62	91.64	138000.0
2012-09-27	BIS	ETF	2624.0	2624.0	2576.0	2576.0	5.55
2012-09-27	BIV	ETF	90.16	90.24	90.1	90.18	222200.0
2012-09-27	BJK	ETF	33.85	34.11	33.8	34.11	1500.0
2012-09-27	BKF	ETF	37.87	38.09	37.67	37.96	71871.0
2012-09-27	BKLN	ETF	24.99	25.0	24.94	24.97	1528500.0
2012-09-27	BLNG	ETF	55.94	55.94	53.54	53.54	500.0
2012-09-27	BLV	ETF	96.75	96.75	96.26	96.63	18100.0
2012-09-27	BMVP	ETF	16.0267	16.1851	16.0267	16.16	5933.0
2012-09-27	BND	ETF	85.07	85.14	85.05	85.07	963400.0
2012-09-27	BNO	ETF	40.4	40.625	40.24	40.56	120600.0

> showing 50 of 944 rows — these rows as CSV

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