PREVIEW / etf_daily / 2021-08-31

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-31.parquet
  size:    92 KB
  rows:    2,436

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
2021-08-31	SPY	ETF	452.13	452.49	450.92	451.56	59300200.0
2021-08-31	QQQ	ETF	380.51	380.579	378.36	379.95	29628175.0
2021-08-31	IWM	ETF	225.24	226.61	224.33	225.92	20839800.0
2021-08-31	DIA	ETF	353.8	354.8	353.18	353.92	2913800.0
2021-08-31	GLD	ETF	169.23	169.92	168.75	169.69	6336000.0
2021-08-31	TLT	ETF	149.67	150.09	148.5	148.83	15262400.0
2021-08-31	AAA	ETF	25.0	25.005	25.0	25.005	752.0
2021-08-31	AAAU	ETF	18.0	18.07	17.95	18.06	211900.0
2021-08-31	AADR	ETF	68.3	68.3	67.81	68.14	2100.0
2021-08-31	AAXJ	ETF	88.72	88.85	88.5	88.76	1146400.0
2021-08-31	ABEQ	ETF	27.81	27.86	27.79	27.838	800.0
2021-08-31	ACES	ETF	70.47	71.05	70.22	70.52	87200.0
2021-08-31	ACIO	ETF	31.15	31.21	31.125	31.16	40900.0
2021-08-31	ACSI	ETF	51.01	51.5113	51.01	51.5113	357.0
2021-08-31	ACTV	ETF	38.53	38.59	38.51	38.5576	2642.0
2021-08-31	ACTX	ETF	1.25	1.3	1.25	1.25	1164.0
2021-08-31	ACVF	ETF	33.75	33.75	33.39	33.48	40100.0
2021-08-31	ACWF	ETF	39.06	39.08	38.9617	38.9617	64948.0
2021-08-31	ACWI	ETF	104.5	104.5	104.22	104.33	5907800.0
2021-08-31	ACWV	ETF	106.73	107.03	106.64	106.75	79200.0
2021-08-31	ACWX	ETF	57.49	57.52	57.325	57.38	738565.0
2021-08-31	ADFI	ETF	9.765	9.765	9.765	9.765	2600.0
2021-08-31	ADIV	ETF	18.072	18.072	18.072	18.072	1400.0
2021-08-31	ADME	ETF	41.32	41.37	41.29	41.34	33800.0
2021-08-31	ADRE	ETF	52.35	52.35	52.06	52.3167	3638.0
2021-08-31	AEMB	ETF	50.09	50.285	50.09	50.285	600.0
2021-08-31	AESR	ETF	14.3	14.33	14.28	14.31	2600.0
2021-08-31	AFIF	ETF	9.68	9.68	9.68	9.68	7275.0
2021-08-31	AFK	ETF	21.8	21.97	21.77	21.93	6512.0
2021-08-31	AFLG	ETF	26.73	26.73	26.716	26.716	1300.0
2021-08-31	AFSM	ETF	26.699	26.699	26.699	26.699	600.0
2021-08-31	AFTY	ETF	19.73	19.796	19.73	19.796	500.0
2021-08-31	AGG	ETF	116.18	116.29	116.02	116.06	6763900.0
2021-08-31	AGGY	ETF	52.64	52.736	52.591	52.609	127400.0
2021-08-31	AGNG	ETF	30.98	31.18	30.97	30.979	4700.0
2021-08-31	AGOV	ETF	101.04	101.17	101.04	101.045	2126.0
2021-08-31	AGOX	ETF	26.93	26.93	26.61	26.72	10700.0
2021-08-31	AGQ	ETF	38.33	38.56	37.42	37.8	602300.0
2021-08-31	AGZ	ETF	119.26	119.3019	119.16	119.23	61246.0
2021-08-31	AGZD	ETF	23.44	23.45	23.405	23.405	71200.0
2021-08-31	AIA	ETF	83.12	83.41	82.8901	83.1	50021.0
2021-08-31	AIEQ	ETF	42.85	43.0	42.72	43.0	13800.0
2021-08-31	AIQ	ETF	31.82	31.85	31.691	31.85	9208.0
2021-08-31	AIRR	ETF	42.72	42.72	42.43	42.62	63000.0
2021-08-31	AIVI	ETF	43.24	43.25	43.18	43.22	6200.0
2021-08-31	ALTL	ETF	43.5	43.6404	43.29	43.44	17449.0
2021-08-31	ALTY	ETF	13.76	13.76	13.68	13.72	32000.0
2021-08-31	AMJ	ETF	17.69	17.82	17.57	17.57	426695.0
2021-08-31	AMLP	ETF	32.36	32.78	32.31	32.36	1312700.0
2021-08-31	AMNA	ETF	31.8017	31.8017	31.8017	31.8017	0.0

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

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