PREVIEW / etf_daily / 2022-05-06

all etf daily files

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

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-06	SPY	ETF	411.1	414.8	405.73	411.34	151770800.0
2022-05-06	QQQ	ETF	310.95	315.09	305.105	309.25	139572805.0
2022-05-06	IWM	ETF	184.96	185.42	180.55	182.58	45457900.0
2022-05-06	DIA	ETF	327.74	330.65	324.75	329.07	10644200.0
2022-05-06	GLD	ETF	175.39	176.56	174.86	175.42	7643300.0
2022-05-06	TLT	ETF	114.14	115.04	113.31	113.67	32790500.0
2022-05-06	AAA	ETF	24.71	24.71	24.71	24.71	4.0
2022-05-06	AAAU	ETF	18.67	18.8	18.62	18.68	640400.0
2022-05-06	AADR	ETF	53.45	53.69	53.34	53.5	900.0
2022-05-06	AAXJ	ETF	68.88	69.07	68.22	68.61	2109900.0
2022-05-06	ABEQ	ETF	29.01	29.01	28.525	28.71	13200.0
2022-05-06	ACES	ETF	52.45	52.45	50.38	51.27	116900.0
2022-05-06	ACIO	ETF	29.7	30.01	29.7	29.78	147100.0
2022-05-06	ACSI	ETF	45.81	45.81	45.6054	45.6054	168.0
2022-05-06	ACT	ETF	23.78	23.86	23.025	23.32	241606.0
2022-05-06	ACTV	ETF	32.69	32.9257	32.4308	32.57	12267.0
2022-05-06	ACTX	ETF	0.85	1.0	0.85	1.0	402.0
2022-05-06	ACVF	ETF	30.91	31.16	30.66	30.976	3600.0
2022-05-06	ACWF	ETF	33.97	34.29	33.94	34.2024	5754.0
2022-05-06	ACWI	ETF	90.87	91.41	89.7	90.63	4590200.0
2022-05-06	ACWV	ETF	98.48	99.14	98.09	98.52	172100.0
2022-05-06	ACWX	ETF	47.82	47.97	47.37	47.66	5241673.0
2022-05-06	ADFI	ETF	8.61	8.66	8.61	8.625	9600.0
2022-05-06	ADIV	ETF	14.311	14.38	14.311	14.38	1700.0
2022-05-06	ADME	ETF	37.5	37.97	37.46	37.68	106200.0
2022-05-06	ADRE	ETF	39.0	39.2	38.4619	38.78	3848.0
2022-05-06	AEMB	ETF	40.38	40.38	40.065	40.065	300.0
2022-05-06	AESR	ETF	12.162	12.24	12.03	12.2	15600.0
2022-05-06	AFIF	ETF	9.15	9.17	9.15	9.155	19606.0
2022-05-06	AFK	ETF	19.1	19.1	18.8	18.84	9452.0
2022-05-06	AFLG	ETF	24.755	24.755	24.755	24.755	100.0
2022-05-06	AFMC	ETF	23.24	23.24	23.24	23.24	100.0
2022-05-06	AFSM	ETF	23.505	23.68	23.42	23.68	300.0
2022-05-06	AFTY	ETF	16.51	16.55	16.51	16.545	1400.0
2022-05-06	AGG	ETF	101.66	101.95	101.49	101.57	8314100.0
2022-05-06	AGGY	ETF	44.87	45.04	44.83	44.9	286300.0
2022-05-06	AGNG	ETF	26.07	26.07	25.65	25.742	8300.0
2022-05-06	AGOV	ETF	79.0	79.7028	79.0	79.7028	1101.0
2022-05-06	AGOX	ETF	21.908	21.99	21.55	21.787	97900.0
2022-05-06	AGQ	ETF	30.79	31.17	30.31	30.62	834700.0
2022-05-06	AGZ	ETF	109.82	110.11	109.78	109.8071	19642.0
2022-05-06	AGZD	ETF	23.055	23.1	23.0	23.025	154200.0
2022-05-06	AHHX	ETF	9.12	9.13	9.12	9.13	1114713.0
2022-05-06	AHYB	ETF	44.877	44.948	44.86	44.948	1200.0
2022-05-06	AIA	ETF	62.16	62.38	61.5	61.73	167998.0
2022-05-06	AIEQ	ETF	33.82	34.155	33.251	33.81	15200.0
2022-05-06	AIQ	ETF	22.88	23.07	22.4005	22.63	22981.0
2022-05-06	AIRR	ETF	38.93	39.25	38.43	38.77	53200.0
2022-05-06	AIVI	ETF	38.14	38.32	37.98	38.19	49000.0
2022-05-06	AIVL	ETF	94.8	95.43	94.54	95.23	5300.0

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

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