PREVIEW / etf_daily / 2022-08-30

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-30.parquet
  size:    103 KB
  rows:    2,782

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-30	SPY	ETF	403.85	404.1	396.0	398.21	85652400.0
2022-08-30	QQQ	ETF	306.1	306.73	298.44	301.02	51184500.0
2022-08-30	IWM	ETF	187.82	188.01	183.54	184.62	22548900.0
2022-08-30	DIA	ETF	322.09	322.17	316.57	318.04	2926300.0
2022-08-30	GLD	ETF	161.27	161.43	160.34	160.51	4856600.0
2022-08-30	TLT	ETF	112.62	113.51	112.21	112.96	14346600.0
2022-08-30	AAA	ETF	24.43	24.43	24.43	24.43	1.0
2022-08-30	AAAU	ETF	17.2	17.2	17.09	17.11	1931200.0
2022-08-30	AADR	ETF	50.84	50.84	49.83	49.95	1700.0
2022-08-30	AAPB	ETF	23.31	23.35	23.1299	23.2925	1222.0
2022-08-30	AAPD	ETF	25.4	26.011	25.33	25.8391	61850.0
2022-08-30	AAPU	ETF	24.31	24.31	23.39	23.5	21484.0
2022-08-30	AAXJ	ETF	67.21	67.26	66.13	66.34	703500.0
2022-08-30	ABEQ	ETF	26.806	26.806	26.688	26.688	2400.0
2022-08-30	ACES	ETF	63.93	64.36	61.537	62.17	34100.0
2022-08-30	ACIO	ETF	30.01	30.04	29.909	30.03	42700.0
2022-08-30	ACSI	ETF	45.4147	45.4147	45.4147	45.4147	105.0
2022-08-30	ACT	ETF	25.88	26.1725	25.34	25.36	103471.0
2022-08-30	ACTV	ETF	29.88	29.99	29.87	29.9405	2448.0
2022-08-30	ACVF	ETF	30.24	30.24	29.8	29.896	26200.0
2022-08-30	ACWF	ETF	32.4389	32.4389	32.08	32.13	9470.0
2022-08-30	ACWI	ETF	87.73	87.77	86.07	86.46	5699500.0
2022-08-30	ACWV	ETF	96.3	96.3	95.18	95.31	73500.0
2022-08-30	ACWX	ETF	45.07	45.14	44.355	44.46	2294365.0
2022-08-30	ADFI	ETF	8.52	8.54	8.51	8.525	21100.0
2022-08-30	ADIV	ETF	13.31	13.31	13.292	13.292	400.0
2022-08-30	ADME	ETF	35.72	35.72	35.55	35.602	25600.0
2022-08-30	ADRE	ETF	39.84	39.84	39.035	39.18	971.0
2022-08-30	AEMB	ETF	38.08	38.16	38.08	38.16	400.0
2022-08-30	AESR	ETF	11.72	11.72	11.65	11.7	33000.0
2022-08-30	AFIF	ETF	8.91	8.92	8.9	8.92	24346.0
2022-08-30	AFK	ETF	17.3	17.3	16.69	16.71	6626.0
2022-08-30	AFLG	ETF	23.65	23.65	23.63	23.643	300.0
2022-08-30	AFMC	ETF	22.333	22.333	22.333	22.333	100.0
2022-08-30	AFSM	ETF	23.4	23.4	23.119	23.119	200.0
2022-08-30	AFTY	ETF	16.56	16.569	16.56	16.569	100.0
2022-08-30	AGG	ETF	101.26	101.45	100.93	101.25	6573600.0
2022-08-30	AGGH	ETF	23.47	23.49	23.4697	23.4715	1151.0
2022-08-30	AGGY	ETF	44.6	44.7	44.43	44.61	89200.0
2022-08-30	AGNG	ETF	24.66	24.69	24.57	24.58	11500.0
2022-08-30	AGOV	ETF	81.69	81.69	80.9708	80.9708	4513.0
2022-08-30	AGOX	ETF	21.28	21.28	21.104	21.17	206000.0
2022-08-30	AGQ	ETF	20.06	20.07	19.29	19.4	918600.0
2022-08-30	AGZ	ETF	109.32	109.48	109.15	109.22	22324.0
2022-08-30	AGZD	ETF	22.96	23.005	22.915	22.945	101000.0
2022-08-30	AHHX	ETF	8.5614	8.5745	8.5562	8.5562	1805.0
2022-08-30	AHYB	ETF	43.566	43.566	43.566	43.566	100.0
2022-08-30	AIA	ETF	59.16	59.16	57.82	58.05	253991.0
2022-08-30	AIEQ	ETF	34.37	34.37	33.401	33.54	6100.0
2022-08-30	AIQ	ETF	21.84	21.86	21.36	21.62	27202.0

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

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