PREVIEW / etf_daily / 2022-09-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-01.parquet
  size:    105 KB
  rows:    2,805

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
2022-09-01	SPY	ETF	392.89	396.78	390.04	396.42	78740100.0
2022-09-01	QQQ	ETF	296.72	299.78	292.95	299.4	57990745.0
2022-09-01	IWM	ETF	181.78	181.89	178.9	181.5	30706600.0
2022-09-01	DIA	ETF	314.29	317.25	312.7	317.06	3228000.0
2022-09-01	GLD	ETF	158.17	158.39	157.32	157.87	7390800.0
2022-09-01	TLT	ETF	109.87	110.25	108.94	109.6	22490400.0
2022-09-01	AAA	ETF	24.36	24.36	24.34	24.34	110.0
2022-09-01	AAAU	ETF	16.85	16.88	16.76	16.82	2419500.0
2022-09-01	AADR	ETF	48.83	49.27	48.83	49.27	1000.0
2022-09-01	AAPB	ETF	22.63	23.0078	22.36	23.0078	5992.0
2022-09-01	AAPD	ETF	26.28	26.5	25.9701	26.0091	78493.0
2022-09-01	AAPU	ETF	23.04	23.3353	22.6999	23.3353	34350.0
2022-09-01	AAXJ	ETF	66.22	66.47	65.81	66.4	936500.0
2022-09-01	ABEQ	ETF	26.25	26.462	26.23	26.456	13400.0
2022-09-01	ACES	ETF	62.16	62.5	60.36	61.74	47900.0
2022-09-01	ACIO	ETF	29.71	29.89	29.66	29.88	150000.0
2022-09-01	ACSI	ETF	44.78	45.3485	44.78	45.3485	292.0
2022-09-01	ACT	ETF	25.37	25.45	24.62	24.68	201159.0
2022-09-01	ACTV	ETF	29.27	29.5422	29.16	29.5422	4824.0
2022-09-01	ACTX	ETF	0.5	0.5	0.5	0.5	1876.0
2022-09-01	ACVF	ETF	29.56	29.699	29.35	29.699	5100.0
2022-09-01	ACWF	ETF	31.71	31.8234	31.48	31.8234	10761.0
2022-09-01	ACWI	ETF	85.21	85.73	84.48	85.69	3659900.0
2022-09-01	ACWV	ETF	94.53	95.3	94.27	95.24	147600.0
2022-09-01	ACWX	ETF	43.75	43.8	43.32	43.79	2890798.0
2022-09-01	ADFI	ETF	8.44	8.46	8.41	8.415	25400.0
2022-09-01	ADIV	ETF	13.3	13.3	13.23	13.27	3900.0
2022-09-01	ADME	ETF	35.15	35.266	35.09	35.266	17600.0
2022-09-01	ADRE	ETF	38.87	38.94	38.5436	38.94	2801.0
2022-09-01	AEMB	ETF	37.42	37.583	37.42	37.583	200.0
2022-09-01	AESR	ETF	11.55	11.59	11.5	11.59	26100.0
2022-09-01	AFIF	ETF	8.76	8.87	8.76	8.865	32549.0
2022-09-01	AFK	ETF	16.35	16.41	16.19	16.35	16081.0
2022-09-01	AFLG	ETF	23.35	23.5	23.34	23.5	800.0
2022-09-01	AFMC	ETF	21.99	21.99	21.99	21.99	100.0
2022-09-01	AFSM	ETF	22.6	22.689	22.59	22.689	300.0
2022-09-01	AFTY	ETF	16.68	16.686	16.66	16.686	600.0
2022-09-01	AGG	ETF	100.07	100.15	99.66	100.07	8961600.0
2022-09-01	AGGH	ETF	23.3	23.4	23.3	23.4	6031.0
2022-09-01	AGGY	ETF	44.18	44.223	44.04	44.19	96100.0
2022-09-01	AGNG	ETF	24.4	24.703	24.19	24.703	3100.0
2022-09-01	AGOV	ETF	81.19	81.99	81.1501	81.9756	13593.0
2022-09-01	AGOX	ETF	21.02	21.02	20.65	20.97	14900.0
2022-09-01	AGQ	ETF	18.05	18.23	17.56	17.98	1315000.0
2022-09-01	AGZ	ETF	108.77	108.865	108.64	108.705	16023.0
2022-09-01	AGZD	ETF	22.92	22.975	22.87	22.96	38400.0
2022-09-01	AHHX	ETF	8.42	8.54	8.4	8.5391	49430.0
2022-09-01	AHYB	ETF	43.23	43.23	43.23	43.23	100.0
2022-09-01	AIA	ETF	58.25	58.38	57.8	58.35	845221.0
2022-09-01	AIEQ	ETF	32.78	32.78	31.973	32.39	5900.0

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

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