PREVIEW / etf_daily / 2021-12-06

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-06.parquet
  size:    97 KB
  rows:    2,589

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-06	SPY	ETF	456.13	460.79	453.56	458.79	98977500.0
2021-12-06	QQQ	ETF	383.63	387.6	379.3	386.2	67588801.0
2021-12-06	IWM	ETF	216.54	220.69	213.71	219.02	43878300.0
2021-12-06	DIA	ETF	349.26	354.02	348.83	352.82	7026500.0
2021-12-06	GLD	ETF	166.14	166.8	165.93	166.22	4813600.0
2021-12-06	TLT	ETF	154.05	154.35	151.93	152.23	30924200.0
2021-12-06	AAA	ETF	25.01	25.01	25.01	25.01	227.0
2021-12-06	AAAU	ETF	17.67	17.74	17.66	17.68	182500.0
2021-12-06	AADR	ETF	61.59	61.74	61.38	61.6	6200.0
2021-12-06	AAXJ	ETF	82.89	83.81	82.58	83.81	1059900.0
2021-12-06	ABEQ	ETF	27.12	27.53	27.12	27.448	5900.0
2021-12-06	ACES	ETF	67.88	69.05	65.72	68.5	119900.0
2021-12-06	ACIO	ETF	31.32	31.74	31.26	31.62	677400.0
2021-12-06	ACSI	ETF	51.3052	51.3052	51.3052	51.3052	72.0
2021-12-06	ACT	ETF	21.11	21.595	21.01	21.33	143507.0
2021-12-06	ACTV	ETF	37.72	38.16	37.72	37.8096	5495.0
2021-12-06	ACTX	ETF	1.2	1.2	1.1899	1.1899	502.0
2021-12-06	ACVF	ETF	33.93	34.4	33.93	34.258	3300.0
2021-12-06	ACWF	ETF	37.72	38.0	37.65	37.87	18520.0
2021-12-06	ACWI	ETF	102.81	103.69	102.25	103.36	6256200.0
2021-12-06	ACWV	ETF	104.96	105.34	104.81	105.14	115900.0
2021-12-06	ACWX	ETF	54.92	55.259	54.735	55.22	2220614.0
2021-12-06	ADFI	ETF	9.64	9.64	9.635	9.635	600.0
2021-12-06	ADIV	ETF	15.66	15.8	15.66	15.79	1500.0
2021-12-06	ADME	ETF	41.485	41.92	41.485	41.78	591500.0
2021-12-06	ADRE	ETF	45.58	46.3199	45.31	46.31	7844.0
2021-12-06	AEMB	ETF	48.34	48.34	48.34	48.34	100.0
2021-12-06	AESR	ETF	14.277	14.51	14.277	14.453	2500.0
2021-12-06	AFIF	ETF	9.56	9.57	9.56	9.57	7512.0
2021-12-06	AFK	ETF	20.25	20.25	20.0	20.21	6835.0
2021-12-06	AFLG	ETF	27.025	27.025	27.025	27.025	100.0
2021-12-06	AFMC	ETF	25.92	25.92	25.843	25.843	200.0
2021-12-06	AFTY	ETF	21.2	21.4	21.2	21.388	1700.0
2021-12-06	AGG	ETF	114.98	115.04	114.62	114.67	9416700.0
2021-12-06	AGGY	ETF	52.12	52.16	51.98	52.01	78200.0
2021-12-06	AGNG	ETF	27.55	27.59	27.22	27.4	24900.0
2021-12-06	AGOV	ETF	97.83	97.83	97.83	97.83	1.0
2021-12-06	AGOX	ETF	25.87	25.87	24.83	24.94	53100.0
2021-12-06	AGQ	ETF	31.62	32.28	31.41	32.22	590600.0
2021-12-06	AGZ	ETF	117.81	117.81	117.55	117.66	21010.0
2021-12-06	AGZD	ETF	23.36	23.365	23.28	23.355	47200.0
2021-12-06	AHHX	ETF	10.38	10.395	10.145	10.275	3658.0
2021-12-06	AHYB	ETF	49.815	49.815	49.815	49.815	100.0
2021-12-06	AIA	ETF	76.89	78.02	76.64	77.98	74108.0
2021-12-06	AIEQ	ETF	41.0	41.57	40.38	41.375	26100.0
2021-12-06	AIQ	ETF	30.83	31.0299	30.35	30.96	78461.0
2021-12-06	AIRR	ETF	44.81	45.167	44.5	45.01	24400.0
2021-12-06	AIVI	ETF	40.61	40.75	40.61	40.69	3200.0
2021-12-06	ALTL	ETF	44.22	44.97	43.8799	44.57	93534.0
2021-12-06	ALTY	ETF	13.2	13.28	13.11	13.25	16700.0

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

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