PREVIEW / etf_daily / 2023-03-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-08.parquet
  size:    109 KB
  rows:    2,930

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
2023-03-08	SPY	ETF	398.39	399.71	396.59	398.92	74746600.0
2023-03-08	QQQ	ETF	296.77	298.43	294.88	297.82	50876265.0
2023-03-08	IWM	ETF	186.79	187.61	185.12	186.6	22505900.0
2023-03-08	DIA	ETF	328.92	329.5	326.6	328.49	3169600.0
2023-03-08	GLD	ETF	168.61	169.59	168.52	168.54	5718600.0
2023-03-08	TLT	ETF	102.4	102.97	101.42	101.82	20252400.0
2023-03-08	AAA	ETF	24.56	24.6	24.56	24.59	322.0
2023-03-08	AAAU	ETF	17.99	18.09	17.99	17.99	1595900.0
2023-03-08	AADR	ETF	48.42	48.91	48.42	48.91	600.0
2023-03-08	AAPB	ETF	19.96	20.1	19.9199	20.0036	5632.0
2023-03-08	AAPD	ETF	25.66	25.8099	25.5559	25.62	105646.0
2023-03-08	AAPU	ETF	20.99	21.0701	20.79	21.0	73833.0
2023-03-08	AAXJ	ETF	66.4	66.6	66.26	66.49	552700.0
2023-03-08	ABEQ	ETF	27.6	27.6	27.52	27.52	8100.0
2023-03-08	ACES	ETF	47.92	48.12	47.29	48.03	66800.0
2023-03-08	ACIO	ETF	29.565	29.61	29.48	29.54	87000.0
2023-03-08	ACSI	ETF	43.92	43.92	43.9061	43.9061	597.0
2023-03-08	ACT	ETF	24.24	24.6	24.201	24.5	100220.0
2023-03-08	ACTV	ETF	31.16	31.2	31.05	31.176	1458.0
2023-03-08	ACVF	ETF	30.708	30.74	30.708	30.74	2600.0
2023-03-08	ACWF	ETF	33.02	33.0501	32.945	33.0501	2966.0
2023-03-08	ACWI	ETF	88.85	89.17	88.52	88.94	1800000.0
2023-03-08	ACWV	ETF	93.67	93.9	93.44	93.73	201900.0
2023-03-08	ACWX	ETF	47.68	47.95	47.615	47.8	2351925.0
2023-03-08	ADFI	ETF	8.38	8.39	8.365	8.365	12500.0
2023-03-08	ADIV	ETF	13.83	13.83	13.83	13.83	100.0
2023-03-08	ADME	ETF	33.89	33.89	33.72	33.79	59400.0
2023-03-08	ADPV	ETF	25.16	25.2	25.065	25.18	17616.0
2023-03-08	ADRE	ETF	39.34	39.63	39.34	39.6	2905.0
2023-03-08	AEMB	ETF	37.29	37.29	37.29	37.29	100.0
2023-03-08	AESR	ETF	11.56	11.57	11.5	11.57	33100.0
2023-03-08	AFIF	ETF	8.83	8.85	8.82	8.83	46513.0
2023-03-08	AFK	ETF	15.84	15.99	15.83	15.83	3653.0
2023-03-08	AFLG	ETF	23.827	23.827	23.827	23.827	100.0
2023-03-08	AFSM	ETF	24.14	24.202	24.14	24.202	300.0
2023-03-08	AFTY	ETF	16.085	16.085	16.028	16.028	300.0
2023-03-08	AGG	ETF	96.9	97.08	96.48	96.61	8044000.0
2023-03-08	AGGY	ETF	42.68	42.765	42.535	42.6	95100.0
2023-03-08	AGNG	ETF	25.88	25.88	25.751	25.87	13400.0
2023-03-08	AGOV	ETF	75.4407	75.4407	75.4407	75.4407	49.0
2023-03-08	AGOX	ETF	21.62	21.77	21.57	21.72	99600.0
2023-03-08	AGQ	ETF	21.74	22.08	21.62	21.67	694600.0
2023-03-08	AGZ	ETF	106.07	106.15	105.78	105.78	39348.0
2023-03-08	AGZD	ETF	21.94	21.975	21.94	21.955	96400.0
2023-03-08	AHHX	ETF	8.47	8.4954	8.47	8.4954	323.0
2023-03-08	AHYB	ETF	43.291	43.33	43.07	43.121	800.0
2023-03-08	AIA	ETF	59.09	59.3041	59.08	59.26	70460.0
2023-03-08	AIEQ	ETF	30.11	30.11	29.8	29.96	15300.0
2023-03-08	AIQ	ETF	22.72	22.8718	22.7	22.8	13613.0
2023-03-08	AIRR	ETF	50.61	50.72	50.242	50.63	51100.0

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

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