PREVIEW / etf_daily / 2014-03-05

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-05.parquet
  size:    43 KB
  rows:    1,069

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
2014-03-05	SPY	ETF	187.74	188.07	187.45	187.75	88376900.0
2014-03-05	QQQ	ETF	90.9698	91.22	90.77	91.06	27220604.0
2014-03-05	IWM	ETF	119.86	119.96	119.47	119.76	34691300.0
2014-03-05	DIA	ETF	163.78	163.82	163.21	163.35	4968400.0
2014-03-05	GLD	ETF	128.71	129.34	128.58	128.89	4878500.0
2014-03-05	TLT	ETF	107.34	107.78	107.2	107.62	4798500.0
2014-03-05	AADR	ETF	38.5	38.5	38.03	38.03	900.0
2014-03-05	AAXJ	ETF	58.0	58.22	57.91	58.21	656700.0
2014-03-05	ACWI	ETF	57.96	58.06	57.87	57.92	3054800.0
2014-03-05	ACWV	ETF	63.84	63.84	63.65	63.74	11400.0
2014-03-05	ACWX	ETF	46.2315	46.3199	46.18	46.24	76831.0
2014-03-05	ADRE	ETF	35.06	35.233	35.06	35.21	15719.0
2014-03-05	AFK	ETF	31.5	31.5692	31.31	31.55	14591.0
2014-03-05	AGG	ETF	107.83	108.02	107.81	108.01	2852300.0
2014-03-05	AGQ	ETF	73.97	74.69	73.56	73.71	363000.0
2014-03-05	AGZ	ETF	111.62	112.4029	111.6	111.64	200669.0
2014-03-05	AGZD	ETF	25.05	25.05	25.05	25.05	2000.0
2014-03-05	AIA	ETF	45.04	45.276	45.04	45.1974	24639.0
2014-03-05	AIQ	ETF	30.37	31.0	30.37	30.75	7420.0
2014-03-05	AIVI	ETF	48.78	49.16	48.78	49.07	14800.0
2014-03-05	AMJ	ETF	46.29	46.57	46.06	46.35	1264315.0
2014-03-05	AMLP	ETF	87.5	88.0	87.3	87.75	471560.0
2014-03-05	ANGL	ETF	27.64	27.64	27.6	27.6	1400.0
2014-03-05	AOA	ETF	45.22	45.33	45.21	45.27	21600.0
2014-03-05	AOK	ETF	32.41	32.42	32.3704	32.4	23486.0
2014-03-05	AOM	ETF	34.73	34.812	34.73	34.73	41403.0
2014-03-05	AOR	ETF	39.04	39.15	39.04	39.12	95400.0
2014-03-05	ARGT	ETF	19.12	19.12	19.07	19.12	9300.0
2014-03-05	ASEA	ETF	15.62	15.62	15.6	15.61	4900.0
2014-03-05	ASHR	ETF	22.38	22.38	22.25	22.32	76600.0
2014-03-05	ATMP	ETF	27.47	27.62	27.47	27.52	10300.0
2014-03-05	AVIV	ETF	25.86	26.04	25.58	25.69	72826.0
2014-03-05	AWAY	ETF	46.99	47.29	46.055	46.93	822108.0
2014-03-05	BAB	ETF	28.6	28.63	28.511	28.63	154472.0
2014-03-05	BAL	ETF	55.55	55.55	55.31	55.36	5051.0
2014-03-05	BALT	ETF	7.22	7.58	7.18	7.55	1225725.0
2014-03-05	BBH	ETF	104.08	104.08	103.26	103.3	57700.0
2014-03-05	BCM	ETF	41.34	41.37	41.2	41.21	47848.0
2014-03-05	BFOR	ETF	7.7075	7.7075	7.6725	7.7025	124800.0
2014-03-05	BIB	ETF	52.895	52.895	51.61	51.935	314996.0
2014-03-05	BICK	ETF	23.71	23.71	23.71	23.71	208.0
2014-03-05	BIL	ETF	91.54	91.56	91.54	91.56	163600.0
2014-03-05	BIS	ETF	560.4	570.4	560.0	568.4	5904.5
2014-03-05	BIV	ETF	83.52	83.65	83.45	83.6	178500.0
2014-03-05	BIZD	ETF	21.0	21.0	20.83	20.9	8100.0
2014-03-05	BJK	ETF	55.51	55.77	55.22	55.7	24400.0
2014-03-05	BKF	ETF	34.61	34.75	34.46	34.75	890690.0
2014-03-05	BKLN	ETF	24.85	24.87	24.85	24.87	10836200.0
2014-03-05	BLV	ETF	85.4	85.58	85.28	85.48	65100.0
2014-03-05	BMVP	ETF	23.47	23.53	23.45	23.46	44233.0

> showing 50 of 1,069 rows — these rows as CSV

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