PREVIEW / etf_daily / 2014-03-13

all etf daily files

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

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-13	SPY	ETF	187.84	187.99	184.66	185.18	155014300.0
2014-03-13	QQQ	ETF	90.9	90.93	88.87	89.28	48541951.0
2014-03-13	IWM	ETF	118.85	118.96	116.38	117.05	53542800.0
2014-03-13	DIA	ETF	163.74	164.03	160.78	161.05	9500500.0
2014-03-13	GLD	ETF	131.69	132.54	131.56	132.21	8007700.0
2014-03-13	TLT	ETF	106.7	108.53	106.65	108.5	11815500.0
2014-03-13	AAXJ	ETF	57.46	57.57	56.36	56.59	461500.0
2014-03-13	ACWI	ETF	57.58	57.7	56.55	56.69	847400.0
2014-03-13	ACWV	ETF	63.83	63.83	63.06	63.17	45300.0
2014-03-13	ACWX	ETF	45.75	45.84	44.85	44.94	164423.0
2014-03-13	ADRE	ETF	34.7	34.7	33.95	33.98	18692.0
2014-03-13	AFK	ETF	31.75	31.75	30.91	31.01	133152.0
2014-03-13	AGG	ETF	107.57	108.06	107.55	107.98	660900.0
2014-03-13	AGQ	ETF	73.64	74.78	73.44	73.56	540700.0
2014-03-13	AGZ	ETF	112.49	112.49	111.5401	111.79	24259.0
2014-03-13	AIA	ETF	44.53	44.53	43.82	43.87	15871.0
2014-03-13	AIQ	ETF	30.06	30.06	28.59	29.59	32017.0
2014-03-13	AIRR	ETF	20.19	20.19	19.44	19.52	8800.0
2014-03-13	AIVI	ETF	48.81	48.98	47.76	47.94	48800.0
2014-03-13	ALTL	ETF	33.49	33.49	33.49	33.49	200.0
2014-03-13	AMJ	ETF	45.89	45.89	45.35	45.55	596437.0
2014-03-13	AMLP	ETF	87.25	87.25	86.55	86.7	434020.0
2014-03-13	ANGL	ETF	27.53	27.55	27.43	27.55	3700.0
2014-03-13	AOA	ETF	45.1	45.1	44.39	44.43	28200.0
2014-03-13	AOK	ETF	32.32	32.32	32.1	32.138	18992.0
2014-03-13	AOM	ETF	34.6	34.6899	34.42	34.42	93565.0
2014-03-13	AOR	ETF	38.92	38.94	38.5	38.56	25572.0
2014-03-13	ARGT	ETF	18.81	18.84	18.58	18.58	4400.0
2014-03-13	ASEA	ETF	15.51	15.52	15.3	15.35	12600.0
2014-03-13	ASHR	ETF	21.95	22.0	21.72	21.79	302000.0
2014-03-13	ATMP	ETF	27.33	27.33	27.0	27.08	11100.0
2014-03-13	AVIV	ETF	25.18	25.331	24.75	25.03	162023.0
2014-03-13	AWAY	ETF	44.95	45.3899	42.78	43.23	1447405.0
2014-03-13	BAB	ETF	28.66	28.83	28.55	28.81	98371.0
2014-03-13	BAL	ETF	57.83	58.228	57.21	57.29	25189.0
2014-03-13	BALT	ETF	7.05	7.12	6.78	6.86	719319.0
2014-03-13	BBH	ETF	101.38	101.47	97.79	98.34	282900.0
2014-03-13	BCM	ETF	40.93	40.95	40.694	40.84	5851.0
2014-03-13	BFOR	ETF	7.665	7.6775	7.515	7.545	217600.0
2014-03-13	BIB	ETF	49.765	49.825	46.14	46.81	698764.0
2014-03-13	BICK	ETF	23.25	23.25	22.78	22.78	15858.0
2014-03-13	BIL	ETF	91.54	91.56	91.54	91.54	74750.0
2014-03-13	BIS	ETF	588.8	632.796	587.2	626.2	10106.5
2014-03-13	BIV	ETF	83.22	83.72	83.17	83.67	187300.0
2014-03-13	BIZD	ETF	20.99	21.0	20.69	20.73	25800.0
2014-03-13	BJK	ETF	54.67	54.67	53.24	53.44	13400.0
2014-03-13	BKF	ETF	33.7	33.79	32.91	33.04	80092.0
2014-03-13	BKLN	ETF	24.87	24.87	24.85	24.85	1896200.0
2014-03-13	BLV	ETF	84.87	85.96	84.87	85.78	73900.0
2014-03-13	BMVP	ETF	23.63	23.63	23.19	23.26	5606.0

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

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