PREVIEW / etf_daily / 2022-06-06

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-06.parquet
  size:    101 KB
  rows:    2,730

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-06-06	SPY	ETF	414.78	416.61	410.55	411.79	57508900.0
2022-06-06	QQQ	ETF	310.75	312.35	305.62	307.22	51785013.0
2022-06-06	IWM	ETF	189.29	189.31	186.83	187.87	24678700.0
2022-06-06	DIA	ETF	331.59	332.74	328.53	329.45	1957600.0
2022-06-06	GLD	ETF	172.81	172.89	171.65	171.82	3766000.0
2022-06-06	TLT	ETF	115.15	115.51	113.81	113.89	20815400.0
2022-06-06	AAA	ETF	24.42	24.47	24.42	24.47	227.0
2022-06-06	AAAU	ETF	18.41	18.42	18.29	18.3	837700.0
2022-06-06	AADR	ETF	57.16	57.16	56.72	56.72	2300.0
2022-06-06	AAXJ	ETF	72.49	72.71	71.66	71.86	913900.0
2022-06-06	ABEQ	ETF	29.037	29.037	28.837	28.882	7400.0
2022-06-06	ACES	ETF	55.34	55.77	54.22	54.77	140200.0
2022-06-06	ACIO	ETF	30.31	30.31	30.09	30.18	78600.0
2022-06-06	ACSI	ETF	45.2361	45.2361	45.2361	45.2361	88.0
2022-06-06	ACT	ETF	25.49	25.855	24.59	24.8	575964.0
2022-06-06	ACTV	ETF	33.3799	33.39	33.12	33.154	9036.0
2022-06-06	ACTX	ETF	0.998	0.998	0.54	0.9	2531.0
2022-06-06	ACVF	ETF	31.22	31.46	31.02	31.094	8700.0
2022-06-06	ACWF	ETF	34.57	34.64	34.4	34.4333	8090.0
2022-06-06	ACWI	ETF	92.9	93.09	91.88	92.08	3043500.0
2022-06-06	ACWV	ETF	99.02	99.25	98.34	98.53	151900.0
2022-06-06	ACWX	ETF	50.06	50.13	49.52	49.61	2845722.0
2022-06-06	ADFI	ETF	8.71	8.72	8.68	8.68	6200.0
2022-06-06	ADIV	ETF	14.83	14.83	14.83	14.83	100.0
2022-06-06	ADME	ETF	37.73	37.89	37.425	37.55	41100.0
2022-06-06	ADRE	ETF	42.34	42.34	41.816	41.93	3620.0
2022-06-06	AESR	ETF	12.29	12.33	12.2	12.25	13300.0
2022-06-06	AFIF	ETF	9.08	9.09	9.06	9.07	49672.0
2022-06-06	AFK	ETF	19.15	19.35	19.15	19.15	5201.0
2022-06-06	AFLG	ETF	24.746	24.746	24.746	24.746	100.0
2022-06-06	AFTY	ETF	17.58	17.58	17.469	17.469	1500.0
2022-06-06	AGG	ETF	102.67	102.77	102.16	102.19	5144500.0
2022-06-06	AGGH	ETF	23.69	23.69	23.61	23.633	301.0
2022-06-06	AGGY	ETF	45.5	45.52	45.25	45.26	198600.0
2022-06-06	AGNG	ETF	25.665	25.71	25.665	25.7	1300.0
2022-06-06	AGOV	ETF	80.56	80.56	80.56	80.56	28.0
2022-06-06	AGOX	ETF	22.55	22.622	22.349	22.41	10200.0
2022-06-06	AGQ	ETF	30.36	30.42	29.48	29.65	473000.0
2022-06-06	AGZ	ETF	110.33	110.33	109.87	109.98	66826.0
2022-06-06	AGZD	ETF	23.075	23.13	23.04	23.085	24600.0
2022-06-06	AHHX	ETF	9.07	9.2	9.07	9.14	4968.0
2022-06-06	AHYB	ETF	45.376	45.376	45.162	45.162	200.0
2022-06-06	AIA	ETF	66.66	66.98	65.89	66.02	59489.0
2022-06-06	AIEQ	ETF	34.91	34.98	34.56	34.625	28000.0
2022-06-06	AIQ	ETF	23.24	23.36	22.93	23.02	51353.0
2022-06-06	AIRR	ETF	41.68	41.95	41.68	41.92	11000.0
2022-06-06	AIVI	ETF	40.01	40.01	39.6	39.71	3100.0
2022-06-06	AIVL	ETF	96.95	97.35	96.51	96.63	10500.0
2022-06-06	ALTL	ETF	42.69	42.7898	42.4456	42.5	55249.0
2022-06-06	ALTY	ETF	12.14	12.19	12.13	12.13	19700.0

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

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