PREVIEW / etf_daily / 2021-12-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-16.parquet
  size:    98 KB
  rows:    2,606

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-12-16	SPY	ETF	472.57	472.87	464.8	466.45	116568600.0
2021-12-16	QQQ	ETF	398.04	398.475	385.21	386.84	82591368.0
2021-12-16	IWM	ETF	219.45	219.9	212.25	213.18	52743800.0
2021-12-16	DIA	ETF	361.27	362.51	358.31	359.44	9493700.0
2021-12-16	GLD	ETF	167.01	168.18	166.94	168.16	11186200.0
2021-12-16	TLT	ETF	148.75	149.88	148.73	149.14	18677900.0
2021-12-16	AAA	ETF	25.06	25.06	25.04	25.045	4325.0
2021-12-16	AAAU	ETF	17.76	17.89	17.76	17.89	274200.0
2021-12-16	AADR	ETF	62.96	62.96	62.43	62.43	2100.0
2021-12-16	AAXJ	ETF	82.59	82.85	81.73	81.81	1200700.0
2021-12-16	ABEQ	ETF	28.18	28.18	28.12	28.139	700.0
2021-12-16	ACES	ETF	66.44	66.94	63.66	63.95	304900.0
2021-12-16	ACIO	ETF	32.25	32.27	31.974	32.044	67400.0
2021-12-16	ACSI	ETF	51.6246	51.6246	51.6246	51.6246	6.0
2021-12-16	ACT	ETF	21.29	21.9	20.4105	20.61	266418.0
2021-12-16	ACTV	ETF	38.46	38.46	37.62	37.749	5263.0
2021-12-16	ACTX	ETF	1.12	1.4	1.12	1.4	2175.0
2021-12-16	ACVF	ETF	35.34	35.34	34.7	34.88	6300.0
2021-12-16	ACWF	ETF	38.43	38.43	37.9119	38.06	10272.0
2021-12-16	ACWI	ETF	104.89	104.98	103.38	103.79	4886500.0
2021-12-16	ACWV	ETF	107.01	107.45	106.95	107.25	127100.0
2021-12-16	ACWX	ETF	55.17	55.27	54.73	54.89	3302668.0
2021-12-16	ADFI	ETF	9.58	9.6	9.575	9.575	600.0
2021-12-16	ADIV	ETF	16.131	16.131	16.02	16.02	800.0
2021-12-16	ADME	ETF	42.81	42.819	42.28	42.35	99200.0
2021-12-16	ADRE	ETF	46.14	46.536	45.63	45.815	9861.0
2021-12-16	AESR	ETF	13.85	13.85	13.66	13.68	10100.0
2021-12-16	AFIF	ETF	9.57	9.57	9.56	9.57	19040.0
2021-12-16	AFK	ETF	20.55	20.55	20.4	20.4	2374.0
2021-12-16	AFLG	ETF	27.679	27.679	27.679	27.679	100.0
2021-12-16	AFMC	ETF	25.856	25.856	25.856	25.856	100.0
2021-12-16	AFSM	ETF	26.5	26.5	26.478	26.478	2400.0
2021-12-16	AFTY	ETF	22.02	22.02	21.774	21.774	2900.0
2021-12-16	AGG	ETF	114.26	114.48	114.26	114.36	7566600.0
2021-12-16	AGGY	ETF	51.76	51.909	51.76	51.836	144600.0
2021-12-16	AGNG	ETF	28.48	28.58	28.22	28.3	7600.0
2021-12-16	AGOV	ETF	98.54	98.54	98.38	98.38	225.0
2021-12-16	AGOX	ETF	26.0	26.0	24.93	24.93	34800.0
2021-12-16	AGQ	ETF	31.85	32.55	31.82	32.38	1063900.0
2021-12-16	AGZ	ETF	117.37	117.5845	117.37	117.56	34069.0
2021-12-16	AGZD	ETF	23.5	23.5	23.305	23.33	70000.0
2021-12-16	AHHX	ETF	10.17	10.47	10.17	10.325	7468.0
2021-12-16	AHYB	ETF	49.72	49.72	49.72	49.72	100.0
2021-12-16	AIA	ETF	76.8	77.09	75.75	75.95	139424.0
2021-12-16	AIEQ	ETF	41.57	41.694	40.84	41.027	17400.0
2021-12-16	AIQ	ETF	31.94	31.94	31.01	31.19	38970.0
2021-12-16	AIRR	ETF	44.91	44.91	43.699	43.89	24900.0
2021-12-16	AIVI	ETF	41.66	41.75	41.57	41.65	6500.0
2021-12-16	ALTL	ETF	44.95	44.97	43.73	43.85	121829.0
2021-12-16	ALTY	ETF	13.32	13.35	13.275	13.29	12700.0

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

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