PREVIEW / etf_daily / 2014-03-27

all etf daily files

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

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-27	SPY	ETF	184.75	185.34	183.9	184.58	142383000.0
2014-03-27	QQQ	ETF	87.27	87.64	86.4	86.879	64784488.0
2014-03-27	IWM	ETF	114.71	115.38	113.69	114.4	65234900.0
2014-03-27	DIA	ETF	162.25	162.68	161.54	162.28	7713700.0
2014-03-27	GLD	ETF	125.06	125.29	124.21	124.59	7312300.0
2014-03-27	TLT	ETF	109.64	110.39	109.42	109.99	9772200.0
2014-03-27	AADR	ETF	37.14	37.51	37.14	37.51	1300.0
2014-03-27	AAXJ	ETF	57.87	58.39	57.87	58.32	551400.0
2014-03-27	ACWI	ETF	57.25	57.43	57.06	57.32	2952600.0
2014-03-27	ACWV	ETF	63.1	63.67	63.1	63.45	24100.0
2014-03-27	ACWX	ETF	45.8	46.02	45.75	45.95	295177.0
2014-03-27	ADRE	ETF	35.58	36.0583	35.57	36.03	9711.0
2014-03-27	AFK	ETF	31.31	31.37	31.15	31.37	48827.0
2014-03-27	AGG	ETF	107.87	108.08	107.85	108.06	1299200.0
2014-03-27	AGQ	ETF	63.69	64.01	63.05	63.87	221400.0
2014-03-27	AGZ	ETF	111.5	111.65	111.5	111.6	6616.0
2014-03-27	AIA	ETF	45.19	45.52	45.19	45.479	27898.0
2014-03-27	AIQ	ETF	33.78	34.475	33.59	33.81	65599.0
2014-03-27	AIRR	ETF	19.31	19.37	19.15	19.21	22000.0
2014-03-27	AIVI	ETF	48.76	48.76	48.51	48.59	43700.0
2014-03-27	ALTL	ETF	33.34	33.34	33.34	33.34	2000.0
2014-03-27	AMJ	ETF	45.68	46.07	45.56	46.04	369595.0
2014-03-27	AMLP	ETF	87.25	87.5	87.05	87.4	659020.0
2014-03-27	ANGL	ETF	27.6	27.6	27.53	27.6	3100.0
2014-03-27	AOA	ETF	44.79	44.87	44.66	44.78	19100.0
2014-03-27	AOK	ETF	32.17	32.24	32.17	32.2101	11090.0
2014-03-27	AOM	ETF	34.58	34.61	34.51	34.55	20030.0
2014-03-27	AOR	ETF	38.79	38.84	38.7096	38.79	35156.0
2014-03-27	ARGT	ETF	19.15	19.33	18.93	19.25	4900.0
2014-03-27	ASEA	ETF	15.7	15.79	15.7	15.75	24700.0
2014-03-27	ASHR	ETF	21.77	21.92	21.7	21.92	69900.0
2014-03-27	ATMP	ETF	27.23	27.44	27.23	27.44	892100.0
2014-03-27	AVIV	ETF	23.89	24.51	23.67	24.1	110479.0
2014-03-27	AWAY	ETF	38.64	38.87	37.65	38.25	1570561.0
2014-03-27	BAB	ETF	28.79	28.8699	28.7144	28.83	71296.0
2014-03-27	BAL	ETF	58.07	58.24	57.45	57.832	11760.0
2014-03-27	BALT	ETF	5.97	6.21	5.85	6.08	426756.0
2014-03-27	BBH	ETF	90.11	91.97	88.38	90.71	282800.0
2014-03-27	BFOR	ETF	7.4525	7.4925	7.4125	7.4475	176800.0
2014-03-27	BIB	ETF	39.12	40.815	37.415	39.995	925348.0
2014-03-27	BICK	ETF	23.86	24.13	23.86	24.13	3460.0
2014-03-27	BIL	ETF	91.54	91.56	91.54	91.54	66100.0
2014-03-27	BIS	ETF	730.0	765.2	701.204	720.0	23207.0
2014-03-27	BIV	ETF	83.34	83.54	83.32	83.46	309500.0
2014-03-27	BIZD	ETF	20.38	20.53	20.32	20.48	8300.0
2014-03-27	BJK	ETF	50.16	50.3	49.81	50.3	26700.0
2014-03-27	BKF	ETF	35.07	35.51	35.07	35.47	52948.0
2014-03-27	BKLN	ETF	24.81	24.82	24.8	24.82	931600.0
2014-03-27	BLV	ETF	86.86	87.35	86.7	87.17	101800.0
2014-03-27	BMVP	ETF	23.4833	23.4833	23.2498	23.2767	3843.0

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

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