PREVIEW / etf_daily / 2021-08-02

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-02.parquet
  size:    91 KB
  rows:    2,427

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-08-02	SPY	ETF	440.34	440.93	437.21	437.59	58783300.0
2021-08-02	QQQ	ETF	366.28	366.88	363.87	364.6	27334097.0
2021-08-02	IWM	ETF	222.47	224.55	219.64	219.95	24192600.0
2021-08-02	DIA	ETF	350.45	351.91	348.06	348.35	2827100.0
2021-08-02	GLD	ETF	169.3	170.25	169.1	169.61	10783200.0
2021-08-02	TLT	ETF	149.45	151.23	149.18	150.67	21232700.0
2021-08-02	AAA	ETF	25.0	25.0	25.0	25.0	23.0
2021-08-02	AAAU	ETF	18.01	18.1	17.97	18.04	440900.0
2021-08-02	AADR	ETF	67.15	67.49	67.15	67.49	1400.0
2021-08-02	AAXJ	ETF	88.32	88.74	88.22	88.25	769600.0
2021-08-02	ABEQ	ETF	27.71	27.71	27.585	27.585	3400.0
2021-08-02	ACES	ETF	72.83	72.83	71.54	71.62	84100.0
2021-08-02	ACIO	ETF	30.93	30.93	30.7	30.7	90100.0
2021-08-02	ACSI	ETF	50.4888	50.4888	50.4888	50.4888	197.0
2021-08-02	ACTV	ETF	38.25	38.41	38.1916	38.1916	13906.0
2021-08-02	ACTX	ETF	1.9	1.9	1.9	1.9	575.0
2021-08-02	ACVF	ETF	32.55	32.77	32.535	32.535	3400.0
2021-08-02	ACWF	ETF	38.5769	38.62	38.3751	38.3751	18386.0
2021-08-02	ACWI	ETF	102.7	102.77	102.08	102.16	3627300.0
2021-08-02	ACWV	ETF	105.1	105.3	104.89	104.91	71800.0
2021-08-02	ACWX	ETF	57.03	57.155	56.805	56.87	682036.0
2021-08-02	ADFI	ETF	9.8	9.8	9.79	9.79	2400.0
2021-08-02	ADIV	ETF	18.14	18.14	18.14	18.14	100.0
2021-08-02	ADME	ETF	40.722	40.722	40.485	40.485	47700.0
2021-08-02	ADRE	ETF	53.36	53.75	53.28	53.43	9454.0
2021-08-02	AEMB	ETF	50.121	50.121	50.121	50.121	601400.0
2021-08-02	AESR	ETF	14.03	14.03	13.855	13.855	13100.0
2021-08-02	AFIF	ETF	9.69	9.73	9.68	9.7	283367.0
2021-08-02	AFK	ETF	21.84	21.85	21.76	21.76	5645.0
2021-08-02	AFLG	ETF	25.943	25.943	25.943	25.943	100.0
2021-08-02	AFMC	ETF	25.54	25.54	25.385	25.385	500.0
2021-08-02	AFSM	ETF	25.855	25.855	25.855	25.855	800.0
2021-08-02	AFTY	ETF	20.55	20.597	20.51	20.512	2000.0
2021-08-02	AGG	ETF	116.36	116.68	116.31	116.54	5753800.0
2021-08-02	AGGY	ETF	52.88	53.015	52.854	52.95	44100.0
2021-08-02	AGNG	ETF	30.585	30.689	30.585	30.68	4700.0
2021-08-02	AGOV	ETF	100.525	100.525	100.51	100.51	420.0
2021-08-02	AGOX	ETF	26.29	26.37	26.1	26.13	18200.0
2021-08-02	AGQ	ETF	42.91	43.64	42.9	43.2	361100.0
2021-08-02	AGZ	ETF	119.3	119.39	119.2	119.37	19676.0
2021-08-02	AGZD	ETF	23.525	23.525	23.42	23.42	67200.0
2021-08-02	AIA	ETF	84.26	84.8	84.26	84.4	66971.0
2021-08-02	AIEQ	ETF	41.75	41.75	41.417	41.515	15900.0
2021-08-02	AIQ	ETF	30.62	30.76	30.5038	30.54	17895.0
2021-08-02	AIRR	ETF	41.48	42.25	40.8	40.8	40600.0
2021-08-02	AIVI	ETF	43.91	43.93	43.68	43.68	8800.0
2021-08-02	ALTL	ETF	43.42	43.42	42.6912	42.7	33029.0
2021-08-02	ALTY	ETF	13.75	13.75	13.66	13.675	17500.0
2021-08-02	AMJ	ETF	18.49	18.69	18.04	18.04	599002.0
2021-08-02	AMLP	ETF	34.01	34.6	33.4	33.4	2971000.0

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

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