PREVIEW / etf_daily / 2017-03-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-20.parquet
  size:    56 KB
  rows:    1,409

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-03-20	SPY	ETF	237.03	237.36	236.32	236.77	52537000.0
2017-03-20	QQQ	ETF	131.65	132.11	131.4601	131.81	10105210.0
2017-03-20	IWM	ETF	138.28	138.52	137.37	137.86	19091200.0
2017-03-20	DIA	ETF	208.85	209.27	208.56	208.81	3308600.0
2017-03-20	GLD	ETF	117.31	117.6	117.21	117.51	4000200.0
2017-03-20	TLT	ETF	118.55	119.23	118.5	119.15	5497800.0
2017-03-20	AADR	ETF	46.8	46.8	46.09	46.47	15700.0
2017-03-20	AAXJ	ETF	63.33	63.67	63.27	63.59	2991500.0
2017-03-20	ACSI	ETF	28.007	28.007	27.9599	27.9599	325.0
2017-03-20	ACTX	ETF	112.101	112.101	100.3009	104.4309	1447.0
2017-03-20	ACWF	ETF	25.9884	25.9884	25.9884	25.9884	41.0
2017-03-20	ACWI	ETF	63.58	63.68	63.42	63.52	1362900.0
2017-03-20	ACWV	ETF	77.54	77.55	77.31	77.4	130500.0
2017-03-20	ACWX	ETF	43.63	43.74	43.55	43.63	654053.0
2017-03-20	ADRE	ETF	36.65	37.09	36.65	37.09	14861.0
2017-03-20	AFK	ETF	21.2	21.43	21.15	21.28	24043.0
2017-03-20	AFTY	ETF	13.77	13.78	13.77	13.78	1200.0
2017-03-20	AGG	ETF	107.86	108.05	107.84	108.05	1635200.0
2017-03-20	AGGY	ETF	49.56	49.62	49.53	49.57	8400.0
2017-03-20	AGNG	ETF	16.78	16.78	16.78	16.78	100.0
2017-03-20	AGQ	ETF	37.75	37.91	37.53	37.81	141400.0
2017-03-20	AGZ	ETF	112.658	112.81	112.6	112.76	7351.0
2017-03-20	AGZD	ETF	24.06	24.065	24.05	24.065	4800.0
2017-03-20	AIA	ETF	53.25	53.4	53.2	53.39	18765.0
2017-03-20	AIQ	ETF	10.3	10.3	10.15	10.15	4841.0
2017-03-20	AIRR	ETF	23.95	23.95	23.596	23.7	97000.0
2017-03-20	AIVI	ETF	39.82	39.82	39.59	39.72	21400.0
2017-03-20	ALTY	ETF	15.38	15.495	15.38	15.477	3700.0
2017-03-20	AMJ	ETF	31.64	31.78	31.48	31.7386	3151470.0
2017-03-20	AMLP	ETF	63.0	63.1	62.6	63.05	1131160.0
2017-03-20	AMUB	ETF	20.845	20.845	20.845	20.845	0.0
2017-03-20	AMZA	ETF	110.0	110.0	108.9	109.45	76590.0
2017-03-20	ANGL	ETF	29.19	29.25	29.15	29.18	253900.0
2017-03-20	AOA	ETF	50.03	50.05	49.9	49.95	48100.0
2017-03-20	AOK	ETF	33.2	33.2199	33.165	33.1965	39100.0
2017-03-20	AOM	ETF	36.29	36.33	36.24	36.2991	61232.0
2017-03-20	AOR	ETF	42.37	42.38	42.2901	42.3409	147498.0
2017-03-20	ARGT	ETF	27.48	27.7	27.46	27.7	46400.0
2017-03-20	ARKG	ETF	20.51	20.71	20.51	20.66	3000.0
2017-03-20	ARKK	ETF	23.63	23.71	23.63	23.7	4200.0
2017-03-20	ARKQ	ETF	24.39	24.45	24.35	24.42	24100.0
2017-03-20	ARKW	ETF	28.769	28.89	28.769	28.839	4600.0
2017-03-20	ASEA	ETF	14.09	14.12	14.03	14.03	15000.0
2017-03-20	ASET	ETF	26.41	26.7	26.35	26.4	7322.0
2017-03-20	ASHR	ETF	24.99	25.06	24.96	25.04	500000.0
2017-03-20	ASHS	ETF	33.81	34.28	33.81	34.24	16400.0
2017-03-20	ATMP	ETF	23.58	23.58	23.19	23.34	24600.0
2017-03-20	BAB	ETF	29.19	29.23	29.1404	29.2136	95807.0
2017-03-20	BAL	ETF	51.02	51.23	50.2511	50.2556	10921.0
2017-03-20	BBC	ETF	23.83	24.105	23.69	24.0	13366.0

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

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