Multi-leg option trades

core.multileg_trades

Class E accrual with a 24-hour vendor cap - the shortest window in the project.

508,354 rowsCSV — whole table, not this view

Sources in this table

uw_multileg508,354 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:direction = short×endpoint = /api/option-trades/multi-leg×ticker = XLE×

idtext	tickertext	executed_at ↓timestamp with time zone	strategytext	leg_countinteger	txnsinteger	sizebigint	total_premiumnumeric

01a0d99e-463f-7561-bde4-0ddc7b65cf2a	XLE	2026-09-25 13:30	call_calendar	2	1	40	39920.00	short	ask	61.7300	1.6500	["57"]	["2.4215"]	[]	["XCBO"]	57.0000	57.0000	0	3	false	false	true	false	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T17:31:02Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0d962-9cce-7db1-b99a-1fb3aee951d5	XLE	2026-09-25 12:25	synthetic	2	1	2000	1768000.00	short	bid	61.8850	0.6500	["60"]	["0.2547"]	["62.46"]	["XBOX"]	60.0000	60.0000	175	175	false	false
01a0d92a-568e-73e1-9ee2-c9e66d067ab8	XLE	2026-09-25 11:23	call_calendar	2	1	24	136176.00	short	bid	62.1500	2.3000	["35"]	["0.3187"]	[]	["XCBO"]	35.0000	35.0000	812	847	false	false
01a0d92a-568e-73e1-9ee2-c9dfc7c9a9db	XLE	2026-09-25 11:23	call_calendar	2	1	24	136224.00	short	ask	62.1500	2.3000	["35"]	["0.3187"]	[]	["XPHO"]	35.0000	35.0000	812	847	false	false
01a0d92a-568e-73e1-9ee2-c9c12ed57835	XLE	2026-09-25 11:23	call_calendar	2	1	24	136224.00	short	ask	62.1500	2.3000	["35"]	["0.3187"]	[]	["XCBO"]	35.0000	35.0000	812	847	false	false
01a0d91a-dd9f-7972-8739-90aa51e1d89d	XLE	2026-09-25 11:06	put_calendar	2	1	200	78000.00	short	bid	62.1550	0.3800	["64"]	["0.4746"]	[]	["XMIO"]	64.0000	64.0000	0	7	false	false
01a0d916-ce8f-7be1-80b0-2513eea54170	XLE	2026-09-25 11:02	put_calendar	2	1	90	28260.00	short	bid	62.0450	0.5300	["63.5"]	["0.5679"]	[]	["XMIO"]	63.5000	63.5000	0	7	false	false
01a0d912-2b0f-7a91-9235-3b2ce3833deb	XLE	2026-09-25 10:57	put_calendar	2	1	300	72300.00	short	bid	62.0100	0.1200	["63"]	["0.3478"]	[]	["XMIO"]	63.0000	63.0000	0	7	false	false
01a0d90e-b06f-7cf3-bdd0-1cb4cd3d64c1	XLE	2026-09-25 10:53	put_calendar	2	1	100	41400.00	short	ask	62.0527	0.4700	["64"]	["0.5706"]	[]	["XCBO"]	64.0000	64.0000	0	7	false	false
01a0d4f7-7e67-7ab1-881f-6676b1327fc9	XLE	2026-09-24 15:49	strangle	2	8	160	26400.00	short	bid	62.6700	0.0300	["57","68"]	["0.2794","0.2734"]	["55.35","69.65"]	["AMXO","ARCO","EMLD","MCRY","XBOX","XISX","XMIO","XPHO"]	57.0000	68.0000	57	57	false	true
01a0d475-040e-7473-be3d-a63e46908e89	XLE	2026-09-24 13:27	call_vertical_spread	2	1	110	72820.00	short	bid	62.9000	0.2700	["60","70"]	["0.2571","0.2618"]	["64.08"]	["XCBO"]	60.0000	70.0000	98	98	false	false
01a0d474-d52f-7273-81bc-3d595446e9f8	XLE	2026-09-24 13:26	call_vertical_spread	2	2	43	28415.00	short	bid	62.8950	0.2526	["60","70"]	["0.2556","0.2628"]	["64.05"]	["ARCO","XBOX"]	60.0000	70.0000	98	98	false	false
01a0d40b-41d7-7be1-9a44-0d067fb24770	XLE	2026-09-24 11:31	call_calendar	2	1	20	72080.00	short	bid	63.3050	2.2500	["50"]	["0.2078"]	[]	["XISX"]	50.0000	50.0000	813	848	false	false
01a0d409-51be-7f83-9c51-f3d351b97a21	XLE	2026-09-24 11:29	call_calendar	2	1	28	45444.00	short	bid	63.3250	1.5500	["70"]	["0.2064"]	[]	["AMXO"]	70.0000	70.0000	813	848	false	true
01a0d408-28df-7723-95cb-f0ff66dcfc8e	XLE	2026-09-24 11:28	call_vertical_spread	2	1	20	27760.00	short	bid	63.3050	0.3500	["55","60"]	["0.2963","0.2722"]	["59.12"]	["XMIO"]	55.0000	60.0000	57	57	false	false
01a0d3b8-a94f-7930-9b04-1a230437bb20	XLE	2026-09-24 10:01	call_calendar	2	1	41	83189.00	short	ask	62.9500	1.2000	["53"]	["0.4135"]	[]	["XMIO"]	53.0000	53.0000	22	36	false	false
01a0ce9e-7e66-7291-b94a-8e5903e7c844	XLE	2026-09-23 10:14	strangle	2	6	51	27438.00	short	bid	62.7850	0.0900	["62.5","65"]	["0.2684","0.2683"]	["57.12","70.38"]	["AMXO","ARCO","C2OX","MCRY","XCBO","XISX"]	62.5000	65.0000	86	86	false	true
01a0ca65-e597-7d53-8729-8ada97472bf0	XLE	2026-09-22 14:34	call_diagonal_spread	2	1	200	160200.00	short	bid	62.2200	0.4500	["59","60"]	["0.2977","0.2546"]	[]	["SPHR"]	59.0000	60.0000	24	59	false	false
01a0ca5a-73e7-7280-92af-9a38b589a4d9	XLE	2026-09-22 14:21	put_vertical_spread	2	2	40	26020.00	short	bid	62.3250	0.4600	["60","65"]	["0.2749","0.2750"]	["62.50"]	["XISX"]	60.0000	65.0000	87	87	false	false
01a0c955-1d8f-7c51-94dc-945bdc561095	XLE	2026-09-22 09:36	put_vertical_spread	2	1	193	25283.00	short	bid	61.4400	0.0800	["58.5","61.5"]	["0.2899","0.2695"]	["60.63"]	["XCBO"]	58.5000	61.5000	10	10	false	false
01a0c4d3-71b6-7243-9d86-3d07f65985e2	XLE	2026-09-21 12:36	straddle	2	1	2000	1310000.00	short	bid	62.6450	0.3600	["62.5"]	["0.2675"]	["55.95","69.05"]	["ARCO"]	62.5000	62.5000	88	88	false	false
01a0c482-30ef-74c3-aeea-70e842a49b44	XLE	2026-09-21 11:07	call_diagonal_spread	2	1	18	100008.00	short	ask	62.7050	2.8000	["35","36"]	["1.2587","0.9513"]	[]	["BATO"]	35.0000	36.0000	25	60	false	false
01a0c46a-7e87-72c0-8d1d-740d2e64518f	XLE	2026-09-21 10:41	call_vertical_spread	2	1	10	27660.00	short	bid	62.8200	0.8500	["47.5","52.5"]	["0.3070","0.2842"]	["52.1"]	["XPHO"]	47.5000	52.5000	116	116	false	false
01a0c456-3eef-72a3-989c-ace5fbf8f3d6	XLE	2026-09-21 10:19	synthetic	2	1	25	43700.00	short	bid	62.8300	0.8300	["50"]	["0.2110"]	["64.10"]	["SPHR"]	50.0000	50.0000	452	452	false	false
01a0c447-623e-7402-9226-441b2907f4c4	XLE	2026-09-21 10:03	put_vertical_spread	2	1	126	31248.00	short	bid	62.8650	0.2300	["63.5","64"]	["0.2713","0.2787"]	["63.64"]	["XCBO"]	63.5000	64.0000	4	4	false	false
01a0b617-508f-7d23-af3b-d95f03881ac7	XLE	2026-09-18 15:56	call_diagonal_spread	2	1	38	34428.00	short	bid	64.2750	0.3500	["60","61"]	["0.1869","0.2292"]	[]	["MCRY"]	60.0000	61.0000	14	63	false	false
01a0b60e-d4b0-70a0-9602-2d7a169c168f	XLE	2026-09-18 15:46	call_diagonal_spread	2	1	20	38580.00	short	bid	64.3050	0.4500	["55","59"]	["0.4013","0.2138"]	[]	["XISX"]	55.0000	59.0000	12	364	false	false
01a0b5c6-9497-7f60-93a6-d90730c590eb	XLE	2026-09-18 14:28	call_calendar	2	1	25	60825.00	short	bid	64.4450	0.5500	["52.5"]	["4.0702"]	[]	["XMIO"]	52.5000	52.5000	0	119	false	false
01a0b51a-a10f-73a3-b4d6-829434777f8a	XLE	2026-09-18 11:20	call_calendar	2	1	20	49520.00	short	ask	64.6850	0.7000	["52.5"]	["2.4912"]	[]	["XCBO"]	52.5000	52.5000	0	119	false	false
01a0b502-8147-7292-95d4-759fecd37e4f	XLE	2026-09-18 10:53	call_calendar	2	1	50	55300.00	short	bid	64.4600	0.4500	["60"]	["1.0547"]	[]	["XCBO"]	60.0000	60.0000	0	119	false	false
01a0b4dc-c907-79d1-9c7e-3f119915ad72	XLE	2026-09-18 10:12	call_diagonal_spread	2	1	100	38500.00	short	bid	64.3800	0.0600	["65.5","66"]	["0.2386","0.2488"]	[]	["XISX"]	65.5000	66.0000	42	63	false	true
01a0b4d7-6238-7ab2-8a0f-40fd3171508d	XLE	2026-09-18 10:06	call_calendar	2	1	35	101500.00	short	ask	64.3400	0.7000	["50"]	["2.0517"]	[]	["XISX"]	50.0000	50.0000	0	91	false	false
01a0b4d6-f4d7-7770-87a2-07cd0dca1f5e	XLE	2026-09-18 10:06	call_calendar	2	1	500	72500.00	short	ask	64.3500	0.0200	["65"]	["0.2592"]	[]	["AMXO"]	65.0000	65.0000	0	28	false	true
01a0b0d1-f353-7811-bd26-217ac09f6b1a	XLE	2026-09-17 15:22	call_vertical_spread	2	1	73	155855.00	short	bid	64.3700	0.5000	["55","56"]	["0.2106","0.2157"]	["55.79"]	["XMIO"]	55.0000	56.0000	183	183	false	false
01a0b0cf-e3fb-7240-8085-218354759df7	XLE	2026-09-17 15:20	call_vertical_spread	2	1	20	42700.00	short	bid	64.3950	0.7000	["55","56"]	["0.2077","0.2134"]	["55.79"]	["XMIO"]	55.0000	56.0000	183	183	false	false
01a0b07b-24ab-73c2-8911-afd85dc7411e	XLE	2026-09-17 13:47	call_calendar	2	1	30	58650.00	short	ask	64.3100	0.3000	["55"]	["0.2912"]	[]	["BATO"]	55.0000	55.0000	13	105	false	false
01a0b03f-1993-7c91-b42a-d3769fb66795	XLE	2026-09-17 12:41	call_calendar	2	1	44	126324.00	short	ask	64.1350	1.9500	["50"]	["0.4115"]	[]	["ARCO"]	50.0000	50.0000	13	105	false	false
01a0afbd-1083-7443-827a-4e0bb8a5e0f6	XLE	2026-09-17 10:19	call_vertical_spread	2	3	40	38920.00	short	bid	63.8600	0.3375	["60","70"]	["0.2289","0.2461"]	["64.42"]	["XISX"]	60.0000	70.0000	183	183	false	false
01a0ab73-e19b-73c3-a2d4-4fd7e2a2f6c5	XLE	2026-09-16 14:21	call_diagonal_spread	2	1	33	59169.00	short	ask	64.7850	1.4500	["54","60"]	["2.0991","0.2538"]	[]	["BATO"]	54.0000	60.0000	2	93	false	false
01a0ab56-b0f3-71c1-8ec3-087a6bedc0f1	XLE	2026-09-16 13:49	call_diagonal_spread	2	1	24	41304.00	short	ask	64.6905	0.2000	["54","60"]	["1.1358","0.2500"]	[]	["XMIO"]	54.0000	60.0000	2	93	false	false
01a0aac8-019b-7433-b666-670cffa6b570	XLE	2026-09-16 11:13	put_calendar	2	1	138	25668.00	short	ask	64.1000	0.0600	["63"]	["0.3123"]	[]	["EDGO"]	63.0000	63.0000	9	16	false	true
01a0aac7-8883-7882-93f7-6946a0875e07	XLE	2026-09-16 11:13	call_diagonal_spread	2	1	22	82390.00	short	ask	64.0700	2.8000	["45","54"]	["0.3336","0.1545"]	[]	["XMIO"]	45.0000	54.0000	492	856	false	false
01a0aabd-4784-7242-851e-086eea5eb366	XLE	2026-09-16 11:02	straddle	2	1	38	26942.00	short	bid	64.1100	0.2000	["65"]	["0.2743"]	["57.91","72.09"]	["XCBO"]	65.0000	65.0000	93	93	false	false
01a0aabd-4784-7242-851e-085240fc3ab6	XLE	2026-09-16 11:02	straddle	2	2	78	55302.00	short	bid	64.1100	0.2000	["65"]	["0.2743"]	["57.91","72.09"]	["AMXO","ARCO"]	65.0000	65.0000	93	93	false	false
01a0aab8-afbb-7d70-a573-3456725a5e67	XLE	2026-09-16 10:57	call_diagonal_spread	2	1	10	34170.00	short	ask	64.3550	0.4000	["45","50"]	["2.1425","0.3619"]	[]	["XPHO"]	45.0000	50.0000	2	121	false	false
01a0aaa9-8103-74c1-bdfd-1cb58720e437	XLE	2026-09-16 10:40	call_diagonal_spread	2	1	10	47680.00	short	bid	64.4950	2.4500	["38.5","44"]	["0.4698","3.4254"]	[]	["BATO"]	38.5000	44.0000	2	274	false	false
01a0aa84-74a3-7e60-b2e0-f9265f02904e	XLE	2026-09-16 10:00	call_diagonal_spread	2	1	25	27200.00	short	bid	64.7050	0.5500	["60","65"]	["0.5806","0.2346"]	[]	["XMIO"]	60.0000	65.0000	2	274	false	false
01a0aa6d-6263-7292-8820-cd1ac89a1171	XLE	2026-09-16 09:34	call_vertical_spread	2	3	463	551124.00	short	bid	64.8650	0.1900	["56","69"]	["0.2378","0.2667"]	["63.65"]	["ARCO","C2OX","EDGO"]	56.0000	69.0000	93	93	false	false
01a0a66a-1d16-7053-979e-1dc11a23e396	XLE	2026-09-15 14:52	call_diagonal_spread	2	1	20	54520.00	short	bid	65.8750	0.6000	["52","52.5"]	["0.3740","1.3979"]	[]	["XMIO"]	52.0000	52.5000	3	31	false	false
01a0a640-617e-79c0-be16-dbac0a09e737	XLE	2026-09-15 14:07	call_diagonal_spread	2	2	38	46360.00	short	bid	66.0150	0.1500	["60","62.5"]	["0.2821","0.2366"]	[]	["EDGO","XISX"]	60.0000	62.5000	15	122	false	false