PREVIEW / etf_daily / 2021-11-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-29.parquet
  size:    97 KB
  rows:    2,603

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-29	SPY	ETF	464.07	466.56	461.73	464.6	86268800.0
2021-11-29	QQQ	ETF	395.89	400.73	395.14	399.69	54447106.0
2021-11-29	IWM	ETF	226.22	226.75	221.24	222.71	45982400.0
2021-11-29	DIA	ETF	352.59	352.77	348.92	351.19	5243000.0
2021-11-29	GLD	ETF	166.84	167.26	166.38	166.62	7394900.0
2021-11-29	TLT	ETF	148.31	149.64	148.17	149.32	23234200.0
2021-11-29	AAA	ETF	25.02	25.035	25.02	25.035	891.0
2021-11-29	AAAU	ETF	17.75	17.79	17.71	17.73	171900.0
2021-11-29	AADR	ETF	62.47	62.47	62.31	62.31	1000.0
2021-11-29	AAXJ	ETF	83.93	83.95	83.23	83.52	2881800.0
2021-11-29	ABEQ	ETF	27.49	27.538	27.49	27.538	600.0
2021-11-29	ACES	ETF	75.13	75.795	74.22	75.74	45700.0
2021-11-29	ACIO	ETF	31.82	31.95	31.66	31.84	56500.0
2021-11-29	ACSI	ETF	51.9	52.2617	51.9	52.1645	924.0
2021-11-29	ACT	ETF	21.78	21.78	20.81	20.93	370329.0
2021-11-29	ACTV	ETF	37.1315	37.32	37.007	37.0557	7579.0
2021-11-29	ACTX	ETF	1.65	1.8	1.65	1.65	6670.0
2021-11-29	ACVF	ETF	34.75	34.94	34.54	34.845	9400.0
2021-11-29	ACWF	ETF	38.06	38.13	37.79	38.04	37243.0
2021-11-29	ACWI	ETF	104.5	104.75	103.76	104.3	4160000.0
2021-11-29	ACWV	ETF	105.38	105.61	104.96	105.37	113700.0
2021-11-29	ACWX	ETF	55.3	55.3	54.8	55.05	1471238.0
2021-11-29	ADFI	ETF	9.52	9.62	9.52	9.6	3000.0
2021-11-29	ADIV	ETF	17.479	17.479	17.479	17.479	100.0
2021-11-29	ADME	ETF	42.26	42.28	41.9	42.14	33100.0
2021-11-29	ADRE	ETF	47.8	47.8	47.42	47.5294	5090.0
2021-11-29	AEMB	ETF	47.98	48.08	47.97	47.97	6500.0
2021-11-29	AESR	ETF	14.62	14.74	14.62	14.699	26700.0
2021-11-29	AFIF	ETF	9.54	9.56	9.54	9.555	20847.0
2021-11-29	AFK	ETF	20.27	20.55	20.27	20.37	12355.0
2021-11-29	AFLG	ETF	27.292	27.4	27.292	27.325	2300.0
2021-11-29	AFMC	ETF	26.11	26.11	26.11	26.11	300.0
2021-11-29	AFSM	ETF	27.253	27.253	27.253	27.253	100.0
2021-11-29	AFTY	ETF	20.8	20.818	20.8	20.818	500.0
2021-11-29	AGG	ETF	114.15	114.6	114.13	114.58	8982800.0
2021-11-29	AGGY	ETF	51.7	51.835	51.65	51.79	79300.0
2021-11-29	AGNG	ETF	28.111	28.111	27.88	27.88	4700.0
2021-11-29	AGOV	ETF	97.81	97.965	97.81	97.965	566.0
2021-11-29	AGOX	ETF	25.82	25.82	25.34	25.51	81900.0
2021-11-29	AGQ	ETF	34.15	34.32	33.33	33.66	737100.0
2021-11-29	AGZ	ETF	117.78	118.0432	117.78	118.01	27552.0
2021-11-29	AGZD	ETF	23.205	23.395	23.205	23.38	103400.0
2021-11-29	AHHX	ETF	10.19	10.36	10.19	10.26	9373.0
2021-11-29	AHYB	ETF	49.523	49.523	49.523	49.523	100.0
2021-11-29	AIA	ETF	77.65	77.65	76.91	77.39	53714.0
2021-11-29	AIEQ	ETF	43.13	43.225	42.91	43.15	29300.0
2021-11-29	AIQ	ETF	32.14	32.36	31.95	32.26	31364.0
2021-11-29	AIRR	ETF	46.34	46.34	45.14	45.34	58200.0
2021-11-29	AIVI	ETF	40.46	40.6	40.42	40.42	5100.0
2021-11-29	ALTL	ETF	44.74	44.92	44.48	44.8157	39024.0

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

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