PREVIEW / etf_daily / 2020-09-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-29.parquet
  size:    79 KB
  rows:    2,091

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
2020-09-29	SPY	ETF	333.97	334.77	331.62	332.37	51304000.0
2020-09-29	QQQ	ETF	276.72	277.71	275.3719	275.95	27178921.0
2020-09-29	IWM	ETF	149.85	150.28	148.0	149.34	18683800.0
2020-09-29	DIA	ETF	275.6	275.98	273.29	274.42	1971100.0
2020-09-29	GLD	ETF	177.19	178.33	176.95	178.19	8718500.0
2020-09-29	TLT	ETF	164.8	165.24	164.56	164.84	10297600.0
2020-09-29	AAA	ETF	24.94	24.95	24.93	24.945	8023.0
2020-09-29	AAAU	ETF	18.81	18.91	18.78	18.9	712600.0
2020-09-29	AADR	ETF	55.08	55.46	55.06	55.25	4000.0
2020-09-29	AAXJ	ETF	75.83	76.22	75.75	75.96	396400.0
2020-09-29	ABEQ	ETF	23.42	23.42	23.209	23.34	26100.0
2020-09-29	ACES	ETF	53.65	54.55	53.52	54.4	34300.0
2020-09-29	ACIO	ETF	26.53	26.59	26.49	26.53	12800.0
2020-09-29	ACSI	ETF	37.1567	37.1567	37.1567	37.1567	119.0
2020-09-29	ACTX	ETF	1.829	2.186	1.77	1.773	1297.0
2020-09-29	ACWF	ETF	29.59	29.64	29.5645	29.5809	7198.0
2020-09-29	ACWI	ETF	79.73	79.94	79.35	79.56	2188400.0
2020-09-29	ACWV	ETF	91.68	92.04	91.42	91.63	534800.0
2020-09-29	ACWX	ETF	45.96	46.11	45.81	45.93	520829.0
2020-09-29	ADME	ETF	33.47	33.57	33.42	33.465	11900.0
2020-09-29	ADRE	ETF	45.67	45.93	45.67	45.855	2349.0
2020-09-29	AESR	ETF	10.87	10.87	10.827	10.827	21200.0
2020-09-29	AFIF	ETF	9.82	9.84	9.81	9.815	58017.0
2020-09-29	AFK	ETF	17.46	17.4903	17.3408	17.35	2531.0
2020-09-29	AFLG	ETF	20.11	20.11	20.051	20.051	2700.0
2020-09-29	AFTY	ETF	19.22	19.31	19.21	19.297	5300.0
2020-09-29	AGG	ETF	118.28	118.33	118.21	118.25	5301700.0
2020-09-29	AGGY	ETF	53.81	53.89	53.81	53.87	58400.0
2020-09-29	AGNG	ETF	25.42	25.54	25.42	25.54	5800.0
2020-09-29	AGQ	ETF	44.26	46.19	44.05	45.45	2386000.0
2020-09-29	AGZ	ETF	121.17	122.0	121.17	121.31	34233.0
2020-09-29	AGZD	ETF	23.415	23.435	23.38	23.425	15000.0
2020-09-29	AIA	ETF	70.75	71.07	70.61	70.8538	105746.0
2020-09-29	AIEQ	ETF	30.61	30.72	30.451	30.587	8200.0
2020-09-29	AIQ	ETF	23.3	23.39	23.2448	23.3253	20625.0
2020-09-29	AIRR	ETF	25.55	25.823	25.55	25.72	60200.0
2020-09-29	AIVI	ETF	36.04	36.15	35.94	36.03	3100.0
2020-09-29	ALTL	ETF	24.91	24.93	24.8489	24.8552	3782.0
2020-09-29	ALTY	ETF	10.75	10.75	10.45	10.54	37300.0
2020-09-29	AMJ	ETF	10.95	11.09	10.72	11.01	677956.0
2020-09-29	AMLP	ETF	20.04	20.51	19.79	20.39	2083200.0
2020-09-29	AMNA	ETF	22.1649	22.1649	22.1649	22.1649	0.0
2020-09-29	AMND	ETF	23.235	23.235	23.235	23.235	0.0
2020-09-29	AMOM	ETF	35.45	35.45	35.27	35.34	600.0
2020-09-29	AMUB	ETF	6.845	6.96	6.845	6.9396	3253.0
2020-09-29	AMZA	ETF	13.46	13.894	13.26	13.84	55300.0
2020-09-29	ANGL	ETF	29.57	29.59	29.48	29.58	777100.0
2020-09-29	AOA	ETF	57.94	58.02	57.63	57.75	40700.0
2020-09-29	AOK	ETF	37.22	37.225	37.1404	37.18	247077.0
2020-09-29	AOM	ETF	41.07	41.33	40.96	41.0	87440.0

> showing 50 of 2,091 rows — these rows as CSV

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