PREVIEW / etf_daily / 2022-01-14

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-14.parquet
  size:    99 KB
  rows:    2,631

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-01-14	SPY	ETF	461.19	465.09	459.9	464.72	95890900.0
2022-01-14	QQQ	ETF	375.07	380.35	374.86	380.01	80121210.0
2022-01-14	IWM	ETF	211.99	214.4	210.58	214.31	42020900.0
2022-01-14	DIA	ETF	358.21	359.8	356.4	359.14	8575400.0
2022-01-14	GLD	ETF	170.22	170.56	169.48	169.67	7865900.0
2022-01-14	TLT	ETF	143.42	143.46	141.79	142.1	22997500.0
2022-01-14	AAA	ETF	24.9801	24.985	24.9801	24.985	1271.0
2022-01-14	AAAU	ETF	18.12	18.15	18.04	18.05	105800.0
2022-01-14	AADR	ETF	63.87	63.93	63.87	63.93	700.0
2022-01-14	AAXJ	ETF	84.08	84.67	84.0	84.36	850800.0
2022-01-14	ABEQ	ETF	28.83	28.996	28.83	28.996	9000.0
2022-01-14	ACES	ETF	57.52	58.44	56.47	57.4	57100.0
2022-01-14	ACIO	ETF	31.67	31.938	31.67	31.823	69600.0
2022-01-14	ACSI	ETF	51.18	51.6484	51.18	51.6484	707.0
2022-01-14	ACT	ETF	22.07	22.45	21.85	22.34	84447.0
2022-01-14	ACTV	ETF	36.849	36.9887	36.54	36.9887	11708.0
2022-01-14	ACVF	ETF	34.4	34.713	34.39	34.713	10000.0
2022-01-14	ACWF	ETF	38.74	38.8884	38.59	38.8884	29887.0
2022-01-14	ACWI	ETF	103.9	104.51	103.51	104.47	6341200.0
2022-01-14	ACWV	ETF	105.26	105.42	104.72	105.19	303600.0
2022-01-14	ACWX	ETF	55.91	56.2135	55.77	56.13	5381698.0
2022-01-14	ADFI	ETF	9.425	9.425	9.425	9.425	100.0
2022-01-14	ADIV	ETF	16.602	16.602	16.602	16.602	100.0
2022-01-14	ADME	ETF	42.14	42.175	41.835	42.09	50200.0
2022-01-14	ADRE	ETF	49.22	49.38	49.01	49.31	8250.0
2022-01-14	AEMB	ETF	47.0	47.02	46.94	46.94	1400.0
2022-01-14	AESR	ETF	13.65	13.73	13.61	13.73	1800.0
2022-01-14	AFIF	ETF	9.485	9.485	9.465	9.465	10791.0
2022-01-14	AFK	ETF	20.68	20.763	20.675	20.72	7312.0
2022-01-14	AFLG	ETF	27.08	27.285	27.08	27.285	100.0
2022-01-14	AFSM	ETF	26.42	26.614	26.42	26.614	300.0
2022-01-14	AFTY	ETF	20.01	20.05	20.0	20.03	500.0
2022-01-14	AGG	ETF	112.53	112.55	112.15	112.17	9113400.0
2022-01-14	AGGY	ETF	50.84	50.84	50.655	50.7	89500.0
2022-01-14	AGNG	ETF	27.53	27.659	27.3	27.65	4500.0
2022-01-14	AGOV	ETF	97.1	97.1	96.72	96.875	4675.0
2022-01-14	AGOX	ETF	24.53	24.92	24.53	24.89	21300.0
2022-01-14	AGQ	ETF	33.67	33.96	33.23	33.55	542800.0
2022-01-14	AGZ	ETF	116.34	116.3699	116.1607	116.18	20392.0
2022-01-14	AGZD	ETF	23.325	23.35	23.31	23.345	57800.0
2022-01-14	AHHX	ETF	10.19	10.19	10.13	10.165	4041.0
2022-01-14	AHYB	ETF	49.81	49.81	49.81	49.81	300.0
2022-01-14	AIA	ETF	78.96	79.56	78.8926	79.37	133824.0
2022-01-14	AIEQ	ETF	38.2	38.522	37.79	38.18	15300.0
2022-01-14	AIQ	ETF	29.71	30.1	29.67	30.0291	27239.0
2022-01-14	AIRR	ETF	43.9	44.09	43.66	44.04	18900.0
2022-01-14	AIVI	ETF	43.18	43.46	43.18	43.44	29000.0
2022-01-14	ALTL	ETF	46.08	46.08	45.29	45.63	119690.0
2022-01-14	ALTY	ETF	13.43	13.435	13.33	13.412	13700.0
2022-01-14	AMAX	ETF	9.501	9.572	9.5	9.542	15700.0

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

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