PREVIEW / etf_daily / 2021-08-25

all etf daily files

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

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-25	SPY	ETF	448.17	449.46	447.77	448.91	40529700.0
2021-08-25	QQQ	ETF	374.63	375.39	373.855	374.8	20441880.0
2021-08-25	IWM	ETF	221.77	223.97	220.85	222.56	21548000.0
2021-08-25	DIA	ETF	353.78	355.04	352.92	354.18	2434700.0
2021-08-25	GLD	ETF	167.88	167.92	166.74	167.48	5588800.0
2021-08-25	TLT	ETF	149.21	149.37	147.58	148.04	16743800.0
2021-08-25	AAA	ETF	25.0001	25.015	25.0001	25.015	511.0
2021-08-25	AAAU	ETF	17.86	17.86	17.74	17.81	534200.0
2021-08-25	AADR	ETF	68.0	68.34	67.89	68.2	2400.0
2021-08-25	AAXJ	ETF	87.1	87.27	86.85	87.15	894300.0
2021-08-25	ABEQ	ETF	27.831	27.9	27.831	27.891	7100.0
2021-08-25	ACES	ETF	69.98	70.55	69.72	70.16	42700.0
2021-08-25	ACIO	ETF	30.928	31.0	30.912	30.98	62200.0
2021-08-25	ACSI	ETF	51.5025	51.5025	51.5025	51.5025	82.0
2021-08-25	ACTV	ETF	38.1	38.47	38.1	38.2827	5367.0
2021-08-25	ACVF	ETF	33.52	33.52	33.26	33.393	40900.0
2021-08-25	ACWF	ETF	38.71	38.78	38.701	38.7215	4456.0
2021-08-25	ACWI	ETF	103.47	103.75	103.39	103.65	10848000.0
2021-08-25	ACWV	ETF	106.28	106.4	106.01	106.29	159700.0
2021-08-25	ACWX	ETF	56.85	57.025	56.795	56.98	404683.0
2021-08-25	ADFI	ETF	9.75	9.76	9.745	9.745	1600.0
2021-08-25	ADIV	ETF	18.113	18.113	18.113	18.113	1400.0
2021-08-25	ADME	ETF	41.03	41.155	40.97	41.065	115600.0
2021-08-25	ADRE	ETF	51.25	51.7383	51.25	51.67	7585.0
2021-08-25	AESR	ETF	14.18	14.26	14.18	14.233	6500.0
2021-08-25	AFIF	ETF	9.67	9.68	9.67	9.67	12594.0
2021-08-25	AFK	ETF	21.64	21.64	21.5201	21.61	2986.0
2021-08-25	AFLG	ETF	26.64	26.64	26.618	26.618	100.0
2021-08-25	AFMC	ETF	26.04	26.04	25.989	25.989	500.0
2021-08-25	AFSM	ETF	26.366	26.366	26.366	26.366	100.0
2021-08-25	AFTY	ETF	20.35	20.372	20.34	20.372	1900.0
2021-08-25	AGG	ETF	115.99	116.01	115.68	115.77	5452000.0
2021-08-25	AGGY	ETF	52.55	52.57	52.41	52.43	82100.0
2021-08-25	AGNG	ETF	30.85	30.85	30.645	30.78	3700.0
2021-08-25	AGOV	ETF	100.0	100.25	100.0	100.145	859.0
2021-08-25	AGOX	ETF	26.36	26.629	26.36	26.58	40900.0
2021-08-25	AGQ	ETF	37.62	37.82	36.81	37.73	462000.0
2021-08-25	AGZ	ETF	119.05	119.06	118.85	118.86	17161.0
2021-08-25	AGZD	ETF	23.445	23.445	23.405	23.42	34800.0
2021-08-25	AIA	ETF	82.04	82.2299	81.7456	82.16	65604.0
2021-08-25	AIEQ	ETF	42.24	42.45	42.209	42.45	9000.0
2021-08-25	AIQ	ETF	31.2	31.27	31.155	31.24	12105.0
2021-08-25	AIRR	ETF	42.01	42.328	42.0	42.17	9300.0
2021-08-25	AIVI	ETF	43.14	43.2	43.14	43.2	1500.0
2021-08-25	ALTL	ETF	43.15	43.2921	43.088	43.22	65499.0
2021-08-25	ALTY	ETF	13.7	13.74	13.64	13.7	7100.0
2021-08-25	AMJ	ETF	17.87	18.23	17.78	17.98	437454.0
2021-08-25	AMLP	ETF	32.23	33.02	32.11	32.61	2530200.0
2021-08-25	AMNA	ETF	31.9606	31.9606	31.9606	31.9606	0.0
2021-08-25	AMND	ETF	33.4949	33.4949	33.4949	33.4949	14.0

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

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