PREVIEW / etf_daily / 2023-06-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-07.parquet
  size:    110 KB
  rows:    2,968

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
2023-06-07	SPY	ETF	428.44	429.62	426.11	426.55	85373300.0
2023-06-07	QQQ	ETF	355.13	357.12	348.18	348.82	69225936.0
2023-06-07	IWM	ETF	184.96	187.77	184.96	187.24	60685600.0
2023-06-07	DIA	ETF	336.54	337.52	335.93	337.17	2739000.0
2023-06-07	GLD	ETF	181.94	183.0	180.15	180.15	9066500.0
2023-06-07	TLT	ETF	102.17	102.43	100.78	100.88	25251100.0
2023-06-07	AAA	ETF	24.5	24.5	24.5	24.5	133.0
2023-06-07	AAAU	ETF	19.42	19.53	19.23	19.23	1121200.0
2023-06-07	AADR	ETF	48.84	48.84	48.41	48.46	2800.0
2023-06-07	AAPB	ETF	25.62	26.05	25.2915	25.37	8560.0
2023-06-07	AAPD	ETF	21.94	22.0995	21.63	22.06	140309.0
2023-06-07	AAPU	ETF	25.98	26.56	25.72	25.8	145052.0
2023-06-07	AAXJ	ETF	66.78	67.24	66.47	66.59	318200.0
2023-06-07	ABEQ	ETF	28.47	28.47	28.167	28.26	12100.0
2023-06-07	ACES	ETF	45.27	45.87	45.14	45.16	20700.0
2023-06-07	ACIO	ETF	30.43	30.446	30.343	30.369	70800.0
2023-06-07	ACSI	ETF	45.33	45.35	45.33	45.3309	752.0
2023-06-07	ACT	ETF	25.77	26.32	25.665	26.16	327562.0
2023-06-07	ACTV	ETF	30.726	31.0	30.72	30.96	14278.0
2023-06-07	ACVF	ETF	32.57	32.595	32.41	32.445	9600.0
2023-06-07	ACWF	ETF	34.48	34.48	34.15	34.15	7525.0
2023-06-07	ACWI	ETF	93.34	93.58	92.76	92.84	8882900.0
2023-06-07	ACWV	ETF	96.61	96.61	96.13	96.17	178600.0
2023-06-07	ACWX	ETF	48.6	48.805	48.33	48.38	1416273.0
2023-06-07	ADFI	ETF	8.43	8.435	8.427	8.435	5400.0
2023-06-07	ADIV	ETF	13.605	13.605	13.605	13.605	100.0
2023-06-07	ADME	ETF	35.36	35.36	35.18	35.23	29200.0
2023-06-07	ADPV	ETF	23.8	23.8828	23.8	23.8828	362.0
2023-06-07	AEMB	ETF	37.23	37.26	37.21	37.21	300.0
2023-06-07	AESR	ETF	12.37	12.37	12.21	12.233	14500.0
2023-06-07	AFIF	ETF	8.81	8.84	8.78	8.8	173605.0
2023-06-07	AFK	ETF	15.39	15.51	15.37	15.37	18835.0
2023-06-07	AFMC	ETF	23.97	24.094	23.97	24.094	100.0
2023-06-07	AFSM	ETF	24.491	24.491	24.491	24.491	100.0
2023-06-07	AFTY	ETF	14.749	14.749	14.749	14.749	300.0
2023-06-07	AGG	ETF	98.15	98.22	97.59	97.68	5131500.0
2023-06-07	AGGY	ETF	43.15	43.185	42.935	42.95	63700.0
2023-06-07	AGNG	ETF	27.67	27.76	27.53	27.59	4400.0
2023-06-07	AGOV	ETF	76.01	77.24	76.01	77.24	396.0
2023-06-07	AGOX	ETF	22.78	22.78	22.59	22.609	39100.0
2023-06-07	AGQ	ETF	29.31	30.39	28.79	28.83	580100.0
2023-06-07	AGZ	ETF	107.2	107.255	106.7	106.85	224822.0
2023-06-07	AGZD	ETF	21.965	21.965	21.91	21.91	21600.0
2023-06-07	AHYB	ETF	43.5	43.515	43.5	43.515	200.0
2023-06-07	AIA	ETF	60.13	60.5	59.84	59.96	309363.0
2023-06-07	AIEQ	ETF	30.71	31.05	30.63	30.9	24700.0
2023-06-07	AIQ	ETF	26.87	27.05	26.35	26.43	351356.0
2023-06-07	AIRR	ETF	51.44	52.61	51.44	52.42	144900.0
2023-06-07	AIVI	ETF	39.47	39.47	39.35	39.4	2000.0
2023-06-07	AIVL	ETF	90.56	91.49	90.56	91.46	11200.0

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

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