PREVIEW / etf_daily / 2021-12-30

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-30.parquet
  size:    98 KB
  rows:    2,623

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-12-30	SPY	ETF	477.93	479.0	475.67	476.16	55329000.0
2021-12-30	QQQ	ETF	401.33	403.5699	399.75	400.35	23850065.0
2021-12-30	IWM	ETF	222.94	225.43	222.7	222.93	23607700.0
2021-12-30	DIA	ETF	365.69	366.72	363.6	364.07	2863200.0
2021-12-30	GLD	ETF	168.43	169.81	168.37	169.8	5426300.0
2021-12-30	TLT	ETF	147.25	147.97	146.45	147.9	10355000.0
2021-12-30	AAA	ETF	25.02	25.02	25.01	25.01	101.0
2021-12-30	AAAU	ETF	17.91	18.06	17.91	18.06	120800.0
2021-12-30	AADR	ETF	64.06	64.09	64.06	64.09	200.0
2021-12-30	AAXJ	ETF	82.16	83.35	82.16	83.15	1232300.0
2021-12-30	ABEQ	ETF	28.39	28.39	28.37	28.375	500.0
2021-12-30	ACES	ETF	62.91	65.094	62.87	64.26	99000.0
2021-12-30	ACIO	ETF	32.82	32.86	32.66	32.74	20700.0
2021-12-30	ACSI	ETF	53.3396	53.3396	53.3396	53.3396	105.0
2021-12-30	ACT	ETF	20.47	20.93	20.34	20.55	76987.0
2021-12-30	ACTV	ETF	36.78	36.94	36.33	36.33	4781.0
2021-12-30	ACTX	ETF	1.34	1.34	1.34	1.34	291.0
2021-12-30	ACVF	ETF	35.88	35.88	35.697	35.697	4500.0
2021-12-30	ACWF	ETF	39.33	39.43	39.23	39.23	15501.0
2021-12-30	ACWI	ETF	106.12	106.4	105.88	105.95	2156000.0
2021-12-30	ACWV	ETF	108.29	108.54	108.17	108.2	87900.0
2021-12-30	ACWX	ETF	55.6	55.82	55.6	55.69	1482461.0
2021-12-30	ADFI	ETF	9.58	9.585	9.58	9.585	400.0
2021-12-30	ADIV	ETF	16.46	16.52	16.46	16.479	800.0
2021-12-30	ADME	ETF	43.6	43.6	43.303	43.35	12700.0
2021-12-30	ADRE	ETF	44.58	46.31	44.58	46.085	25876.0
2021-12-30	AESR	ETF	14.08	14.11	14.02	14.02	4500.0
2021-12-30	AFIF	ETF	9.5696	9.58	9.53	9.56	145213.0
2021-12-30	AFK	ETF	20.08	20.14	19.895	20.06	9180.0
2021-12-30	AFLG	ETF	28.21	28.21	28.123	28.123	200.0
2021-12-30	AFMC	ETF	26.9	26.93	26.598	26.598	14200.0
2021-12-30	AFSM	ETF	27.745	27.745	27.745	27.745	100.0
2021-12-30	AFTY	ETF	20.8	20.907	20.8	20.907	800.0
2021-12-30	AGG	ETF	113.99	114.13	113.83	114.12	5455400.0
2021-12-30	AGGY	ETF	51.59	51.64	51.51	51.64	196600.0
2021-12-30	AGNG	ETF	29.4	29.4	28.92	28.92	2200.0
2021-12-30	AGOV	ETF	98.0411	98.055	98.0411	98.055	1144.0
2021-12-30	AGOX	ETF	25.473	25.483	25.3	25.34	24200.0
2021-12-30	AGQ	ETF	33.69	34.23	33.69	34.11	545700.0
2021-12-30	AGZ	ETF	117.21	117.23	117.0714	117.23	15620.0
2021-12-30	AGZD	ETF	23.365	23.38	23.33	23.335	317000.0
2021-12-30	AHHX	ETF	10.47	10.48	10.325	10.325	489.0
2021-12-30	AHYB	ETF	50.21	50.21	50.145	50.145	800.0
2021-12-30	AIA	ETF	75.73	77.47	75.73	77.21	123638.0
2021-12-30	AIEQ	ETF	42.05	42.149	41.772	41.772	46800.0
2021-12-30	AIQ	ETF	31.93	32.26	31.93	31.99	29350.0
2021-12-30	AIRR	ETF	45.17	45.52	44.757	44.757	10200.0
2021-12-30	AIVI	ETF	42.05	42.13	41.84	41.88	6300.0
2021-12-30	ALTL	ETF	46.26	46.42	45.915	45.95	72478.0
2021-12-30	ALTY	ETF	13.41	13.44	13.363	13.41	15800.0

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

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