PREVIEW / etf_daily / 2023-03-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-01.parquet
  size:    109 KB
  rows:    2,948

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-01	SPY	ETF	395.41	396.69	393.38	394.74	99706800.0
2023-03-01	QQQ	ETF	293.26	293.93	290.2	291.2	58286972.0
2023-03-01	IWM	ETF	188.19	189.49	187.19	188.42	22532800.0
2023-03-01	DIA	ETF	326.04	327.82	325.3	327.0	3317500.0
2023-03-01	GLD	ETF	170.95	171.49	170.47	170.76	6590500.0
2023-03-01	TLT	ETF	100.82	101.03	99.96	100.37	19000000.0
2023-03-01	AAA	ETF	24.52	24.52	24.52	24.52	125.0
2023-03-01	AAAU	ETF	18.24	18.3	18.2	18.22	448000.0
2023-03-01	AADR	ETF	49.04	49.04	49.01	49.01	300.0
2023-03-01	AAPB	ETF	18.62	18.75	18.37	18.37	1727.0
2023-03-01	AAPD	ETF	26.78	27.0359	26.6481	27.0	87411.0
2023-03-01	AAPU	ETF	19.77	19.85	19.46	19.47	51641.0
2023-03-01	AAXJ	ETF	67.25	67.28	66.79	66.87	1608300.0
2023-03-01	ABEQ	ETF	27.753	27.85	27.71	27.793	12300.0
2023-03-01	ACES	ETF	48.39	48.697	47.74	47.989	10400.0
2023-03-01	ACIO	ETF	29.52	29.52	29.3	29.36	47600.0
2023-03-01	ACSI	ETF	43.82	43.82	43.7671	43.7671	436.0
2023-03-01	ACT	ETF	24.23	24.61	24.105	24.28	69511.0
2023-03-01	ACTV	ETF	31.49	31.6	31.4199	31.53	16366.0
2023-03-01	ACTX	ETF	0.32	0.44	0.32	0.43	850.0
2023-03-01	ACVF	ETF	30.73	30.73	30.46	30.574	2300.0
2023-03-01	ACWI	ETF	88.53	88.81	88.13	88.41	3307700.0
2023-03-01	ACWV	ETF	93.18	93.36	92.83	93.1	128400.0
2023-03-01	ACWX	ETF	47.95	48.01	47.67	47.81	1145359.0
2023-03-01	ADFI	ETF	8.34	8.38	8.34	8.365	17500.0
2023-03-01	ADIV	ETF	13.99	13.99	13.99	13.99	100.0
2023-03-01	ADME	ETF	33.78	33.78	33.59	33.62	31100.0
2023-03-01	ADPV	ETF	25.27	25.35	25.21	25.25	13878.0
2023-03-01	ADRE	ETF	39.71	39.71	39.227	39.39	3567.0
2023-03-01	AEMB	ETF	37.32	37.32	37.32	37.32	100.0
2023-03-01	AESR	ETF	11.45	11.48	11.43	11.47	17000.0
2023-03-01	AFIF	ETF	8.81	8.83	8.7901	8.8253	23108.0
2023-03-01	AFK	ETF	16.56	16.56	16.35	16.5	134942.0
2023-03-01	AFLG	ETF	23.689	23.689	23.689	23.689	100.0
2023-03-01	AFMC	ETF	23.841	23.841	23.841	23.841	100.0
2023-03-01	AFSM	ETF	24.527	24.527	24.527	24.527	100.0
2023-03-01	AFTY	ETF	16.79	16.79	16.73	16.73	600.0
2023-03-01	AGG	ETF	96.83	97.04	96.5	96.52	9125300.0
2023-03-01	AGGH	ETF	21.83	21.83	21.83	21.83	1217.0
2023-03-01	AGGY	ETF	42.68	42.68	42.52	42.565	106900.0
2023-03-01	AGNG	ETF	26.14	26.141	26.06	26.141	3000.0
2023-03-01	AGOV	ETF	74.85	74.85	74.85	74.85	73.0
2023-03-01	AGOX	ETF	21.66	21.69	21.595	21.62	8400.0
2023-03-01	AGQ	ETF	23.8	24.33	23.72	23.82	792500.0
2023-03-01	AGRH	ETF	25.63	25.63	25.585	25.585	121.0
2023-03-01	AGZ	ETF	106.2	106.23	106.05	106.05	31338.0
2023-03-01	AGZD	ETF	21.95	21.96	21.87	21.945	101200.0
2023-03-01	AHHX	ETF	8.495	8.51	8.475	8.48	12261.0
2023-03-01	AHYB	ETF	43.13	43.13	43.13	43.13	100.0
2023-03-01	AIA	ETF	60.58	60.63	60.0	60.21	165293.0

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

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