PREVIEW / etf_daily / 2021-11-04

all etf daily files

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

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-04	SPY	ETF	465.36	467.0	464.99	466.91	52847100.0
2021-11-04	QQQ	ETF	394.48	399.2	393.92	398.22	40265313.0
2021-11-04	IWM	ETF	239.48	240.94	237.56	238.55	26514000.0
2021-11-04	DIA	ETF	361.34	361.65	359.87	361.35	3870900.0
2021-11-04	GLD	ETF	167.51	168.14	167.37	167.65	6656100.0
2021-11-04	TLT	ETF	145.87	147.36	145.85	147.1	15922400.0
2021-11-04	AAA	ETF	24.99	24.99	24.99	24.99	108.0
2021-11-04	AAAU	ETF	17.81	17.89	17.81	17.83	237000.0
2021-11-04	AADR	ETF	65.81	65.81	65.2	65.5	1300.0
2021-11-04	AAXJ	ETF	86.39	86.71	85.88	86.28	769500.0
2021-11-04	ABEQ	ETF	27.929	27.945	27.822	27.822	1100.0
2021-11-04	ACES	ETF	81.18	81.18	79.96	80.76	43100.0
2021-11-04	ACIO	ETF	31.805	31.91	31.799	31.878	19400.0
2021-11-04	ACSI	ETF	53.2209	53.2209	53.2209	53.2209	280.0
2021-11-04	ACT	ETF	23.2	24.0	23.14	23.52	245237.0
2021-11-04	ACTV	ETF	39.52	39.64	39.185	39.2335	3041.0
2021-11-04	ACTX	ETF	0.8375	1.01	0.8375	1.01	576.0
2021-11-04	ACVF	ETF	34.98	35.162	34.97	35.13	11000.0
2021-11-04	ACWF	ETF	38.57	38.7	38.4313	38.68	90927.0
2021-11-04	ACWI	ETF	106.61	106.87	106.42	106.81	2515300.0
2021-11-04	ACWV	ETF	106.58	106.83	106.36	106.78	164700.0
2021-11-04	ACWX	ETF	57.7	57.71	57.465	57.68	738840.0
2021-11-04	ADFI	ETF	9.69	9.71	9.69	9.7	10500.0
2021-11-04	ADIV	ETF	17.602	17.602	17.602	17.602	100.0
2021-11-04	ADME	ETF	42.235	42.38	42.215	42.38	13500.0
2021-11-04	ADRE	ETF	50.0	50.21	49.645	49.9875	5026.0
2021-11-04	AEMB	ETF	49.01	49.04	48.965	48.965	6200.0
2021-11-04	AESR	ETF	14.8	14.85	14.8	14.82	15900.0
2021-11-04	AFIF	ETF	9.6463	9.6697	9.6336	9.6619	56759.0
2021-11-04	AFK	ETF	21.72	21.77	21.61	21.61	8351.0
2021-11-04	AFLG	ETF	27.265	27.265	27.192	27.192	200.0
2021-11-04	AFSM	ETF	28.447	28.447	28.447	28.447	100.0
2021-11-04	AFTY	ETF	21.11	21.11	20.95	20.957	3500.0
2021-11-04	AGG	ETF	114.51	114.84	114.48	114.77	6618100.0
2021-11-04	AGGY	ETF	51.87	52.09	51.87	52.05	82800.0
2021-11-04	AGNG	ETF	30.47	30.47	30.33	30.391	2800.0
2021-11-04	AGOV	ETF	98.8	98.8	98.6518	98.6518	805.0
2021-11-04	AGOX	ETF	26.7	26.7	26.03	26.1	86600.0
2021-11-04	AGQ	ETF	37.2	37.66	36.75	36.86	1112000.0
2021-11-04	AGZ	ETF	117.99	118.25	117.99	118.18	30917.0
2021-11-04	AGZD	ETF	23.475	23.475	23.4	23.41	97400.0
2021-11-04	AIA	ETF	80.6	80.6	79.815	80.24	33141.0
2021-11-04	AIEQ	ETF	44.39	44.56	44.227	44.37	12900.0
2021-11-04	AIQ	ETF	32.51	32.79	32.5	32.7399	21037.0
2021-11-04	AIRR	ETF	45.37	45.65	45.2	45.51	50800.0
2021-11-04	AIVI	ETF	41.69	41.69	41.54	41.66	11200.0
2021-11-04	ALTL	ETF	44.5	44.5499	44.25	44.449	106649.0
2021-11-04	ALTY	ETF	13.62	13.65	13.56	13.574	30300.0
2021-11-04	AMJ	ETF	19.4	19.45	18.79	19.01	436983.0
2021-11-04	AMLP	ETF	35.75	35.85	34.68	35.2	1787000.0

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

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