PREVIEW / etf_daily / 2022-11-03

all etf daily files

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

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-03	SPY	ETF	371.47	374.2	368.79	371.01	87100100.0
2022-11-03	QQQ	ETF	263.01	264.5	260.1	260.49	70038903.0
2022-11-03	IWM	ETF	175.29	177.94	174.11	176.3	29093200.0
2022-11-03	DIA	ETF	319.35	321.85	317.18	319.87	4112700.0
2022-11-03	GLD	ETF	150.7	151.96	150.57	151.81	5378800.0
2022-11-03	TLT	ETF	95.17	96.38	95.09	95.83	29097500.0
2022-11-03	AAA	ETF	24.11	24.11	24.11	24.11	25.0
2022-11-03	AAAU	ETF	16.07	16.2	16.06	16.18	1316800.0
2022-11-03	AADR	ETF	46.62	46.99	46.54	46.95	2500.0
2022-11-03	AAPB	ETF	18.51	18.51	17.76	17.82	3298.0
2022-11-03	AAPD	ETF	28.26	28.85	28.1048	28.83	242551.0
2022-11-03	AAPU	ETF	19.49	19.57	18.8	18.83	78628.0
2022-11-03	AAXJ	ETF	55.98	56.83	55.98	56.71	709500.0
2022-11-03	ABEQ	ETF	26.47	26.6	26.47	26.475	11400.0
2022-11-03	ACES	ETF	52.08	54.278	52.08	53.62	30900.0
2022-11-03	ACIO	ETF	28.98	29.031	28.929	28.97	25600.0
2022-11-03	ACSI	ETF	42.1756	42.1756	42.1756	42.1756	14.0
2022-11-03	ACT	ETF	26.31	26.625	25.36	25.45	234509.0
2022-11-03	ACTV	ETF	28.36	28.46	28.2683	28.2683	3858.0
2022-11-03	ACTX	ETF	0.48	0.48	0.48	0.48	202.0
2022-11-03	ACVF	ETF	28.4	28.664	28.378	28.492	3900.0
2022-11-03	ACWF	ETF	30.62	30.88	30.62	30.7741	3051.0
2022-11-03	ACWI	ETF	80.24	80.97	79.85	80.44	7749200.0
2022-11-03	ACWV	ETF	90.68	91.32	90.52	91.0	211000.0
2022-11-03	ACWX	ETF	40.8	41.31	40.8	41.15	2322244.0
2022-11-03	ADFI	ETF	8.05	8.175	8.05	8.175	3100.0
2022-11-03	ADIV	ETF	11.298	11.298	11.298	11.298	100.0
2022-11-03	ADME	ETF	33.89	33.89	33.69	33.7	29300.0
2022-11-03	ADRE	ETF	32.405	32.84	32.2388	32.8053	3890.0
2022-11-03	AEMB	ETF	36.52	36.52	35.158	35.158	300.0
2022-11-03	AESR	ETF	11.04	11.263	11.04	11.22	32800.0
2022-11-03	AFIF	ETF	8.6204	8.67	8.59	8.65	134198.0
2022-11-03	AFK	ETF	15.03	15.26	15.02	15.21	7387.0
2022-11-03	AFLG	ETF	22.761	22.761	22.761	22.761	100.0
2022-11-03	AFSM	ETF	22.42	22.7	22.42	22.504	8000.0
2022-11-03	AFTY	ETF	13.71	13.71	13.703	13.703	200.0
2022-11-03	AGG	ETF	93.97	94.51	93.93	94.35	9314800.0
2022-11-03	AGGY	ETF	41.23	41.44	41.21	41.39	76700.0
2022-11-03	AGNG	ETF	24.53	24.53	24.53	24.53	300.0
2022-11-03	AGOV	ETF	79.71	79.7161	79.35	79.7161	610.0
2022-11-03	AGOX	ETF	19.9	20.175	19.9	20.01	229000.0
2022-11-03	AGQ	ETF	20.29	21.66	20.24	21.54	1587400.0
2022-11-03	AGZ	ETF	105.12	105.33	105.12	105.14	19582.0
2022-11-03	AGZD	ETF	22.945	22.945	22.76	22.875	85800.0
2022-11-03	AHHX	ETF	8.25	8.37	8.24	8.3152	5955.0
2022-11-03	AHYB	ETF	42.208	42.208	42.208	42.208	200.0
2022-11-03	AIA	ETF	46.35	47.19	46.25	47.0	32953.0
2022-11-03	AIEQ	ETF	30.09	30.78	29.97	30.29	33700.0
2022-11-03	AIQ	ETF	18.86	18.94	18.77	18.77	78500.0
2022-11-03	AIRR	ETF	43.17	44.19	42.98	43.83	20100.0

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

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