PREVIEW / etf_daily / 2021-02-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-24.parquet
  size:    86 KB
  rows:    2,268

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-02-24	SPY	ETF	386.33	392.23	385.27	391.77	72433900.0
2021-02-24	QQQ	ETF	318.74	324.45	315.96	324.13	58206272.0
2021-02-24	IWM	ETF	222.62	227.45	221.71	227.0	27584900.0
2021-02-24	DIA	ETF	314.68	320.04	314.18	319.53	4290300.0
2021-02-24	GLD	ETF	167.65	169.14	167.15	169.0	8890600.0
2021-02-24	TLT	ETF	139.35	141.18	139.16	140.84	17363100.0
2021-02-24	AAA	ETF	25.0797	25.08	25.0685	25.07	1610.0
2021-02-24	AAAU	ETF	17.8	17.96	17.76	17.95	982500.0
2021-02-24	AADR	ETF	64.21	65.0	64.21	65.0	2700.0
2021-02-24	AAXJ	ETF	97.34	97.72	96.25	97.66	3583000.0
2021-02-24	ABEQ	ETF	25.945	26.05	25.945	26.039	4400.0
2021-02-24	ACES	ETF	84.02	85.52	82.055	85.52	111500.0
2021-02-24	ACIO	ETF	27.602	27.81	27.56	27.81	34600.0
2021-02-24	ACSI	ETF	45.4505	45.512	45.4505	45.512	688.0
2021-02-24	ACTV	ETF	35.26	35.4595	35.195	35.4595	1212.0
2021-02-24	ACTX	ETF	5.0	5.0	5.0	5.0	728.0
2021-02-24	ACVF	ETF	28.82	29.23	28.82	29.21	2300.0
2021-02-24	ACWF	ETF	35.45	35.93	35.45	35.93	9576.0
2021-02-24	ACWI	ETF	94.33	95.56	94.04	95.45	5469700.0
2021-02-24	ACWV	ETF	95.87	96.46	95.52	96.24	351000.0
2021-02-24	ACWX	ETF	55.58	56.24	55.42	56.17	1389526.0
2021-02-24	ADFI	ETF	9.739	9.739	9.739	9.739	600.0
2021-02-24	ADME	ETF	36.45	36.55	36.025	36.55	33200.0
2021-02-24	ADRE	ETF	62.05	62.73	61.4121	62.62	27928.0
2021-02-24	AESR	ETF	12.26	12.41	12.24	12.385	180900.0
2021-02-24	AFIF	ETF	9.7	9.74	9.69	9.72	61712.0
2021-02-24	AFK	ETF	21.61	22.12	21.61	22.12	10231.0
2021-02-24	AFLG	ETF	23.438	23.438	23.438	23.438	1700.0
2021-02-24	AFMC	ETF	23.95	23.95	23.945	23.945	200.0
2021-02-24	AFSM	ETF	25.582	25.582	25.582	25.582	100.0
2021-02-24	AFTY	ETF	24.59	24.81	24.5	24.81	9400.0
2021-02-24	AGG	ETF	115.06	115.5	115.01	115.47	6232300.0
2021-02-24	AGGY	ETF	51.97	52.152	51.87	52.07	188100.0
2021-02-24	AGNG	ETF	28.21	28.6	28.21	28.6	206000.0
2021-02-24	AGQ	ETF	52.67	54.63	52.11	54.55	1116400.0
2021-02-24	AGZ	ETF	118.58	118.64	118.503	118.61	28014.0
2021-02-24	AGZD	ETF	23.615	23.615	23.58	23.585	25400.0
2021-02-24	AIA	ETF	96.75	97.76	95.94	97.7	197166.0
2021-02-24	AIEQ	ETF	39.33	40.0	38.815	40.0	45300.0
2021-02-24	AIQ	ETF	29.25	29.55	28.96	29.55	69141.0
2021-02-24	AIRR	ETF	39.18	40.009	39.095	39.85	68100.0
2021-02-24	AIVI	ETF	42.37	42.81	42.31	42.79	8200.0
2021-02-24	ALTL	ETF	38.2289	39.1143	38.2289	39.0851	10960.0
2021-02-24	ALTY	ETF	12.381	12.57	12.38	12.55	20900.0
2021-02-24	AMJ	ETF	16.06	16.61	16.05	16.52	677087.0
2021-02-24	AMLP	ETF	28.98	30.0	28.92	29.84	3123700.0
2021-02-24	AMNA	ETF	29.2382	29.2382	29.2382	29.2382	2.0
2021-02-24	AMND	ETF	30.9439	30.9439	30.9439	30.9439	0.0
2021-02-24	AMOM	ETF	32.81	33.33	32.81	33.32	3200.0
2021-02-24	AMPS	ETF	10.53	10.63	10.45	10.62	64120.0

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

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