PREVIEW / etf_daily / 2017-08-07

all etf daily files

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

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-07	SPY	ETF	247.49	247.87	247.37	247.87	31995000.0
2017-08-07	QQQ	ETF	143.89	144.56	143.71	144.56	17933942.0
2017-08-07	IWM	ETF	140.44	140.85	139.71	140.44	9176200.0
2017-08-07	DIA	ETF	220.75	220.98	220.6	220.85	1902800.0
2017-08-07	GLD	ETF	119.43	119.79	119.43	119.51	3010100.0
2017-08-07	TLT	ETF	124.84	125.1	124.61	125.07	4684600.0
2017-08-07	AADR	ETF	50.07	50.76	50.07	50.67	10400.0
2017-08-07	AAXJ	ETF	71.22	71.5	71.22	71.5	655300.0
2017-08-07	ACSI	ETF	29.38	29.4099	29.28	29.4	4930.0
2017-08-07	ACTX	ETF	100.3009	100.3009	85.5508	88.5008	937.0
2017-08-07	ACWF	ETF	28.138	28.16	28.138	28.16	4063.0
2017-08-07	ACWI	ETF	67.52	67.61	67.47	67.59	917600.0
2017-08-07	ACWV	ETF	80.69	80.8	80.66	80.8	40800.0
2017-08-07	ACWX	ETF	47.4	47.56	47.4	47.55	507239.0
2017-08-07	ADRE	ETF	41.73	42.13	41.73	42.13	7071.0
2017-08-07	AFK	ETF	23.01	23.2	22.9901	23.13	11797.0
2017-08-07	AFTY	ETF	16.04	16.074	16.04	16.074	1600.0
2017-08-07	AGG	ETF	109.69	109.72	109.61	109.67	2359800.0
2017-08-07	AGGY	ETF	50.74	50.77	50.71	50.75	7800.0
2017-08-07	AGNG	ETF	18.789	18.789	18.742	18.742	1200.0
2017-08-07	AGQ	ETF	31.54	32.11	31.54	31.87	55300.0
2017-08-07	AGZ	ETF	113.84	113.88	113.7865	113.88	9853.0
2017-08-07	AGZD	ETF	24.0	24.0	24.0	24.0	600.0
2017-08-07	AIA	ETF	60.75	60.8	60.67	60.79	41904.0
2017-08-07	AIQ	ETF	13.2	13.2	13.05	13.2	31712.0
2017-08-07	AIRR	ETF	23.7	23.84	23.685	23.84	54500.0
2017-08-07	AIVI	ETF	41.95	42.06	41.95	42.02	6700.0
2017-08-07	ALTY	ETF	15.91	15.91	15.6	15.65	2300.0
2017-08-07	AMJ	ETF	29.5	29.52	29.33	29.4	833548.0
2017-08-07	AMLP	ETF	59.25	59.35	58.85	58.9	1309640.0
2017-08-07	AMZA	ETF	96.2	96.5	94.88	95.0	113120.0
2017-08-07	ANGL	ETF	29.94	29.94	29.85	29.92	318900.0
2017-08-07	AOA	ETF	52.72	52.78	52.67	52.71	41000.0
2017-08-07	AOK	ETF	34.24	34.28	34.21	34.21	51608.0
2017-08-07	AOM	ETF	37.53	37.65	37.53	37.65	103188.0
2017-08-07	AOR	ETF	44.19	44.28	44.1828	44.24	92139.0
2017-08-07	ARCM	ETF	100.0	100.0	100.0	100.0	12000.0
2017-08-07	ARGT	ETF	28.79	28.79	28.52	28.59	46000.0
2017-08-07	ARKG	ETF	22.78	23.071	22.65	22.98	22900.0
2017-08-07	ARKK	ETF	30.4	30.98	30.4	30.97	96300.0
2017-08-07	ARKQ	ETF	29.75	29.78	29.56	29.676	20500.0
2017-08-07	ARKW	ETF	37.58	38.12	37.58	38.12	59700.0
2017-08-07	ASEA	ETF	15.37	15.45	15.34	15.39	6400.0
2017-08-07	ASET	ETF	28.06	28.06	28.035	28.05	3129.0
2017-08-07	ASHR	ETF	28.05	28.11	28.03	28.08	564000.0
2017-08-07	ASHS	ETF	34.2	34.2	34.13	34.15	3700.0
2017-08-07	ATMP	ETF	22.43	22.44	22.22	22.3	33200.0
2017-08-07	BAB	ETF	30.23	30.3112	30.18	30.27	125784.0
2017-08-07	BAL	ETF	46.75	46.87	46.6056	46.6056	7098.0
2017-08-07	BBC	ETF	24.5	24.7416	24.46	24.7416	11220.0

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

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