PREVIEW / etf_daily / 2021-11-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-09.parquet
  size:    96 KB
  rows:    2,562

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-09	SPY	ETF	469.32	469.57	465.88	467.38	51149100.0
2021-11-09	QQQ	ETF	399.16	399.57	393.92	395.32	50490720.0
2021-11-09	IWM	ETF	242.0	242.53	239.54	241.15	29895900.0
2021-11-09	DIA	ETF	364.19	364.3	361.82	363.28	3680600.0
2021-11-09	GLD	ETF	170.73	171.31	170.12	171.29	5781200.0
2021-11-09	TLT	ETF	150.8	151.77	150.64	150.96	23430200.0
2021-11-09	AAA	ETF	25.05	25.05	25.02	25.02	4260.0
2021-11-09	AAAU	ETF	18.17	18.22	18.11	18.21	170400.0
2021-11-09	AADR	ETF	66.25	66.25	65.94	65.94	1800.0
2021-11-09	AAXJ	ETF	86.65	86.96	86.11	86.26	4694600.0
2021-11-09	ABEQ	ETF	28.225	28.319	28.225	28.319	1100.0
2021-11-09	ACES	ETF	81.32	81.32	77.98	78.79	96800.0
2021-11-09	ACIO	ETF	32.22	32.22	31.98	32.098	47100.0
2021-11-09	ACSI	ETF	53.3076	53.3076	53.3076	53.3076	15.0
2021-11-09	ACT	ETF	23.0	23.03	22.36	22.45	171137.0
2021-11-09	ACTV	ETF	39.245	39.44	39.245	39.3951	6098.0
2021-11-09	ACTX	ETF	1.01	1.01	0.8525	1.01	1838.0
2021-11-09	ACVF	ETF	35.42	35.46	35.06	35.46	13900.0
2021-11-09	ACWF	ETF	38.715	38.7941	38.66	38.7941	2236.0
2021-11-09	ACWI	ETF	107.38	107.38	106.65	106.95	2839400.0
2021-11-09	ACWV	ETF	106.47	106.72	106.35	106.63	125100.0
2021-11-09	ACWX	ETF	57.96	57.98	57.6	57.75	1370878.0
2021-11-09	ADFI	ETF	9.75	9.75	9.72	9.735	4800.0
2021-11-09	ADIV	ETF	17.74	17.74	17.74	17.74	100.0
2021-11-09	ADME	ETF	42.8	42.8	42.48	42.57	29100.0
2021-11-09	ADRE	ETF	50.51	50.7435	50.1101	50.19	6805.0
2021-11-09	AESR	ETF	14.87	14.87	14.79	14.81	21500.0
2021-11-09	AFIF	ETF	9.68	9.7	9.66	9.66	25536.0
2021-11-09	AFK	ETF	21.75	21.7601	21.61	21.61	3395.0
2021-11-09	AFLG	ETF	27.273	27.354	27.273	27.354	200.0
2021-11-09	AFMC	ETF	27.051	27.051	27.051	27.051	100.0
2021-11-09	AFSM	ETF	28.809	28.869	28.809	28.832	600.0
2021-11-09	AFTY	ETF	20.88	20.9	20.88	20.9	1500.0
2021-11-09	AGG	ETF	115.38	115.5	115.29	115.33	8960500.0
2021-11-09	AGGY	ETF	52.41	52.433	52.33	52.36	169800.0
2021-11-09	AGNG	ETF	30.14	30.3	30.14	30.24	5600.0
2021-11-09	AGOV	ETF	99.44	99.52	99.44	99.52	915.0
2021-11-09	AGOX	ETF	26.3	26.45	26.29	26.43	836700.0
2021-11-09	AGQ	ETF	38.59	38.96	37.6	38.5	696200.0
2021-11-09	AGZ	ETF	118.38	118.52	118.38	118.39	27010.0
2021-11-09	AGZD	ETF	23.44	23.465	23.4	23.405	76000.0
2021-11-09	AIA	ETF	80.24	80.63	79.9099	80.01	64802.0
2021-11-09	AIEQ	ETF	44.64	44.7	44.35	44.633	10300.0
2021-11-09	AIQ	ETF	33.07	33.135	32.83	32.94	23235.0
2021-11-09	AIRR	ETF	47.35	47.35	46.86	47.2	38200.0
2021-11-09	AIVI	ETF	41.77	41.77	41.56	41.67	5300.0
2021-11-09	ALTL	ETF	44.59	44.59	44.387	44.59	49294.0
2021-11-09	ALTY	ETF	13.67	13.7	13.62	13.65	8100.0
2021-11-09	AMJ	ETF	19.33	19.42	19.19	19.37	282758.0
2021-11-09	AMLP	ETF	35.68	35.83	35.39	35.79	1009600.0

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

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