PREVIEW / etf_daily / 2022-04-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-29.parquet
  size:    102 KB
  rows:    2,713

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-04-29	SPY	ETF	423.59	425.87	411.21	412.0	145491100.0
2022-04-29	QQQ	ETF	323.7	327.225	312.6	313.25	91977859.0
2022-04-29	IWM	ETF	189.59	191.73	184.51	184.95	41193400.0
2022-04-29	DIA	ETF	337.62	339.23	329.1	329.69	6495600.0
2022-04-29	GLD	ETF	178.07	178.62	176.71	176.91	7719700.0
2022-04-29	TLT	ETF	119.31	120.97	119.11	119.45	26153400.0
2022-04-29	AAA	ETF	24.825	24.825	24.825	24.825	18.0
2022-04-29	AAAU	ETF	18.96	19.02	18.82	18.84	1934100.0
2022-04-29	AADR	ETF	55.39	55.39	54.66	54.66	1100.0
2022-04-29	AAXJ	ETF	71.88	72.19	70.81	70.92	2022800.0
2022-04-29	ABEQ	ETF	28.999	28.999	28.571	28.571	7900.0
2022-04-29	ACES	ETF	51.18	52.35	50.0	50.11	68800.0
2022-04-29	ACIO	ETF	30.4	30.4	30.03	30.07	68300.0
2022-04-29	ACSI	ETF	46.71	46.7312	45.6144	45.6144	507.0
2022-04-29	ACT	ETF	23.57	24.155	23.305	23.58	224636.0
2022-04-29	ACTV	ETF	33.696	33.73	33.14	33.1834	3420.0
2022-04-29	ACVF	ETF	32.033	32.05	31.098	31.098	12300.0
2022-04-29	ACWF	ETF	35.14	35.23	34.3396	34.3396	27965.0
2022-04-29	ACWI	ETF	93.99	94.49	91.65	91.73	3367900.0
2022-04-29	ACWV	ETF	102.34	102.34	100.01	100.11	107400.0
2022-04-29	ACWX	ETF	49.53	49.82	48.73	48.77	3416366.0
2022-04-29	ADFI	ETF	8.735	8.735	8.695	8.695	9400.0
2022-04-29	ADIV	ETF	14.92	14.92	14.731	14.731	1400.0
2022-04-29	ADME	ETF	38.885	38.885	38.165	38.22	35700.0
2022-04-29	ADRE	ETF	41.39	41.39	40.33	40.33	1864.0
2022-04-29	AEMB	ETF	40.91	40.92	40.675	40.675	2400.0
2022-04-29	AESR	ETF	12.5	12.58	12.17	12.17	23800.0
2022-04-29	AFIF	ETF	9.1749	9.18	9.16	9.16	33937.0
2022-04-29	AFK	ETF	19.85	20.02	19.46	19.51	7357.0
2022-04-29	AFLG	ETF	25.27	25.27	24.739	24.739	100.0
2022-04-29	AFMC	ETF	23.76	23.76	23.182	23.182	300.0
2022-04-29	AFSM	ETF	23.673	23.673	23.673	23.673	100.0
2022-04-29	AFTY	ETF	17.08	17.14	16.99	16.99	500.0
2022-04-29	AGG	ETF	102.92	103.27	102.82	102.87	9924100.0
2022-04-29	AGGH	ETF	23.95	23.95	23.8605	23.8605	106.0
2022-04-29	AGGY	ETF	45.5	45.676	45.48	45.49	329000.0
2022-04-29	AGNG	ETF	26.99	27.0	26.66	26.66	3900.0
2022-04-29	AGOV	ETF	79.86	79.86	79.86	79.86	113.0
2022-04-29	AGOX	ETF	22.45	22.605	21.87	21.87	162500.0
2022-04-29	AGQ	ETF	32.72	33.12	31.68	31.79	1272700.0
2022-04-29	AGZ	ETF	110.39	110.65	110.33	110.33	18004.0
2022-04-29	AGZD	ETF	23.065	23.09	22.98	23.035	56000.0
2022-04-29	AHHX	ETF	9.17	9.18	9.15	9.16	5775.0
2022-04-29	AHYB	ETF	45.65	45.7	45.469	45.469	600.0
2022-04-29	AIA	ETF	65.42	65.67	64.32	64.42	63675.0
2022-04-29	AIEQ	ETF	34.58	34.85	33.94	33.98	6000.0
2022-04-29	AIQ	ETF	23.8	24.2063	23.23	23.27	126406.0
2022-04-29	AIRR	ETF	39.38	39.4	38.23	38.33	18800.0
2022-04-29	AIVI	ETF	38.95	39.0	38.55	38.55	5700.0
2022-04-29	AIVL	ETF	96.54	97.0	94.49	94.49	3700.0

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

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