PREVIEW / etf_daily / 2019-08-06

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-06.parquet
  size:    71 KB
  rows:    1,847

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-08-06	SPY	ETF	285.91	288.04	284.28	287.8	120711700.0
2019-08-06	QQQ	ETF	182.38	183.8	181.07	183.26	41897249.0
2019-08-06	IWM	ETF	148.9	149.7	147.38	149.36	24283300.0
2019-08-06	DIA	ETF	258.55	260.36	257.05	260.29	4991000.0
2019-08-06	GLD	ETF	138.33	139.03	138.01	138.91	9471200.0
2019-08-06	TLT	ETF	138.2	139.98	138.09	139.98	12747400.0
2019-08-06	AAAU	ETF	14.64	14.71	14.62	14.7	47000.0
2019-08-06	AADR	ETF	49.39	49.45	49.06	49.42	13100.0
2019-08-06	AAXJ	ETF	64.21	64.3	63.57	63.92	2452800.0
2019-08-06	ACES	ETF	30.29	30.53	30.2	30.475	43000.0
2019-08-06	ACIO	ETF	24.38	24.43	24.199	24.34	43100.0
2019-08-06	ACSI	ETF	33.1707	33.42	33.07	33.42	2187.0
2019-08-06	ACTX	ETF	20.3552	20.3552	17.7002	17.7061	111.0
2019-08-06	ACWF	ETF	27.82	27.999	27.7501	27.9788	7652.0
2019-08-06	ACWI	ETF	70.96	71.23	70.5	71.17	13946200.0
2019-08-06	ACWV	ETF	90.82	91.4	90.59	91.33	296600.0
2019-08-06	ACWX	ETF	44.38	44.44	44.0	44.32	5617624.0
2019-08-06	ADRE	ETF	37.25	37.2979	37.169	37.23	2625.0
2019-08-06	AFIF	ETF	9.7554	9.77	9.7554	9.7602	1011.0
2019-08-06	AFK	ETF	20.31	20.593	20.28	20.3723	8033.0
2019-08-06	AFTY	ETF	16.21	16.31	16.14	16.223	7500.0
2019-08-06	AGG	ETF	112.47	112.76	112.4	112.74	5151800.0
2019-08-06	AGGY	ETF	52.0	52.14	51.92	52.14	168400.0
2019-08-06	AGNG	ETF	20.94	21.0	20.821	20.976	11800.0
2019-08-06	AGQ	ETF	28.31	28.39	28.04	28.24	231600.0
2019-08-06	AGZ	ETF	116.04	116.21	116.0199	116.21	26129.0
2019-08-06	AGZD	ETF	23.855	23.885	23.81	23.84	5400.0
2019-08-06	AIA	ETF	56.46	56.6507	55.96	56.18	37804.0
2019-08-06	AIEQ	ETF	25.39	25.575	25.26	25.51	60500.0
2019-08-06	AIQ	ETF	15.63	15.75	15.52	15.7	57630.0
2019-08-06	AIRR	ETF	25.06	25.39	24.92	25.05	6500.0
2019-08-06	AIVI	ETF	39.3	39.37	39.05	39.27	49000.0
2019-08-06	ALTY	ETF	14.71	14.77	14.61	14.685	6600.0
2019-08-06	AMJ	ETF	24.0	24.17	23.59	23.79	1509828.0
2019-08-06	AMLP	ETF	47.2	47.5	46.35	46.6	3900800.0
2019-08-06	AMOM	ETF	25.731	25.731	25.731	25.731	800.0
2019-08-06	AMUB	ETF	14.9769	14.9769	14.9769	14.9769	0.0
2019-08-06	AMZA	ETF	50.9	51.0	49.5	50.05	117680.0
2019-08-06	ANGL	ETF	28.85	29.03	28.7	28.89	1754800.0
2019-08-06	AOA	ETF	53.15	54.26	52.9	53.21	96100.0
2019-08-06	AOK	ETF	35.11	35.21	35.02	35.21	73178.0
2019-08-06	AOM	ETF	38.4	38.581	38.36	38.51	262063.0
2019-08-06	AOR	ETF	44.76	44.96	44.6542	44.96	96633.0
2019-08-06	ARGT	ETF	30.97	31.15	30.7	31.05	14100.0
2019-08-06	ARKF	ETF	21.47	21.47	21.2	21.398	15800.0
2019-08-06	ARKG	ETF	32.06	32.23	31.48	32.15	211700.0
2019-08-06	ARKK	ETF	44.62	44.98	43.77	44.56	471300.0
2019-08-06	ARKQ	ETF	30.46	30.73	30.19	30.47	27500.0
2019-08-06	ARKW	ETF	49.18	49.61	48.4	48.92	75400.0
2019-08-06	ASEA	ETF	15.84	16.11	15.64	15.83	64000.0

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

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