PREVIEW / etf_daily / 2023-05-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-12.parquet
  size:    108 KB
  rows:    2,943

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-05-12	SPY	ETF	413.42	413.64	409.07	411.59	70439400.0
2023-05-12	QQQ	ETF	326.74	327.17	322.94	325.03	48432836.0
2023-05-12	IWM	ETF	173.65	174.21	171.65	172.72	20396400.0
2023-05-12	DIA	ETF	334.42	334.45	331.31	333.2	2635300.0
2023-05-12	GLD	ETF	187.43	187.92	186.58	186.81	7084400.0
2023-05-12	TLT	ETF	105.05	105.25	104.25	104.27	14195900.0
2023-05-12	AAA	ETF	24.5899	24.5899	24.55	24.55	1480.0
2023-05-12	AAAU	ETF	20.01	20.05	19.92	19.94	461400.0
2023-05-12	AADR	ETF	47.66	47.66	47.13	47.13	3900.0
2023-05-12	AAPB	ETF	24.2467	24.27	23.9215	24.255	6011.0
2023-05-12	AAPD	ETF	22.49	22.8107	22.43	22.64	132575.0
2023-05-12	AAPU	ETF	25.05	25.07	24.48	24.8	38497.0
2023-05-12	AAXJ	ETF	65.63	65.63	65.03	65.16	588000.0
2023-05-12	ABEQ	ETF	28.45	28.49	28.41	28.49	14100.0
2023-05-12	ACES	ETF	42.66	43.52	42.34	42.691	171100.0
2023-05-12	ACIO	ETF	30.1	30.115	29.96	30.07	101600.0
2023-05-12	ACSI	ETF	43.729	43.729	43.729	43.729	20.0
2023-05-12	ACT	ETF	23.87	23.9	23.65	23.8	406305.0
2023-05-12	ACTV	ETF	28.62	28.63	28.35	28.4978	23984.0
2023-05-12	ACVF	ETF	31.29	31.31	30.93	31.103	3200.0
2023-05-12	ACWF	ETF	33.9	33.9	33.69	33.8454	3212.0
2023-05-12	ACWI	ETF	92.08	92.12	91.26	91.7	1265300.0
2023-05-12	ACWV	ETF	99.69	99.9	99.26	99.59	64700.0
2023-05-12	ACWX	ETF	49.51	49.51	49.1	49.25	1132334.0
2023-05-12	ADFI	ETF	8.53	8.53	8.5	8.515	17500.0
2023-05-12	ADIV	ETF	13.41	13.41	13.41	13.41	100.0
2023-05-12	ADME	ETF	34.7	34.735	34.6	34.735	6100.0
2023-05-12	ADPV	ETF	23.36	23.3601	23.17	23.2401	768.0
2023-05-12	AEMB	ETF	37.555	37.555	37.555	37.555	100.0
2023-05-12	AESR	ETF	12.04	12.04	11.98	12.04	13800.0
2023-05-12	AFIF	ETF	8.82	8.86	8.81	8.8101	11456.0
2023-05-12	AFK	ETF	15.16	15.16	15.02	15.04	4993.0
2023-05-12	AFLG	ETF	23.741	23.741	23.741	23.741	100.0
2023-05-12	AFMC	ETF	22.58	22.652	22.58	22.652	300.0
2023-05-12	AFSM	ETF	22.54	22.54	22.397	22.53	4200.0
2023-05-12	AFTY	ETF	15.78	15.78	15.714	15.714	1700.0
2023-05-12	AGG	ETF	99.89	99.95	99.39	99.39	4285900.0
2023-05-12	AGGH	ETF	23.13	23.13	23.03	23.0628	13733.0
2023-05-12	AGGY	ETF	43.89	43.92	43.69	43.695	114200.0
2023-05-12	AGNG	ETF	28.42	28.875	28.268	28.34	3900.0
2023-05-12	AGOV	ETF	74.42	74.42	74.42	74.42	101.0
2023-05-12	AGOX	ETF	21.74	21.74	21.36	21.504	19800.0
2023-05-12	AGQ	ETF	30.57	30.9	30.14	30.4	1029600.0
2023-05-12	AGZ	ETF	108.78	108.78	108.54	108.54	15871.0
2023-05-12	AGZD	ETF	21.755	21.775	21.675	21.775	27000.0
2023-05-12	AHYB	ETF	43.59	43.63	43.59	43.63	700.0
2023-05-12	AIA	ETF	57.59	57.6	56.98	57.21	135345.0
2023-05-12	AIEQ	ETF	27.82	27.88	27.01	27.198	14400.0
2023-05-12	AIQ	ETF	23.96	23.97	23.6225	23.76	42520.0
2023-05-12	AIRR	ETF	46.89	47.64	46.786	47.03	23500.0

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

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