PREVIEW / etf_daily / 2022-09-16

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-16.parquet
  size:    103 KB
  rows:    2,764

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-16	SPY	ETF	384.14	386.25	382.11	385.56	103084800.0
2022-09-16	QQQ	ETF	287.72	289.72	285.62	289.32	79920391.0
2022-09-16	IWM	ETF	179.09	179.68	176.91	178.99	41155900.0
2022-09-16	DIA	ETF	305.96	308.58	305.35	308.05	4071000.0
2022-09-16	GLD	ETF	154.66	156.56	154.34	155.84	7141200.0
2022-09-16	TLT	ETF	107.03	108.05	106.77	107.07	18903800.0
2022-09-16	AAA	ETF	24.28	24.28	24.28	24.28	111.0
2022-09-16	AAAU	ETF	16.48	16.68	16.45	16.61	1352200.0
2022-09-16	AADR	ETF	47.58	47.88	47.58	47.88	1500.0
2022-09-16	AAPB	ETF	20.61	21.06	20.61	21.03	1860.0
2022-09-16	AAPD	ETF	27.09	27.519	27.03	27.08	60632.0
2022-09-16	AAPU	ETF	21.66	21.77	21.1817	21.69	33832.0
2022-09-16	AAXJ	ETF	64.01	64.16	63.68	63.9	1140800.0
2022-09-16	ABEQ	ETF	26.18	26.39	26.18	26.387	55700.0
2022-09-16	ACES	ETF	64.38	65.53	64.1	65.01	129200.0
2022-09-16	ACIO	ETF	29.06	29.24	29.06	29.18	43500.0
2022-09-16	ACSI	ETF	44.6302	44.6302	44.6302	44.6302	4.0
2022-09-16	ACT	ETF	23.43	23.655	22.77	23.12	2344760.0
2022-09-16	ACTV	ETF	29.195	29.2108	28.98	29.2108	6454.0
2022-09-16	ACTX	ETF	0.615	0.64	0.2005	0.64	527.0
2022-09-16	ACVF	ETF	29.0	29.0	28.865	28.925	2700.0
2022-09-16	ACWF	ETF	31.35	31.36	31.06	31.29	24444.0
2022-09-16	ACWI	ETF	83.85	84.18	83.39	83.99	4167400.0
2022-09-16	ACWV	ETF	93.14	93.91	93.14	93.78	261200.0
2022-09-16	ACWX	ETF	43.09	43.3	42.92	43.15	1983542.0
2022-09-16	ADFI	ETF	8.371	8.41	8.371	8.41	21800.0
2022-09-16	ADME	ETF	34.27	34.49	32.56	34.357	16300.0
2022-09-16	ADRE	ETF	38.2	38.2	37.6129	37.83	23763.0
2022-09-16	AEMB	ETF	37.56	37.56	37.46	37.46	300.0
2022-09-16	AESR	ETF	11.35	11.37	11.25	11.34	36200.0
2022-09-16	AFIF	ETF	8.829	8.86	8.81	8.84	200483.0
2022-09-16	AFK	ETF	16.21	16.36	16.11	16.15	4989.0
2022-09-16	AFLG	ETF	22.85	23.014	22.85	23.014	300.0
2022-09-16	AFMC	ETF	21.39	21.544	21.37	21.544	300.0
2022-09-16	AFSM	ETF	21.86	22.07	21.86	22.07	100.0
2022-09-16	AFTY	ETF	16.08	16.08	16.045	16.045	600.0
2022-09-16	AGG	ETF	98.66	99.01	98.61	98.83	6965400.0
2022-09-16	AGGH	ETF	23.06	23.06	22.99	22.99	1329.0
2022-09-16	AGGY	ETF	43.48	43.66	43.475	43.56	113500.0
2022-09-16	AGNG	ETF	24.64	24.73	24.64	24.71	800.0
2022-09-16	AGOV	ETF	80.99	80.991	80.33	80.991	646.0
2022-09-16	AGOX	ETF	20.86	20.86	20.495	20.646	6500.0
2022-09-16	AGQ	ETF	20.99	22.24	20.72	22.06	1309000.0
2022-09-16	AGRH	ETF	25.2988	25.2988	25.29	25.29	1005.0
2022-09-16	AGZ	ETF	107.8	107.9688	107.75	107.86	19324.0
2022-09-16	AGZD	ETF	22.945	22.975	22.925	22.925	167000.0
2022-09-16	AHHX	ETF	8.4597	8.4597	8.4553	8.4553	645.0
2022-09-16	AIA	ETF	55.03	55.23	54.8	55.01	65885.0
2022-09-16	AIEQ	ETF	32.124	32.197	31.94	32.197	2000.0
2022-09-16	AIQ	ETF	20.59	20.6	20.4	20.49	21969.0

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

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