PREVIEW / etf_daily / 2022-08-26

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-26.parquet
  size:    103 KB
  rows:    2,787

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-08-26	SPY	ETF	419.39	419.96	405.25	405.31	103087000.0
2022-08-26	QQQ	ETF	320.28	321.51	307.35	307.44	69047740.0
2022-08-26	IWM	ETF	195.34	195.44	188.66	188.98	24177200.0
2022-08-26	DIA	ETF	333.49	333.67	322.82	322.93	4191000.0
2022-08-26	GLD	ETF	163.12	163.61	161.55	161.76	6689300.0
2022-08-26	TLT	ETF	112.3	113.99	112.01	113.62	18764400.0
2022-08-26	AAA	ETF	24.41	24.43	24.41	24.43	206.0
2022-08-26	AAAU	ETF	17.39	17.43	17.21	17.24	3454100.0
2022-08-26	AADR	ETF	51.06	51.06	50.75	50.75	500.0
2022-08-26	AAPB	ETF	26.25	26.25	24.5019	24.57	4056.0
2022-08-26	AAPD	ETF	24.1	25.1022	24.1	25.1006	56693.0
2022-08-26	AAPU	ETF	26.14	26.14	24.6104	24.7	21584.0
2022-08-26	AAXJ	ETF	69.01	69.11	67.44	67.44	646400.0
2022-08-26	ABEQ	ETF	27.21	27.21	27.14	27.156	3500.0
2022-08-26	ACES	ETF	65.41	65.804	63.38	63.59	54100.0
2022-08-26	ACIO	ETF	30.69	30.968	30.35	30.35	32200.0
2022-08-26	ACSI	ETF	46.192	46.192	46.192	46.192	29.0
2022-08-26	ACT	ETF	26.55	26.56	25.99	26.16	94882.0
2022-08-26	ACTV	ETF	31.04	31.04	30.5999	30.5999	2758.0
2022-08-26	ACTX	ETF	0.5	0.5	0.5	0.5	1700.0
2022-08-26	ACVF	ETF	31.62	31.62	30.49	30.49	8100.0
2022-08-26	ACWF	ETF	33.58	33.59	32.68	32.68	32620.0
2022-08-26	ACWI	ETF	90.71	90.74	87.88	87.9	4202100.0
2022-08-26	ACWV	ETF	98.16	98.73	96.19	96.25	223600.0
2022-08-26	ACWX	ETF	46.2	46.25	45.02	45.04	2196037.0
2022-08-26	ADFI	ETF	8.63	8.63	8.58	8.585	13200.0
2022-08-26	ADIV	ETF	13.55	13.55	13.505	13.505	1300.0
2022-08-26	ADME	ETF	36.59	36.59	36.13	36.13	16400.0
2022-08-26	ADRE	ETF	41.29	41.29	39.9679	39.99	3920.0
2022-08-26	AEMB	ETF	38.44	38.539	38.44	38.539	600.0
2022-08-26	AESR	ETF	12.11	12.11	11.88	11.88	7100.0
2022-08-26	AFIF	ETF	8.93	8.94	8.92	8.925	11673.0
2022-08-26	AFK	ETF	17.59	17.6	17.13	17.2321	5213.0
2022-08-26	AFLG	ETF	24.4	24.4	24.121	24.121	300.0
2022-08-26	AFMC	ETF	22.818	22.818	22.818	22.818	100.0
2022-08-26	AFSM	ETF	24.01	24.01	23.82	23.82	100.0
2022-08-26	AFTY	ETF	17.01	17.01	16.929	16.929	200.0
2022-08-26	AGG	ETF	101.67	101.85	101.42	101.61	5584800.0
2022-08-26	AGGH	ETF	23.43	23.48	23.43	23.48	260.0
2022-08-26	AGGY	ETF	44.86	44.98	44.78	44.86	113300.0
2022-08-26	AGNG	ETF	25.376	25.376	25.115	25.118	800.0
2022-08-26	AGOV	ETF	82.3	82.45	82.3	82.4282	424.0
2022-08-26	AGOX	ETF	22.14	22.14	21.58	21.58	56300.0
2022-08-26	AGQ	ETF	21.64	21.81	20.44	20.51	1118100.0
2022-08-26	AGZ	ETF	109.37	109.57	109.37	109.56	17951.0
2022-08-26	AGZD	ETF	23.01	23.02	22.96	22.975	42600.0
2022-08-26	AHHX	ETF	8.83	8.83	8.6845	8.6856	5599.0
2022-08-26	AHYB	ETF	44.289	44.319	43.999	43.999	800.0
2022-08-26	AIA	ETF	61.56	61.58	59.62	59.66	536992.0
2022-08-26	AIEQ	ETF	35.92	35.92	34.699	34.74	5900.0

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

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