PREVIEW / etf_daily / 2017-05-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-03.parquet
  size:    55 KB
  rows:    1,386

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-05-03	SPY	ETF	238.77	238.88	237.7	238.48	73137700.0
2017-05-03	QQQ	ETF	137.14	137.17	136.615	136.99	23827550.0
2017-05-03	IWM	ETF	138.49	138.76	137.69	138.29	27050300.0
2017-05-03	DIA	ETF	209.13	209.47	208.47	209.22	1829400.0
2017-05-03	GLD	ETF	119.18	119.34	117.92	117.98	10811100.0
2017-05-03	TLT	ETF	122.22	122.39	121.55	121.78	8932900.0
2017-05-03	AADR	ETF	47.93	47.94	47.47	47.72	23900.0
2017-05-03	AAXJ	ETF	64.76	64.76	64.42	64.61	351700.0
2017-05-03	ACSI	ETF	28.4098	28.46	28.4098	28.46	662.0
2017-05-03	ACTX	ETF	84.3708	84.3708	77.8807	82.0107	384.0
2017-05-03	ACWF	ETF	26.29	26.37	26.27	26.37	4623.0
2017-05-03	ACWI	ETF	64.47	64.52	64.31	64.45	938800.0
2017-05-03	ACWV	ETF	77.93	77.93	77.66	77.8	100400.0
2017-05-03	ACWX	ETF	44.82	44.85	44.6981	44.765	859943.0
2017-05-03	ADRE	ETF	37.3	37.3	37.1	37.1953	2026.0
2017-05-03	AFK	ETF	21.23	21.23	21.11	21.11	1897.0
2017-05-03	AFTY	ETF	13.58	13.6	13.58	13.6	10900.0
2017-05-03	AGG	ETF	108.97	108.99	108.77	108.77	1923400.0
2017-05-03	AGGY	ETF	50.21	50.21	50.11	50.13	6900.0
2017-05-03	AGNG	ETF	17.62	17.62	17.62	17.62	400.0
2017-05-03	AGQ	ETF	34.36	34.42	33.48	33.55	326100.0
2017-05-03	AGZ	ETF	113.23	113.386	113.18	113.29	9056.0
2017-05-03	AGZD	ETF	23.99	24.055	23.99	24.055	13400.0
2017-05-03	AIA	ETF	54.47	54.47	54.2	54.32	20971.0
2017-05-03	AIQ	ETF	13.15	13.2	13.1	13.15	18749.0
2017-05-03	AIRR	ETF	24.38	24.38	24.09	24.21	36700.0
2017-05-03	AIVI	ETF	40.11	40.11	39.92	40.01	7800.0
2017-05-03	ALTY	ETF	15.6	15.65	15.6	15.65	1600.0
2017-05-03	AMJ	ETF	31.77	31.8	31.42	31.42	1434705.0
2017-05-03	AMLP	ETF	62.85	62.95	62.4	62.55	2553100.0
2017-05-03	AMZA	ETF	105.0	105.4	104.0	104.2	48570.0
2017-05-03	ANGL	ETF	29.61	29.63	29.54	29.59	207200.0
2017-05-03	AOA	ETF	50.74	50.74	50.61	50.73	57800.0
2017-05-03	AOK	ETF	33.55	33.62	33.5496	33.58	37601.0
2017-05-03	AOM	ETF	36.77	36.77	36.7	36.75	87864.0
2017-05-03	AOR	ETF	42.89	42.9	42.8	42.9	73438.0
2017-05-03	ARCM	ETF	100.0	100.0	100.0	100.0	4000.0
2017-05-03	ARGT	ETF	28.97	29.21	28.91	29.19	13300.0
2017-05-03	ARKG	ETF	20.54	20.55	19.95	20.34	5900.0
2017-05-03	ARKK	ETF	25.635	25.635	25.45	25.59	8200.0
2017-05-03	ARKQ	ETF	26.83	26.83	26.57	26.653	6400.0
2017-05-03	ARKW	ETF	30.76	30.76	30.37	30.58	24900.0
2017-05-03	ASEA	ETF	14.63	14.63	14.6	14.6	400.0
2017-05-03	ASET	ETF	26.7699	26.79	26.7699	26.79	3212.0
2017-05-03	ASHR	ETF	24.69	24.69	24.6	24.64	591800.0
2017-05-03	ASHS	ETF	32.43	32.45	32.39	32.39	2600.0
2017-05-03	ATMP	ETF	24.01	24.01	23.14	23.26	41800.0
2017-05-03	BAB	ETF	29.5	29.5628	29.4697	29.48	146340.0
2017-05-03	BAL	ETF	50.42	50.5	50.1425	50.16	3587.0
2017-05-03	BBC	ETF	22.3	22.3	22.01	22.1447	25767.0

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

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