PREVIEW / etf_daily / 2022-04-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-28.parquet
  size:    101 KB
  rows:    2,698

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-28	SPY	ETF	422.29	429.64	417.6	427.81	105449100.0
2022-04-28	QQQ	ETF	321.85	329.89	317.52	328.01	99449957.0
2022-04-28	IWM	ETF	189.17	191.4	184.71	190.45	37405200.0
2022-04-28	DIA	ETF	335.24	340.54	332.49	339.29	5976600.0
2022-04-28	GLD	ETF	175.92	176.97	175.69	176.93	6381100.0
2022-04-28	TLT	ETF	120.39	121.07	120.01	121.02	16892500.0
2022-04-28	AAA	ETF	24.8562	24.8562	24.845	24.845	246.0
2022-04-28	AAAU	ETF	18.74	18.85	18.72	18.84	1082700.0
2022-04-28	AADR	ETF	54.26	55.32	54.26	55.21	12900.0
2022-04-28	AAXJ	ETF	70.01	70.52	69.36	70.41	1764400.0
2022-04-28	ABEQ	ETF	28.75	29.01	28.702	28.969	12600.0
2022-04-28	ACES	ETF	51.48	51.57	49.422	51.32	65800.0
2022-04-28	ACIO	ETF	30.25	30.747	30.25	30.66	71300.0
2022-04-28	ACSI	ETF	47.2959	47.2959	47.2959	47.2959	71.0
2022-04-28	ACT	ETF	23.42	24.4103	23.4	23.66	248770.0
2022-04-28	ACTV	ETF	33.64	34.16	33.27	34.02	9459.0
2022-04-28	ACTX	ETF	1.05	1.05	1.04	1.04	509.0
2022-04-28	ACVF	ETF	31.54	32.135	31.54	32.135	1800.0
2022-04-28	ACWF	ETF	34.52	35.42	34.52	35.1945	50161.0
2022-04-28	ACWI	ETF	93.16	94.55	92.2	94.2	4315300.0
2022-04-28	ACWV	ETF	101.67	102.65	101.16	102.43	184800.0
2022-04-28	ACWX	ETF	48.8	49.28	48.36	49.2	3516744.0
2022-04-28	ADFI	ETF	8.66	8.754	8.66	8.754	6800.0
2022-04-28	ADIV	ETF	14.63	14.731	14.63	14.731	200.0
2022-04-28	ADME	ETF	38.63	39.27	38.57	39.12	15200.0
2022-04-28	ADRE	ETF	39.285	40.15	39.0634	40.13	4601.0
2022-04-28	AEMB	ETF	41.02	41.169	41.02	41.169	2500.0
2022-04-28	AESR	ETF	12.35	12.68	12.35	12.62	19000.0
2022-04-28	AFIF	ETF	9.17	9.18	9.17	9.18	21766.0
2022-04-28	AFK	ETF	19.65	19.77	19.4	19.71	43354.0
2022-04-28	AFLG	ETF	25.63	25.65	25.63	25.635	200.0
2022-04-28	AFMC	ETF	23.66	23.806	23.66	23.806	200.0
2022-04-28	AFTY	ETF	17.18	17.18	16.79	16.97	6500.0
2022-04-28	AGG	ETF	103.33	103.51	103.17	103.49	10372200.0
2022-04-28	AGGY	ETF	45.68	45.85	45.624	45.81	190000.0
2022-04-28	AGNG	ETF	27.02	27.155	26.421	27.09	7400.0
2022-04-28	AGOV	ETF	80.112	81.0	79.765	79.765	1300.0
2022-04-28	AGOX	ETF	22.16	22.595	21.995	22.46	65100.0
2022-04-28	AGQ	ETF	32.58	33.2	32.36	33.11	946400.0
2022-04-28	AGZ	ETF	110.68	110.85	110.68	110.85	15400.0
2022-04-28	AGZD	ETF	23.035	23.12	23.01	23.06	129000.0
2022-04-28	AHHX	ETF	9.19	9.2	9.19	9.2	446.0
2022-04-28	AHYB	ETF	46.01	46.025	46.01	46.025	400.0
2022-04-28	AIA	ETF	62.65	63.01	61.92	63.01	76783.0
2022-04-28	AIEQ	ETF	34.53	35.0	34.04	34.811	6500.0
2022-04-28	AIQ	ETF	23.51	24.03	23.15	23.94	101902.0
2022-04-28	AIRR	ETF	38.99	39.432	38.391	39.295	10100.0
2022-04-28	AIVI	ETF	38.63	38.98	38.46	38.92	8900.0
2022-04-28	AIVL	ETF	96.36	97.59	96.36	97.31	5400.0
2022-04-28	ALTL	ETF	44.29	44.62	44.0358	44.53	63292.0

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

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