Multi-leg option trades

core.multileg_trades

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

473,794 rowsCSV — whole table, not this view

Sources in this table

uw_multileg473,794 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:ticker = ROIV×

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

01a0b505-1d3f-73e2-861a-69900f985bc0	ROIV	2026-09-18 10:56	call_diagonal_spread	2	2	45	138375.00	unknown	—	39.8800	5.9889	["20","30"]	["18.4975","0.9259"]	[]	["ARCO"]	20.0000	30.0000	0	28	false	false	true	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-18T14:56:45Z"}	2026-09-18	2026-09-18 17:15	2026-09-18 17:15
01a08260-e5a0-7730-8f72-c4d714049d87	ROIV	2026-09-08 14:56	other	2	1	8800	7565600.00	unknown	—	41.3500	3.4000	["39","45"]	["0.4856","0.4902"]	[]	["XPHO"]	39.0000	45.0000	101	164	false	false	true	true	false	mlft
01a0825f-0910-7110-900a-412f2a234433	ROIV	2026-09-08 14:54	call_diagonal_spread	2	3	211	215854.00	short	bid	41.3600	1.4000	["40","45"]	["0.4893","0.4170"]	[]	["EDGO","XCBO","XISX"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825f-0910-7110-900a-40f3a2e3f8a9	ROIV	2026-09-08 14:54	call_diagonal_spread	2	4	107	109351.00	short	bid	41.3500	1.3673	["40","45"]	["0.4901","0.4166"]	[]	["SPHR","XBOX","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825f-0910-7110-900a-40e9322d77ac	ROIV	2026-09-08 14:54	call_diagonal_spread	2	5	160	163676.00	short	bid	41.3500	1.3338	["40","45"]	["0.4907","0.4170"]	[]	["SPHR","XBOX","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825d-4009-72d3-bc94-7550b0357b88	ROIV	2026-09-08 14:52	other	2	3	432	454600.00	unknown	—	41.4500	1.9000	["40","45"]	["0.4816","0.3849"]	[]	["MCRY","XPHO"]	40.0000	45.0000	101	346	false	false	true	true	false	mlet
01a0825d-18f8-7ef2-9054-c15ac7ef18bb	ROIV	2026-09-08 14:52	call_diagonal_spread	2	1	112	116480.00	short	bid	41.4500	1.0000	["40","45"]	["0.4917","0.4203"]	[]	["C2OX"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825d-18f8-7ef2-9054-c1406675a76c	ROIV	2026-09-08 14:52	call_diagonal_spread	2	1	116	121104.00	short	bid	41.4500	0.8000	["40","45"]	["0.4941","0.4217"]	[]	["C2OX"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825a-6590-79a3-9a7f-271429cc80af	ROIV	2026-09-08 14:49	call_diagonal_spread	2	1	500	546900.00	short	bid	41.5250	2.4000	["40","45"]	["0.5005","0.3956"]	[]	["XCBO"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0825a-1b58-79b3-85c6-250441d4c971	ROIV	2026-09-08 14:48	call_diagonal_spread	2	1	142	151088.00	short	bid	41.5200	2.5000	["40","45"]	["0.5009","0.4261"]	[]	["C2OX"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825a-1b58-79b3-85c6-24fbd189b1f3	ROIV	2026-09-08 14:48	call_diagonal_spread	2	5	151	160315.00	short	bid	41.5200	2.4000	["40","45"]	["0.5001","0.4249"]	[]	["MCRY","XBOX","XISX","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a0825a-1b58-79b3-85c6-24e1b095dcf1	ROIV	2026-09-08 14:48	call_diagonal_spread	2	10	119	126893.00	short	bid	41.5200	2.1765	["40","45"]	["0.5029","0.4265"]	[]	["AMXO","ARCO","EMLD","SPHR","XBOX","XMIO","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a08258-6da8-7b90-8af4-be5d954435c1	ROIV	2026-09-08 14:47	call_diagonal_spread	2	1	146	154468.00	short	bid	41.3000	2.1000	["40","45"]	["0.4932","0.3932"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08258-61f0-7953-b383-a1c9e6b7e156	ROIV	2026-09-08 14:47	call_diagonal_spread	2	1	142	150236.00	short	bid	41.2800	2.3000	["40","45"]	["0.4947","0.3939"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08258-5638-7673-998d-ccfa0a5a51e9	ROIV	2026-09-08 14:46	call_diagonal_spread	2	1	145	153410.00	short	bid	41.2300	1.9000	["40","45"]	["0.4984","0.3955"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0824f-22c0-7151-b90d-586cd9b6b7f1	ROIV	2026-09-08 14:36	call_diagonal_spread	2	10	250	252986.00	short	bid	41.2500	0.6000	["40","45"]	["0.4854","0.4202"]	[]	["AMXO","ARCO","EDGO","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a08242-22a0-7a02-9370-4d9a2481bcf4	ROIV	2026-09-08 14:22	call_diagonal_spread	2	1	149	157493.00	short	bid	41.2500	1.2000	["40","45"]	["0.4969","0.3942"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08242-1301-7080-b472-6dd58eb71a34	ROIV	2026-09-08 14:22	call_diagonal_spread	2	1	149	157642.00	short	bid	41.2400	3.0000	["40","45"]	["0.4976","0.3952"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0823c-d340-78e0-962f-e2b3185b28f7	ROIV	2026-09-08 14:16	call_diagonal_spread	2	1	147	161112.00	short	bid	41.3362	1.5000	["40","45"]	["0.5122","0.4045"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0823c-98a8-7d50-a1c1-d21c7176a02c	ROIV	2026-09-08 14:16	call_diagonal_spread	2	1	148	161912.00	short	bid	41.2950	2.6000	["40","45"]	["0.5141","0.4053"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0823c-0ff0-7133-8ef3-3f5bbba53d46	ROIV	2026-09-08 14:16	call_diagonal_spread	2	1	147	160818.00	short	bid	41.3300	1.7000	["40","45"]	["0.5115","0.4041"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a0822b-75f0-7340-9dd0-57bf6d35df9e	ROIV	2026-09-08 13:57	other	2	9	228	259010.00	unknown	—	42.2000	1.4000	["40","45"]	["0.4763","0.4348"]	[]	["AMXO","ARCO","EDGO","SPHR","XBOX","XCBO","XISX","XMIO","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false	mlet
01a08227-66e1-7833-8085-d98d25b850a7	ROIV	2026-09-08 13:53	other	2	8	393	461849.00	unknown	—	42.3400	2.5359	["40","45"]	["0.4921","0.3907"]	[]	["BATO","C2OX","EMLD","MCRY","XBOX","XPHO"]	40.0000	45.0000	101	346	false	false	true	true	false	mlet
01a08210-1620-7712-a06a-ff56f4c7c834	ROIV	2026-09-08 13:28	call_diagonal_spread	2	3	139	161364.00	short	bid	42.0900	2.5000	["40","45"]	["0.5177","0.4374"]	[]	["BATO","C2OX","EDGO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a08210-1620-7712-a06a-ff43df8dc86e	ROIV	2026-09-08 13:28	call_diagonal_spread	2	4	179	209878.00	short	bid	42.0900	2.6000	["40","45"]	["0.5252","0.4411"]	[]	["ARCO","EMLD","SPHR","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false
01a081bf-98a9-7252-9afa-0e407e615dd2	ROIV	2026-09-08 12:00	call_diagonal_spread	2	1	141	154254.00	long	ask	41.6600	1.5000	["40","45"]	["0.4963","0.3881"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081bf-8908-7041-a529-79753dea2df2	ROIV	2026-09-08 12:00	call_diagonal_spread	2	2	141	154959.00	long	ask	41.6500	1.4298	["40","45"]	["0.4991","0.3906"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081bf-8908-7041-a529-796af2238927	ROIV	2026-09-08 12:00	call_diagonal_spread	2	1	141	154345.00	long	ask	41.6300	1.5000	["40","45"]	["0.4973","0.3902"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081ba-ce18-79e3-b2d1-b8d39f9cf969	ROIV	2026-09-08 11:54	other	2	1	105	111300.00	unknown	—	41.3500	1.4000	["40","45"]	["0.4955","0.3897"]	[]	["XCBO"]	40.0000	45.0000	101	346	false	false	true	true	false	mlet
01a081ba-a708-7d90-ad2e-279cb28ee329	ROIV	2026-09-08 11:54	call_diagonal_spread	2	1	146	154614.00	unknown	—	41.3350	1.4000	["40","45"]	["0.4954","0.3902"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false	mlet
01a081ba-9381-7b80-a59d-e8202f58d271	ROIV	2026-09-08 11:54	call_diagonal_spread	2	3	147	156501.00	short	bid	41.3350	1.1000	["40","45"]	["0.4988","0.3919"]	[]	["C2OX","SPHR","XBOX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b7-43d8-7990-835c-8c7105ee1d62	ROIV	2026-09-08 11:51	call_diagonal_spread	2	4	151	163633.00	short	bid	41.3699	1.4000	["40","45"]	["0.5053","0.3980"]	[]	["EDGO","XCBO","XISX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b7-43d8-7990-835c-8c1fa03530e9	ROIV	2026-09-08 11:51	call_diagonal_spread	2	6	99	106259.00	short	bid	41.3699	1.7000	["40","45"]	["0.5051","0.3916"]	[]	["AMXO","ARCO","SPHR","XBOX","XMIO","XPHO"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b4-2310-7d90-a977-429d6c347989	ROIV	2026-09-08 11:47	call_diagonal_spread	2	1	95	100795.00	short	bid	41.2350	1.0000	["40","45"]	["0.5016","0.3954"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b4-1b40-7cd1-a57e-fb7e29e8b363	ROIV	2026-09-08 11:47	call_diagonal_spread	2	2	165	175675.00	short	bid	41.2450	1.1018	["40","45"]	["0.5031","0.3962"]	[]	["C2OX","XBOX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b4-0f89-7271-b6eb-9eddfa6af617	ROIV	2026-09-08 11:47	call_diagonal_spread	2	2	145	152935.00	long	ask	41.2450	1.4993	["40","45"]	["0.4971","0.3931"]	[]	["C2OX","XBOX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081b1-3510-7243-8d59-b79171bb9f9a	ROIV	2026-09-08 11:44	other	2	1	145	157470.00	unknown	—	41.3050	0.9000	["40","45"]	["0.5061","0.4037"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false	mlet
01a081b1-19b8-73e0-b163-b481ea6fe738	ROIV	2026-09-08 11:44	call_diagonal_spread	2	2	146	159240.00	short	bid	41.2950	0.8007	["40","45"]	["0.5090","0.4058"]	[]	["C2OX","XBOX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081ad-58c8-7db1-a5f4-32e6d78545d3	ROIV	2026-09-08 11:40	call_diagonal_spread	2	1	156	170040.00	unknown	—	41.2550	0.6000	["40","45"]	["0.5086","0.4085"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false	mesl
01a081ad-4d10-7ee1-9421-354dd9b176f2	ROIV	2026-09-08 11:40	call_diagonal_spread	2	1	149	162410.00	unknown	—	41.2575	0.6000	["40","45"]	["0.5084","0.4084"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false	mesl
01a081ad-4d10-7ee1-9421-353943956858	ROIV	2026-09-08 11:40	call_diagonal_spread	2	1	101	109484.00	long	ask	41.2575	0.9000	["40","45"]	["0.5048","0.4065"]	[]	["C2OX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081a3-0828-7063-9003-88c369fdd2b8	ROIV	2026-09-08 11:28	call_diagonal_spread	2	3	151	168300.00	long	ask	41.7600	1.4000	["40","45"]	["0.4952","0.3942"]	[]	["EDGO","XCBO","XISX"]	40.0000	45.0000	101	346	false	false	true	true	false
01a081a3-0828-7063-9003-885ebaa24f57	ROIV	2026-09-08 11:28	call_diagonal_spread	2	6	99	109174.00	short	bid	41.7600	1.4000	["40","45"]	["0.5025","0.3832"]	[]	["AMXO","ARCO","SPHR","XBOX","XMIO","XPHO"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08191-c630-77e3-833c-0afa951fa52a	ROIV	2026-09-08 11:10	call_diagonal_spread	2	3	135	152100.00	short	bid	41.4700	0.9333	["40","45"]	["0.5086","0.4158"]	[]	["EMLD","MCRY"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08191-c630-77e3-833c-0ae776f1a1f7	ROIV	2026-09-08 11:10	call_diagonal_spread	2	7	315	356400.00	short	bid	41.4700	1.2000	["40","45"]	["0.5115","0.4173"]	[]	["AMXO","EMLD","MCRY","XISX","XMIO","XPHO"]	40.0000	45.0000	101	346	false	false	true	true	false
01a08183-ef38-7bd3-a26b-b74ae34a5ed8	ROIV	2026-09-08 10:54	call_diagonal_spread	2	5	268	262212.00	short	bid	40.8100	1.2000	["40","45"]	["0.4976","0.4227"]	[]	["EMLD","MCRY","XISX","XMIO","XPHO"]	40.0000	45.0000	101	282	false	false	true	true	false