PREVIEW / etf_daily / 2022-09-30

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-30.parquet
  size:    105 KB
  rows:    2,826

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-09-30	SPY	ETF	361.8	365.91	357.04	357.18	153711200.0
2022-09-30	QQQ	ETF	271.03	275.19	267.1	267.26	78482378.0
2022-09-30	IWM	ETF	165.78	169.52	164.87	164.92	40643800.0
2022-09-30	DIA	ETF	291.21	293.46	287.04	287.3	3827200.0
2022-09-30	GLD	ETF	154.94	156.04	154.57	154.67	6832400.0
2022-09-30	TLT	ETF	104.27	104.86	102.23	102.45	26485700.0
2022-09-30	AAA	ETF	24.205	24.205	24.205	24.205	112.0
2022-09-30	AAAU	ETF	16.52	16.63	16.48	16.5	347200.0
2022-09-30	AADR	ETF	43.92	44.31	43.92	44.03	1600.0
2022-09-30	AAPB	ETF	18.59	18.91	17.9649	17.9649	8293.0
2022-09-30	AAPD	ETF	28.86	29.49	28.4825	29.49	221790.0
2022-09-30	AAPU	ETF	19.51	19.86	18.87	18.96	54766.0
2022-09-30	AAXJ	ETF	58.76	59.25	58.53	58.53	1708500.0
2022-09-30	ABEQ	ETF	25.26	25.43	25.136	25.136	9500.0
2022-09-30	ACES	ETF	55.59	57.14	55.094	55.5	136800.0
2022-09-30	ACIO	ETF	28.23	28.396	28.09	28.1	177700.0
2022-09-30	ACSI	ETF	41.192	41.192	41.192	41.192	28.0
2022-09-30	ACT	ETF	22.25	22.47	21.955	22.17	304146.0
2022-09-30	ACTV	ETF	26.9923	27.08	26.59	26.61	68684.0
2022-09-30	ACTX	ETF	0.5891	0.5891	0.549	0.549	800.0
2022-09-30	ACVF	ETF	27.46	27.46	26.997	26.997	2100.0
2022-09-30	ACWF	ETF	29.4	29.4	29.1966	29.1966	896.0
2022-09-30	ACWI	ETF	78.41	79.33	77.77	77.83	4633100.0
2022-09-30	ACWV	ETF	89.64	89.98	88.56	88.56	231100.0
2022-09-30	ACWX	ETF	39.99	40.47	39.94	40.01	2950629.0
2022-09-30	ADFI	ETF	8.215	8.22	8.185	8.185	3100.0
2022-09-30	ADIV	ETF	11.81	11.81	11.753	11.753	400.0
2022-09-30	ADME	ETF	33.34	33.38	33.24	33.32	123100.0
2022-09-30	ADRE	ETF	34.43	34.94	34.43	34.62	4590.0
2022-09-30	AEMB	ETF	35.67	35.67	35.49	35.655	2500.0
2022-09-30	AESR	ETF	10.78	10.78	10.55	10.55	19100.0
2022-09-30	AFIF	ETF	8.67	8.68	8.635	8.635	65054.0
2022-09-30	AFK	ETF	15.05	15.1999	15.0	15.07	11198.0
2022-09-30	AFLG	ETF	21.55	21.55	21.421	21.421	300.0
2022-09-30	AFMC	ETF	20.22	20.22	20.115	20.115	100.0
2022-09-30	AFSM	ETF	20.91	20.91	20.805	20.805	100.0
2022-09-30	AFTY	ETF	15.505	15.505	15.505	15.505	100.0
2022-09-30	AGG	ETF	96.86	97.09	96.19	96.34	14376300.0
2022-09-30	AGGH	ETF	22.83	22.8498	22.76	22.8498	2012.0
2022-09-30	AGGY	ETF	42.52	42.52	42.172	42.22	248000.0
2022-09-30	AGNG	ETF	23.57	23.57	23.49	23.49	600.0
2022-09-30	AGOV	ETF	77.1535	77.9255	77.1535	77.5726	2606.0
2022-09-30	AGOX	ETF	19.46	19.56	19.18	19.183	79300.0
2022-09-30	AGQ	ETF	20.53	21.4	20.48	20.76	1605000.0
2022-09-30	AGZ	ETF	106.87	106.87	106.4546	106.5	18385.0
2022-09-30	AGZD	ETF	22.795	22.8	22.78	22.79	21800.0
2022-09-30	AHHX	ETF	8.125	8.16	8.07	8.0863	6743.0
2022-09-30	AHYB	ETF	42.029	42.029	41.617	41.617	200.0
2022-09-30	AIA	ETF	50.07	50.56	49.92	49.92	78994.0
2022-09-30	AIEQ	ETF	28.955	29.518	28.955	28.961	4400.0

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

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