PREVIEW / etf_daily / 2017-03-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-16.parquet
  size:    54 KB
  rows:    1,376

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-03-16	SPY	ETF	239.11	239.2	238.1	238.48	78344000.0
2017-03-16	QQQ	ETF	132.33	132.35	131.71	132.01	18457291.0
2017-03-16	IWM	ETF	138.22	138.51	137.56	137.91	25306600.0
2017-03-16	DIA	ETF	210.17	210.17	209.05	209.44	3018400.0
2017-03-16	GLD	ETF	117.27	117.29	116.69	116.73	9322000.0
2017-03-16	TLT	ETF	117.99	118.15	117.63	117.9	8018200.0
2017-03-16	AADR	ETF	46.24	46.4	46.05	46.17	39100.0
2017-03-16	AAXJ	ETF	62.85	63.04	62.72	62.92	2113600.0
2017-03-16	ACSI	ETF	28.07	28.1	28.0575	28.0575	3036.0
2017-03-16	ACTX	ETF	109.741	112.101	97.3509	105.6109	1292.0
2017-03-16	ACWF	ETF	25.95	25.95	25.94	25.94	641.0
2017-03-16	ACWI	ETF	63.65	63.69	63.44	63.54	2072300.0
2017-03-16	ACWV	ETF	77.46	77.46	77.17	77.22	519900.0
2017-03-16	ACWX	ETF	43.56	43.58	43.46	43.54	304478.0
2017-03-16	ADRE	ETF	36.6	36.745	36.6	36.63	3861.0
2017-03-16	AFK	ETF	21.11	21.24	21.1	21.16	33012.0
2017-03-16	AFTY	ETF	14.0	14.022	13.95	13.96	7300.0
2017-03-16	AGG	ETF	107.68	107.75	107.62	107.66	2369700.0
2017-03-16	AGGY	ETF	49.39	49.462	49.39	49.428	5600.0
2017-03-16	AGQ	ETF	38.16	38.16	37.1	37.36	149900.0
2017-03-16	AGZ	ETF	112.52	112.64	112.41	112.61	37194.0
2017-03-16	AIA	ETF	52.72	52.72	52.53	52.585	24160.0
2017-03-16	AIQ	ETF	10.184	10.184	10.0	10.0	7516.0
2017-03-16	AIRR	ETF	24.05	24.05	23.79	23.87	38900.0
2017-03-16	AIVI	ETF	39.5	39.64	39.47	39.53	38400.0
2017-03-16	ALTY	ETF	15.39	15.42	15.295	15.42	3000.0
2017-03-16	AMJ	ETF	32.3	32.3	31.895	32.01	912533.0
2017-03-16	AMLP	ETF	63.7	63.85	63.3	63.45	1203880.0
2017-03-16	AMZA	ETF	110.6	111.37	110.2	110.25	56480.0
2017-03-16	ANGL	ETF	29.33	29.34	29.12	29.16	315800.0
2017-03-16	AOA	ETF	50.01	50.03	49.86	49.97	37600.0
2017-03-16	AOK	ETF	33.19	33.19	33.1	33.11	49250.0
2017-03-16	AOM	ETF	36.3	36.31	36.2201	36.25	102859.0
2017-03-16	AOR	ETF	42.32	42.36	42.25	42.25	41015.0
2017-03-16	ARGT	ETF	27.52	27.64	27.47	27.6	33400.0
2017-03-16	ARKG	ETF	20.7	20.74	20.587	20.64	1500.0
2017-03-16	ARKK	ETF	23.745	23.78	23.68	23.72	1700.0
2017-03-16	ARKQ	ETF	24.1	24.247	24.1	24.215	1700.0
2017-03-16	ARKW	ETF	28.93	28.948	28.87	28.87	3000.0
2017-03-16	ASEA	ETF	13.95	13.95	13.95	13.95	1400.0
2017-03-16	ASET	ETF	26.33	26.33	26.28	26.31	2438.0
2017-03-16	ASHR	ETF	25.4	25.44	25.36	25.42	615500.0
2017-03-16	ASHS	ETF	34.72	34.72	34.58	34.62	3000.0
2017-03-16	ASHX	ETF	19.69	19.69	19.69	19.69	535.0
2017-03-16	ATMP	ETF	23.53	23.65	23.5	23.6	61900.0
2017-03-16	BAB	ETF	29.15	29.15	29.04	29.08	100134.0
2017-03-16	BAL	ETF	51.3	51.3	50.7801	50.87	9321.0
2017-03-16	BBC	ETF	24.17	24.17	23.55	23.7	55381.0
2017-03-16	BBH	ETF	122.66	122.66	120.52	121.0	72100.0
2017-03-16	BBP	ETF	38.56	38.56	37.85	37.999	7100.0

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

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