PREVIEW / etf_daily / 2022-07-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-21.parquet
  size:    102 KB
  rows:    2,737

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
2022-07-21	SPY	ETF	394.16	398.84	391.63	398.79	64903900.0
2022-07-21	QQQ	ETF	303.5	307.435	300.78	307.38	55049363.0
2022-07-21	IWM	ETF	180.45	182.5	178.85	182.42	21709900.0
2022-07-21	DIA	ETF	317.63	320.46	315.38	320.41	2159800.0
2022-07-21	GLD	ETF	158.31	160.31	158.27	160.27	5863300.0
2022-07-21	TLT	ETF	115.19	116.72	115.01	116.59	14754900.0
2022-07-21	AAA	ETF	24.26	24.26	24.245	24.245	14501.0
2022-07-21	AAAU	ETF	16.86	17.08	16.86	17.08	2769000.0
2022-07-21	AADR	ETF	48.51	48.87	48.51	48.87	900.0
2022-07-21	AAXJ	ETF	67.97	68.52	67.89	68.48	755900.0
2022-07-21	ABEQ	ETF	26.73	26.743	26.65	26.743	5400.0
2022-07-21	ACES	ETF	52.63	53.33	52.0	53.22	31400.0
2022-07-21	ACIO	ETF	29.66	29.91	29.52	29.91	32400.0
2022-07-21	ACSI	ETF	44.7798	44.7798	44.7798	44.7798	15.0
2022-07-21	ACT	ETF	21.84	22.02	21.54	21.97	65039.0
2022-07-21	ACTV	ETF	31.89	32.05	31.76	31.9923	4664.0
2022-07-21	ACVF	ETF	29.79	30.07	29.79	30.07	2000.0
2022-07-21	ACWF	ETF	31.88	32.2857	31.88	32.2857	8936.0
2022-07-21	ACWI	ETF	86.24	87.3	85.95	87.27	3553400.0
2022-07-21	ACWV	ETF	95.2	95.73	94.92	95.71	175900.0
2022-07-21	ACWX	ETF	44.85	45.405	44.85	45.4	1480716.0
2022-07-21	ADFI	ETF	8.59	8.609	8.56	8.609	9000.0
2022-07-21	ADIV	ETF	13.71	13.801	13.71	13.801	500.0
2022-07-21	ADME	ETF	35.33	35.74	35.31	35.74	20200.0
2022-07-21	ADRE	ETF	38.7492	39.07	38.682	39.06	4228.0
2022-07-21	AEMB	ETF	37.46	37.46	37.46	37.46	100.0
2022-07-21	AESR	ETF	11.42	11.54	11.41	11.54	21100.0
2022-07-21	AFIF	ETF	8.87	8.9	8.87	8.89	16100.0
2022-07-21	AFK	ETF	16.94	17.04	16.89	17.04	7733.0
2022-07-21	AFLG	ETF	23.39	23.551	23.37	23.551	1400.0
2022-07-21	AFMC	ETF	22.2	22.2	22.2	22.2	100.0
2022-07-21	AFTY	ETF	17.68	17.71	17.66	17.69	16600.0
2022-07-21	AGG	ETF	101.96	102.58	101.96	102.56	5920000.0
2022-07-21	AGGY	ETF	45.04	45.31	45.04	45.29	91500.0
2022-07-21	AGNG	ETF	26.15	26.184	26.15	26.184	300.0
2022-07-21	AGOV	ETF	79.61	80.84	79.61	80.3	4540.0
2022-07-21	AGOX	ETF	20.916	21.14	20.9	21.11	21200.0
2022-07-21	AGQ	ETF	20.22	20.99	20.16	20.99	629000.0
2022-07-21	AGZ	ETF	109.79	110.1651	109.7722	110.13	100125.0
2022-07-21	AGZD	ETF	22.88	22.965	22.88	22.925	47400.0
2022-07-21	AHHX	ETF	8.54	8.67	8.52	8.67	8706.0
2022-07-21	AHYB	ETF	44.251	44.526	44.251	44.526	200.0
2022-07-21	AIA	ETF	61.69	62.0	61.42	61.98	11997.0
2022-07-21	AIEQ	ETF	32.994	32.994	32.9	32.992	4900.0
2022-07-21	AIQ	ETF	22.25	22.54	22.15	22.54	7415.0
2022-07-21	AIRR	ETF	39.58	39.96	39.21	39.95	4200.0
2022-07-21	AIVI	ETF	35.19	35.37	35.04	35.37	1800.0
2022-07-21	AIVL	ETF	91.14	92.68	91.14	92.68	7100.0
2022-07-21	ALTL	ETF	40.59	40.78	40.455	40.76	109350.0
2022-07-21	ALTY	ETF	11.75	11.8	11.69	11.8	21800.0

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

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