PREVIEW / etf_daily / 2022-09-28

all etf daily files

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

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-28	SPY	ETF	364.38	372.3	362.6	370.53	110802200.0
2022-09-28	QQQ	ETF	274.46	281.25	272.945	279.94	79652140.0
2022-09-28	IWM	ETF	165.76	170.99	165.07	169.94	35186500.0
2022-09-28	DIA	ETF	292.35	298.03	291.05	296.73	3995700.0
2022-09-28	GLD	ETF	153.2	154.88	152.93	154.69	8977200.0
2022-09-28	TLT	ETF	103.13	104.45	102.48	104.33	39283100.0
2022-09-28	AAA	ETF	24.22	24.22	24.22	24.22	95.0
2022-09-28	AAAU	ETF	16.33	16.51	16.31	16.48	1284400.0
2022-09-28	AADR	ETF	44.19	44.83	44.19	44.83	2400.0
2022-09-28	AAPB	ETF	20.29	20.82	19.62	20.78	9459.0
2022-09-28	AAPD	ETF	27.62	28.0911	27.12	27.1944	173624.0
2022-09-28	AAPU	ETF	20.91	21.48	20.3792	21.35	130760.0
2022-09-28	AAXJ	ETF	59.28	60.5	59.14	60.34	820100.0
2022-09-28	ABEQ	ETF	24.98	25.52	24.98	25.46	15100.0
2022-09-28	ACES	ETF	57.36	59.05	56.82	58.77	170900.0
2022-09-28	ACIO	ETF	28.31	28.718	28.31	28.58	389000.0
2022-09-28	ACSI	ETF	42.9611	42.9611	42.9611	42.9611	20.0
2022-09-28	ACT	ETF	21.97	22.8	21.92	22.65	175170.0
2022-09-28	ACTV	ETF	27.26	27.68	27.26	27.55	8266.0
2022-09-28	ACTX	ETF	0.45	0.45	0.45	0.45	4990.0
2022-09-28	ACVF	ETF	27.31	27.88	27.31	27.73	11900.0
2022-09-28	ACWF	ETF	29.31	30.05	29.31	29.91	16301.0
2022-09-28	ACWI	ETF	78.67	80.47	78.37	80.21	7182400.0
2022-09-28	ACWV	ETF	89.54	91.04	89.54	90.7	295600.0
2022-09-28	ACWX	ETF	39.88	40.89	39.77	40.79	3924563.0
2022-09-28	ADFI	ETF	8.18	8.225	8.175	8.225	8900.0
2022-09-28	ADIV	ETF	12.21	12.28	12.16	12.258	14500.0
2022-09-28	ADME	ETF	33.315	33.63	33.29	33.56	20200.0
2022-09-28	ADRE	ETF	34.61	35.29	34.59	35.29	3489.0
2022-09-28	AEMB	ETF	35.51	35.815	35.51	35.815	1500.0
2022-09-28	AESR	ETF	10.72	10.94	10.72	10.921	17000.0
2022-09-28	AFIF	ETF	8.77	8.77	8.68	8.7489	136307.0
2022-09-28	AFK	ETF	15.08	15.405	15.08	15.3602	9040.0
2022-09-28	AFLG	ETF	22.1	22.2	22.1	22.142	400.0
2022-09-28	AFMC	ETF	20.616	20.616	20.616	20.616	100.0
2022-09-28	AFSM	ETF	21.28	21.28	21.236	21.236	100.0
2022-09-28	AFTY	ETF	15.72	15.72	15.72	15.72	100.0
2022-09-28	AGG	ETF	96.47	97.13	96.27	97.08	10539800.0
2022-09-28	AGGY	ETF	42.24	42.59	42.16	42.49	181600.0
2022-09-28	AGNG	ETF	23.38	23.96	23.38	23.89	4800.0
2022-09-28	AGOV	ETF	78.51	78.99	78.18	78.89	9807.0
2022-09-28	AGOX	ETF	19.4	19.81	19.34	19.797	87400.0
2022-09-28	AGQ	ETF	19.52	20.68	19.51	20.59	1109700.0
2022-09-28	AGZ	ETF	106.56	106.945	106.55	106.78	14349.0
2022-09-28	AGZD	ETF	22.82	22.88	22.74	22.75	59000.0
2022-09-28	AHHX	ETF	8.16	8.235	8.16	8.2329	1726.0
2022-09-28	AHYB	ETF	41.94	42.19	41.94	42.19	300.0
2022-09-28	AIA	ETF	50.74	51.9	50.74	51.81	33010.0
2022-09-28	AIEQ	ETF	29.185	30.01	29.185	29.959	11800.0
2022-09-28	AIQ	ETF	19.35	19.93	19.308	19.93	19321.0

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

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