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 = XOP×

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

01a0cab3-afa7-7e60-af7f-b7303770b7cf	XOP	2026-09-22 15:59	put_vertical_spread	2	1	700	2317000.00	short	bid	181.5950	5.3500	["125","175"]	["0.3661","0.3605"]	["157.90"]	["AMXO"]	125.0000	175.0000	815	815	true	true	false	true	false	mlft	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T19:59:32Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0c975-866f-77c2-8bbd-185ab7db326b	XOP	2026-09-22 10:11	put_vertical_spread	2	1	50	136000.00	long	ask	183.6900	3.1000	["185","190"]	["0.3491","0.3501"]	["187.20"]	["XPHO"]	185.0000	190.0000	87	87	false	false	false
01a0c975-3c37-7bd2-80cd-9155b89c07e4	XOP	2026-09-22 10:11	call_vertical_spread	2	1	50	105000.00	long	ask	183.5800	2.6500	["185","190"]	["0.3193","0.3188"]	["187.20"]	["XISX"]	185.0000	190.0000	87	87	false	true	false
01a0c96f-ae57-77b3-aa14-ba52af91981f	XOP	2026-09-22 10:05	put_vertical_spread	2	3	93	109957.00	unknown	bid	182.7200	0.8800	["170","190"]	["0.3455","0.3209"]	["178.18"]	["AMXO","XCBO","XISX"]	170.0000	190.0000	24	24	false	false
01a0c434-3fcf-7e60-a843-e14aa052f1e2	XOP	2026-09-21 09:42	call_diagonal_spread	2	2	211	258264.00	long	ask	186.1200	1.4500	["190","195"]	["0.3340","0.3393"]	[]	["EMLD","SPHR"]	190.0000	195.0000	25	60	false	true	true
01a0c434-3fcf-7e60-a843-e13faf46f708	XOP	2026-09-21 09:42	call_diagonal_spread	2	5	109	135300.00	long	ask	186.1200	1.7110	["190","195"]	["0.3369","0.3442"]	[]	["AMXO","EMLD","SPHR","XBOX"]	190.0000	195.0000	25	60	false	true	true
01a0c434-3fcf-7e60-a843-e1205cd124a2	XOP	2026-09-21 09:42	call_diagonal_spread	2	2	115	143750.00	long	ask	186.1200	2.0000	["190","195"]	["0.3384","0.3467"]	[]	["ARCO"]	190.0000	195.0000	25	60	false	true	true
01a0b58e-3eb7-76f3-b71f-976781dfa383	XOP	2026-09-18 13:26	put_vertical_spread	2	1	500	1005000.00	unknown	bid	191.0500	2.5500	["125","175"]	["0.3543","0.3430"]	["154.90"]	["XBOX"]	125.0000	175.0000	490	490	false	true	false
01a0b0c3-6c93-7323-bd66-ef7c171784d0	XOP	2026-09-17 15:06	call_vertical_spread	2	1	48	239472.00	unknown	—	192.8100	3.0000	["165","170"]	["1.8302","1.5419"]	[]	["MCRY"]	165.0000	170.0000	1	1	false	false	false	true	false
01a0b059-834b-7901-b969-b4d3201021c0	XOP	2026-09-17 13:10	call_vertical_spread	2	1	33	162492.00	unknown	—	192.3900	2.3000	["165","170"]	["1.7246","1.4457"]	[]	["XCBO"]	165.0000	170.0000	1	1	false	false	false	true	false
01a0aa87-a50b-73b0-b33a-a1bfa0bd7ec2	XOP	2026-09-16 10:03	call_vertical_spread	2	1	50	177800.00	short	bid	194.5700	3.6000	["185","190"]	["0.3314","0.3332"]	["187.80"]	["XMIO"]	185.0000	190.0000	93	93	false	false	false
01a0a689-bad6-7bc0-9b7d-dd981e5967c6	XOP	2026-09-15 15:27	call_vertical_spread	2	1	43	167485.00	short	bid	199.2300	4.9000	["220","250"]	["0.2911","0.2971"]	["228.50"]	["ARCO"]	220.0000	250.0000	493	493	true	true	false
01a0a614-5bf6-7c52-8acd-20640fd47502	XOP	2026-09-15 13:19	call_ratio_spread	2	1	2500	816000.00	unknown	—	199.6200	0.7400	["200","205"]	["0.4007","0.4118"]	[]	["ARCO"]	200.0000	205.0000	3	3	false	true	false	true	false
01a0a0cd-d660-7a63-9c9b-46733dac5348	XOP	2026-09-14 12:43	put_frontspread	2	1	1800	758700.00	long	ask	196.2200	0.6900	["180","188"]	["0.3525","0.3475"]	["171.99"]	["ARCO"]	180.0000	188.0000	32	32	false	true	false
01a0a07b-3dd8-7971-95f5-606d00d53e9e	XOP	2026-09-14 11:13	call_diagonal_spread	2	1	15	111750.00	short	ask	195.6000	5.0500	["155","165"]	["0.8581","0.2915"]	[]	["XCBO"]	155.0000	165.0000	4	95	false	false	true
01a0a056-9af0-7533-93c2-b33c6399e724	XOP	2026-09-14 10:33	call_calendar	2	1	80	425440.00	short	ask	198.3050	5.1500	["240"]	["0.2926"]	[]	["XMIO"]	240.0000	240.0000	823	858	true	true	true
01a0a056-3d31-7733-8cba-63a412d36130	XOP	2026-09-14 10:33	call_calendar	2	5	40	204608.00	short	bid	198.2400	6.1500	["245"]	["0.2964"]	[]	["AMXO","C2OX","EMLD","XMIO","XPHO"]	245.0000	245.0000	823	858	false	true	true
01a0a056-3561-7fb1-af81-93fb26ae0f7e	XOP	2026-09-14 10:33	other	2	6	40	204088.00	unknown	—	198.2400	6.3300	["245"]	["0.2959"]	[]	["AMXO","C2OX","EMLD","XMIO","XPHO"]	245.0000	245.0000	823	858	true	true	true	false	false
01a0a055-8d68-7fb1-b435-47bb7df1ef8e	XOP	2026-09-14 10:32	call_calendar	2	5	40	193280.00	short	bid	198.2100	5.7200	["250"]	["0.2961"]	[]	["ARCO","C2OX","EMLD","XMIO","XPHO"]	250.0000	250.0000	823	858	true	true	true
01a0a054-7fe0-7a62-9caa-ef9978742119	XOP	2026-09-14 10:31	call_calendar	2	11	80	371274.00	short	bid	198.3300	5.4500	["255"]	["0.2985"]	[]	["AMXO","ARCO","C2OX","EDGO","EMLD","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"]	255.0000	255.0000	823	858	true	true
01a090d8-9240-7a60-b359-1c14988c71a8	XOP	2026-09-11 10:21	call_vertical_spread	2	1	56	112896.00	unknown	—	195.9500	3.1000	["185","190"]	["0.4462","0.3997"]	[]	["XPHO"]	185.0000	190.0000	7	7	false	false	false	true	false
01a08caf-e790-7113-a672-9cea45aaa532	XOP	2026-09-10 14:58	call_vertical_spread	2	1	23	133998.00	unknown	—	196.5500	5.9000	["225","230"]	["0.2795","0.2798"]	[]	["XMIO"]	225.0000	230.0000	827	827	false	true	false	true	false
01a08bc7-c9b0-7bb0-b9ce-2229e08dd499	XOP	2026-09-10 10:45	put_calendar	2	1	1960	613480.00	short	ask	194.0500	0.6400	["180"]	["0.3561"]	[]	["AMXO"]	180.0000	180.0000	8	36	false	true	true
01a086a4-c529-7050-9525-98693945cbba	XOP	2026-09-09 10:48	call_diagonal_spread	2	3	321	1686612.00	long	bid	194.2200	4.8000	["180","190"]	["0.3178","0.3086"]	[]	["BATO","C2OX","XCBO"]	180.0000	190.0000	191	281	false	false	true
01a086a4-c529-7050-9525-9851d523d029	XOP	2026-09-09 10:48	other	2	2	164	878860.00	unknown	—	194.2200	4.8043	["180","190"]	["0.3287","0.3166"]	[]	["XBOX","XPHO"]	180.0000	190.0000	191	281	false	false	true	true	false
01a086a4-c529-7050-9525-984ae2073651	XOP	2026-09-09 10:48	call_diagonal_spread	2	3	279	1466145.00	short	ask	194.2200	4.9333	["180","190"]	["0.3181","0.3085"]	[]	["EMLD","SPHR","XPHO"]	180.0000	190.0000	191	281	false	false	true
01a086a4-c529-7050-9525-983936b838a9	XOP	2026-09-09 10:48	other	2	5	236	1234430.00	unknown	—	194.2200	5.0000	["180","190"]	["0.3156","0.3066"]	[]	["EMLD","SPHR","XBOX","XPHO"]	180.0000	190.0000	191	281	false	false	true	true	false
01a081d4-f181-7e82-8713-36bdc8af3044	XOP	2026-09-08 12:23	call_condor	4	3	10	139840.00	unknown	—	193.9600	13.7000	["190","205","210","220"]	["0.2659","0.2706","0.2767","0.2765"]	[]	["AMXO"]	190.0000	220.0000	829	829	false	false	false	true	false
01a08185-d780-7f53-a194-f98d496aebf6	XOP	2026-09-08 10:57	other	2	1	5000	3367500.00	unknown	—	194.5550	1.9200	["165","185"]	["0.3376","0.3312"]	[]	["ARCO"]	165.0000	185.0000	101	101	false	true	false	true	false
01a08181-e7b1-72b1-afbe-9246c7d429eb	XOP	2026-09-08 10:52	call_vertical_spread	2	6	12	101970.00	unknown	—	194.5451	3.1833	["150","155"]	["0.8940","0.7972"]	[]	["ARCO","EMLD","SPHR","XBOX","XISX","XPHO"]	150.0000	155.0000	10	10	false	false	false	true
01a0813b-f958-7353-bc21-b4a4c42890e8	XOP	2026-09-08 09:36	call_vertical_spread	2	1	17	145928.00	unknown	—	195.1500	1.5000	["150","155"]	["0.7389","0.6536"]	[]	["EDGO"]	150.0000	155.0000	10	10	false	false	false	true	false
01a0813b-eda1-7c40-a947-e834abcd6942	XOP	2026-09-08 09:36	call_vertical_spread	2	3	12	102958.00	unknown	—	195.1500	1.0000	["150","155"]	["0.7186","0.6345"]	[]	["BATO","C2OX","EDGO"]	150.0000	155.0000	10	10	false	false	false	true
01a06dfd-3f8d-7540-89a5-0d9c2e392371	XOP	2026-09-04 15:55	call_condor	4	1	12	167688.00	long	ask	190.8200	14.9000	["170","200","210","230"]	["0.2666","0.2814","0.2841","0.2901"]	["177.10"]	["XCBO"]	170.0000	230.0000	833	833	false	false	false