PREVIEW / etf_daily / 2022-06-30

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-30.parquet
  size:    102 KB
  rows:    2,752

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-06-30	SPY	ETF	376.24	380.66	372.56	377.25	112508300.0
2022-06-30	QQQ	ETF	280.75	283.9441	275.78	280.28	79313580.0
2022-06-30	IWM	ETF	168.2	171.31	166.76	169.36	31466300.0
2022-06-30	DIA	ETF	306.75	309.82	304.25	307.82	4117800.0
2022-06-30	GLD	ETF	169.51	169.96	168.24	168.46	9144400.0
2022-06-30	TLT	ETF	114.86	115.77	114.75	114.87	25802100.0
2022-06-30	AAA	ETF	24.33	24.33	24.19	24.3	549.0
2022-06-30	AAAU	ETF	18.05	18.09	17.92	17.94	1003500.0
2022-06-30	AADR	ETF	48.44	48.59	47.67	48.59	2000.0
2022-06-30	AAXJ	ETF	68.46	69.22	68.05	69.2	1657600.0
2022-06-30	ABEQ	ETF	26.84	27.02	26.833	26.833	1800.0
2022-06-30	ACES	ETF	47.64	49.14	47.11	48.62	62800.0
2022-06-30	ACIO	ETF	28.59	28.96	28.59	28.83	77800.0
2022-06-30	ACSI	ETF	41.9852	41.9852	41.9852	41.9852	20.0
2022-06-30	ACT	ETF	20.7	21.48	20.32	21.48	268624.0
2022-06-30	ACTV	ETF	29.9632	30.5397	29.9632	30.41	17583.0
2022-06-30	ACVF	ETF	28.33	28.58	28.33	28.551	1400.0
2022-06-30	ACWF	ETF	31.05	31.21	30.96	31.06	5365.0
2022-06-30	ACWI	ETF	83.46	84.43	82.78	83.89	5459500.0
2022-06-30	ACWV	ETF	93.92	95.19	93.92	94.5	167000.0
2022-06-30	ACWX	ETF	44.48	45.02	44.26	45.0	2276843.0
2022-06-30	ADFI	ETF	8.47	8.51	8.46	8.51	19500.0
2022-06-30	ADIV	ETF	14.187	14.187	14.187	14.187	200.0
2022-06-30	ADME	ETF	34.71	34.79	34.2	34.52	51000.0
2022-06-30	ADRE	ETF	38.28	39.08	38.25	38.91	13531.0
2022-06-30	AEMB	ETF	37.68	37.887	37.65	37.887	1500.0
2022-06-30	AESR	ETF	11.02	11.16	10.88	11.09	21900.0
2022-06-30	AFIF	ETF	8.86	8.86	8.84	8.86	10530.0
2022-06-30	AFK	ETF	17.0	17.0	16.77	16.79	7038.0
2022-06-30	AFLG	ETF	22.66	22.67	22.544	22.544	4900.0
2022-06-30	AFMC	ETF	20.95	20.95	20.855	20.855	5800.0
2022-06-30	AFSM	ETF	21.86	21.86	21.722	21.722	3100.0
2022-06-30	AFTY	ETF	19.01	19.172	19.01	19.172	1600.0
2022-06-30	AGG	ETF	101.6	101.96	101.58	101.68	7521300.0
2022-06-30	AGGH	ETF	23.5	23.6467	23.5	23.6467	151.0
2022-06-30	AGGY	ETF	44.66	44.85	44.66	44.71	447500.0
2022-06-30	AGNG	ETF	25.285	25.44	25.27	25.294	1800.0
2022-06-30	AGOV	ETF	79.47	80.01	78.63	79.4	2601.0
2022-06-30	AGOX	ETF	20.0	20.34	20.0	20.14	96300.0
2022-06-30	AGQ	ETF	25.22	25.47	24.3	24.47	1027900.0
2022-06-30	AGZ	ETF	109.9	110.36	109.84	109.98	49090.0
2022-06-30	AGZD	ETF	22.8	22.835	22.74	22.795	30000.0
2022-06-30	AHHX	ETF	8.38	8.4134	8.38	8.4036	1875.0
2022-06-30	AHYB	ETF	42.43	42.646	42.43	42.595	3000.0
2022-06-30	AIA	ETF	62.19	62.84	61.69	62.74	150046.0
2022-06-30	AIEQ	ETF	30.39	30.66	30.02	30.214	13400.0
2022-06-30	AIQ	ETF	20.83	21.0536	20.5	20.82	22060.0
2022-06-30	AIRR	ETF	36.26	37.411	36.16	37.145	82700.0
2022-06-30	AIVI	ETF	35.16	35.64	35.0	35.56	5900.0
2022-06-30	AIVL	ETF	88.22	89.17	87.92	88.74	5500.0

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

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