PREVIEW / etf_daily / 2014-08-01

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-01.parquet
  size:    45 KB
  rows:    1,112

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-01	SPY	ETF	192.56	193.76	191.57	192.5	189261000.0
2014-08-01	QQQ	ETF	94.83	95.34	94.04	94.67	60707990.0
2014-08-01	IWM	ETF	111.16	111.7	109.86	110.68	67805300.0
2014-08-01	DIA	ETF	164.8	165.51	164.01	164.57	7435100.0
2014-08-01	GLD	ETF	124.54	124.81	124.23	124.38	7397000.0
2014-08-01	TLT	ETF	113.58	114.87	113.05	114.56	14951200.0
2014-08-01	AADR	ETF	37.99	37.99	37.75	37.8	1100.0
2014-08-01	AAXJ	ETF	64.47	64.99	64.42	64.85	297600.0
2014-08-01	ACWI	ETF	59.14	59.51	58.93	59.14	709700.0
2014-08-01	ACWV	ETF	65.81	66.13	65.7	65.85	603100.0
2014-08-01	ACWX	ETF	47.1	47.36	46.96	47.09	454487.0
2014-08-01	ADRE	ETF	40.644	41.07	40.501	40.84	39999.0
2014-08-01	AFK	ETF	33.32	33.38	33.0	33.13	51173.0
2014-08-01	AGG	ETF	108.89	109.19	108.76	109.14	1064400.0
2014-08-01	AGQ	ETF	67.89	67.89	65.64	66.23	166600.0
2014-08-01	AGZ	ETF	112.2	112.345	112.04	112.1401	4364.0
2014-08-01	AGZD	ETF	24.955	24.96	24.75	24.79	118600.0
2014-08-01	AIA	ETF	49.88	50.159	49.7501	50.07	27265.0
2014-08-01	AIQ	ETF	28.69	28.725	27.01	27.57	36416.0
2014-08-01	AIRR	ETF	17.9	17.9	17.52	17.64	163800.0
2014-08-01	AIVI	ETF	49.48	49.5	49.17	49.32	20900.0
2014-08-01	AMJ	ETF	50.34	51.0	49.61	49.99	1424021.0
2014-08-01	AMLP	ETF	92.25	92.5	91.25	91.95	826740.0
2014-08-01	ANGL	ETF	27.56	28.13	27.56	27.85	5000.0
2014-08-01	AOA	ETF	45.8	45.9	45.57	45.75	25300.0
2014-08-01	AOK	ETF	32.57	32.59	32.49	32.58	64918.0
2014-08-01	AOM	ETF	35.02	35.05	34.91	34.96	32713.0
2014-08-01	AOR	ETF	39.5	39.59	39.37	39.5	44136.0
2014-08-01	ARGT	ETF	22.16	22.38	21.5	22.06	49000.0
2014-08-01	ASEA	ETF	17.24	17.28	17.19	17.28	9100.0
2014-08-01	ASHR	ETF	24.56	24.63	24.46	24.59	179500.0
2014-08-01	ASHS	ETF	28.87	28.87	28.67	28.75	900.0
2014-08-01	ATMP	ETF	30.95	30.95	30.29	30.44	63600.0
2014-08-01	AVIV	ETF	28.42	28.46	28.09	28.25	276834.0
2014-08-01	AWAY	ETF	34.77	34.88	33.75	33.83	1505292.0
2014-08-01	BAB	ETF	29.39	29.55	29.35	29.52	103713.0
2014-08-01	BAL	ETF	41.76	42.93	41.76	42.43	26569.0
2014-08-01	BALT	ETF	5.08	5.12	4.94	5.04	672817.0
2014-08-01	BBH	ETF	96.69	97.71	95.5	96.38	158900.0
2014-08-01	BCM	ETF	39.905	39.905	39.87	39.87	1662.0
2014-08-01	BFOR	ETF	7.5475	7.58	7.4925	7.55	170800.0
2014-08-01	BIB	ETF	43.505	45.0475	42.83	43.785	802200.0
2014-08-01	BICK	ETF	26.85	26.85	26.82	26.82	1160.0
2014-08-01	BIL	ETF	91.52	91.52	91.5	91.52	809650.0
2014-08-01	BIS	ETF	590.4	600.8	570.8	587.6	13846.0
2014-08-01	BIV	ETF	84.16	84.46	84.06	84.41	280400.0
2014-08-01	BIZD	ETF	20.0	20.1	19.91	19.99	5300.0
2014-08-01	BJK	ETF	50.6	50.6	50.08	50.34	13600.0
2014-08-01	BKF	ETF	39.42	39.79	39.26	39.66	144380.0
2014-08-01	BKLN	ETF	24.62	24.64	24.55	24.56	6197500.0

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

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