PREVIEW / etf_daily / 2017-11-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-16.parquet
  size:    59 KB
  rows:    1,513

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-16	SPY	ETF	257.52	259.04	257.47	258.62	67777000.0
2017-11-16	QQQ	ETF	153.38	154.89	153.33	154.54	34790570.0
2017-11-16	IWM	ETF	146.21	148.4	146.19	147.77	25889000.0
2017-11-16	DIA	ETF	234.22	235.28	234.19	234.91	2933400.0
2017-11-16	GLD	ETF	121.45	121.71	121.29	121.4	2796500.0
2017-11-16	TLT	ETF	126.01	126.33	125.45	125.46	5894900.0
2017-11-16	AADR	ETF	56.06	57.04	56.06	56.93	48200.0
2017-11-16	AAXJ	ETF	76.04	76.84	76.04	76.72	1428700.0
2017-11-16	ACSI	ETF	29.76	29.8799	29.76	29.8799	1953.0
2017-11-16	ACTX	ETF	51.3305	51.4485	47.2004	50.1505	640.0
2017-11-16	ACWF	ETF	29.98	30.24	29.98	30.23	6868.0
2017-11-16	ACWI	ETF	70.21	70.59	70.19	70.49	998600.0
2017-11-16	ACWV	ETF	83.0	83.33	82.78	83.19	132700.0
2017-11-16	ACWX	ETF	49.09	49.28	49.08	49.22	473755.0
2017-11-16	ADRE	ETF	42.6	43.09	42.5651	42.9803	29567.0
2017-11-16	AFK	ETF	23.45	23.58	22.69	23.58	11287.0
2017-11-16	AFTY	ETF	18.513	18.577	18.51	18.577	3700.0
2017-11-16	AGG	ETF	109.22	109.32	109.18	109.19	1912600.0
2017-11-16	AGGY	ETF	50.62	50.64	50.558	50.558	184100.0
2017-11-16	AGNG	ETF	19.22	19.46	19.22	19.46	1800.0
2017-11-16	AGQ	ETF	34.59	34.84	34.52	34.6	33800.0
2017-11-16	AGZ	ETF	113.4304	113.46	113.36	113.4	25764.0
2017-11-16	AGZD	ETF	24.095	24.145	24.065	24.125	27600.0
2017-11-16	AIA	ETF	66.14	66.64	66.12	66.45	39468.0
2017-11-16	AIEQ	ETF	24.29	24.599	24.29	24.53	79700.0
2017-11-16	AIRR	ETF	25.27	25.645	25.21	25.52	20600.0
2017-11-16	AIVI	ETF	42.66	42.72	42.6	42.69	8000.0
2017-11-16	ALTY	ETF	15.328	15.328	15.328	15.328	400.0
2017-11-16	AMJ	ETF	26.48	26.58	26.33	26.46	2946774.0
2017-11-16	AMLP	ETF	51.3	51.5	50.9	51.15	3515540.0
2017-11-16	AMZA	ETF	80.3	80.6	79.58	80.1	68970.0
2017-11-16	ANGL	ETF	29.78	29.92	29.69	29.92	557600.0
2017-11-16	AOA	ETF	54.2	54.5	54.2	54.45	58700.0
2017-11-16	AOK	ETF	34.63	34.6562	34.53	34.64	138705.0
2017-11-16	AOM	ETF	38.22	38.229	38.1368	38.18	338753.0
2017-11-16	AOR	ETF	45.2	45.36	45.175	45.32	87370.0
2017-11-16	ARGT	ETF	31.24	31.88	31.19	31.75	106300.0
2017-11-16	ARKG	ETF	24.261	24.779	24.261	24.493	26300.0
2017-11-16	ARKK	ETF	34.96	35.46	34.86	35.3	124900.0
2017-11-16	ARKQ	ETF	33.0	33.46	33.0	33.36	23500.0
2017-11-16	ARKW	ETF	43.16	43.8	43.16	43.69	75000.0
2017-11-16	ASEA	ETF	16.18	16.25	16.0	16.09	3100.0
2017-11-16	ASET	ETF	28.21	28.309	28.21	28.309	1832.0
2017-11-16	ASHR	ETF	31.29	31.49	31.29	31.43	824000.0
2017-11-16	ASHS	ETF	36.02	36.07	36.02	36.07	1000.0
2017-11-16	ASHX	ETF	23.08	23.08	23.08	23.08	139.0
2017-11-16	ATMP	ETF	19.83	20.05	19.8	19.94	353100.0
2017-11-16	BAB	ETF	30.65	30.7	30.57	30.57	122670.0
2017-11-16	BAL	ETF	45.41	45.41	45.41	45.41	232.0
2017-11-16	BBC	ETF	27.02	27.4864	27.02	27.25	8902.0

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

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