PREVIEW / etf_daily / 2014-09-30

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-30.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-30	SPY	ETF	197.69	198.3	196.61	197.02	131302000.0
2014-09-30	QQQ	ETF	98.92	99.3	98.32	98.79	41834324.0
2014-09-30	IWM	ETF	110.92	111.03	109.31	109.35	55596900.0
2014-09-30	DIA	ETF	170.45	171.1	169.8	170.07	5492800.0
2014-09-30	GLD	ETF	116.54	117.35	115.85	116.21	10170100.0
2014-09-30	TLT	ETF	116.66	117.04	116.13	116.27	7277500.0
2014-09-30	AADR	ETF	37.27	37.55	37.1	37.36	5400.0
2014-09-30	AAXJ	ETF	61.3	61.44	61.14	61.32	593300.0
2014-09-30	ACWI	ETF	58.94	59.18	58.74	58.9	1182400.0
2014-09-30	ACWV	ETF	66.52	66.87	66.51	66.72	18200.0
2014-09-30	ACWX	ETF	45.47	45.6098	45.33	45.48	249400.0
2014-09-30	ADRE	ETF	39.18	39.31	38.88	39.211	48178.0
2014-09-30	AFK	ETF	31.41	31.53	31.27	31.39	11072.0
2014-09-30	AGG	ETF	109.19	109.28	109.09	109.11	2335400.0
2014-09-30	AGQ	ETF	47.29	48.0	45.2	46.15	497300.0
2014-09-30	AGZ	ETF	112.3	112.58	112.192	112.2901	9534.0
2014-09-30	AGZD	ETF	24.91	24.925	24.82	24.9	46000.0
2014-09-30	AIA	ETF	46.67	46.7098	46.55	46.67	41291.0
2014-09-30	AIQ	ETF	23.41	23.418	22.32	22.61	37973.0
2014-09-30	AIRR	ETF	18.45	18.585	18.354	18.354	32700.0
2014-09-30	AIVI	ETF	46.74	46.91	46.63	46.8	14500.0
2014-09-30	ALTL	ETF	35.49	35.54	35.34	35.34	14032.0
2014-09-30	AMJ	ETF	52.89	53.18	52.36	53.08	1178920.0
2014-09-30	AMLP	ETF	95.45	95.95	94.6	95.85	566360.0
2014-09-30	ANGL	ETF	27.52	27.75	27.51	27.75	8100.0
2014-09-30	AOA	ETF	45.74	45.78	45.51	45.57	28800.0
2014-09-30	AOK	ETF	32.46	32.52	32.422	32.46	45860.0
2014-09-30	AOM	ETF	34.98	35.01	34.8901	34.92	52068.0
2014-09-30	AOR	ETF	39.5	39.62	39.4102	39.47	57594.0
2014-09-30	ARGT	ETF	21.09	21.19	20.97	21.12	26900.0
2014-09-30	ARKQ	ETF	20.02	20.02	19.82	19.82	7303.0
2014-09-30	ARKW	ETF	20.06	20.06	19.92	19.99	6001.0
2014-09-30	ASEA	ETF	16.76	16.78	16.71	16.78	4400.0
2014-09-30	ASHR	ETF	25.47	25.78	25.36	25.77	1031600.0
2014-09-30	ASHS	ETF	35.45	35.49	34.6	34.6	11900.0
2014-09-30	ATMP	ETF	31.95	32.33	31.95	32.33	141600.0
2014-09-30	AVIV	ETF	26.49	26.65	26.23	26.35	462415.0
2014-09-30	AWAY	ETF	34.43	35.645	34.21	35.5	2042148.0
2014-09-30	BAB	ETF	29.67	29.734	29.6	29.65	142723.0
2014-09-30	BAL	ETF	40.9001	41.2306	40.841	40.9013	22049.0
2014-09-30	BALT	ETF	4.24	4.33	4.12	4.14	430209.0
2014-09-30	BAR	ETF	3.118	3.118	3.013	3.025	347150.0
2014-09-30	BBH	ETF	106.93	107.11	105.54	105.84	49100.0
2014-09-30	BCHP	ETF	19.0	19.0	19.0	19.0	234.0
2014-09-30	BCM	ETF	37.0401	37.0401	36.661	36.661	1018.0
2014-09-30	BFOR	ETF	7.6425	7.6425	7.55	7.5575	128800.0
2014-09-30	BIB	ETF	53.21	53.25	51.5	51.99	384542.0
2014-09-30	BICK	ETF	24.89	24.9001	24.87	24.9001	977.0
2014-09-30	BIL	ETF	91.5	91.52	91.5	91.52	251150.0
2014-09-30	BIS	ETF	469.6	485.6	469.6	481.6	8261.5

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

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