PREVIEW / etf_daily / 2022-03-31

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-31.parquet
  size:    101 KB
  rows:    2,686

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-03-31	SPY	ETF	457.89	458.76	451.16	451.64	121699900.0
2022-03-31	QQQ	ETF	367.24	367.6	361.68	362.54	67011405.0
2022-03-31	IWM	ETF	207.13	208.91	205.15	205.27	26771600.0
2022-03-31	DIA	ETF	351.07	351.57	346.76	346.83	3978900.0
2022-03-31	GLD	ETF	180.91	181.96	180.56	180.65	9844400.0
2022-03-31	TLT	ETF	131.98	132.67	131.66	132.08	19901000.0
2022-03-31	AAA	ETF	24.86	24.86	24.8253	24.8253	101.0
2022-03-31	AAAU	ETF	19.26	19.36	19.22	19.23	724400.0
2022-03-31	AADR	ETF	60.18	60.18	60.0	60.0	2700.0
2022-03-31	AAXJ	ETF	76.04	76.06	75.02	75.03	1084500.0
2022-03-31	ABEQ	ETF	30.198	30.198	29.92	29.92	1400.0
2022-03-31	ACES	ETF	63.49	64.25	62.87	63.32	31400.0
2022-03-31	ACIO	ETF	31.735	31.75	31.45	31.48	22200.0
2022-03-31	ACSI	ETF	50.6631	50.6631	50.6631	50.6631	156.0
2022-03-31	ACT	ETF	22.3	23.14	22.15	22.25	106130.0
2022-03-31	ACTV	ETF	36.2	36.47	36.02	36.02	13096.0
2022-03-31	ACVF	ETF	34.35	34.35	33.889	33.889	3800.0
2022-03-31	ACWF	ETF	37.4275	37.4275	36.9153	36.9153	6472.0
2022-03-31	ACWI	ETF	101.11	101.29	99.78	99.78	5912300.0
2022-03-31	ACWV	ETF	105.36	105.75	104.72	104.82	83700.0
2022-03-31	ACWX	ETF	52.7	52.88	52.21	52.27	3257209.0
2022-03-31	ADFI	ETF	9.045	9.06	9.03	9.042	2200.0
2022-03-31	ADIV	ETF	15.509	15.509	15.509	15.509	100.0
2022-03-31	ADME	ETF	41.4	41.4	40.94	40.94	17300.0
2022-03-31	ADRE	ETF	44.36	44.6	44.03	44.03	25931.0
2022-03-31	AEMB	ETF	43.36	43.398	43.36	43.398	200.0
2022-03-31	AESR	ETF	13.58	13.59	13.43	13.44	13700.0
2022-03-31	AFIF	ETF	9.25	9.25	9.22	9.2316	20014.0
2022-03-31	AFK	ETF	21.56	21.56	21.25	21.25	7939.0
2022-03-31	AFLG	ETF	26.699	26.699	26.699	26.699	100.0
2022-03-31	AFMC	ETF	24.712	24.712	24.712	24.712	100.0
2022-03-31	AFSM	ETF	25.75	25.75	25.656	25.656	300.0
2022-03-31	AFTY	ETF	18.142	18.142	18.142	18.142	100.0
2022-03-31	AGG	ETF	107.17	107.38	107.06	107.1	13799100.0
2022-03-31	AGGH	ETF	24.76	24.76	24.4693	24.4693	699.0
2022-03-31	AGGY	ETF	47.89	47.967	47.832	47.85	87000.0
2022-03-31	AGNG	ETF	28.8	29.0	28.66	28.66	4200.0
2022-03-31	AGOV	ETF	82.88	84.86	82.88	83.1973	2144.0
2022-03-31	AGOX	ETF	24.12	24.21	23.86	23.86	26700.0
2022-03-31	AGQ	ETF	39.31	39.55	38.44	38.53	530300.0
2022-03-31	AGZ	ETF	112.44	112.52	112.3	112.3	32485.0
2022-03-31	AGZD	ETF	23.29	23.335	23.18	23.22	73800.0
2022-03-31	AHHX	ETF	9.4599	9.47	9.41	9.4334	4457.0
2022-03-31	AHYB	ETF	47.69	47.69	47.585	47.585	400.0
2022-03-31	AIA	ETF	69.78	69.78	68.49	68.63	39834.0
2022-03-31	AIEQ	ETF	37.176	37.33	36.884	36.884	10100.0
2022-03-31	AIQ	ETF	27.44	27.46	26.9788	27.01	13494.0
2022-03-31	AIRR	ETF	42.95	43.05	42.28	42.35	15700.0
2022-03-31	AIVI	ETF	40.42	40.46	40.11	40.11	1500.0
2022-03-31	AIVL	ETF	100.48	100.48	99.06	99.06	5700.0

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

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