PREVIEW / etf_daily / 2023-05-04

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-04.parquet
  size:    110 KB
  rows:    2,970

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-05-04	SPY	ETF	406.93	407.27	403.74	405.13	94901900.0
2023-05-04	QQQ	ETF	317.06	318.23	315.115	316.17	50224520.0
2023-05-04	IWM	ETF	171.32	171.56	168.78	170.4	42382100.0
2023-05-04	DIA	ETF	333.28	333.59	329.37	331.33	3576800.0
2023-05-04	GLD	ETF	188.86	191.36	188.81	190.44	14146800.0
2023-05-04	TLT	ETF	105.22	106.45	105.15	105.24	25110500.0
2023-05-04	AAA	ETF	24.53	24.53	24.53	24.53	93.0
2023-05-04	AAAU	ETF	20.16	20.43	20.15	20.32	2329800.0
2023-05-04	AADR	ETF	46.5	46.56	46.25	46.34	3500.0
2023-05-04	AAPB	ETF	22.5	22.93	22.38	22.69	12488.0
2023-05-04	AAPD	ETF	23.76	23.78	23.4257	23.61	579426.0
2023-05-04	AAPU	ETF	23.15	23.59	23.0789	23.36	216085.0
2023-05-04	AAXJ	ETF	66.25	66.57	66.1	66.3	3364200.0
2023-05-04	ABEQ	ETF	28.66	28.73	28.57	28.65	10200.0
2023-05-04	ACES	ETF	40.98	40.98	40.14	40.32	109300.0
2023-05-04	ACIO	ETF	29.81	29.929	29.81	29.84	35700.0
2023-05-04	ACSI	ETF	42.9575	42.9575	42.9575	42.9575	34.0
2023-05-04	ACT	ETF	23.8	23.96	21.81	22.19	421370.0
2023-05-04	ACTV	ETF	28.8	28.8	28.29	28.3544	20326.0
2023-05-04	ACTX	ETF	0.3	0.3	0.3	0.3	101.0
2023-05-04	ACVF	ETF	30.83	30.892	30.69	30.752	8600.0
2023-05-04	ACWF	ETF	33.41	33.471	33.39	33.4399	1469.0
2023-05-04	ACWI	ETF	91.02	91.11	90.5	90.77	2789300.0
2023-05-04	ACWV	ETF	99.03	99.43	98.95	99.07	182400.0
2023-05-04	ACWX	ETF	49.13	49.33	49.05	49.17	882931.0
2023-05-04	ADFI	ETF	8.545	8.545	8.52	8.525	11400.0
2023-05-04	ADIV	ETF	13.63	13.81	13.59	13.61	2800.0
2023-05-04	ADME	ETF	34.55	34.55	34.32	34.35	20500.0
2023-05-04	AEMB	ETF	37.63	37.63	37.63	37.63	100.0
2023-05-04	AESR	ETF	11.92	11.945	11.89	11.91	12500.0
2023-05-04	AFIF	ETF	8.86	8.86	8.81	8.8348	12580.0
2023-05-04	AFK	ETF	15.6	15.7138	15.57	15.57	1466.0
2023-05-04	AFLG	ETF	23.491	23.491	23.491	23.491	500.0
2023-05-04	AFMC	ETF	22.47	22.47	22.431	22.431	100.0
2023-05-04	AFSM	ETF	22.17	22.197	22.17	22.197	100.0
2023-05-04	AFTY	ETF	16.16	16.18	16.16	16.18	200.0
2023-05-04	AGG	ETF	99.77	100.42	99.75	99.97	5262200.0
2023-05-04	AGGH	ETF	23.32	24.2	23.1132	23.1132	83447.0
2023-05-04	AGGY	ETF	43.86	44.09	43.86	43.94	76900.0
2023-05-04	AGNG	ETF	27.97	28.06	27.96	27.99	3100.0
2023-05-04	AGOV	ETF	77.08	78.645	77.08	78.645	1161.0
2023-05-04	AGOX	ETF	21.27	21.29	21.17	21.232	17800.0
2023-05-04	AGQ	ETF	34.78	36.28	34.76	36.28	1441400.0
2023-05-04	AGZ	ETF	108.67	109.165	108.67	108.85	22759.0
2023-05-04	AGZD	ETF	21.71	21.78	21.62	21.715	55600.0
2023-05-04	AHYB	ETF	43.596	43.615	43.596	43.615	400.0
2023-05-04	AIA	ETF	57.95	58.38	57.95	58.23	51380.0
2023-05-04	AIEQ	ETF	26.9	26.9	26.62	26.744	13200.0
2023-05-04	AIQ	ETF	23.44	23.55	23.25	23.41	184168.0
2023-05-04	AIRR	ETF	45.38	45.38	44.174	44.71	67800.0

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

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