Multi-leg option trades

core.multileg_trades

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

403,968 rowsCSV — whole table, not this view

Sources in this table

uw_multileg403,968 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:code = mlet×endpoint = /api/option-trades/multi-leg×ticker = XLE×

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

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	false	true	false	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T18:22:22Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
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
01a0c95b-092f-72c0-8bc4-9ebd2f3b839f	XLE	2026-09-22 09:42	put_diagonal_spread	2	1	575	100625.00	unknown	ask	61.7498	0.1000	["61","63"]	["0.3344","0.3587"]	[]	["ARCO"]	61.0000	63.0000	1	3	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
01a0c954-5657-7a00-b872-060d6cf52960	XLE	2026-09-22 09:35	put_vertical_spread	2	1	152	44992.00	long	ask	61.6150	0.2600	["62","63.5"]	["0.3235","0.3433"]	["62.38"]	["EMLD"]	62.0000	63.5000	3	3	false	false
01a0c582-c86f-7b03-90ff-f94a8d0f79aa	XLE	2026-09-21 15:47	call_diagonal_spread	2	1	532	256424.00	long	ask	62.5200	0.0600	["65","66"]	["0.2598","0.2707"]	[]	["EDGO"]	65.0000	66.0000	88	101	false	true
01a0c582-c86f-7b03-90ff-f9254033c324	XLE	2026-09-21 15:47	call_diagonal_spread	2	3	229	110016.00	long	ask	62.5200	0.0400	["65","66"]	["0.2592","0.2700"]	[]	["AMXO","ARCO","SPHR"]	65.0000	66.0000	88	101	false	true
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
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
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
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
01a0b609-9107-70d2-a698-71c6b9086ab0	XLE	2026-09-18 15:41	call_diagonal_spread	2	1	70	79100.00	unknown	—	64.3300	0.5000	["57.5","60"]	["8.8707","0.1979"]	[]	["AMXO"]	57.5000	60.0000	0	21	false	false	true	true
01a0b604-f16f-7431-8b06-113341550659	XLE	2026-09-18 15:36	other	4	1	234	34632.00	unknown	ask	64.2950	0.1300	["62","64","66"]	["0.3099","0.2652","0.2261"]	["60.84","63.16","64.84","67.16"]	["XMIO"]	62.0000	66.0000	7	7	false	false
01a0b5d5-a7f8-7213-8af6-831ec7f96f27	XLE	2026-09-18 14:44	call_diagonal_spread	2	1	34	91766.00	long	ask	64.4000	1.0500	["51","52"]	["0.3364","0.2031"]	[]	["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
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
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
01a0b4db-1388-7321-a814-f6fb67de5469	XLE	2026-09-18 10:10	call_calendar	2	1	10	35940.00	long	ask	64.3950	0.7500	["46.5"]	["3.1932"]	[]	["XISX"]	46.5000	46.5000	0	91	false	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	true
01a0b4d1-91f0-7502-9730-752298a0d703	XLE	2026-09-18 10:00	call_diagonal_spread	2	1	20	50700.00	unknown	—	64.3400	1.2000	["52","53"]	["0.2473","0.1559"]	[]	["XMIO"]	52.0000	53.0000	104	182	false	false	true	true
01a0b4c0-9a30-7913-a959-114037dd9fdb	XLE	2026-09-18 09:41	call_calendar	2	1	10	35500.00	long	ask	64.2600	0.7000	["46.5"]	["2.9396"]	[]	["XMIO"]	46.5000	46.5000	0	91	false	false	true
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
01a0b05d-dc93-7b53-80cf-8a5015268ba9	XLE	2026-09-17 13:15	call_vertical_spread	2	1	10	26720.00	long	ask	64.3050	2.2500	["48","55"]	["0.3899","0.1490"]	["54.50"]	["XMIO"]	48.0000	55.0000	120	120	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
01a0b036-3c0b-7990-912a-367765edb4d5	XLE	2026-09-17 12:32	call_calendar	2	1	19	50521.00	unknown	—	64.1900	0.7000	["51"]	["1.1969"]	[]	["ARCO"]	51.0000	51.0000	1	92	false	false	true	false	false
01a0b035-8c43-7690-8c52-f9adf42937a7	XLE	2026-09-17 12:31	other	3	2	148	64084.00	unknown	—	64.1800	0.1600	["65","75"]	["0.2448","0.2730"]	[]	["MCRY","XPHO"]	65.0000	75.0000	29	64	false	true	true	true	false
01a0afeb-1d94-73f3-9afc-f42b415b5a1b	XLE	2026-09-17 11:10	call_vertical_spread	2	1	20	29340.00	unknown	—	64.0000	0.4500	["55","60"]	["0.1335","0.2364"]	[]	["XMIO"]	55.0000	60.0000	64	64	false	false	false	true
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
01a0abab-d1eb-73f3-b2a6-6dde8d96ed1e	XLE	2026-09-16 15:22	call_diagonal_spread	2	2	10	39800.00	unknown	—	63.7350	6.5500	["42","50"]	["0.4579","0.1857"]	[]	["XISX"]	42.0000	50.0000	121	492	false	false	true	true
01a0ab91-6c1b-71f0-8b72-6ef578cea0a0	XLE	2026-09-16 14:53	call_diagonal_spread	2	1	35	59010.00	unknown	—	64.3050	1.0000	["54","60"]	["1.5964","0.2641"]	[]	["XMIO"]	54.0000	60.0000	2	93	false	false	true	true
01a0ab7d-400b-77b0-9d34-4c35f6fa38c1	XLE	2026-09-16 14:31	call_diagonal_spread	2	1	29	50315.00	unknown	—	64.6000	0.4500	["54","60"]	["1.7486","0.2540"]	[]	["XMIO"]	54.0000	60.0000	2	93	false	false	true	true
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	true
01a0aac3-7d5b-7721-8e5a-132832080d70	XLE	2026-09-16 11:08	put_diagonal_spread	2	1	10	25150.00	long	ask	63.9400	1.4000	["61","85"]	["0.2722","0.3622"]	[]	["EMLD"]	61.0000	85.0000	196	821	true	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
01a0aabd-3013-7602-9d54-013e80363c93	XLE	2026-09-16 11:01	straddle	2	1	77	54824.00	unknown	—	64.1500	0.1500	["65"]	["0.2754"]	[]	["XCBO"]	65.0000	65.0000	93	93	false	false	false	false	true
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
01a0aaa9-3ab3-76b3-ba49-3f2b213786c7	XLE	2026-09-16 10:40	call_ratio_spread	2	1	1734	62424.00	long	ask	64.5050	0.0300	["65","66"]	["0.3303","0.3287"]	["65.12","66.88"]	["EDGO"]	65.0000	66.0000	2	2	false	true
01a0aa9a-b00b-7ed2-8653-317bf4cf417a	XLE	2026-09-16 10:24	call_diagonal_spread	2	1	20	48100.00	unknown	—	64.4451	1.1000	["52.5","55"]	["1.5374","0.2075"]	[]	["XISX"]	52.5000	55.0000	2	274	false	false	true	true