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:strategy = risk_reversal×ticker = ORCL×

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

01a0ca54-845e-7c83-9fba-84d24e800376	ORCL	2026-09-22 14:15	risk_reversal	2	1	18	26262.00	long	ask	149.7900	0.4000	["130","180"]	["0.5715","0.5754"]	["180.35"]	["C2OX"]	130.0000	180.0000	87	87	false	true	false	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-22T18:15:42Z"}	2026-09-22	2026-09-22 17:15	2026-09-22 17:15
01a0c9b4-6bfe-7390-9d5b-cc2566d3b62e	ORCL	2026-09-22 11:20	risk_reversal	2	2	11	46506.00	long	bid	149.2850	0.4000	["150","160"]	["0.5686","0.5588"]	["148"]	["ARCO","XBOX"]	150.0000	160.0000	178	178	false	false	false	true
01a0c43a-13fe-7eb1-b92e-3b7d366423dd	ORCL	2026-09-21 09:48	risk_reversal	2	3	5	34864.00	short	bid	147.9050	1.2600	["140","145"]	["0.5739","0.5429"]	["157.60"]	["ARCO","EMLD","SPHR"]	140.0000	145.0000	487	487	false	false	false	true
01a0b614-2bdf-7b63-bbf5-222edb8f6470	ORCL	2026-09-18 15:52	risk_reversal	3	3	65	35134.00	short	ask	147.7200	0.1300	["140","148","160"]	["0.4559","0.4579","0.4851"]	["145.76"]	["EDGO","XCBO","XPHO"]	140.0000	160.0000	7	7	false	false	false	true
01a0b524-ca9f-7642-b68c-f8f0e92147f9	ORCL	2026-09-18 11:31	risk_reversal	2	2	10	26050.00	long	bid	145.5600	0.4000	["145","160"]	["0.5576","0.5532"]	["141.09"]	["ARCO","XBOX"]	145.0000	160.0000	91	91	false	true	false	true
01a0b4ce-944f-7700-aaec-aeacc16df43f	ORCL	2026-09-18 09:57	risk_reversal	2	1	5	25790.00	long	bid	146.0650	1.7000	["140","210"]	["0.5755","0.5557"]	["132.80"]	["XCBO"]	140.0000	210.0000	490	490	false	true	false	true
01a0af95-be1b-7131-bba7-ebded9ade8f9	ORCL	2026-09-17 09:36	risk_reversal	2	1	25	33425.00	long	bid	148.6201	0.6500	["130","190"]	["0.5690","0.5769"]	["127.97"]	["EMLD"]	130.0000	190.0000	92	92	false	true	false	true
01a0a6a7-9f2e-71e1-b631-d7b36b688fdf	ORCL	2026-09-15 15:59	risk_reversal	2	1	4	26348.00	short	bid	140.3000	1.7000	["140","150"]	["0.5763","0.5422"]	["153.09"]	["XCBO"]	140.0000	150.0000	493	493	false	true	false	true
01a0a6a7-9b46-7e33-ad52-7fbde5697c1d	ORCL	2026-09-15 15:59	risk_reversal	2	4	6	39408.00	short	bid	140.2900	1.9083	["140","150"]	["0.5771","0.5384"]	["152.80"]	["ARCO","EMLD","SPHR","XBOX"]	140.0000	150.0000	493	493	false	true	false	true
01a0a680-be0e-7a00-88c9-8e760205a793	ORCL	2026-09-15 15:17	risk_reversal	2	1	4	27228.00	short	bid	141.0400	0.8000	["140","145"]	["0.5780","0.5432"]	["150.57"]	["XCBO"]	140.0000	145.0000	493	493	false	true	false	true
01a0a680-be0e-7a00-88c9-8e63874051a4	ORCL	2026-09-15 15:17	risk_reversal	2	4	6	40850.00	short	bid	141.0400	0.8500	["140","145"]	["0.5787","0.5427"]	["150.50"]	["ARCO","EMLD","SPHR","XBOX"]	140.0000	145.0000	493	493	false	true	false	true
01a0a0d6-90c1-7ab1-bc45-03f4575ad361	ORCL	2026-09-14 12:53	risk_reversal	2	3	19	36195.00	short	ask	144.0800	0.1132	["140","155"]	["0.5229","0.5171"]	["138.60"]	["XBOX","XCBO","XISX"]	140.0000	155.0000	67	67	false	true	false	true
01a0a06c-d658-70f1-8447-bfb2f2fa3cc4	ORCL	2026-09-14 10:58	risk_reversal	2	2	29	54810.00	short	ask	143.9800	0.1000	["145","165"]	["0.5282","0.5202"]	["138.02"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false	false	true
01a0a06c-caa0-7ba2-8749-5f948d11f296	ORCL	2026-09-14 10:57	risk_reversal	2	2	24	45360.00	long	bid	143.9450	0.1000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false	false	true
01a0a06c-c6b9-7422-9115-23771f298043	ORCL	2026-09-14 10:57	risk_reversal	2	2	24	45360.00	long	bid	143.9450	0.1000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false	false	true
01a0a06c-c6b9-7422-9115-236e615d00db	ORCL	2026-09-14 10:57	risk_reversal	2	2	29	54810.00	long	bid	143.9450	0.2207	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false	false	true
01a0a06c-c6b9-7422-9115-235f8754e7f9	ORCL	2026-09-14 10:57	risk_reversal	2	2	29	54810.00	long	bid	143.9450	0.2000	["145","165"]	["0.5260","0.5224"]	["138.10"]	["XISX","XPHO"]	145.0000	165.0000	67	67	false	false	false	true
01a0a031-9279-7d80-9ad5-65b47ae995ae	ORCL	2026-09-14 09:53	risk_reversal	3	5	42	25660.00	short	ask	144.5600	0.3100	["137","145","155"]	["0.6295","0.6425","0.6875"]	["142.96"]	["BATO","C2OX","EDGO","XCBO","XISX"]	137.0000	155.0000	4	4	false	false	false	true
01a0a031-9279-7d80-9ad5-659ecd3e1b9b	ORCL	2026-09-14 09:53	risk_reversal	3	5	55	33390.00	short	ask	144.5600	0.2900	["137","145","155"]	["0.6244","0.6393","0.6881"]	["142.96"]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	137.0000	155.0000	4	4	false	false	false	true
01a0a031-8aa8-7dc2-81f2-17cd56532878	ORCL	2026-09-14 09:53	risk_reversal	3	3	168	101116.00	short	ask	144.7234	0.2900	["137","145","155"]	["0.6314","0.6451","0.6798"]	["143.0"]	["XCBO","XMIO","XPHO"]	137.0000	155.0000	4	4	false	false	false	true
01a0a031-8aa8-7dc2-81f2-17a89e00de15	ORCL	2026-09-14 09:53	risk_reversal	3	6	60	36298.00	short	ask	144.7234	0.2900	["137","145","155"]	["0.6345","0.6469","0.6817"]	["143.01"]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	137.0000	155.0000	4	4	false	false	false	true
01a0a031-82d8-7410-a8d3-917ebfa338a6	ORCL	2026-09-14 09:53	risk_reversal	3	5	64	38742.00	short	ask	144.6350	0.3134	["137","145","155"]	["0.6323","0.6382","0.6867"]	["143.03"]	["C2OX","EDGO","MCRY","XCBO","XPHO"]	137.0000	155.0000	4	4	false	false	false	true
01a0a022-2928-72f1-a93c-4b8c217d922c	ORCL	2026-09-14 09:36	risk_reversal	2	4	5	36892.00	long	bid	142.5700	4.2500	["150","240"]	["0.5761","0.5794"]	["134"]	["BATO","C2OX","EDGO","XBOX"]	150.0000	240.0000	823	823	false	false	false	true
01a091e4-9b70-7bd3-82c1-d3379baf8690	ORCL	2026-09-11 15:14	risk_reversal	2	9	37	29970.00	long	bid	151.3000	0.4000	["120","210"]	["0.5523","0.5762"]	["119.63"]	["AMXO","ARCO","EDGO","EMLD","SPHR","XBOX","XISX","XMIO"]	120.0000	210.0000	98	98	false	true	false	true
01a09105-0141-7983-b798-d769d1300bdd	ORCL	2026-09-11 11:10	risk_reversal	2	1	10	46990.00	unknown	—	152.8450	1.5000	["140","250"]	["0.5767","0.5708"]	[]	["XCBO"]	140.0000	250.0000	497	497	false	true	false	true	true	mlat
01a090eb-1871-7c40-be8c-3a982ef7e185	ORCL	2026-09-11 10:41	risk_reversal	2	1	25	36000.00	short	bid	153.6000	0.7500	["130","190"]	["0.5727","0.5721"]	["190.30"]	["EMLD"]	130.0000	190.0000	98	98	false	true	false	true
01a090e3-11c0-7033-8c2c-50cd7ad974d9	ORCL	2026-09-11 10:33	risk_reversal	3	2	25	62760.00	long	bid	153.3800	0.8500	["160","170"]	["0.5241","0.5230"]	["149.30"]	["MCRY","XBOX"]	160.0000	170.0000	35	35	false	false	false	true
01a090e2-b7e8-7263-9561-5e4baaabeebd	ORCL	2026-09-11 10:32	risk_reversal	2	2	9	29853.00	long	bid	153.6250	1.7278	["155","175"]	["0.5618","0.5690"]	["148.73"]	["ARCO","XBOX"]	155.0000	175.0000	126	126	false	false	false	true
01a090df-3191-7143-a426-09369ce01c2a	ORCL	2026-09-11 10:28	risk_reversal	2	1	10	27710.00	long	bid	153.8650	0.4500	["150","170"]	["0.5648","0.5738"]	["147.61"]	["XBOX"]	150.0000	170.0000	98	98	false	true	false	true
01a08cc3-19a0-7d92-b093-136838d644a4	ORCL	2026-09-10 15:19	risk_reversal	2	1	35	34304.00	unknown	—	154.8200	0.2500	["150","175"]	["2.7867","2.9745"]	[]	["XISX"]	150.0000	175.0000	1	1	false	true	false	true	true	mlet
01a08ca1-c279-7471-b76c-d5d91af2b685	ORCL	2026-09-10 14:43	risk_reversal	2	2	92	122544.00	unknown	—	155.2000	0.4500	["100","300"]	["0.5958","0.6240"]	[]	["EDGO"]	100.0000	300.0000	280	280	false	true	false	true	true	mlet
01a08c8d-a221-7bb1-8684-6c270aa9f77b	ORCL	2026-09-10 14:21	risk_reversal	2	1	41	54407.00	unknown	—	155.5750	0.3000	["100","300"]	["0.5945","0.6229"]	[]	["XISX"]	100.0000	300.0000	280	280	false	true	false	true	true	mlet
01a08c22-0740-71e2-87bc-2eee58af438e	ORCL	2026-09-10 12:23	risk_reversal	2	1	60	80940.00	short	bid	155.9500	0.2000	["100","300"]	["0.5976","0.6258"]	["301.07"]	["EDGO"]	100.0000	300.0000	280	280	false	true	false	true
01a08c1d-b9b1-7213-bd7a-31a9f95b3622	ORCL	2026-09-10 12:19	risk_reversal	2	1	184	246560.00	short	bid	155.8100	0.2500	["100","300"]	["0.5963","0.6246"]	["301.02"]	["EDGO"]	100.0000	300.0000	280	280	false	true	false	true
01a08bfb-2a08-7150-806b-ce5543ef46f3	ORCL	2026-09-10 11:41	risk_reversal	2	1	20	29980.00	short	ask	158.6400	0.2500	["160","180"]	["1.1149","1.1554"]	["152.79"]	["C2OX"]	160.0000	180.0000	8	8	false	false	false	true
01a087b6-f490-7071-b136-49abb753f0ca	ORCL	2026-09-09 15:48	risk_reversal	2	1	200	950000.00	short	ask	161.8500	0.7500	["175","180"]	["0.6193","0.6127"]	["162.10"]	["XPHO"]	175.0000	180.0000	128	128	false	false	false	true
01a08776-f5c1-7260-9fc2-5c4d260f6507	ORCL	2026-09-09 14:38	risk_reversal	2	1	10	50990.00	short	ask	162.9100	1.7500	["140","250"]	["0.5856","0.5956"]	["138.03"]	["XCBO"]	140.0000	250.0000	499	499	false	true	false	true
01a08731-d288-7471-875e-4988defc0c45	ORCL	2026-09-09 13:23	risk_reversal	3	5	16	28440.00	short	ask	163.1100	0.8500	["115","140","240"]	["0.6311","0.6301","0.6656"]	["138.20"]	["AMXO","XMIO"]	115.0000	240.0000	100	100	false	true	false	true
01a08731-d288-7471-875e-49435220d3b0	ORCL	2026-09-09 13:23	risk_reversal	3	6	17	30246.00	short	ask	163.0750	0.8500	["115","140","240"]	["0.6314","0.6301","0.6659"]	["138.2"]	["ARCO","EMLD","SPHR","XISX","XMIO"]	115.0000	240.0000	100	100	false	true	false	true
01a0818d-6518-7410-9fe3-cb379d8ba10b	ORCL	2026-09-08 11:05	risk_reversal	3	1	10	73780.00	long	ask	163.8900	1.7500	["120","160","260"]	["0.5995","0.5835","0.5973"]	["171.20"]	["XMIO"]	120.0000	260.0000	374	374	false	false	false	true
01a08145-09a9-7cb2-ae43-10ca8be254b3	ORCL	2026-09-08 09:46	risk_reversal	3	6	75	115761.00	short	ask	166.2700	0.4800	["152.5","165","190"]	["1.5349","1.6023","1.6925"]	["162.55"]	["AMXO","ARCO","BATO","EDGO","XCBO","XISX"]	152.5000	190.0000	3	3	false	true	false	true
01a08145-05c1-7d62-aaa9-a46cc34d393b	ORCL	2026-09-08 09:46	risk_reversal	3	5	106	164212.00	short	ask	166.1900	0.5800	["152.5","165","190"]	["1.5392","1.6018","1.6926"]	["162.54"]	["AMXO","EMLD","XBOX","XMIO","XPHO"]	152.5000	190.0000	3	3	false	true	false	true
01a08145-05c1-7d62-aaa9-a4463c0c452b	ORCL	2026-09-08 09:46	risk_reversal	3	6	119	184321.00	short	ask	166.1900	0.5800	["152.5","165","190"]	["1.5367","1.6025","1.6939"]	["162.53"]	["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"]	152.5000	190.0000	3	3	false	true	false	true
01a08142-a460-7d03-9ed2-bef5d2c89847	ORCL	2026-09-08 09:43	risk_reversal	3	7	29	51264.00	short	ask	167.0700	0.8500	["150","165","190"]	["0.9770","0.9979","1.0337"]	["163.00"]	["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"]	150.0000	190.0000	10	10	false	true	false	true
01a06d78-2d26-7ff1-a34d-2c4d60eaff7c	ORCL	2026-09-04 13:29	risk_reversal	3	2	15	38970.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6014","0.6093","0.6828"]	["144.74"]	["EMLD","XMIO"]	135.0000	300.0000	105	105	false	true	false	true
01a06d78-2d26-7ff1-a34d-2c3a1011e0a7	ORCL	2026-09-04 13:29	risk_reversal	3	5	15	38994.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6010","0.6093","0.6854"]	["144.75"]	["BATO","C2OX","EDGO","XCBO","XISX"]	135.0000	300.0000	105	105	false	true	false	true
01a06d78-2d26-7ff1-a34d-2c1f567cabd7	ORCL	2026-09-04 13:29	risk_reversal	3	4	23	59784.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6015","0.6090","0.6846"]	["144.77"]	["AMXO","ARCO","XBOX","XISX"]	135.0000	300.0000	105	105	false	true	false	true
01a06d78-2d26-7ff1-a34d-2c0e71945989	ORCL	2026-09-04 13:29	risk_reversal	3	1	14	36344.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6003","0.6086","0.6858"]	["144.76"]	["XPHO"]	135.0000	300.0000	105	105	false	true	false	true
01a06d78-2d25-7ce0-b6d3-038712a87794	ORCL	2026-09-04 13:29	risk_reversal	3	5	50	130090.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6017","0.6094","0.6854"]	["144.77"]	["BATO","C2OX","EDGO","XCBO","XISX"]	135.0000	300.0000	105	105	false	true	false	true
01a06d78-2d25-7ce0-b6d3-0379e9d2167b	ORCL	2026-09-04 13:29	risk_reversal	3	6	64	166438.00	short	ask	157.5500	0.8100	["135","150","300"]	["0.6018","0.6095","0.6837"]	["144.75"]	["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"]	135.0000	300.0000	105	105	false	true	false	true