PREVIEW / etf_daily / 2022-10-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-19.parquet
  size:    105 KB
  rows:    2,836

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-19	SPY	ETF	368.99	371.85	365.55	368.5	79746900.0
2022-10-19	QQQ	ETF	269.93	273.68	268.07	270.49	53115405.0
2022-10-19	IWM	ETF	172.49	173.4	169.33	171.21	27146900.0
2022-10-19	DIA	ETF	304.34	306.65	302.29	304.35	2939800.0
2022-10-19	GLD	ETF	152.09	152.49	151.54	151.69	8257100.0
2022-10-19	TLT	ETF	97.19	97.42	96.32	96.53	25431600.0
2022-10-19	AAA	ETF	24.13	24.13	24.13	24.13	201.0
2022-10-19	AAAU	ETF	16.21	16.25	16.15	16.16	711400.0
2022-10-19	AADR	ETF	45.53	45.53	45.01	45.31	6600.0
2022-10-19	AAPB	ETF	18.62	19.1109	18.62	19.1109	1120.0
2022-10-19	AAPD	ETF	28.58	28.58	27.96	28.17	150076.0
2022-10-19	AAPU	ETF	19.5	20.18	19.5	19.9563	127552.0
2022-10-19	AAXJ	ETF	57.09	57.42	56.69	56.83	493500.0
2022-10-19	ABEQ	ETF	25.98	25.99	25.867	25.894	13800.0
2022-10-19	ACES	ETF	50.9	50.9	49.62	50.02	198400.0
2022-10-19	ACIO	ETF	28.81	28.86	28.67	28.81	58400.0
2022-10-19	ACSI	ETF	41.36	41.4624	41.36	41.4624	774.0
2022-10-19	ACT	ETF	23.86	24.26	23.7	23.9	85371.0
2022-10-19	ACTV	ETF	27.64	27.93	27.45	27.524	13584.0
2022-10-19	ACTX	ETF	0.49	0.49	0.49	0.49	1000.0
2022-10-19	ACVF	ETF	27.77	27.795	27.51	27.632	2200.0
2022-10-19	ACWF	ETF	30.17	30.17	29.92	30.043	7788.0
2022-10-19	ACWI	ETF	79.71	80.22	78.99	79.53	2844000.0
2022-10-19	ACWV	ETF	89.23	89.53	88.69	89.03	77200.0
2022-10-19	ACWX	ETF	40.5	40.655	40.13	40.33	3975622.0
2022-10-19	ADFI	ETF	8.14	8.14	8.121	8.135	1700.0
2022-10-19	ADIV	ETF	11.471	11.54	11.471	11.48	2600.0
2022-10-19	ADME	ETF	33.86	34.2	33.77	33.96	15400.0
2022-10-19	ADRE	ETF	33.46	33.7699	33.28	33.33	6889.0
2022-10-19	AEMB	ETF	34.83	34.83	34.83	34.83	100.0
2022-10-19	AESR	ETF	11.01	11.015	10.79	10.96	15900.0
2022-10-19	AFIF	ETF	8.59	8.6221	8.59	8.615	19716.0
2022-10-19	AFK	ETF	15.26	15.26	15.11	15.19	4252.0
2022-10-19	AFLG	ETF	22.37	22.37	22.24	22.24	100.0
2022-10-19	AFMC	ETF	21.19	21.19	21.111	21.111	100.0
2022-10-19	AFSM	ETF	21.813	21.813	21.813	21.813	300.0
2022-10-19	AFTY	ETF	14.709	14.709	14.709	14.709	100.0
2022-10-19	AGG	ETF	94.41	94.56	94.15	94.2	6316100.0
2022-10-19	AGGH	ETF	22.04	22.05	22.04	22.05	727.0
2022-10-19	AGGY	ETF	41.42	41.48	41.27	41.32	670500.0
2022-10-19	AGNG	ETF	24.19	24.19	23.82	23.82	500.0
2022-10-19	AGOV	ETF	77.0	77.0	76.5909	76.5909	622.0
2022-10-19	AGOX	ETF	19.75	19.82	19.55	19.61	19500.0
2022-10-19	AGQ	ETF	19.17	19.38	19.0	19.24	702000.0
2022-10-19	AGRH	ETF	25.03	25.03	24.99	24.99	100.0
2022-10-19	AGZ	ETF	105.46	105.5173	105.355	105.39	8068.0
2022-10-19	AGZD	ETF	22.77	22.795	22.735	22.775	38800.0
2022-10-19	AHHX	ETF	8.25	8.3	8.18	8.2454	9052.0
2022-10-19	AHYB	ETF	41.98	42.016	41.98	42.016	200.0
2022-10-19	AIA	ETF	48.24	48.49	47.69	47.79	111575.0

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

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