PREVIEW / etf_daily / 2014-08-18

all etf daily files

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

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-18	SPY	ETF	196.8	197.45	196.69	197.36	75424000.0
2014-08-18	QQQ	ETF	97.89	98.24	97.77	98.15	38938349.0
2014-08-18	IWM	ETF	114.5	115.14	114.09	115.04	33287300.0
2014-08-18	DIA	ETF	167.25	168.12	167.23	168.06	2975200.0
2014-08-18	GLD	ETF	124.78	125.08	124.65	124.96	4952500.0
2014-08-18	TLT	ETF	117.21	117.3	116.39	116.54	7595300.0
2014-08-18	AAXJ	ETF	65.56	65.76	65.44	65.75	366800.0
2014-08-18	ACWI	ETF	60.14	60.24	60.04	60.24	394900.0
2014-08-18	ACWV	ETF	67.66	67.71	67.55	67.61	17600.0
2014-08-18	ACWX	ETF	47.46	47.54	47.39	47.5	217850.0
2014-08-18	ADRE	ETF	42.07	42.48	42.07	42.48	45871.0
2014-08-18	AFK	ETF	33.51	33.58	33.2901	33.53	30370.0
2014-08-18	AGG	ETF	109.79	109.82	109.62	109.66	1424400.0
2014-08-18	AGQ	ETF	61.45	61.98	61.15	61.84	99600.0
2014-08-18	AGZ	ETF	112.26	113.11	112.26	112.7901	15289.0
2014-08-18	AGZD	ETF	24.885	24.91	24.885	24.895	6000.0
2014-08-18	AIA	ETF	50.5	50.86	50.33	50.84	40335.0
2014-08-18	AIQ	ETF	28.42	28.85	28.42	28.71	36637.0
2014-08-18	AIRR	ETF	19.07	19.08	18.94	19.07	90700.0
2014-08-18	AIVI	ETF	49.55	49.74	49.46	49.67	14000.0
2014-08-18	ALTL	ETF	35.63	35.63	35.63	35.63	189.0
2014-08-18	AMJ	ETF	53.07	53.08	52.83	52.94	231399.0
2014-08-18	AMLP	ETF	94.75	94.75	94.45	94.65	448660.0
2014-08-18	ANGL	ETF	28.15	28.15	27.96	28.12	1900.0
2014-08-18	AOA	ETF	46.41	46.65	46.41	46.61	12400.0
2014-08-18	AOK	ETF	32.8	32.87	32.8	32.85	44564.0
2014-08-18	AOM	ETF	35.36	35.45	35.34	35.41	26779.0
2014-08-18	AOR	ETF	39.99	40.16	39.99	40.14	58543.0
2014-08-18	ARGT	ETF	21.05	21.45	21.05	21.42	18200.0
2014-08-18	ASEA	ETF	17.51	17.53	17.49	17.52	1400.0
2014-08-18	ASHR	ETF	25.23	25.23	25.09	25.21	218600.0
2014-08-18	ASHS	ETF	30.97	30.97	30.71	30.74	10200.0
2014-08-18	ATMP	ETF	32.25	32.3	32.18	32.26	24900.0
2014-08-18	AVIV	ETF	28.08	28.14	27.94	28.1	155141.0
2014-08-18	AWAY	ETF	33.19	33.3	32.965	33.25	778461.0
2014-08-18	BAB	ETF	29.6	29.62	29.51	29.55	55858.0
2014-08-18	BAL	ETF	43.04	43.06	42.82	42.93	26882.0
2014-08-18	BALT	ETF	5.87	6.018	5.83	5.94	307333.0
2014-08-18	BBH	ETF	102.72	103.64	102.72	103.11	148800.0
2014-08-18	BCM	ETF	39.2	39.2238	39.188	39.2	1987.0
2014-08-18	BFOR	ETF	7.73	7.7825	7.73	7.765	59600.0
2014-08-18	BIB	ETF	49.2	49.825	48.935	49.355	619300.0
2014-08-18	BICK	ETF	27.25	27.25	27.25	27.25	312.0
2014-08-18	BIL	ETF	91.5	91.52	91.5	91.5	526850.0
2014-08-18	BIS	ETF	520.0	522.0	512.48	518.4	14607.0
2014-08-18	BIV	ETF	85.12	85.15	84.99	85.01	188900.0
2014-08-18	BIZD	ETF	20.38	20.48	20.38	20.44	7600.0
2014-08-18	BJK	ETF	48.62	48.95	48.6	48.95	14100.0
2014-08-18	BKF	ETF	40.9	40.98	40.76	40.88	349928.0
2014-08-18	BKLN	ETF	24.53	24.54	24.52	24.53	2888700.0

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

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