PREVIEW / etf_daily / 2014-01-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-01-23.parquet
  size:    43 KB
  rows:    1,072

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-01-23	SPY	ETF	183.37	183.4	181.82	182.79	132496900.0
2014-01-23	QQQ	ETF	88.5	88.52	87.86	88.48	35077428.0
2014-01-23	IWM	ETF	116.72	116.78	115.66	116.42	36057500.0
2014-01-23	DIA	ETF	162.43	162.43	161.07	161.71	9456000.0
2014-01-23	GLD	ETF	120.97	122.02	120.97	121.79	11028200.0
2014-01-23	TLT	ETF	105.88	107.09	105.88	106.79	12960600.0
2014-01-23	AADR	ETF	37.36	37.37	37.17	37.17	2000.0
2014-01-23	AAXJ	ETF	57.73	57.83	56.97	57.3	996500.0
2014-01-23	ACWI	ETF	57.16	57.16	56.59	56.85	2046500.0
2014-01-23	ACWV	ETF	62.46	62.68	62.23	62.46	41400.0
2014-01-23	ACWX	ETF	45.87	45.89	45.5432	45.72	368457.0
2014-01-23	ADRE	ETF	35.43	35.43	34.69	34.82	15877.0
2014-01-23	AFK	ETF	31.29	31.479	31.03	31.1964	34293.0
2014-01-23	AGG	ETF	107.27	107.52	107.26	107.35	1901200.0
2014-01-23	AGQ	ETF	67.52	68.44	66.24	66.44	730800.0
2014-01-23	AGZ	ETF	110.965	111.262	110.965	111.21	10040.0
2014-01-23	AGZD	ETF	25.1	25.1	24.9	24.9	13600.0
2014-01-23	AIA	ETF	45.52	45.52	44.73	44.91	20647.0
2014-01-23	AIQ	ETF	27.59	28.14	27.59	27.85	30184.0
2014-01-23	AIVI	ETF	47.5	47.71	47.42	47.5	85100.0
2014-01-23	AMJ	ETF	46.25	46.5	46.0701	46.29	773711.0
2014-01-23	AMLP	ETF	88.6	88.85	88.4	88.65	473740.0
2014-01-23	ANGL	ETF	27.24	27.24	27.15	27.15	1500.0
2014-01-23	AOA	ETF	44.55	44.55	44.23	44.35	41900.0
2014-01-23	AOK	ETF	32.12	32.12	32.03	32.07	122764.0
2014-01-23	AOM	ETF	34.4	34.4	34.2501	34.32	39425.0
2014-01-23	AOR	ETF	38.5	38.5	38.3275	38.42	18624.0
2014-01-23	ARGT	ETF	19.18	19.18	18.25	18.25	7800.0
2014-01-23	ASEA	ETF	15.01	15.01	14.91	14.94	14300.0
2014-01-23	ASHR	ETF	23.5	23.52	23.16	23.21	260100.0
2014-01-23	ATMP	ETF	27.14	27.4	27.14	27.18	184200.0
2014-01-23	AVIV	ETF	24.43	24.612	24.14	24.43	129141.0
2014-01-23	AWAY	ETF	43.3	43.3899	41.51	41.8	821020.0
2014-01-23	BAB	ETF	27.81	27.9436	27.81	27.9	73597.0
2014-01-23	BAL	ETF	55.21	55.4301	54.59	54.72	17681.0
2014-01-23	BALT	ETF	5.9	5.9	5.69	5.76	1112617.0
2014-01-23	BBH	ETF	98.73	98.85	97.63	98.85	138900.0
2014-01-23	BCM	ETF	39.26	39.26	39.129	39.129	22547.0
2014-01-23	BFOR	ETF	7.4425	7.4425	7.3525	7.4	294400.0
2014-01-23	BIB	ETF	46.5575	46.6	45.5	46.4225	530752.0
2014-01-23	BICK	ETF	23.76	23.76	23.4699	23.4699	1382.0
2014-01-23	BIL	ETF	91.54	91.56	91.54	91.56	174600.0
2014-01-23	BIS	ETF	668.8	677.6	663.2	663.2	2422.5
2014-01-23	BIV	ETF	82.8	83.0	82.77	82.85	584700.0
2014-01-23	BIZD	ETF	21.4	21.43	21.32	21.42	14100.0
2014-01-23	BJK	ETF	53.29	53.29	52.36	52.68	34400.0
2014-01-23	BKF	ETF	36.05	36.05	35.28	35.44	159329.0
2014-01-23	BKLN	ETF	24.94	24.95	24.93	24.93	1757100.0
2014-01-23	BLV	ETF	84.13	84.64	84.06	84.43	39300.0
2014-01-23	BMVP	ETF	22.43	22.7347	22.43	22.6197	6279.0

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

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