PREVIEW / etf_daily / 2022-11-30

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-30.parquet
  size:    108 KB
  rows:    2,879

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-11-30	SPY	ETF	395.49	407.68	393.48	407.68	144566700.0
2022-11-30	QQQ	ETF	280.84	293.47	279.97	293.36	74718088.0
2022-11-30	IWM	ETF	182.67	187.43	180.8	187.37	28030100.0
2022-11-30	DIA	ETF	338.65	346.19	336.18	346.15	6940400.0
2022-11-30	GLD	ETF	163.69	164.81	162.4	164.81	4874700.0
2022-11-30	TLT	ETF	101.62	102.73	101.37	102.73	21581700.0
2022-11-30	AAA	ETF	24.38	24.38	24.38	24.38	1.0
2022-11-30	AAAU	ETF	17.44	17.57	17.32	17.56	3784900.0
2022-11-30	AADR	ETF	49.43	50.13	49.43	50.13	900.0
2022-11-30	AAPB	ETF	18.08	19.518	18.02	19.518	3566.0
2022-11-30	AAPD	ETF	28.09	28.2083	26.72	26.72	450370.0
2022-11-30	AAPU	ETF	19.23	20.58	19.1	20.58	77652.0
2022-11-30	AAXJ	ETF	66.08	66.83	65.67	66.7	1378300.0
2022-11-30	ABEQ	ETF	28.3	28.53	28.05	28.528	34500.0
2022-11-30	ACES	ETF	53.48	55.8	53.234	55.8	44900.0
2022-11-30	ACIO	ETF	29.69	30.35	29.65	30.35	64200.0
2022-11-30	ACSI	ETF	45.6347	45.6347	45.6347	45.6347	46.0
2022-11-30	ACT	ETF	24.31	24.94	24.02	24.8	261974.0
2022-11-30	ACTV	ETF	30.07	30.821	29.77	30.821	7292.0
2022-11-30	ACTX	ETF	0.43	0.43	0.43	0.43	204.0
2022-11-30	ACVF	ETF	30.72	31.45	30.49	31.448	7100.0
2022-11-30	ACWF	ETF	33.28	33.92	33.15	33.92	11192.0
2022-11-30	ACWI	ETF	87.64	89.67	87.07	89.67	6897400.0
2022-11-30	ACWV	ETF	96.98	98.87	96.89	98.79	92500.0
2022-11-30	ACWX	ETF	46.5	47.12	46.115	46.96	4130064.0
2022-11-30	ADFI	ETF	8.375	8.45	8.375	8.45	8800.0
2022-11-30	ADIV	ETF	13.297	13.297	13.297	13.297	100.0
2022-11-30	ADME	ETF	34.796	35.44	34.73	35.44	47500.0
2022-11-30	ADPV	ETF	25.08	25.095	25.08	25.095	19490.0
2022-11-30	ADRE	ETF	38.62	39.71	38.62	39.71	56896.0
2022-11-30	AEMB	ETF	38.155	38.155	38.155	38.155	100.0
2022-11-30	AESR	ETF	11.76	12.12	11.76	12.12	28700.0
2022-11-30	AFIF	ETF	8.77	8.79	8.74	8.78	6649.0
2022-11-30	AFK	ETF	17.6	17.6	17.19	17.51	8726.0
2022-11-30	AFLG	ETF	24.06	24.67	24.02	24.67	2100.0
2022-11-30	AFMC	ETF	22.99	23.567	22.99	23.567	500.0
2022-11-30	AFSM	ETF	23.76	24.238	23.72	24.238	300.0
2022-11-30	AFTY	ETF	15.505	15.59	15.505	15.58	700.0
2022-11-30	AGG	ETF	97.48	98.32	97.29	98.29	8963500.0
2022-11-30	AGGY	ETF	42.75	43.1	42.685	43.1	146600.0
2022-11-30	AGNG	ETF	26.01	26.59	25.96	26.59	1700.0
2022-11-30	AGOV	ETF	80.0	81.86	80.0	81.555	10618.0
2022-11-30	AGOX	ETF	21.21	21.69	21.07	21.683	10300.0
2022-11-30	AGQ	ETF	26.97	27.79	26.05	27.78	1646800.0
2022-11-30	AGZ	ETF	106.55	107.24	106.45	107.24	18636.0
2022-11-30	AGZD	ETF	23.015	23.05	22.97	23.005	151000.0
2022-11-30	AHHX	ETF	8.4831	8.6278	8.47	8.6278	5061.0
2022-11-30	AHYB	ETF	43.382	44.002	43.382	44.002	800.0
2022-11-30	AIA	ETF	57.17	58.4106	57.17	58.2	61803.0
2022-11-30	AIEQ	ETF	30.62	31.285	30.336	31.27	22500.0

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

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