PREVIEW / etf_daily / 2014-10-17

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-17.parquet
  size:    46 KB
  rows:    1,134

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-10-17	SPY	ETF	188.42	189.75	187.62	188.47	214625000.0
2014-10-17	QQQ	ETF	92.99	93.89	92.46	93.0	69546720.0
2014-10-17	IWM	ETF	109.16	109.22	107.04	107.48	72675000.0
2014-10-17	DIA	ETF	162.68	163.95	162.21	163.45	11730200.0
2014-10-17	GLD	ETF	119.06	119.23	118.42	118.99	8059000.0
2014-10-17	TLT	ETF	121.19	121.71	120.48	121.07	8524300.0
2014-10-17	AAXJ	ETF	60.45	60.82	60.24	60.38	575300.0
2014-10-17	ACWI	ETF	56.22	56.57	56.01	56.31	1354800.0
2014-10-17	ACWV	ETF	65.66	65.82	65.32	65.67	83200.0
2014-10-17	ACWX	ETF	43.11	43.44	43.07	43.32	688417.0
2014-10-17	ADRE	ETF	38.84	39.1299	38.81	38.99	14129.0
2014-10-17	AFK	ETF	28.85	29.0058	28.85	28.958	18249.0
2014-10-17	AGG	ETF	110.51	110.65	110.4	110.52	2065800.0
2014-10-17	AGQ	ETF	47.63	47.66	46.9	47.25	214700.0
2014-10-17	AGZ	ETF	113.16	113.5625	113.04	113.22	16199.0
2014-10-17	AGZD	ETF	24.755	24.8	24.655	24.655	8000.0
2014-10-17	AIA	ETF	46.16	46.27	45.85	46.06	50556.0
2014-10-17	AIQ	ETF	23.53	23.73	22.12	22.94	25508.0
2014-10-17	AIRR	ETF	17.92	17.97	17.7	17.73	46400.0
2014-10-17	AIVI	ETF	44.21	44.34	43.99	44.23	46900.0
2014-10-17	AMJ	ETF	50.07	50.768	48.67	49.83	3366651.0
2014-10-17	AMLP	ETF	92.75	93.05	90.4	92.0	1770300.0
2014-10-17	AMZA	ETF	240.0	241.7	233.08	239.9	2150.0
2014-10-17	ANGL	ETF	27.4	27.62	27.4	27.57	1000.0
2014-10-17	AOA	ETF	44.05	44.23	43.91	44.08	44900.0
2014-10-17	AOK	ETF	32.08	32.172	32.06	32.128	31867.0
2014-10-17	AOM	ETF	34.4	34.42	34.2632	34.35	69444.0
2014-10-17	AOR	ETF	38.61	38.6626	38.4301	38.57	46532.0
2014-10-17	ARGT	ETF	19.09	19.37	19.09	19.16	22100.0
2014-10-17	ARKQ	ETF	19.22	19.22	18.96	19.051	6300.0
2014-10-17	ARKW	ETF	18.99	19.01	18.8	18.87	6800.0
2014-10-17	ASEA	ETF	16.26	16.33	16.26	16.29	2300.0
2014-10-17	ASHR	ETF	25.76	25.93	25.66	25.76	888600.0
2014-10-17	ASHS	ETF	33.89	33.89	33.33	33.4	22200.0
2014-10-17	ATMP	ETF	30.65	30.99	30.01	30.48	22500.0
2014-10-17	AVIV	ETF	28.46	28.48	27.96	28.09	275796.0
2014-10-17	AWAY	ETF	30.4	31.835	30.15	31.71	1414526.0
2014-10-17	BAB	ETF	30.02	30.1232	29.86	30.0101	91204.0
2014-10-17	BAL	ETF	42.33	42.33	42.15	42.1599	2673.0
2014-10-17	BALT	ETF	3.53	3.65	3.39	3.43	767679.0
2014-10-17	BAR	ETF	3.203	3.259	3.191	3.2586	34080.0
2014-10-17	BBH	ETF	101.51	102.89	100.84	101.79	111000.0
2014-10-17	BCHP	ETF	18.025	18.025	18.025	18.025	270.0
2014-10-17	BFOR	ETF	7.325	7.3375	7.24	7.26	113200.0
2014-10-17	BIB	ETF	49.255	49.655	47.935	48.685	766200.0
2014-10-17	BICK	ETF	24.22	24.382	24.22	24.382	927.0
2014-10-17	BIL	ETF	91.5	91.5	91.48	91.5	683350.0
2014-10-17	BIS	ETF	501.2	513.8	494.8	506.4	19272.0
2014-10-17	BIV	ETF	85.69	85.8	85.52	85.7	227800.0
2014-10-17	BIZD	ETF	18.79	18.96	18.72	18.83	19700.0

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

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