PREVIEW / etf_daily / 2014-07-16

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-16.parquet
  size:    45 KB
  rows:    1,104

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-07-16	SPY	ETF	198.11	198.26	197.42	197.96	79986400.0
2014-07-16	QQQ	ETF	96.19	96.3	95.785	95.89	22061998.0
2014-07-16	IWM	ETF	115.05	115.09	113.82	114.24	63433000.0
2014-07-16	DIA	ETF	170.96	171.16	170.66	171.07	3197900.0
2014-07-16	GLD	ETF	125.02	125.47	124.78	124.97	4099800.0
2014-07-16	TLT	ETF	113.0	113.58	112.94	113.46	4615800.0
2014-07-16	AADR	ETF	38.91	38.91	38.91	38.91	2300.0
2014-07-16	AAXJ	ETF	64.12	64.12	63.87	63.87	283100.0
2014-07-16	ACWI	ETF	60.83	60.84	60.65	60.78	563800.0
2014-07-16	ACWV	ETF	67.18	67.44	67.18	67.39	27400.0
2014-07-16	ACWX	ETF	48.23	48.29	48.17	48.26	76925.0
2014-07-16	ADRE	ETF	40.54	40.58	40.31	40.37	18818.0
2014-07-16	AFK	ETF	33.43	33.49	33.25	33.47	18108.0
2014-07-16	AGG	ETF	109.01	109.05	108.96	109.02	725600.0
2014-07-16	AGQ	ETF	68.99	69.6	68.6	69.02	154200.0
2014-07-16	AGZ	ETF	112.42	112.45	112.29	112.406	8400.0
2014-07-16	AGZD	ETF	24.95	25.01	24.9	25.005	22800.0
2014-07-16	AIA	ETF	49.01	49.07	48.96	49.04	12607.0
2014-07-16	AIQ	ETF	29.0	29.26	28.54	28.76	22051.0
2014-07-16	AIRR	ETF	19.02	19.02	18.72	18.72	81300.0
2014-07-16	AIVI	ETF	50.87	50.87	50.53	50.67	12900.0
2014-07-16	ALTL	ETF	35.75	35.75	35.69	35.71	2400.0
2014-07-16	AMJ	ETF	51.5	51.95	51.4001	51.91	569750.0
2014-07-16	AMLP	ETF	94.1	94.55	94.05	94.55	533800.0
2014-07-16	ANGL	ETF	28.05	28.11	28.05	28.05	1000.0
2014-07-16	AOA	ETF	46.95	46.95	46.71	46.84	24300.0
2014-07-16	AOK	ETF	32.93	32.93	32.85	32.8771	33489.0
2014-07-16	AOM	ETF	35.53	35.53	35.41	35.46	31474.0
2014-07-16	AOR	ETF	40.2	40.26	40.1234	40.2	34987.0
2014-07-16	ARGT	ETF	22.59	22.77	22.4	22.66	471600.0
2014-07-16	ASEA	ETF	17.32	17.32	17.25	17.3	1800.0
2014-07-16	ASHR	ETF	22.89	22.89	22.66	22.73	34100.0
2014-07-16	ASHS	ETF	27.37	27.38	27.37	27.37	2500.0
2014-07-16	ATMP	ETF	31.29	31.43	31.21	31.43	12800.0
2014-07-16	AVIV	ETF	28.21	28.23	27.9533	28.1	133515.0
2014-07-16	AWAY	ETF	32.72	32.74	31.96	32.1	651714.0
2014-07-16	BAB	ETF	29.35	29.387	29.22	29.26	88252.0
2014-07-16	BAL	ETF	45.72	45.81	45.41	45.59	5880.0
2014-07-16	BALT	ETF	5.22	5.43	5.19	5.4	769598.0
2014-07-16	BBH	ETF	95.55	95.6	93.58	93.91	138500.0
2014-07-16	BCM	ETF	40.55	40.59	40.4	40.41	16302.0
2014-07-16	BFOR	ETF	7.7975	7.8025	7.7525	7.7775	105600.0
2014-07-16	BIB	ETF	45.005	45.18	43.225	43.49	497636.0
2014-07-16	BICK	ETF	26.6	26.6	26.55	26.55	894.0
2014-07-16	BIL	ETF	91.5	91.52	91.5	91.52	89250.0
2014-07-16	BIS	ETF	586.0	603.6	577.6	601.16	18753.0
2014-07-16	BIV	ETF	84.41	84.48	84.34	84.44	225300.0
2014-07-16	BIZD	ETF	20.5	20.5	20.44	20.46	6900.0
2014-07-16	BJK	ETF	49.82	50.16	49.82	50.12	12600.0
2014-07-16	BKF	ETF	39.72	39.83	39.6131	39.69	47209.0

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

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