PREVIEW / etf_daily / 2017-08-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-16.parquet
  size:    57 KB
  rows:    1,440

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-08-16	SPY	ETF	247.11	247.57	246.45	246.94	56715500.0
2017-08-16	QQQ	ETF	144.37	144.96	143.8007	144.28	31913002.0
2017-08-16	IWM	ETF	137.67	138.39	137.21	137.44	21858600.0
2017-08-16	DIA	ETF	220.7	221.1	220.28	220.47	2476100.0
2017-08-16	GLD	ETF	120.66	122.06	120.66	121.87	8267300.0
2017-08-16	TLT	ETF	124.83	126.02	124.81	125.71	5283800.0
2017-08-16	AADR	ETF	50.94	51.77	50.94	51.33	66800.0
2017-08-16	AAXJ	ETF	70.47	70.72	70.47	70.7	364600.0
2017-08-16	ACSI	ETF	29.05	29.06	28.9661	28.9789	4424.0
2017-08-16	ACTX	ETF	73.1607	79.6507	71.9806	79.6507	242.0
2017-08-16	ACWF	ETF	27.88	28.01	27.88	27.9686	2017.0
2017-08-16	ACWI	ETF	67.14	67.22	67.08	67.16	1123200.0
2017-08-16	ACWV	ETF	80.78	81.1	80.75	81.07	105500.0
2017-08-16	ACWX	ETF	46.94	47.09	46.93	47.08	139681.0
2017-08-16	ADRE	ETF	41.44	41.7	41.44	41.48	12056.0
2017-08-16	AFK	ETF	22.71	22.9899	22.7	22.8763	7544.0
2017-08-16	AFTY	ETF	16.12	16.12	16.057	16.11	5800.0
2017-08-16	AGG	ETF	109.54	109.93	109.54	109.86	1956500.0
2017-08-16	AGGY	ETF	50.584	50.77	50.584	50.76	4900.0
2017-08-16	AGQ	ETF	33.68	35.36	33.68	35.19	177200.0
2017-08-16	AGZ	ETF	113.8	114.01	113.8	113.98	27523.0
2017-08-16	AGZD	ETF	23.935	23.97	23.92	23.945	4800.0
2017-08-16	AIA	ETF	60.0	60.325	60.0	60.25	40512.0
2017-08-16	AIQ	ETF	13.2	13.2	13.1	13.15	31263.0
2017-08-16	AIRR	ETF	23.01	23.12	22.94	22.96	59400.0
2017-08-16	AIVI	ETF	41.59	41.83	41.59	41.8	13900.0
2017-08-16	ALTY	ETF	15.4	15.61	15.15	15.59	11700.0
2017-08-16	AMJ	ETF	27.68	27.89	27.4	27.52	2139195.0
2017-08-16	AMLP	ETF	54.55	54.6	53.5	53.8	2073420.0
2017-08-16	AMZA	ETF	89.6	90.59	87.6	88.3	164780.0
2017-08-16	ANGL	ETF	29.71	29.8	29.58	29.77	297900.0
2017-08-16	AOA	ETF	52.35	52.47	52.35	52.46	23700.0
2017-08-16	AOK	ETF	34.14	34.22	34.1179	34.16	47904.0
2017-08-16	AOM	ETF	37.48	37.6	37.4501	37.48	92604.0
2017-08-16	AOR	ETF	44.0	44.1035	43.98	44.09	83970.0
2017-08-16	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-08-16	ARGT	ETF	29.33	29.33	29.15	29.24	53400.0
2017-08-16	ARKG	ETF	22.77	22.87	22.5	22.5	17800.0
2017-08-16	ARKK	ETF	31.27	31.795	31.27	31.53	56200.0
2017-08-16	ARKQ	ETF	29.5	29.55	29.321	29.37	23400.0
2017-08-16	ARKW	ETF	38.79	39.1	38.64	38.917	81800.0
2017-08-16	ASEA	ETF	15.33	15.33	15.33	15.33	1000.0
2017-08-16	ASET	ETF	27.979	27.979	27.979	27.979	106.0
2017-08-16	ASHR	ETF	27.94	28.03	27.93	28.02	569100.0
2017-08-16	ASHS	ETF	34.41	34.41	34.35	34.41	3800.0
2017-08-16	ASHX	ETF	21.03	21.03	20.99	20.99	650.0
2017-08-16	ATMP	ETF	21.25	21.25	20.74	20.85	27700.0
2017-08-16	BAB	ETF	30.12	30.29	30.1	30.26	114273.0
2017-08-16	BAL	ETF	44.0408	44.05	43.94	43.98	9573.0
2017-08-16	BBC	ETF	24.3799	24.55	24.3015	24.3372	2821.0

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

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