PREVIEW / etf_daily / 2017-07-06

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-06.parquet
  size:    56 KB
  rows:    1,423

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-07-06	SPY	ETF	241.89	242.03	240.34	240.55	65400800.0
2017-07-06	QQQ	ETF	136.47	137.06	135.8	136.29	48430476.0
2017-07-06	IWM	ETF	139.93	140.47	138.83	139.14	30563400.0
2017-07-06	DIA	ETF	214.09	214.25	212.94	213.14	2297500.0
2017-07-06	GLD	ETF	116.58	116.61	116.24	116.47	4443400.0
2017-07-06	TLT	ETF	123.52	123.64	122.93	123.46	10853100.0
2017-07-06	AADR	ETF	46.87	47.09	46.69	46.81	18100.0
2017-07-06	AAXJ	ETF	67.08	67.17	66.75	66.77	689700.0
2017-07-06	ACSI	ETF	28.72	28.72	28.46	28.46	6052.0
2017-07-06	ACTX	ETF	94.4008	100.3009	93.2208	97.9409	383.0
2017-07-06	ACWF	ETF	27.11	27.2	27.11	27.125	1196.0
2017-07-06	ACWI	ETF	65.32	65.37	65.02	65.09	2196100.0
2017-07-06	ACWV	ETF	78.55	78.55	78.21	78.27	111900.0
2017-07-06	ACWX	ETF	45.3	45.44	45.22	45.3	600333.0
2017-07-06	ADRE	ETF	38.45	38.46	38.2001	38.32	3956.0
2017-07-06	AFK	ETF	21.5	21.5	21.39	21.48	4245.0
2017-07-06	AGG	ETF	108.95	109.0	108.82	108.94	2284900.0
2017-07-06	AGGY	ETF	50.3	50.42	50.216	50.3	21400.0
2017-07-06	AGNG	ETF	18.75	18.75	18.54	18.54	1700.0
2017-07-06	AGQ	ETF	31.45	31.45	31.1	31.41	145100.0
2017-07-06	AGZ	ETF	113.3214	113.46	113.234	113.39	5641.0
2017-07-06	AGZD	ETF	23.975	23.975	23.96	23.96	2000.0
2017-07-06	AIA	ETF	56.62	56.62	56.26	56.26	41706.0
2017-07-06	AIQ	ETF	13.2499	13.25	13.2	13.25	23681.0
2017-07-06	AIRR	ETF	23.59	23.83	23.54	23.57	19100.0
2017-07-06	AIVI	ETF	40.38	40.54	40.34	40.43	11300.0
2017-07-06	ALTY	ETF	15.429	15.429	15.429	15.429	500.0
2017-07-06	AMJ	ETF	29.82	30.1	29.4965	29.65	2104215.0
2017-07-06	AMLP	ETF	59.9	60.3	59.35	59.55	4550760.0
2017-07-06	AMZA	ETF	97.0	97.4	95.11	95.7	122810.0
2017-07-06	ANGL	ETF	29.46	29.48	29.35	29.4	626000.0
2017-07-06	AOA	ETF	51.27	51.28	51.02	51.09	59900.0
2017-07-06	AOK	ETF	33.7	33.74	33.63	33.64	46595.0
2017-07-06	AOM	ETF	36.92	36.92	36.79	36.85	79790.0
2017-07-06	AOR	ETF	43.18	43.18	43.07	43.11	65708.0
2017-07-06	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-06	ARGT	ETF	29.43	29.48	29.32	29.4	21300.0
2017-07-06	ARKG	ETF	22.5	22.5	22.091	22.091	12800.0
2017-07-06	ARKK	ETF	28.8	28.8	28.349	28.4	52600.0
2017-07-06	ARKQ	ETF	27.78	27.87	27.57	27.63	23000.0
2017-07-06	ARKW	ETF	34.83	34.83	34.37	34.43	20800.0
2017-07-06	ASEA	ETF	15.01	15.02	15.01	15.01	1400.0
2017-07-06	ASET	ETF	26.96	27.01	26.9583	26.96	1054.0
2017-07-06	ASHR	ETF	27.19	27.21	27.08	27.09	457200.0
2017-07-06	ASHS	ETF	33.17	33.22	33.16	33.16	1000.0
2017-07-06	ASHX	ETF	20.68	20.68	20.68	20.68	113.0
2017-07-06	ATMP	ETF	22.55	22.55	22.2	22.29	31300.0
2017-07-06	BAB	ETF	29.92	29.97	29.77	29.94	104888.0
2017-07-06	BAL	ETF	44.457	44.78	44.457	44.765	1332.0
2017-07-06	BBC	ETF	24.7779	24.987	24.49	24.53	7137.0

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

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