PREVIEW / etf_daily / 2022-07-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-20.parquet
  size:    102 KB
  rows:    2,741

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-07-20	SPY	ETF	392.47	396.26	391.03	394.77	71843800.0
2022-07-20	QQQ	ETF	298.73	304.24	297.9329	303.03	67769430.0
2022-07-20	IWM	ETF	178.65	181.81	178.4	181.49	26049300.0
2022-07-20	DIA	ETF	318.24	319.43	316.45	318.74	3243000.0
2022-07-20	GLD	ETF	159.71	159.82	158.03	158.04	4795800.0
2022-07-20	TLT	ETF	115.48	115.55	114.05	114.61	9117300.0
2022-07-20	AAA	ETF	24.26	24.26	24.25	24.25	15003.0
2022-07-20	AAAU	ETF	17.02	17.02	16.84	16.85	553200.0
2022-07-20	AADR	ETF	48.73	48.84	48.37	48.84	2400.0
2022-07-20	AAXJ	ETF	67.79	68.02	67.53	67.81	1326700.0
2022-07-20	ABEQ	ETF	26.85	26.88	26.746	26.778	31200.0
2022-07-20	ACES	ETF	51.58	52.95	51.5	52.63	48000.0
2022-07-20	ACIO	ETF	29.56	29.665	29.43	29.65	48700.0
2022-07-20	ACSI	ETF	44.5685	44.5685	44.5685	44.5685	38.0
2022-07-20	ACT	ETF	21.73	22.0	21.64	21.95	100070.0
2022-07-20	ACTV	ETF	31.4901	31.9	31.4793	31.8405	11958.0
2022-07-20	ACVF	ETF	29.72	29.8	29.58	29.77	2600.0
2022-07-20	ACWF	ETF	31.95	32.03	31.74	31.9685	7227.0
2022-07-20	ACWI	ETF	86.07	86.71	85.79	86.39	1837500.0
2022-07-20	ACWV	ETF	95.64	95.64	94.77	94.99	306500.0
2022-07-20	ACWX	ETF	45.08	45.14	44.71	44.88	2432701.0
2022-07-20	ADFI	ETF	7.85	8.57	7.85	8.555	2000.0
2022-07-20	ADIV	ETF	13.74	13.74	13.7	13.7	1700.0
2022-07-20	ADME	ETF	35.03	35.555	35.03	35.472	17700.0
2022-07-20	ADRE	ETF	37.7	38.6272	37.7	38.62	2183.0
2022-07-20	AEMB	ETF	37.19	37.19	37.19	37.19	100.0
2022-07-20	AESR	ETF	11.38	11.48	11.38	11.444	8800.0
2022-07-20	AFIF	ETF	8.84	8.86	8.82	8.83	15052.0
2022-07-20	AFK	ETF	16.92	16.92	16.8101	16.9	9998.0
2022-07-20	AFLG	ETF	23.44	23.44	23.29	23.43	700.0
2022-07-20	AFMC	ETF	21.99	22.09	21.99	22.09	200.0
2022-07-20	AFSM	ETF	23.06	23.199	23.06	23.199	200.0
2022-07-20	AFTY	ETF	17.97	17.97	17.901	17.901	300.0
2022-07-20	AGG	ETF	102.16	102.17	101.67	101.71	6124000.0
2022-07-20	AGGY	ETF	45.06	45.1	44.87	44.88	89900.0
2022-07-20	AGNG	ETF	25.91	26.04	25.81	25.81	700.0
2022-07-20	AGOV	ETF	80.96	80.96	80.1513	80.1513	414.0
2022-07-20	AGOX	ETF	20.933	21.044	20.84	20.99	72600.0
2022-07-20	AGQ	ETF	21.46	21.54	20.53	20.53	662900.0
2022-07-20	AGZ	ETF	109.89	109.89	109.531	109.61	11234.0
2022-07-20	AGZD	ETF	22.91	23.035	22.91	22.94	140000.0
2022-07-20	AHHX	ETF	8.58	8.71	8.58	8.6501	8480.0
2022-07-20	AHYB	ETF	44.116	44.116	43.985	43.985	300.0
2022-07-20	AIA	ETF	61.45	61.5665	61.09	61.35	18916.0
2022-07-20	AIEQ	ETF	32.33	33.124	32.33	33.012	6400.0
2022-07-20	AIQ	ETF	21.85	22.23	21.77	22.2	36131.0
2022-07-20	AIRR	ETF	39.25	39.948	39.176	39.87	13500.0
2022-07-20	AIVI	ETF	35.39	35.39	35.05	35.12	4400.0
2022-07-20	AIVL	ETF	91.66	91.75	91.15	91.7	3700.0
2022-07-20	ALTL	ETF	40.91	40.92	40.48	40.6	181042.0

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

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