PREVIEW / etf_daily / 2017-11-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-03.parquet
  size:    58 KB
  rows:    1,489

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-11-03	SPY	ETF	257.77	258.5	257.3	258.45	59589700.0
2017-11-03	QQQ	ETF	152.39	153.29	151.84	153.27	26199249.0
2017-11-03	IWM	ETF	148.48	148.96	148.06	148.61	22312700.0
2017-11-03	DIA	ETF	235.36	235.39	234.64	235.18	2574400.0
2017-11-03	GLD	ETF	121.36	121.43	120.18	120.62	6330600.0
2017-11-03	TLT	ETF	125.47	125.7	125.14	125.64	10984100.0
2017-11-03	AADR	ETF	56.95	57.31	56.88	57.14	70700.0
2017-11-03	AAXJ	ETF	76.24	76.24	75.59	75.9	691500.0
2017-11-03	ACSI	ETF	29.39	29.62	29.39	29.62	1300.0
2017-11-03	ACTX	ETF	41.3004	41.8904	29.5003	38.3503	1348.0
2017-11-03	ACWF	ETF	29.94	30.17	29.94	30.0	1794.0
2017-11-03	ACWI	ETF	70.48	70.62	70.33	70.59	1157600.0
2017-11-03	ACWV	ETF	82.62	82.71	82.53	82.67	85300.0
2017-11-03	ACWX	ETF	49.44	49.4825	49.24	49.45	276472.0
2017-11-03	ADRE	ETF	43.17	43.17	42.7141	43.0	10495.0
2017-11-03	AFK	ETF	23.89	23.89	23.5669	23.6	3489.0
2017-11-03	AFTY	ETF	17.9	17.92	17.898	17.904	2000.0
2017-11-03	AGG	ETF	109.48	109.48	109.29	109.45	1781200.0
2017-11-03	AGGY	ETF	50.78	50.803	50.68	50.8	16800.0
2017-11-03	AGNG	ETF	19.43	19.455	19.3	19.45	9100.0
2017-11-03	AGQ	ETF	35.06	35.17	33.52	33.79	124800.0
2017-11-03	AGZ	ETF	113.41	113.44	113.32	113.402	9935.0
2017-11-03	AGZD	ETF	24.135	24.16	24.11	24.115	21800.0
2017-11-03	AIA	ETF	65.56	65.56	65.09	65.4	44605.0
2017-11-03	AIEQ	ETF	24.72	24.72	24.5	24.6	132900.0
2017-11-03	AIRR	ETF	26.611	26.611	26.47	26.49	26500.0
2017-11-03	AIVI	ETF	43.22	43.3	43.18	43.3	2400.0
2017-11-03	ALTY	ETF	15.29	15.44	15.28	15.44	8500.0
2017-11-03	AMJ	ETF	27.0	27.32	26.93	27.19	3688138.0
2017-11-03	AMLP	ETF	53.4	54.2	53.2	53.85	2412460.0
2017-11-03	AMZA	ETF	83.1	84.4	82.77	83.5	91090.0
2017-11-03	ANGL	ETF	30.27	30.27	30.2	30.25	290000.0
2017-11-03	AOA	ETF	54.5	54.57	54.41	54.55	60600.0
2017-11-03	AOK	ETF	34.7	34.72	34.66	34.7	68713.0
2017-11-03	AOM	ETF	38.25	38.29	38.21	38.23	95318.0
2017-11-03	AOR	ETF	45.4	45.44	45.29	45.43	60914.0
2017-11-03	ARCM	ETF	104.2	104.2	104.2	104.2	100.0
2017-11-03	ARGT	ETF	32.61	33.17	32.52	32.88	87000.0
2017-11-03	ARKG	ETF	25.48	25.66	25.349	25.58	26000.0
2017-11-03	ARKK	ETF	34.9	35.419	34.83	35.3	194200.0
2017-11-03	ARKQ	ETF	32.91	33.246	32.81	33.24	45100.0
2017-11-03	ARKW	ETF	42.97	43.464	42.81	43.32	94900.0
2017-11-03	ASEA	ETF	15.96	15.96	15.96	15.96	1200.0
2017-11-03	ASET	ETF	28.229	28.25	28.229	28.23	3611.0
2017-11-03	ASHR	ETF	30.51	30.51	30.32	30.42	530800.0
2017-11-03	ASHS	ETF	35.51	35.56	35.3	35.33	5000.0
2017-11-03	ATMP	ETF	20.36	20.58	20.32	20.46	24700.0
2017-11-03	BAB	ETF	30.55	30.62	30.47	30.61	63496.0
2017-11-03	BAL	ETF	45.49	45.49	45.18	45.36	1806.0
2017-11-03	BAR	ETF	12.768	12.768	12.674	12.6752	23400.0

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

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