PREVIEW / etf_daily / 2017-08-03

all etf daily files

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

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-03	SPY	ETF	247.31	247.34	246.64	246.96	40856000.0
2017-08-03	QQQ	ETF	144.17	144.17	143.13	143.39	27112799.0
2017-08-03	IWM	ETF	140.44	140.54	139.16	139.53	19624900.0
2017-08-03	DIA	ETF	219.93	220.23	219.72	220.06	2496400.0
2017-08-03	GLD	ETF	120.31	120.83	120.31	120.59	4275600.0
2017-08-03	TLT	ETF	125.29	126.02	125.26	126.0	10324500.0
2017-08-03	AADR	ETF	49.58	49.83	49.49	49.81	24300.0
2017-08-03	AAXJ	ETF	70.8	70.89	70.56	70.86	682100.0
2017-08-03	ACSI	ETF	29.34	29.34	29.17	29.17	31291.0
2017-08-03	ACTX	ETF	84.3708	97.3509	82.6007	91.4508	1589.0
2017-08-03	ACWF	ETF	28.0	28.02	28.0	28.0	1976.0
2017-08-03	ACWI	ETF	67.46	67.5	67.35	67.4	623100.0
2017-08-03	ACWV	ETF	80.75	80.91	80.66	80.87	67400.0
2017-08-03	ACWX	ETF	47.43	47.47	47.34	47.41	178226.0
2017-08-03	ADRE	ETF	41.48	41.5	41.2483	41.43	6144.0
2017-08-03	AFK	ETF	23.14	23.24	23.01	23.01	11591.0
2017-08-03	AFTY	ETF	16.2	16.2	16.17	16.17	900.0
2017-08-03	AGG	ETF	109.77	109.94	109.74	109.86	1485200.0
2017-08-03	AGGY	ETF	50.83	50.9	50.782	50.875	27200.0
2017-08-03	AGNG	ETF	18.691	18.691	18.691	18.691	1000.0
2017-08-03	AGQ	ETF	33.42	33.8	33.42	33.48	100900.0
2017-08-03	AGZ	ETF	113.94	113.96	113.87	113.94	9837.0
2017-08-03	AGZD	ETF	24.07	24.075	24.07	24.075	1000.0
2017-08-03	AIA	ETF	60.5	60.56	60.3191	60.4	62624.0
2017-08-03	AIQ	ETF	13.05	13.1	12.75	13.1	94675.0
2017-08-03	AIRR	ETF	23.709	23.81	23.58	23.66	31000.0
2017-08-03	AIVI	ETF	42.11	42.19	42.04	42.06	7100.0
2017-08-03	ALTY	ETF	15.7	15.705	15.63	15.645	11100.0
2017-08-03	AMJ	ETF	30.14	30.2	29.7	29.76	1204552.0
2017-08-03	AMLP	ETF	60.15	60.15	59.4	59.4	1489540.0
2017-08-03	AMZA	ETF	97.6	97.73	96.2	96.6	67430.0
2017-08-03	ANGL	ETF	29.86	29.9	29.84	29.85	508100.0
2017-08-03	AOA	ETF	52.67	52.68	52.57	52.66	38000.0
2017-08-03	AOK	ETF	34.26	34.27	34.17	34.26	26836.0
2017-08-03	AOM	ETF	37.59	37.64	37.525	37.56	49100.0
2017-08-03	AOR	ETF	44.23	44.23	44.16	44.23	46639.0
2017-08-03	ARCM	ETF	99.975	99.975	99.975	99.975	20.0
2017-08-03	ARGT	ETF	29.32	29.57	29.32	29.53	56300.0
2017-08-03	ARKG	ETF	22.126	22.551	22.126	22.417	17200.0
2017-08-03	ARKK	ETF	29.99	30.12	29.8	30.035	32000.0
2017-08-03	ARKQ	ETF	29.45	29.5	29.34	29.456	21800.0
2017-08-03	ARKW	ETF	37.21	37.312	37.042	37.18	24000.0
2017-08-03	ASEA	ETF	15.39	15.42	15.32	15.41	2300.0
2017-08-03	ASHR	ETF	28.14	28.23	28.09	28.13	549600.0
2017-08-03	ASHS	ETF	33.96	33.99	33.95	33.99	1400.0
2017-08-03	ASHX	ETF	21.19	21.19	21.19	21.19	151.0
2017-08-03	ATMP	ETF	22.89	22.89	22.51	22.51	72700.0
2017-08-03	BAB	ETF	30.28	30.405	30.28	30.39	55583.0
2017-08-03	BAL	ETF	46.43	46.52	46.38	46.41	8244.0
2017-08-03	BBC	ETF	23.6852	23.78	23.63	23.77	3157.0

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

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