PREVIEW / etf_daily / 2021-11-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-26.parquet
  size:    96 KB
  rows:    2,581

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-11-26	SPY	ETF	462.34	463.9	457.77	458.97	112669600.0
2021-11-26	QQQ	ETF	396.11	397.54	389.77	391.2	51533314.0
2021-11-26	IWM	ETF	224.96	226.17	219.64	222.85	62595400.0
2021-11-26	DIA	ETF	350.33	351.46	347.36	349.02	9075000.0
2021-11-26	GLD	ETF	168.6	168.64	166.37	166.85	9605200.0
2021-11-26	TLT	ETF	148.83	150.68	148.67	150.53	20064800.0
2021-11-26	AAA	ETF	25.0389	25.0389	25.025	25.025	525.0
2021-11-26	AAAU	ETF	17.95	17.95	17.7	17.75	334600.0
2021-11-26	AADR	ETF	62.08	62.08	61.47	61.47	600.0
2021-11-26	AAXJ	ETF	83.83	83.9	82.96	83.39	1817300.0
2021-11-26	ABEQ	ETF	27.51	27.614	27.51	27.614	800.0
2021-11-26	ACES	ETF	74.99	75.94	73.546	74.47	36200.0
2021-11-26	ACIO	ETF	31.7	31.7	31.439	31.464	7300.0
2021-11-26	ACSI	ETF	51.7137	51.7137	51.7137	51.7137	12.0
2021-11-26	ACT	ETF	21.5	21.53	20.82	21.4	137550.0
2021-11-26	ACTV	ETF	36.75	37.02	36.75	37.0098	2492.0
2021-11-26	ACTX	ETF	1.5	1.65	1.5	1.65	807.0
2021-11-26	ACVF	ETF	34.73	34.73	34.2	34.414	6200.0
2021-11-26	ACWF	ETF	37.91	37.99	37.63	37.75	5910.0
2021-11-26	ACWI	ETF	104.17	104.42	103.17	103.37	4094700.0
2021-11-26	ACWV	ETF	105.1	105.8	104.66	104.78	87700.0
2021-11-26	ACWX	ETF	55.21	55.23	54.58	54.8	2008407.0
2021-11-26	ADFI	ETF	9.6	9.61	9.58	9.598	8200.0
2021-11-26	ADIV	ETF	17.5	17.5	17.442	17.442	400.0
2021-11-26	ADME	ETF	42.12	42.12	41.64	41.76	11300.0
2021-11-26	ADRE	ETF	47.34	47.44	46.871	47.3813	4836.0
2021-11-26	AEMB	ETF	47.58	47.58	47.58	47.58	100.0
2021-11-26	AESR	ETF	14.67	14.755	14.48	14.515	17500.0
2021-11-26	AFIF	ETF	9.6263	9.63	9.625	9.625	700.0
2021-11-26	AFK	ETF	20.19	20.34	19.97	20.08	22013.0
2021-11-26	AFLG	ETF	27.29	27.29	27.022	27.022	200.0
2021-11-26	AFMC	ETF	26.42	26.42	26.084	26.084	200.0
2021-11-26	AFSM	ETF	27.86	27.86	27.297	27.297	300.0
2021-11-26	AFTY	ETF	20.73	20.73	20.66	20.718	900.0
2021-11-26	AGG	ETF	114.33	114.58	114.2	114.52	3258900.0
2021-11-26	AGGY	ETF	51.599	51.81	51.599	51.76	23600.0
2021-11-26	AGNG	ETF	28.54	28.54	27.99	28.118	4700.0
2021-11-26	AGOV	ETF	97.63	97.63	97.63	97.63	200.0
2021-11-26	AGOX	ETF	25.4	25.54	25.172	25.32	30900.0
2021-11-26	AGQ	ETF	35.75	35.75	33.81	34.44	965900.0
2021-11-26	AGZ	ETF	117.94	118.1555	117.55	117.55	5672.0
2021-11-26	AGZD	ETF	23.35	23.37	23.255	23.255	126000.0
2021-11-26	AHHX	ETF	10.26	10.26	10.195	10.195	1157.0
2021-11-26	AHYB	ETF	49.249	49.264	49.249	49.264	100.0
2021-11-26	AIA	ETF	77.91	77.91	76.7	77.17	67207.0
2021-11-26	AIEQ	ETF	42.7	43.1	42.365	42.8	29300.0
2021-11-26	AIQ	ETF	32.07	32.17	31.7	31.8	17778.0
2021-11-26	AIRR	ETF	46.11	46.12	44.89	45.582	21400.0
2021-11-26	AIVI	ETF	40.5	40.51	40.19	40.29	3500.0
2021-11-26	ALTL	ETF	44.52	44.88	44.3086	44.3556	66288.0

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

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