PREVIEW / etf_daily / 2021-08-10

all etf daily files

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

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-10	SPY	ETF	442.61	443.44	441.88	442.68	43339300.0
2021-08-10	QQQ	ETF	369.26	369.56	365.62	366.84	35130796.0
2021-08-10	IWM	ETF	222.64	223.22	221.19	222.6	22681600.0
2021-08-10	DIA	ETF	351.41	352.94	351.01	352.73	2841000.0
2021-08-10	GLD	ETF	161.39	162.11	160.68	161.77	6870800.0
2021-08-10	TLT	ETF	147.49	147.57	146.56	146.57	13716900.0
2021-08-10	AAA	ETF	25.01	25.01	25.01	25.01	364.0
2021-08-10	AAAU	ETF	17.17	17.23	17.09	17.21	362800.0
2021-08-10	AADR	ETF	68.82	69.31	68.82	69.18	1200.0
2021-08-10	AAXJ	ETF	88.91	88.94	88.48	88.65	689600.0
2021-08-10	ABEQ	ETF	27.85	27.85	27.834	27.834	1400.0
2021-08-10	ACES	ETF	72.44	72.7	72.0	72.27	61500.0
2021-08-10	ACIO	ETF	30.766	30.83	30.731	30.763	18700.0
2021-08-10	ACSI	ETF	51.323	51.323	51.323	51.323	50.0
2021-08-10	ACTV	ETF	38.345	38.49	38.345	38.4725	9570.0
2021-08-10	ACVF	ETF	32.8	32.85	32.79	32.795	2500.0
2021-08-10	ACWF	ETF	38.59	38.63	38.53	38.5489	7187.0
2021-08-10	ACWI	ETF	103.13	103.27	102.95	103.13	1176000.0
2021-08-10	ACWV	ETF	105.11	105.24	105.03	105.19	75100.0
2021-08-10	ACWX	ETF	57.25	57.26	57.135	57.26	278846.0
2021-08-10	ADFI	ETF	9.715	9.73	9.71	9.71	4800.0
2021-08-10	ADIV	ETF	18.25	18.25	18.25	18.25	100.0
2021-08-10	ADME	ETF	40.48	40.72	40.48	40.61	26500.0
2021-08-10	ADRE	ETF	53.59	53.59	52.91	53.0648	9657.0
2021-08-10	AEMB	ETF	49.697	49.697	49.697	49.697	100.0
2021-08-10	AESR	ETF	14.03	14.07	14.0	14.05	13400.0
2021-08-10	AFIF	ETF	9.72	9.72	9.68	9.69	5954.0
2021-08-10	AFK	ETF	21.61	21.79	21.5711	21.71	5659.0
2021-08-10	AFLG	ETF	26.3	26.3	26.266	26.266	600.0
2021-08-10	AFMC	ETF	25.61	25.793	25.61	25.757	800.0
2021-08-10	AFSM	ETF	26.368	26.409	26.368	26.409	600.0
2021-08-10	AFTY	ETF	21.193	21.193	21.193	21.193	100.0
2021-08-10	AGG	ETF	115.65	115.65	115.43	115.43	7332100.0
2021-08-10	AGGY	ETF	52.44	52.45	52.361	52.37	52800.0
2021-08-10	AGNG	ETF	30.32	30.379	30.151	30.19	8200.0
2021-08-10	AGOV	ETF	99.6	99.6	99.6	99.6	1.0
2021-08-10	AGOX	ETF	26.4	26.47	26.37	26.37	29100.0
2021-08-10	AGQ	ETF	36.0	36.53	35.86	36.1	855300.0
2021-08-10	AGZ	ETF	118.83	118.91	118.75	118.78	1250598.0
2021-08-10	AGZD	ETF	23.525	23.525	23.47	23.49	35400.0
2021-08-10	AIA	ETF	85.15	85.28	84.632	84.9	44371.0
2021-08-10	AIEQ	ETF	41.97	42.074	41.72	41.726	7500.0
2021-08-10	AIQ	ETF	31.05	31.05	30.8	30.8	16763.0
2021-08-10	AIRR	ETF	41.43	42.27	41.43	42.27	26200.0
2021-08-10	AIVI	ETF	43.47	43.62	43.47	43.61	3800.0
2021-08-10	ALTL	ETF	43.02	43.02	42.8947	42.94	52569.0
2021-08-10	ALTY	ETF	13.56	13.67	13.56	13.655	23300.0
2021-08-10	AMJ	ETF	17.65	18.03	17.65	17.89	363706.0
2021-08-10	AMLP	ETF	32.56	33.25	32.56	33.19	2460900.0
2021-08-10	AMNA	ETF	32.2351	32.2351	32.2351	32.2351	0.0

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

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