PREVIEW / etf_daily / 2021-07-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-28.parquet
  size:    92 KB
  rows:    2,422

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-07-28	SPY	ETF	439.68	440.3	437.31	438.83	52472400.0
2021-07-28	QQQ	ETF	365.6	367.45	363.24	365.83	42066195.0
2021-07-28	IWM	ETF	219.0	222.59	217.4	220.82	33043700.0
2021-07-28	DIA	ETF	351.02	351.23	348.71	349.36	3697700.0
2021-07-28	GLD	ETF	168.26	169.38	167.72	169.29	7905800.0
2021-07-28	TLT	ETF	148.67	149.67	148.27	149.65	14346700.0
2021-07-28	AAA	ETF	25.0177	25.02	25.0177	25.02	940.0
2021-07-28	AAAU	ETF	17.89	18.0	17.86	18.0	235400.0
2021-07-28	AADR	ETF	66.17	67.33	66.15	67.33	2400.0
2021-07-28	AAXJ	ETF	86.57	88.13	86.49	87.94	2643100.0
2021-07-28	ABEQ	ETF	27.43	27.51	27.38	27.449	6500.0
2021-07-28	ACES	ETF	69.09	71.505	69.011	71.25	28100.0
2021-07-28	ACIO	ETF	31.05	31.05	30.83	30.86	35200.0
2021-07-28	ACSI	ETF	50.8899	51.0157	50.88	51.0157	624.0
2021-07-28	ACTV	ETF	37.96	38.34	37.65	38.0783	3958.0
2021-07-28	ACTX	ETF	1.93	2.0	1.8	2.0	1480.0
2021-07-28	ACVF	ETF	32.54	32.54	32.432	32.432	14700.0
2021-07-28	ACWF	ETF	37.88	38.08	37.8601	38.0241	9561.0
2021-07-28	ACWI	ETF	101.92	102.4	101.62	102.13	3241300.0
2021-07-28	ACWV	ETF	104.7	104.87	104.29	104.75	183900.0
2021-07-28	ACWX	ETF	56.19	56.7	56.08	56.61	870353.0
2021-07-28	ADFI	ETF	9.77	9.774	9.77	9.774	200.0
2021-07-28	ADME	ETF	40.785	40.83	40.631	40.75	23400.0
2021-07-28	ADRE	ETF	51.82	53.16	51.82	53.0	13350.0
2021-07-28	AESR	ETF	13.9	13.945	13.86	13.907	11300.0
2021-07-28	AFIF	ETF	9.685	9.71	9.67	9.6952	12929.0
2021-07-28	AFK	ETF	21.2	21.4417	21.2	21.39	10013.0
2021-07-28	AFLG	ETF	25.95	25.98	25.91	25.931	900.0
2021-07-28	AFMC	ETF	25.253	25.253	25.253	25.253	100.0
2021-07-28	AFSM	ETF	25.766	25.766	25.766	25.766	100.0
2021-07-28	AFTY	ETF	20.59	20.85	20.53	20.85	5800.0
2021-07-28	AGG	ETF	116.24	116.49	116.14	116.49	5463600.0
2021-07-28	AGGY	ETF	52.75	52.84	52.7	52.82	70600.0
2021-07-28	AGNG	ETF	30.437	30.67	30.437	30.62	3000.0
2021-07-28	AGOV	ETF	100.0752	100.0752	100.0752	100.0752	90.0
2021-07-28	AGOX	ETF	26.1	26.21	26.0	26.136	27000.0
2021-07-28	AGQ	ETF	40.83	41.89	40.55	41.82	707700.0
2021-07-28	AGZ	ETF	119.14	119.27	119.0864	119.27	61815.0
2021-07-28	AGZD	ETF	23.47	23.47	23.42	23.45	24000.0
2021-07-28	AIA	ETF	82.75	84.6	82.75	84.45	213243.0
2021-07-28	AIEQ	ETF	40.83	41.338	40.77	41.225	13900.0
2021-07-28	AIQ	ETF	30.5	30.7699	30.39	30.72	36951.0
2021-07-28	AIRR	ETF	40.77	41.35	40.28	41.08	47700.0
2021-07-28	AIVI	ETF	43.56	43.85	43.56	43.81	4500.0
2021-07-28	ALTL	ETF	42.76	42.83	42.518	42.6611	82370.0
2021-07-28	ALTY	ETF	13.64	13.67	13.58	13.66	24900.0
2021-07-28	AMJ	ETF	18.4	18.64	18.14	18.47	400188.0
2021-07-28	AMLP	ETF	34.0	34.48	33.51	34.2	1915800.0
2021-07-28	AMNA	ETF	32.5593	32.5593	32.5593	32.5593	0.0
2021-07-28	AMND	ETF	34.2462	34.2462	34.2462	34.2462	10.0

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

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