PREVIEW / etf_daily / 2022-09-21

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-21.parquet
  size:    105 KB
  rows:    2,815

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-21	SPY	ETF	386.11	389.31	377.38	377.39	106746600.0
2022-09-21	QQQ	ETF	289.59	293.95	283.42	283.56	82930963.0
2022-09-21	IWM	ETF	179.37	181.1	175.33	175.34	29357100.0
2022-09-21	DIA	ETF	308.52	310.27	301.72	301.81	5110700.0
2022-09-21	GLD	ETF	155.97	157.25	154.01	155.79	7816100.0
2022-09-21	TLT	ETF	106.7	108.04	105.97	108.03	23132900.0
2022-09-21	AAA	ETF	24.26	24.26	24.26	24.26	22.0
2022-09-21	AAAU	ETF	16.62	16.75	16.42	16.6	1958200.0
2022-09-21	AADR	ETF	47.8	47.9	47.19	47.19	2200.0
2022-09-21	AAPB	ETF	22.75	22.98	21.77	21.77	5974.0
2022-09-21	AAPD	ETF	25.85	26.53	25.775	26.53	70003.0
2022-09-21	AAPU	ETF	23.06	23.31	22.22	22.22	77718.0
2022-09-21	AAXJ	ETF	63.26	63.58	62.57	62.59	759100.0
2022-09-21	ABEQ	ETF	26.21	26.21	25.92	25.92	1200.0
2022-09-21	ACES	ETF	62.98	64.55	62.39	62.5	30800.0
2022-09-21	ACIO	ETF	29.14	29.3	28.71	28.71	127400.0
2022-09-21	ACSI	ETF	43.8421	43.8421	43.8421	43.8421	10.0
2022-09-21	ACT	ETF	23.43	23.635	23.16	23.21	132983.0
2022-09-21	ACTV	ETF	29.07	29.07	28.5398	28.5398	57194.0
2022-09-21	ACTX	ETF	0.6	0.6	0.401	0.401	5108.0
2022-09-21	ACVF	ETF	29.03	29.075	28.459	28.459	1900.0
2022-09-21	ACWF	ETF	31.21	31.21	30.64	30.64	4345.0
2022-09-21	ACWI	ETF	83.73	84.37	82.11	82.13	4704500.0
2022-09-21	ACWV	ETF	93.06	93.71	91.96	92.13	132900.0
2022-09-21	ACWX	ETF	42.68	42.96	42.1	42.13	2470899.0
2022-09-21	ADFI	ETF	8.38	8.41	8.36	8.36	9600.0
2022-09-21	ADIV	ETF	12.721	12.721	12.721	12.721	200.0
2022-09-21	ADME	ETF	34.27	34.45	33.66	33.71	96700.0
2022-09-21	ADRE	ETF	37.51	37.51	36.65	36.65	5639.0
2022-09-21	AEMB	ETF	37.17	37.22	37.17	37.22	200.0
2022-09-21	AESR	ETF	11.32	11.41	11.15	11.15	39400.0
2022-09-21	AFIF	ETF	8.79	8.82	8.7801	8.81	46353.0
2022-09-21	AFK	ETF	16.13	16.21	16.0532	16.0532	2197.0
2022-09-21	AFLG	ETF	23.08	23.11	22.607	22.607	500.0
2022-09-21	AFMC	ETF	21.229	21.229	21.229	21.229	100.0
2022-09-21	AFSM	ETF	21.823	21.823	21.823	21.823	100.0
2022-09-21	AFTY	ETF	15.82	15.85	15.73	15.73	1400.0
2022-09-21	AGG	ETF	98.4	98.6	97.86	98.55	7094400.0
2022-09-21	AGGY	ETF	43.42	43.49	43.16	43.439	119800.0
2022-09-21	AGNG	ETF	23.856	23.856	23.856	23.856	200.0
2022-09-21	AGOV	ETF	80.84	81.0584	80.84	81.0584	100.0
2022-09-21	AGOX	ETF	20.64	20.77	20.27	20.313	7900.0
2022-09-21	AGQ	ETF	22.16	22.96	21.58	22.3	1513400.0
2022-09-21	AGZ	ETF	107.6	107.66	107.29	107.63	23793.0
2022-09-21	AGZD	ETF	22.925	23.025	22.895	22.96	117400.0
2022-09-21	AHHX	ETF	8.4859	8.4859	8.3991	8.3991	8007.0
2022-09-21	AHYB	ETF	43.043	43.043	42.858	42.858	400.0
2022-09-21	AIA	ETF	54.43	54.53	53.64	53.76	166529.0
2022-09-21	AIEQ	ETF	31.94	32.25	31.27	31.286	2200.0
2022-09-21	AIQ	ETF	20.5	20.79	20.2001	20.23	13374.0

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

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