PREVIEW / etf_daily / 2023-06-30

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-30.parquet
  size:    110 KB
  rows:    2,974

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-06-30	SPY	ETF	441.44	444.3	441.11	443.28	104921500.0
2023-06-30	QQQ	ETF	367.55	370.49	367.23	369.42	58712501.0
2023-06-30	IWM	ETF	188.26	188.43	186.91	187.27	30271600.0
2023-06-30	DIA	ETF	343.22	344.58	342.76	343.85	3025000.0
2023-06-30	GLD	ETF	177.69	178.53	177.32	178.27	6420600.0
2023-06-30	TLT	ETF	102.06	103.06	101.87	102.94	32018800.0
2023-06-30	AAA	ETF	24.66	24.69	24.66	24.66	505.0
2023-06-30	AAAU	ETF	18.96	19.06	18.93	19.04	1183900.0
2023-06-30	AADR	ETF	49.35	49.61	49.35	49.61	1900.0
2023-06-30	AAPB	ETF	28.8	29.43	28.7	29.27	31364.0
2023-06-30	AAPD	ETF	20.3	20.34	20.0	20.0523	526662.0
2023-06-30	AAPU	ETF	28.64	29.22	28.54	29.12	303329.0
2023-06-30	AAXJ	ETF	66.4	66.74	66.33	66.44	607800.0
2023-06-30	ABEQ	ETF	28.012	28.16	28.012	28.13	3800.0
2023-06-30	ACES	ETF	44.71	45.23	44.23	45.18	35500.0
2023-06-30	ACIO	ETF	31.02	31.18	31.02	31.11	43600.0
2023-06-30	ACSI	ETF	47.04	47.04	47.04	47.04	645.0
2023-06-30	ACT	ETF	25.11	25.33	25.05	25.13	204508.0
2023-06-30	ACTV	ETF	31.7	31.82	31.46	31.5858	11106.0
2023-06-30	ACVF	ETF	33.803	33.889	33.76	33.85	5500.0
2023-06-30	ACWF	ETF	35.19	35.43	35.19	35.3858	4635.0
2023-06-30	ACWI	ETF	95.66	96.09	95.59	95.94	2247800.0
2023-06-30	ACWV	ETF	97.87	98.18	97.76	98.06	496400.0
2023-06-30	ACWX	ETF	49.14	49.32	49.07	49.22	1790253.0
2023-06-30	ADFI	ETF	8.45	8.47	8.441	8.455	20200.0
2023-06-30	ADIV	ETF	13.528	13.528	13.528	13.528	100.0
2023-06-30	ADME	ETF	36.33	36.45	36.27	36.416	6100.0
2023-06-30	ADPV	ETF	24.73	24.96	24.73	24.9587	3792.0
2023-06-30	AEMB	ETF	37.86	37.86	37.805	37.805	400.0
2023-06-30	AESR	ETF	12.83	12.85	12.69	12.78	48000.0
2023-06-30	AFIF	ETF	8.79	8.82	8.79	8.8	18122.0
2023-06-30	AFK	ETF	14.75	14.78	14.59	14.7	64627.0
2023-06-30	AFLG	ETF	25.35	25.471	25.35	25.471	600.0
2023-06-30	AFMC	ETF	24.82	24.94	24.82	24.878	800.0
2023-06-30	AFSM	ETF	24.85	24.85	24.798	24.798	400.0
2023-06-30	AFTY	ETF	14.727	14.727	14.727	14.727	100.0
2023-06-30	AGG	ETF	97.86	98.1	97.74	97.95	13417300.0
2023-06-30	AGGH	ETF	22.5	22.54	22.44	22.5141	4053.0
2023-06-30	AGGY	ETF	43.0	43.09	42.95	43.09	592300.0
2023-06-30	AGNG	ETF	27.66	27.8	27.66	27.8	1500.0
2023-06-30	AGOV	ETF	75.09	75.09	75.09	75.09	2.0
2023-06-30	AGOX	ETF	23.67	23.67	23.41	23.43	11200.0
2023-06-30	AGQ	ETF	26.28	27.11	26.08	26.95	588400.0
2023-06-30	AGZ	ETF	106.91	107.01	106.8799	106.9662	12546.0
2023-06-30	AGZD	ETF	22.07	22.165	22.07	22.12	15600.0
2023-06-30	AHOY	ETF	20.585	20.62	20.5693	20.5693	306.0
2023-06-30	AHYB	ETF	43.976	44.15	43.97	44.06	10700.0
2023-06-30	AIA	ETF	59.59	59.92	59.4617	59.59	121281.0
2023-06-30	AIEQ	ETF	31.59	31.59	31.416	31.51	9400.0
2023-06-30	AIQ	ETF	27.88	28.1013	27.76	27.96	522729.0

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

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