PREVIEW / etf_daily / 2014-09-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-29.parquet
  size:    46 KB
  rows:    1,130

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-09-29	SPY	ETF	196.2	197.89	196.05	197.54	95112000.0
2014-09-29	QQQ	ETF	97.8	98.92	97.75	98.65	33342673.0
2014-09-29	IWM	ETF	109.82	111.35	109.72	111.03	30619000.0
2014-09-29	DIA	ETF	169.18	170.58	168.94	170.33	5167800.0
2014-09-29	GLD	ETF	117.27	117.4	116.9	117.03	4049500.0
2014-09-29	TLT	ETF	117.0	117.17	116.66	116.93	6791800.0
2014-09-29	AADR	ETF	37.34	37.76	37.34	37.43	6300.0
2014-09-29	AAXJ	ETF	61.47	61.57	61.26	61.41	572500.0
2014-09-29	ACWI	ETF	58.77	59.13	58.69	59.05	754100.0
2014-09-29	ACWV	ETF	66.5	66.81	66.4	66.76	35700.0
2014-09-29	ACWX	ETF	45.47	45.64	45.38	45.56	119396.0
2014-09-29	ADRE	ETF	39.47	39.58	39.14	39.44	40193.0
2014-09-29	AFK	ETF	31.03	31.468	31.0101	31.44	32451.0
2014-09-29	AGG	ETF	109.16	109.24	109.06	109.18	7243700.0
2014-09-29	AGQ	ETF	48.85	49.15	48.31	48.61	151500.0
2014-09-29	AGZ	ETF	112.23	112.5193	112.164	112.44	24751.0
2014-09-29	AGZD	ETF	24.755	24.91	24.755	24.9	14000.0
2014-09-29	AIA	ETF	46.86	46.87	46.54	46.81	27771.0
2014-09-29	AIQ	ETF	24.01	24.01	22.99	23.58	19518.0
2014-09-29	AIRR	ETF	18.466	18.63	18.466	18.59	10000.0
2014-09-29	AIVI	ETF	46.71	46.97	46.69	46.9	17600.0
2014-09-29	ALTL	ETF	35.3	35.3	35.3	35.3	200.0
2014-09-29	AMJ	ETF	52.35	52.895	52.33	52.86	1522933.0
2014-09-29	AMLP	ETF	94.5	95.4	94.5	95.35	517540.0
2014-09-29	ANGL	ETF	27.45	27.57	27.43	27.47	1800.0
2014-09-29	AOA	ETF	45.54	45.74	45.48	45.73	14500.0
2014-09-29	AOK	ETF	32.4	32.49	32.4	32.46	17745.0
2014-09-29	AOM	ETF	34.9	34.99	34.84	34.93	66604.0
2014-09-29	AOR	ETF	39.44	39.5799	39.41	39.51	26303.0
2014-09-29	ARGT	ETF	21.17	21.19	21.1	21.19	5700.0
2014-09-29	ASEA	ETF	16.75	16.81	16.74	16.74	3500.0
2014-09-29	ASHR	ETF	25.49	25.49	25.25	25.35	663700.0
2014-09-29	ASHS	ETF	34.78	35.53	34.78	35.52	35700.0
2014-09-29	ATMP	ETF	32.01	32.24	31.96	32.22	6800.0
2014-09-29	AVIV	ETF	26.64	26.97	26.48	26.5	302752.0
2014-09-29	AWAY	ETF	33.21	34.44	33.0832	34.4	924339.0
2014-09-29	BAB	ETF	29.65	29.75	29.63	29.72	222697.0
2014-09-29	BAL	ETF	41.44	41.74	41.17	41.19	34162.0
2014-09-29	BALT	ETF	4.16	4.34	4.16	4.26	490375.0
2014-09-29	BAR	ETF	3.114	3.114	3.096	3.1064	18070.0
2014-09-29	BBH	ETF	105.84	107.59	105.61	106.93	44200.0
2014-09-29	BCHP	ETF	19.09	19.09	19.017	19.09	498.0
2014-09-29	BCM	ETF	36.94	37.271	36.94	37.17	3168.0
2014-09-29	BFOR	ETF	7.5825	7.6375	7.5675	7.63	90800.0
2014-09-29	BIB	ETF	51.91	53.629	51.635	52.965	261294.0
2014-09-29	BICK	ETF	25.19	25.19	25.11	25.11	1960.0
2014-09-29	BIL	ETF	91.52	91.52	91.5	91.5	139600.0
2014-09-29	BIS	ETF	480.8	485.2	466.4	473.6	8936.0
2014-09-29	BIV	ETF	84.21	84.27	84.13	84.21	788200.0
2014-09-29	BIZD	ETF	19.67	19.8	19.65	19.76	7400.0

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

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