Calendar

Date	Type	Description
2024-Apr-23 (Tue)	Syndoic(29)	FM
2024-May-07 (Tue)	Syndoic(29)	NM
2024-May-23 (Thu)	Syndoic(29)	FM
2024-Jun-06 (Thu)	Syndoic(29)	NM

select t.ticker, t.timepoint, t.adjClose as xclose from stocks t inner join ( select ticker, max(timepoint) as MaxDate from stocks group by ticker ) tm on t.ticker = tm.ticker and t.timepoint = tm.MaxDate ORDER BY ticker

Row	Ticker	High	Lows	Current	Discount
0	ABR	19.01	2.82	13.2	-31 %
1	ACWF	41.46	17.71	40.19	-3 %
2	AIA	100.25	32.17	59.97	-40 %
3	AOA	73.59	25.84	71.26	-3 %
4	AOK	39.82	12.77	35.95	-10 %
5	AOM	45.32	18.28	41.6	-8 %
6	AOR	56.83	22.44	54.09	-5 %
7	ARCC	20.86	4.99	20.74	-1 %
8	BBDC	10.83	3.9	9.26	-14 %
9	BNO	36.84	5.91	32.43	-12 %
10	BRZU	3060.57	32.48	78.98	-97 %
11	CANE	15.51	4.91	12.03	-22 %
12	CCRV	31.82	15.24	21.79	-32 %
13	CEMB	50.92	34.52	43.83	-14 %
14	CMDY	68.21	28.37	49.74	-27 %
15	COMT	46.28	16.53	27.63	-40 %
16	CORN	30.3	11.52	20.16	-33 %
17	CPER	30.12	12.87	27.67	-8 %
18	CSWC	26.17	2.32	25.69	-2 %
19	CURE	149.45	15.71	108.13	-28 %
20	DBA	26.53	13.15	25.95	-2 %
21	DBB	27.01	10.64	19.9	-26 %
22	DFEN	70.21	4.93	24.94	-64 %
23	DGRO	58.19	19.32	56.54	-3 %
24	DIA	398.82	130.06	385.02	-3 %
25	DIVB	44.59	18.55	43.03	-3 %
26	DIVO	38.99	17.23	38.24	-2 %
27	DPST	180.96	3.46	70.67	-61 %
28	DRN	32.89	4.1	7.64	-77 %
29	DUSL	56.74	5.82	52.05	-8 %
30	DVY	132.42	37.75	120.22	-9 %
31	DVYA	40.17	21.59	36.19	-10 %
32	DVYE	39.5	17.86	26.56	-33 %
33	EDC	163.59	20.1	28.67	-82 %
34	EDEN	124.64	40.6	120.82	-3 %
35	EEM	56.68	24.17	40.47	-29 %
36	EEMA	97.72	38.61	67.24	-31 %
37	EEMS	61.42	25.54	58.55	-5 %
38	EEMV	64.05	37.22	55.71	-13 %
39	EFNL	49.8	22.12	35.78	-28 %
40	EIDO	28.16	11.39	21.11	-25 %
41	EIRL	69.65	24.73	67.84	-3 %
42	EIS	79.14	36.04	59.49	-25 %
43	EMB	109.1	75.38	88.11	-19 %
44	EMGF	53.29	25.3	44.09	-17 %
45	EMHY	43.23	28.38	37.06	-14 %
46	EMIF	31.08	15.77	21.93	-29 %
47	ENB	43.03	17.09	35.42	-18 %
48	ENOR	31.01	11.81	23.58	-24 %
49	ENZL	69.19	24.75	44.04	-36 %
50	EPHE	40.48	18.43	25.24	-38 %
51	EPOL	27.95	10.45	24.05	-14 %
52	ERX	619.89	4.69	72.87	-88 %
53	EUFN	23.12	9.61	22.67	-2 %
54	EWA	26.31	11.47	23.86	-9 %
55	EWC	40.81	15.8	37.7	-8 %
56	EWD	46.3	19.48	39.49	-15 %
57	EWG	34.5	16.25	30.93	-10 %
58	EWI	37.96	16.24	37.61	-1 %
59	EWJ	72.44	36.44	67.32	-7 %
60	EWJV	33.53	17.29	32.01	-5 %
61	EWK	22.06	11.03	18.66	-15 %
62	EWL	52	23.12	46.44	-11 %
63	EWM	30.99	17.17	22.03	-29 %
64	EWN	53.11	18.85	48.49	-9 %
65	EWO	26.51	9.76	22.11	-17 %
66	EWP	32.57	16.36	32.04	-2 %
67	EWQ	41.88	17.83	40.65	-3 %
68	EWRE	42.07	17.46	31.15	-26 %
69	EWS	23.49	13.65	18.91	-19 %
70	EWU	34.53	17.86	34.27	-1 %
71	EWUS	48.67	20.13	34.29	-30 %
72	EWY	94.27	37.17	62.99	-33 %
73	EWZ	41.54	13.44	31.16	-25 %
74	EWZS	20.97	4.68	13.25	-37 %
75	EXI	140.09	53.64	135.95	-3 %
76	EZA	59.17	21.81	38.84	-34 %
77	EZU	51.46	23.59	50.11	-3 %
78	FALN	29.44	17.47	26.23	-11 %
79	FAS	155.51	13.98	103.56	-33 %
80	FAZ	2682.62	9.74	10.58	-100 %
81	FILL	27.99	7.07	27.38	-2 %
82	FM	35.64	17.88	27.3	-23 %
83	FNGU	354.87	2.24	280.13	-21 %
84	GAIN	14.96	3.13	14.22	-5 %
85	GLTR	107.47	51.61	100.82	-6 %
86	GOOGL	160.22	24.55	158.26	-1 %
87	GSG	26.49	7.5	22.63	-15 %
88	GYLD	15.81	7.38	13.07	-17 %
89	HDV	110.33	31.12	109.24	-1 %
90	HYG	84.96	54.4	76.71	-10 %
91	IAI	116.16	25.52	113.1	-3 %
92	IAK	117.6	25.25	113.74	-3 %
93	IAU	45.98	20.23	43.91	-5 %
94	IBB	176.98	78.88	128.02	-28 %
95	ICF	76.09	26.14	53.8	-29 %
96	IDAT	30.52	18.13	27.88	-9 %
97	IDEV	67.82	35.05	65.5	-3 %
98	IDNA	54.96	17.33	22.27	-59 %
99	IDRV	56.67	16.81	29.05	-49 %
100	IDU	96	41.35	85.11	-11 %
101	IDV	32.51	16.67	28.05	-14 %
102	IEDI	50.07	21.56	46.96	-6 %
103	IEMG	67.03	28.63	50.97	-24 %
104	IEO	112.72	16.26	108.12	-4 %
105	IETC	72	20.98	67.41	-6 %
106	IEUR	58.21	28.68	57.05	-2 %
107	IEUS	72.39	29.83	55.56	-23 %
108	IEV	55.9	27.4	54.93	-2 %
109	IEZ	47.74	4.86	22.96	-52 %
110	IFGL	29.72	16.49	20.5	-31 %
111	IFRA	43.59	15.87	42.33	-3 %
112	IGBH	24.9	13.67	24.52	-2 %
113	IGE	46.88	12.25	45.37	-3 %
114	IGM	516.69	75.11	82.47	-84 %
115	IGRO	68.88	34.12	65.86	-4 %
116	IGSB	53.96	45.03	50.84	-6 %
117	IGV	448.75	78.23	80.86	-82 %
118	IHAK	49.5	20.12	44.44	-10 %
119	IHE	208.68	62.78	63.92	-69 %
120	IHF	297.1	50.34	52.32	-82 %
121	IHI	67.11	16.14	55.51	-17 %
122	IJH	289.18	55.78	57.85	-80 %
123	IJJ	118.63	37.4	112.47	-5 %
124	IJK	91.74	29.42	86.93	-5 %
125	IJR	120.1	35.11	105.96	-12 %
126	IJS	110.67	35.28	98.13	-11 %
127	IJT	143.93	38.47	125.72	-13 %
128	ILCB	72.6	13.67	69.9	-4 %
129	ILCG	76.38	16.11	72.51	-5 %
130	ILCV	76.99	23.67	74.59	-3 %
131	ILF	32.15	13.47	27.49	-14 %
132	IMCB	72.92	13.19	69.56	-5 %
133	IMCG	76.05	20.59	67.01	-12 %
134	IMCV	72.64	19.74	69.94	-4 %
135	IMTM	39.55	19.55	38.04	-4 %
136	INDA	52.45	19.14	52.01	-1 %
137	INDL	116.69	8.9	62.48	-46 %
138	INTC	65.46	20.52	34.28	-48 %
139	INTF	29.93	15.7	29.18	-3 %
140	IOO	89.93	27.91	87.42	-3 %
141	IPAC	67.33	33.55	60.52	-10 %
142	IQLT	39.97	19.05	38.46	-4 %
143	IRBO	50.65	18.33	32.31	-36 %
144	ISCB	61.39	20.79	53.13	-13 %
145	ISCF	37.26	17.75	32.17	-14 %
146	ISCG	58.31	17.15	44.11	-24 %
147	ISCV	61.84	22.76	58.1	-6 %
148	ISVL	36.6	25.24	34.75	-5 %
149	ISZE	30.05	16.18	26.16	-13 %
150	ITA	132.27	39.53	129.37	-2 %
151	ITB	116.34	20.9	106	-9 %
152	ITOT	115.61	33.7	111.11	-4 %
153	IUSG	118.45	19.92	112.86	-5 %
154	IUSV	90.64	22.66	87.52	-3 %
155	IVE	187.24	61.59	180.98	-3 %
156	IVLU	28.58	14.13	27.94	-2 %
157	IVV	527.16	128.87	508.17	-4 %
158	IVW	85.56	7.05	81.4	-5 %
159	IWB	288.75	82.68	277.99	-4 %
160	IWC	157.8	53.68	112.9	-28 %
161	IWD	179.56	74.33	173.66	-3 %
162	IWF	340.83	78.78	324.03	-5 %
163	IWFH	35.44	11.52	14.85	-58 %
164	IWL	127.57	34.85	123.12	-3 %
165	IWM	242.58	86.22	198.57	-18 %
166	IWN	175.95	66.32	151.74	-14 %
167	IWO	338.22	106.74	252.37	-25 %
168	IWP	123.03	37.4	108.63	-12 %
169	IWR	84.79	31.07	80.37	-5 %
170	IWS	125.64	36.04	119.86	-5 %
171	IWX	76.49	29.95	74.57	-3 %
172	IWY	197.9	30.63	188.2	-5 %
173	IXC	45.22	11	44.09	-2 %
174	IXG	86.83	32.49	84.65	-3 %
175	IXJ	93.37	25.99	89.62	-4 %
176	IXN	76.25	12.49	70.51	-8 %
177	IXP	89.72	39.42	84.05	-6 %
178	IXUS	72.4	36.02	66.45	-8 %
179	IYC	87.23	23.52	77.59	-11 %
180	IYE	51.7	10.97	50.18	-3 %
181	IYF	95.88	32.78	93.15	-3 %
182	IYG	203.11	62.13	64.88	-68 %
183	IYH	310.69	57.95	59.21	-81 %
184	IYJ	126.07	34.8	121.93	-3 %
185	IYK	214.53	63.95	66.54	-69 %
186	IYLD	23.63	12.74	19.66	-17 %
187	IYM	153.94	52.52	140.67	-9 %
188	IYR	115.99	53.01	83.35	-28 %
189	IYT	282.26	65.55	67.43	-76 %
190	IYW	137.54	17.41	128.52	-7 %
191	IYY	128.29	23.86	123.5	-4 %
192	IYZ	34	19.85	20.86	-39 %
193	JEPI	60.33	40.92	56.36	-7 %
194	JPXN	77.12	35.71	71.1	-8 %
195	JXI	66.78	33.53	59.33	-11 %
196	KRBN	56.07	18.79	31.8	-43 %
197	KSA	50.75	16.51	43.34	-15 %
198	KXI	64.76	34.44	60.11	-7 %
199	LABD	20227.05	5.72	10.07	-100 %
200	LABU	237.09	2.42	91.98	-61 %
201	LQD	133.39	92	105.45	-21 %
202	LQDI	30.83	18.35	25.5	-17 %
203	LRGF	54	18.84	51.9	-4 %
204	MAIN	48.75	10.75	48.69	-0 %
205	MIDU	76.75	6.72	47.88	-38 %
206	MMM	221.8	85.35	93	-58 %
207	MPW	20.4	2.92	4.64	-77 %
208	MRNA	497.49	11.54	107.89	-78 %
209	MSFT	430.82	35.21	407.57	-5 %
210	MTUM	192.83	50.78	179.07	-7 %
211	MXI	93.14	31.98	86.81	-7 %
212	NAIL	153.4	4.76	113.23	-26 %
213	NUGT	845.08	20.3	37.11	-96 %
214	NURE	41.22	15.52	29.69	-28 %
215	O	74.52	30.81	53.39	-28 %
216	OBDC	15.83	5.39	15.74	-1 %
217	OCSL	21.64	1.93	19.64	-9 %
218	OHI	36.5	10.76	30.69	-16 %
219	OXY	77.13	8.47	67.39	-13 %
220	PCM	9.94	3.53	8.46	-15 %
221	PDI	21.16	8.41	18.83	-11 %
222	PFE	57.15	19.78	26.32	-54 %
223	PFF	38.39	21.25	31.35	-18 %
224	PFLT	12.53	2.28	11.54	-8 %
225	PICK	50.91	10.06	42.12	-17 %
226	PLTM	13	5.76	8.83	-32 %
227	PTY	17.09	5.24	13.94	-18 %
228	QYLD	20.69	8.45	17.37	-16 %
229	REET	30.47	14.47	22.41	-26 %
230	REM	39.62	10.67	22.36	-44 %
231	RETL	60.54	1.61	8.73	-86 %
232	REZ	99.55	41.55	70.02	-30 %
233	RINC	30.43	18.46	23.25	-24 %
234	RING	36.59	9.2	26.35	-28 %
235	RXI	186	70.63	159.31	-14 %
236	RYLD	23.11	10.86	16.33	-29 %
237	SCHD	80.82	24.38	77.77	-4 %
238	SCHH	26.32	12.44	18.96	-28 %
239	SCHP	60.96	44.47	51.38	-16 %
240	SCJ	85.53	44.26	72.3	-15 %
241	SCZ	76.18	35.32	61.53	-19 %
242	SDG	98.81	40.62	76.55	-23 %
243	SDIV	25.99	6.44	21.36	-18 %
244	SDOW	1837.79	15.58	17.45	-99 %
245	SHY	85.86	78.2	81.28	-5 %
246	SLV	27.98	10.86	24.99	-11 %
247	SMIN	74.79	20.16	74.62	-0 %
248	SMLF	63.91	23.44	60.47	-5 %
249	SMMD	70.13	27.19	62	-12 %
250	SMMV	39.22	20.93	36.33	-7 %
251	SOXL	74.1	0.93	34.11	-54 %
252	SOXS	511418.93	2.76	41.18	-100 %
253	SOXX	682.77	67.28	205.87	-70 %
254	SOYB	29.43	13.27	24.94	-15 %
255	SPXL	147.8	13.36	119.51	-19 %
256	SPXS	1236.92	8.65	9.75	-99 %
257	SPXU	928.61	6.4	35.99	-96 %
258	SPY	524.61	160.31	505.65	-4 %
259	SPYI	50.47	39.15	49	-3 %
260	SQQQ	17269.96	10.05	11.91	-100 %
261	SRTY	4699.63	24.81	30.12	-99 %
262	STAG	44.65	10.25	35.41	-21 %
263	STLG	48	17.36	45.46	-5 %
264	SVAL	33.06	18.35	29.51	-11 %
265	TECB	48.82	19.33	45.58	-7 %
266	TECL	91.04	2.16	66.69	-27 %
267	THD	91.96	42.78	58.04	-37 %
268	THQ	24.67	8.5	19.31	-22 %
269	THW	15.35	6.01	12.61	-18 %
270	TIP	124.52	90.98	105.89	-15 %
271	TMF	67.87	3.83	45.2	-33 %
272	TMV	358.68	28.14	39.98	-89 %
273	TNA	114.24	10.08	35.5	-69 %
274	TPOR	69.99	4.33	33.52	-52 %
275	TPVG	15.08	1.85	9.63	-36 %
276	TQQQ	91.68	2.72	53.19	-42 %
277	TSLX	22.35	5.32	21.18	-5 %
278	TTT	192.84	23.97	82.82	-57 %
279	TZA	2896.48	16.43	19.91	-99 %
280	UDOW	88.47	10.65	76.59	-13 %
281	UNG	67.72	4.5	15.44	-77 %
282	UNL	29.37	7.1	8.08	-72 %
283	UPRO	78.67	7.04	62.93	-20 %
284	URTH	145.19	52.27	140.06	-4 %
285	URTY	136.47	11.8	41.86	-69 %
286	USO	172	16.88	79.98	-54 %
287	USRT	67.48	29.25	50.61	-25 %
288	UTG	34.56	14.66	26.23	-24 %
289	VEGI	50.32	17.42	37.4	-26 %
290	VLUE	113.83	43.25	102.8	-10 %
291	VMFXX	1	1	1	0 %
292	VNQ	115.35	51.66	80.43	-30 %
293	VNQI	57.11	32.99	40.73	-29 %
294	WEAT	12.94	4.83	5.66	-56 %
295	WOOD	95.94	34.48	79.55	-17 %
296	WPS	38.46	21.42	27.29	-29 %
297	XLB	93.72	31.88	88.28	-6 %
298	XLC	85.6	37.84	80.79	-6 %
299	XLE	98.97	20.04	96.12	-3 %
300	XLF	42.22	13.09	41.13	-3 %
301	XLI	126.39	41.43	123.07	-3 %
302	XLK	212.35	28.47	197.13	-7 %
303	XLP	80.75	36.28	75.36	-7 %
304	XLRE	51.46	21.18	36.5	-29 %
305	XLU	78.22	32.38	66.34	-15 %
306	XLV	148.27	50.39	141.3	-5 %
307	XLY	213.92	60.59	172.54	-19 %
308	XT	66.9	19.48	55.97	-16 %
309	XYLD	47.55	24.48	39.86	-16 %
310	YYY	15.98	7.19	11.78	-26 %