PREVIEW / etf_daily / 2021-12-09

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-09.parquet
  size:    97 KB
  rows:    2,595

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-09	SPY	ETF	468.15	469.63	466.14	466.35	61272600.0
2021-12-09	QQQ	ETF	398.35	400.2	393.5299	393.73	49973714.0
2021-12-09	IWM	ETF	223.95	225.81	220.48	220.52	34830300.0
2021-12-09	DIA	ETF	356.75	359.18	356.35	358.11	3774500.0
2021-12-09	GLD	ETF	166.54	166.58	165.65	165.88	4913800.0
2021-12-09	TLT	ETF	149.34	149.84	148.48	149.22	17544900.0
2021-12-09	AAA	ETF	25.0	25.03	24.99	25.005	75979.0
2021-12-09	AAAU	ETF	17.71	17.72	17.63	17.65	141100.0
2021-12-09	AADR	ETF	63.4	63.43	63.04	63.04	1900.0
2021-12-09	AAXJ	ETF	85.45	85.83	85.25	85.33	1434800.0
2021-12-09	ABEQ	ETF	27.54	27.59	27.54	27.557	8100.0
2021-12-09	ACES	ETF	70.45	71.1	68.42	68.6	84600.0
2021-12-09	ACIO	ETF	32.25	32.25	32.055	32.065	18600.0
2021-12-09	ACSI	ETF	51.963	51.963	51.963	51.963	14.0
2021-12-09	ACT	ETF	20.82	20.93	20.43	20.76	112486.0
2021-12-09	ACTV	ETF	38.49	38.49	38.1556	38.1556	9448.0
2021-12-09	ACVF	ETF	34.875	34.884	34.721	34.721	1200.0
2021-12-09	ACWF	ETF	38.58	38.63	38.4433	38.4433	2075.0
2021-12-09	ACWI	ETF	105.47	105.68	105.03	105.06	6138700.0
2021-12-09	ACWV	ETF	106.14	106.48	106.14	106.26	122100.0
2021-12-09	ACWX	ETF	56.09	56.18	55.95	56.0	3259360.0
2021-12-09	ADFI	ETF	9.5	9.68	9.5	9.61	3200.0
2021-12-09	ADIV	ETF	16.23	16.23	16.23	16.23	100.0
2021-12-09	ADME	ETF	42.81	42.81	42.4	42.4	26300.0
2021-12-09	ADRE	ETF	47.42	47.42	47.0047	47.0047	2943.0
2021-12-09	AEMB	ETF	48.39	48.49	48.39	48.49	100.0
2021-12-09	AESR	ETF	14.747	14.77	14.67	14.682	7100.0
2021-12-09	AFIF	ETF	9.58	9.59	9.58	9.59	8332.0
2021-12-09	AFK	ETF	20.7	20.7	20.55	20.55	2018.0
2021-12-09	AFLG	ETF	27.61	27.61	27.469	27.469	3000.0
2021-12-09	AFSM	ETF	27.3	27.335	27.101	27.101	400.0
2021-12-09	AFTY	ETF	21.96	22.054	21.96	22.054	700.0
2021-12-09	AGG	ETF	114.28	114.39	114.12	114.2	8646500.0
2021-12-09	AGGY	ETF	51.72	51.82	51.705	51.74	64000.0
2021-12-09	AGNG	ETF	28.42	28.49	28.29	28.29	1600.0
2021-12-09	AGOV	ETF	98.16	98.16	98.08	98.08	185.0
2021-12-09	AGOX	ETF	26.14	26.14	25.34	25.35	17100.0
2021-12-09	AGQ	ETF	31.38	31.45	30.79	30.92	992500.0
2021-12-09	AGZ	ETF	117.4	117.45	117.28	117.4	23373.0
2021-12-09	AGZD	ETF	23.395	23.4	23.335	23.35	31400.0
2021-12-09	AHHX	ETF	10.32	10.45	10.32	10.325	1949.0
2021-12-09	AHYB	ETF	50.05	50.05	49.986	49.986	100.0
2021-12-09	AIA	ETF	78.88	79.2673	78.57	78.72	73672.0
2021-12-09	AIEQ	ETF	42.74	42.74	41.917	41.917	10700.0
2021-12-09	AIQ	ETF	32.12	32.3	31.73	31.79	14351.0
2021-12-09	AIRR	ETF	45.35	45.35	44.72	44.72	21500.0
2021-12-09	AIVI	ETF	41.23	41.3	41.17	41.2	27900.0
2021-12-09	ALTL	ETF	45.99	46.05	45.42	45.42	81230.0
2021-12-09	ALTY	ETF	13.39	13.39	13.28	13.28	8100.0
2021-12-09	AMAX	ETF	9.62	9.675	9.56	9.581	900.0

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

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