PREVIEW / etf_daily / 2023-06-16

all etf daily files

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

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-16	SPY	ETF	443.02	443.61	438.97	439.46	114121300.0
2023-06-16	QQQ	ETF	372.72	372.85	367.48	367.93	80931971.0
2023-06-16	IWM	ETF	187.95	188.55	185.09	185.94	50674000.0
2023-06-16	DIA	ETF	345.35	345.73	342.72	342.95	5574600.0
2023-06-16	GLD	ETF	181.93	182.62	181.41	181.63	8778600.0
2023-06-16	TLT	ETF	102.44	102.83	102.03	102.6	16758200.0
2023-06-16	AAA	ETF	24.57	24.605	24.57	24.605	1029.0
2023-06-16	AAAU	ETF	19.43	19.49	19.36	19.39	1231600.0
2023-06-16	AADR	ETF	50.56	50.58	50.35	50.48	1500.0
2023-06-16	AAPB	ETF	27.161	27.33	27.03	27.15	17304.0
2023-06-16	AAPD	ETF	21.0313	21.2501	21.02	21.24	39188.0
2023-06-16	AAPU	ETF	27.67	27.74	27.27	27.36	136338.0
2023-06-16	AAXJ	ETF	69.18	69.22	68.76	68.96	530200.0
2023-06-16	ABEQ	ETF	28.49	28.49	28.39	28.45	7200.0
2023-06-16	ACES	ETF	46.62	46.62	45.41	45.55	112000.0
2023-06-16	ACIO	ETF	31.0	31.14	30.97	31.0	27900.0
2023-06-16	ACSI	ETF	46.3453	46.3453	46.3453	46.3453	17.0
2023-06-16	ACT	ETF	25.47	25.54	24.825	24.94	282979.0
2023-06-16	ACTV	ETF	31.68	31.68	31.3999	31.4046	4329.0
2023-06-16	ACVF	ETF	34.07	34.085	33.63	33.655	23700.0
2023-06-16	ACWF	ETF	35.61	35.61	35.3431	35.3431	2158.0
2023-06-16	ACWI	ETF	96.81	96.81	96.0	96.08	2292300.0
2023-06-16	ACWV	ETF	98.77	98.77	98.02	98.31	145500.0
2023-06-16	ACWX	ETF	50.36	50.3702	50.05	50.07	1210334.0
2023-06-16	ADFI	ETF	8.455	8.46	8.441	8.455	4500.0
2023-06-16	ADIV	ETF	14.017	14.017	14.017	14.017	100.0
2023-06-16	ADME	ETF	36.22	36.35	36.08	36.16	17300.0
2023-06-16	AEMB	ETF	37.6	37.645	37.59	37.645	300.0
2023-06-16	AESR	ETF	12.8	12.81	12.71	12.73	185900.0
2023-06-16	AFIF	ETF	8.94	8.94	8.77	8.7752	125936.0
2023-06-16	AFK	ETF	15.79	15.82	15.61	15.61	4213.0
2023-06-16	AFLG	ETF	25.19	25.19	25.142	25.142	200.0
2023-06-16	AFMC	ETF	24.32	24.32	24.26	24.263	900.0
2023-06-16	AFSM	ETF	24.27	24.356	24.27	24.356	1800.0
2023-06-16	AFTY	ETF	15.53	15.53	15.5	15.525	3000.0
2023-06-16	AGG	ETF	98.09	98.28	97.91	98.14	5653700.0
2023-06-16	AGGH	ETF	22.7299	22.75	22.705	22.7057	5809.0
2023-06-16	AGGY	ETF	43.17	43.24	43.12	43.22	112800.0
2023-06-16	AGNG	ETF	28.47	28.47	28.42	28.42	600.0
2023-06-16	AGOV	ETF	78.67	79.04	76.0	76.0	874.0
2023-06-16	AGOX	ETF	23.36	23.53	23.34	23.391	15300.0
2023-06-16	AGQ	ETF	30.28	30.66	29.86	30.5	498600.0
2023-06-16	AGZ	ETF	107.0	107.16	106.96	107.0804	37356.0
2023-06-16	AGZD	ETF	22.06	22.08	22.055	22.08	20200.0
2023-06-16	AHOY	ETF	20.56	20.56	20.5232	20.5232	253.0
2023-06-16	AHYB	ETF	43.861	43.885	43.861	43.864	1300.0
2023-06-16	AIA	ETF	63.21	63.21	62.5209	62.72	54152.0
2023-06-16	AIEQ	ETF	31.77	31.77	31.385	31.41	18400.0
2023-06-16	AIQ	ETF	28.76	28.76	28.25	28.31	713480.0
2023-06-16	AIRR	ETF	52.42	52.42	51.664	51.93	27000.0

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

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