PREVIEW / etf_daily / 2017-11-06

all etf daily files

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

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-06	SPY	ETF	258.3	259.0	258.22	258.85	49652600.0
2017-11-06	QQQ	ETF	153.13	153.85	153.1	153.79	28693919.0
2017-11-06	IWM	ETF	148.75	149.38	148.39	148.78	15576800.0
2017-11-06	DIA	ETF	235.23	235.59	235.09	235.41	2549900.0
2017-11-06	GLD	ETF	120.72	121.85	120.68	121.65	6953800.0
2017-11-06	TLT	ETF	125.93	126.22	125.72	126.11	6246700.0
2017-11-06	AADR	ETF	57.61	57.74	57.23	57.65	41600.0
2017-11-06	AAXJ	ETF	75.9	76.53	75.89	76.53	1313700.0
2017-11-06	ACSI	ETF	29.615	29.615	29.57	29.57	3554.0
2017-11-06	ACTX	ETF	39.5304	41.3004	36.5803	40.1204	1184.0
2017-11-06	ACWF	ETF	30.074	30.175	30.05	30.175	6987.0
2017-11-06	ACWI	ETF	70.57	70.82	70.54	70.79	764100.0
2017-11-06	ACWV	ETF	82.56	82.73	82.56	82.69	56500.0
2017-11-06	ACWX	ETF	49.38	49.64	49.36	49.64	187902.0
2017-11-06	ADRE	ETF	43.0	43.6084	43.0	43.57	11601.0
2017-11-06	AFK	ETF	23.6	23.9514	23.6	23.791	12778.0
2017-11-06	AFTY	ETF	18.09	18.09	18.005	18.005	4900.0
2017-11-06	AGG	ETF	109.56	109.59	109.46	109.55	1293000.0
2017-11-06	AGGY	ETF	50.82	50.84	50.764	50.83	54600.0
2017-11-06	AGNG	ETF	19.45	19.49	19.449	19.45	3500.0
2017-11-06	AGQ	ETF	34.0	35.42	33.91	35.39	137600.0
2017-11-06	AGZ	ETF	113.5	113.572	113.49	113.5456	16029.0
2017-11-06	AGZD	ETF	24.095	24.135	24.08	24.08	6000.0
2017-11-06	AIA	ETF	65.6	65.779	65.52	65.7	55570.0
2017-11-06	AIEQ	ETF	24.55	24.74	24.55	24.72	199100.0
2017-11-06	AIRR	ETF	26.56	26.692	26.453	26.66	15600.0
2017-11-06	AIVI	ETF	43.36	43.56	43.36	43.56	7500.0
2017-11-06	ALTY	ETF	15.5	15.5	15.35	15.351	4900.0
2017-11-06	AMJ	ETF	27.19	27.58	27.11	27.58	2632629.0
2017-11-06	AMLP	ETF	53.85	54.65	53.55	54.6	2635220.0
2017-11-06	AMZA	ETF	83.7	84.3	82.7	84.1	207670.0
2017-11-06	ANGL	ETF	30.25	30.25	30.17	30.22	196900.0
2017-11-06	AOA	ETF	54.56	54.71	54.55	54.7	37000.0
2017-11-06	AOK	ETF	34.66	34.77	34.66	34.76	61160.0
2017-11-06	AOM	ETF	38.25	38.38	38.23	38.35	76060.0
2017-11-06	AOR	ETF	45.42	45.54	45.3968	45.49	68320.0
2017-11-06	ARGT	ETF	32.96	33.28	32.8	33.28	42600.0
2017-11-06	ARKG	ETF	25.69	25.69	25.3	25.34	38800.0
2017-11-06	ARKK	ETF	35.37	35.385	35.02	35.24	160900.0
2017-11-06	ARKQ	ETF	33.21	33.46	33.205	33.46	19300.0
2017-11-06	ARKW	ETF	43.41	43.57	43.326	43.5	130800.0
2017-11-06	ASEA	ETF	16.0	16.02	15.98	16.02	2000.0
2017-11-06	ASET	ETF	28.25	28.33	28.25	28.33	1566.0
2017-11-06	ASHR	ETF	30.72	30.83	30.69	30.83	526900.0
2017-11-06	ASHS	ETF	35.68	35.89	35.68	35.89	3100.0
2017-11-06	ASHX	ETF	22.7699	22.7799	22.7691	22.7799	1246.0
2017-11-06	ATMP	ETF	20.53	20.82	20.52	20.75	130800.0
2017-11-06	BAB	ETF	30.65	30.68	30.58	30.68	119657.0
2017-11-06	BAL	ETF	45.259	45.521	45.259	45.521	612.0
2017-11-06	BAR	ETF	12.825	12.825	12.825	12.825	2220.0

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

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