PREVIEW / etf_daily / 2021-11-15

all etf daily files

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

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-15	SPY	ETF	468.64	468.81	466.23	467.43	46980500.0
2021-11-15	QQQ	ETF	395.91	396.24	392.095	394.61	33716861.0
2021-11-15	IWM	ETF	240.57	240.76	237.55	238.55	27390000.0
2021-11-15	DIA	ETF	362.6	362.73	360.67	361.24	2555000.0
2021-11-15	GLD	ETF	174.1	174.59	173.69	174.18	5630800.0
2021-11-15	TLT	ETF	146.89	146.96	145.22	145.48	15232700.0
2021-11-15	AAA	ETF	25.02	25.04	25.02	25.04	493.0
2021-11-15	AAAU	ETF	18.53	18.57	18.48	18.53	272200.0
2021-11-15	AADR	ETF	65.36	65.53	65.36	65.53	1400.0
2021-11-15	AAXJ	ETF	88.03	88.3	87.64	87.69	554500.0
2021-11-15	ABEQ	ETF	28.345	28.345	28.23	28.236	3200.0
2021-11-15	ACES	ETF	80.86	80.86	79.216	79.98	38900.0
2021-11-15	ACIO	ETF	32.041	32.1	31.98	32.02	59400.0
2021-11-15	ACSI	ETF	53.314	53.314	53.0502	53.06	2118.0
2021-11-15	ACT	ETF	22.48	22.81	22.4066	22.8	233723.0
2021-11-15	ACTV	ETF	38.95	39.14	38.95	38.9657	5454.0
2021-11-15	ACTX	ETF	1.01	1.01	1.01	1.01	329.0
2021-11-15	ACVF	ETF	35.33	35.33	35.08	35.12	21200.0
2021-11-15	ACWF	ETF	39.205	39.23	38.9968	38.9968	7106.0
2021-11-15	ACWI	ETF	107.29	107.3	106.84	107.01	2585500.0
2021-11-15	ACWV	ETF	107.31	107.54	107.28	107.35	74500.0
2021-11-15	ACWX	ETF	57.98	58.08	57.77	57.81	623126.0
2021-11-15	ADFI	ETF	9.65	9.65	9.625	9.625	600.0
2021-11-15	ADIV	ETF	17.905	17.905	17.905	17.905	100.0
2021-11-15	ADME	ETF	42.67	42.67	42.53	42.53	18000.0
2021-11-15	ADRE	ETF	51.36	51.36	50.957	50.971	4143.0
2021-11-15	AEMB	ETF	48.7	48.7	48.7	48.7	100.0
2021-11-15	AESR	ETF	14.79	14.83	14.79	14.804	13100.0
2021-11-15	AFIF	ETF	9.5992	9.6051	9.58	9.582	30594.0
2021-11-15	AFK	ETF	21.79	21.81	21.69	21.75	6478.0
2021-11-15	AFLG	ETF	27.457	27.457	27.457	27.457	100.0
2021-11-15	AFMC	ETF	27.132	27.132	27.132	27.132	100.0
2021-11-15	AFSM	ETF	28.82	28.82	28.75	28.79	2200.0
2021-11-15	AFTY	ETF	21.09	21.09	21.04	21.04	1900.0
2021-11-15	AGG	ETF	114.3	114.31	113.9	113.9	6405000.0
2021-11-15	AGGY	ETF	51.8	51.804	51.61	51.61	74000.0
2021-11-15	AGNG	ETF	30.0	30.0	29.71	29.737	6400.0
2021-11-15	AGOV	ETF	98.85	98.965	98.78	98.965	3013.0
2021-11-15	AGOX	ETF	26.37	26.48	26.321	26.4	48300.0
2021-11-15	AGQ	ETF	40.85	41.25	40.36	40.99	785700.0
2021-11-15	AGZ	ETF	117.81	117.88	117.6928	117.73	22972.0
2021-11-15	AGZD	ETF	23.38	23.445	23.38	23.435	30200.0
2021-11-15	AHHX	ETF	10.395	10.395	10.395	10.395	3.0
2021-11-15	AIA	ETF	82.22	82.26	81.63	81.8	125439.0
2021-11-15	AIEQ	ETF	44.65	44.65	44.16	44.52	34700.0
2021-11-15	AIQ	ETF	33.2	33.2	32.94	32.99	26052.0
2021-11-15	AIRR	ETF	47.69	47.69	47.13	47.316	20800.0
2021-11-15	AIVI	ETF	41.65	41.65	41.44	41.44	3900.0
2021-11-15	ALTL	ETF	44.77	44.98	44.7307	44.84	43091.0
2021-11-15	ALTY	ETF	13.59	13.59	13.55	13.56	12000.0

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

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