PREVIEW / etf_daily / 2021-12-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-21.parquet
  size:    98 KB
  rows:    2,616

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
2021-12-21	SPY	ETF	458.61	463.21	456.31	463.06	69806300.0
2021-12-21	QQQ	ETF	384.05	389.53	380.201	389.21	48899477.0
2021-12-21	IWM	ETF	214.2	218.39	212.06	218.18	38545300.0
2021-12-21	DIA	ETF	352.16	354.98	351.51	354.91	4693300.0
2021-12-21	GLD	ETF	167.69	167.78	166.74	167.02	4548500.0
2021-12-21	TLT	ETF	148.14	149.2	147.62	149.13	16598200.0
2021-12-21	AAA	ETF	25.04	25.04	25.04	25.04	2.0
2021-12-21	AAAU	ETF	17.85	17.86	17.74	17.77	100000.0
2021-12-21	AADR	ETF	62.34	62.8	62.34	62.8	1300.0
2021-12-21	AAXJ	ETF	80.96	81.74	80.94	81.72	1245800.0
2021-12-21	ABEQ	ETF	27.831	28.05	27.831	27.935	6700.0
2021-12-21	ACES	ETF	62.62	63.91	62.31	63.81	195600.0
2021-12-21	ACIO	ETF	31.74	32.02	31.71	32.0	66500.0
2021-12-21	ACSI	ETF	51.34	51.7821	51.34	51.7821	472.0
2021-12-21	ACT	ETF	19.55	19.85	19.335	19.6	146735.0
2021-12-21	ACTV	ETF	35.04	35.49	35.04	35.4354	7130.0
2021-12-21	ACTX	ETF	1.1	1.2	1.1	1.2	2523.0
2021-12-21	ACVF	ETF	34.27	34.675	34.27	34.675	6300.0
2021-12-21	ACWF	ETF	37.71	38.06	37.68	38.06	43823.0
2021-12-21	ACWI	ETF	102.54	103.54	102.22	103.46	3683100.0
2021-12-21	ACWV	ETF	106.06	106.19	105.62	106.1	146500.0
2021-12-21	ACWX	ETF	54.27	54.69	54.25	54.67	2032029.0
2021-12-21	ADFI	ETF	9.54	9.576	9.54	9.576	5500.0
2021-12-21	ADIV	ETF	16.07	16.1	16.04	16.1	700.0
2021-12-21	ADME	ETF	41.93	42.44	41.83	42.44	21400.0
2021-12-21	ADRE	ETF	44.15	45.1708	44.15	45.01	25280.0
2021-12-21	AEMB	ETF	48.147	48.147	48.147	48.147	100.0
2021-12-21	AESR	ETF	14.74	14.74	13.43	13.633	63000.0
2021-12-21	AFIF	ETF	9.52	9.56	9.51	9.53	49740.0
2021-12-21	AFK	ETF	19.39	19.5	19.3884	19.45	8315.0
2021-12-21	AFLG	ETF	27.19	27.432	27.19	27.432	400.0
2021-12-21	AFMC	ETF	25.74	25.877	25.74	25.877	200.0
2021-12-21	AFSM	ETF	26.71	26.9	26.71	26.9	200.0
2021-12-21	AFTY	ETF	21.3	21.381	21.3	21.381	700.0
2021-12-21	AGG	ETF	114.07	114.32	113.97	114.24	12970200.0
2021-12-21	AGGY	ETF	51.83	51.83	51.63	51.81	183500.0
2021-12-21	AGNG	ETF	28.12	28.38	28.05	28.358	3900.0
2021-12-21	AGOV	ETF	98.7	98.73	98.4	98.4	355.0
2021-12-21	AGOX	ETF	24.56	24.88	24.52	24.78	179800.0
2021-12-21	AGQ	ETF	32.62	32.77	32.19	32.33	507100.0
2021-12-21	AGZ	ETF	117.24	117.3547	117.21	117.23	33951.0
2021-12-21	AGZD	ETF	23.325	23.4	23.325	23.35	196600.0
2021-12-21	AHHX	ETF	10.1601	10.44	10.1601	10.285	2682.0
2021-12-21	AHYB	ETF	49.82	49.91	49.82	49.9	284800.0
2021-12-21	AIA	ETF	75.13	76.13	74.9855	76.12	128895.0
2021-12-21	AIEQ	ETF	40.75	41.347	40.73	41.32	7400.0
2021-12-21	AIQ	ETF	30.84	31.39	30.66	31.38	25231.0
2021-12-21	AIRR	ETF	42.83	43.57	42.83	43.57	11800.0
2021-12-21	AIVI	ETF	41.55	41.72	41.47	41.67	46400.0
2021-12-21	ALTL	ETF	43.81	44.87	43.795	44.85	86738.0

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

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