PREVIEW / etf_daily / 2021-11-01

all etf daily files

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

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-01	SPY	ETF	460.3	460.7	458.2	460.04	48433600.0
2021-11-01	QQQ	ETF	386.56	387.56	384.42	387.43	30765303.0
2021-11-01	IWM	ETF	229.25	234.18	228.89	233.96	35500800.0
2021-11-01	DIA	ETF	359.45	360.05	357.98	359.13	2548400.0
2021-11-01	GLD	ETF	167.38	167.84	166.91	167.52	4975600.0
2021-11-01	TLT	ETF	145.8	146.76	145.7	146.44	18035500.0
2021-11-01	AAA	ETF	24.99	24.99	24.99	24.99	100.0
2021-11-01	AAAU	ETF	17.8	17.86	17.77	17.83	216400.0
2021-11-01	AADR	ETF	65.76	65.89	65.75	65.89	1600.0
2021-11-01	AAXJ	ETF	86.13	87.04	86.13	86.99	863700.0
2021-11-01	ABEQ	ETF	27.561	27.635	27.561	27.584	6900.0
2021-11-01	ACES	ETF	80.0	81.89	80.0	81.83	62200.0
2021-11-01	ACIO	ETF	31.68	31.68	31.52	31.589	34900.0
2021-11-01	ACSI	ETF	52.01	52.1929	52.01	52.1929	383.0
2021-11-01	ACT	ETF	22.81	23.22	22.715	23.1	140117.0
2021-11-01	ACTV	ETF	38.83	39.285	38.83	39.2679	11863.0
2021-11-01	ACTX	ETF	0.9001	0.9001	0.9	0.9	903.0
2021-11-01	ACVF	ETF	34.5	34.55	34.351	34.55	17700.0
2021-11-01	ACWF	ETF	38.08	38.2466	38.08	38.2466	18955.0
2021-11-01	ACWI	ETF	105.64	105.87	105.34	105.84	1700000.0
2021-11-01	ACWV	ETF	105.69	106.0	105.6	106.0	204500.0
2021-11-01	ACWX	ETF	57.27	57.65	57.245	57.6	1684197.0
2021-11-01	ADFI	ETF	9.65	9.65	9.645	9.645	700.0
2021-11-01	ADIV	ETF	17.676	17.676	17.676	17.676	100.0
2021-11-01	ADME	ETF	41.865	41.89	41.739	41.82	22900.0
2021-11-01	ADRE	ETF	49.56	50.455	49.56	50.455	4183.0
2021-11-01	AEMB	ETF	48.76	48.76	48.76	48.76	100.0
2021-11-01	AESR	ETF	14.65	14.65	14.57	14.621	4900.0
2021-11-01	AFIF	ETF	9.61	9.61	9.6	9.61	1116.0
2021-11-01	AFK	ETF	21.49	21.6399	21.49	21.52	5070.0
2021-11-01	AFLG	ETF	26.83	26.874	26.83	26.874	200.0
2021-11-01	AFMC	ETF	26.382	26.382	26.382	26.382	100.0
2021-11-01	AFSM	ETF	27.717	27.717	27.717	27.717	100.0
2021-11-01	AFTY	ETF	21.36	21.36	21.302	21.328	4600.0
2021-11-01	AGG	ETF	114.16	114.42	114.14	114.39	6197900.0
2021-11-01	AGGY	ETF	51.81	51.84	51.72	51.84	184900.0
2021-11-01	AGNG	ETF	29.82	29.979	29.82	29.93	6600.0
2021-11-01	AGOV	ETF	98.68	98.69	98.625	98.625	984.0
2021-11-01	AGOX	ETF	27.47	27.47	27.2	27.29	45000.0
2021-11-01	AGQ	ETF	37.68	37.91	37.39	37.67	427700.0
2021-11-01	AGZ	ETF	117.71	117.93	117.7	117.85	29518.0
2021-11-01	AGZD	ETF	23.42	23.445	23.42	23.445	30200.0
2021-11-01	AIA	ETF	79.89	81.0	79.89	80.99	54685.0
2021-11-01	AIEQ	ETF	43.31	43.65	43.15	43.54	19000.0
2021-11-01	AIQ	ETF	31.77	31.98	31.7514	31.98	46915.0
2021-11-01	AIRR	ETF	44.17	45.19	44.17	45.19	49500.0
2021-11-01	AIVI	ETF	41.61	41.69	41.57	41.69	7500.0
2021-11-01	ALTL	ETF	43.75	44.2263	43.68	44.2223	23945.0
2021-11-01	ALTY	ETF	13.66	13.74	13.62	13.72	62000.0
2021-11-01	AMJ	ETF	19.06	19.49	19.06	19.45	511428.0

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

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