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:net_side = bid×strategy = call_diagonal_spread×ticker = ORCL×

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

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	true	false	mlat	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T19:04:45Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
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
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
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-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
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	true
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
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
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
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
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
01a0ab9e-50e3-72f2-a5aa-1f367e567ab3	ORCL	2026-09-16 15:07	call_diagonal_spread	2	1	10	121610.00	short	bid	143.1950	2.7500	["100","115"]	["0.5414","0.5429"]	[]	["XCBO"]	100.0000	115.0000	492	821	false	false	true
01a0aae7-a72b-7a00-99a0-0b287a4c8a95	ORCL	2026-09-16 11:48	call_diagonal_spread	2	1	10	25340.00	long	bid	143.9200	1.2000	["210","300"]	["0.5582","0.5744"]	[]	["XISX"]	210.0000	300.0000	366	457	false	true	true
01a0a64b-6d9e-7db3-b3ca-3962ab87de5e	ORCL	2026-09-15 14:19	call_diagonal_spread	2	1	10	29140.00	short	bid	141.7550	0.3700	["148","240"]	["0.6259","0.5639"]	[]	["XMIO"]	148.0000	240.0000	3	822	false	true	true
01a0a5fe-4f6e-7500-85a4-d6d02e32cf5a	ORCL	2026-09-15 12:54	call_diagonal_spread	2	1	20	168180.00	short	bid	143.1800	1.6500	["150","155"]	["0.5489","0.5538"]	[]	["XCBO"]	150.0000	155.0000	493	822	false	true	true
01a0a575-2626-7c63-98e5-091a3e60cac8	ORCL	2026-09-15 10:25	call_diagonal_spread	2	1	5	25005.00	short	bid	142.1350	1.5000	["125","130"]	["0.5333","0.5459"]	[]	["XMIO"]	125.0000	130.0000	94	122	false	false	true
01a0a158-5380-74c2-b34d-82ddb883e0f8	ORCL	2026-09-14 15:15	call_diagonal_spread	2	1	50	172686.00	short	bid	143.4899	0.7000	["140","150"]	["0.5438","0.5571"]	[]	["XCBO"]	140.0000	150.0000	95	123	false	false	true
01a0a157-a7a0-72e3-a9e8-663a37d49dc2	ORCL	2026-09-14 15:14	call_diagonal_spread	2	1	10	28010.00	short	bid	143.6100	0.5000	["160","190"]	["0.5463","0.5682"]	[]	["XISX"]	160.0000	190.0000	123	276	false	true	true
01a0a156-e838-7731-a3af-f56b72da8312	ORCL	2026-09-14 15:13	call_diagonal_spread	2	1	10	29730.00	short	bid	143.5300	0.5500	["155","190"]	["0.5474","0.5697"]	[]	["XISX"]	155.0000	190.0000	123	276	false	true	true
01a0a119-0861-7173-b480-aef6cac14b44	ORCL	2026-09-14 14:06	call_diagonal_spread	2	1	20	91180.00	long	bid	144.1600	1.6500	["145","165"]	["0.5504","0.5722"]	[]	["MCRY"]	145.0000	165.0000	186	276	false	true	true
01a0a100-6f80-7080-adff-3fb13b534138	ORCL	2026-09-14 13:39	call_diagonal_spread	2	1	65	34710.00	short	bid	143.8570	0.2800	["230","290"]	["0.5799","0.6898"]	[]	["XISX"]	230.0000	290.0000	67	186	false	true	true
01a0a041-9fd8-7261-a4f0-d44afc6e24bf	ORCL	2026-09-14 10:10	call_diagonal_spread	2	1	10	77180.00	short	bid	144.3694	4.9500	["140","150"]	["0.5582","0.5615"]	[]	["XMIO"]	140.0000	150.0000	459	494	false	false	true
01a09160-8ec1-7231-959a-fcf4c00f69bd	ORCL	2026-09-11 12:50	call_diagonal_spread	2	1	30	39240.00	short	bid	151.1000	0.7500	["145","150"]	["1.6141","0.5198"]	[]	["EMLD"]	145.0000	150.0000	0	14	false	false	true
01a0913d-2840-7ed3-b356-8c2b091eef38	ORCL	2026-09-11 12:11	call_diagonal_spread	2	2	9	33975.00	short	bid	151.9850	1.2500	["134","135"]	["2.4591","0.4782"]	[]	["XISX"]	134.0000	135.0000	0	35	false	false	true
01a09117-dd60-7783-b576-3c2d09935aca	ORCL	2026-09-11 11:30	call_diagonal_spread	2	2	10	50250.00	short	bid	153.4600	2.3500	["240","370"]	["0.5696","0.5825"]	[]	["XCBO"]	240.0000	370.0000	735	826	false	true	true
01a090ef-8158-7d90-954f-2ad6c1d0ca8d	ORCL	2026-09-11 10:46	call_diagonal_spread	2	1	5	31380.00	short	bid	154.0600	3.3500	["123","125"]	["4.8867","0.4729"]	[]	["BATO"]	123.0000	125.0000	0	70	false	false	true
01a090ef-8158-7d90-954f-2ac4c6d9b19e	ORCL	2026-09-11 10:46	call_diagonal_spread	2	1	5	31290.00	short	bid	154.0600	4.1500	["123","125"]	["5.4396","0.4663"]	[]	["EMLD"]	123.0000	125.0000	0	70	false	false	true
01a090d0-5cb0-7031-a047-246ce312cf51	ORCL	2026-09-11 10:12	call_diagonal_spread	2	1	20	46660.00	short	bid	156.3250	1.3000	["140","150"]	["0.5501","1.2212"]	[]	["BATO"]	140.0000	150.0000	0	7	false	false	true
01a090c2-bc69-7e31-b0dd-a903ddeb7731	ORCL	2026-09-11 09:57	call_diagonal_spread	2	2	18	164430.00	long	bid	156.2950	3.1000	["120","130"]	["0.5517","0.5630"]	[]	["XCBO"]	120.0000	130.0000	189	279	false	false	true
01a08cd6-1cd0-7d11-b9b9-d7c62abd00d7	ORCL	2026-09-10 15:40	call_diagonal_spread	2	1	26	128254.00	long	bid	154.2950	1.5500	["130","200"]	["2.3165","0.5884"]	[]	["XCBO"]	130.0000	200.0000	1	372	false	false	true
01a08cd6-1cd0-7d11-b9b9-d7b217a957fd	ORCL	2026-09-10 15:40	call_diagonal_spread	2	1	6	29568.00	long	bid	154.2950	1.6000	["130","200"]	["2.2901","0.5881"]	[]	["BATO"]	130.0000	200.0000	1	372	false	false	true
01a08cd6-1cd0-7d11-b9b9-d7964257fdc7	ORCL	2026-09-10 15:40	call_diagonal_spread	2	1	7	34468.00	long	bid	154.2950	1.7000	["130","200"]	["2.2711","0.5877"]	[]	["BATO"]	130.0000	200.0000	1	372	false	false	true
01a08cbe-37a0-7062-aa43-fde980a41da7	ORCL	2026-09-10 15:14	call_diagonal_spread	2	1	5	31240.00	short	bid	154.7700	2.9500	["130","135"]	["0.6314","0.6182"]	[]	["XCBO"]	130.0000	135.0000	71	99	false	false	true
01a08ca5-44e8-7ac1-85d5-33fae6c790e0	ORCL	2026-09-10 14:47	call_diagonal_spread	2	1	66	32340.00	short	bid	155.1000	0.1900	["210","230"]	["0.7187","0.6704"]	[]	["BATO"]	210.0000	230.0000	43	71	false	true	true
01a08c8a-5660-7423-b51d-3a69316ffea0	ORCL	2026-09-10 14:17	call_diagonal_spread	2	1	15	150930.00	short	bid	155.5250	1.8500	["125","145"]	["0.5721","0.5808"]	[]	["XMIO"]	125.0000	145.0000	372	498	false	false	true
01a08c88-3768-75e1-88ca-444d70ccf995	ORCL	2026-09-10 14:15	call_diagonal_spread	2	1	65	238875.00	short	bid	155.5500	0.6000	["140","141"]	["2.6329","1.0886"]	[]	["SPHR"]	140.0000	141.0000	1	8	false	false	true
01a08c14-3fe8-7ea1-acaa-b809cc423414	ORCL	2026-09-10 12:08	call_diagonal_spread	2	1	8	25200.00	long	bid	157.8250	0.8500	["145","152.5"]	["2.5856","0.7044"]	[]	["BATO"]	145.0000	152.5000	1	29	false	false	true
01a08be3-3920-7752-8681-5d8234e21a43	ORCL	2026-09-10 11:15	call_diagonal_spread	2	1	25	45175.00	short	bid	158.7900	0.8000	["170","195"]	["0.7855","0.6450"]	[]	["BATO"]	170.0000	195.0000	22	99	false	true	true