PREVIEW / etf_daily / 2014-11-11

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-11.parquet
  size:    45 KB
  rows:    1,116

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-11-11	SPY	ETF	204.06	204.31	203.65	204.18	54499400.0
2014-11-11	QQQ	ETF	101.98	102.28	101.7	102.28	15454012.0
2014-11-11	IWM	ETF	117.12	117.44	116.87	117.37	23536800.0
2014-11-11	DIA	ETF	175.98	176.24	175.69	176.02	3192700.0
2014-11-11	GLD	ETF	111.08	112.76	110.87	112.04	8603200.0
2014-11-11	TLT	ETF	118.48	118.81	118.34	118.73	2416500.0
2014-11-11	AAXJ	ETF	62.21	62.48	62.17	62.33	1408600.0
2014-11-11	ACWI	ETF	59.6	59.73	59.5	59.73	1422200.0
2014-11-11	ACWV	ETF	69.35	69.46	69.15	69.38	97100.0
2014-11-11	ACWX	ETF	44.83	45.07	44.794	45.04	467013.0
2014-11-11	ADRE	ETF	38.7	38.8	38.49	38.74	7324.0
2014-11-11	AFK	ETF	29.67	29.74	29.43	29.65	197939.0
2014-11-11	AGG	ETF	109.66	109.71	109.59	109.7	1138500.0
2014-11-11	AGQ	ETF	38.13	39.68	37.8	38.87	204000.0
2014-11-11	AGZ	ETF	112.5238	112.9599	112.5101	112.8099	4871.0
2014-11-11	AGZD	ETF	24.785	24.85	24.75	24.835	14200.0
2014-11-11	AIA	ETF	47.74	47.8645	47.69	47.8345	23909.0
2014-11-11	AIQ	ETF	22.62	22.62	22.04	22.11	66431.0
2014-11-11	AIRR	ETF	19.09	19.09	18.98	19.08	48200.0
2014-11-11	AIVI	ETF	45.78	46.06	45.75	46.0	26500.0
2014-11-11	AMJ	ETF	50.67	50.73	50.13	50.56	1326639.0
2014-11-11	AMLP	ETF	91.9	92.3	91.2	91.7	685800.0
2014-11-11	AMZA	ETF	242.6	247.83	242.1	242.1	600.0
2014-11-11	ANGL	ETF	27.68	27.8	27.62	27.68	6300.0
2014-11-11	AOA	ETF	46.51	46.59	46.45	46.59	25600.0
2014-11-11	AOK	ETF	32.7473	32.77	32.71	32.77	32933.0
2014-11-11	AOM	ETF	35.4	35.4	35.29	35.33	88465.0
2014-11-11	AOR	ETF	40.22	40.22	40.152	40.22	33864.0
2014-11-11	ARGT	ETF	20.7	20.78	20.7	20.72	10300.0
2014-11-11	ARKG	ETF	20.5	20.5	19.84	19.92	3300.0
2014-11-11	ARKK	ETF	20.69	20.69	20.234	20.29	2900.0
2014-11-11	ARKQ	ETF	20.15	20.15	19.961	20.08	1400.0
2014-11-11	ARKW	ETF	20.371	20.371	20.37	20.37	600.0
2014-11-11	ASEA	ETF	16.55	16.7	16.55	16.68	8900.0
2014-11-11	ASHR	ETF	27.18	27.26	27.0	27.23	1388600.0
2014-11-11	ASHS	ETF	33.36	33.61	33.34	33.49	46300.0
2014-11-11	ATMP	ETF	31.52	31.52	31.23	31.46	15600.0
2014-11-11	AVIV	ETF	33.21	33.37	33.08	33.26	1039902.0
2014-11-11	AWAY	ETF	29.71	31.18	29.65	30.87	2649178.0
2014-11-11	BAB	ETF	29.83	29.91	29.83	29.83	94907.0
2014-11-11	BAL	ETF	42.04	42.76	41.92	42.18	5696.0
2014-11-11	BALT	ETF	3.24	3.305	3.21	3.24	401690.0
2014-11-11	BAR	ETF	2.6	2.711	2.6	2.678	25900.0
2014-11-11	BBH	ETF	116.2	117.0	115.65	116.27	77800.0
2014-11-11	BCHP	ETF	18.5552	18.57	18.51	18.51	2972.0
2014-11-11	BFOR	ETF	7.925	7.9325	7.9075	7.9325	26000.0
2014-11-11	BIB	ETF	60.485	61.05	59.5	60.495	362332.0
2014-11-11	BICK	ETF	24.84	24.88	24.83	24.88	2528.0
2014-11-11	BIL	ETF	91.48	91.5	91.48	91.5	128400.0
2014-11-11	BIS	ETF	401.6	405.2	395.4	400.16	14713.0

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

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