PREVIEW / etf_daily / 2017-09-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-20.parquet
  size:    57 KB
  rows:    1,451

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-09-20	SPY	ETF	250.07	250.19	248.92	250.06	59574100.0
2017-09-20	QQQ	ETF	145.75	145.91	144.23	145.35	34236155.0
2017-09-20	IWM	ETF	143.53	144.02	143.26	143.84	20244700.0
2017-09-20	DIA	ETF	223.57	223.95	222.95	223.9	1819900.0
2017-09-20	GLD	ETF	124.68	125.06	123.15	123.62	11415400.0
2017-09-20	TLT	ETF	125.97	126.05	125.33	125.91	8037000.0
2017-09-20	AADR	ETF	55.93	56.15	54.92	55.37	44000.0
2017-09-20	AAXJ	ETF	73.8	73.87	72.85	73.4	606600.0
2017-09-20	ACSI	ETF	28.86	28.939	28.86	28.939	3182.0
2017-09-20	ACTX	ETF	72.5707	76.1107	70.8006	70.8006	459.0
2017-09-20	ACWI	ETF	68.88	68.97	68.51	68.87	2005000.0
2017-09-20	ACWV	ETF	81.56	81.66	81.04	81.35	88000.0
2017-09-20	ACWX	ETF	48.62	48.71	48.2044	48.5	555236.0
2017-09-20	ADRE	ETF	43.29	43.38	42.591	42.88	12748.0
2017-09-20	AFK	ETF	23.25	23.56	23.25	23.3195	5301.0
2017-09-20	AFTY	ETF	17.06	17.13	16.93	16.94	3500.0
2017-09-20	AGG	ETF	109.84	109.92	109.59	109.71	1356800.0
2017-09-20	AGGY	ETF	50.89	50.89	50.706	50.762	12100.0
2017-09-20	AGNG	ETF	19.56	19.6	19.52	19.552	2700.0
2017-09-20	AGQ	ETF	35.67	36.12	34.46	35.12	142600.0
2017-09-20	AGZ	ETF	113.894	113.9	113.7	113.8	16524.0
2017-09-20	AGZD	ETF	24.07	24.07	23.965	24.015	8800.0
2017-09-20	AIA	ETF	62.03	62.25	61.63	62.0	46969.0
2017-09-20	AIRR	ETF	24.83	25.06	24.83	24.96	21500.0
2017-09-20	AIVI	ETF	43.29	43.33	42.9	43.1	8000.0
2017-09-20	ALTY	ETF	15.7	15.7	15.61	15.61	7900.0
2017-09-20	AMJ	ETF	28.18	28.3134	28.01	28.11	1579506.0
2017-09-20	AMLP	ETF	56.15	56.45	55.85	56.0	1202300.0
2017-09-20	AMZA	ETF	92.7	93.1	92.0	92.2	82830.0
2017-09-20	ANGL	ETF	30.19	30.21	30.1	30.14	233500.0
2017-09-20	AOA	ETF	53.56	53.57	53.19	53.4	37600.0
2017-09-20	AOK	ETF	34.48	34.51	34.36	34.39	134081.0
2017-09-20	AOM	ETF	38.0	38.03	37.82	37.89	79769.0
2017-09-20	AOR	ETF	44.85	44.85	44.5824	44.69	142882.0
2017-09-20	ARGT	ETF	31.57	31.8	31.24	31.36	50700.0
2017-09-20	ARKG	ETF	25.5	25.81	25.442	25.692	27800.0
2017-09-20	ARKK	ETF	34.31	34.35	34.01	34.3	106700.0
2017-09-20	ARKQ	ETF	31.75	31.771	31.522	31.72	29100.0
2017-09-20	ARKW	ETF	41.16	41.2	40.735	41.07	63600.0
2017-09-20	ASEA	ETF	15.78	15.81	15.65	15.65	1400.0
2017-09-20	ASET	ETF	28.425	28.47	28.25	28.25	2909.0
2017-09-20	ASHR	ETF	29.7	29.73	29.54	29.55	469400.0
2017-09-20	ASHS	ETF	37.36	37.37	37.24	37.24	3200.0
2017-09-20	ASHX	ETF	21.8199	21.82	21.8199	21.82	535.0
2017-09-20	ATMP	ETF	21.47	21.57	21.38	21.41	12300.0
2017-09-20	BAB	ETF	30.45	30.47	30.37	30.38	82640.0
2017-09-20	BAL	ETF	45.72	45.72	45.7	45.7	2622.0
2017-09-20	BAR	ETF	13.124	13.15	12.969	13.011	64420.0
2017-09-20	BBC	ETF	28.85	28.99	28.71	28.92	6892.0
2017-09-20	BBH	ETF	133.83	134.22	133.16	134.1	15800.0

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

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