PREVIEW / etf_daily / 2017-10-09

all etf daily files

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

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-10-09	SPY	ETF	254.63	254.7	253.65	253.95	35803100.0
2017-10-09	QQQ	ETF	147.86	148.0093	147.3	147.49	13704835.0
2017-10-09	IWM	ETF	150.19	150.68	149.18	149.43	13981300.0
2017-10-09	DIA	ETF	227.89	227.96	227.34	227.53	1006800.0
2017-10-09	GLD	ETF	121.64	122.11	121.55	122.08	5264100.0
2017-10-09	TLT	ETF	123.78	124.06	123.64	123.98	3590900.0
2017-10-09	AADR	ETF	56.89	56.9	56.59	56.71	47400.0
2017-10-09	AAXJ	ETF	73.5	73.8	73.48	73.77	879600.0
2017-10-09	ACSI	ETF	29.36	29.36	29.36	29.36	1314.0
2017-10-09	ACTX	ETF	59.0005	59.0005	47.7904	53.1005	509.0
2017-10-09	ACWF	ETF	29.43	29.43	29.399	29.399	388.0
2017-10-09	ACWI	ETF	69.45	69.46	69.22	69.27	625700.0
2017-10-09	ACWV	ETF	81.84	81.88	81.67	81.67	93900.0
2017-10-09	ACWX	ETF	48.57	48.57	48.47	48.5	123180.0
2017-10-09	ADRE	ETF	42.8	42.869	42.606	42.6845	5738.0
2017-10-09	AFK	ETF	23.6	23.6596	23.5877	23.61	7694.0
2017-10-09	AFTY	ETF	17.173	17.173	17.173	17.173	200.0
2017-10-09	AGG	ETF	109.35	109.43	109.3	109.43	1131500.0
2017-10-09	AGGY	ETF	50.68	50.72	50.62	50.72	8200.0
2017-10-09	AGNG	ETF	19.56	19.59	19.5	19.54	3000.0
2017-10-09	AGQ	ETF	34.18	34.43	34.05	34.36	112900.0
2017-10-09	AGZ	ETF	113.4452	113.5199	113.42	113.46	57914.0
2017-10-09	AGZD	ETF	24.06	24.06	24.06	24.06	400.0
2017-10-09	AIA	ETF	62.73	62.7455	62.5884	62.7	48841.0
2017-10-09	AIRR	ETF	26.42	26.42	26.117	26.14	137600.0
2017-10-09	AIVI	ETF	42.36	42.43	42.34	42.36	8600.0
2017-10-09	ALTY	ETF	15.78	15.78	15.71	15.71	1300.0
2017-10-09	AMJ	ETF	28.61	28.74	28.47	28.47	1040093.0
2017-10-09	AMLP	ETF	57.15	57.25	56.7	56.7	1210240.0
2017-10-09	AMZA	ETF	90.0	90.4	89.2	89.3	67100.0
2017-10-09	ANGL	ETF	30.28	30.28	30.18	30.23	226300.0
2017-10-09	AOA	ETF	53.87	53.87	53.62	53.73	51800.0
2017-10-09	AOK	ETF	34.52	34.52	34.43	34.48	60042.0
2017-10-09	AOM	ETF	37.82	37.95	37.82	37.87	235985.0
2017-10-09	AOR	ETF	44.92	44.9276	44.8	44.84	79489.0
2017-10-09	ARGT	ETF	32.46	32.56	32.22	32.26	73300.0
2017-10-09	ARKG	ETF	26.95	27.17	26.74	26.75	43200.0
2017-10-09	ARKK	ETF	35.29	35.29	34.9	34.947	80000.0
2017-10-09	ARKQ	ETF	32.79	32.79	32.54	32.566	34800.0
2017-10-09	ARKW	ETF	41.8	41.8	41.435	41.5	47300.0
2017-10-09	ASEA	ETF	15.75	15.78	15.75	15.78	200.0
2017-10-09	ASET	ETF	28.09	28.1	28.0594	28.0594	2667.0
2017-10-09	ASHR	ETF	29.72	29.81	29.71	29.77	551400.0
2017-10-09	ASHS	ETF	37.03	37.03	36.84	36.91	3000.0
2017-10-09	ATMP	ETF	21.44	21.65	21.44	21.55	6400.0
2017-10-09	BAB	ETF	30.34	30.37	30.29	30.34	41144.0
2017-10-09	BAL	ETF	45.15	45.2289	45.15	45.2289	579.0
2017-10-09	BAR	ETF	12.803	12.803	12.803	12.803	4980.0
2017-10-09	BBC	ETF	29.62	29.64	29.32	29.32	11848.0
2017-10-09	BBH	ETF	136.3	136.3	135.01	135.32	8100.0

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

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