PREVIEW / etf_daily / 2021-11-22

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-22.parquet
  size:    97 KB
  rows:    2,592

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-11-22	SPY	ETF	470.89	473.54	467.35	467.57	72762000.0
2021-11-22	QQQ	ETF	405.57	408.71	399.19	399.3	61715370.0
2021-11-22	IWM	ETF	234.22	235.74	231.62	231.73	31042100.0
2021-11-22	DIA	ETF	357.48	359.24	356.09	356.2	4929200.0
2021-11-22	GLD	ETF	169.9	170.44	168.42	168.74	13091900.0
2021-11-22	TLT	ETF	147.4	147.64	146.13	146.62	15266000.0
2021-11-22	AAA	ETF	25.05	25.0599	25.05	25.05	536.0
2021-11-22	AAAU	ETF	18.08	18.13	17.92	17.94	345300.0
2021-11-22	AADR	ETF	64.25	64.25	63.6	63.81	2300.0
2021-11-22	AAXJ	ETF	86.68	87.02	86.18	86.28	735000.0
2021-11-22	ABEQ	ETF	27.88	27.937	27.846	27.846	2400.0
2021-11-22	ACES	ETF	80.02	81.23	78.0	78.45	51200.0
2021-11-22	ACIO	ETF	31.92	32.22	31.9	31.9	35800.0
2021-11-22	ACSI	ETF	53.7	53.7	53.41	53.4739	281.0
2021-11-22	ACT	ETF	23.21	23.6402	23.1	23.14	170784.0
2021-11-22	ACTV	ETF	38.02	38.28	37.97	37.99	4256.0
2021-11-22	ACTX	ETF	1.49	1.85	1.49	1.85	12733.0
2021-11-22	ACVF	ETF	35.35	35.45	35.0	35.0	9700.0
2021-11-22	ACWF	ETF	38.8	38.88	38.6233	38.6233	8226.0
2021-11-22	ACWI	ETF	106.77	107.16	105.9	105.94	5876700.0
2021-11-22	ACWV	ETF	106.84	106.97	106.42	106.43	140800.0
2021-11-22	ACWX	ETF	56.97	57.1	56.645	56.65	1523991.0
2021-11-22	ADFI	ETF	9.63	9.63	9.55	9.585	8100.0
2021-11-22	ADIV	ETF	17.85	17.85	17.85	17.85	100.0
2021-11-22	ADME	ETF	42.64	42.871	42.36	42.36	24700.0
2021-11-22	ADRE	ETF	49.23	49.6139	48.8501	48.93	6614.0
2021-11-22	AEMB	ETF	48.29	48.29	48.29	48.29	100.0
2021-11-22	AESR	ETF	14.98	14.98	14.823	14.823	4000.0
2021-11-22	AFIF	ETF	9.59	9.59	9.54	9.545	48382.0
2021-11-22	AFK	ETF	21.13	21.13	20.8	20.92	16670.0
2021-11-22	AFLG	ETF	27.646	27.66	27.422	27.422	1100.0
2021-11-22	AFTY	ETF	21.06	21.1	21.06	21.085	3300.0
2021-11-22	AGG	ETF	114.14	114.23	113.82	113.9	6995300.0
2021-11-22	AGGY	ETF	51.75	51.797	51.63	51.65	136200.0
2021-11-22	AGNG	ETF	29.19	29.19	28.91	28.91	3700.0
2021-11-22	AGOV	ETF	97.83	97.835	97.83	97.835	205.0
2021-11-22	AGOX	ETF	26.41	26.41	25.88	25.88	34300.0
2021-11-22	AGQ	ETF	38.98	39.36	37.71	37.83	886200.0
2021-11-22	AGZ	ETF	117.73	117.73	117.46	117.54	67907.0
2021-11-22	AGZD	ETF	23.445	23.45	23.415	23.435	84600.0
2021-11-22	AHHX	ETF	10.5	10.51	10.305	10.395	8539.0
2021-11-22	AHYB	ETF	49.837	49.837	49.837	49.837	100.0
2021-11-22	AIA	ETF	81.02	81.33	80.4	80.41	57671.0
2021-11-22	AIEQ	ETF	44.07	44.41	43.7	43.78	16400.0
2021-11-22	AIQ	ETF	33.19	33.33	32.56	32.56	38042.0
2021-11-22	AIRR	ETF	47.49	47.98	47.21	47.3	44400.0
2021-11-22	AIVI	ETF	41.05	41.33	41.05	41.06	8300.0
2021-11-22	ALTL	ETF	44.7	45.21	44.7	44.93	119372.0
2021-11-22	ALTY	ETF	13.47	13.47	13.38	13.38	19200.0
2021-11-22	AMAX	ETF	9.805	9.89	9.72	9.74	1000.0

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

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