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

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

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	false	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T18:40:11Z"}	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	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	false	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	true	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	true	true	false
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	true	true	false
01a0c9db-f8ff-7fa2-aa04-9120bd46d99e	XLE	2026-09-22 12:03	put_diagonal_spread	2	1	3000	210000.00	long	ask	62.6400	0.0400	["60","60.5"]	["0.2624","0.3122"]	[]	["ARCO"]	60.0000	60.5000	3	24	false	true	true	true	false
01a0c9c4-7576-73b1-afef-7bad4e9b9938	XLE	2026-09-22 11:38	put_calendar	2	1	2500	467500.00	long	ask	62.4699	0.1300	["59"]	["0.2692"]	[]	["XISX"]	59.0000	59.0000	38	59	false	true	true	false	false
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	true	true	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	true	true	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	true	true	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	false	true	false
01a0c584-473f-74f3-8e91-61a35e015aa3	XLE	2026-09-21 15:49	synthetic	2	1	10500	10332000.00	long	ask	62.4700	0.4100	["55"]	["0.2662"]	["63.10"]	["AMXO"]	55.0000	55.0000	116	116	false	false	false	false	true
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	true	true	false
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	true	true
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	true	true	false
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	false	false
01a0b4d5-e367-7b42-bdb2-4fbc1ec60a2b	XLE	2026-09-18 10:05	put_vertical_spread	2	1	149	33674.00	long	ask	64.3800	0.0700	["64","65"]	["0.2906","0.3140"]	["64.40"]	["XISX"]	64.0000	65.0000	7	7	false	false	false	true	false
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	false	false
01a0b4bd-d33f-78a1-9c68-4029357462cd	XLE	2026-09-18 09:38	call_calendar	2	1	10	35400.00	long	ask	64.1300	0.5000	["46.5"]	["3.1533"]	[]	["XMIO"]	46.5000	46.5000	0	91	false	false	true	false	false
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	true	true	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	false	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	true	true	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	true	true	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	false	true	false
01a0aa7c-e70c-7510-b4d4-c3050d1c70fd	XLE	2026-09-16 09:51	put_vertical_spread	2	1	14	38864.00	long	ask	64.7650	0.7000	["70","85"]	["0.3082","0.4429"]	["71.58"]	["XCBO"]	70.0000	85.0000	121	121	false	false	false	true
01a0a6a5-a35e-7be0-be54-35774285f834	XLE	2026-09-15 15:57	put_frontspread	2	1	5530	184924.00	long	ask	65.9100	0.0600	["63.5","65"]	["0.3331","0.3200"]	["61.45","64.78"]	["XPHO"]	63.5000	65.0000	3	3	false	true	false	true	false
01a0a6a1-9066-7083-8166-4f9861f6c1f9	XLE	2026-09-15 15:53	call_vertical_spread	2	1	25	64375.00	long	ask	65.7950	0.3250	["50","57.5"]	["0.3299","0.2119"]	["56.75"]	["MCRY"]	50.0000	57.5000	122	122	false	false	false	true
01a0a67c-aefe-7f50-9424-b710db6a2ea3	XLE	2026-09-15 15:13	call_diagonal_spread	2	1	20	117920.00	long	ask	65.8000	3.5000	["35","38"]	["1.1512","2.6667"]	[]	["BATO"]	35.0000	38.0000	3	31	false	false	true	true	false
01a0a672-cfa5-7703-8277-6095f8b5850f	XLE	2026-09-15 15:02	straddle	2	1	310	131440.00	long	ask	65.8170	0.0700	["66"]	["0.2772"]	["61.76","70.24"]	["XBOX"]	66.0000	66.0000	31	31	false	false	false	false	true
01a0a64c-adee-7702-bb29-6e6db856ab7e	XLE	2026-09-15 14:20	call_vertical_spread	2	1	25	65175.00	long	ask	65.9550	0.6500	["50","57.5"]	["0.3263","0.2143"]	["56.75"]	["XMIO"]	50.0000	57.5000	122	122	false	false	false	true
01a0a637-ab06-7f72-bcd5-7669fa0829a8	XLE	2026-09-15 13:57	call_diagonal_spread	2	1	14	25816.00	long	ask	66.1000	0.8500	["65","70"]	["0.2161","0.2078"]	[]	["XPHO"]	65.0000	70.0000	458	822	false	false	true	true	false
01a0a175-de00-78d2-aff5-d773ab344e1a	XLE	2026-09-14 15:47	call_vertical_spread	2	1	10	26040.00	long	ask	64.4100	0.3000	["47","57.5"]	["0.4295","0.2282"]	["56.36"]	["EDGO"]	47.0000	57.5000	123	123	false	false	false	true
01a0a160-71a1-77e3-a32f-1cf19410ddbd	XLE	2026-09-14 15:24	call_vertical_spread	2	1	12	61176.00	long	ask	64.3850	2.4500	["39","39.5"]	["2.9355","2.9072"]	["39.48"]	["XISX"]	39.0000	39.5000	4	4	false	false	false	true
01a0a11e-9a29-7c00-b0ff-5b0a6c08687c	XLE	2026-09-14 14:12	call_vertical_spread	2	1	200	203000.00	long	ask	64.6150	0.4000	["59","61"]	["0.2000","0.2256"]	["60.67"]	["XMIO"]	59.0000	61.0000	32	32	false	false	false	true
01a0a0ea-91d9-79f0-a4d1-754ce1ea4b46	XLE	2026-09-14 13:15	call_vertical_spread	2	1	20	61600.00	long	ask	64.6700	1.9000	["47.5","52.5"]	["0.3936","0.2570"]	["52.16"]	["XMIO"]	47.5000	52.5000	123	123	false	false	false	true
01a0a0e8-3460-7513-8df2-a1800b4f6006	XLE	2026-09-14 13:12	put_vertical_spread	2	1	3752	228872.00	long	ask	64.6450	0.0300	["60","62"]	["0.3327","0.3221"]	["61.71"]	["AMXO"]	60.0000	62.0000	11	11	false	true	false	true
01a0a0de-fd00-7b13-9607-406caeef0b4e	XLE	2026-09-14 13:02	put_calendar	2	2	532	68628.00	long	ask	64.6650	0.0400	["63.5"]	["0.3220"]	[]	["ARCO","C2OX"]	63.5000	63.5000	4	11	false	true	true	false	false
01a0a0de-f530-7563-9cd3-86a82bd811c4	XLE	2026-09-14 13:02	put_calendar	2	1	654	84366.00	long	ask	64.6750	0.0400	["63.5"]	["0.3230"]	[]	["ARCO"]	63.5000	63.5000	4	11	false	true	true	false	false
01a0a0de-f149-7c51-881c-efa95e3c68ed	XLE	2026-09-14 13:02	put_calendar	2	2	209	26961.00	long	ask	64.6750	0.0400	["63.5"]	["0.3230"]	[]	["SPHR","XBOX"]	63.5000	63.5000	4	11	false	true	true	false	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
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
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
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
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
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
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
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
01a087a5-4150-7dd0-a4c9-b7e8c37ff910	XLE	2026-09-09 15:29	call_vertical_spread	2	1	200	35200.00	long	ask	65.4750	0.0700	["65","67.5"]	["0.2671","0.2623"]	["66.0"]	["XMIO"]	65.0000	67.5000	9	9	false	false	false	true
01a08796-1680-7ae1-8ef5-087d76caa002	XLE	2026-09-09 15:12	call_butterfly_spread	3	1	100	29950.00	long	ask	65.5350	0.2300	["63","65","68"]	["0.2845","0.2633","0.2694"]	["63.39","66.61"]	["XCBO"]	63.0000	68.0000	9	9	false	false	false	true