PREVIEW / etf_daily / 2017-08-31

all etf daily files

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

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-08-31	SPY	ETF	246.72	247.77	246.05	247.49	103803900.0
2017-08-31	QQQ	ETF	145.03	146.21	144.98	146.2	38480747.0
2017-08-31	IWM	ETF	138.91	139.94	138.67	139.73	29260600.0
2017-08-31	DIA	ETF	219.53	219.89	219.12	219.52	2173000.0
2017-08-31	GLD	ETF	124.58	125.84	124.55	125.82	11775500.0
2017-08-31	TLT	ETF	127.64	128.03	127.57	127.99	7978400.0
2017-08-31	AADR	ETF	52.32	52.67	52.15	52.51	31000.0
2017-08-31	AAXJ	ETF	71.98	72.17	71.88	72.07	802400.0
2017-08-31	ACSI	ETF	28.75	28.8	28.75	28.8	1649.0
2017-08-31	ACTX	ETF	73.7507	76.7007	71.3906	73.4557	275.0
2017-08-31	ACWF	ETF	28.21	28.21	28.21	28.21	272.0
2017-08-31	ACWI	ETF	67.3	67.62	67.3	67.55	1045100.0
2017-08-31	ACWV	ETF	81.01	81.32	80.93	81.26	161900.0
2017-08-31	ACWX	ETF	47.28	47.46	47.225	47.39	676318.0
2017-08-31	ADRE	ETF	42.46	42.7	42.3422	42.6469	8284.0
2017-08-31	AFK	ETF	23.87	23.88	23.75	23.88	6477.0
2017-08-31	AFTY	ETF	17.03	17.09	17.01	17.09	9500.0
2017-08-31	AGG	ETF	110.31	110.46	110.31	110.45	5308300.0
2017-08-31	AGGY	ETF	50.95	51.01	50.9	51.01	8700.0
2017-08-31	AGNG	ETF	19.08	19.28	19.08	19.28	1200.0
2017-08-31	AGQ	ETF	36.49	37.35	36.49	37.31	139400.0
2017-08-31	AGZ	ETF	114.3	114.42	114.3	114.41	8995.0
2017-08-31	AIA	ETF	61.0	61.1199	60.88	61.03	41803.0
2017-08-31	AIRR	ETF	23.42	23.665	23.42	23.66	17600.0
2017-08-31	AIVI	ETF	41.86	42.11	41.86	42.07	15800.0
2017-08-31	ALTY	ETF	15.86	15.86	15.657	15.7	8700.0
2017-08-31	AMJ	ETF	27.61	28.19	27.43	28.16	3318462.0
2017-08-31	AMLP	ETF	54.85	56.15	54.85	56.0	2439720.0
2017-08-31	AMZA	ETF	90.5	92.9	90.39	92.7	81930.0
2017-08-31	ANGL	ETF	29.95	30.03	29.87	30.02	1627200.0
2017-08-31	AOA	ETF	52.59	52.77	52.53	52.74	150700.0
2017-08-31	AOK	ETF	34.33	34.4199	34.2853	34.41	38949.0
2017-08-31	AOM	ETF	37.62	37.78	37.4897	37.74	85024.0
2017-08-31	AOR	ETF	44.25	44.3499	44.1759	44.33	107534.0
2017-08-31	ARGT	ETF	29.6	29.95	29.57	29.71	194000.0
2017-08-31	ARKG	ETF	24.4	25.28	24.4	25.15	70500.0
2017-08-31	ARKK	ETF	33.9	34.32	33.88	34.142	248400.0
2017-08-31	ARKQ	ETF	30.25	30.39	30.25	30.36	37400.0
2017-08-31	ARKW	ETF	40.78	41.31	40.78	41.2	98300.0
2017-08-31	ASEA	ETF	15.49	15.49	15.42	15.42	800.0
2017-08-31	ASET	ETF	28.144	28.144	28.144	28.144	228.0
2017-08-31	ASHR	ETF	29.41	29.46	29.33	29.41	868500.0
2017-08-31	ASHS	ETF	35.91	35.92	35.71	35.87	24400.0
2017-08-31	ASHX	ETF	21.6904	21.6904	21.6796	21.69	430.0
2017-08-31	ATMP	ETF	20.95	21.27	20.88	21.26	86600.0
2017-08-31	BAB	ETF	30.6	30.66	30.49	30.66	699226.0
2017-08-31	BAL	ETF	46.82	46.88	46.59	46.8608	4276.0
2017-08-31	BAR	ETF	13.135	13.182	13.135	13.182	5260.0
2017-08-31	BBC	ETF	27.01	27.7492	27.01	27.64	18853.0
2017-08-31	BBH	ETF	132.76	135.4	132.64	135.23	161900.0

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

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