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:direction = long×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
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
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
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
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
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
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	true
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	true
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
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
01a0ab84-9adb-7b61-9719-964ab87d2628	ORCL	2026-09-16 14:39	call_diagonal_spread	2	1	18	144072.00	long	ask	143.5700	1.6000	["125","145"]	["0.5422","0.5477"]	[]	["XCBO"]	125.0000	145.0000	366	492	false	false	true
01a0ab77-73ab-7363-8ce9-0b1d9d6df821	ORCL	2026-09-16 14:25	call_diagonal_spread	2	1	13	118638.00	long	ask	144.4850	1.7500	["155","160"]	["0.5496","0.5501"]	[]	["XPHO"]	155.0000	160.0000	730	821	false	true	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
01a0a6a6-fb1e-7a00-8185-7a51ec0cc2d2	ORCL	2026-09-15 15:59	call_diagonal_spread	2	1	624	290784.00	long	ask	140.2600	0.1100	["150","155"]	["0.4913","0.6776"]	[]	["EDGO"]	150.0000	155.0000	3	31	false	true	true
01a0a6a4-e3f5-7a63-8f97-6694e602d550	ORCL	2026-09-15 15:56	call_diagonal_spread	2	1	625	291875.00	long	ask	140.3450	0.1100	["150","155"]	["0.4900","0.6743"]	[]	["EDGO"]	150.0000	155.0000	3	31	false	true	true
01a0a68c-7dde-7490-bb35-28679a756d14	ORCL	2026-09-15 15:30	call_diagonal_spread	2	1	50	37150.00	long	ask	140.1518	0.5000	["300","350"]	["0.5889","0.5907"]	[]	["XMIO"]	300.0000	350.0000	275	367	false	true	true
01a0a142-4ae1-7170-b874-195cbfcfa8d1	ORCL	2026-09-14 14:51	call_diagonal_spread	2	1	10	30260.00	long	ask	143.7150	0.6800	["125","150"]	["0.5454","0.6194"]	[]	["XISX"]	125.0000	150.0000	4	123	false	false	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
01a0a088-2e58-7122-9c15-1ad0fae332ce	ORCL	2026-09-14 11:27	call_diagonal_spread	2	1	80	126000.00	long	ask	144.1000	0.6000	["150","200"]	["0.4953","0.5700"]	[]	["XMIO"]	150.0000	200.0000	39	186	false	true	true
01a0a074-2d40-7db1-84f8-0be03d5ee555	ORCL	2026-09-14 11:06	call_diagonal_spread	2	1	10	32190.00	long	ask	143.6150	1.2900	["150","240"]	["0.5358","0.5784"]	[]	["SPHR"]	150.0000	240.0000	11	823	false	true	true
01a0a04c-dec1-78a2-ac48-f6ce435511a2	ORCL	2026-09-14 10:23	call_diagonal_spread	2	1	15	102855.00	long	ask	142.7400	2.2500	["145","150"]	["0.5689","0.5669"]	[]	["XMIO"]	145.0000	150.0000	368	459	false	true	true
01a0a043-edb0-7a32-8ce5-f95b58032e14	ORCL	2026-09-14 10:13	call_diagonal_spread	2	1	18	130086.00	long	ask	143.2050	2.7500	["120","140"]	["0.5613","0.5632"]	[]	["XMIO"]	120.0000	140.0000	186	396	false	false	true
01a091f3-87c0-7b80-9437-e927ce13b4cb	ORCL	2026-09-11 15:30	call_diagonal_spread	2	1	10	79990.00	long	ask	151.4650	0.9600	["75","155"]	["0.5321","1.4561"]	[]	["XCBO"]	75.0000	155.0000	0	279	false	false	true
01a091cf-4298-7952-aab8-116f6143f948	ORCL	2026-09-11 14:51	call_diagonal_spread	2	1	7	29533.00	long	ask	151.2750	0.7500	["150","155"]	["0.5525","0.5539"]	[]	["XCBO"]	150.0000	155.0000	98	189	false	false	true
01a091af-2bc0-7930-bb01-e70d5b804404	ORCL	2026-09-11 14:16	call_diagonal_spread	2	1	5	28820.00	long	ask	152.1507	2.1000	["120","145"]	["0.5463","0.4887"]	[]	["AMXO"]	120.0000	145.0000	49	189	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
01a08ce6-0708-7313-8944-71d1dd2d2066	ORCL	2026-09-10 15:57	call_diagonal_spread	2	1	3	45072.00	long	ask	153.3200	5.1500	["80","90"]	["0.7315","0.5793"]	[]	["XISX"]	80.0000	90.0000	99	463	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
01a08c68-7298-77b1-95e7-5393ec5d26a6	ORCL	2026-09-10 13:40	call_diagonal_spread	2	1	5	27885.00	long	ask	155.8950	1.2500	["160","190"]	["0.6028","0.5863"]	[]	["BATO"]	160.0000	190.0000	190	400	false	true	true
01a08c2a-3118-7e41-8a4a-abeeb3b50e83	ORCL	2026-09-10 12:32	call_diagonal_spread	2	1	10	30400.00	long	ask	156.4400	0.4500	["140","160"]	["0.6648","2.8743"]	[]	["BATO"]	140.0000	160.0000	1	36	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
01a0879a-b230-7472-b2d8-16a9b7f802f5	ORCL	2026-09-09 15:17	call_diagonal_spread	2	5	15	53445.00	long	ask	163.4350	0.2500	["140","162.5"]	["1.0013","1.9880"]	[]	["ARCO","EMLD","SPHR","XBOX","XPHO"]	140.0000	162.5000	2	9	false	false	true
01a08755-fc58-7340-be32-2b59363e6ea9	ORCL	2026-09-09 14:02	call_diagonal_spread	2	1	2	25220.00	long	ask	164.2820	3.7000	["150","155"]	["0.5864","0.5866"]	[]	["XMIO"]	150.0000	155.0000	737	828	false	false	true
01a08739-b610-7450-b608-dd596d810a1d	ORCL	2026-09-09 13:31	call_diagonal_spread	2	1	9	33804.00	long	ask	163.2699	0.7500	["150","170"]	["1.0292","0.6311"]	[]	["XPHO"]	150.0000	170.0000	9	100	false	false	true
01a086b2-ea40-7d23-a6b2-0b4182ab9173	ORCL	2026-09-09 11:04	call_diagonal_spread	2	2	26	291564.00	long	ask	162.0500	2.3000	["110","120"]	["0.6324","0.5904"]	[]	["ARCO"]	110.0000	120.0000	100	281	false	false	true
01a08699-3c08-7ff3-a479-1ddc3febc45e	ORCL	2026-09-09 10:36	call_diagonal_spread	2	4	19	58657.00	long	bid	161.7550	0.2500	["145","170"]	["0.9899","0.6722"]	[]	["AMXO","XBOX","XISX","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3820-74e3-a4c4-ec5eb61ab850	ORCL	2026-09-09 10:36	call_diagonal_spread	2	4	31	95635.00	long	bid	161.7550	0.2500	["145","170"]	["0.9884","0.6717"]	[]	["AMXO","XBOX","XISX","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3820-74e3-a4c4-ec476b989ed7	ORCL	2026-09-09 10:36	call_diagonal_spread	2	4	33	102125.00	long	bid	161.7550	0.3000	["145","170"]	["0.9950","0.6740"]	[]	["AMXO","XBOX","XISX","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3820-74e3-a4c4-ec36e30a5bcf	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145205.00	long	bid	161.7550	0.2500	["145","170"]	["0.9915","0.6728"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3438-7961-a0fa-cd05193100ce	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145205.00	long	bid	161.7550	0.2500	["145","170"]	["0.9915","0.6728"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3438-7961-a0fa-ccf60e3de8d3	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145205.00	long	bid	161.7550	0.2500	["145","170"]	["0.9915","0.6728"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3438-7961-a0fa-ccedd86ca128	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145205.00	long	bid	161.7550	0.2500	["145","170"]	["0.9915","0.6728"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3438-7961-a0fa-ccdfe29f4411	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145205.00	long	bid	161.7700	0.2500	["145","170"]	["0.9899","0.6724"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true
01a08699-3050-72c3-91e6-f6de39b87854	ORCL	2026-09-09 10:36	call_diagonal_spread	2	6	47	145281.00	long	bid	161.7700	0.2500	["145","170"]	["0.9910","0.6728"]	[]	["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"]	145.0000	170.0000	9	37	false	false	true