PREVIEW / etf_daily / 2017-07-31

all etf daily files

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

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-31	SPY	ETF	247.37	247.48	246.53	246.77	65838700.0
2017-07-31	QQQ	ETF	144.22	144.43	142.92	143.23	33848645.0
2017-07-31	IWM	ETF	142.22	142.38	140.97	141.51	16417700.0
2017-07-31	DIA	ETF	218.65	219.03	218.49	218.7	1765000.0
2017-07-31	GLD	ETF	120.5	120.81	120.45	120.75	3944600.0
2017-07-31	TLT	ETF	123.46	124.05	123.4	124.04	5464600.0
2017-07-31	AADR	ETF	49.47	49.59	49.3	49.42	39700.0
2017-07-31	AAXJ	ETF	71.06	71.06	70.76	70.84	608600.0
2017-07-31	ACSI	ETF	29.28	29.28	28.95	28.97	12805.0
2017-07-31	ACTX	ETF	73.7507	73.7507	67.2606	70.8006	254.0
2017-07-31	ACWF	ETF	27.99	28.0205	27.9501	27.9501	1891.0
2017-07-31	ACWI	ETF	67.35	67.35	67.13	67.28	2577700.0
2017-07-31	ACWV	ETF	80.49	80.61	80.39	80.56	58100.0
2017-07-31	ACWX	ETF	47.2	47.25	47.07	47.19	188917.0
2017-07-31	ADRE	ETF	41.69	41.83	41.4501	41.4701	4984.0
2017-07-31	AFK	ETF	23.27	23.27	22.88	23.03	12863.0
2017-07-31	AFTY	ETF	16.2	16.2	16.2	16.2	100.0
2017-07-31	AGG	ETF	109.69	109.73	109.58	109.65	2363000.0
2017-07-31	AGGY	ETF	50.64	50.69	50.6	50.69	43700.0
2017-07-31	AGNG	ETF	19.26	19.26	18.807	18.807	6100.0
2017-07-31	AGQ	ETF	34.34	34.6	34.22	34.43	112400.0
2017-07-31	AGZ	ETF	113.88	113.91	113.75	113.89	5996.0
2017-07-31	AGZD	ETF	23.98	24.01	23.98	24.01	7600.0
2017-07-31	AIA	ETF	60.22	60.26	60.17	60.2	30750.0
2017-07-31	AIQ	ETF	13.25	13.25	13.2	13.25	47495.0
2017-07-31	AIRR	ETF	23.84	24.001	23.8	23.91	58500.0
2017-07-31	AIVI	ETF	41.83	41.89	41.77	41.89	8100.0
2017-07-31	ALTY	ETF	15.72	15.76	15.618	15.72	2000.0
2017-07-31	AMJ	ETF	29.9	30.11	29.76	30.04	548609.0
2017-07-31	AMLP	ETF	59.9	60.1	59.65	60.0	1368020.0
2017-07-31	AMZA	ETF	97.0	97.27	96.4	97.2	70790.0
2017-07-31	ANGL	ETF	29.98	30.02	29.93	29.94	1034900.0
2017-07-31	AOA	ETF	52.54	52.54	52.43	52.49	45000.0
2017-07-31	AOK	ETF	34.19	34.22	34.15	34.16	68055.0
2017-07-31	AOM	ETF	37.52	37.58	37.46	37.52	79909.0
2017-07-31	AOR	ETF	44.14	44.14	44.039	44.12	66863.0
2017-07-31	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-07-31	ARGT	ETF	29.87	29.92	29.61	29.7	22400.0
2017-07-31	ARKG	ETF	22.74	22.74	22.24	22.29	14600.0
2017-07-31	ARKK	ETF	30.16	30.16	29.54	29.622	31100.0
2017-07-31	ARKQ	ETF	29.99	29.99	29.527	29.63	23900.0
2017-07-31	ARKW	ETF	37.49	37.49	36.69	36.85	32300.0
2017-07-31	ASEA	ETF	15.36	15.43	15.36	15.4	19100.0
2017-07-31	ASET	ETF	27.8971	27.935	27.8971	27.935	2638.0
2017-07-31	ASHR	ETF	28.1	28.23	28.1	28.21	440300.0
2017-07-31	ASHS	ETF	34.04	34.3	34.04	34.21	9600.0
2017-07-31	ATMP	ETF	22.69	22.84	22.61	22.8	8000.0
2017-07-31	BAB	ETF	30.03	30.096	29.97	30.09	59319.0
2017-07-31	BAL	ETF	45.32	45.94	45.32	45.39	3496.0
2017-07-31	BBC	ETF	24.63	24.68	24.22	24.22	25031.0

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

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