PREVIEW / etf_daily / 2014-07-31

all etf daily files

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

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-31	SPY	ETF	195.61	195.78	192.97	193.09	183479000.0
2014-07-31	QQQ	ETF	96.2	96.34	94.88	95.02	50047926.0
2014-07-31	IWM	ETF	112.63	112.99	111.05	111.19	61507700.0
2014-07-31	DIA	ETF	167.27	167.43	165.29	165.29	9038800.0
2014-07-31	GLD	ETF	123.85	124.07	123.23	123.39	9896500.0
2014-07-31	TLT	ETF	113.53	114.58	113.47	113.98	18254000.0
2014-07-31	AADR	ETF	38.5	38.5	37.91	38.0	2900.0
2014-07-31	AAXJ	ETF	65.6	65.6	64.4	64.49	342500.0
2014-07-31	ACWI	ETF	60.06	60.06	59.37	59.39	1120300.0
2014-07-31	ACWV	ETF	66.5	66.52	65.79	65.8	549500.0
2014-07-31	ACWX	ETF	47.68	47.69	47.27	47.28	782016.0
2014-07-31	ADRE	ETF	41.15	41.2237	40.685	40.82	17280.0
2014-07-31	AFK	ETF	33.37	34.5	33.2732	33.42	49373.0
2014-07-31	AGG	ETF	108.9	109.09	108.88	108.93	1066400.0
2014-07-31	AGQ	ETF	67.61	67.65	66.29	66.59	203800.0
2014-07-31	AGZ	ETF	112.23	112.31	112.22	112.25	16110.0
2014-07-31	AGZD	ETF	24.955	24.955	24.955	24.955	400.0
2014-07-31	AIA	ETF	50.44	50.75	49.9624	50.01	20871.0
2014-07-31	AIQ	ETF	29.0	29.46	27.83	28.55	88382.0
2014-07-31	AIRR	ETF	18.21	18.22	17.69	17.73	29000.0
2014-07-31	AIVI	ETF	50.08	50.08	49.56	49.63	18000.0
2014-07-31	ALTL	ETF	35.35	35.35	34.876	34.876	11358.0
2014-07-31	AMJ	ETF	51.21	51.2899	50.4	50.4	735486.0
2014-07-31	AMLP	ETF	93.45	93.55	92.35	92.4	613840.0
2014-07-31	ANGL	ETF	28.1	28.1	27.84	27.93	1900.0
2014-07-31	AOA	ETF	46.3	46.3	45.81	45.84	60800.0
2014-07-31	AOK	ETF	32.65	32.6753	32.5701	32.58	22903.0
2014-07-31	AOM	ETF	35.18	35.19	34.98	34.98	55049.0
2014-07-31	AOR	ETF	39.86	39.86	39.48	39.48	34876.0
2014-07-31	ARGT	ETF	22.25	22.45	21.54	22.25	82100.0
2014-07-31	ASEA	ETF	17.32	17.32	17.17	17.21	17200.0
2014-07-31	ASHR	ETF	24.6	24.75	24.54	24.63	570200.0
2014-07-31	ASHS	ETF	29.02	29.02	28.82	28.92	11700.0
2014-07-31	ATMP	ETF	31.57	31.57	30.7	30.72	83400.0
2014-07-31	AVIV	ETF	28.73	28.73	28.26	28.45	204277.0
2014-07-31	AWAY	ETF	35.16	35.63	34.62	34.72	1041461.0
2014-07-31	BAB	ETF	29.37	29.45	29.32	29.38	85812.0
2014-07-31	BAL	ETF	42.59	42.6544	41.78	42.12	32679.0
2014-07-31	BALT	ETF	4.98	5.31	4.41	5.09	569845.0
2014-07-31	BBH	ETF	98.58	98.58	96.51	96.84	93800.0
2014-07-31	BCHP	ETF	20.24	20.24	20.23	20.23	951.0
2014-07-31	BCM	ETF	40.68	40.68	40.086	40.086	3850.0
2014-07-31	BFOR	ETF	7.675	7.675	7.5625	7.5675	267600.0
2014-07-31	BIB	ETF	45.525	45.675	43.69	43.9525	715332.0
2014-07-31	BICK	ETF	27.0	27.0	26.65	26.7	2299.0
2014-07-31	BIL	ETF	91.52	91.52	91.5	91.5	185050.0
2014-07-31	BIS	ETF	567.6	589.2	564.16	586.0	14972.5
2014-07-31	BIV	ETF	84.12	84.32	84.0	84.23	297600.0
2014-07-31	BIZD	ETF	20.38	20.38	19.98	20.0	38000.0
2014-07-31	BJK	ETF	50.76	50.96	50.54	50.54	9900.0

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

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