PREVIEW / etf_daily / 2021-08-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-16.parquet
  size:    92 KB
  rows:    2,438

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-08-16	SPY	ETF	444.53	447.11	442.87	446.97	73740000.0
2021-08-16	QQQ	ETF	367.67	369.02	363.7	368.98	35044107.0
2021-08-16	IWM	ETF	219.77	220.26	217.65	219.07	24074400.0
2021-08-16	DIA	ETF	354.41	356.6	352.66	356.57	3634600.0
2021-08-16	GLD	ETF	166.73	167.39	166.59	167.22	7776500.0
2021-08-16	TLT	ETF	149.19	150.02	148.81	148.91	19170900.0
2021-08-16	AAA	ETF	25.01	25.015	25.0	25.015	1241.0
2021-08-16	AAAU	ETF	17.73	17.8	17.71	17.79	134300.0
2021-08-16	AADR	ETF	68.8	68.8	67.67	68.14	1700.0
2021-08-16	AAXJ	ETF	86.94	86.95	86.38	86.95	1265300.0
2021-08-16	ABEQ	ETF	28.01	28.02	28.001	28.001	2300.0
2021-08-16	ACES	ETF	69.6	69.6	68.22	68.379	58300.0
2021-08-16	ACIO	ETF	30.77	31.04	30.77	31.04	40700.0
2021-08-16	ACSI	ETF	51.6203	51.6203	51.6203	51.6203	60.0
2021-08-16	ACTV	ETF	38.345	38.43	38.3128	38.3128	2316.0
2021-08-16	ACTX	ETF	1.5	1.5	1.5	1.5	209.0
2021-08-16	ACVF	ETF	33.08	33.126	32.84	33.126	3100.0
2021-08-16	ACWF	ETF	38.66	38.85	38.5593	38.85	14048.0
2021-08-16	ACWI	ETF	103.27	103.62	102.81	103.62	2426100.0
2021-08-16	ACWV	ETF	105.8	106.5	105.78	106.47	77600.0
2021-08-16	ACWX	ETF	57.1	57.17	56.885	57.16	631683.0
2021-08-16	ADFI	ETF	9.76	9.76	9.675	9.732	4200.0
2021-08-16	ADIV	ETF	18.28	18.28	18.28	18.28	100.0
2021-08-16	ADME	ETF	40.59	40.9	40.535	40.9	26900.0
2021-08-16	ADRE	ETF	51.63	51.63	51.1053	51.1384	5737.0
2021-08-16	AEMB	ETF	50.03	50.03	50.03	50.03	100.0
2021-08-16	AESR	ETF	14.05	14.13	14.04	14.13	5000.0
2021-08-16	AFIF	ETF	9.6907	9.7	9.68	9.685	20282.0
2021-08-16	AFK	ETF	21.82	21.875	21.62	21.76	10410.0
2021-08-16	AFLG	ETF	26.34	26.561	26.34	26.561	500.0
2021-08-16	AFMC	ETF	25.826	25.826	25.826	25.826	100.0
2021-08-16	AFSM	ETF	26.259	26.27	26.168	26.168	600.0
2021-08-16	AFTY	ETF	21.07	21.07	20.945	20.99	1600.0
2021-08-16	AGG	ETF	116.14	116.27	116.03	116.03	3693600.0
2021-08-16	AGGY	ETF	52.71	52.8	52.69	52.699	53700.0
2021-08-16	AGNG	ETF	30.4	30.51	30.299	30.51	2400.0
2021-08-16	AGOV	ETF	100.0	100.0	99.7	99.85	10124.0
2021-08-16	AGOX	ETF	26.1	26.31	26.09	26.29	16100.0
2021-08-16	AGQ	ETF	37.27	37.81	36.94	37.71	599100.0
2021-08-16	AGZ	ETF	119.275	119.275	119.16	119.16	18678.0
2021-08-16	AGZD	ETF	23.425	23.46	23.405	23.435	7400.0
2021-08-16	AIA	ETF	82.04	82.11	81.64	82.11	143500.0
2021-08-16	AIEQ	ETF	41.76	41.76	41.155	41.485	34800.0
2021-08-16	AIQ	ETF	30.7	30.7	30.37	30.62	16708.0
2021-08-16	AIRR	ETF	42.09	42.17	41.67	42.01	20800.0
2021-08-16	AIVI	ETF	43.86	44.03	43.86	44.03	3800.0
2021-08-16	ALTL	ETF	43.17	43.69	43.17	43.69	142353.0
2021-08-16	ALTY	ETF	13.7	13.76	13.69	13.75	20300.0
2021-08-16	AMJ	ETF	17.92	18.17	17.81	18.08	308098.0
2021-08-16	AMLP	ETF	32.59	32.94	32.28	32.67	1469400.0

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

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