PREVIEW / etf_daily / 2022-05-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-20.parquet
  size:    102 KB
  rows:    2,722

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-05-20	SPY	ETF	393.25	397.03	380.54	389.63	131432200.0
2022-05-20	QQQ	ETF	293.13	293.8	280.21	288.68	91764174.0
2022-05-20	IWM	ETF	178.5	178.97	171.79	176.08	42243700.0
2022-05-20	DIA	ETF	314.79	315.07	306.28	312.42	4654000.0
2022-05-20	GLD	ETF	171.71	172.24	170.89	172.03	6578100.0
2022-05-20	TLT	ETF	117.09	119.02	117.06	118.51	22780900.0
2022-05-20	AAA	ETF	24.44	24.48	24.43	24.48	3301.0
2022-05-20	AAAU	ETF	18.29	18.35	18.21	18.32	468000.0
2022-05-20	AADR	ETF	54.16	54.16	53.4	54.11	3200.0
2022-05-20	AAXJ	ETF	69.77	70.04	68.38	69.37	3378400.0
2022-05-20	ABEQ	ETF	28.27	28.31	27.99	28.307	20600.0
2022-05-20	ACES	ETF	50.72	50.788	47.98	49.55	113700.0
2022-05-20	ACIO	ETF	29.01	29.01	28.424	28.91	36000.0
2022-05-20	ACSI	ETF	42.13	42.4325	42.13	42.4325	1206.0
2022-05-20	ACT	ETF	23.54	23.7	22.9	23.49	181919.0
2022-05-20	ACTV	ETF	31.8992	31.8992	31.07	31.5786	6121.0
2022-05-20	ACTX	ETF	0.75	0.7605	0.7	0.7605	10225.0
2022-05-20	ACVF	ETF	29.5	29.5	28.93	29.434	2900.0
2022-05-20	ACWF	ETF	33.34	33.4269	32.635	33.1711	18077.0
2022-05-20	ACWI	ETF	88.64	88.72	86.2	87.95	2268400.0
2022-05-20	ACWV	ETF	96.47	96.6	95.13	96.37	348100.0
2022-05-20	ACWX	ETF	48.24	48.3	47.33	47.97	3557306.0
2022-05-20	ADFI	ETF	8.64	8.655	8.64	8.655	5800.0
2022-05-20	ADIV	ETF	14.464	14.464	14.464	14.464	100.0
2022-05-20	ADME	ETF	35.963	35.963	35.321	35.78	16500.0
2022-05-20	ADRE	ETF	39.6	39.6	38.4401	39.2	3030.0
2022-05-20	AEMB	ETF	39.93	40.103	39.93	40.103	800.0
2022-05-20	AESR	ETF	11.49	11.49	11.2	11.43	34400.0
2022-05-20	AFIF	ETF	8.941	8.96	8.94	8.94	20019.0
2022-05-20	AFK	ETF	19.14	19.14	18.56	18.76	6333.0
2022-05-20	AFLG	ETF	23.28	23.448	23.14	23.448	700.0
2022-05-20	AFMC	ETF	22.218	22.218	22.218	22.218	100.0
2022-05-20	AFSM	ETF	22.5	22.953	22.5	22.953	100.0
2022-05-20	AFTY	ETF	17.17	17.17	17.03	17.119	1000.0
2022-05-20	AGG	ETF	102.95	103.21	102.88	103.16	6731400.0
2022-05-20	AGGH	ETF	23.75	23.86	23.75	23.8056	325.0
2022-05-20	AGGY	ETF	45.5	45.663	45.5	45.64	186400.0
2022-05-20	AGNG	ETF	25.67	25.74	25.24	25.641	7100.0
2022-05-20	AGOV	ETF	79.62	80.495	79.62	80.495	825.0
2022-05-20	AGOX	ETF	21.6	21.6	20.921	21.32	18900.0
2022-05-20	AGQ	ETF	29.0	29.1	28.36	28.75	730200.0
2022-05-20	AGZ	ETF	110.77	111.2397	110.6932	110.93	30907.0
2022-05-20	AGZD	ETF	22.98	22.98	22.87	22.91	104800.0
2022-05-20	AHHX	ETF	9.01	9.0399	8.95	9.0399	6300.0
2022-05-20	AHYB	ETF	44.475	44.475	44.258	44.358	900.0
2022-05-20	AIA	ETF	63.44	63.54	62.0	62.74	33799.0
2022-05-20	AIEQ	ETF	32.893	32.893	31.885	32.7	13800.0
2022-05-20	AIQ	ETF	21.87	21.92	21.07	21.5727	27997.0
2022-05-20	AIRR	ETF	38.78	38.78	37.42	38.11	13200.0
2022-05-20	AIVI	ETF	39.05	39.05	38.55	38.9	2600.0

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

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