PREVIEW / etf_daily / 2022-12-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-07.parquet
  size:    106 KB
  rows:    2,880

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-12-07	SPY	ETF	392.94	395.64	391.97	393.16	65927900.0
2022-12-07	QQQ	ETF	280.47	282.57	278.7801	280.53	45614254.0
2022-12-07	IWM	ETF	179.75	181.5	179.11	179.54	17177800.0
2022-12-07	DIA	ETF	336.14	338.33	335.54	336.44	3577100.0
2022-12-07	GLD	ETF	165.47	166.64	165.32	166.33	4610700.0
2022-12-07	TLT	ETF	108.37	109.68	108.2	109.47	30546700.0
2022-12-07	AAA	ETF	24.31	24.31	24.31	24.31	23.0
2022-12-07	AAAU	ETF	17.65	17.77	17.63	17.73	865600.0
2022-12-07	AADR	ETF	48.65	48.72	48.27	48.4	4100.0
2022-12-07	AAPB	ETF	17.9984	17.9984	17.9984	17.9984	324.0
2022-12-07	AAPD	ETF	27.79	28.2527	27.6161	28.08	170056.0
2022-12-07	AAPU	ETF	19.5286	19.5286	18.89	19.11	56074.0
2022-12-07	AAXJ	ETF	65.71	65.99	65.5	65.84	1160900.0
2022-12-07	ABEQ	ETF	28.09	28.14	27.982	28.03	11000.0
2022-12-07	ACES	ETF	51.73	52.022	51.02	51.56	27500.0
2022-12-07	ACIO	ETF	29.55	29.57	29.38	29.51	63300.0
2022-12-07	ACSI	ETF	43.8792	43.8792	43.8792	43.8792	21.0
2022-12-07	ACT	ETF	23.86	24.16	23.62	23.92	105740.0
2022-12-07	ACTV	ETF	30.06	30.14	29.97	29.97	9551.0
2022-12-07	ACTX	ETF	0.3	0.375	0.3	0.375	569.0
2022-12-07	ACVF	ETF	30.47	30.54	30.406	30.447	1300.0
2022-12-07	ACWF	ETF	32.93	33.0799	32.8979	32.9617	4947.0
2022-12-07	ACWI	ETF	87.05	87.54	86.88	87.09	4579300.0
2022-12-07	ACWV	ETF	97.24	97.63	97.17	97.32	222100.0
2022-12-07	ACWX	ETF	46.3	46.48	46.14	46.3	2049446.0
2022-12-07	ADFI	ETF	8.5	8.554	8.5	8.554	3500.0
2022-12-07	ADIV	ETF	13.1	13.1	13.094	13.094	200.0
2022-12-07	ADME	ETF	34.53	34.84	34.5	34.71	58000.0
2022-12-07	ADPV	ETF	25.09	25.101	25.09	25.101	20095.0
2022-12-07	ADRE	ETF	38.56	38.78	38.46	38.67	8489.0
2022-12-07	AEMB	ETF	38.37	38.37	38.37	38.37	100.0
2022-12-07	AESR	ETF	11.75	11.78	11.73	11.75	23900.0
2022-12-07	AFIF	ETF	8.8299	8.83	8.81	8.825	8128.0
2022-12-07	AFK	ETF	17.08	17.3516	17.08	17.23	3699.0
2022-12-07	AFLG	ETF	23.92	23.922	23.88	23.904	900.0
2022-12-07	AFMC	ETF	22.86	22.86	22.853	22.853	100.0
2022-12-07	AFSM	ETF	23.456	23.456	23.373	23.373	200.0
2022-12-07	AFTY	ETF	16.122	16.122	16.122	16.122	100.0
2022-12-07	AGG	ETF	99.29	99.73	99.17	99.68	6752900.0
2022-12-07	AGGY	ETF	43.71	43.89	43.68	43.89	118600.0
2022-12-07	AGNG	ETF	26.31	26.46	26.31	26.38	1800.0
2022-12-07	AGOV	ETF	81.355	81.355	81.355	81.355	20.0
2022-12-07	AGOX	ETF	21.02	21.02	20.88	20.945	12700.0
2022-12-07	AGQ	ETF	28.25	29.22	28.25	28.93	1294300.0
2022-12-07	AGZ	ETF	107.29	108.06	107.29	107.58	24590.0
2022-12-07	AGZD	ETF	21.765	21.825	21.7	21.775	287800.0
2022-12-07	AHHX	ETF	8.505	8.5228	8.48	8.5228	1686.0
2022-12-07	AHYB	ETF	43.522	43.664	43.522	43.664	600.0
2022-12-07	AIA	ETF	57.12	57.6	57.1	57.4	11715.0
2022-12-07	AIEQ	ETF	29.56	29.56	29.367	29.45	4500.0

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

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