PREVIEW / etf_daily / 2022-04-27

all etf daily files

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

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-27	SPY	ETF	417.24	422.92	415.01	417.27	122030000.0
2022-04-27	QQQ	ETF	317.24	322.88	315.0	316.76	111204164.0
2022-04-27	IWM	ETF	187.67	189.78	186.26	186.96	37808000.0
2022-04-27	DIA	ETF	333.88	337.0	331.08	333.03	6894400.0
2022-04-27	GLD	ETF	176.46	176.64	175.5	175.98	8854700.0
2022-04-27	TLT	ETF	122.19	122.32	120.77	120.84	14560500.0
2022-04-27	AAA	ETF	24.82	24.83	24.82	24.83	903.0
2022-04-27	AAAU	ETF	18.8	18.81	18.69	18.77	4754800.0
2022-04-27	AADR	ETF	54.52	55.06	54.48	54.65	7800.0
2022-04-27	AAXJ	ETF	69.08	69.86	69.01	69.39	3155000.0
2022-04-27	ABEQ	ETF	28.685	28.9	28.685	28.694	7700.0
2022-04-27	ACES	ETF	51.13	52.3	50.75	50.94	28600.0
2022-04-27	ACIO	ETF	30.01	30.39	30.01	30.22	43200.0
2022-04-27	ACSI	ETF	46.37	46.4191	46.37	46.4191	312.0
2022-04-27	ACT	ETF	23.2	24.02	23.17	23.39	161739.0
2022-04-27	ACTV	ETF	33.6308	33.7697	33.42	33.4455	5592.0
2022-04-27	ACTX	ETF	1.0	1.0	1.0	1.0	2207.0
2022-04-27	ACVF	ETF	31.39	31.815	31.39	31.48	3900.0
2022-04-27	ACWF	ETF	34.66	34.725	34.5785	34.5785	8805.0
2022-04-27	ACWI	ETF	92.2	93.21	91.72	92.27	5464900.0
2022-04-27	ACWV	ETF	101.62	102.2	101.24	101.46	211700.0
2022-04-27	ACWX	ETF	48.39	48.745	48.16	48.46	5559939.0
2022-04-27	ADFI	ETF	8.76	8.765	8.751	8.751	2300.0
2022-04-27	ADIV	ETF	14.63	14.63	14.63	14.63	200.0
2022-04-27	ADME	ETF	38.21	38.75	38.21	38.51	39000.0
2022-04-27	ADRE	ETF	38.94	39.44	38.845	39.07	4431.0
2022-04-27	AEMB	ETF	41.26	41.26	41.19	41.22	4100.0
2022-04-27	AESR	ETF	12.32	12.5	12.32	12.38	19100.0
2022-04-27	AFIF	ETF	9.219	9.22	9.19	9.19	5737.0
2022-04-27	AFK	ETF	19.73	19.73	19.49	19.63	2909.0
2022-04-27	AFLG	ETF	25.32	25.32	25.191	25.191	100.0
2022-04-27	AFMC	ETF	23.4	23.4	23.4	23.4	100.0
2022-04-27	AFSM	ETF	23.91	23.91	23.886	23.886	500.0
2022-04-27	AFTY	ETF	16.95	17.02	16.92	17.0	5900.0
2022-04-27	AGG	ETF	103.91	104.01	103.53	103.53	11185400.0
2022-04-27	AGGH	ETF	23.99	24.0383	23.99	24.0383	304.0
2022-04-27	AGGY	ETF	45.96	46.04	45.81	45.85	471500.0
2022-04-27	AGNG	ETF	27.22	27.22	26.77	26.981	17300.0
2022-04-27	AGOV	ETF	80.86	80.86	80.86	80.86	2.0
2022-04-27	AGOX	ETF	22.11	22.27	21.99	22.0	260200.0
2022-04-27	AGQ	ETF	34.28	34.38	33.3	33.37	645700.0
2022-04-27	AGZ	ETF	110.99	111.44	110.65	110.65	53230.0
2022-04-27	AGZD	ETF	22.975	23.045	22.955	23.0	52000.0
2022-04-27	AHHX	ETF	9.21	9.215	9.2	9.21	8043.0
2022-04-27	AHYB	ETF	46.0	46.0	45.783	45.783	200.0
2022-04-27	AIA	ETF	61.61	62.49	61.61	61.99	61540.0
2022-04-27	AIEQ	ETF	34.28	34.527	34.057	34.161	3900.0
2022-04-27	AIQ	ETF	23.06	23.37	22.95	23.1	20088.0
2022-04-27	AIRR	ETF	38.91	39.122	38.49	38.76	27800.0
2022-04-27	AIVI	ETF	38.33	38.56	38.25	38.37	10200.0

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

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