PREVIEW / etf_daily / 2023-03-23

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-23.parquet
  size:    110 KB
  rows:    2,941

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-23	SPY	ETF	395.09	399.29	390.35	393.17	119351300.0
2023-03-23	QQQ	ETF	309.92	314.15	307.01	309.75	74575981.0
2023-03-23	IWM	ETF	172.28	174.39	168.71	170.25	47720900.0
2023-03-23	DIA	ETF	321.33	325.02	318.5	320.84	4772600.0
2023-03-23	GLD	ETF	183.91	186.24	183.6	185.74	11347100.0
2023-03-23	TLT	ETF	105.36	106.55	104.82	106.4	25475100.0
2023-03-23	AAA	ETF	24.465	24.465	24.465	24.465	65.0
2023-03-23	AAAU	ETF	19.63	19.87	19.6	19.82	2614100.0
2023-03-23	AADR	ETF	46.25	47.1	45.88	45.89	2500.0
2023-03-23	AAPB	ETF	21.31	21.8505	21.14	21.3	21874.0
2023-03-23	AAPD	ETF	24.51	24.6799	24.1186	24.52	268463.0
2023-03-23	AAPU	ETF	22.11	22.606	21.8542	22.11	169150.0
2023-03-23	AAXJ	ETF	66.91	67.74	66.71	67.05	832200.0
2023-03-23	ABEQ	ETF	27.25	27.356	27.129	27.168	7000.0
2023-03-23	ACES	ETF	44.98	45.59	43.44	43.76	21700.0
2023-03-23	ACIO	ETF	29.665	29.823	29.49	29.64	17000.0
2023-03-23	ACSI	ETF	42.6971	42.6971	42.6971	42.6971	102.0
2023-03-23	ACT	ETF	22.09	22.09	21.655	21.72	85066.0
2023-03-23	ACTV	ETF	28.8	28.92	28.06	28.2488	11531.0
2023-03-23	ACTX	ETF	0.25	0.25	0.25	0.25	2598.0
2023-03-23	ACVF	ETF	30.48	30.75	30.08	30.328	4900.0
2023-03-23	ACWF	ETF	32.75	32.94	32.408	32.5816	13172.0
2023-03-23	ACWI	ETF	88.35	89.16	87.34	87.85	2834300.0
2023-03-23	ACWV	ETF	94.09	94.79	93.75	94.02	294900.0
2023-03-23	ACWX	ETF	47.66	47.93	47.07	47.26	1786096.0
2023-03-23	ADFI	ETF	8.51	8.51	8.505	8.505	1800.0
2023-03-23	ADIV	ETF	13.759	13.759	13.759	13.759	100.0
2023-03-23	ADME	ETF	34.159	34.159	33.83	33.83	11700.0
2023-03-23	ADPV	ETF	22.55	22.8	22.55	22.78	20696.0
2023-03-23	ADRE	ETF	38.11	38.205	38.095	38.11	10948.0
2023-03-23	AEMB	ETF	37.74	37.77	37.731	37.77	500.0
2023-03-23	AESR	ETF	11.58	11.62	11.499	11.499	5100.0
2023-03-23	AFIF	ETF	8.7997	8.8	8.71	8.71	19569.0
2023-03-23	AFK	ETF	15.48	15.739	15.29	15.4115	42685.0
2023-03-23	AFLG	ETF	23.134	23.134	23.134	23.134	100.0
2023-03-23	AFMC	ETF	22.085	22.085	22.085	22.085	300.0
2023-03-23	AFSM	ETF	22.411	22.411	22.411	22.411	200.0
2023-03-23	AFTY	ETF	16.321	16.321	16.321	16.321	100.0
2023-03-23	AGG	ETF	99.68	100.05	99.51	99.99	9949700.0
2023-03-23	AGGH	ETF	23.11	23.11	23.079	23.079	1044.0
2023-03-23	AGGY	ETF	43.76	43.94	43.73	43.9	276700.0
2023-03-23	AGNG	ETF	26.16	26.16	25.91	26.02	600.0
2023-03-23	AGOV	ETF	75.71	76.86	75.71	76.86	10668.0
2023-03-23	AGOX	ETF	20.95	21.3	20.89	21.014	34000.0
2023-03-23	AGQ	ETF	28.52	29.1	28.25	28.88	853900.0
2023-03-23	AGZ	ETF	108.28	108.73	108.26	108.68	19883.0
2023-03-23	AGZD	ETF	21.75	21.83	21.675	21.675	124600.0
2023-03-23	AHHX	ETF	8.31	8.355	8.31	8.355	622.0
2023-03-23	AHYB	ETF	43.54	43.54	43.255	43.255	900.0
2023-03-23	AIA	ETF	60.9	61.3808	60.2501	60.63	62633.0

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

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