PREVIEW / etf_daily / 2023-06-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-01.parquet
  size:    111 KB
  rows:    2,980

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-01	SPY	ETF	418.09	422.92	416.79	421.82	88865000.0
2023-06-01	QQQ	ETF	347.73	353.36	346.66	352.01	50488601.0
2023-06-01	IWM	ETF	173.86	176.24	172.93	175.65	27800900.0
2023-06-01	DIA	ETF	328.91	331.98	327.32	330.94	3081300.0
2023-06-01	GLD	ETF	182.81	184.21	182.72	183.76	7300500.0
2023-06-01	TLT	ETF	103.28	103.63	102.63	103.12	21040400.0
2023-06-01	AAA	ETF	24.441	24.51	24.441	24.48	1723.0
2023-06-01	AAAU	ETF	19.52	19.66	19.51	19.61	1061700.0
2023-06-01	AADR	ETF	46.49	47.66	45.95	46.96	8000.0
2023-06-01	AAPB	ETF	25.4	25.96	25.23	25.94	10547.0
2023-06-01	AAPD	ETF	22.03	22.14	21.73	21.73	81632.0
2023-06-01	AAPU	ETF	25.85	26.35	25.75	26.35	97431.0
2023-06-01	AAXJ	ETF	64.75	65.86	64.75	65.83	686500.0
2023-06-01	ABEQ	ETF	27.68	27.82	27.68	27.81	4600.0
2023-06-01	ACES	ETF	43.16	44.045	42.68	43.79	331300.0
2023-06-01	ACIO	ETF	30.03	30.266	30.03	30.23	26200.0
2023-06-01	ACSI	ETF	44.3472	44.3472	44.3472	44.3472	29.0
2023-06-01	ACT	ETF	24.45	25.01	24.27	24.95	173432.0
2023-06-01	ACTV	ETF	29.22	29.63	29.22	29.4237	7187.0
2023-06-01	ACTX	ETF	0.285	0.285	0.285	0.285	695.0
2023-06-01	ACVF	ETF	31.75	32.16	31.63	31.987	34300.0
2023-06-01	ACWF	ETF	33.73	34.225	33.73	34.1637	44439.0
2023-06-01	ACWI	ETF	91.77	92.91	91.64	92.71	5391900.0
2023-06-01	ACWV	ETF	96.58	96.85	96.23	96.84	63200.0
2023-06-01	ACWX	ETF	48.06	48.64	48.03	48.61	1430885.0
2023-06-01	ADFI	ETF	8.45	8.48	8.45	8.465	6300.0
2023-06-01	ADIV	ETF	13.34	13.34	13.34	13.34	100.0
2023-06-01	ADME	ETF	34.98	35.06	34.7	34.96	61100.0
2023-06-01	ADPV	ETF	22.78	22.9601	22.78	22.9175	1158.0
2023-06-01	AEMB	ETF	37.01	37.251	37.01	37.251	900.0
2023-06-01	AESR	ETF	12.11	12.28	12.11	12.243	16900.0
2023-06-01	AFIF	ETF	8.8239	8.8239	8.78	8.81	54746.0
2023-06-01	AFK	ETF	15.14	15.26	14.85	15.0762	5695.0
2023-06-01	AFMC	ETF	22.71	22.71	22.654	22.654	200.0
2023-06-01	AFSM	ETF	22.852	22.852	22.852	22.852	100.0
2023-06-01	AFTY	ETF	14.88	14.88	14.874	14.874	100.0
2023-06-01	AGG	ETF	98.6	98.8	98.48	98.61	9029800.0
2023-06-01	AGGH	ETF	22.78	22.84	22.7702	22.8127	996.0
2023-06-01	AGGY	ETF	43.35	43.4	43.29	43.34	80700.0
2023-06-01	AGNG	ETF	27.283	27.33	27.283	27.33	1200.0
2023-06-01	AGOV	ETF	76.2	77.3297	76.2	77.3297	195.0
2023-06-01	AGOX	ETF	22.01	22.42	22.01	22.28	9700.0
2023-06-01	AGQ	ETF	29.06	30.08	29.0	29.96	595800.0
2023-06-01	AGZ	ETF	107.65	107.75	107.1261	107.595	882129.0
2023-06-01	AGZD	ETF	21.815	21.855	21.81	21.85	87400.0
2023-06-01	AHYB	ETF	43.43	43.555	43.43	43.514	1000.0
2023-06-01	AIA	ETF	57.87	59.0996	57.79	59.01	24427.0
2023-06-01	AIEQ	ETF	29.38	29.89	29.28	29.73	22600.0
2023-06-01	AIQ	ETF	26.1	26.609	26.0	26.5	424270.0
2023-06-01	AIRR	ETF	47.88	48.465	47.635	48.235	79100.0

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

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