PREVIEW / etf_daily / 2021-08-23

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-23.parquet
  size:    92 KB
  rows:    2,444

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-23	SPY	ETF	445.16	448.23	443.44	447.26	54973000.0
2021-08-23	QQQ	ETF	368.8	373.935	368.79	373.23	34034744.0
2021-08-23	IWM	ETF	217.48	219.94	217.44	219.62	25778800.0
2021-08-23	DIA	ETF	352.96	354.31	352.92	353.45	3569200.0
2021-08-23	GLD	ETF	168.82	168.91	167.96	168.73	8190500.0
2021-08-23	TLT	ETF	150.2	150.5	149.92	150.45	10615000.0
2021-08-23	AAA	ETF	25.0	25.015	25.0	25.015	222.0
2021-08-23	AAAU	ETF	17.96	17.96	17.86	17.93	258500.0
2021-08-23	AADR	ETF	66.44	67.23	66.44	67.22	1400.0
2021-08-23	AAXJ	ETF	84.61	85.41	84.59	85.24	2099400.0
2021-08-23	ABEQ	ETF	27.843	27.843	27.8	27.803	800.0
2021-08-23	ACES	ETF	68.04	69.64	68.04	69.535	35500.0
2021-08-23	ACIO	ETF	30.66	31.0	30.66	30.93	55700.0
2021-08-23	ACSI	ETF	51.54	51.54	51.5224	51.5224	532.0
2021-08-23	ACTV	ETF	38.22	38.28	37.8	37.9376	3432.0
2021-08-23	ACTX	ETF	1.48	1.5	1.47	1.5	2526.0
2021-08-23	ACVF	ETF	33.52	33.75	33.29	33.3	49400.0
2021-08-23	ACWF	ETF	38.38	38.49	38.33	38.4719	11957.0
2021-08-23	ACWI	ETF	102.59	103.25	102.59	103.05	3127300.0
2021-08-23	ACWV	ETF	106.53	106.77	106.42	106.55	48100.0
2021-08-23	ACWX	ETF	56.21	56.535	56.18	56.46	2067385.0
2021-08-23	ADFI	ETF	9.72	9.78	9.72	9.73	11100.0
2021-08-23	ADIV	ETF	18.025	18.025	18.025	18.025	1400.0
2021-08-23	ADME	ETF	40.86	40.975	40.86	40.89	19000.0
2021-08-23	ADRE	ETF	48.5	49.2896	48.5	49.2896	7396.0
2021-08-23	AEMB	ETF	49.97	49.97	49.97	49.97	100.0
2021-08-23	AESR	ETF	14.08	14.18	14.08	14.12	23200.0
2021-08-23	AFIF	ETF	9.68	9.68	9.65	9.67	30937.0
2021-08-23	AFK	ETF	21.05	21.23	21.05	21.22	6651.0
2021-08-23	AFLG	ETF	26.541	26.541	26.464	26.464	1900.0
2021-08-23	AFMC	ETF	25.65	25.65	25.602	25.602	1100.0
2021-08-23	AFSM	ETF	25.95	26.09	25.95	26.032	6500.0
2021-08-23	AFTY	ETF	20.13	20.13	20.0	20.12	1600.0
2021-08-23	AGG	ETF	116.09	116.18	116.04	116.16	6585300.0
2021-08-23	AGGY	ETF	52.73	52.75	52.68	52.75	82000.0
2021-08-23	AGNG	ETF	30.85	30.86	30.771	30.807	4700.0
2021-08-23	AGOV	ETF	100.26	100.26	99.955	99.955	4143.0
2021-08-23	AGOX	ETF	26.17	26.2	25.92	26.12	33700.0
2021-08-23	AGQ	ETF	36.83	37.18	36.42	36.91	868100.0
2021-08-23	AGZ	ETF	119.2	119.2	119.11	119.19	34095.0
2021-08-23	AGZD	ETF	23.415	23.445	23.4	23.42	36600.0
2021-08-23	AIA	ETF	79.02	79.8	78.8494	79.78	97270.0
2021-08-23	AIEQ	ETF	41.51	41.895	41.51	41.895	17600.0
2021-08-23	AIQ	ETF	30.38	30.84	30.38	30.8	46309.0
2021-08-23	AIRR	ETF	41.51	41.734	41.465	41.56	12700.0
2021-08-23	AIVI	ETF	43.04	43.2	43.04	43.17	2100.0
2021-08-23	ALTL	ETF	44.0	44.0	43.5299	43.53	39088.0
2021-08-23	ALTY	ETF	13.6	13.67	13.59	13.65	8500.0
2021-08-23	AMJ	ETF	17.71	17.85	17.635	17.7	492729.0
2021-08-23	AMLP	ETF	32.02	32.27	31.89	31.97	2373100.0

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

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