PREVIEW / etf_daily / 2023-06-28

all etf daily files

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

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-28	SPY	ETF	435.05	437.44	434.41	436.39	75636000.0
2023-06-28	QQQ	ETF	361.98	366.52	361.9038	364.54	46498031.0
2023-06-28	IWM	ETF	182.99	184.42	182.12	184.26	23187600.0
2023-06-28	DIA	ETF	338.73	338.94	337.43	338.63	2305000.0
2023-06-28	GLD	ETF	177.23	177.69	176.7	177.28	5866700.0
2023-06-28	TLT	ETF	103.41	103.84	102.83	103.61	23826800.0
2023-06-28	AAA	ETF	24.631	24.67	24.631	24.67	160.0
2023-06-28	AAAU	ETF	18.91	18.97	18.87	18.92	1147800.0
2023-06-28	AADR	ETF	48.98	48.98	48.98	48.98	100.0
2023-06-28	AAPB	ETF	27.86	28.2	27.86	28.12	10587.0
2023-06-28	AAPD	ETF	20.68	20.7	20.47	20.54	314950.0
2023-06-28	AAPU	ETF	27.85	28.25	27.75	28.12	80651.0
2023-06-28	AAXJ	ETF	66.24	66.51	66.17	66.45	435100.0
2023-06-28	ABEQ	ETF	27.96	28.14	27.96	28.101	13500.0
2023-06-28	ACES	ETF	43.01	43.71	43.01	43.4	32200.0
2023-06-28	ACIO	ETF	30.72	30.78	30.693	30.76	45900.0
2023-06-28	ACSI	ETF	46.3789	46.3789	46.3789	46.3789	40.0
2023-06-28	ACT	ETF	24.56	24.675	24.375	24.62	137093.0
2023-06-28	ACTV	ETF	30.87	31.09	30.85	31.0858	5641.0
2023-06-28	ACTX	ETF	0.21	0.21	0.21	0.21	505.0
2023-06-28	ACVF	ETF	33.17	33.3	33.155	33.207	5300.0
2023-06-28	ACWF	ETF	34.78	34.8895	34.78	34.8583	14263.0
2023-06-28	ACWI	ETF	94.5	94.92	94.36	94.73	1317500.0
2023-06-28	ACWV	ETF	97.46	97.46	97.01	97.25	272900.0
2023-06-28	ACWX	ETF	48.76	48.88	48.67	48.83	638736.0
2023-06-28	ADFI	ETF	8.465	8.47	8.45	8.465	9000.0
2023-06-28	ADIV	ETF	13.64	13.64	13.64	13.64	100.0
2023-06-28	ADME	ETF	35.72	35.9	35.72	35.86	8700.0
2023-06-28	AEMB	ETF	37.745	37.805	37.745	37.805	200.0
2023-06-28	AESR	ETF	12.69	12.69	12.61	12.64	20400.0
2023-06-28	AFIF	ETF	8.79	8.81	8.77	8.79	44665.0
2023-06-28	AFK	ETF	14.99	14.99	14.51	14.82	11505.0
2023-06-28	AFLG	ETF	25.002	25.002	25.002	25.002	100.0
2023-06-28	AFMC	ETF	24.33	24.406	24.33	24.406	2400.0
2023-06-28	AFSM	ETF	24.19	24.311	24.19	24.311	1200.0
2023-06-28	AFTY	ETF	14.77	14.77	14.77	14.77	100.0
2023-06-28	AGG	ETF	98.34	98.54	98.2	98.48	8622900.0
2023-06-28	AGGH	ETF	22.61	22.61	22.5804	22.5804	123.0
2023-06-28	AGGY	ETF	43.17	43.24	43.1	43.215	232100.0
2023-06-28	AGNG	ETF	27.535	27.61	27.5	27.543	3700.0
2023-06-28	AGOV	ETF	75.035	75.035	75.035	75.035	53.0
2023-06-28	AGOX	ETF	22.94	23.15	22.94	23.06	33800.0
2023-06-28	AGQ	ETF	26.93	27.24	26.5	26.88	415900.0
2023-06-28	AGZ	ETF	107.21	107.31	107.14	107.2728	8289.0
2023-06-28	AGZD	ETF	22.0	22.05	22.0	22.045	38000.0
2023-06-28	AHYB	ETF	43.722	43.921	43.722	43.921	400.0
2023-06-28	AIA	ETF	59.86	60.03	59.66	59.97	29034.0
2023-06-28	AIEQ	ETF	30.99	31.091	30.9	31.06	7100.0
2023-06-28	AIQ	ETF	27.52	27.84	27.5	27.68	222067.0
2023-06-28	AIRR	ETF	52.42	52.79	52.16	52.44	59100.0

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

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