PREVIEW / etf_daily / 2023-07-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-03.parquet
  size:    106 KB
  rows:    2,971

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-07-03	SPY	ETF	442.92	444.08	442.63	443.79	32793400.0
2023-07-03	QQQ	ETF	370.07	370.93	368.97	370.29	19432862.0
2023-07-03	IWM	ETF	186.91	188.84	186.74	187.65	14011900.0
2023-07-03	DIA	ETF	343.0	344.53	342.78	344.07	1698400.0
2023-07-03	GLD	ETF	178.61	179.34	178.46	178.47	4085700.0
2023-07-03	TLT	ETF	102.84	103.26	102.06	102.08	16011800.0
2023-07-03	AAA	ETF	24.57	24.57	24.54	24.54	200.0
2023-07-03	AAAU	ETF	19.07	19.16	19.05	19.05	920800.0
2023-07-03	AADR	ETF	48.16	49.55	48.16	49.37	1600.0
2023-07-03	AAPB	ETF	29.27	29.35	28.82	28.97	22062.0
2023-07-03	AAPD	ETF	20.08	20.2799	20.0701	20.23	107664.0
2023-07-03	AAPU	ETF	29.08	29.12	28.66	28.79	103335.0
2023-07-03	AAXJ	ETF	67.22	67.58	67.14	67.23	280400.0
2023-07-03	ABEQ	ETF	28.19	28.24	28.18	28.184	5100.0
2023-07-03	ACES	ETF	45.5	46.55	45.5	45.93	47900.0
2023-07-03	ACIO	ETF	31.22	31.22	31.07	31.17	10000.0
2023-07-03	ACSI	ETF	47.263	47.263	47.263	47.263	100.0
2023-07-03	ACT	ETF	25.25	25.91	25.1985	25.72	174182.0
2023-07-03	ACTV	ETF	31.55	31.832	31.545	31.832	5600.0
2023-07-03	ACVF	ETF	33.87	33.88	33.87	33.88	2100.0
2023-07-03	ACWF	ETF	35.44	35.445	35.44	35.4438	982.0
2023-07-03	ACWI	ETF	96.02	96.22	95.97	96.17	1508900.0
2023-07-03	ACWV	ETF	98.2	98.2	97.82	98.19	61500.0
2023-07-03	ACWX	ETF	49.35	49.52	49.35	49.42	760600.0
2023-07-03	ADFI	ETF	8.45	8.46	8.44	8.455	9800.0
2023-07-03	ADIV	ETF	13.55	13.616	13.55	13.616	300.0
2023-07-03	ADME	ETF	36.366	36.4	36.355	36.387	3500.0
2023-07-03	ADPV	ETF	24.87	24.87	24.8437	24.8437	346.0
2023-07-03	AEMB	ETF	37.68	37.68	37.68	37.68	100.0
2023-07-03	AESR	ETF	12.85	12.945	12.75	12.82	35600.0
2023-07-03	AFIF	ETF	8.82	8.82	8.79	8.79	1400.0
2023-07-03	AFK	ETF	15.06	15.06	14.89	14.93	5000.0
2023-07-03	AFLG	ETF	25.471	25.471	25.471	25.471	100.0
2023-07-03	AFMC	ETF	24.95	24.956	24.95	24.956	100.0
2023-07-03	AFSM	ETF	24.86	24.864	24.817	24.864	800.0
2023-07-03	AFTY	ETF	14.97	15.04	14.948	14.948	1900.0
2023-07-03	AGG	ETF	97.82	98.04	97.54	97.58	3691600.0
2023-07-03	AGGH	ETF	22.51	22.52	22.5	22.5	4944.0
2023-07-03	AGGY	ETF	43.08	43.155	43.005	43.005	120900.0
2023-07-03	AGNG	ETF	27.59	27.59	27.46	27.46	700.0
2023-07-03	AGOV	ETF	75.15	75.22	75.15	75.22	147.0
2023-07-03	AGOX	ETF	23.67	23.67	23.41	23.53	10700.0
2023-07-03	AGQ	ETF	27.36	27.66	27.17	27.2	433400.0
2023-07-03	AGRH	ETF	25.67	25.69	25.633	25.633	66971.0
2023-07-03	AGZ	ETF	106.6	106.83	106.59	106.59	26600.0
2023-07-03	AGZD	ETF	22.095	22.15	22.095	22.14	20800.0
2023-07-03	AHOY	ETF	20.61	20.61	20.5803	20.5803	656.0
2023-07-03	AHYB	ETF	43.756	43.77	43.756	43.77	300.0
2023-07-03	AIA	ETF	60.63	60.82	60.48	60.57	33000.0
2023-07-03	AIEQ	ETF	31.48	31.76	31.48	31.74	28900.0

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

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