PREVIEW / etf_daily / 2017-11-01

all etf daily files

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

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-01	SPY	ETF	258.04	258.43	257.07	257.49	54202700.0
2017-11-01	QQQ	ETF	152.75	152.83	151.5	152.1	29481569.0
2017-11-01	IWM	ETF	150.5	150.53	147.44	148.27	31585500.0
2017-11-01	DIA	ETF	234.6	235.02	233.73	234.19	2675700.0
2017-11-01	GLD	ETF	120.98	121.55	120.84	121.11	4647800.0
2017-11-01	TLT	ETF	124.35	125.14	124.3	124.75	8940400.0
2017-11-01	AADR	ETF	57.97	57.98	57.46	57.46	33400.0
2017-11-01	AAXJ	ETF	76.23	76.35	75.85	75.96	2869500.0
2017-11-01	ACSI	ETF	29.64	29.64	29.52	29.56	2224.0
2017-11-01	ACTX	ETF	46.0204	47.2004	44.2504	47.2004	76.0
2017-11-01	ACWF	ETF	30.07	30.17	30.0	30.0	7180.0
2017-11-01	ACWI	ETF	70.63	70.71	70.39	70.42	1493200.0
2017-11-01	ACWV	ETF	82.86	82.9	82.55	82.59	353500.0
2017-11-01	ACWX	ETF	49.55	49.63	49.39	49.42	466069.0
2017-11-01	ADRE	ETF	43.17	43.4212	43.0508	43.09	12331.0
2017-11-01	AFK	ETF	23.8	23.8	23.63	23.8	15421.0
2017-11-01	AFTY	ETF	17.95	18.03	17.95	18.0	7400.0
2017-11-01	AGG	ETF	109.17	109.41	109.17	109.29	2959400.0
2017-11-01	AGGY	ETF	50.64	50.77	50.635	50.715	67400.0
2017-11-01	AGNG	ETF	19.41	19.66	19.24	19.592	8100.0
2017-11-01	AGQ	ETF	33.92	35.17	33.84	34.99	485300.0
2017-11-01	AGZ	ETF	113.281	113.39	113.254	113.3003	9906.0
2017-11-01	AGZD	ETF	24.135	24.135	24.07	24.07	6200.0
2017-11-01	AIA	ETF	65.63	65.73	65.4345	65.48	57871.0
2017-11-01	AIEQ	ETF	25.06	25.15	24.75	24.85	270200.0
2017-11-01	AIRR	ETF	27.02	27.02	26.455	26.48	13500.0
2017-11-01	AIVI	ETF	43.38	43.38	43.24	43.24	4900.0
2017-11-01	ALTY	ETF	15.405	15.45	15.383	15.433	2000.0
2017-11-01	AMJ	ETF	27.19	27.53	27.16	27.49	3327578.0
2017-11-01	AMLP	ETF	53.8	54.65	53.7	54.5	2880460.0
2017-11-01	AMZA	ETF	84.3	85.7	84.0	85.7	104410.0
2017-11-01	ANGL	ETF	30.22	30.23	30.14	30.16	346900.0
2017-11-01	AOA	ETF	54.76	54.76	54.4	54.48	57100.0
2017-11-01	AOK	ETF	35.0	35.0	34.6474	34.7	73883.0
2017-11-01	AOM	ETF	38.37	38.37	38.16	38.24	242323.0
2017-11-01	AOR	ETF	45.41	45.54	45.3	45.36	97499.0
2017-11-01	ARGT	ETF	32.24	32.24	31.85	31.95	76100.0
2017-11-01	ARKG	ETF	26.03	26.093	25.175	25.21	42700.0
2017-11-01	ARKK	ETF	35.76	35.82	34.93	34.96	147200.0
2017-11-01	ARKQ	ETF	33.69	33.69	32.96	33.06	38900.0
2017-11-01	ARKW	ETF	43.55	43.64	42.94	42.97	182200.0
2017-11-01	ASEA	ETF	15.91	15.99	15.89	15.96	4100.0
2017-11-01	ASET	ETF	28.26	28.31	28.23	28.23	5653.0
2017-11-01	ASHR	ETF	30.7	30.7	30.62	30.67	601700.0
2017-11-01	ASHS	ETF	36.18	36.21	36.13	36.19	2800.0
2017-11-01	ASHX	ETF	22.625	22.625	22.625	22.625	128.0
2017-11-01	ATMP	ETF	20.85	20.85	20.74	20.82	67400.0
2017-11-01	BAB	ETF	30.53	30.53	30.38	30.47	117564.0
2017-11-01	BAL	ETF	45.2499	45.31	45.2499	45.31	620.0
2017-11-01	BAR	ETF	12.738	12.751	12.738	12.751	3560.0

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

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