PREVIEW / etf_daily / 2023-03-13

all etf daily files

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

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-13	SPY	ETF	381.81	390.39	380.65	385.36	157790000.0
2023-03-13	QQQ	ETF	286.73	294.47	285.19	290.69	97123603.0
2023-03-13	IWM	ETF	172.52	176.4	171.07	173.31	74171500.0
2023-03-13	DIA	ETF	316.76	323.17	316.66	318.82	6831600.0
2023-03-13	GLD	ETF	176.66	178.02	176.3	177.86	20554400.0
2023-03-13	TLT	ETF	108.2	109.1	105.04	105.83	51502500.0
2023-03-13	AAA	ETF	24.57	24.57	24.57	24.57	111.0
2023-03-13	AAAU	ETF	18.86	18.99	18.81	18.97	2859600.0
2023-03-13	AADR	ETF	46.91	46.91	46.5	46.55	500.0
2023-03-13	AAPB	ETF	18.93	19.9472	18.93	19.45	7850.0
2023-03-13	AAPD	ETF	26.55	26.55	25.61	26.0559	236626.0
2023-03-13	AAPU	ETF	19.95	20.97	19.95	20.46	84714.0
2023-03-13	AAXJ	ETF	64.57	65.37	64.54	65.02	997300.0
2023-03-13	ABEQ	ETF	26.79	27.211	26.79	27.08	15100.0
2023-03-13	ACES	ETF	44.37	45.76	44.01	45.185	35000.0
2023-03-13	ACIO	ETF	28.9	29.407	28.9	29.278	56500.0
2023-03-13	ACSI	ETF	41.7225	41.7225	41.7225	41.7225	17.0
2023-03-13	ACT	ETF	22.09	22.18	21.19	21.61	175571.0
2023-03-13	ACTV	ETF	29.06	29.275	28.9	28.9514	8605.0
2023-03-13	ACTX	ETF	0.321	0.321	0.321	0.321	200.0
2023-03-13	ACVF	ETF	29.95	30.01	29.5	29.71	8400.0
2023-03-13	ACWF	ETF	31.99	32.2	31.93	31.93	6922.0
2023-03-13	ACWI	ETF	85.51	87.05	85.31	86.14	5470000.0
2023-03-13	ACWV	ETF	92.25	93.61	92.25	92.7	320600.0
2023-03-13	ACWX	ETF	46.43	46.975	46.33	46.6	2343765.0
2023-03-13	ADFI	ETF	8.455	8.47	8.44	8.44	10100.0
2023-03-13	ADME	ETF	33.47	33.784	33.47	33.57	27800.0
2023-03-13	ADPV	ETF	23.091	23.31	22.94	23.1157	12843.0
2023-03-13	ADRE	ETF	37.67	38.23	37.67	37.94	3735.0
2023-03-13	AEMB	ETF	37.77	37.77	37.56	37.56	400.0
2023-03-13	AESR	ETF	11.35	11.4	11.3	11.35	10600.0
2023-03-13	AFIF	ETF	8.87	8.91	8.8151	8.8151	51138.0
2023-03-13	AFK	ETF	15.64	15.64	15.58	15.58	11518.0
2023-03-13	AFMC	ETF	22.4	22.4	22.28	22.28	600.0
2023-03-13	AFSM	ETF	22.62	22.62	22.61	22.61	300.0
2023-03-13	AFTY	ETF	15.99	16.099	15.99	16.099	1300.0
2023-03-13	AGG	ETF	99.05	99.65	98.62	98.87	10343900.0
2023-03-13	AGGH	ETF	22.88	22.9	22.86	22.9	2229.0
2023-03-13	AGGY	ETF	43.48	43.77	43.36	43.465	103800.0
2023-03-13	AGNG	ETF	25.681	25.681	25.681	25.681	100.0
2023-03-13	AGOV	ETF	75.015	75.015	75.015	75.015	1.0
2023-03-13	AGOX	ETF	20.5	20.9	20.47	20.59	55200.0
2023-03-13	AGQ	ETF	24.82	25.93	24.75	25.55	1446200.0
2023-03-13	AGZ	ETF	108.37	108.464	107.91	108.33	47039.0
2023-03-13	AGZD	ETF	21.695	21.735	21.495	21.665	64800.0
2023-03-13	AHHX	ETF	8.01	8.3762	8.01	8.3762	11049.0
2023-03-13	AHYB	ETF	42.888	43.17	42.783	42.783	1800.0
2023-03-13	AIA	ETF	57.54	58.235	57.52	57.96	37670.0
2023-03-13	AIEQ	ETF	27.92	28.62	27.56	28.26	33000.0
2023-03-13	AIQ	ETF	21.82	22.24	21.6001	22.01	28577.0

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

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