PREVIEW / etf_daily / 2021-07-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-22.parquet
  size:    91 KB
  rows:    2,414

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-07-22	SPY	ETF	434.74	435.72	433.69	435.46	47878500.0
2021-07-22	QQQ	ETF	361.77	363.96	361.77	363.95	30252240.0
2021-07-22	IWM	ETF	221.47	221.93	217.58	218.53	32879000.0
2021-07-22	DIA	ETF	347.77	348.81	346.68	348.26	2429300.0
2021-07-22	GLD	ETF	168.49	169.19	168.06	169.09	4793600.0
2021-07-22	TLT	ETF	148.11	149.81	148.06	149.5	18136900.0
2021-07-22	AAA	ETF	25.02	25.02	25.02	25.02	4.0
2021-07-22	AAAU	ETF	17.92	17.99	17.87	17.98	387600.0
2021-07-22	AADR	ETF	65.91	65.91	65.44	65.73	4300.0
2021-07-22	AAXJ	ETF	91.51	91.55	90.99	91.32	1162100.0
2021-07-22	ABEQ	ETF	27.15	27.24	27.15	27.195	5100.0
2021-07-22	ACES	ETF	71.49	71.59	70.295	70.57	39200.0
2021-07-22	ACIO	ETF	30.53	30.78	30.53	30.77	30100.0
2021-07-22	ACSI	ETF	50.8384	50.8384	50.8384	50.8384	157.0
2021-07-22	ACTV	ETF	37.95	37.97	37.8644	37.8644	5462.0
2021-07-22	ACTX	ETF	2.1	2.1	1.61	1.61	1223.0
2021-07-22	ACVF	ETF	32.18	32.219	32.12	32.219	1000.0
2021-07-22	ACWF	ETF	37.83	37.89	37.83	37.8821	3634.0
2021-07-22	ACWI	ETF	101.71	101.87	101.4	101.77	1328600.0
2021-07-22	ACWV	ETF	104.24	104.24	103.88	104.11	66500.0
2021-07-22	ACWX	ETF	56.89	56.89	56.5501	56.74	391758.0
2021-07-22	ADFI	ETF	9.78	9.8	9.773	9.773	1700.0
2021-07-22	ADIV	ETF	18.319	18.319	18.319	18.319	100.0
2021-07-22	ADME	ETF	40.39	40.63	40.39	40.63	23100.0
2021-07-22	ADRE	ETF	55.175	55.175	54.75	55.02	3980.0
2021-07-22	AEMB	ETF	50.23	50.26	50.165	50.165	600.0
2021-07-22	AESR	ETF	13.8	13.83	13.8	13.83	6400.0
2021-07-22	AFIF	ETF	9.7081	9.73	9.69	9.715	33841.0
2021-07-22	AFK	ETF	21.71	21.798	21.47	21.55	6487.0
2021-07-22	AFLG	ETF	25.64	25.667	25.63	25.667	300.0
2021-07-22	AFMC	ETF	24.99	24.99	24.903	24.903	600.0
2021-07-22	AFTY	ETF	22.13	22.22	22.01	22.03	19600.0
2021-07-22	AGG	ETF	116.03	116.35	116.03	116.29	8176300.0
2021-07-22	AGGY	ETF	52.69	52.86	52.69	52.82	39400.0
2021-07-22	AGNG	ETF	30.42	30.42	30.321	30.4	1600.0
2021-07-22	AGOV	ETF	100.01	100.03	100.005	100.005	418547.0
2021-07-22	AGOX	ETF	26.27	26.27	25.82	26.01	24800.0
2021-07-22	AGQ	ETF	42.44	43.5	41.94	43.42	623300.0
2021-07-22	AGZ	ETF	118.98	119.19	118.98	119.15	245149.0
2021-07-22	AGZD	ETF	23.495	23.495	23.46	23.46	87000.0
2021-07-22	AIA	ETF	88.26	88.49	87.905	88.27	44113.0
2021-07-22	AIEQ	ETF	40.76	40.88	40.63	40.844	6900.0
2021-07-22	AIQ	ETF	30.63	30.84	30.63	30.84	85146.0
2021-07-22	AIRR	ETF	40.18	40.22	39.61	39.63	44800.0
2021-07-22	AIVI	ETF	43.34	43.43	43.31	43.42	35700.0
2021-07-22	ALTL	ETF	42.15	42.27	42.14	42.26	16772.0
2021-07-22	ALTY	ETF	13.48	13.58	13.47	13.54	12200.0
2021-07-22	AMJ	ETF	18.26	18.48	18.04	18.23	418173.0
2021-07-22	AMLP	ETF	33.76	34.22	33.36	33.72	2284600.0
2021-07-22	AMNA	ETF	32.2165	32.2165	32.2165	32.2165	18.0

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

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