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:source = uw_multileg×strategy = call_diagonal_spread×ticker = ORCL×

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

01a0ca8b-4fb7-7710-9172-0031897e2cfa	ORCL	2026-09-22 15:15	call_diagonal_spread	2	1	16	52240.00	unknown	—	150.3650	0.7000	["160","170"]	["0.5474","0.5609"]	[]	["XCBO"]	160.0000	170.0000	115	178	false	true	true	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T19:16:01Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0ca80-e7a6-7f41-b0f3-e9efd2c07c8e	ORCL	2026-09-22 15:03	call_diagonal_spread	2	1	30	47220.00	long	bid	149.9300	0.4000	["147","150"]	["0.4960","0.4911"]	[]	["AMXO"]	147.0000	150.0000	17	24	false	false	true
01a0ca67-1e17-7f80-809d-fc3dd276c199	ORCL	2026-09-22 14:35	call_diagonal_spread	2	1	6	33618.00	unknown	bid	149.8700	1.2000	["175","180"]	["0.5579","0.5547"]	[]	["ARCO"]	175.0000	180.0000	360	451	false	true	true
01a0ca38-ab77-7733-a935-fa82286a2755	ORCL	2026-09-22 13:45	call_diagonal_spread	2	1	11	94908.00	short	bid	148.9600	1.8500	["150","155"]	["0.5520","0.5450"]	[]	["ARCO"]	150.0000	155.0000	451	724	false	true	true
01a0ca2f-b67e-7ce1-acf6-1a4d10e566db	ORCL	2026-09-22 13:35	call_diagonal_spread	2	1	13	26013.00	short	bid	148.9500	0.2500	["160","170"]	["0.5230","0.5522"]	[]	["XCBO"]	160.0000	170.0000	59	115	false	true	true
01a0c9ec-353f-7053-a159-a5b0c562d0b1	ORCL	2026-09-22 12:21	call_diagonal_spread	2	1	11	47982.00	unknown	ask	148.9400	0.6000	["150","155"]	["0.5470","0.4869"]	[]	["BATO"]	150.0000	155.0000	24	451	false	true	true
01a0c9d0-f0c6-7b32-8a43-e928cb22341b	ORCL	2026-09-22 11:51	call_diagonal_spread	2	1	28	149352.00	long	ask	149.5400	0.7500	["125","130"]	["0.5076","0.5634"]	[]	["XISX"]	125.0000	130.0000	24	87	false	false	true
01a0c9a3-6c6f-7361-b98f-e55ca353fd16	ORCL	2026-09-22 11:02	call_diagonal_spread	2	1	3	36078.00	short	ask	148.8850	1.1000	["70","140"]	["0.5133","0.5509"]	[]	["XMIO"]	70.0000	140.0000	268	360	false	false	true
01a0c981-f606-7451-85b9-dcda3c2b5dc6	ORCL	2026-09-22 10:25	call_diagonal_spread	2	1	12	31548.00	unknown	bid	150.4056	0.5500	["140","150"]	["0.5141","0.4868"]	[]	["XISX"]	140.0000	150.0000	24	59	false	false	true
01a0c972-b7af-79f2-8f41-03da7a4da0d3	ORCL	2026-09-22 10:08	call_diagonal_spread	2	1	50	29300.00	long	ask	150.7150	0.1600	["155","160"]	["0.5959","0.4993"]	[]	["XISX"]	155.0000	160.0000	3	24	false	true	true
01a0c575-7a2f-70b3-8d0b-36677db9e9d4	ORCL	2026-09-21 15:33	call_diagonal_spread	2	3	114	32946.00	long	ask	148.4000	0.0500	["155","160"]	["0.5607","0.5304"]	[]	["XMIO"]	155.0000	160.0000	4	11	false	true	true
01a0c53c-2a4f-7b20-a129-c73f87309781	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	84	84000.00	short	bid	148.5650	0.1500	["175","190"]	["0.5317","0.5754"]	[]	["XPHO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-2a4f-7b20-a129-c70a36cd38ae	ORCL	2026-09-21 14:30	call_diagonal_spread	2	2	145	145000.00	short	bid	148.5650	0.1500	["175","190"]	["0.5317","0.5754"]	[]	["XCBO","XPHO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-2a4f-7b20-a129-c6f60ef130eb	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	65	65130.00	short	bid	148.5650	0.1500	["175","190"]	["0.5322","0.5758"]	[]	["ARCO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-2a4f-7b20-a129-c699ed2ed1a1	ORCL	2026-09-21 14:30	call_diagonal_spread	2	2	575	575000.00	short	bid	148.5650	0.1500	["175","190"]	["0.5317","0.5754"]	[]	["XCBO","XISX"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-0727-74f1-9fbb-26b3cf186f92	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	39	38922.00	short	bid	148.5400	0.3000	["175","190"]	["0.5310","0.5757"]	[]	["EDGO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-0727-74f1-9fbb-2692f8acc50c	ORCL	2026-09-21 14:30	call_diagonal_spread	2	2	58	57948.00	short	bid	148.5400	0.3000	["175","190"]	["0.5313","0.5759"]	[]	["AMXO","XMIO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-0727-74f1-9fbb-268ba8cb5e4a	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	26	26000.00	short	bid	148.5400	0.3000	["175","190"]	["0.5315","0.5761"]	[]	["XPHO"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-0727-74f1-9fbb-267015be437f	ORCL	2026-09-21 14:30	call_diagonal_spread	2	2	86	86486.00	unknown	ask	148.5400	0.3000	["175","190"]	["0.5329","0.5773"]	[]	["ARCO","XBOX"]	175.0000	190.0000	60	88	false	true
01a0c53c-0727-74f1-9fbb-266acf8e21cf	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	34	34000.00	short	bid	148.5400	0.3000	["175","190"]	["0.5315","0.5761"]	[]	["XISX"]	175.0000	190.0000	60	88	false	true	true
01a0c53c-033e-74f2-a85e-218fcefcc978	ORCL	2026-09-21 14:30	call_diagonal_spread	2	1	37	37037.00	unknown	ask	148.5100	0.3000	["175","190"]	["0.5314","0.5773"]	[]	["XMIO"]	175.0000	190.0000	60	88	false	true	true
01a0c437-c23e-7300-8031-08fac37291a0	ORCL	2026-09-21 09:46	call_diagonal_spread	2	2	16	39984.00	long	ask	147.6700	1.0000	["170","200"]	["0.5484","0.5689"]	[]	["XISX"]	170.0000	200.0000	88	269	false	true	true
01a0b616-1fdf-7ee3-857d-be9a23fb114d	ORCL	2026-09-18 15:54	call_diagonal_spread	2	3	23	35673.00	short	bid	147.7300	0.5000	["140","145"]	["0.4773","0.4549"]	[]	["BATO","C2OX","EDGO"]	140.0000	145.0000	7	14	false	false
01a0b616-1fdf-7ee3-857d-be80532de6ed	ORCL	2026-09-18 15:54	call_diagonal_spread	2	2	21	32655.00	short	bid	147.7300	0.5000	["140","145"]	["0.4794","0.4575"]	[]	["ARCO","EMLD"]	140.0000	145.0000	7	14	false	false	true
01a0b605-acef-70f3-899a-86cbe9294040	ORCL	2026-09-18 15:36	call_diagonal_spread	2	1	5	34500.00	unknown	bid	148.3646	0.7000	["120","125"]	["0.5251","0.5317"]	[]	["XISX"]	120.0000	125.0000	119	154	false	false	true
01a0b5dd-c617-7513-a911-d5b2d5a58a29	ORCL	2026-09-18 14:53	call_diagonal_spread	2	1	6	27684.00	unknown	bid	147.6051	1.1000	["170","175"]	["0.5450","0.5465"]	[]	["ARCO"]	170.0000	175.0000	272	364	false	true	true
01a0b551-d9c7-7af3-8da5-a47dcfcb2819	ORCL	2026-09-18 12:20	call_diagonal_spread	2	1	9	53280.00	short	bid	145.2950	0.8000	["100","150"]	["0.5466","0.4755"]	[]	["XMIO"]	100.0000	150.0000	21	272	false	false	true
01a0b525-95bf-73a2-b017-7a9e0e72d0d0	ORCL	2026-09-18 11:32	call_diagonal_spread	2	1	65	66105.00	long	ask	145.3900	0.3500	["143","146"]	["0.4552","0.4707"]	[]	["XMIO"]	143.0000	146.0000	7	14	false	false	true
01a0b51e-fa57-7ba1-841e-cbf3a0cbe63d	ORCL	2026-09-18 11:24	call_diagonal_spread	2	1	14	52850.00	long	ask	145.4850	0.6000	["145","150"]	["0.5339","0.5280"]	[]	["BATO"]	145.0000	150.0000	119	154	false	false	true
01a0b4fb-b317-7fc1-a0a5-6d9e456e44da	ORCL	2026-09-18 10:46	call_diagonal_spread	2	1	15	174990.00	unknown	ask	145.7900	0.7000	["75","100"]	["1.0099","7.0802"]	[]	["XMIO"]	75.0000	100.0000	0	28	false	false	true
01a0b4cd-4077-77f0-b01a-b0ff838d8344	ORCL	2026-09-18 09:55	call_diagonal_spread	2	2	14	32470.00	short	bid	146.0100	0.4000	["147","150"]	["0.4692","0.5511"]	[]	["BATO","XISX"]	147.0000	150.0000	35	91	false	true	true
01a0b4b7-a14f-7510-a594-70cad6807ec0	ORCL	2026-09-18 09:32	call_diagonal_spread	2	1	57	149967.00	long	bid	147.9500	3.0000	["135","137"]	["2.1713","0.5377"]	[]	["XPHO"]	135.0000	137.0000	0	14	false	false	true
01a0b0e3-73cb-76a1-bbef-d5532fe410a4	ORCL	2026-09-17 15:41	call_diagonal_spread	2	1	19	87438.00	unknown	—	150.2600	0.6500	["130","140"]	["0.5034","0.5559"]	[]	["XCBO"]	130.0000	140.0000	43	92	false	false	true	true	false
01a0b0d3-760b-7c51-b8d7-86c267a663ed	ORCL	2026-09-17 15:24	call_diagonal_spread	2	1	75	501000.00	unknown	—	149.2022	0.9500	["145","150"]	["0.5519","0.5526"]	[]	["XBOX"]	145.0000	150.0000	273	365	false	false	true	true	false
01a0b079-f3fa-7f23-b282-2f84459ade73	ORCL	2026-09-17 13:46	call_diagonal_spread	2	1	7	48013.00	short	bid	149.6100	0.9000	["170","220"]	["0.5471","0.5551"]	[]	["XCBO"]	170.0000	220.0000	491	820	false	true	true
01a0b063-08cb-7530-b54a-048e8f07d01a	ORCL	2026-09-17 13:21	call_diagonal_spread	2	1	50	42700.00	unknown	—	149.6800	0.5000	["147","155"]	["0.6041","0.4853"]	[]	["XPHO"]	147.0000	155.0000	1	22	false	false	true	true	false
01a0b046-ed7b-7691-93ca-9d06c6c9471d	ORCL	2026-09-17 12:50	call_diagonal_spread	2	1	32	32320.00	unknown	—	150.6750	0.3000	["150","152.5"]	["0.4942","0.4946"]	[]	["XPHO"]	150.0000	152.5000	8	15	false	false	true	true	false
01a0b010-2223-7e92-8dd1-7f4ab101fd45	ORCL	2026-09-17 11:50	call_diagonal_spread	2	5	13	33525.00	unknown	—	151.5750	0.5731	["140","150"]	["0.7737","0.5088"]	[]	["AMXO","XBOX","XISX","XMIO","XPHO"]	140.0000	150.0000	1	64	false	false	true	true
01a0b010-2223-7e92-8dd1-7f349f0214fd	ORCL	2026-09-17 11:50	call_diagonal_spread	2	6	38	98144.00	long	ask	151.5750	0.5868	["140","150"]	["0.8185","0.5096"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	140.0000	150.0000	1	64	false	false
01a0afef-28bb-7001-a58f-967d5821e1d6	ORCL	2026-09-17 11:14	call_diagonal_spread	2	7	36	33072.00	long	ask	150.4801	0.4500	["200","300"]	["0.5729","0.5837"]	[]	["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"]	200.0000	300.0000	92	273	false	true
01a0afe4-999b-73a2-a336-b57489ec9f83	ORCL	2026-09-17 11:03	call_diagonal_spread	2	1	45	32535.00	unknown	—	150.5500	0.1700	["150","160"]	["0.6580","0.4947"]	[]	["XISX"]	150.0000	160.0000	1	29	false	false	true	true	false
01a0afdc-546c-7df1-af14-e1a60243a868	ORCL	2026-09-17 10:54	call_diagonal_spread	2	1	80	90800.00	short	bid	150.7300	0.3500	["150","152.5"]	["0.4909","0.6938"]	[]	["XMIO"]	150.0000	152.5000	1	36	false	false	true
01a0afcf-832b-7862-926a-4751cb3a499b	ORCL	2026-09-17 10:40	call_diagonal_spread	2	1	19	84626.00	unknown	—	150.6000	0.6000	["130","140"]	["0.5604","0.5640"]	[]	["XCBO"]	130.0000	140.0000	15	92	false	false	true	true	false
01a0afcd-a2b3-7953-a2fb-dc588132b438	ORCL	2026-09-17 10:38	call_diagonal_spread	2	1	162	190026.00	long	ask	150.6000	0.3500	["144","149"]	["0.5205","0.6927"]	[]	["XCBO"]	144.0000	149.0000	1	8	false	false	true
01a0afcd-96fb-7e60-9841-f4e43954a39e	ORCL	2026-09-17 10:37	call_diagonal_spread	2	1	38	44460.00	unknown	—	150.5850	0.3500	["144","149"]	["0.5207","0.6892"]	[]	["C2OX"]	144.0000	149.0000	1	8	false	false	true	true	false
01a0afc6-7e93-74d3-ab20-2a1f51d4fd8a	ORCL	2026-09-17 10:30	call_diagonal_spread	2	1	20	26620.00	short	bid	150.5300	0.4500	["145","160"]	["0.7290","0.5239"]	[]	["C2OX"]	145.0000	160.0000	1	43	false	false	true
01a0afc6-7e93-74d3-ab20-2a088b207a8a	ORCL	2026-09-17 10:30	call_diagonal_spread	2	1	20	26700.00	unknown	—	150.5450	0.7000	["145","160"]	["0.7328","0.5246"]	[]	["C2OX"]	145.0000	160.0000	1	43	false	false	true	true	false
01a0afc6-7e93-74d3-ab20-29f0c31b4e0b	ORCL	2026-09-17 10:30	call_diagonal_spread	2	1	20	26900.00	long	ask	150.5450	0.7000	["145","160"]	["0.7587","0.5271"]	[]	["C2OX"]	145.0000	160.0000	1	43	false	false	true
01a0afc6-7e93-74d3-ab20-29ecb0a60250	ORCL	2026-09-17 10:30	call_diagonal_spread	2	1	20	26880.00	long	ask	150.5450	0.7000	["145","160"]	["0.7536","0.5271"]	[]	["XISX"]	145.0000	160.0000	1	43	false	false	true
01a0afc6-7aab-72b2-a8ea-cac4cb756cd8	ORCL	2026-09-17 10:30	call_diagonal_spread	2	1	20	26900.00	long	ask	150.5450	0.7000	["145","160"]	["0.7587","0.5271"]	[]	["XISX"]	145.0000	160.0000	1	43	false	false	true