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

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

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
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	true
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
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
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
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	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	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
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
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
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
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
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
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	true
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
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
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	true
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	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	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
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
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
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
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	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	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	true
01a0c4a4-1c87-7fc3-bc63-c657e587218d	XLE	2026-09-21 11:44	other	3	1	109	33463.00	unknown	—	62.7950	0.0700	["65","75"]	["0.2617","0.2842"]	[]	["XCBO"]	65.0000	75.0000	25	60	false	true	true	true	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	true
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	true
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	false
01a0c457-e4cf-7ed2-b1be-04c0f64d8c25	XLE	2026-09-21 10:21	straddle	2	1	25	43750.00	unknown	—	62.8350	0.7800	["50"]	["0.2155"]	[]	["XCBO"]	50.0000	50.0000	452	452	false	false	false	false	true
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	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	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	true
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	true
01a0b60c-7737-73d0-aa26-31f361f229fc	XLE	2026-09-18 15:44	call_diagonal_spread	2	1	20	52400.00	unknown	ask	64.3200	0.6500	["45","65"]	["30.4610","0.2272"]	[]	["XCBO"]	45.0000	65.0000	0	364	false	false	true
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	false
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	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	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
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	true
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	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	true
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	true
01a0b51d-2d67-7472-b83e-1c66b27d9e00	XLE	2026-09-18 11:23	other	4	1	50	80150.00	unknown	—	64.6650	0.6300	["59","61","63"]	["2.5062","0.9766","0.2198"]	[]	["XCBO"]	59.0000	63.0000	0	28	false	false	true	true	false
01a0b51a-a10f-73a3-b4d6-829434777f8a	XLE	2026-09-18 11:20	call_calendar	2	1	20	49520.00	short	ask	64.6850	0.7000	["52.5"]	["2.4912"]	[]	["XCBO"]	52.5000	52.5000	0	119	false	false	true
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	true
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	true