PREVIEW / etf_daily / 2022-08-03

all etf daily files

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

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-03	SPY	ETF	410.3	415.68	410.0	414.45	67820600.0
2022-08-03	QQQ	ETF	316.05	323.7291	315.99	322.89	53735729.0
2022-08-03	IWM	ETF	188.3	190.15	187.64	189.75	19157700.0
2022-08-03	DIA	ETF	325.7	329.14	325.14	328.16	2564600.0
2022-08-03	GLD	ETF	164.77	164.91	163.48	164.45	4417800.0
2022-08-03	TLT	ETF	117.17	119.49	116.33	119.35	16731200.0
2022-08-03	AAA	ETF	24.27	24.27	24.27	24.27	1.0
2022-08-03	AAAU	ETF	17.55	17.56	17.42	17.52	1328900.0
2022-08-03	AADR	ETF	50.25	50.67	50.25	50.56	800.0
2022-08-03	AAXJ	ETF	67.2	67.78	66.96	67.66	1216500.0
2022-08-03	ABEQ	ETF	27.59	27.59	26.83	26.973	10800.0
2022-08-03	ACES	ETF	61.11	61.11	59.565	60.94	55100.0
2022-08-03	ACIO	ETF	30.51	30.73	30.51	30.67	57000.0
2022-08-03	ACSI	ETF	46.9377	46.9377	46.9377	46.9377	24.0
2022-08-03	ACT	ETF	24.74	25.38	24.447	25.07	244453.0
2022-08-03	ACTV	ETF	31.1401	31.64	31.1401	31.5603	4771.0
2022-08-03	ACTX	ETF	0.7	0.7	0.56	0.56	6647.0
2022-08-03	ACVF	ETF	30.81	31.196	30.81	31.196	2300.0
2022-08-03	ACWF	ETF	32.87	33.1504	32.87	33.1043	9587.0
2022-08-03	ACWI	ETF	89.24	90.14	89.08	89.97	2494100.0
2022-08-03	ACWV	ETF	97.16	97.56	96.74	97.38	171200.0
2022-08-03	ACWX	ETF	45.99	46.19	45.72	46.11	1193093.0
2022-08-03	ADFI	ETF	8.61	8.72	8.61	8.718	4400.0
2022-08-03	ADIV	ETF	13.614	13.614	13.614	13.614	200.0
2022-08-03	ADME	ETF	36.53	36.81	36.46	36.746	9300.0
2022-08-03	ADRE	ETF	38.5001	39.16	38.5001	39.15	1693.0
2022-08-03	AEMB	ETF	39.0	39.0	38.93	38.93	100.0
2022-08-03	AESR	ETF	11.84	12.03	11.84	12.012	4600.0
2022-08-03	AFIF	ETF	8.9201	8.95	8.91	8.9472	86433.0
2022-08-03	AFK	ETF	17.05	17.1899	17.05	17.16	3876.0
2022-08-03	AFLG	ETF	24.115	24.313	24.115	24.313	600.0
2022-08-03	AFMC	ETF	22.79	22.852	22.79	22.852	100.0
2022-08-03	AFSM	ETF	23.93	23.982	23.93	23.982	100.0
2022-08-03	AFTY	ETF	17.0	17.013	16.94	17.013	4600.0
2022-08-03	AGG	ETF	103.03	103.64	102.72	103.62	6261700.0
2022-08-03	AGGY	ETF	45.63	45.86	45.465	45.85	63700.0
2022-08-03	AGIH	ETF	25.93	25.943	25.93	25.943	129.0
2022-08-03	AGNG	ETF	26.202	26.239	26.16	26.167	4600.0
2022-08-03	AGOV	ETF	82.88	83.79	80.95	81.9768	3171.0
2022-08-03	AGOX	ETF	21.71	21.86	21.614	21.81	16600.0
2022-08-03	AGQ	ETF	23.61	23.83	23.23	23.76	777800.0
2022-08-03	AGZ	ETF	110.42	110.61	110.19	110.6	11762.0
2022-08-03	AGZD	ETF	22.945	23.0	22.925	22.965	59000.0
2022-08-03	AHHX	ETF	8.7386	8.81	8.7386	8.81	1769.0
2022-08-03	AHYB	ETF	45.178	45.178	45.178	45.178	100.0
2022-08-03	AIA	ETF	59.62	60.15	59.27	60.13	102527.0
2022-08-03	AIEQ	ETF	34.21	34.59	34.193	34.588	5800.0
2022-08-03	AIQ	ETF	22.57	23.09	22.57	23.02	14833.0
2022-08-03	AIRR	ETF	42.82	42.958	42.44	42.87	6400.0
2022-08-03	AIVI	ETF	36.12	36.28	36.12	36.28	300.0

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

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