PREVIEW / etf_daily / 2017-08-30

all etf daily files

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

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-30	SPY	ETF	244.83	246.32	244.62	246.01	62030800.0
2017-08-30	QQQ	ETF	143.11	144.89	143.0	144.65	33642716.0
2017-08-30	IWM	ETF	137.36	138.51	137.25	138.37	15915500.0
2017-08-30	DIA	ETF	218.75	219.16	218.39	218.93	1804100.0
2017-08-30	GLD	ETF	124.33	124.62	124.16	124.36	6328400.0
2017-08-30	TLT	ETF	127.46	127.74	127.34	127.61	4735200.0
2017-08-30	AADR	ETF	52.1	52.33	51.8	52.3	23300.0
2017-08-30	AAXJ	ETF	71.83	71.94	71.72	71.83	893600.0
2017-08-30	ACSI	ETF	28.65	28.73	28.65	28.73	1318.0
2017-08-30	ACTX	ETF	76.7007	76.7007	71.3906	74.3407	301.0
2017-08-30	ACWF	ETF	27.99	28.06	27.99	28.06	315.0
2017-08-30	ACWI	ETF	66.97	67.18	66.9	67.14	781200.0
2017-08-30	ACWV	ETF	80.77	80.94	80.68	80.82	100400.0
2017-08-30	ACWX	ETF	47.05	47.1399	47.01	47.08	155474.0
2017-08-30	ADRE	ETF	42.25	42.48	42.24	42.44	7692.0
2017-08-30	AFK	ETF	23.8	24.4	23.572	23.73	9888.0
2017-08-30	AFTY	ETF	17.2	17.2	17.128	17.165	6000.0
2017-08-30	AGG	ETF	110.27	110.33	110.24	110.3	1505700.0
2017-08-30	AGGY	ETF	50.868	50.92	50.86	50.92	16600.0
2017-08-30	AGNG	ETF	18.79	19.028	18.79	19.028	400.0
2017-08-30	AGQ	ETF	36.44	36.67	36.3	36.51	99000.0
2017-08-30	AGZ	ETF	114.31	114.3475	114.28	114.28	24497.0
2017-08-30	AGZD	ETF	23.96	23.96	23.935	23.96	2600.0
2017-08-30	AIA	ETF	60.92	61.05	60.87	61.01	37652.0
2017-08-30	AIRR	ETF	23.17	23.41	23.1	23.35	28500.0
2017-08-30	AIVI	ETF	41.79	41.8	41.71	41.72	9700.0
2017-08-30	ALTY	ETF	15.82	15.82	15.539	15.59	4900.0
2017-08-30	AMJ	ETF	27.25	27.6	27.2083	27.58	2651802.0
2017-08-30	AMLP	ETF	54.0	54.85	53.9	54.75	1488300.0
2017-08-30	AMZA	ETF	89.0	90.39	88.5	90.1	55020.0
2017-08-30	ANGL	ETF	29.91	29.97	29.87	29.94	600300.0
2017-08-30	AOA	ETF	52.29	52.44	52.27	52.43	31800.0
2017-08-30	AOK	ETF	34.24	34.29	34.18	34.23	64179.0
2017-08-30	AOM	ETF	37.53	37.61	37.5	37.6	59212.0
2017-08-30	AOR	ETF	44.01	44.12	43.9938	44.11	49475.0
2017-08-30	ARCM	ETF	100.05	100.195	100.05	100.195	78600.0
2017-08-30	ARGT	ETF	29.5	29.5	29.34	29.49	45700.0
2017-08-30	ARKG	ETF	24.2	24.54	24.2	24.4	38300.0
2017-08-30	ARKK	ETF	32.96	33.49	32.88	33.42	141200.0
2017-08-30	ARKQ	ETF	29.72	30.01	29.556	30.0	27500.0
2017-08-30	ARKW	ETF	39.78	40.53	39.72	40.49	95900.0
2017-08-30	ASEA	ETF	15.44	15.47	15.44	15.47	1900.0
2017-08-30	ASET	ETF	27.965	27.9761	27.965	27.97	496.0
2017-08-30	ASHR	ETF	29.49	29.5	29.41	29.41	648200.0
2017-08-30	ASHS	ETF	35.51	35.62	35.51	35.61	6800.0
2017-08-30	ASHX	ETF	21.72	21.72	21.72	21.72	200.0
2017-08-30	ATMP	ETF	20.85	20.89	20.66	20.89	211300.0
2017-08-30	BAB	ETF	30.54	30.5884	30.43	30.55	112146.0
2017-08-30	BAL	ETF	46.53	46.8413	46.4487	46.73	4338.0
2017-08-30	BBC	ETF	26.69	27.07	26.66	26.8	27027.0

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

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