PREVIEW / etf_daily / 2023-03-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-09.parquet
  size:    110 KB
  rows:    2,961

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-03-09	SPY	ETF	399.74	401.48	390.53	391.56	111945300.0
2023-03-09	QQQ	ETF	298.33	300.98	291.8299	292.66	71456691.0
2023-03-09	IWM	ETF	186.73	187.27	181.28	181.41	33546900.0
2023-03-09	DIA	ETF	329.72	330.44	322.4	323.08	4760900.0
2023-03-09	GLD	ETF	169.75	170.65	169.71	170.2	5583000.0
2023-03-09	TLT	ETF	101.55	102.52	101.33	102.07	21550400.0
2023-03-09	AAA	ETF	24.56	24.59	24.56	24.59	107.0
2023-03-09	AAAU	ETF	18.11	18.2	18.11	18.16	1140800.0
2023-03-09	AADR	ETF	48.8	48.8	47.68	47.68	1100.0
2023-03-09	AAPB	ETF	20.3059	20.37	19.475	19.53	2097.0
2023-03-09	AAPD	ETF	25.52	26.08	25.37	26.02	172968.0
2023-03-09	AAPU	ETF	21.15	21.31	20.43	20.53	87837.0
2023-03-09	AAXJ	ETF	66.03	66.03	64.82	64.94	865700.0
2023-03-09	ABEQ	ETF	27.5	27.53	27.24	27.24	12300.0
2023-03-09	ACES	ETF	48.2	48.63	46.49	46.51	55400.0
2023-03-09	ACIO	ETF	29.71	29.71	29.36	29.42	45400.0
2023-03-09	ACSI	ETF	43.9549	43.9549	42.833	42.833	240.0
2023-03-09	ACT	ETF	24.39	24.47	23.45	23.46	162961.0
2023-03-09	ACTV	ETF	31.1834	31.1834	30.3895	30.3895	9842.0
2023-03-09	ACTX	ETF	0.322	0.322	0.322	0.322	6006.0
2023-03-09	ACVF	ETF	30.76	30.76	30.1	30.206	6000.0
2023-03-09	ACWF	ETF	33.11	33.11	32.5701	32.5701	3552.0
2023-03-09	ACWI	ETF	89.0	89.34	87.35	87.51	2954900.0
2023-03-09	ACWV	ETF	93.66	93.91	92.73	92.98	140700.0
2023-03-09	ACWX	ETF	47.78	47.88	47.165	47.22	1289270.0
2023-03-09	ADFI	ETF	8.375	8.375	8.365	8.365	6600.0
2023-03-09	ADIV	ETF	13.521	13.555	13.521	13.555	400.0
2023-03-09	ADME	ETF	34.03	34.03	33.65	33.71	12300.0
2023-03-09	ADPV	ETF	25.09	25.11	24.44	24.44	27749.0
2023-03-09	ADRE	ETF	39.09	39.15	38.44	38.44	3033.0
2023-03-09	AEMB	ETF	37.445	37.445	37.244	37.244	200.0
2023-03-09	AESR	ETF	11.61	11.61	11.416	11.416	14500.0
2023-03-09	AFIF	ETF	8.86	8.86	8.84	8.855	16921.0
2023-03-09	AFK	ETF	15.92	15.92	15.64	15.64	7454.0
2023-03-09	AFMC	ETF	23.43	23.43	23.24	23.24	100.0
2023-03-09	AFSM	ETF	24.32	24.32	23.72	23.72	300.0
2023-03-09	AFTY	ETF	15.785	15.785	15.785	15.785	100.0
2023-03-09	AGG	ETF	96.76	97.15	96.7	96.96	7054400.0
2023-03-09	AGGH	ETF	22.15	22.16	22.1109	22.1109	274.0
2023-03-09	AGGY	ETF	42.65	42.764	42.61	42.69	105800.0
2023-03-09	AGNG	ETF	25.835	25.835	25.613	25.613	2300.0
2023-03-09	AGOV	ETF	77.79	77.79	75.595	75.595	132.0
2023-03-09	AGOX	ETF	21.64	21.715	21.17	21.221	10500.0
2023-03-09	AGQ	ETF	21.84	22.22	21.58	21.71	787600.0
2023-03-09	AGZ	ETF	106.13	106.32	106.02	106.3	35568.0
2023-03-09	AGZD	ETF	21.94	21.975	21.905	21.905	84200.0
2023-03-09	AHHX	ETF	8.4353	8.4353	8.4353	8.4353	26.0
2023-03-09	AHYB	ETF	43.28	43.31	42.911	42.911	900.0
2023-03-09	AIA	ETF	58.61	58.61	57.46	57.5	55789.0
2023-03-09	AIEQ	ETF	30.0	30.23	29.12	29.123	13400.0

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

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