PREVIEW / etf_daily / 2023-02-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-13.parquet
  size:    109 KB
  rows:    2,921

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-02-13	SPY	ETF	408.72	412.97	408.24	412.83	64913500.0
2023-02-13	QQQ	ETF	301.13	305.1	299.93	304.5	39636720.0
2023-02-13	IWM	ETF	190.51	192.86	189.31	192.6	15754400.0
2023-02-13	DIA	ETF	338.88	342.56	338.88	342.55	2653900.0
2023-02-13	GLD	ETF	172.7	172.9	172.07	172.48	3970800.0
2023-02-13	TLT	ETF	103.71	104.42	103.58	104.26	13134300.0
2023-02-13	AAA	ETF	24.61	24.615	24.61	24.615	241.0
2023-02-13	AAAU	ETF	18.42	18.44	18.36	18.38	780300.0
2023-02-13	AADR	ETF	49.78	49.78	49.78	49.78	800.0
2023-02-13	AAPB	ETF	19.7886	20.4899	19.7886	20.43	3624.0
2023-02-13	AAPD	ETF	25.97	25.97	25.4113	25.47	78412.0
2023-02-13	AAPU	ETF	20.72	21.35	20.72	21.29	85789.0
2023-02-13	AAXJ	ETF	69.44	69.84	69.22	69.74	515000.0
2023-02-13	ABEQ	ETF	28.57	28.67	28.57	28.636	3400.0
2023-02-13	ACES	ETF	49.9	50.694	49.8	50.46	37000.0
2023-02-13	ACIO	ETF	30.04	30.21	30.04	30.21	55700.0
2023-02-13	ACSI	ETF	46.1545	46.1545	46.1545	46.1545	24.0
2023-02-13	ACT	ETF	24.38	24.75	24.36	24.62	122008.0
2023-02-13	ACTV	ETF	32.505	32.72	32.505	32.72	6244.0
2023-02-13	ACVF	ETF	31.64	31.78	31.51	31.771	4300.0
2023-02-13	ACWF	ETF	33.77	33.9489	33.77	33.934	2320.0
2023-02-13	ACWI	ETF	90.94	91.82	90.84	91.76	6341100.0
2023-02-13	ACWV	ETF	95.93	96.47	95.88	96.47	158600.0
2023-02-13	ACWX	ETF	48.87	49.23	48.7763	49.2	962820.0
2023-02-13	ADFI	ETF	8.39	8.505	8.39	8.505	400.0
2023-02-13	ADIV	ETF	14.193	14.193	14.18	14.18	800.0
2023-02-13	ADME	ETF	34.7	34.83	34.682	34.78	27400.0
2023-02-13	ADPV	ETF	25.4025	25.57	25.4025	25.52	210608.0
2023-02-13	ADRE	ETF	41.63	42.0	41.63	41.97	63153.0
2023-02-13	AEMB	ETF	38.296	38.296	38.221	38.221	200.0
2023-02-13	AESR	ETF	11.89	11.96	11.79	11.95	16600.0
2023-02-13	AFIF	ETF	8.87	8.91	8.87	8.91	42206.0
2023-02-13	AFK	ETF	16.8	16.8601	16.748	16.85	20980.0
2023-02-13	AFLG	ETF	24.66	24.693	24.637	24.693	1600.0
2023-02-13	AFMC	ETF	24.292	24.292	24.292	24.292	100.0
2023-02-13	AFSM	ETF	24.65	24.705	24.65	24.705	100.0
2023-02-13	AFTY	ETF	17.14	17.16	17.14	17.141	1100.0
2023-02-13	AGG	ETF	98.49	98.72	98.46	98.72	6832700.0
2023-02-13	AGGY	ETF	43.42	43.535	43.42	43.52	67600.0
2023-02-13	AGNG	ETF	26.99	27.156	26.71	27.08	4100.0
2023-02-13	AGOV	ETF	78.67	78.67	78.67	78.67	2.0
2023-02-13	AGOX	ETF	22.12	22.31	22.12	22.26	11600.0
2023-02-13	AGQ	ETF	26.26	26.52	25.97	26.43	353500.0
2023-02-13	AGZ	ETF	107.16	107.2672	107.16	107.267	19536.0
2023-02-13	AGZD	ETF	21.955	21.985	21.93	21.97	73600.0
2023-02-13	AHHX	ETF	8.68	8.68	8.63	8.655	2742.0
2023-02-13	AHYB	ETF	43.634	43.708	43.634	43.708	200.0
2023-02-13	AIA	ETF	63.59	64.16	63.475	64.02	1460486.0
2023-02-13	AIEQ	ETF	31.03	31.45	30.77	31.38	24900.0
2023-02-13	AIQ	ETF	23.31	23.59	23.22	23.58	17656.0

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

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