PREVIEW / etf_daily / 2014-08-21

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-21.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-08-21	SPY	ETF	199.09	199.76	198.93	199.5	67791000.0
2014-08-21	QQQ	ETF	98.76	98.95	98.6	98.9	19339477.0
2014-08-21	IWM	ETF	114.88	115.4	113.84	115.2	33018200.0
2014-08-21	DIA	ETF	169.81	170.53	169.69	170.18	2652600.0
2014-08-21	GLD	ETF	122.72	123.24	122.45	122.88	8008800.0
2014-08-21	TLT	ETF	116.07	116.76	116.02	116.64	6790700.0
2014-08-21	AAXJ	ETF	65.68	65.85	65.51	65.56	397700.0
2014-08-21	ACWI	ETF	60.58	60.72	60.53	60.66	1014500.0
2014-08-21	ACWV	ETF	67.88	68.13	67.88	67.94	11300.0
2014-08-21	ACWX	ETF	47.66	47.76	47.5801	47.7	183701.0
2014-08-21	ADRE	ETF	42.83	42.83	42.4701	42.55	8730.0
2014-08-21	AFK	ETF	33.46	33.51	33.32	33.35	37412.0
2014-08-21	AGG	ETF	109.48	109.6	109.45	109.58	775600.0
2014-08-21	AGQ	ETF	60.2	60.75	59.99	60.55	105900.0
2014-08-21	AGZ	ETF	112.8054	113.13	112.5901	112.5901	49096.0
2014-08-21	AGZD	ETF	24.765	24.87	24.73	24.87	2600.0
2014-08-21	AIA	ETF	50.68	50.7499	50.46	50.46	19350.0
2014-08-21	AIQ	ETF	28.48	28.59	27.61	28.4	12339.0
2014-08-21	AIRR	ETF	18.93	19.13	18.8	19.1	8800.0
2014-08-21	AIVI	ETF	49.6	49.86	49.55	49.83	14400.0
2014-08-21	AMJ	ETF	53.69	53.78	53.28	53.52	382708.0
2014-08-21	AMLP	ETF	95.5	95.5	94.9	95.25	505540.0
2014-08-21	ANGL	ETF	28.2	28.2	28.1	28.16	4300.0
2014-08-21	AOA	ETF	46.84	46.97	46.8	46.9	14600.0
2014-08-21	AOK	ETF	32.85	32.94	32.85	32.91	44760.0
2014-08-21	AOM	ETF	35.54	35.57	35.48	35.54	29067.0
2014-08-21	AOR	ETF	40.34	40.37	40.258	40.34	18081.0
2014-08-21	ARGT	ETF	20.94	20.97	20.85	20.85	20300.0
2014-08-21	ASEA	ETF	17.47	17.52	17.47	17.49	5800.0
2014-08-21	ASHR	ETF	24.87	24.87	24.75	24.8	110100.0
2014-08-21	ASHS	ETF	30.69	30.73	30.68	30.69	4600.0
2014-08-21	ATMP	ETF	33.18	33.18	32.46	32.51	13400.0
2014-08-21	AVIV	ETF	28.48	28.78	28.35	28.37	126757.0
2014-08-21	AWAY	ETF	32.94	33.04	32.81	32.99	416085.0
2014-08-21	BAB	ETF	29.53	29.66	29.53	29.6	40701.0
2014-08-21	BAL	ETF	44.29	44.63	44.0	44.1728	17888.0
2014-08-21	BALT	ETF	5.81	6.01	5.8	6.0	516490.0
2014-08-21	BBH	ETF	103.17	103.55	102.19	102.43	43200.0
2014-08-21	BCHP	ETF	20.3	20.32	20.29	20.31	2201.0
2014-08-21	BCM	ETF	39.2999	39.2999	39.2999	39.2999	101.0
2014-08-21	BFOR	ETF	7.815	7.8475	7.7875	7.8425	110000.0
2014-08-21	BIB	ETF	49.75	50.0	48.5	48.725	644680.0
2014-08-21	BICK	ETF	27.17	27.17	27.13	27.13	2752.0
2014-08-21	BIL	ETF	91.5	91.52	91.5	91.52	214700.0
2014-08-21	BIS	ETF	516.0	526.8	512.048	524.4	9384.5
2014-08-21	BIV	ETF	84.92	85.04	84.87	84.97	266100.0
2014-08-21	BIZD	ETF	20.52	20.52	20.44	20.49	23200.0
2014-08-21	BJK	ETF	49.03	49.1	48.85	49.1	11200.0
2014-08-21	BKF	ETF	41.26	41.26	41.0	41.05	57913.0
2014-08-21	BKLN	ETF	24.6	24.68	24.6	24.68	2704500.0

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

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