PREVIEW / etf_daily / 2022-10-20

all etf daily files

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

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-20	SPY	ETF	368.03	372.67	364.61	365.41	88283100.0
2022-10-20	QQQ	ETF	269.58	274.84	267.92	269.11	60605496.0
2022-10-20	IWM	ETF	171.42	173.55	168.47	169.03	26710700.0
2022-10-20	DIA	ETF	304.83	308.37	302.74	303.31	3574700.0
2022-10-20	GLD	ETF	151.92	153.23	151.27	151.45	5019800.0
2022-10-20	TLT	ETF	95.93	96.33	94.74	94.88	25434900.0
2022-10-20	AAA	ETF	24.11	24.13	24.1	24.13	251.0
2022-10-20	AAAU	ETF	16.2	16.33	16.13	16.15	579400.0
2022-10-20	AADR	ETF	45.26	45.56	44.77	44.77	2800.0
2022-10-20	AAPB	ETF	19.33	19.33	18.899	19.024	1456.0
2022-10-20	AAPD	ETF	28.0915	28.38	27.7618	28.26	181847.0
2022-10-20	AAPU	ETF	19.79	20.35	19.79	19.87	44889.0
2022-10-20	AAXJ	ETF	57.28	58.07	57.06	57.15	581500.0
2022-10-20	ABEQ	ETF	26.04	26.04	25.74	25.796	8100.0
2022-10-20	ACES	ETF	49.69	50.22	48.48	48.86	117400.0
2022-10-20	ACIO	ETF	28.84	28.92	28.6	28.62	17200.0
2022-10-20	ACSI	ETF	41.2028	41.2028	41.2028	41.2028	26.0
2022-10-20	ACT	ETF	24.01	24.52	23.65	23.7	174655.0
2022-10-20	ACTV	ETF	27.62	27.77	27.28	27.375	8103.0
2022-10-20	ACTX	ETF	0.289	0.44	0.269	0.44	761.0
2022-10-20	ACVF	ETF	27.62	27.89	27.423	27.47	1800.0
2022-10-20	ACWF	ETF	30.2599	30.54	29.93	30.01	41790.0
2022-10-20	ACWI	ETF	79.59	80.58	78.98	79.15	6200900.0
2022-10-20	ACWV	ETF	89.36	89.71	88.54	88.76	241900.0
2022-10-20	ACWX	ETF	40.46	40.99	40.3	40.39	2448737.0
2022-10-20	ADFI	ETF	8.13	8.144	8.09	8.105	5400.0
2022-10-20	ADIV	ETF	11.53	11.63	11.53	11.534	900.0
2022-10-20	ADME	ETF	33.93	34.08	33.68	33.73	9300.0
2022-10-20	ADRE	ETF	33.59	34.0523	33.4413	33.49	4333.0
2022-10-20	AEMB	ETF	34.37	34.495	34.37	34.495	200.0
2022-10-20	AESR	ETF	10.99	10.99	10.84	10.862	8100.0
2022-10-20	AFIF	ETF	8.57	8.66	8.57	8.615	83677.0
2022-10-20	AFK	ETF	15.16	15.35	15.08	15.08	1826.0
2022-10-20	AFLG	ETF	22.13	22.149	22.13	22.149	400.0
2022-10-20	AFTY	ETF	14.79	14.79	14.744	14.744	200.0
2022-10-20	AGG	ETF	94.06	94.26	93.56	93.63	9012900.0
2022-10-20	AGGH	ETF	21.78	21.7965	21.78	21.7965	1534.0
2022-10-20	AGGY	ETF	41.21	41.298	40.995	41.15	75800.0
2022-10-20	AGNG	ETF	23.915	23.915	23.81	23.81	600.0
2022-10-20	AGOV	ETF	76.6	77.68	76.43	76.7911	1607.0
2022-10-20	AGOX	ETF	19.78	19.845	19.5	19.5	34500.0
2022-10-20	AGQ	ETF	19.41	20.38	19.34	19.6	1273200.0
2022-10-20	AGZ	ETF	105.26	105.3691	105.0583	105.07	40420.0
2022-10-20	AGZD	ETF	22.76	22.795	22.76	22.775	94000.0
2022-10-20	AHHX	ETF	8.29	8.31	8.13	8.18	14489.0
2022-10-20	AHYB	ETF	42.15	42.15	41.822	41.822	200.0
2022-10-20	AIA	ETF	47.91	48.82	47.88	47.89	45301.0
2022-10-20	AIEQ	ETF	30.026	30.026	29.26	29.37	3200.0
2022-10-20	AIQ	ETF	19.16	19.6499	19.16	19.23	7564.0
2022-10-20	AIRR	ETF	41.39	41.512	40.343	40.544	23300.0

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

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