PREVIEW / etf_daily / 2017-11-10

all etf daily files

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

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-10	SPY	ETF	257.73	258.29	257.37	258.09	59984700.0
2017-11-10	QQQ	ETF	153.36	153.8	153.06	153.68	20150762.0
2017-11-10	IWM	ETF	146.71	147.1	146.35	146.57	17823700.0
2017-11-10	DIA	ETF	234.45	234.67	234.1	234.43	2506600.0
2017-11-10	GLD	ETF	121.99	122.11	120.94	121.13	7116200.0
2017-11-10	TLT	ETF	124.71	124.84	123.96	124.1	11981000.0
2017-11-10	AADR	ETF	56.96	56.96	56.39	56.4	29200.0
2017-11-10	AAXJ	ETF	76.11	76.15	75.87	76.08	619700.0
2017-11-10	ACSI	ETF	29.5723	29.5723	29.5723	29.5723	1189.0
2017-11-10	ACTX	ETF	51.3305	53.0415	43.0704	47.7904	773.0
2017-11-10	ACWF	ETF	30.0078	30.016	29.9997	29.9997	863.0
2017-11-10	ACWI	ETF	70.37	70.43	70.27	70.38	551300.0
2017-11-10	ACWV	ETF	82.66	82.83	82.59	82.71	184400.0
2017-11-10	ACWX	ETF	49.24	49.26	49.11	49.18	161865.0
2017-11-10	ADRE	ETF	43.09	43.09	42.8966	43.054	3357.0
2017-11-10	AFK	ETF	23.8	23.83	23.5628	23.83	7360.0
2017-11-10	AFTY	ETF	18.3	18.41	18.3	18.33	3800.0
2017-11-10	AGG	ETF	109.06	109.15	108.97	108.99	1751100.0
2017-11-10	AGGY	ETF	50.53	55.58	50.4	50.5	215900.0
2017-11-10	AGNG	ETF	19.311	19.362	19.311	19.35	2800.0
2017-11-10	AGQ	ETF	34.58	34.75	33.57	33.99	105400.0
2017-11-10	AGZ	ETF	113.31	113.3856	113.24	113.24	8854.0
2017-11-10	AGZD	ETF	24.07	24.115	24.07	24.115	3600.0
2017-11-10	AIA	ETF	65.82	65.85	65.56	65.78	35857.0
2017-11-10	AIEQ	ETF	24.4	24.53	24.4	24.41	53600.0
2017-11-10	AIRR	ETF	25.91	26.0	25.88	25.91	12600.0
2017-11-10	AIVI	ETF	43.17	43.17	43.0	43.06	4900.0
2017-11-10	ALTY	ETF	15.392	15.392	15.34	15.385	13200.0
2017-11-10	AMJ	ETF	27.2	27.5	27.16	27.18	1743390.0
2017-11-10	AMLP	ETF	53.05	53.4	52.6	52.8	2250360.0
2017-11-10	AMZA	ETF	83.4	84.2	82.9	83.7	70510.0
2017-11-10	ANGL	ETF	29.84	29.9	29.74	29.78	688400.0
2017-11-10	AOA	ETF	54.32	54.39	54.29	54.34	60100.0
2017-11-10	AOK	ETF	34.58	34.6032	34.45	34.57	35267.0
2017-11-10	AOM	ETF	38.14	38.17	38.05	38.07	110040.0
2017-11-10	AOR	ETF	45.19	45.27	45.19	45.22	114990.0
2017-11-10	ARGT	ETF	32.73	32.77	32.26	32.37	81100.0
2017-11-10	ARKG	ETF	24.1	24.58	24.1	24.58	12800.0
2017-11-10	ARKK	ETF	34.56	34.798	34.287	34.7	98400.0
2017-11-10	ARKQ	ETF	33.0	33.139	32.86	32.96	22100.0
2017-11-10	ARKW	ETF	42.93	43.16	42.691	42.99	73500.0
2017-11-10	ASEA	ETF	16.03	16.1	16.03	16.05	900.0
2017-11-10	ASET	ETF	28.3999	28.3999	28.349	28.3556	1999.0
2017-11-10	ASHR	ETF	31.36	31.42	31.28	31.39	758300.0
2017-11-10	ASHS	ETF	36.44	36.44	36.42	36.42	1100.0
2017-11-10	ASHX	ETF	23.224	23.244	23.224	23.23	5682.0
2017-11-10	ATMP	ETF	20.49	20.73	20.45	20.55	105700.0
2017-11-10	BAB	ETF	30.49	30.49	30.38	30.4	84481.0
2017-11-10	BAL	ETF	45.45	45.48	45.45	45.48	528.0
2017-11-10	BAR	ETF	12.798	12.798	12.798	12.798	4890.0

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

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