PREVIEW / etf_daily / 2017-09-28

all etf daily files

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

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-09-28	SPY	ETF	249.73	250.44	249.63	250.35	44778800.0
2017-09-28	QQQ	ETF	144.14	144.5566	143.78	144.41	24149422.0
2017-09-28	IWM	ETF	147.25	148.06	146.78	147.83	29291400.0
2017-09-28	DIA	ETF	222.97	223.77	222.7	223.6	1462800.0
2017-09-28	GLD	ETF	122.04	122.48	121.83	122.21	5968200.0
2017-09-28	TLT	ETF	124.21	124.65	123.97	124.48	8883700.0
2017-09-28	AADR	ETF	54.57	55.05	54.49	55.02	24400.0
2017-09-28	AAXJ	ETF	71.18	71.52	71.04	71.44	2466500.0
2017-09-28	ACSI	ETF	29.08	29.159	29.08	29.159	2641.0
2017-09-28	ACTX	ETF	67.8506	67.8506	65.4906	66.0806	138.0
2017-09-28	ACWF	ETF	28.74	28.74	28.74	28.74	400.0
2017-09-28	ACWI	ETF	68.26	68.5	68.26	68.44	3610400.0
2017-09-28	ACWV	ETF	80.83	81.21	80.83	81.15	210800.0
2017-09-28	ACWX	ETF	47.9	48.06	47.875	48.01	323693.0
2017-09-28	ADRE	ETF	41.6	41.66	41.5366	41.6	7508.0
2017-09-28	AFK	ETF	23.27	23.36	23.25	23.35	6264.0
2017-09-28	AFTY	ETF	16.769	16.769	16.75	16.75	600.0
2017-09-28	AGG	ETF	109.58	109.72	109.51	109.68	1702500.0
2017-09-28	AGGY	ETF	50.62	50.7	50.61	50.66	7900.0
2017-09-28	AGNG	ETF	19.2	19.28	19.17	19.27	2500.0
2017-09-28	AGQ	ETF	33.76	34.11	33.5	33.94	60000.0
2017-09-28	AGZ	ETF	113.67	113.77	113.59	113.73	13666.0
2017-09-28	AGZD	ETF	24.0	24.0	23.96	23.96	18400.0
2017-09-28	AIA	ETF	60.5	60.7123	60.28	60.69	14010.0
2017-09-28	AIRR	ETF	25.93	26.09	25.84	26.08	28800.0
2017-09-28	AIVI	ETF	42.38	42.5	42.35	42.35	29100.0
2017-09-28	ALTY	ETF	15.59	15.72	15.59	15.72	2100.0
2017-09-28	AMJ	ETF	28.3	28.44	28.02	28.18	826849.0
2017-09-28	AMLP	ETF	56.35	56.45	55.7	56.0	1229040.0
2017-09-28	AMZA	ETF	93.4	93.4	91.9	92.7	104980.0
2017-09-28	ANGL	ETF	30.23	30.34	30.23	30.26	654600.0
2017-09-28	AOA	ETF	53.39	53.39	53.22	53.36	29600.0
2017-09-28	AOK	ETF	34.25	34.42	34.25	34.42	66145.0
2017-09-28	AOM	ETF	37.72	37.9	37.72	37.86	74858.0
2017-09-28	AOR	ETF	44.72	44.72	44.5787	44.67	61692.0
2017-09-28	ARCM	ETF	100.8	100.8	100.8	100.8	20.0
2017-09-28	ARGT	ETF	30.95	31.26	30.95	31.22	37500.0
2017-09-28	ARKG	ETF	25.62	26.2	25.509	26.046	30300.0
2017-09-28	ARKK	ETF	33.86	34.28	33.751	34.12	117200.0
2017-09-28	ARKQ	ETF	31.53	31.53	31.3	31.48	18300.0
2017-09-28	ARKW	ETF	40.38	40.429	40.17	40.37	24000.0
2017-09-28	ASEA	ETF	15.65	15.65	15.65	15.65	100.0
2017-09-28	ASET	ETF	27.95	28.03	27.95	28.03	1437.0
2017-09-28	ASHR	ETF	28.95	28.96	28.9	28.94	676900.0
2017-09-28	ASHS	ETF	36.16	36.16	36.12	36.16	10800.0
2017-09-28	ASHX	ETF	21.46	21.46	21.45	21.45	1501.0
2017-09-28	ATMP	ETF	21.22	21.44	21.22	21.29	66000.0
2017-09-28	BAB	ETF	30.31	30.39	30.3	30.38	150558.0
2017-09-28	BAL	ETF	45.06	45.6	45.06	45.5125	7332.0
2017-09-28	BAR	ETF	12.849	12.865	12.849	12.865	8400.0

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

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