PREVIEW / etf_daily / 2023-03-28

all etf daily files

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

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-28	SPY	ETF	395.77	396.49	393.69	395.6	62871700.0
2023-03-28	QQQ	ETF	308.17	308.2	304.774	307.12	48585917.0
2023-03-28	IWM	ETF	173.1	174.51	172.69	173.45	28555100.0
2023-03-28	DIA	ETF	323.99	325.65	322.84	323.81	2536500.0
2023-03-28	GLD	ETF	182.31	183.62	182.12	183.44	6202600.0
2023-03-28	TLT	ETF	104.24	104.68	104.02	104.53	17794300.0
2023-03-28	AAA	ETF	24.535	24.535	24.535	24.535	4.0
2023-03-28	AAAU	ETF	19.46	19.59	19.43	19.57	2625400.0
2023-03-28	AADR	ETF	47.05	47.05	47.05	47.05	100.0
2023-03-28	AAPB	ETF	21.0	21.05	20.6375	21.05	4034.0
2023-03-28	AAPD	ETF	24.68	24.975	24.68	24.7217	170036.0
2023-03-28	AAPU	ETF	21.87	21.9	21.48	21.83	55852.0
2023-03-28	AAXJ	ETF	66.62	67.21	66.62	67.17	596500.0
2023-03-28	ABEQ	ETF	27.53	27.58	27.504	27.538	9600.0
2023-03-28	ACES	ETF	44.0	44.122	43.38	43.72	113900.0
2023-03-28	ACIO	ETF	29.42	29.64	29.42	29.61	77000.0
2023-03-28	ACSI	ETF	42.8564	42.8564	42.8564	42.8564	41.0
2023-03-28	ACT	ETF	22.54	22.7225	22.25	22.49	57966.0
2023-03-28	ACTV	ETF	28.37	28.8099	28.37	28.7315	13729.0
2023-03-28	ACTX	ETF	0.32	0.32	0.32	0.32	237.0
2023-03-28	ACVF	ETF	30.468	30.47	30.438	30.438	10100.0
2023-03-28	ACWF	ETF	32.62	32.68	32.581	32.6545	12318.0
2023-03-28	ACWI	ETF	88.39	88.54	88.06	88.45	6464300.0
2023-03-28	ACWV	ETF	95.15	95.49	95.13	95.34	200300.0
2023-03-28	ACWX	ETF	47.49	47.686	47.46	47.62	943408.0
2023-03-28	ADFI	ETF	8.43	8.45	8.4	8.429	16100.0
2023-03-28	ADIV	ETF	13.674	13.674	13.674	13.674	100.0
2023-03-28	ADME	ETF	33.72	33.779	33.714	33.74	9600.0
2023-03-28	ADPV	ETF	22.85	22.85	22.69	22.76	9046.0
2023-03-28	ADRE	ETF	38.14	38.22	38.08	38.14	11737.0
2023-03-28	AEMB	ETF	37.24	37.24	37.24	37.24	100.0
2023-03-28	AESR	ETF	11.65	11.67	11.59	11.635	14000.0
2023-03-28	AFIF	ETF	8.77	8.79	8.7349	8.7349	27814.0
2023-03-28	AFK	ETF	15.59	15.73	15.405	15.63	30745.0
2023-03-28	AFLG	ETF	23.26	23.26	23.26	23.26	100.0
2023-03-28	AFMC	ETF	22.46	22.49	22.46	22.49	200.0
2023-03-28	AFSM	ETF	22.748	22.748	22.748	22.748	100.0
2023-03-28	AFTY	ETF	16.131	16.141	16.131	16.141	700.0
2023-03-28	AGG	ETF	98.98	99.05	98.82	98.93	6356200.0
2023-03-28	AGGH	ETF	22.9	22.94	22.8717	22.8717	29177.0
2023-03-28	AGGY	ETF	43.38	43.42	43.34	43.37	51500.0
2023-03-28	AGNG	ETF	26.335	26.34	26.335	26.34	300.0
2023-03-28	AGOV	ETF	76.635	76.635	76.635	76.635	1.0
2023-03-28	AGOX	ETF	20.96	21.125	20.96	21.123	43500.0
2023-03-28	AGQ	ETF	28.57	29.49	28.48	29.37	573500.0
2023-03-28	AGZ	ETF	107.99	108.1	107.9517	108.0	23550.0
2023-03-28	AGZD	ETF	21.695	21.745	21.63	21.685	38200.0
2023-03-28	AHHX	ETF	8.32	8.364	8.31	8.3261	1661600.0
2023-03-28	AHYB	ETF	43.08	43.157	43.08	43.157	300.0
2023-03-28	AIA	ETF	60.77	61.35	60.74	61.35	36188.0

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

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