PREVIEW / etf_daily / 2022-09-06

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-06.parquet
  size:    104 KB
  rows:    2,788

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-06	SPY	ETF	393.13	394.12	388.42	390.76	76637400.0
2022-09-06	QQQ	ETF	295.66	296.6	290.87	293.05	57005444.0
2022-09-06	IWM	ETF	180.71	181.08	177.5	178.31	23837100.0
2022-09-06	DIA	ETF	314.55	315.2	310.93	312.2	3320400.0
2022-09-06	GLD	ETF	159.17	159.46	158.32	158.33	4863800.0
2022-09-06	TLT	ETF	108.9	108.97	107.42	107.49	24648500.0
2022-09-06	AAA	ETF	24.32	24.32	24.32	24.32	55.0
2022-09-06	AAAU	ETF	16.96	16.98	16.86	16.88	1121600.0
2022-09-06	AADR	ETF	49.07	49.07	48.69	48.69	800.0
2022-09-06	AAPB	ETF	22.54	22.54	21.96	22.15	2515.0
2022-09-06	AAPD	ETF	26.29	26.689	26.29	26.6359	51474.0
2022-09-06	AAPU	ETF	23.0	23.01	22.42	22.54	36433.0
2022-09-06	AAXJ	ETF	65.28	65.38	64.73	64.86	866000.0
2022-09-06	ABEQ	ETF	26.355	26.41	26.224	26.224	4800.0
2022-09-06	ACES	ETF	61.26	62.14	60.212	61.55	75300.0
2022-09-06	ACIO	ETF	29.71	29.76	29.605	29.67	49500.0
2022-09-06	ACSI	ETF	44.6034	44.6034	44.6034	44.6034	113.0
2022-09-06	ACT	ETF	24.45	25.46	24.45	24.56	323182.0
2022-09-06	ACTV	ETF	29.1	29.1	28.93	28.9596	3125.0
2022-09-06	ACTX	ETF	0.5	0.5	0.5	0.5	2439.0
2022-09-06	ACVF	ETF	29.4	29.4	29.2	29.31	4300.0
2022-09-06	ACWF	ETF	31.73	31.73	31.4716	31.4913	3280.0
2022-09-06	ACWI	ETF	85.09	85.27	84.15	84.48	16409700.0
2022-09-06	ACWV	ETF	94.22	94.63	93.69	93.86	204300.0
2022-09-06	ACWX	ETF	43.59	43.64	43.15	43.25	2843104.0
2022-09-06	ADFI	ETF	8.41	8.46	8.41	8.435	6700.0
2022-09-06	ADIV	ETF	13.11	13.11	13.007	13.007	100.0
2022-09-06	ADME	ETF	35.0	35.08	34.905	35.01	27300.0
2022-09-06	ADRE	ETF	38.57	38.57	38.09	38.2	2924.0
2022-09-06	AEMB	ETF	37.78	37.8	37.565	37.565	2000.0
2022-09-06	AESR	ETF	11.54	11.54	11.42	11.47	28200.0
2022-09-06	AFIF	ETF	8.91	8.91	8.87	8.88	27015.0
2022-09-06	AFK	ETF	16.43	16.68	16.43	16.4771	4691.0
2022-09-06	AFLG	ETF	23.23	23.24	23.184	23.184	300.0
2022-09-06	AFMC	ETF	21.67	21.67	21.67	21.67	100.0
2022-09-06	AFSM	ETF	22.313	22.313	22.313	22.313	100.0
2022-09-06	AFTY	ETF	16.29	16.294	16.25	16.282	1800.0
2022-09-06	AGG	ETF	99.96	99.97	99.41	99.42	5341300.0
2022-09-06	AGGH	ETF	23.31	23.31	23.25	23.2521	1443.0
2022-09-06	AGGY	ETF	44.06	44.06	43.78	43.8	175700.0
2022-09-06	AGNG	ETF	24.44	24.44	24.32	24.327	800.0
2022-09-06	AGOV	ETF	81.23	81.23	80.898	81.0	602.0
2022-09-06	AGOX	ETF	20.97	20.97	20.62	20.66	34500.0
2022-09-06	AGQ	ETF	19.05	19.14	18.45	18.5	919800.0
2022-09-06	AGZ	ETF	108.77	108.77	108.56	108.63	21485.0
2022-09-06	AGZD	ETF	22.94	22.955	22.885	22.9	168800.0
2022-09-06	AHHX	ETF	8.5	8.55	8.47	8.5126	3876.0
2022-09-06	AHYB	ETF	43.1	43.113	43.1	43.113	500.0
2022-09-06	AIA	ETF	56.89	56.89	56.26	56.32	32988.0
2022-09-06	AIEQ	ETF	32.52	32.52	32.078	32.078	5100.0

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

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