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:ticker = XLE×

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

01a0a072-b258-7363-bf34-40fbda9a6a76	XLE	2026-09-14 11:04	other	4	1	96	72288.00	unknown	—	65.5300	0.2900	["62.5","65","68","71"]	["0.3646","0.3051","0.2568","0.2600"]	[]	["XMIO"]	62.5000	71.0000	4	67	false	false	true	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-14T15:04:56Z"}	2026-09-14	2026-09-14 17:15	2026-09-14 17:15
01a0a06c-c6b9-7422-9115-24a1ad9cc7d9	XLE	2026-09-14 10:57	iron_condor	4	1	150	86700.00	unknown	—	65.5900	0.2100	["63","64","65","68"]	["0.2868","0.2894","0.2365","0.2471"]	[]	["XMIO"]	63.0000	68.0000	32	32	false	false	false	true	true	mlet
01a0a059-0fd9-7751-82f1-be2b43ac9b95	XLE	2026-09-14 10:36	call_calendar	2	5	23	72915.00	short	bid	65.6450	0.3500	["50"]	["0.7666"]	[]	["ARCO","EMLD","SPHR","XISX","XPHO"]	50.0000	50.0000	4	95	false	false	true	false	false
01a0a02b-7029-7d53-9ce0-73b97d978cf9	XLE	2026-09-14 09:46	call_diagonal_spread	2	1	20	41800.00	short	bid	65.9400	0.6000	["52.5","59"]	["0.2535","0.6846"]	[]	["XMIO"]	52.5000	59.0000	4	95	false	false	true	true	false
01a091e3-b8e0-7a53-ae5c-1a6b0a9224a2	XLE	2026-09-11 15:13	other	2	2	80	44600.00	unknown	—	65.0850	0.2200	["58","65"]	["0.4862","0.2324"]	[]	["XCBO","XPHO"]	58.0000	65.0000	7	35	false	false	true	true	false	mlet
01a091c9-c840-7fe3-b6d7-a57eeeb81e48	XLE	2026-09-11 14:45	other	2	1	2000	892000.00	unknown	—	65.0600	0.2300	["58","65"]	["0.5147","0.2435"]	[]	["XBOX"]	58.0000	65.0000	7	7	false	false	false	true	false	mlft
01a0919d-af31-78f1-91bd-9368a0691b42	XLE	2026-09-11 13:57	other	3	2	60	86724.00	unknown	—	65.0000	1.5600	["58","58.5","65"]	["0.1857","0.1712","0.2432"]	[]	["XCBO","XISX"]	58.0000	65.0000	7	42	false	false	true	true	true	mlet
01a0919d-af31-78f1-91bd-935c1ebe270c	XLE	2026-09-11 13:57	other	3	2	32	45904.00	unknown	—	65.0000	1.5600	["58","58.5","65"]	["0.2236","0.2215","0.2519"]	[]	["XBOX","XISX"]	58.0000	65.0000	7	42	false	false	true	true	true	mlet
01a09196-73a0-79c3-89bc-a043b071d8f1	XLE	2026-09-11 13:49	put_vertical_spread	2	1	500	55500.00	unknown	—	65.1451	0.0400	["57","62"]	["0.3026","0.2839"]	[]	["XBOX"]	57.0000	62.0000	35	35	false	true	false	true	false	mlat
01a0918c-abb8-7273-9920-c1c7bed1ebaa	XLE	2026-09-11 13:38	put_vertical_spread	2	1	945	99225.00	short	bid	65.1350	0.0400	["63","65"]	["0.2719","0.2502"]	["64.43"]	["EDGO"]	63.0000	65.0000	7	7	false	true	false	true	false
01a09189-2948-76b1-8ff5-56afc229d5ab	XLE	2026-09-11 13:34	other	2	1	625	42250.00	unknown	—	65.1400	0.0500	["62","63"]	["0.2836","0.2680"]	[]	["EDGO"]	62.0000	63.0000	7	35	false	true	true	true	false	mlat
01a09113-1e88-7832-ac00-5c20bc613116	XLE	2026-09-11 11:25	call_diagonal_spread	2	1	168	216384.00	short	bid	65.0700	0.4000	["59","60"]	["0.4311","0.2331"]	[]	["AMXO"]	59.0000	60.0000	7	98	false	false	true	true	false
01a09110-1919-7b20-bfc4-44e50dd8f162	XLE	2026-09-11 11:22	call_diagonal_spread	2	1	534	764688.00	short	ask	65.0200	0.5000	["57.5","60"]	["0.5947","0.2289"]	[]	["ARCO"]	57.5000	60.0000	7	98	false	false	true	true	false
01a09105-5348-7202-998d-8b9c21764a08	XLE	2026-09-11 11:10	call_diagonal_spread	2	7	215	145383.00	long	ask	64.8050	0.1800	["65","68"]	["0.2527","0.2421"]	[]	["BATO","C2OX","EDGO","XCBO","XISX"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-5348-7202-998d-8b8a0007119c	XLE	2026-09-11 11:10	call_diagonal_spread	2	6	161	108533.00	long	ask	64.8050	0.1800	["65","68"]	["0.2517","0.2416"]	[]	["AMXO","ARCO","EMLD","MCRY","XBOX","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-5348-7202-998d-8b7393e63be3	XLE	2026-09-11 11:10	call_diagonal_spread	2	6	108	73008.00	long	ask	64.8050	0.1800	["65","68"]	["0.2526","0.2421"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-5348-7202-998d-8b6e6956d697	XLE	2026-09-11 11:10	other	2	6	115	77488.00	unknown	—	64.8050	0.1800	["65","68"]	["0.2521","0.2412"]	[]	["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false	mlet
01a09105-5348-7202-998d-8b5441204ddf	XLE	2026-09-11 11:10	call_diagonal_spread	2	5	120	81144.00	long	ask	64.8050	0.1800	["65","68"]	["0.2527","0.2421"]	[]	["BATO","C2OX","EDGO","XCBO","XISX"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-5348-7202-998d-8b4241a92578	XLE	2026-09-11 11:10	call_diagonal_spread	2	7	174	117270.00	short	bid	64.8050	0.1800	["65","68"]	["0.2526","0.2410"]	[]	["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-3fc0-7de2-953d-249b6b9f058a	XLE	2026-09-11 11:10	other	2	2	63	42651.00	unknown	—	64.8150	0.1800	["65","68"]	["0.2525","0.2421"]	[]	["EMLD","XMIO"]	65.0000	68.0000	70	189	false	true	true	true	false	mlet
01a09105-3fc0-7de2-953d-248c79abb6ae	XLE	2026-09-11 11:10	call_diagonal_spread	2	6	168	113624.00	long	ask	64.8150	0.1800	["65","68"]	["0.2523","0.2419"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-3fc0-7de2-953d-247bdffd6aa4	XLE	2026-09-11 11:10	other	2	4	112	75824.00	unknown	—	64.8150	0.1550	["65","68"]	["0.2525","0.2421"]	[]	["AMXO","MCRY","XBOX","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false	mlet
01a09105-2c38-78e2-a55d-6e00dbd35e8a	XLE	2026-09-11 11:10	call_diagonal_spread	2	9	326	221828.00	short	bid	64.8350	0.1700	["65","68"]	["0.2527","0.2428"]	[]	["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XCBO","XISX"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-2c38-78e2-a55d-6df29498d909	XLE	2026-09-11 11:10	call_diagonal_spread	2	8	184	124984.00	short	bid	64.8350	0.1654	["65","68"]	["0.2521","0.2424"]	[]	["AMXO","EMLD","MCRY","XBOX","XMIO","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09105-14c8-7972-91c0-d65cf7bb6fce	XLE	2026-09-11 11:10	call_diagonal_spread	2	6	145	98851.00	short	bid	64.8600	0.1700	["65","68"]	["0.2516","0.2427"]	[]	["AMXO","EMLD","MCRY","XISX","XMIO","XPHO"]	65.0000	68.0000	70	189	false	true	true	true	false
01a09104-e9d1-7f91-97ac-abdb208299d4	XLE	2026-09-11 11:10	other	2	1	38	25916.00	unknown	—	64.8900	0.1700	["65","68"]	["0.2498","0.2424"]	[]	["MCRY"]	65.0000	68.0000	70	189	false	true	true	true	false	mlet
01a090f2-ec58-7331-b458-f301fecb700e	XLE	2026-09-11 10:50	call_diagonal_spread	2	1	200	300000.00	short	ask	64.8197	1.0000	["55","65"]	["0.6783","0.2294"]	[]	["SPHR"]	55.0000	65.0000	7	201	false	false	true	true	false
01a090e3-09f1-75a3-b216-f1e99ef9fa9d	XLE	2026-09-11 10:33	other	2	2	3900	5457400.00	unknown	—	65.2250	1.2125	["55","70"]	["0.1882","0.2252"]	[]	["XCBO"]	55.0000	70.0000	279	371	false	false	true	true	false	mfsl
01a090df-54b8-7250-aabe-c2e52f68c619	XLE	2026-09-11 10:29	other	2	1	111	34743.00	unknown	—	65.2401	0.0900	["63.5","64.5"]	["0.5497","0.2605"]	[]	["EDGO"]	63.5000	64.5000	0	7	false	false	true	true	false	mlet
01a090cf-08d9-7481-bd09-0c14829e49fd	XLE	2026-09-11 10:11	call_diagonal_spread	2	1	90	47970.00	unknown	—	65.4400	1.1600	["65.5","66"]	["0.2464","0.2500"]	[]	["XCBO"]	65.5000	66.0000	49	70	false	true	true	true	false	mlat
01a08cb9-7cb0-7bc1-a53f-c147c56cbc35	XLE	2026-09-10 15:09	strangle	2	1	1000	697000.00	short	bid	65.2000	0.3000	["65","67.5"]	["0.2868","0.2442"]	["58.03","74.47"]	["XPHO"]	65.0000	67.5000	127	127	false	true	false	true	true	mlft
01a08cb8-f3f8-7ec3-b01f-9af07f2f8e9c	XLE	2026-09-10 15:08	other	2	1	59	118590.00	unknown	—	65.2050	0.6500	["60","65"]	["0.2202","0.1984"]	[]	["MCRY"]	60.0000	65.0000	280	827	false	false	true	true	false	mlet
01a08ca7-3501-7c42-9bd1-114c659c3ce4	XLE	2026-09-10 14:49	call_vertical_spread	2	1	160	44640.00	unknown	—	65.0550	0.1000	["65","70"]	["0.2489","0.2609"]	[]	["XCBO"]	65.0000	70.0000	36	36	false	false	false	true	false	mlat
01a08c8e-7ce0-7793-926d-e0517eb730e2	XLE	2026-09-10 14:22	other	3	1	38	44080.00	unknown	—	65.2000	0.4700	["59.5","60","64"]	["0.9238","0.3258","0.2812"]	[]	["XPHO"]	59.5000	64.0000	1	8	false	false	true	true	true	mlet
01a08c79-3791-7cd2-add3-ef4d5c9ab46b	XLE	2026-09-10 13:59	other	2	2	24	33080.00	unknown	—	65.1050	0.7500	["59","60"]	["0.4153","0.2008"]	[]	["ARCO","XISX"]	59.0000	60.0000	8	463	false	false	true	true	false	mlet
01a08c79-3791-7cd2-add3-ef38c3525553	XLE	2026-09-10 13:59	other	2	3	56	77312.00	unknown	—	65.1050	0.7500	["59","60"]	["0.4435","0.2013"]	[]	["ARCO","EDGO","XISX"]	59.0000	60.0000	8	463	false	false	true	true	false	mlet
01a08c79-33a8-7d23-966a-b7626efe7b17	XLE	2026-09-10 13:59	other	2	3	42	57930.00	unknown	—	65.1050	0.7000	["59","60"]	["0.4021","0.2012"]	[]	["AMXO","XCBO","XPHO"]	59.0000	60.0000	8	463	false	false	true	true	false	mlet
01a08c78-64a0-7552-b0a5-e82f85bc582f	XLE	2026-09-10 13:58	call_vertical_spread	2	1	130	80080.00	short	bid	65.0900	0.3000	["65","69"]	["0.2572","0.2639"]	["66.58"]	["XCBO"]	65.0000	69.0000	99	99	false	false	false	true	false
01a08c6f-b9e0-7552-b91d-2419ebb31ff7	XLE	2026-09-10 13:48	put_vertical_spread	2	1	3000	237000.00	unknown	—	65.1500	0.1200	["45","55"]	["0.3326","0.2841"]	[]	["ARCO"]	45.0000	55.0000	127	127	false	true	false	true	false	mlct
01a08c6b-d5c8-70a0-a656-ce2eced2804d	XLE	2026-09-10 13:44	put_vertical_spread	2	1	12000	948000.00	unknown	—	65.1600	0.1100	["45","55"]	["0.3327","0.2842"]	[]	["ARCO"]	45.0000	55.0000	127	127	false	true	false	true	false	mlct
01a08c64-5fa0-7062-8829-7be771048636	XLE	2026-09-10 13:36	other	2	1	40	40960.00	unknown	—	65.2500	0.2800	["60","62.5"]	["0.2272","0.2940"]	[]	["C2OX"]	60.0000	62.5000	8	127	false	false	true	true	false	mlet
01a08c4e-4378-7cb2-bc8a-6c626dcd70dc	XLE	2026-09-10 13:12	call_vertical_spread	2	1	100	71200.00	short	bid	65.2100	0.1600	["60","64"]	["0.3263","0.2781"]	["63.50"]	["XMIO"]	60.0000	64.0000	8	8	false	false	false	true	false
01a08bcc-ced9-7e10-94f0-3081b766f90f	XLE	2026-09-10 10:50	other	4	1	154	27566.00	unknown	—	64.6950	0.1700	["63","65","67"]	["0.2821","0.2783","0.2785"]	[]	["XPHO"]	63.0000	67.0000	8	8	false	false	false	true	true	mlet
01a08bba-96c8-7d13-b349-93fa99727d2e	XLE	2026-09-10 10:30	call_vertical_spread	2	1	100	57400.00	unknown	—	64.6400	0.3000	["65","69"]	["0.2586","0.2625"]	[]	["XBOX"]	65.0000	69.0000	99	99	false	true	false	true	false	mlat
01a08bb6-e190-7b43-8992-5179a955a9c8	XLE	2026-09-10 10:26	call_vertical_spread	2	1	90	34740.00	unknown	—	64.4150	0.2200	["67.5","75"]	["0.2454","0.2601"]	[]	["XCBO"]	67.5000	75.0000	127	127	false	true	false	true	false	mlat
01a08ba2-a5e0-7382-adce-48e6310f3319	XLE	2026-09-10 10:04	call_vertical_spread	2	1	130	64350.00	long	ask	64.9000	0.1500	["66","71"]	["0.2587","0.2646"]	["67.67"]	["XCBO"]	66.0000	71.0000	99	99	false	true	false	true	false
01a08ba2-a1f8-75c1-9293-2d609e2ceee7	XLE	2026-09-10 10:04	call_vertical_spread	2	5	170	84000.00	long	ask	64.9000	0.1503	["66","71"]	["0.2587","0.2638"]	["67.68"]	["ARCO","EMLD","SPHR","XBOX","XPHO"]	66.0000	71.0000	99	99	false	true	false	true	false
01a08b8a-7a60-7c30-9269-be19caf568bf	XLE	2026-09-10 09:38	call_vertical_spread	2	1	75	30075.00	unknown	—	65.4000	0.2400	["65","75"]	["0.2538","0.2778"]	[]	["XPHO"]	65.0000	75.0000	71	71	false	false	false	true	false	mlet
01a087af-5b41-7b43-b7c3-13b36dc56567	XLE	2026-09-09 15:40	call_vertical_spread	2	1	35	41475.00	short	bid	65.3600	0.4000	["58","62"]	["0.1923","0.2367"]	["61.39"]	["XMIO"]	58.0000	62.0000	37	37	false	false	false	true	false
01a087ac-2ec0-77a3-9adb-0bbcebf5834c	XLE	2026-09-09 15:36	call_diagonal_spread	2	1	14	34440.00	long	bid	65.4200	0.5500	["50","57.5"]	["0.3286","0.2386"]	[]	["XISX"]	50.0000	57.5000	72	100	false	false	true	true	false