PREVIEW / etf_daily / 2022-11-04

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-04.parquet
  size:    106 KB
  rows:    2,868

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-11-04	SPY	ETF	377.0	378.87	370.0	376.35	103505200.0
2022-11-04	QQQ	ETF	265.53	266.61	259.08	264.68	78313213.0
2022-11-04	IWM	ETF	178.92	179.94	175.47	178.68	25842400.0
2022-11-04	DIA	ETF	323.61	326.14	319.34	324.14	6263700.0
2022-11-04	GLD	ETF	154.95	156.6	154.66	156.47	7692000.0
2022-11-04	TLT	ETF	95.1	95.66	94.22	94.22	23561400.0
2022-11-04	AAA	ETF	24.11	24.11	24.11	24.11	17.0
2022-11-04	AAAU	ETF	16.52	16.69	16.5	16.68	1296000.0
2022-11-04	AADR	ETF	47.95	48.19	47.82	48.19	2700.0
2022-11-04	AAPB	ETF	18.2401	18.25	16.95	17.6459	6965.0
2022-11-04	AAPD	ETF	28.14	29.73	28.0	28.96	358632.0
2022-11-04	AAPU	ETF	19.56	19.56	17.95	18.79	163502.0
2022-11-04	AAXJ	ETF	58.97	59.36	58.31	59.26	1678300.0
2022-11-04	ABEQ	ETF	26.755	26.93	26.58	26.799	7200.0
2022-11-04	ACES	ETF	54.92	54.98	52.21	53.46	39300.0
2022-11-04	ACIO	ETF	28.95	29.1	28.79	29.03	74400.0
2022-11-04	ACSI	ETF	42.4889	42.4889	42.4889	42.4889	101.0
2022-11-04	ACT	ETF	25.49	26.17	25.49	25.74	169792.0
2022-11-04	ACTV	ETF	28.64	28.776	28.2199	28.29	7003.0
2022-11-04	ACTX	ETF	0.2502	0.51	0.2502	0.45	7568.0
2022-11-04	ACVF	ETF	28.84	29.034	28.8	28.866	1600.0
2022-11-04	ACWF	ETF	31.4	31.545	31.4	31.461	1457.0
2022-11-04	ACWI	ETF	82.27	82.67	81.07	82.33	6669600.0
2022-11-04	ACWV	ETF	91.95	92.42	91.15	92.28	159300.0
2022-11-04	ACWX	ETF	42.47	42.835	42.17	42.79	4490343.0
2022-11-04	ADFI	ETF	8.18	8.195	8.15	8.165	11500.0
2022-11-04	ADIV	ETF	11.735	11.735	11.735	11.735	100.0
2022-11-04	ADME	ETF	33.85	33.99	33.65	33.91	13100.0
2022-11-04	ADPV	ETF	25.06	25.11	25.0	25.025	23936.0
2022-11-04	ADRE	ETF	34.2	34.2	33.905	34.0667	2746.0
2022-11-04	AESR	ETF	11.28	11.334	11.17	11.33	28300.0
2022-11-04	AFIF	ETF	8.64	8.66	8.64	8.65	140755.0
2022-11-04	AFK	ETF	16.01	16.07	15.21	16.07	24455.0
2022-11-04	AFMC	ETF	21.89	21.961	21.89	21.961	100.0
2022-11-04	AFSM	ETF	22.788	22.788	22.788	22.788	100.0
2022-11-04	AFTY	ETF	14.52	14.685	14.47	14.685	2100.0
2022-11-04	AGG	ETF	94.43	94.64	94.17	94.34	6918300.0
2022-11-04	AGGH	ETF	21.96	21.96	21.75	21.75	2410.0
2022-11-04	AGGY	ETF	41.36	41.46	41.28	41.34	582900.0
2022-11-04	AGNG	ETF	24.9	24.97	24.686	24.97	800.0
2022-11-04	AGOV	ETF	79.26	80.18	79.17	80.16	4600.0
2022-11-04	AGOX	ETF	20.15	20.445	20.11	20.345	155100.0
2022-11-04	AGQ	ETF	23.54	24.8	23.32	24.77	1827700.0
2022-11-04	AGRH	ETF	25.17	25.17	25.165	25.165	200.0
2022-11-04	AGZ	ETF	105.155	105.7	105.13	105.41	23661.0
2022-11-04	AGZD	ETF	22.84	22.84	22.78	22.815	638800.0
2022-11-04	AHHX	ETF	8.36	8.38	8.26	8.36	16976.0
2022-11-04	AHYB	ETF	42.453	42.453	42.453	42.453	100.0
2022-11-04	AIA	ETF	49.23	49.52	48.5735	49.45	43491.0
2022-11-04	AIEQ	ETF	30.52	30.52	29.905	30.158	2600.0

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

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