PREVIEW / etf_daily / 2022-02-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-02-01.parquet
  size:    100 KB
  rows:    2,649

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-02-01	SPY	ETF	450.68	453.63	446.94	452.95	123155400.0
2022-02-01	QQQ	ETF	364.43	366.19	359.14	365.52	74433023.0
2022-02-01	IWM	ETF	201.66	203.57	197.97	203.36	43429400.0
2022-02-01	DIA	ETF	351.66	354.27	349.68	353.94	7636000.0
2022-02-01	GLD	ETF	168.57	168.85	167.87	168.23	9763900.0
2022-02-01	TLT	ETF	142.28	142.36	141.06	141.72	20806100.0
2022-02-01	AAA	ETF	24.99	25.0	24.99	25.0	826.0
2022-02-01	AAAU	ETF	17.93	17.97	17.87	17.91	249300.0
2022-02-01	AADR	ETF	62.82	63.55	62.82	63.5	2100.0
2022-02-01	AAXJ	ETF	81.94	82.09	81.18	82.03	1065600.0
2022-02-01	ABEQ	ETF	28.27	28.423	28.27	28.423	7500.0
2022-02-01	ACES	ETF	53.78	54.17	52.44	53.98	157000.0
2022-02-01	ACIO	ETF	31.59	31.83	31.52	31.79	51500.0
2022-02-01	ACSI	ETF	50.182	50.182	50.182	50.182	63.0
2022-02-01	ACT	ETF	21.83	22.215	21.615	22.14	119699.0
2022-02-01	ACTV	ETF	35.13	35.2977	35.05	35.2977	5410.0
2022-02-01	ACVF	ETF	33.61	33.843	33.54	33.843	7200.0
2022-02-01	ACWF	ETF	37.13	37.2745	36.825	37.2745	18125.0
2022-02-01	ACWI	ETF	101.19	101.83	100.48	101.75	3796400.0
2022-02-01	ACWV	ETF	103.24	103.62	102.66	103.6	322400.0
2022-02-01	ACWX	ETF	54.43	54.62	54.05	54.61	5633941.0
2022-02-01	ADFI	ETF	9.33	9.39	9.33	9.362	4800.0
2022-02-01	ADIV	ETF	16.23	16.23	16.23	16.23	200.0
2022-02-01	ADME	ETF	41.45	41.84	41.372	41.84	29000.0
2022-02-01	ADRE	ETF	46.98	47.4263	46.9152	47.21	9637.0
2022-02-01	AESR	ETF	13.2	13.26	13.17	13.21	17800.0
2022-02-01	AFIF	ETF	9.42	9.45	9.42	9.45	56915.0
2022-02-01	AFK	ETF	20.83	20.83	20.6801	20.79	8495.0
2022-02-01	AFLG	ETF	26.38	26.555	26.38	26.555	2300.0
2022-02-01	AFMC	ETF	24.84	24.84	24.84	24.84	100.0
2022-02-01	AFSM	ETF	25.14	25.301	25.14	25.301	300.0
2022-02-01	AFTY	ETF	19.7	19.774	19.7	19.774	5100.0
2022-02-01	AGG	ETF	111.66	111.68	111.38	111.6	10356000.0
2022-02-01	AGGY	ETF	50.26	50.31	50.17	50.245	122500.0
2022-02-01	AGNG	ETF	26.73	26.865	26.57	26.865	59300.0
2022-02-01	AGOV	ETF	96.5483	96.5483	96.4649	96.4649	225.0
2022-02-01	AGOX	ETF	24.01	24.32	23.982	24.289	91600.0
2022-02-01	AGQ	ETF	33.28	33.45	32.09	32.36	988100.0
2022-02-01	AGZ	ETF	115.89	115.9544	115.8	115.88	36456.0
2022-02-01	AGZD	ETF	23.25	23.285	23.225	23.275	156800.0
2022-02-01	AHHX	ETF	9.94	9.96	9.88	9.9195	111235.0
2022-02-01	AHYB	ETF	48.788	48.935	48.788	48.935	1000.0
2022-02-01	AIA	ETF	77.53	77.81	76.9004	77.79	76438.0
2022-02-01	AIEQ	ETF	37.0	37.36	36.565	37.28	39300.0
2022-02-01	AIQ	ETF	28.94	29.07	28.49	29.07	19361.0
2022-02-01	AIRR	ETF	41.11	41.39	40.57	41.35	31100.0
2022-02-01	AIVI	ETF	42.3	42.36	42.02	42.35	9600.0
2022-02-01	AIVL	ETF	98.1	98.94	97.93	98.92	8200.0
2022-02-01	ALTL	ETF	44.87	44.87	44.19	44.58	337363.0
2022-02-01	ALTY	ETF	13.13	13.23	13.09	13.23	67500.0

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

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