PREVIEW / etf_daily / 2022-08-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-29.parquet
  size:    104 KB
  rows:    2,787

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-08-29	SPY	ETF	402.2	405.84	401.2	402.63	65370800.0
2022-08-29	QQQ	ETF	304.62	307.22	303.28	304.41	48321851.0
2022-08-29	IWM	ETF	186.95	188.99	186.52	187.24	19753300.0
2022-08-29	DIA	ETF	320.54	323.33	319.75	321.1	2896900.0
2022-08-29	GLD	ETF	161.88	162.62	161.7	161.86	4702300.0
2022-08-29	TLT	ETF	112.94	113.01	112.13	112.68	14278300.0
2022-08-29	AAA	ETF	24.415	24.43	24.415	24.43	331.0
2022-08-29	AAAU	ETF	17.25	17.33	17.24	17.25	937700.0
2022-08-29	AADR	ETF	50.61	50.87	50.61	50.71	1000.0
2022-08-29	AAPB	ETF	23.76	24.2	23.7476	23.922	10137.0
2022-08-29	AAPD	ETF	25.55	25.679	25.24	25.4614	55765.0
2022-08-29	AAPU	ETF	23.99	24.3805	23.88	24.12	30217.0
2022-08-29	AAXJ	ETF	67.16	67.55	66.94	66.94	547900.0
2022-08-29	ABEQ	ETF	27.018	27.1	26.95	26.99	7300.0
2022-08-29	ACES	ETF	62.55	64.11	62.55	63.19	31700.0
2022-08-29	ACIO	ETF	30.22	30.29	30.17	30.2	45600.0
2022-08-29	ACSI	ETF	46.04	46.04	45.9352	45.9352	134.0
2022-08-29	ACT	ETF	25.94	26.375	25.82	25.85	61939.0
2022-08-29	ACTV	ETF	30.36	30.47	30.2756	30.2756	3965.0
2022-08-29	ACTX	ETF	0.5	0.5	0.314	0.314	13339.0
2022-08-29	ACVF	ETF	30.42	30.42	30.18	30.335	5200.0
2022-08-29	ACWF	ETF	32.54	32.6516	32.2	32.5171	11659.0
2022-08-29	ACWI	ETF	87.33	87.98	87.15	87.36	7073600.0
2022-08-29	ACWV	ETF	95.87	96.44	95.71	96.02	90600.0
2022-08-29	ACWX	ETF	44.87	45.13	44.8	44.87	2630276.0
2022-08-29	ADFI	ETF	8.47	8.55	8.47	8.545	14900.0
2022-08-29	ADIV	ETF	13.375	13.375	13.375	13.375	100.0
2022-08-29	ADME	ETF	35.91	36.025	35.87	35.92	23300.0
2022-08-29	ADRE	ETF	39.85	39.88	39.65	39.65	3778.0
2022-08-29	AEMB	ETF	38.34	38.34	38.34	38.34	100.0
2022-08-29	AESR	ETF	11.84	11.92	11.84	11.87	17900.0
2022-08-29	AFIF	ETF	8.92	8.92	8.91	8.915	9108.0
2022-08-29	AFK	ETF	17.25	17.38	17.2201	17.32	6627.0
2022-08-29	AFLG	ETF	23.981	23.981	23.981	23.981	100.0
2022-08-29	AFMC	ETF	22.701	22.701	22.701	22.701	100.0
2022-08-29	AFSM	ETF	23.61	23.61	23.61	23.61	100.0
2022-08-29	AFTY	ETF	16.73	16.747	16.73	16.747	400.0
2022-08-29	AGG	ETF	101.27	101.28	101.06	101.12	7509000.0
2022-08-29	AGGY	ETF	44.68	44.682	44.43	44.61	201000.0
2022-08-29	AGIH	ETF	25.62	25.62	25.585	25.585	112.0
2022-08-29	AGNG	ETF	25.0	25.0	24.35	24.622	457900.0
2022-08-29	AGOV	ETF	82.185	82.73	82.0263	82.0263	621.0
2022-08-29	AGOX	ETF	21.534	21.54	21.37	21.44	9400.0
2022-08-29	AGQ	ETF	20.04	20.5	19.95	20.21	778900.0
2022-08-29	AGZ	ETF	109.36	109.43	109.31	109.42	30449.0
2022-08-29	AGZD	ETF	22.94	22.98	22.935	22.945	90400.0
2022-08-29	AHHX	ETF	8.71	8.71	8.6798	8.6798	558.0
2022-08-29	AHYB	ETF	43.922	43.922	43.833	43.833	300.0
2022-08-29	AIA	ETF	59.36	59.78	59.05	59.13	364933.0
2022-08-29	AIEQ	ETF	34.22	34.717	34.22	34.465	3400.0

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

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