PREVIEW / etf_daily / 2017-05-09

all etf daily files

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

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-09	SPY	ETF	239.96	240.19	239.04	239.44	51363200.0
2017-05-09	QQQ	ETF	138.05	138.628	137.93	138.32	28426109.0
2017-05-09	IWM	ETF	138.59	138.83	137.78	138.35	23988400.0
2017-05-09	DIA	ETF	210.14	210.32	209.22	209.62	1570100.0
2017-05-09	GLD	ETF	116.18	116.24	115.56	116.05	6801300.0
2017-05-09	TLT	ETF	120.38	120.63	120.14	120.62	5536700.0
2017-05-09	AADR	ETF	47.94	48.09	47.75	47.82	12200.0
2017-05-09	AAXJ	ETF	65.07	65.48	64.97	65.31	1903000.0
2017-05-09	ACSI	ETF	28.6604	28.67	28.62	28.62	1249.0
2017-05-09	ACTX	ETF	67.8506	74.0457	67.8506	72.5707	417.0
2017-05-09	ACWF	ETF	26.57	26.57	26.4929	26.4929	1220.0
2017-05-09	ACWI	ETF	64.91	65.04	64.78	64.87	1010100.0
2017-05-09	ACWV	ETF	78.43	78.51	78.25	78.34	403300.0
2017-05-09	ACWX	ETF	45.22	45.29	45.15	45.22	473575.0
2017-05-09	ADRE	ETF	37.68	37.97	37.5	37.94	21981.0
2017-05-09	AFK	ETF	21.0	21.1099	20.8485	20.8485	2752.0
2017-05-09	AFTY	ETF	13.5	13.52	13.5	13.5	1800.0
2017-05-09	AGG	ETF	108.43	108.51	108.4	108.5	3084900.0
2017-05-09	AGGY	ETF	49.97	50.0	49.89	50.0	4400.0
2017-05-09	AGQ	ETF	32.5	32.5	31.92	32.29	221000.0
2017-05-09	AGZ	ETF	112.98	113.14	112.88	113.07	32777.0
2017-05-09	AGZD	ETF	24.09	24.09	23.98	24.03	7800.0
2017-05-09	AIA	ETF	55.33	55.53	55.06	55.12	1558092.0
2017-05-09	AIQ	ETF	13.1	13.15	13.0	13.1	20295.0
2017-05-09	AIRR	ETF	24.31	24.31	24.02	24.2	59500.0
2017-05-09	AIVI	ETF	40.56	40.56	40.41	40.41	4400.0
2017-05-09	ALTY	ETF	15.392	15.392	15.392	15.392	100.0
2017-05-09	AMJ	ETF	31.27	31.4181	30.81	31.02	939520.0
2017-05-09	AMLP	ETF	62.1	62.25	61.55	61.8	1440400.0
2017-05-09	AMZA	ETF	103.8	103.9	102.4	103.0	92160.0
2017-05-09	ANGL	ETF	29.5	29.5	29.39	29.4	340000.0
2017-05-09	AOA	ETF	50.99	51.01	50.85	50.96	44200.0
2017-05-09	AOK	ETF	33.61	33.61	33.5564	33.61	43606.0
2017-05-09	AOM	ETF	36.78	36.793	36.69	36.69	106421.0
2017-05-09	AOR	ETF	43.05	43.05	42.954	43.01	80805.0
2017-05-09	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-05-09	ARGT	ETF	29.91	29.92	29.78	29.88	65500.0
2017-05-09	ARKG	ETF	20.03	20.08	19.91	20.079	2800.0
2017-05-09	ARKK	ETF	25.87	26.27	25.87	26.27	34900.0
2017-05-09	ARKQ	ETF	26.95	27.32	26.95	27.28	58300.0
2017-05-09	ARKW	ETF	31.25	31.73	31.228	31.7	22700.0
2017-05-09	ASEA	ETF	14.73	14.73	14.73	14.73	300.0
2017-05-09	ASET	ETF	26.89	26.89	26.8206	26.84	3210.0
2017-05-09	ASHR	ETF	24.19	24.19	24.11	24.15	514700.0
2017-05-09	ASHS	ETF	31.45	31.45	31.36	31.38	4800.0
2017-05-09	ASHX	ETF	18.85	18.85	18.7896	18.7896	840.0
2017-05-09	ATMP	ETF	23.14	23.14	22.76	22.88	45600.0
2017-05-09	BAB	ETF	29.35	29.4	29.3	29.32	106019.0
2017-05-09	BAL	ETF	49.21	49.39	49.197	49.32	5092.0
2017-05-09	BBC	ETF	21.26	21.4116	21.16	21.35	3019.0

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

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