PREVIEW / etf_daily / 2022-09-29

all etf daily files

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

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-29	SPY	ETF	366.81	367.11	359.7	362.79	112952300.0
2022-09-29	QQQ	ETF	275.86	276.25	268.84	271.87	81215957.0
2022-09-29	IWM	ETF	167.78	167.93	163.8	166.13	31464000.0
2022-09-29	DIA	ETF	294.77	294.85	289.85	292.21	3351100.0
2022-09-29	GLD	ETF	154.14	155.03	153.16	154.66	6317000.0
2022-09-29	TLT	ETF	102.9	104.23	102.8	103.79	19127100.0
2022-09-29	AAA	ETF	24.1808	24.21	24.1808	24.21	429.0
2022-09-29	AAAU	ETF	16.43	16.52	16.33	16.48	1320900.0
2022-09-29	AADR	ETF	43.35	43.87	43.35	43.87	1000.0
2022-09-29	AAPB	ETF	19.87	19.87	18.84	18.95	14644.0
2022-09-29	AAPD	ETF	27.93	28.89	27.8283	28.59	198771.0
2022-09-29	AAPU	ETF	20.5283	20.635	19.43	19.79	96477.0
2022-09-29	AAXJ	ETF	59.1	59.16	58.48	58.87	1235600.0
2022-09-29	ABEQ	ETF	25.09	25.324	25.09	25.307	28700.0
2022-09-29	ACES	ETF	57.96	57.96	54.83	55.46	47400.0
2022-09-29	ACIO	ETF	28.26	28.36	28.16	28.25	125400.0
2022-09-29	ACSI	ETF	41.9307	41.9307	41.9307	41.9307	6.0
2022-09-29	ACT	ETF	22.32	22.65	21.91	22.09	210175.0
2022-09-29	ACTV	ETF	26.8	26.9575	26.7	26.91	8420.0
2022-09-29	ACVF	ETF	27.65	27.65	27.225	27.328	3300.0
2022-09-29	ACWF	ETF	29.48	29.48	29.23	29.401	31357.0
2022-09-29	ACWI	ETF	79.14	79.28	78.03	78.7	5311400.0
2022-09-29	ACWV	ETF	89.94	90.26	89.11	89.57	198900.0
2022-09-29	ACWX	ETF	40.15	40.21	39.65	40.11	5606845.0
2022-09-29	ADFI	ETF	8.18	8.23	8.18	8.23	6400.0
2022-09-29	ADIV	ETF	11.95	11.95	11.95	11.95	100.0
2022-09-29	ADME	ETF	33.15	33.52	33.15	33.44	64500.0
2022-09-29	ADRE	ETF	36.26	36.4145	32.77	34.42	4366.0
2022-09-29	AEMB	ETF	35.37	35.495	35.31	35.495	1800.0
2022-09-29	AESR	ETF	10.74	10.75	10.572	10.7	23400.0
2022-09-29	AFIF	ETF	8.64	8.64	8.61	8.63	51580.0
2022-09-29	AFK	ETF	15.27	15.27	15.02	15.12	7959.0
2022-09-29	AFLG	ETF	21.53	21.674	21.53	21.674	100.0
2022-09-29	AFMC	ETF	20.15	20.194	20.15	20.194	200.0
2022-09-29	AFSM	ETF	20.784	20.861	20.784	20.861	200.0
2022-09-29	AFTY	ETF	15.62	15.769	15.62	15.769	100.0
2022-09-29	AGG	ETF	96.48	96.8	96.29	96.57	8666100.0
2022-09-29	AGGH	ETF	22.91	22.97	22.91	22.97	2833.0
2022-09-29	AGGY	ETF	42.34	42.43	42.205	42.325	137400.0
2022-09-29	AGNG	ETF	23.64	23.64	23.48	23.48	1900.0
2022-09-29	AGOV	ETF	78.38	78.38	76.26	77.38	26663.0
2022-09-29	AGOX	ETF	19.45	19.468	19.24	19.397	117700.0
2022-09-29	AGQ	ETF	20.17	20.4	19.59	20.34	969500.0
2022-09-29	AGZ	ETF	106.51	106.7399	106.51	106.71	16384.0
2022-09-29	AGZD	ETF	22.84	22.84	22.715	22.77	62000.0
2022-09-29	AHHX	ETF	8.13	8.13	7.88	8.1	2291.0
2022-09-29	AHYB	ETF	41.75	41.847	41.75	41.847	200.0
2022-09-29	AIA	ETF	50.6	50.63	49.95	50.4	203563.0
2022-09-29	AIEQ	ETF	29.49	29.49	28.8	29.19	10600.0
2022-09-29	AIQ	ETF	19.5	19.5	19.19	19.2	11391.0

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

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