PREVIEW / etf_daily / 2021-11-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-24.parquet
  size:    97 KB
  rows:    2,585

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-24	SPY	ETF	466.06	469.57	465.19	469.44	61858800.0
2021-11-24	QQQ	ETF	394.93	399.05	392.54	398.76	46954382.0
2021-11-24	IWM	ETF	229.39	231.99	228.54	231.58	24099300.0
2021-11-24	DIA	ETF	356.06	358.2	355.8	358.03	4246700.0
2021-11-24	GLD	ETF	166.58	167.44	166.32	167.12	5359500.0
2021-11-24	TLT	ETF	144.94	146.82	144.79	146.82	13769700.0
2021-11-24	AAA	ETF	25.03	25.0399	25.025	25.025	496.0
2021-11-24	AAAU	ETF	17.73	17.81	17.7	17.78	269900.0
2021-11-24	AADR	ETF	62.73	63.21	62.64	63.13	1700.0
2021-11-24	AAXJ	ETF	85.53	85.98	85.36	85.94	1571900.0
2021-11-24	ABEQ	ETF	27.93	27.932	27.9	27.932	800.0
2021-11-24	ACES	ETF	75.88	77.235	75.095	76.96	47500.0
2021-11-24	ACIO	ETF	32.03	32.1	31.84	32.05	13300.0
2021-11-24	ACSI	ETF	52.9161	52.9161	52.9161	52.9161	146.0
2021-11-24	ACT	ETF	21.39	21.99	21.25	21.64	158529.0
2021-11-24	ACTV	ETF	38.12	38.35	38.12	38.2475	4469.0
2021-11-24	ACTX	ETF	1.8	1.8	1.65	1.65	8409.0
2021-11-24	ACVF	ETF	34.84	35.13	34.84	35.13	3200.0
2021-11-24	ACWF	ETF	38.4	38.59	38.35	38.59	4335.0
2021-11-24	ACWI	ETF	105.21	105.99	105.03	105.95	2439700.0
2021-11-24	ACWV	ETF	105.9	106.36	105.81	106.31	100700.0
2021-11-24	ACWX	ETF	56.0	56.4	55.94	56.39	1446398.0
2021-11-24	ADFI	ETF	9.53	9.56	9.53	9.56	300.0
2021-11-24	ADIV	ETF	17.825	17.825	17.825	17.825	100.0
2021-11-24	ADME	ETF	42.45	42.54	42.17	42.5	10300.0
2021-11-24	ADRE	ETF	48.41	48.87	48.3427	48.87	50689.0
2021-11-24	AEMB	ETF	48.101	48.101	48.101	48.101	100.0
2021-11-24	AESR	ETF	14.76	14.87	14.76	14.856	7300.0
2021-11-24	AFIF	ETF	9.57	9.59	9.57	9.59	16031.0
2021-11-24	AFK	ETF	20.7	20.73	20.5933	20.73	5665.0
2021-11-24	AFLG	ETF	27.47	27.53	27.47	27.526	1000.0
2021-11-24	AFMC	ETF	26.858	26.858	26.858	26.858	100.0
2021-11-24	AFTY	ETF	21.147	21.147	21.147	21.147	100.0
2021-11-24	AGG	ETF	113.47	113.73	113.39	113.71	8472400.0
2021-11-24	AGGY	ETF	51.25	51.39	51.25	51.387	60400.0
2021-11-24	AGNG	ETF	28.53	28.657	28.39	28.657	54000.0
2021-11-24	AGOV	ETF	97.59	97.59	97.59	97.59	1.0
2021-11-24	AGOX	ETF	25.6	26.04	25.6	26.03	32600.0
2021-11-24	AGQ	ETF	35.61	35.9	35.37	35.78	392500.0
2021-11-24	AGZ	ETF	117.29	117.47	117.29	117.47	23140.0
2021-11-24	AGZD	ETF	23.42	23.42	23.36	23.37	26200.0
2021-11-24	AHHX	ETF	10.31	10.43	10.15	10.285	12499.0
2021-11-24	AHYB	ETF	49.669	49.669	49.669	49.669	100.0
2021-11-24	AIA	ETF	79.35	79.635	79.0233	79.55	37179.0
2021-11-24	AIEQ	ETF	43.11	43.66	43.02	43.52	20300.0
2021-11-24	AIQ	ETF	32.01	32.43	31.9	32.43	14603.0
2021-11-24	AIRR	ETF	47.13	47.349	46.95	47.18	23700.0
2021-11-24	AIVI	ETF	41.04	41.27	41.04	41.27	5700.0
2021-11-24	ALTL	ETF	45.1	45.1	44.86	45.061	26221.0
2021-11-24	ALTY	ETF	13.4	13.48	13.367	13.431	23300.0

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

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