PREVIEW / etf_daily / 2022-12-05

all etf daily files

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

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
2022-12-05	SPY	ETF	403.95	404.93	398.17	399.59	77289800.0
2022-12-05	QQQ	ETF	290.38	291.68	286.15	287.64	41482121.0
2022-12-05	IWM	ETF	186.86	187.06	182.18	182.87	25449300.0
2022-12-05	DIA	ETF	342.45	343.31	339.03	340.03	3827200.0
2022-12-05	GLD	ETF	166.55	166.72	164.32	164.39	5436200.0
2022-12-05	TLT	ETF	105.84	105.99	104.9	105.59	20159700.0
2022-12-05	AAA	ETF	24.29	24.29	24.29	24.29	8.0
2022-12-05	AAAU	ETF	17.76	17.77	17.52	17.53	1256600.0
2022-12-05	AADR	ETF	48.82	48.82	48.82	48.82	200.0
2022-12-05	AAPB	ETF	20.28	20.28	19.2436	19.2436	985.0
2022-12-05	AAPD	ETF	26.79	27.1301	26.26	26.99	144689.0
2022-12-05	AAPU	ETF	20.47	21.1	20.11	20.265	38548.0
2022-12-05	AAXJ	ETF	67.11	67.14	66.23	66.39	763700.0
2022-12-05	ABEQ	ETF	28.32	28.33	28.102	28.166	1900.0
2022-12-05	ACES	ETF	55.25	55.25	54.17	54.37	43100.0
2022-12-05	ACIO	ETF	29.91	30.1	29.8	29.93	112900.0
2022-12-05	ACSI	ETF	44.6108	44.6108	44.6108	44.6108	15.0
2022-12-05	ACT	ETF	24.65	25.24	24.6	24.69	167363.0
2022-12-05	ACTV	ETF	30.76	30.76	30.435	30.435	4263.0
2022-12-05	ACTX	ETF	0.3	0.3	0.3	0.3	2278.0
2022-12-05	ACVF	ETF	31.3	31.3	30.84	30.88	5500.0
2022-12-05	ACWF	ETF	33.64	33.64	33.1848	33.1848	3014.0
2022-12-05	ACWI	ETF	89.2	89.39	87.91	88.19	16178500.0
2022-12-05	ACWV	ETF	98.21	98.28	97.51	97.77	172800.0
2022-12-05	ACWX	ETF	47.14	47.2	46.48	46.57	3040485.0
2022-12-05	ADFI	ETF	8.48	8.52	8.47	8.52	11400.0
2022-12-05	ADIV	ETF	13.058	13.058	13.058	13.058	100.0
2022-12-05	ADME	ETF	35.135	35.19	34.93	35.02	97200.0
2022-12-05	ADPV	ETF	25.09	25.1199	25.08	25.085	20369.0
2022-12-05	ADRE	ETF	39.51	39.51	39.12	39.18	80609.0
2022-12-05	AEMB	ETF	38.035	38.035	38.035	38.035	100.0
2022-12-05	AESR	ETF	11.98	11.985	11.86	11.89	18200.0
2022-12-05	AFIF	ETF	8.78	8.79	8.77	8.79	6892.0
2022-12-05	AFK	ETF	17.43	17.47	17.16	17.16	6467.0
2022-12-05	AFLG	ETF	24.272	24.272	24.19	24.22	800.0
2022-12-05	AFMC	ETF	23.0	23.026	23.0	23.026	100.0
2022-12-05	AFSM	ETF	23.5	23.529	23.5	23.529	200.0
2022-12-05	AFTY	ETF	15.875	15.9	15.84	15.859	2700.0
2022-12-05	AGG	ETF	98.82	99.29	98.3	98.51	8072500.0
2022-12-05	AGGH	ETF	22.68	22.68	22.68	22.68	1351.0
2022-12-05	AGGY	ETF	43.53	43.56	43.36	43.43	100300.0
2022-12-05	AGNG	ETF	26.8	26.8	26.55	26.55	700.0
2022-12-05	AGOV	ETF	81.1544	81.535	81.1544	81.535	1850.0
2022-12-05	AGOX	ETF	21.71	21.71	21.19	21.27	31700.0
2022-12-05	AGQ	ETF	29.03	29.13	27.6	27.71	1125200.0
2022-12-05	AGZ	ETF	107.13	107.16	106.58	106.85	23630.0
2022-12-05	AGZD	ETF	22.985	23.09	22.985	23.07	364200.0
2022-12-05	AHHX	ETF	8.6007	8.61	8.5	8.5404	13271.0
2022-12-05	AHYB	ETF	43.9	43.9	43.57	43.601	2200.0
2022-12-05	AIA	ETF	58.93	58.97	57.94	58.15	208063.0

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

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