PREVIEW / etf_daily / 2019-07-29

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-29.parquet
  size:    69 KB
  rows:    1,810

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
2019-07-29	SPY	ETF	301.88	302.01	300.85	301.46	38126500.0
2019-07-29	QQQ	ETF	195.18	195.18	193.39	194.62	20451652.0
2019-07-29	IWM	ETF	157.19	157.36	155.6	156.15	13192200.0
2019-07-29	DIA	ETF	271.86	272.68	271.69	272.13	1346000.0
2019-07-29	GLD	ETF	134.06	134.73	133.44	134.53	9162400.0
2019-07-29	TLT	ETF	131.82	131.95	131.4	131.51	6231800.0
2019-07-29	AAAU	ETF	14.19	14.24	14.15	14.24	44200.0
2019-07-29	AADR	ETF	51.37	51.48	51.14	51.48	15800.0
2019-07-29	AAXJ	ETF	69.15	69.22	68.93	69.12	554400.0
2019-07-29	ACES	ETF	30.44	30.99	30.326	30.49	7700.0
2019-07-29	ACIO	ETF	25.325	25.39	25.299	25.299	37700.0
2019-07-29	ACSI	ETF	34.9175	34.9175	34.81	34.81	681.0
2019-07-29	ACTX	ETF	23.6002	23.6002	21.2461	21.2461	140.0
2019-07-29	ACWF	ETF	29.57	29.57	29.5	29.55	5081.0
2019-07-29	ACWI	ETF	74.92	74.94	74.67	74.81	1187600.0
2019-07-29	ACWV	ETF	93.19	93.38	93.19	93.32	200700.0
2019-07-29	ACWX	ETF	46.8	46.8027	46.68	46.75	1240769.0
2019-07-29	ADRE	ETF	40.3	40.37	40.08	40.35	3268.0
2019-07-29	AFIF	ETF	9.88	9.885	9.88	9.885	2833.0
2019-07-29	AFK	ETF	21.62	21.68	21.5216	21.53	2470.0
2019-07-29	AFTY	ETF	17.67	17.73	17.67	17.72	100400.0
2019-07-29	AGG	ETF	111.3	111.35	111.22	111.26	4167100.0
2019-07-29	AGGY	ETF	51.31	51.33	51.239	51.29	299000.0
2019-07-29	AGNG	ETF	21.19	21.367	21.19	21.312	1900.0
2019-07-29	AGQ	ETF	28.2	28.42	27.99	28.36	279000.0
2019-07-29	AGZ	ETF	114.9466	114.9699	114.87	114.87	19244.0
2019-07-29	AGZD	ETF	23.99	23.99	23.92	23.92	5200.0
2019-07-29	AIA	ETF	61.05	61.08	60.85	60.95	10466.0
2019-07-29	AIEQ	ETF	26.99	27.001	26.82	26.9	16100.0
2019-07-29	AIQ	ETF	17.21	17.21	16.89	17.02	11149.0
2019-07-29	AIRR	ETF	26.291	26.36	26.16	26.25	18500.0
2019-07-29	AIVI	ETF	41.08	41.08	41.04	41.06	2300.0
2019-07-29	ALTY	ETF	15.07	15.1	15.051	15.1	5700.0
2019-07-29	AMJ	ETF	25.34	25.385	24.95	24.98	1012235.0
2019-07-29	AMLP	ETF	50.0	50.0	49.05	49.25	3903620.0
2019-07-29	AMOM	ETF	26.62	26.646	26.62	26.646	200.0
2019-07-29	AMUB	ETF	15.7537	15.7537	15.7537	15.7537	0.0
2019-07-29	AMZA	ETF	55.1	55.4	54.0	54.0	70910.0
2019-07-29	ANGL	ETF	29.49	29.5	29.42	29.48	361600.0
2019-07-29	AOA	ETF	55.26	55.3	55.15	55.18	37500.0
2019-07-29	AOK	ETF	35.41	35.4724	35.37	35.43	88635.0
2019-07-29	AOM	ETF	39.01	39.0312	38.95	38.97	79444.0
2019-07-29	AOR	ETF	45.99	46.0373	45.935	45.94	92251.0
2019-07-29	ARGT	ETF	33.07	33.31	32.79	33.23	193800.0
2019-07-29	ARKF	ETF	23.36	23.38	23.03	23.17	12900.0
2019-07-29	ARKG	ETF	34.81	34.86	34.07	34.68	85500.0
2019-07-29	ARKK	ETF	49.25	49.35	48.244	49.13	215800.0
2019-07-29	ARKQ	ETF	34.14	34.14	33.61	34.11	12900.0
2019-07-29	ARKW	ETF	53.96	54.12	52.96	53.7	51400.0
2019-07-29	ASEA	ETF	16.42	16.69	16.35	16.38	6200.0

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

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