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:endpoint = /api/option-trades/multi-leg×net_side = bid×ticker = XLE×

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

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	false	false	true	mlct	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-25T16:25:14Z"}	2026-09-25	2026-09-25 17:15	2026-09-25 17:15
01a0d95a-b55f-7920-ae54-26a14b62c98e	XLE	2026-09-25 12:16	call_diagonal_spread	2	1	20	28760.00	long	bid	61.7950	1.1500	["62.5","65"]	["0.2266","0.2259"]	[]	["XPHO"]	62.5000	65.0000	448	483	false	true
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
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	true
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	true
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	true
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
01a0d4f3-6787-7a71-8157-be3170f0a049	XLE	2026-09-24 15:45	other	2	1	10	26280.00	unknown	bid	62.7050	1.1500	["55","80"]	["0.2808","0.3722"]	[]	["XPHO"]	55.0000	80.0000	98	113	false	false	true
01a0d4e0-54b7-7e41-8765-dbe700233bf7	XLE	2026-09-24 15:24	put_ratio_spread	2	1	108983	7326291.00	unknown	bid	62.7500	0.0800	["60","62"]	["0.2697","0.2554"]	["59.29"]	["XCBO"]	60.0000	62.0000	22	22	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
01a0ceae-e987-7dd3-adf7-7d6873730b3b	XLE	2026-09-23 10:32	put_diagonal_spread	2	2	4647	245139.00	unknown	bid	62.7100	0.0900	["61","63"]	["0.2508","0.2748"]	[]	["XCBO"]	61.0000	63.0000	2	7	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
01a0c95a-f98f-7d02-a69c-14da211dec99	XLE	2026-09-22 09:42	put_diagonal_spread	2	3	889	155623.00	long	bid	61.7500	0.1700	["61","63"]	["0.3346","0.3593"]	[]	["ARCO","MCRY"]	61.0000	63.0000	1	3	false	false
01a0c95a-f98f-7d02-a69c-14c99c733ea6	XLE	2026-09-22 09:42	put_diagonal_spread	2	1	253	44781.00	long	bid	61.7418	0.1700	["61","63"]	["0.3380","0.3630"]	[]	["XBOX"]	61.0000	63.0000	1	3	false	false
01a0c95a-9fb7-7560-ae33-686bcaf72064	XLE	2026-09-22 09:42	put_diagonal_spread	2	3	314	53192.00	unknown	bid	61.7700	0.1172	["61","63"]	["0.3239","0.3440"]	[]	["ARCO","SPHR","XBOX"]	61.0000	63.0000	1	3	false	false
01a0c955-ae16-7310-a212-576dffb0fa3d	XLE	2026-09-22 09:37	put_vertical_spread	2	1	100	54800.00	unknown	bid	61.4900	0.1100	["63","64"]	["0.2579","0.2575"]	["60.76"]	["XCBO"]	63.0000	64.0000	24	24	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-8d0f-7252-b21a-0a41c86e9d8b	XLE	2026-09-21 12:36	call_vertical_spread	2	1	9	25506.00	unknown	bid	62.6400	0.9000	["48","49"]	["6.0657","5.6491"]	["62.67"]	["XCBO"]	48.0000	49.0000	0	0	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
01a0c4b2-fd1f-72c1-be9f-2f982fd44ea4	XLE	2026-09-21 12:00	call_diagonal_spread	2	1	102	118014.00	unknown	bid	62.8219	0.5882	["55","65"]	["0.2949","0.2507"]	[]	["XISX"]	55.0000	65.0000	60	116	false	false
01a0c46f-e16f-7450-9e40-6f070aebb7a2	XLE	2026-09-21 10:47	call_diagonal_spread	2	1	9	25686.00	unknown	bid	62.6550	0.9000	["35","62"]	["1.0575","0.4289"]	[]	["EDGO"]	35.0000	62.0000	0	25	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	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
01a0b61a-03f7-7a12-a50c-c6468e8f130e	XLE	2026-09-18 15:59	call_vertical_spread	2	1	258	96492.00	unknown	bid	64.2650	0.2500	["64","65"]	["0.2328","0.2335"]	["66.37"]	["XCBO"]	64.0000	65.0000	35	35	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
01a0b5ee-2967-70d3-b110-9b8f14fa37c1	XLE	2026-09-18 15:11	call_diagonal_spread	2	1	26	69940.00	unknown	bid	64.3250	1.0000	["51","52"]	["0.3658","0.2186"]	[]	["XISX"]	51.0000	52.0000	63	182	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
01a0b5b8-d50f-72a1-b99e-be2d86542651	XLE	2026-09-18 14:13	other	3	1	38	29868.00	unknown	bid	64.3950	0.4800	["60.5","61.5","64.5"]	["0.2868","0.1796","0.3040"]	["63.4"]	["XMIO"]	60.5000	64.5000	7	7	false	false
01a0b5b2-1e4f-7701-a90b-59e6d0dd9db2	XLE	2026-09-18 14:05	other	4	1	80	102720.00	unknown	bid	64.3350	0.4200	["58.5","59","64","64.5"]	["0.1762","0.1929","0.2908","0.2864"]	[]	["XMIO"]	58.5000	64.5000	0	35	false	false
01a0b582-a5f7-7293-b52b-4ef062097b3f	XLE	2026-09-18 13:13	call_calendar	2	1	10	34940.00	unknown	bid	64.3650	0.5000	["47"]	["3.3120"]	[]	["BATO"]	47.0000	47.0000	0	119	false	false
01a0b503-f847-7610-8146-32bee3072bee	XLE	2026-09-18 10:55	call_calendar	2	1	16	46592.00	unknown	bid	64.4100	0.9000	["50"]	["3.0645"]	[]	["XCBO"]	50.0000	50.0000	0	63	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	true
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
01a0b0d9-f61b-7e21-a968-17041b1a0ff9	XLE	2026-09-17 15:31	call_diagonal_spread	2	1	14	30927.00	long	bid	64.3950	0.3000	["52.5","55"]	["0.5888","0.2200"]	[]	["XMIO"]	52.5000	55.0000	13	92	false	false
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
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
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	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
01a0aabc-b313-7d83-ae43-519c6f4fc5fb	XLE	2026-09-16 11:01	call_diagonal_spread	2	1	20	50080.00	long	bid	64.0800	0.9500	["51","55"]	["1.9070","0.2149"]	[]	["XPHO"]	51.0000	55.0000	2	274	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