PREVIEW / etf_daily / 2021-09-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-01.parquet
  size:    92 KB
  rows:    2,456

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-09-01	SPY	ETF	452.56	453.11	451.55	451.8	48721400.0
2021-09-01	QQQ	ETF	381.04	382.71	380.37	380.58	28138311.0
2021-09-01	IWM	ETF	226.83	228.24	224.87	227.44	20451500.0
2021-09-01	DIA	ETF	354.29	354.35	353.29	353.55	2739200.0
2021-09-01	GLD	ETF	169.94	170.0	169.16	169.7	4764900.0
2021-09-01	TLT	ETF	149.27	149.39	148.49	148.89	10807100.0
2021-09-01	AAA	ETF	24.9907	25.0	24.9907	25.0	220.0
2021-09-01	AAAU	ETF	18.06	18.08	18.0	18.05	266500.0
2021-09-01	AADR	ETF	68.72	68.89	68.72	68.89	1100.0
2021-09-01	AAXJ	ETF	89.28	90.23	89.28	89.92	646000.0
2021-09-01	ABEQ	ETF	27.813	27.91	27.813	27.868	16000.0
2021-09-01	ACES	ETF	70.88	71.82	70.88	71.28	163600.0
2021-09-01	ACIO	ETF	31.26	31.26	31.105	31.15	221000.0
2021-09-01	ACSI	ETF	51.68	51.68	51.5857	51.5857	519.0
2021-09-01	ACTV	ETF	38.56	38.86	38.44	38.6	17324.0
2021-09-01	ACTX	ETF	1.25	1.25	1.25	1.25	2031.0
2021-09-01	ACVF	ETF	33.62	33.62	33.4	33.458	27900.0
2021-09-01	ACWF	ETF	38.9101	39.16	38.9101	39.0463	3965.0
2021-09-01	ACWI	ETF	104.7	105.09	104.69	104.76	2981600.0
2021-09-01	ACWV	ETF	107.09	107.54	107.09	107.34	170600.0
2021-09-01	ACWX	ETF	57.8	58.12	57.77	57.95	1393299.0
2021-09-01	ADFI	ETF	9.76	9.78	9.75	9.775	2100.0
2021-09-01	ADIV	ETF	18.19	18.19	18.19	18.19	100.0
2021-09-01	ADME	ETF	41.58	41.58	41.36	41.36	43400.0
2021-09-01	ADRE	ETF	52.59	53.36	52.59	53.1014	9514.0
2021-09-01	AESR	ETF	14.33	14.34	14.28	14.28	1400.0
2021-09-01	AFIF	ETF	9.7	9.71	9.69	9.7	31347.0
2021-09-01	AFK	ETF	22.08	22.08	21.9001	22.07	7215.0
2021-09-01	AFLG	ETF	26.65	26.71	26.65	26.69	500.0
2021-09-01	AFMC	ETF	26.109	26.109	26.109	26.109	100.0
2021-09-01	AFSM	ETF	26.89	26.9	26.836	26.836	1800.0
2021-09-01	AFTY	ETF	20.16	20.35	20.16	20.35	800.0
2021-09-01	AGG	ETF	116.02	116.02	115.81	115.93	4154000.0
2021-09-01	AGGY	ETF	52.69	52.69	52.551	52.625	71500.0
2021-09-01	AGNG	ETF	31.041	31.15	31.04	31.14	2900.0
2021-09-01	AGOV	ETF	101.095	101.12	101.095	101.12	202.0
2021-09-01	AGOX	ETF	26.85	26.85	26.6	26.77	33500.0
2021-09-01	AGQ	ETF	38.53	38.95	38.35	38.61	707400.0
2021-09-01	AGZ	ETF	119.14	119.2	119.12	119.2	21657.0
2021-09-01	AGZD	ETF	23.435	23.445	23.39	23.39	51800.0
2021-09-01	AIA	ETF	83.95	84.95	83.95	84.72	85163.0
2021-09-01	AIEQ	ETF	43.0	43.41	42.92	43.3	13000.0
2021-09-01	AIQ	ETF	31.92	32.2	31.92	32.0	51621.0
2021-09-01	AIRR	ETF	42.54	42.54	42.03	42.36	24300.0
2021-09-01	AIVI	ETF	43.43	43.58	43.43	43.47	17200.0
2021-09-01	ALTL	ETF	43.72	43.72	43.35	43.61	89875.0
2021-09-01	ALTY	ETF	13.77	13.84	13.77	13.825	9400.0
2021-09-01	AMJ	ETF	17.62	17.885	17.5	17.83	401431.0
2021-09-01	AMLP	ETF	32.37	32.9	32.14	32.9	1702000.0
2021-09-01	AMNA	ETF	31.9397	31.9397	31.9397	31.9397	62.0

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

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