PREVIEW / etf_daily / 2023-05-16

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-16.parquet
  size:    109 KB
  rows:    2,968

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-16	SPY	ETF	411.86	412.82	410.24	410.25	57705500.0
2023-05-16	QQQ	ETF	326.06	328.9025	326.02	327.16	40019151.0
2023-05-16	IWM	ETF	173.61	174.81	172.23	172.28	24212900.0
2023-05-16	DIA	ETF	332.71	333.07	330.28	330.35	2265200.0
2023-05-16	GLD	ETF	186.58	186.82	184.46	184.87	9519500.0
2023-05-16	TLT	ETF	102.4	102.9	102.11	102.88	29251700.0
2023-05-16	AAA	ETF	24.59	24.59	24.59	24.59	111.0
2023-05-16	AAAU	ETF	19.92	19.93	19.69	19.73	1144800.0
2023-05-16	AADR	ETF	47.7	47.7	47.39	47.48	1500.0
2023-05-16	AAPB	ETF	24.31	24.31	24.09	24.17	8743.0
2023-05-16	AAPD	ETF	22.69	22.72	22.56	22.68	59112.0
2023-05-16	AAPU	ETF	24.65	24.89	24.63	24.7	50396.0
2023-05-16	AAXJ	ETF	66.29	66.31	65.98	66.09	344000.0
2023-05-16	ABEQ	ETF	28.425	28.44	28.352	28.352	25700.0
2023-05-16	ACES	ETF	43.11	43.18	42.15	42.22	57100.0
2023-05-16	ACIO	ETF	29.89	30.055	29.89	29.94	56700.0
2023-05-16	ACSI	ETF	43.45	43.4501	43.4475	43.4475	1058.0
2023-05-16	ACT	ETF	23.73	24.005	23.63	23.68	244016.0
2023-05-16	ACTV	ETF	28.79	28.79	28.5	28.5079	2198.0
2023-05-16	ACVF	ETF	31.26	31.26	31.025	31.025	1300.0
2023-05-16	ACWF	ETF	33.985	33.985	33.8	33.8	8287.0
2023-05-16	ACWI	ETF	91.97	92.14	91.58	91.59	3550100.0
2023-05-16	ACWV	ETF	99.47	99.68	99.01	99.04	2371100.0
2023-05-16	ACWX	ETF	49.51	49.62	49.28	49.32	677536.0
2023-05-16	ADFI	ETF	8.44	8.45	8.44	8.45	31400.0
2023-05-16	ADIV	ETF	13.52	13.52	13.52	13.52	200.0
2023-05-16	ADME	ETF	34.66	34.695	34.55	34.55	86500.0
2023-05-16	ADPV	ETF	23.2	23.2	23.0585	23.0585	417.0
2023-05-16	AEMB	ETF	37.2	37.26	37.2	37.26	500.0
2023-05-16	AESR	ETF	11.999	12.01	11.96	11.96	47200.0
2023-05-16	AFIF	ETF	8.79	8.81	8.76	8.77	22969.0
2023-05-16	AFK	ETF	15.33	15.33	15.0	15.1156	3584.0
2023-05-16	AFLG	ETF	23.646	23.646	23.646	23.646	100.0
2023-05-16	AFMC	ETF	22.65	22.65	22.548	22.548	800.0
2023-05-16	AFSM	ETF	22.522	22.54	22.483	22.483	300.0
2023-05-16	AFTY	ETF	15.94	15.94	15.86	15.86	700.0
2023-05-16	AGG	ETF	98.89	98.95	98.74	98.91	6728500.0
2023-05-16	AGGH	ETF	22.98	22.98	22.92	22.92	876.0
2023-05-16	AGGY	ETF	43.46	43.51	43.42	43.47	89500.0
2023-05-16	AGNG	ETF	28.34	28.34	28.09	28.09	3100.0
2023-05-16	AGOV	ETF	76.8	79.82	75.62	75.62	1258.0
2023-05-16	AGOX	ETF	21.51	21.72	21.51	21.585	12400.0
2023-05-16	AGQ	ETF	30.37	30.65	29.55	29.85	800000.0
2023-05-16	AGZ	ETF	108.34	108.39	108.2781	108.37	11703.0
2023-05-16	AGZD	ETF	21.68	21.76	21.68	21.75	26000.0
2023-05-16	AHYB	ETF	43.5	43.5	43.363	43.363	800.0
2023-05-16	AIA	ETF	58.44	58.79	58.44	58.72	11167.0
2023-05-16	AIEQ	ETF	27.81	27.86	27.324	27.48	20300.0
2023-05-16	AIQ	ETF	24.1	24.3	24.05	24.22	313383.0
2023-05-16	AIRR	ETF	47.35	47.35	46.81	46.88	12200.0

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

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