PREVIEW / etf_daily / 2017-08-09

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-09.parquet
  size:    56 KB
  rows:    1,434

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-09	SPY	ETF	246.47	247.31	246.06	247.25	62632600.0
2017-08-09	QQQ	ETF	143.14	144.19	142.795	144.12	36169473.0
2017-08-09	IWM	ETF	139.12	139.39	138.28	138.79	26534300.0
2017-08-09	DIA	ETF	220.33	220.61	219.96	220.5	3555800.0
2017-08-09	GLD	ETF	121.02	121.55	120.76	121.31	9186200.0
2017-08-09	TLT	ETF	125.93	125.95	125.2	125.3	9221800.0
2017-08-09	AADR	ETF	49.97	50.04	49.8	50.04	6800.0
2017-08-09	AAXJ	ETF	70.75	70.99	70.64	70.96	1036600.0
2017-08-09	ACSI	ETF	29.22	29.289	29.14	29.26	22642.0
2017-08-09	ACTX	ETF	80.2407	85.5508	76.7007	84.6068	285.0
2017-08-09	ACWF	ETF	28.0	28.0	27.995	27.995	2315.0
2017-08-09	ACWI	ETF	67.11	67.33	66.99	67.32	606600.0
2017-08-09	ACWV	ETF	80.46	80.6	80.37	80.58	296200.0
2017-08-09	ACWX	ETF	47.07	47.2356	46.99	47.23	698802.0
2017-08-09	ADRE	ETF	41.63	41.8304	41.4889	41.8149	24230.0
2017-08-09	AFK	ETF	23.21	23.33	22.63	22.74	172257.0
2017-08-09	AFTY	ETF	16.15	16.15	16.056	16.07	2300.0
2017-08-09	AGG	ETF	109.87	109.87	109.66	109.67	2308900.0
2017-08-09	AGGY	ETF	50.77	50.77	50.65	50.72	9100.0
2017-08-09	AGNG	ETF	18.9	18.9	18.629	18.629	1000.0
2017-08-09	AGQ	ETF	33.98	34.67	33.9	34.58	203500.0
2017-08-09	AGZ	ETF	113.95	114.004	113.83	113.83	31563.0
2017-08-09	AGZD	ETF	23.98	24.005	23.98	23.985	2200.0
2017-08-09	AIA	ETF	60.37	60.3799	60.16	60.32	73653.0
2017-08-09	AIQ	ETF	13.1	13.15	13.05	13.1	39557.0
2017-08-09	AIRR	ETF	23.55	23.82	23.55	23.75	22700.0
2017-08-09	AIVI	ETF	41.7	41.84	41.64	41.84	10600.0
2017-08-09	ALTY	ETF	15.63	15.659	15.615	15.64	4700.0
2017-08-09	AMJ	ETF	28.53	29.03	28.53	28.81	1687827.0
2017-08-09	AMLP	ETF	56.05	56.95	55.75	56.4	1153140.0
2017-08-09	AMZA	ETF	92.5	94.6	92.2	93.7	161180.0
2017-08-09	ANGL	ETF	29.77	29.88	29.65	29.73	420400.0
2017-08-09	AOA	ETF	52.46	52.53	52.34	52.53	413300.0
2017-08-09	AOK	ETF	34.14	34.24	34.1301	34.23	49610.0
2017-08-09	AOM	ETF	37.51	37.56	37.46	37.48	611203.0
2017-08-09	AOR	ETF	44.08	44.13	44.0202	44.09	87125.0
2017-08-09	ARCM	ETF	100.0	100.0	100.0	100.0	20.0
2017-08-09	ARGT	ETF	28.14	28.25	28.03	28.14	48800.0
2017-08-09	ARKG	ETF	22.44	22.689	22.44	22.51	9500.0
2017-08-09	ARKK	ETF	30.65	30.73	30.44	30.64	90100.0
2017-08-09	ARKQ	ETF	29.47	29.65	29.336	29.49	21500.0
2017-08-09	ARKW	ETF	38.02	38.02	37.67	37.87	49300.0
2017-08-09	ASEA	ETF	15.4	15.4	15.29	15.29	4300.0
2017-08-09	ASET	ETF	27.88	27.92	27.88	27.92	1474.0
2017-08-09	ASHR	ETF	28.17	28.2	28.15	28.2	657600.0
2017-08-09	ASHS	ETF	34.49	34.59	34.49	34.59	4100.0
2017-08-09	ASHX	ETF	21.05	21.05	21.05	21.05	221.0
2017-08-09	ATMP	ETF	21.55	21.93	21.55	21.73	65600.0
2017-08-09	BAB	ETF	30.37	30.4486	30.34	30.38	131033.0
2017-08-09	BAL	ETF	46.68	47.15	46.68	47.11	1610.0

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

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