PREVIEW / etf_daily / 2022-10-04

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-04.parquet
  size:    104 KB
  rows:    2,827

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-10-04	SPY	ETF	372.4	378.0	366.57	377.97	103602800.0
2022-10-04	QQQ	ETF	278.99	282.85	278.99	282.13	66696931.0
2022-10-04	IWM	ETF	172.61	176.08	172.53	176.0	37537300.0
2022-10-04	DIA	ETF	298.61	303.18	298.44	303.14	4163800.0
2022-10-04	GLD	ETF	159.18	161.08	158.92	160.7	8024500.0
2022-10-04	TLT	ETF	104.15	104.65	103.3	103.54	13788700.0
2022-10-04	AAA	ETF	24.1086	24.1086	24.08	24.08	218.0
2022-10-04	AAAU	ETF	16.97	17.16	16.93	17.12	313900.0
2022-10-04	AADR	ETF	45.8	46.79	45.8	46.66	11700.0
2022-10-04	AAPB	ETF	19.4901	19.7472	19.49	19.7472	4396.0
2022-10-04	AAPD	ETF	28.0	28.11	27.79	27.83	260552.0
2022-10-04	AAPU	ETF	20.34	20.55	20.19	20.55	78516.0
2022-10-04	AAXJ	ETF	60.24	61.26	60.18	61.08	1027000.0
2022-10-04	ABEQ	ETF	26.084	26.19	26.05	26.189	9500.0
2022-10-04	ACES	ETF	58.36	59.74	58.36	59.18	69700.0
2022-10-04	ACIO	ETF	29.0	29.1	28.895	29.1	590100.0
2022-10-04	ACSI	ETF	43.2295	43.2295	43.2295	43.2295	20.0
2022-10-04	ACT	ETF	23.12	23.95	23.12	23.54	285157.0
2022-10-04	ACTV	ETF	27.93	28.65	27.93	28.65	28224.0
2022-10-04	ACTX	ETF	0.548	0.548	0.306	0.306	250.0
2022-10-04	ACVF	ETF	27.92	28.42	27.92	28.397	2200.0
2022-10-04	ACWF	ETF	30.88	31.01	30.88	31.01	6134.0
2022-10-04	ACWI	ETF	81.2	82.41	81.2	82.4	3585800.0
2022-10-04	ACWV	ETF	91.43	92.18	91.05	92.14	307600.0
2022-10-04	ACWX	ETF	41.78	42.405	41.78	42.38	2591196.0
2022-10-04	ADFI	ETF	8.3	8.31	8.3	8.305	51700.0
2022-10-04	ADIV	ETF	12.13	12.26	12.13	12.26	3600.0
2022-10-04	ADME	ETF	34.04	34.09	33.8	34.06	63100.0
2022-10-04	ADRE	ETF	36.55	36.765	36.4303	36.63	2877.0
2022-10-04	AEMB	ETF	36.19	36.34	36.17	36.34	300.0
2022-10-04	AESR	ETF	11.08	11.18	11.05	11.18	93500.0
2022-10-04	AFIF	ETF	8.68	8.742	8.68	8.725	91253.0
2022-10-04	AFK	ETF	15.81	15.91	15.72	15.72	2510.0
2022-10-04	AFLG	ETF	22.702	22.702	22.702	22.702	100.0
2022-10-04	AFMC	ETF	21.448	21.448	21.448	21.448	100.0
2022-10-04	AFSM	ETF	22.02	22.071	21.986	22.071	13600.0
2022-10-04	AFTY	ETF	15.97	16.14	15.97	16.13	1100.0
2022-10-04	AGG	ETF	97.21	97.55	97.08	97.17	6964200.0
2022-10-04	AGGH	ETF	22.82	22.82	22.7595	22.7595	329.0
2022-10-04	AGGY	ETF	42.77	42.89	42.69	42.77	394800.0
2022-10-04	AGNG	ETF	24.18	24.55	24.18	24.55	8700.0
2022-10-04	AGOV	ETF	78.78	79.44	78.5	78.7282	13066.0
2022-10-04	AGOX	ETF	20.0	20.39	19.99	20.31	22400.0
2022-10-04	AGQ	ETF	25.19	25.92	24.98	25.4	1620900.0
2022-10-04	AGZ	ETF	106.81	107.07	106.79	106.79	20635.0
2022-10-04	AGZD	ETF	22.815	22.815	22.725	22.77	16200.0
2022-10-04	AHHX	ETF	8.29	8.3528	8.29	8.3528	68691.0
2022-10-04	AHYB	ETF	42.568	42.658	42.55	42.658	300.0
2022-10-04	AIA	ETF	51.54	52.66	51.54	52.66	242612.0
2022-10-04	AIEQ	ETF	30.42	31.25	30.42	31.25	7600.0

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

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