PREVIEW / etf_daily / 2022-02-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-02-07.parquet
  size:    98 KB
  rows:    2,606

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-07	SPY	ETF	449.51	450.99	445.85	447.26	84472900.0
2022-02-07	QQQ	ETF	358.62	361.05	353.84	355.13	58198087.0
2022-02-07	IWM	ETF	198.43	201.16	197.99	199.36	33242600.0
2022-02-07	DIA	ETF	351.26	353.16	349.83	350.9	4746200.0
2022-02-07	GLD	ETF	169.45	170.3	169.19	170.11	7796900.0
2022-02-07	TLT	ETF	138.91	139.31	138.55	139.1	12962400.0
2022-02-07	AAA	ETF	25.0	25.0	25.0	25.0	714.0
2022-02-07	AAAU	ETF	18.04	18.12	18.01	18.1	139600.0
2022-02-07	AADR	ETF	63.0	63.46	62.77	63.27	2900.0
2022-02-07	AAXJ	ETF	81.29	81.66	81.04	81.3	1251600.0
2022-02-07	ABEQ	ETF	28.25	28.52	28.25	28.352	4700.0
2022-02-07	ACES	ETF	51.9	52.61	51.0	51.4	178400.0
2022-02-07	ACIO	ETF	31.575	31.58	31.41	31.41	28200.0
2022-02-07	ACSI	ETF	50.0518	50.0518	50.0518	50.0518	51.0
2022-02-07	ACT	ETF	21.01	21.46	20.93	21.41	136288.0
2022-02-07	ACTV	ETF	34.54	34.82	34.48	34.48	5858.0
2022-02-07	ACTX	ETF	1.02	1.02	1.0	1.0	302.0
2022-02-07	ACVF	ETF	33.5	33.67	33.439	33.439	5400.0
2022-02-07	ACWF	ETF	36.93	37.21	36.93	36.943	21393.0
2022-02-07	ACWI	ETF	100.93	101.42	100.5	100.69	3938700.0
2022-02-07	ACWV	ETF	103.32	103.69	103.07	103.24	160100.0
2022-02-07	ACWX	ETF	54.2	54.575	54.18	54.31	2748161.0
2022-02-07	ADFI	ETF	9.285	9.3	9.27	9.285	57500.0
2022-02-07	ADIV	ETF	16.35	16.4	16.35	16.355	3500.0
2022-02-07	ADME	ETF	41.46	41.48	41.178	41.178	29400.0
2022-02-07	ADRE	ETF	46.2709	46.365	45.905	46.09	8654.0
2022-02-07	AESR	ETF	13.24	13.31	13.197	13.197	19500.0
2022-02-07	AFIF	ETF	9.445	9.47	9.43	9.455	37104.0
2022-02-07	AFK	ETF	20.98	20.98	20.8	20.86	4892.0
2022-02-07	AFLG	ETF	26.41	26.41	26.259	26.259	400.0
2022-02-07	AGG	ETF	110.57	110.71	110.47	110.67	6723400.0
2022-02-07	AGGY	ETF	49.71	49.778	49.67	49.74	92500.0
2022-02-07	AGNG	ETF	26.705	26.78	26.63	26.63	1800.0
2022-02-07	AGOV	ETF	96.3365	96.3365	96.3365	96.3365	5.0
2022-02-07	AGOX	ETF	24.09	24.18	23.971	24.0	56700.0
2022-02-07	AGQ	ETF	33.11	33.74	32.92	33.51	878700.0
2022-02-07	AGZ	ETF	115.31	115.39	115.28	115.31	26958.0
2022-02-07	AGZD	ETF	23.31	23.36	23.24	23.255	144800.0
2022-02-07	AHHX	ETF	10.58	10.58	9.695	10.0942	1232.0
2022-02-07	AHYB	ETF	48.411	48.411	48.381	48.381	200.0
2022-02-07	AIA	ETF	76.81	77.315	76.61	76.96	35513.0
2022-02-07	AIEQ	ETF	36.69	36.915	36.45	36.5	24200.0
2022-02-07	AIQ	ETF	28.25	28.4	28.0	28.0	15354.0
2022-02-07	AIRR	ETF	40.1	40.482	40.004	40.26	27300.0
2022-02-07	AIVI	ETF	42.49	42.71	42.49	42.58	9400.0
2022-02-07	AIVL	ETF	98.39	99.11	98.39	98.43	14900.0
2022-02-07	ALTL	ETF	44.52	44.5866	44.28	44.39	249425.0
2022-02-07	ALTY	ETF	12.91	13.01	12.89	12.9	28300.0
2022-02-07	AMAX	ETF	9.11	9.25	9.11	9.19	980900.0
2022-02-07	AMJ	ETF	20.68	20.97	20.58	20.78	999591.0

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

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