PREVIEW / etf_daily / 2022-08-23

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-23.parquet
  size:    102 KB
  rows:    2,746

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-23	SPY	ETF	412.9	415.42	411.77	412.35	49105200.0
2022-08-23	QQQ	ETF	314.12	317.0	313.33	314.1	39497074.0
2022-08-23	IWM	ETF	190.94	192.93	190.39	190.95	20069800.0
2022-08-23	DIA	ETF	330.31	331.45	328.64	329.11	2897200.0
2022-08-23	GLD	ETF	161.96	163.43	161.91	162.77	4425100.0
2022-08-23	TLT	ETF	112.19	113.48	111.74	112.04	17813200.0
2022-08-23	AAA	ETF	24.4599	24.46	24.43	24.43	445.0
2022-08-23	AAAU	ETF	17.26	17.42	17.26	17.35	5518900.0
2022-08-23	AADR	ETF	51.19	51.21	50.86	51.21	1700.0
2022-08-23	AAPB	ETF	25.62	25.68	25.4956	25.4956	1739.0
2022-08-23	AAPD	ETF	24.62	24.77	24.41	24.65	108772.0
2022-08-23	AAPU	ETF	25.4	25.69	25.36	25.46	12754.0
2022-08-23	AAXJ	ETF	66.81	67.22	66.59	66.94	679100.0
2022-08-23	ABEQ	ETF	27.46	27.46	27.304	27.304	2200.0
2022-08-23	ACES	ETF	61.72	62.61	61.57	61.97	23200.0
2022-08-23	ACIO	ETF	30.87	30.87	30.679	30.71	18000.0
2022-08-23	ACSI	ETF	46.7175	46.7175	46.7175	46.7175	21.0
2022-08-23	ACT	ETF	26.26	26.43	26.04	26.27	84290.0
2022-08-23	ACTV	ETF	31.29	31.37	31.014	31.014	5546.0
2022-08-23	ACTX	ETF	0.65	0.65	0.63	0.63	640.0
2022-08-23	ACVF	ETF	31.09	31.16	31.0	31.013	5500.0
2022-08-23	ACWF	ETF	33.14	33.14	32.975	33.03	44590.0
2022-08-23	ACWI	ETF	88.99	89.69	88.93	89.05	2482700.0
2022-08-23	ACWV	ETF	98.14	98.23	97.53	97.67	74600.0
2022-08-23	ACWX	ETF	45.33	45.7	45.23	45.42	1455918.0
2022-08-23	ADFI	ETF	8.48	8.635	8.48	8.635	8500.0
2022-08-23	ADIV	ETF	13.47	13.47	13.465	13.465	200.0
2022-08-23	ADME	ETF	36.63	36.67	36.59	36.592	8000.0
2022-08-23	ADRE	ETF	39.06	39.485	39.06	39.42	2913.0
2022-08-23	AEMB	ETF	38.36	38.625	38.36	38.625	100.0
2022-08-23	AESR	ETF	12.08	12.1	12.03	12.08	12400.0
2022-08-23	AFIF	ETF	8.96	8.9699	8.955	8.9699	28679.0
2022-08-23	AFK	ETF	17.17	17.3528	16.97	17.34	4699.0
2022-08-23	AFLG	ETF	24.43	24.452	24.43	24.452	200.0
2022-08-23	AFMC	ETF	23.02	23.02	23.02	23.02	100.0
2022-08-23	AFSM	ETF	24.137	24.137	24.137	24.137	100.0
2022-08-23	AFTY	ETF	17.152	17.152	17.152	17.152	100.0
2022-08-23	AGG	ETF	101.54	101.97	101.4	101.51	7369600.0
2022-08-23	AGGY	ETF	44.85	45.081	44.83	44.88	70300.0
2022-08-23	AGNG	ETF	25.33	25.33	25.33	25.33	300.0
2022-08-23	AGOV	ETF	82.0	82.2015	82.0	82.2015	647.0
2022-08-23	AGOX	ETF	21.92	21.92	21.83	21.841	8200.0
2022-08-23	AGQ	ETF	20.66	21.53	20.63	21.16	774700.0
2022-08-23	AGZ	ETF	109.7154	109.82	109.56	109.58	7085.0
2022-08-23	AGZD	ETF	22.995	23.04	22.975	23.01	48800.0
2022-08-23	AHHX	ETF	8.73	8.7651	8.72	8.7511	3328.0
2022-08-23	AHYB	ETF	44.24	44.274	44.24	44.267	400.0
2022-08-23	AIA	ETF	58.38	58.76	58.28	58.66	48483.0
2022-08-23	AIEQ	ETF	35.02	35.12	34.93	34.94	3500.0
2022-08-23	AIQ	ETF	22.18	22.5	22.17	22.27	35657.0

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

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