PREVIEW / etf_daily / 2022-07-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-19.parquet
  size:    102 KB
  rows:    2,737

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-07-19	SPY	ETF	386.08	392.87	385.39	392.27	78506000.0
2022-07-19	QQQ	ETF	293.11	298.6	291.47	298.3	55172640.0
2022-07-19	IWM	ETF	174.75	178.89	174.66	178.69	24234600.0
2022-07-19	DIA	ETF	313.07	318.4	312.66	318.11	3004900.0
2022-07-19	GLD	ETF	159.47	159.87	159.33	159.54	3796200.0
2022-07-19	TLT	ETF	114.91	115.15	113.66	114.31	9276800.0
2022-07-19	AAA	ETF	24.27	24.27	24.25	24.27	59602.0
2022-07-19	AAAU	ETF	17.0	17.03	16.98	17.0	824900.0
2022-07-19	AADR	ETF	48.42	48.78	48.31	48.36	4600.0
2022-07-19	AAXJ	ETF	67.8	68.23	67.65	68.2	720200.0
2022-07-19	ABEQ	ETF	26.85	26.95	26.84	26.92	35200.0
2022-07-19	ACES	ETF	50.85	51.63	50.437	51.38	52300.0
2022-07-19	ACIO	ETF	29.197	29.471	29.197	29.471	6300.0
2022-07-19	ACSI	ETF	44.255	44.255	44.255	44.255	10.0
2022-07-19	ACT	ETF	21.28	22.02	21.28	21.83	126274.0
2022-07-19	ACTV	ETF	30.5	31.32	30.5	31.2733	7646.0
2022-07-19	ACTX	ETF	0.65	0.7	0.6451	0.7	4138.0
2022-07-19	ACVF	ETF	29.28	29.835	29.28	29.659	14700.0
2022-07-19	ACWF	ETF	31.5	31.95	31.5	31.95	9797.0
2022-07-19	ACWI	ETF	84.91	86.21	84.91	86.12	2193700.0
2022-07-19	ACWV	ETF	95.19	95.51	94.85	95.37	63000.0
2022-07-19	ACWX	ETF	44.77	45.165	44.73	45.13	2014142.0
2022-07-19	ADFI	ETF	8.54	8.56	8.53	8.545	5300.0
2022-07-19	ADIV	ETF	13.73	13.73	13.73	13.73	300.0
2022-07-19	ADME	ETF	34.75	35.244	34.75	35.244	10100.0
2022-07-19	ADRE	ETF	38.35	38.6835	38.29	38.675	1470.0
2022-07-19	AEMB	ETF	36.83	37.0	36.83	37.0	8300.0
2022-07-19	AESR	ETF	11.22	11.4	11.22	11.39	10200.0
2022-07-19	AFIF	ETF	8.84	8.84	8.82	8.83	25002.0
2022-07-19	AFK	ETF	16.74	16.87	16.74	16.87	1529.0
2022-07-19	AFLG	ETF	23.09	23.35	23.09	23.35	200.0
2022-07-19	AFMC	ETF	21.94	21.94	21.94	21.94	100.0
2022-07-19	AGG	ETF	101.95	101.99	101.66	101.78	5936200.0
2022-07-19	AGGY	ETF	45.02	45.03	44.78	44.97	97500.0
2022-07-19	AGNG	ETF	25.94	26.0	25.93	26.0	300.0
2022-07-19	AGOV	ETF	79.85	80.26	79.85	80.0772	1106.0
2022-07-19	AGOX	ETF	20.46	20.85	20.42	20.85	109100.0
2022-07-19	AGQ	ETF	20.78	20.98	20.71	20.75	447900.0
2022-07-19	AGZ	ETF	110.12	110.12	109.54	109.55	39021.0
2022-07-19	AGZD	ETF	23.0	23.025	22.94	22.99	102800.0
2022-07-19	AHHX	ETF	8.61	8.667	8.58	8.667	6927.0
2022-07-19	AHYB	ETF	43.795	43.795	43.795	43.795	100.0
2022-07-19	AIA	ETF	61.34	61.69	61.12	61.62	20390.0
2022-07-19	AIEQ	ETF	31.385	32.31	31.385	32.241	3800.0
2022-07-19	AIQ	ETF	21.41	21.77	21.2454	21.77	7717.0
2022-07-19	AIRR	ETF	38.31	39.27	38.31	39.27	5500.0
2022-07-19	AIVI	ETF	35.09	35.45	35.09	35.39	5500.0
2022-07-19	AIVL	ETF	89.65	91.35	89.65	91.27	3800.0
2022-07-19	ALTL	ETF	40.53	40.9	40.5101	40.85	235314.0
2022-07-19	ALTY	ETF	11.61	11.68	11.61	11.67	9100.0

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

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