PREVIEW / etf_daily / 2022-03-24

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-24.parquet
  size:    100 KB
  rows:    2,676

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-24	SPY	ETF	445.94	450.5	444.76	450.49	64736900.0
2022-03-24	QQQ	ETF	353.8	359.7	351.5939	359.65	53555251.0
2022-03-24	IWM	ETF	204.38	205.9	202.73	205.84	19781200.0
2022-03-24	DIA	ETF	344.49	347.06	343.44	347.06	3550000.0
2022-03-24	GLD	ETF	182.35	183.51	181.77	183.13	10970100.0
2022-03-24	TLT	ETF	129.65	131.18	129.6	130.47	17141600.0
2022-03-24	AAA	ETF	24.785	24.785	24.785	24.785	1.0
2022-03-24	AAAU	ETF	19.42	19.54	19.36	19.5	451900.0
2022-03-24	AADR	ETF	59.36	59.59	58.97	59.56	49700.0
2022-03-24	AAXJ	ETF	75.69	75.93	75.21	75.91	964000.0
2022-03-24	ABEQ	ETF	29.76	29.81	29.71	29.81	21300.0
2022-03-24	ACES	ETF	62.25	63.08	61.259	63.05	67500.0
2022-03-24	ACIO	ETF	31.095	31.34	29.48	31.32	17600.0
2022-03-24	ACSI	ETF	50.4171	50.4171	50.4171	50.4171	141.0
2022-03-24	ACT	ETF	22.05	22.51	22.04	22.45	31947.0
2022-03-24	ACTV	ETF	35.8012	35.85	35.7	35.7699	5302.0
2022-03-24	ACTX	ETF	1.0	1.0	1.0	1.0	1486.0
2022-03-24	ACVF	ETF	33.43	33.69	33.428	33.69	2400.0
2022-03-24	ACWF	ETF	36.89	37.13	36.89	37.121	3086.0
2022-03-24	ACWI	ETF	99.05	99.83	98.78	99.79	4969100.0
2022-03-24	ACWV	ETF	103.13	103.93	103.13	103.92	1596300.0
2022-03-24	ACWX	ETF	52.16	52.41	52.02	52.39	3786687.0
2022-03-24	ADFI	ETF	9.0	9.015	8.98	9.015	1000.0
2022-03-24	ADIV	ETF	15.59	15.669	15.59	15.669	400.0
2022-03-24	ADME	ETF	40.611	40.826	40.541	40.826	11300.0
2022-03-24	ADRE	ETF	44.78	45.0	44.425	45.0	3555.0
2022-03-24	AEMB	ETF	42.54	42.635	42.53	42.635	3800.0
2022-03-24	AESR	ETF	13.27	13.35	13.27	13.35	2900.0
2022-03-24	AFIF	ETF	9.205	9.22	9.205	9.215	9581.0
2022-03-24	AFK	ETF	21.23	21.4307	21.23	21.394	5132.0
2022-03-24	AFLG	ETF	26.61	26.729	26.6	26.729	3200.0
2022-03-24	AFMC	ETF	24.91	24.958	24.91	24.958	400.0
2022-03-24	AFSM	ETF	25.987	25.987	25.987	25.987	100.0
2022-03-24	AFTY	ETF	18.19	18.231	18.14	18.231	1000.0
2022-03-24	AGG	ETF	106.72	107.04	106.65	106.95	7480500.0
2022-03-24	AGGY	ETF	47.77	47.9	47.762	47.82	79800.0
2022-03-24	AGNG	ETF	27.74	28.03	27.74	28.03	1400.0
2022-03-24	AGOV	ETF	83.3	86.44	81.936	83.715	6888.0
2022-03-24	AGOX	ETF	23.97	24.24	23.92	24.06	83600.0
2022-03-24	AGQ	ETF	41.1	42.38	41.03	41.34	1083900.0
2022-03-24	AGZ	ETF	112.71	112.905	112.7064	112.86	20785.0
2022-03-24	AGZD	ETF	23.215	23.23	23.065	23.13	80800.0
2022-03-24	AHHX	ETF	9.52	9.52	9.46	9.46	3290.0
2022-03-24	AHYB	ETF	47.328	47.328	47.328	47.328	300.0
2022-03-24	AIA	ETF	69.42	69.71	68.86	69.69	35025.0
2022-03-24	AIEQ	ETF	36.87	37.144	36.546	37.07	10100.0
2022-03-24	AIQ	ETF	26.8	27.1	26.5358	27.04	26016.0
2022-03-24	AIRR	ETF	43.04	43.15	42.85	43.1	25100.0
2022-03-24	AIVI	ETF	40.16	40.36	40.16	40.35	1700.0
2022-03-24	AIVL	ETF	98.37	98.71	98.34	98.71	4500.0

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

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