PREVIEW / etf_daily / 2023-10-23

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-23.parquet
  size:    111 KB
  rows:    3,105

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-10-23	SPY	ETF	419.61	424.45	417.8	420.46	92035100.0
2023-10-23	QQQ	ETF	353.26	359.26	351.1199	355.67	60665185.0
2023-10-23	IWM	ETF	165.66	167.46	164.65	165.03	45590900.0
2023-10-23	DIA	ETF	329.9	332.33	328.88	329.32	3898300.0
2023-10-23	GLD	ETF	183.51	183.56	182.71	182.97	9479800.0
2023-10-23	TLT	ETF	82.81	84.86	82.42	84.24	70890400.0
2023-10-23	AAA	ETF	24.8	24.84	24.8	24.84	400.0
2023-10-23	AAAU	ETF	19.6	19.61	19.52	19.55	1086900.0
2023-10-23	AADR	ETF	46.55	47.52	46.55	47.52	900.0
2023-10-23	AAPB	ETF	22.56	23.22	22.4	23.11	13304.0
2023-10-23	AAPD	ETF	22.84	22.93	22.4188	22.53	171304.0
2023-10-23	AAPU	ETF	23.36	24.02	23.2	23.82	87540.0
2023-10-23	AAXJ	ETF	61.3	61.94	61.06	61.74	287500.0
2023-10-23	ABEQ	ETF	27.06	27.18	27.03	27.05	19900.0
2023-10-23	ACES	ETF	30.25	31.108	29.95	30.41	40600.0
2023-10-23	ACIO	ETF	30.12	30.33	30.12	30.21	60300.0
2023-10-23	ACSI	ETF	43.7	43.7	43.542	43.542	1100.0
2023-10-23	ACT	ETF	27.04	27.24	26.84	27.02	155881.0
2023-10-23	ACTV	ETF	28.03	28.26	27.82	27.88	12200.0
2023-10-23	ACVF	ETF	32.11	32.45	32.11	32.22	9900.0
2023-10-23	ACWF	ETF	33.46	33.715	33.4	33.5887	6426.0
2023-10-23	ACWI	ETF	89.99	91.03	89.67	90.33	3015100.0
2023-10-23	ACWV	ETF	93.63	94.02	93.32	93.46	193200.0
2023-10-23	ACWX	ETF	45.27	45.75	45.09	45.46	1670700.0
2023-10-23	ADFI	ETF	8.03	8.09	8.03	8.07	13000.0
2023-10-23	ADIV	ETF	12.797	12.797	12.797	12.797	100.0
2023-10-23	ADME	ETF	34.65	34.85	34.65	34.662	23000.0
2023-10-23	ADPV	ETF	22.91	23.0901	22.91	22.911	12062.0
2023-10-23	ADVE	ETF	28.7	28.7	28.69	28.6902	337.0
2023-10-23	AEMB	ETF	35.09	35.09	34.99	34.99	2000.0
2023-10-23	AESR	ETF	11.88	12.1	11.88	12.04	59100.0
2023-10-23	AETH	ETF	25.03	25.5855	25.03	25.5855	3751.0
2023-10-23	AFIF	ETF	8.9	8.9	8.86	8.87	8500.0
2023-10-23	AFK	ETF	14.08	14.08	13.71	13.89	7100.0
2023-10-23	AFLG	ETF	24.32	24.32	24.305	24.305	100.0
2023-10-23	AFMC	ETF	22.538	22.538	22.538	22.538	100.0
2023-10-23	AFSM	ETF	22.602	22.602	22.602	22.602	100.0
2023-10-23	AFTY	ETF	13.73	13.746	13.73	13.746	300.0
2023-10-23	AGG	ETF	91.7	92.5	91.58	92.36	12885800.0
2023-10-23	AGGH	ETF	20.84	21.04	20.84	20.97	27990.0
2023-10-23	AGGY	ETF	40.69	40.99	40.66	40.95	1012900.0
2023-10-23	AGNG	ETF	25.02	25.16	25.02	25.15	2700.0
2023-10-23	AGOV	ETF	72.71	72.71	72.71	72.71	10.0
2023-10-23	AGOX	ETF	22.31	22.49	22.22	22.22	14100.0
2023-10-23	AGQ	ETF	26.52	26.67	26.01	26.13	814600.0
2023-10-23	AGRH	ETF	25.52	25.5399	25.49	25.49	2082.0
2023-10-23	AGZ	ETF	105.2	105.44	105.14	105.41	15300.0
2023-10-23	AGZD	ETF	22.09	22.11	21.99	22.07	215600.0
2023-10-23	AHLT	ETF	27.1	27.1	26.6	26.7	7488.0
2023-10-23	AHYB	ETF	42.37	42.592	42.37	42.592	300.0

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

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