PREVIEW / etf_daily / 2022-04-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-01.parquet
  size:    101 KB
  rows:    2,683

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-04-01	SPY	ETF	453.31	453.46	449.14	452.92	89048800.0
2022-04-01	QQQ	ETF	362.81	363.61	358.59	361.85	54527761.0
2022-04-01	IWM	ETF	206.18	207.72	205.01	207.57	25948500.0
2022-04-01	DIA	ETF	348.15	348.35	345.24	348.01	3560200.0
2022-04-01	GLD	ETF	179.55	180.46	178.98	179.5	13034400.0
2022-04-01	TLT	ETF	130.01	132.96	129.71	132.38	23489700.0
2022-04-01	AAA	ETF	24.77	24.78	24.77	24.775	29944.0
2022-04-01	AAAU	ETF	19.13	19.2	19.06	19.11	1559900.0
2022-04-01	AADR	ETF	60.24	60.38	59.71	60.38	1300.0
2022-04-01	AAXJ	ETF	76.55	76.84	75.91	76.3	3402200.0
2022-04-01	ABEQ	ETF	30.0	30.163	29.96	30.163	14500.0
2022-04-01	ACES	ETF	63.5	63.9	62.487	63.07	106300.0
2022-04-01	ACIO	ETF	31.481	31.518	31.33	31.491	33200.0
2022-04-01	ACSI	ETF	50.5486	50.5486	50.5486	50.5486	82.0
2022-04-01	ACT	ETF	22.42	22.68	22.05	22.29	60004.0
2022-04-01	ACTV	ETF	36.42	36.42	35.955	36.1837	14383.0
2022-04-01	ACVF	ETF	33.89	33.905	33.75	33.903	3800.0
2022-04-01	ACWF	ETF	37.19	37.19	36.751	37.0105	7043.0
2022-04-01	ACWI	ETF	100.49	100.53	99.66	100.43	3450700.0
2022-04-01	ACWV	ETF	105.38	105.81	104.84	105.7	155500.0
2022-04-01	ACWX	ETF	52.71	52.845	52.44	52.78	2231657.0
2022-04-01	ADFI	ETF	8.995	9.05	8.98	9.025	12000.0
2022-04-01	ADIV	ETF	15.698	15.698	15.698	15.698	200.0
2022-04-01	ADME	ETF	41.19	41.19	40.8	40.92	28200.0
2022-04-01	ADRE	ETF	45.56	45.56	44.45	44.53	4015.0
2022-04-01	AEMB	ETF	43.08	43.475	42.99	43.475	2100.0
2022-04-01	AESR	ETF	13.4	13.4	13.31	13.37	37100.0
2022-04-01	AFIF	ETF	9.19	9.22	9.19	9.22	57448.0
2022-04-01	AFK	ETF	21.75	21.75	21.42	21.56	6553.0
2022-04-01	AFLG	ETF	26.52	26.72	26.52	26.72	300.0
2022-04-01	AFMC	ETF	24.63	24.791	24.63	24.791	200.0
2022-04-01	AFSM	ETF	25.78	25.876	25.65	25.876	900.0
2022-04-01	AFTY	ETF	18.602	18.602	18.53	18.57	1600.0
2022-04-01	AGG	ETF	106.35	106.95	106.25	106.75	11581600.0
2022-04-01	AGGY	ETF	47.58	47.84	47.55	47.81	93400.0
2022-04-01	AGNG	ETF	28.59	28.96	28.42	28.96	8900.0
2022-04-01	AGOV	ETF	83.55	84.525	83.55	84.143	4776.0
2022-04-01	AGOX	ETF	23.981	24.001	23.762	23.902	21200.0
2022-04-01	AGQ	ETF	37.4	38.45	37.35	37.78	629000.0
2022-04-01	AGZ	ETF	111.8	112.09	111.78	111.87	28200.0
2022-04-01	AGZD	ETF	23.285	23.315	23.23	23.29	380400.0
2022-04-01	AHHX	ETF	9.49	9.53	9.4599	9.4599	6956.0
2022-04-01	AHYB	ETF	47.3	47.375	47.3	47.375	500.0
2022-04-01	AIA	ETF	70.14	70.42	69.2422	69.59	39785.0
2022-04-01	AIEQ	ETF	37.066	37.066	36.682	36.89	13600.0
2022-04-01	AIQ	ETF	27.17	27.221	26.88	27.04	414149.0
2022-04-01	AIRR	ETF	42.5	42.67	42.192	42.67	16800.0
2022-04-01	AIVI	ETF	40.37	40.49	40.24	40.49	9800.0
2022-04-01	AIVL	ETF	99.38	99.98	99.01	99.98	14200.0
2022-04-01	ALTL	ETF	45.13	45.13	44.2737	44.72	101548.0

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

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