PREVIEW / etf_daily / 2014-02-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-03.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-02-03	SPY	ETF	177.97	178.37	173.83	174.17	254837100.0
2014-02-03	QQQ	ETF	86.14	86.5	84.07	84.29	65617206.0
2014-02-03	IWM	ETF	111.87	112.2	108.15	108.65	91686000.0
2014-02-03	DIA	ETF	156.57	156.76	153.25	153.53	18172800.0
2014-02-03	GLD	ETF	120.47	122.11	120.32	121.32	9267300.0
2014-02-03	TLT	ETF	107.79	109.34	107.61	109.32	20780300.0
2014-02-03	AADR	ETF	35.8	35.87	35.5	35.5	800.0
2014-02-03	AAXJ	ETF	55.67	55.77	54.63	54.75	743200.0
2014-02-03	ACWI	ETF	54.97	54.97	53.73	53.78	1622900.0
2014-02-03	ACWV	ETF	61.13	61.13	60.01	60.01	104500.0
2014-02-03	ACWX	ETF	43.85	43.9	42.946	42.97	549047.0
2014-02-03	ADRE	ETF	33.54	33.63	32.75	32.75	19007.0
2014-02-03	AFK	ETF	29.85	30.0799	29.28	29.28	67868.0
2014-02-03	AGG	ETF	107.78	108.23	107.71	108.23	1976100.0
2014-02-03	AGQ	ETF	62.03	63.85	61.73	62.06	870300.0
2014-02-03	AGZ	ETF	111.41	112.13	111.41	111.82	29364.0
2014-02-03	AIA	ETF	43.71	43.71	42.775	42.9194	41328.0
2014-02-03	AIQ	ETF	28.97	29.76	27.65	27.94	35310.0
2014-02-03	AIVI	ETF	45.57	45.79	44.84	44.95	25800.0
2014-02-03	ALTL	ETF	31.34	31.34	31.26	31.26	700.0
2014-02-03	AMJ	ETF	46.69	47.0	45.9301	46.25	529577.0
2014-02-03	AMLP	ETF	89.0	89.4	88.2	88.65	666180.0
2014-02-03	ANGL	ETF	26.9	26.91	26.79	26.8	35000.0
2014-02-03	AOA	ETF	43.38	43.38	42.3	42.32	61900.0
2014-02-03	AOK	ETF	31.79	31.79	31.546	31.59	25425.0
2014-02-03	AOM	ETF	33.79	33.8199	33.5	33.54	46165.0
2014-02-03	AOR	ETF	37.69	37.88	37.11	37.17	54629.0
2014-02-03	ARGT	ETF	17.14	17.16	16.9	16.9	17000.0
2014-02-03	ASEA	ETF	14.65	14.72	14.42	14.44	12600.0
2014-02-03	ASHR	ETF	22.83	22.83	22.41	22.5	292800.0
2014-02-03	ATMP	ETF	27.28	27.44	27.1	27.17	16900.0
2014-02-03	AVIV	ETF	24.32	24.75	23.71	23.91	126976.0
2014-02-03	AWAY	ETF	40.94	41.02	38.78	39.22	1477773.0
2014-02-03	BAB	ETF	28.22	28.34	28.12	28.34	135069.0
2014-02-03	BAL	ETF	53.7082	53.8316	53.28	53.28	13865.0
2014-02-03	BALT	ETF	5.72	5.83	5.39	5.44	549901.0
2014-02-03	BBH	ETF	96.56	97.42	93.92	94.25	206400.0
2014-02-03	BCM	ETF	38.77	38.85	38.71	38.8	275750.0
2014-02-03	BFOR	ETF	7.175	7.185	6.955	6.9625	845600.0
2014-02-03	BIB	ETF	44.18	44.41	40.935	41.37	747356.0
2014-02-03	BICK	ETF	22.2	22.2	21.94	21.9615	5002.0
2014-02-03	BIL	ETF	91.56	91.56	91.54	91.54	1180450.0
2014-02-03	BIS	ETF	697.6	736.8	681.628	730.8	4232.5
2014-02-03	BIV	ETF	83.32	83.74	83.19	83.74	274400.0
2014-02-03	BIZD	ETF	20.91	20.91	20.4	20.4	10200.0
2014-02-03	BJK	ETF	51.39	51.39	50.01	50.13	49900.0
2014-02-03	BKF	ETF	34.03	34.04	33.28	33.29	113391.0
2014-02-03	BKLN	ETF	24.91	24.91	24.88	24.89	2197600.0
2014-02-03	BLV	ETF	85.55	86.26	85.25	86.21	526900.0
2014-02-03	BMVP	ETF	21.8667	21.8667	21.472	21.4762	3618.0

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

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