Multi-leg option trades

core.multileg_trades

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

570,195 rowsCSV — whole table, not this view

Sources in this table

uw_multileg570,195 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×kept_by = tracked×ticker = XLE×

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

01a0eeb5-e306-7592-b553-e157c5088faa	XLE	2026-09-29 15:48	call_diagonal_spread	2	3	101	51813.00	unknown	—	61.4300	0.2000	["62.5","65"]	["0.2461","0.2537"]	[]	["BATO","C2OX","EDGO"]	62.5000	65.0000	93	108	false	true	true	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T19:48:15Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0eeb5-e306-7592-b553-e14bbfeffaff	XLE	2026-09-29 15:48	call_diagonal_spread	2	3	182	93366.00	long	ask	61.4300	0.2066	["62.5","65"]	["0.2461","0.2537"]	[]	["ARCO","EMLD","SPHR"]	62.5000	65.0000	93	108	false	true
01a0ee9a-9aa7-77a1-aba7-da844d3a52c9	XLE	2026-09-29 15:18	straddle	2	1	20	27500.00	long	ask	61.3650	0.7000	["65"]	["0.2558"]	["51.25","78.75"]	["XMIO"]	65.0000	65.0000	444	444	false	false
01a0ee90-1357-7963-a6a1-1c049887ab52	XLE	2026-09-29 15:06	call_calendar	2	2	30	25440.00	unknown	bid	61.3350	0.7000	["67.5"]	["0.2325"]	[]	["ARCO"]	67.5000	67.5000	261	444	false	true
01a0ee90-0f6f-73f1-9007-dc625a897f7d	XLE	2026-09-29 15:06	put_diagonal_spread	2	3	120	94880.00	unknown	bid	61.3350	0.4100	["57.5","60"]	["0.2660","0.2785"]	[]	["EDGO","XCBO","XPHO"]	57.5000	60.0000	261	444	false	true
01a0ee76-c6c7-7170-a082-38500eae77f8	XLE	2026-09-29 14:39	call_diagonal_spread	2	1	18	26370.00	unknown	bid	61.4155	0.5000	["62","65"]	["0.1916","0.2032"]	[]	["XCBO"]	62.0000	65.0000	808	843	false	true
01a0ee3b-4c37-7dc0-94cb-144b9768a060	XLE	2026-09-29 13:34	put_ratio_spread	2	1	69	36432.00	unknown	bid	61.6000	0.1700	["61","62.5"]	["0.2660","0.2654"]	["53.45","62.13"]	["XISX"]	61.0000	62.5000	80	80	false	false
01a0ee3b-4467-73e1-a3c0-7a5283e2bba4	XLE	2026-09-29 13:34	put_ratio_spread	2	1	115	60955.00	unknown	bid	61.6000	0.1700	["61","62.5"]	["0.2669","0.2664"]	["53.46","62.13"]	["XISX"]	61.0000	62.5000	80	80	false	false
01a0edad-391e-7651-99cb-dbd1442c2360	XLE	2026-09-29 10:59	straddle	2	2	40	27240.00	long	ask	61.5150	0.3700	["65"]	["0.2725"]	["58.19","71.81"]	["AMXO","ARCO"]	65.0000	65.0000	80	80	false	false
01a0ed9e-3176-7d11-842b-6a1e6a596ff9	XLE	2026-09-29 10:42	put_vertical_spread	2	1	100	50000.00	long	ask	61.5300	0.2200	["62","64"]	["0.2699","0.2738"]	["62.72"]	["XISX"]	62.0000	64.0000	24	24	false	false
01a0ed9c-703e-7630-8b1d-29e61ff1c8e5	XLE	2026-09-29 10:40	put_vertical_spread	2	1	57	28842.00	short	bid	61.5599	0.2600	["63","64"]	["0.2656","0.2650"]	["63.30"]	["XCBO"]	63.0000	64.0000	17	17	false	false
01a0ed6e-3c1f-7e11-afc5-d33f42252539	XLE	2026-09-29 09:50	put_vertical_spread	2	1	193	28564.00	long	ask	61.5450	0.1500	["61","62"]	["0.3380","0.3325"]	["61.52"]	["BATO"]	61.0000	62.0000	3	3	false	false
01a0e8fc-e00f-73c0-a4c6-354a0b5000db	XLE	2026-09-28 13:07	put_vertical_spread	2	4	900	26100.00	long	ask	62.3100	0.0278	["60","61"]	["0.4118","0.3596"]	["60.90"]	["AMXO","C2OX","XISX","XPHO"]	60.0000	61.0000	2	2	false	true
01a0e8dd-3696-75b1-a47d-fd3941a67e58	XLE	2026-09-28 12:33	call_diagonal_spread	2	1	10	26050.00	short	ask	62.0200	0.9500	["50","62"]	["0.1515","0.1972"]	[]	["XISX"]	50.0000	62.0000	480	844	false	false
01a0e849-fb2f-7473-a5cd-34e11736fbd2	XLE	2026-09-28 09:52	call_vertical_spread	2	1	24	63840.00	short	bid	62.4800	1.0375	["47.5","52.5"]	["0.2075","0.2584"]	["52.1"]	["XISX"]	47.5000	52.5000	109	109	false	false
01a0d9ea-147f-78d1-ab3b-b8d6472b556a	XLE	2026-09-25 14:53	other	4	1	35	28940.00	unknown	—	61.9050	0.5200	["60","65","68"]	["0.2658","0.2647","0.2876"]	[]	["XPHO"]	60.0000	68.0000	21	56	false	false	true	true
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
01a0d98b-6636-7d41-874e-700924082dd1	XLE	2026-09-25 13:09	call_vertical_spread	2	1	18	25308.00	long	ask	61.7050	0.5500	["55","57.5"]	["0.2829","0.2748"]	["56.94"]	["XISX"]	55.0000	57.5000	84	84	false	false
01a0d96d-c05f-7012-bf61-6db6f0974d57	XLE	2026-09-25 12:37	put_diagonal_spread	2	1	100	26300.00	long	ask	61.8530	0.1400	["60","61"]	["0.2670","0.2564"]	[]	["XMIO"]	60.0000	61.0000	21	56	false	true
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
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
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
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
01a0d40c-7e3f-7480-b2f4-e849b23617c7	XLE	2026-09-24 11:33	other	4	1	238	39151.00	unknown	—	63.3150	0.1700	["61","63","65"]	["0.2761","0.2666","0.2674"]	[]	["XCBO"]	61.0000	65.0000	8	8	false	false	false	true
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
01a0cf71-2047-7b72-9177-bbfc13b37093	XLE	2026-09-23 14:04	put_calendar	2	1	150	51300.00	unknown	—	62.4100	0.2400	["64"]	["0.2786"]	[]	["XISX"]	64.0000	64.0000	2	30	false	false	true	false
01a0ce9f-0b07-7d60-8d0d-e999d5b43235	XLE	2026-09-23 10:15	call_vertical_spread	2	1	100	43200.00	long	ask	62.8150	0.1800	["60","65"]	["0.2668","0.2507"]	["62.74"]	["XMIO"]	60.0000	65.0000	23	23	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
01a0ce97-17df-79a0-9819-211284351bcb	XLE	2026-09-23 10:06	call_vertical_spread	2	1	36	95724.00	long	ask	62.6400	1.8000	["47.5","52.5"]	["0.3397","0.2149"]	["52.09"]	["XMIO"]	47.5000	52.5000	114	114	false	false
01a0ce7d-90b7-79c2-8c01-d46f55bfbd47	XLE	2026-09-23 09:38	call_vertical_spread	2	1	139	41144.00	unknown	—	62.3300	0.1600	["66","71"]	["0.2710","0.2782"]	[]	["EDGO"]	66.0000	71.0000	86	86	false	true	false	true
01a0ce7d-561f-76f0-9fcc-6a6b350395c8	XLE	2026-09-23 09:38	call_vertical_spread	2	2	122	36112.00	unknown	—	62.2800	0.1600	["66","71"]	["0.2727","0.2794"]	[]	["C2OX","EDGO"]	66.0000	71.0000	86	86	false	true	false	true
01a0ca6a-d737-7821-98b4-f4e47f18976d	XLE	2026-09-22 14:39	put_vertical_spread	2	1	74	31228.00	long	ask	62.1700	0.2800	["62","63"]	["0.2571","0.2597"]	["62.46"]	["XCBO"]	62.0000	63.0000	38	38	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
01a0ca43-36af-7892-b201-ec0e322b0ef5	XLE	2026-09-22 13:56	iron_condor	4	1	100	54800.00	long	ask	61.8900	0.2000	["58","60","64","68"]	["0.2724","0.2686","0.2726","0.2735"]	["58.26","65.74"]	["XISX"]	58.0000	68.0000	59	59	false	true
01a0ca3f-bff9-75b3-bec9-d5a610720d52	XLE	2026-09-22 13:52	call_ratio_spread	2	2	960	25600.00	long	ask	62.1400	0.0500	["64","66"]	["0.2558","0.2552"]	["64.22","69.56"]	["AMXO","XPHO"]	64.0000	66.0000	8	8	false	true
01a0ca3f-1be7-7d81-853c-0073e65fa08a	XLE	2026-09-22 13:52	iron_condor	4	1	50	26800.00	unknown	—	62.2600	0.1800	["58","60","64","68"]	["0.2691","0.2645","0.2664","0.2687"]	[]	["XISX"]	58.0000	68.0000	59	59	false	true	false	true
01a0ca3c-9377-7c02-852e-0bc0e01b3b93	XLE	2026-09-22 13:49	other	2	1	20	30200.00	unknown	—	62.4700	1.2800	["47","54"]	["0.3219","0.1653"]	[]	["XCBO"]	47.0000	54.0000	87	815	false	false	true	true
01a0ca3a-39e6-7f90-90a5-3a546d210635	XLE	2026-09-22 13:46	put_diagonal_spread	2	5	337	34037.00	long	ask	62.5150	0.0200	["60","62"]	["0.2584","0.2760"]	[]	["BATO","EMLD","XCBO"]	60.0000	62.0000	3	24	false	true
01a0ca35-d8cf-7203-abbc-77e822ddd944	XLE	2026-09-22 13:41	put_diagonal_spread	2	2	441	31311.00	long	ask	62.5150	0.0200	["60","60.5"]	["0.2584","0.2994"]	[]	["ARCO","C2OX"]	60.0000	60.5000	3	24	false	true
01a0ca35-4847-75e1-a1d9-b85ef6f3e2c7	XLE	2026-09-22 13:41	put_diagonal_spread	2	3	374	26554.00	long	ask	62.5100	0.0200	["60","60.5"]	["0.2581","0.2989"]	[]	["BATO","EMLD"]	60.0000	60.5000	3	24	false	true
01a0c979-7a27-7033-8c12-38fcfac867a9	XLE	2026-09-22 10:16	call_diagonal_spread	2	1	100	49000.00	long	ask	62.3300	0.7300	["60","65"]	["0.2686","0.2533"]	[]	["XMIO"]	60.0000	65.0000	24	59	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