PREVIEW / etf_daily / 2022-01-06

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-06.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-06	SPY	ETF	467.89	470.82	465.43	467.94	86858900.0
2022-01-06	QQQ	ETF	382.42	387.35	380.13	384.02	70814324.0
2022-01-06	IWM	ETF	217.82	220.42	215.82	218.6	39105900.0
2022-01-06	DIA	ETF	364.11	364.65	361.96	362.39	7019800.0
2022-01-06	GLD	ETF	167.16	167.75	166.86	166.99	10902700.0
2022-01-06	TLT	ETF	142.59	143.44	142.29	143.29	18996400.0
2022-01-06	AAA	ETF	25.0	25.0	24.995	25.0	3176.0
2022-01-06	AAAU	ETF	17.79	17.84	17.76	17.77	193200.0
2022-01-06	AADR	ETF	63.04	63.89	63.04	63.66	2400.0
2022-01-06	AAXJ	ETF	81.73	82.3	81.41	81.96	597400.0
2022-01-06	ABEQ	ETF	28.22	28.66	28.22	28.523	9400.0
2022-01-06	ACES	ETF	60.66	60.87	58.602	59.86	61900.0
2022-01-06	ACIO	ETF	32.23	32.278	32.175	32.2	33500.0
2022-01-06	ACSI	ETF	52.35	52.35	52.1679	52.1679	2568.0
2022-01-06	ACT	ETF	21.85	22.01	21.38	21.97	103383.0
2022-01-06	ACTV	ETF	36.82	36.95	36.6493	36.6493	3807.0
2022-01-06	ACVF	ETF	35.29	35.29	34.91	35.067	9400.0
2022-01-06	ACWF	ETF	38.83	39.015	38.68	38.7788	29250.0
2022-01-06	ACWI	ETF	104.32	104.95	103.8	104.3	6908700.0
2022-01-06	ACWV	ETF	106.22	106.66	106.1	106.23	117600.0
2022-01-06	ACWX	ETF	55.35	55.5884	55.11	55.35	1746793.0
2022-01-06	ADFI	ETF	9.49	9.5	9.462	9.495	4100.0
2022-01-06	ADIV	ETF	16.51	16.52	16.463	16.463	1100.0
2022-01-06	ADME	ETF	42.49	42.556	42.38	42.45	28300.0
2022-01-06	ADRE	ETF	45.77	46.44	45.554	46.28	114424.0
2022-01-06	AEMB	ETF	47.69	47.727	47.67	47.727	2000.0
2022-01-06	AESR	ETF	13.85	13.91	13.82	13.82	6300.0
2022-01-06	AFIF	ETF	9.53	9.53	9.51	9.53	21990.0
2022-01-06	AFK	ETF	20.49	20.49	20.01	20.29	3748.0
2022-01-06	AFLG	ETF	27.56	27.59	27.512	27.512	10200.0
2022-01-06	AFMC	ETF	26.354	26.354	26.24	26.24	300.0
2022-01-06	AFSM	ETF	27.25	27.41	27.192	27.192	400.0
2022-01-06	AFTY	ETF	20.36	20.36	20.295	20.313	800.0
2022-01-06	AGG	ETF	112.75	112.84	112.66	112.82	8866500.0
2022-01-06	AGGY	ETF	50.94	50.99	50.92	50.974	97100.0
2022-01-06	AGNG	ETF	28.0	28.015	27.65	27.695	7300.0
2022-01-06	AGOV	ETF	96.69	96.77	96.69	96.77	730.0
2022-01-06	AGOX	ETF	25.115	25.18	24.94	25.072	70900.0
2022-01-06	AGQ	ETF	30.91	31.69	30.84	31.33	1132300.0
2022-01-06	AGZ	ETF	116.56	116.56	116.4103	116.495	39791.0
2022-01-06	AGZD	ETF	23.395	23.405	23.345	23.395	148000.0
2022-01-06	AHHX	ETF	10.19	10.27	10.14	10.205	53923.0
2022-01-06	AHYB	ETF	49.816	49.835	49.78	49.78	300.0
2022-01-06	AIA	ETF	75.63	76.46	75.45	75.9713	112118.0
2022-01-06	AIEQ	ETF	39.32	39.68	39.01	39.3	31500.0
2022-01-06	AIQ	ETF	30.26	30.575	30.02	30.3	33819.0
2022-01-06	AIRR	ETF	45.09	45.4	44.85	45.21	22200.0
2022-01-06	AIVI	ETF	42.32	42.4	42.21	42.21	6500.0
2022-01-06	ALTL	ETF	46.47	46.5199	46.16	46.22	111559.0
2022-01-06	ALTY	ETF	13.43	13.43	13.3	13.369	19800.0

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

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