PREVIEW / etf_daily / 2017-04-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-20.parquet
  size:    55 KB
  rows:    1,389

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
2017-04-20	SPY	ETF	234.15	235.85	233.78	235.34	92572200.0
2017-04-20	QQQ	ETF	132.04	132.88	131.82	132.59	21977910.0
2017-04-20	IWM	ETF	136.34	137.67	136.15	137.52	31934400.0
2017-04-20	DIA	ETF	204.35	206.21	204.17	205.7	3873700.0
2017-04-20	GLD	ETF	121.82	122.17	121.5	121.96	11787300.0
2017-04-20	TLT	ETF	123.52	123.92	123.14	123.54	7932900.0
2017-04-20	AADR	ETF	46.15	46.32	46.15	46.31	6400.0
2017-04-20	AAXJ	ETF	62.69	62.84	62.57	62.81	449500.0
2017-04-20	ACSI	ETF	27.98	28.13	27.9799	28.13	1400.0
2017-04-20	ACTX	ETF	90.2118	96.7609	85.4328	94.4008	1792.0
2017-04-20	ACWI	ETF	62.96	63.21	62.89	63.11	1681400.0
2017-04-20	ACWV	ETF	77.57	77.7	77.4	77.62	60100.0
2017-04-20	ACWX	ETF	43.48	43.555	43.45	43.51	933980.0
2017-04-20	ADRE	ETF	36.31	36.3414	36.2224	36.2707	5898.0
2017-04-20	AFK	ETF	21.11	21.2083	21.11	21.16	4266.0
2017-04-20	AFTY	ETF	13.66	13.66	13.66	13.66	11200.0
2017-04-20	AGG	ETF	109.31	109.4	109.2	109.31	1867800.0
2017-04-20	AGGY	ETF	50.4	50.42	50.32	50.37	5600.0
2017-04-20	AGNG	ETF	17.0	17.145	17.0	17.145	200.0
2017-04-20	AGQ	ETF	40.48	40.91	39.55	40.21	270200.0
2017-04-20	AGZ	ETF	113.72	113.95	113.506	113.575	4663.0
2017-04-20	AGZD	ETF	24.01	24.02	24.01	24.015	15200.0
2017-04-20	AIA	ETF	51.96	52.1099	51.96	52.06	20772.0
2017-04-20	AIQ	ETF	13.0	13.1	12.95	13.05	9959.0
2017-04-20	AIRR	ETF	23.68	23.884	23.68	23.88	44000.0
2017-04-20	AIVI	ETF	39.03	39.16	39.03	39.11	5400.0
2017-04-20	ALTY	ETF	15.58	15.59	15.544	15.561	2800.0
2017-04-20	AMJ	ETF	31.82	32.0199	31.77	31.84	922523.0
2017-04-20	AMLP	ETF	63.15	63.3	62.85	63.05	912260.0
2017-04-20	AMZA	ETF	104.8	105.4	104.6	105.0	38510.0
2017-04-20	ANGL	ETF	29.53	29.57	29.49	29.55	206200.0
2017-04-20	AOA	ETF	49.74	49.86	49.63	49.79	61600.0
2017-04-20	AOK	ETF	33.43	33.4443	33.3672	33.43	77455.0
2017-04-20	AOM	ETF	36.43	36.4396	36.35	36.42	70081.0
2017-04-20	AOR	ETF	42.26	42.335	42.1972	42.29	61492.0
2017-04-20	ARCM	ETF	100.0	100.0	100.0	100.0	200000.0
2017-04-20	ARGT	ETF	28.78	28.85	28.68	28.84	124700.0
2017-04-20	ARKG	ETF	20.0	20.03	20.0	20.03	300.0
2017-04-20	ARKK	ETF	24.43	24.58	24.37	24.55	11700.0
2017-04-20	ARKQ	ETF	25.24	25.51	25.24	25.475	17800.0
2017-04-20	ARKW	ETF	29.49	29.72	29.49	29.686	12900.0
2017-04-20	ASEA	ETF	14.09	14.23	14.09	14.22	1000.0
2017-04-20	ASET	ETF	26.87	26.87	26.8598	26.87	1489.0
2017-04-20	ASHR	ETF	25.0	25.12	24.99	25.11	884600.0
2017-04-20	ASHS	ETF	33.35	33.39	33.32	33.37	4100.0
2017-04-20	ASHX	ETF	19.4497	19.56	19.4497	19.4776	1345.0
2017-04-20	ATMP	ETF	23.41	23.58	23.41	23.41	42300.0
2017-04-20	BAB	ETF	29.64	29.6437	29.54	29.59	105003.0
2017-04-20	BAL	ETF	50.26	50.65	50.2244	50.39	2920.0
2017-04-20	BBC	ETF	21.86	22.1694	21.86	22.08	2743.0

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

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