PREVIEW / etf_daily / 2017-12-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-29.parquet
  size:    60 KB
  rows:    1,546

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-12-29	SPY	ETF	268.53	268.55	266.64	266.86	96007400.0
2017-12-29	QQQ	ETF	156.9	156.9	155.7	155.76	33185962.0
2017-12-29	IWM	ETF	154.15	154.15	152.39	152.46	21006500.0
2017-12-29	DIA	ETF	248.57	248.61	247.17	247.38	2951800.0
2017-12-29	GLD	ETF	123.7	124.09	123.46	123.65	7852100.0
2017-12-29	TLT	ETF	126.5	127.12	126.48	126.86	7580500.0
2017-12-29	AADR	ETF	59.08	59.08	58.61	58.85	54300.0
2017-12-29	AAXJ	ETF	76.53	76.61	76.23	76.28	637900.0
2017-12-29	ACSI	ETF	30.9699	30.9699	30.8546	30.8546	544.0
2017-12-29	ACTX	ETF	115.051	126.8511	100.3009	120.9511	4986.0
2017-12-29	ACWF	ETF	30.83	30.83	30.66	30.665	8190.0
2017-12-29	ACWI	ETF	72.39	72.44	72.05	72.09	1104400.0
2017-12-29	ACWV	ETF	84.56	84.61	84.3	84.32	77800.0
2017-12-29	ACWX	ETF	50.15	50.158	49.95	49.95	554569.0
2017-12-29	ADRE	ETF	43.0	43.17	42.7	43.13	36385.0
2017-12-29	AFK	ETF	24.73	24.99	24.725	24.86	28058.0
2017-12-29	AFTY	ETF	17.606	17.606	17.606	17.606	900.0
2017-12-29	AGG	ETF	109.28	109.39	109.24	109.33	2813400.0
2017-12-29	AGGY	ETF	50.68	50.75	50.673	50.72	150400.0
2017-12-29	AGNG	ETF	19.57	19.58	19.36	19.45	7000.0
2017-12-29	AGQ	ETF	34.13	34.52	33.68	33.85	259200.0
2017-12-29	AGZ	ETF	113.07	113.15	113.03	113.092	16141.0
2017-12-29	AGZD	ETF	24.185	24.205	24.15	24.205	2600.0
2017-12-29	AIA	ETF	66.24	66.349	66.025	66.04	25677.0
2017-12-29	AIEQ	ETF	26.17	26.17	25.88	25.89	66700.0
2017-12-29	AIRR	ETF	27.66	27.72	27.41	27.41	36500.0
2017-12-29	AIVI	ETF	43.54	43.54	43.39	43.4	14400.0
2017-12-29	ALTY	ETF	15.28	15.3	15.28	15.3	7800.0
2017-12-29	AMJ	ETF	27.56	27.56	27.39	27.47	4908753.0
2017-12-29	AMLP	ETF	54.3	54.3	53.9	53.95	4737500.0
2017-12-29	AMZA	ETF	86.6	86.82	85.6	86.1	245320.0
2017-12-29	ANGL	ETF	29.9	29.97	29.86	29.95	422900.0
2017-12-29	AOA	ETF	54.08	54.08	53.84	53.88	89100.0
2017-12-29	AOK	ETF	34.66	34.69	34.62	34.65	241991.0
2017-12-29	AOM	ETF	38.13	38.14	38.0	38.04	153178.0
2017-12-29	AOR	ETF	45.0	45.0	44.88	44.92	185987.0
2017-12-29	ARGT	ETF	35.41	35.48	35.13	35.31	136400.0
2017-12-29	ARKG	ETF	25.04	25.135	24.47	24.49	70700.0
2017-12-29	ARKK	ETF	37.55	37.64	37.07	37.08	217200.0
2017-12-29	ARKQ	ETF	33.47	33.47	32.89	32.94	108100.0
2017-12-29	ARKW	ETF	46.46	46.46	46.07	46.07	117200.0
2017-12-29	ASEA	ETF	16.83	17.09	16.83	17.0	4600.0
2017-12-29	ASET	ETF	28.76	28.76	28.7493	28.75	962.0
2017-12-29	ASHR	ETF	31.0	31.06	30.95	31.03	646500.0
2017-12-29	ASHS	ETF	34.87	34.88	34.81	34.84	4700.0
2017-12-29	ASHX	ETF	22.08	22.08	22.08	22.08	200.0
2017-12-29	ATMP	ETF	20.72	20.79	20.71	20.75	236100.0
2017-12-29	BAB	ETF	30.64	30.72	30.62	30.69	134360.0
2017-12-29	BAL	ETF	52.06	52.24	52.06	52.2	919.0
2017-12-29	BAR	ETF	13.031	13.031	13.031	13.031	3700.0

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

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