PREVIEW / etf_daily / 2017-08-10

all etf daily files

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

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-10	SPY	ETF	246.29	246.44	243.7	243.76	120479500.0
2017-08-10	QQQ	ETF	143.33	143.4	140.89	141.03	63331663.0
2017-08-10	IWM	ETF	138.28	138.28	136.26	136.27	40983500.0
2017-08-10	DIA	ETF	219.81	219.9	218.55	218.6	7832600.0
2017-08-10	GLD	ETF	122.08	122.44	122.03	122.21	9817900.0
2017-08-10	TLT	ETF	125.62	126.44	125.52	126.37	10378200.0
2017-08-10	AADR	ETF	49.79	49.79	48.87	48.98	13600.0
2017-08-10	AAXJ	ETF	70.27	70.34	69.12	69.16	1470300.0
2017-08-10	ACSI	ETF	29.03	29.03	28.8588	28.86	13152.0
2017-08-10	ACTX	ETF	85.5508	85.5508	76.7007	80.2407	464.0
2017-08-10	ACWF	ETF	27.85	27.85	27.52	27.52	1446.0
2017-08-10	ACWI	ETF	67.03	67.03	66.29	66.34	1778900.0
2017-08-10	ACWV	ETF	80.38	80.43	80.1	80.13	83400.0
2017-08-10	ACWX	ETF	46.95	46.95	46.415	46.435	859177.0
2017-08-10	ADRE	ETF	41.64	41.64	40.691	40.86	21681.0
2017-08-10	AFK	ETF	22.95	22.98	22.57	22.62	16704.0
2017-08-10	AFTY	ETF	16.12	16.12	15.93	15.951	4100.0
2017-08-10	AGG	ETF	109.7	109.85	109.67	109.78	2004200.0
2017-08-10	AGGY	ETF	50.73	50.75	50.66	50.75	25700.0
2017-08-10	AGNG	ETF	18.5	18.5	18.5	18.5	300.0
2017-08-10	AGQ	ETF	35.72	35.94	35.07	35.32	348900.0
2017-08-10	AGZ	ETF	113.9	114.03	113.9	113.98	9361.0
2017-08-10	AGZD	ETF	23.955	24.065	23.945	24.015	12200.0
2017-08-10	AIA	ETF	59.79	59.79	58.77	58.84	71948.0
2017-08-10	AIQ	ETF	13.0696	13.1	12.95	13.1	27929.0
2017-08-10	AIRR	ETF	23.53	23.588	23.19	23.19	39300.0
2017-08-10	AIVI	ETF	41.71	41.71	41.38	41.38	9800.0
2017-08-10	ALTY	ETF	15.49	15.62	15.47	15.47	6700.0
2017-08-10	AMJ	ETF	28.81	29.05	28.48	28.55	1889729.0
2017-08-10	AMLP	ETF	56.5	56.85	55.65	55.75	1325760.0
2017-08-10	AMZA	ETF	93.7	94.1	91.7	91.9	140440.0
2017-08-10	ANGL	ETF	29.71	29.72	29.52	29.54	345300.0
2017-08-10	AOA	ETF	52.34	52.36	51.91	51.92	33400.0
2017-08-10	AOK	ETF	34.17	34.17	34.0446	34.1	57963.0
2017-08-10	AOM	ETF	37.46	37.4849	37.289	37.34	82072.0
2017-08-10	AOR	ETF	43.93	43.97	43.66	43.66	147808.0
2017-08-10	ARCM	ETF	100.0	100.0	100.0	100.0	20.0
2017-08-10	ARGT	ETF	28.03	28.12	27.67	27.75	123500.0
2017-08-10	ARKG	ETF	22.425	22.425	21.93	21.98	7600.0
2017-08-10	ARKK	ETF	30.64	30.7	30.086	30.09	45300.0
2017-08-10	ARKQ	ETF	29.34	29.43	28.74	28.77	32900.0
2017-08-10	ARKW	ETF	37.8	37.8	36.97	37.02	54900.0
2017-08-10	ASEA	ETF	15.24	15.27	15.2	15.2	11300.0
2017-08-10	ASET	ETF	27.78	27.78	27.7152	27.719	2585.0
2017-08-10	ASHR	ETF	28.04	28.1	27.83	27.84	1097900.0
2017-08-10	ASHS	ETF	34.27	34.28	33.91	33.94	21800.0
2017-08-10	ASHX	ETF	20.9424	20.9424	20.9	20.9	444.0
2017-08-10	ATMP	ETF	21.75	21.82	21.45	21.47	46800.0
2017-08-10	BAB	ETF	30.41	30.41	30.2912	30.34	139042.0
2017-08-10	BAL	ETF	46.5311	46.5311	44.93	45.04	27313.0

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

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