PREVIEW / etf_daily / 2017-09-06

all etf daily files

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

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-06	SPY	ETF	246.84	247.28	246.23	246.9	57916900.0
2017-09-06	QQQ	ETF	145.06	145.46	144.08	145.13	30722723.0
2017-09-06	IWM	ETF	139.74	140.0	139.08	139.46	18399700.0
2017-09-06	DIA	ETF	218.54	218.62	218.04	218.25	1915500.0
2017-09-06	GLD	ETF	127.34	127.44	126.55	126.81	10059300.0
2017-09-06	TLT	ETF	128.72	129.0	127.74	127.97	9066400.0
2017-09-06	AADR	ETF	52.63	53.25	52.63	53.13	26300.0
2017-09-06	AAXJ	ETF	71.68	71.82	71.55	71.76	280100.0
2017-09-06	ACSI	ETF	28.75	28.7777	28.73	28.7777	15568.0
2017-09-06	ACTX	ETF	70.8006	72.5707	64.9006	68.4406	1028.0
2017-09-06	ACWI	ETF	67.4	67.61	67.39	67.5	1557200.0
2017-09-06	ACWV	ETF	81.15	81.18	80.96	81.04	89900.0
2017-09-06	ACWX	ETF	47.41	47.565	47.35	47.505	536205.0
2017-09-06	ADRE	ETF	42.28	42.6999	42.28	42.61	6873.0
2017-09-06	AFK	ETF	23.79	24.17	23.7363	23.997	11066.0
2017-09-06	AFTY	ETF	17.38	17.38	17.3	17.34	8400.0
2017-09-06	AGG	ETF	110.42	110.52	110.23	110.3	2720200.0
2017-09-06	AGGY	ETF	51.13	51.14	50.99	50.99	15700.0
2017-09-06	AGNG	ETF	19.36	19.36	19.36	19.36	300.0
2017-09-06	AGQ	ETF	38.75	38.88	38.14	38.3	144300.0
2017-09-06	AGZ	ETF	114.376	114.4461	114.315	114.32	8163.0
2017-09-06	AGZD	ETF	24.035	24.035	23.955	23.97	2200.0
2017-09-06	AIA	ETF	60.39	60.66	60.38	60.55	14825.0
2017-09-06	AIRR	ETF	23.75	23.75	23.55	23.65	16900.0
2017-09-06	AIVI	ETF	42.41	42.49	42.37	42.46	11400.0
2017-09-06	ALTY	ETF	15.7	15.7	15.52	15.57	3400.0
2017-09-06	AMJ	ETF	28.13	28.235	28.01	28.12	2043515.0
2017-09-06	AMLP	ETF	55.95	56.25	55.8	56.1	1803720.0
2017-09-06	AMZA	ETF	92.5	92.6	91.9	92.3	31430.0
2017-09-06	ANGL	ETF	29.98	30.0	29.95	29.98	287500.0
2017-09-06	AOA	ETF	52.68	52.72	52.59	52.68	34300.0
2017-09-06	AOK	ETF	34.42	34.42	34.32	34.35	65533.0
2017-09-06	AOM	ETF	37.76	37.79	37.6701	37.7	535826.0
2017-09-06	AOR	ETF	44.27	44.3221	44.2566	44.29	45904.0
2017-09-06	ARCM	ETF	100.5	100.5	100.5	100.5	20.0
2017-09-06	ARGT	ETF	30.45	30.53	30.34	30.52	74300.0
2017-09-06	ARKG	ETF	25.4	25.4	24.87	25.06	24400.0
2017-09-06	ARKK	ETF	33.63	33.73	33.29	33.64	85200.0
2017-09-06	ARKQ	ETF	30.33	30.33	29.805	30.08	21700.0
2017-09-06	ARKW	ETF	40.2	40.43	39.97	40.325	64300.0
2017-09-06	ASEA	ETF	15.42	15.56	15.42	15.54	4200.0
2017-09-06	ASET	ETF	28.2466	28.25	28.2466	28.25	908.0
2017-09-06	ASHR	ETF	29.99	30.0	29.93	30.0	1420300.0
2017-09-06	ASHS	ETF	36.94	37.01	36.94	36.94	3900.0
2017-09-06	ATMP	ETF	21.5	21.5	21.36	21.43	24900.0
2017-09-06	BAB	ETF	30.8	30.885	30.67	30.75	165749.0
2017-09-06	BAL	ETF	49.83	50.16	49.37	49.4	11150.0
2017-09-06	BAR	ETF	13.421	13.421	13.365	13.365	17040.0
2017-09-06	BBC	ETF	28.05	28.05	27.4942	27.6475	10433.0
2017-09-06	BBH	ETF	135.3	135.69	134.38	135.29	14100.0

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

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