PREVIEW / etf_daily / 2023-09-25

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-25.parquet
  size:    109 KB
  rows:    3,041

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-09-25	SPY	ETF	429.17	432.27	428.72	432.23	70874500.0
2023-09-25	QQQ	ETF	356.93	359.7	355.93	359.61	39167985.0
2023-09-25	IWM	ETF	175.69	177.86	175.54	177.46	22416200.0
2023-09-25	DIA	ETF	338.73	340.07	337.69	339.98	3104700.0
2023-09-25	GLD	ETF	178.41	178.71	177.64	177.7	5582100.0
2023-09-25	TLT	ETF	89.66	90.04	89.15	89.18	45587900.0
2023-09-25	AAA	ETF	24.85	24.909	24.85	24.895	10100.0
2023-09-25	AAAU	ETF	19.06	19.08	18.97	18.98	945800.0
2023-09-25	AADR	ETF	48.96	48.96	48.91	48.91	600.0
2023-09-25	AAPB	ETF	23.8	24.25	23.8	24.09	8219.0
2023-09-25	AAPD	ETF	22.29	22.29	21.9533	22.04	119700.0
2023-09-25	AAPU	ETF	24.24	24.7799	24.24	24.61	82421.0
2023-09-25	AAXJ	ETF	63.78	64.16	63.78	64.13	499000.0
2023-09-25	ABEQ	ETF	27.75	27.86	27.73	27.86	12400.0
2023-09-25	ACES	ETF	37.63	38.11	37.518	37.97	38700.0
2023-09-25	ACIO	ETF	30.53	30.7	30.53	30.68	66900.0
2023-09-25	ACSI	ETF	44.64	44.675	44.64	44.675	100.0
2023-09-25	ACT	ETF	27.55	27.73	27.5	27.65	98899.0
2023-09-25	ACTV	ETF	30.48	30.67	30.45	30.599	12700.0
2023-09-25	ACVF	ETF	33.24	33.34	33.16	33.34	3600.0
2023-09-25	ACWF	ETF	34.556	34.71	34.556	34.6814	1994.0
2023-09-25	ACWI	ETF	92.81	93.39	92.75	93.38	1647100.0
2023-09-25	ACWV	ETF	96.84	96.93	96.54	96.92	153200.0
2023-09-25	ACWX	ETF	47.34	47.54	47.26	47.51	1123300.0
2023-09-25	ADFI	ETF	8.27	8.27	8.24	8.25	3100.0
2023-09-25	ADIV	ETF	13.44	13.501	13.44	13.501	200.0
2023-09-25	ADME	ETF	35.44	35.56	35.41	35.56	13400.0
2023-09-25	ADPV	ETF	23.78	23.9201	23.75	23.83	40835.0
2023-09-25	AEMB	ETF	36.195	36.195	36.195	36.195	100.0
2023-09-25	AESR	ETF	12.21	12.29	12.21	12.29	21800.0
2023-09-25	AFIF	ETF	8.88	8.93	8.88	8.89	41800.0
2023-09-25	AFK	ETF	14.24	14.54	14.0	14.0	22900.0
2023-09-25	AFLG	ETF	24.909	24.92	24.86	24.911	600.0
2023-09-25	AFMC	ETF	23.95	23.95	23.91	23.91	200.0
2023-09-25	AGG	ETF	94.49	94.62	94.29	94.3	7485000.0
2023-09-25	AGGH	ETF	21.7031	21.72	21.65	21.7	16863.0
2023-09-25	AGGY	ETF	41.69	41.74	41.63	41.63	86400.0
2023-09-25	AGIH	ETF	23.7501	23.765	23.7501	23.765	898.0
2023-09-25	AGNG	ETF	26.23	26.295	26.19	26.295	3200.0
2023-09-25	AGOV	ETF	73.3	73.62	72.055	73.5173	3012.0
2023-09-25	AGOX	ETF	22.6	22.745	22.6	22.69	18700.0
2023-09-25	AGQ	ETF	27.6	27.77	26.66	26.85	773500.0
2023-09-25	AGZ	ETF	105.92	105.96	105.85	105.87	15000.0
2023-09-25	AGZD	ETF	22.23	22.26	22.16	22.21	72300.0
2023-09-25	AHLT	ETF	26.26	26.416	26.26	26.416	246.0
2023-09-25	AHOY	ETF	19.79	19.8138	19.78	19.8138	3757.0
2023-09-25	AHYB	ETF	43.538	43.55	43.525	43.525	600.0
2023-09-25	AIA	ETF	55.6	56.0	55.6	55.9	26400.0
2023-09-25	AIEQ	ETF	29.77	30.124	29.77	30.118	13400.0
2023-09-25	AIQ	ETF	26.78	27.01	26.72	26.93	214900.0

> showing 50 of 3,041 rows — these rows as CSV

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