Multi-leg option trades

core.multileg_trades

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

600,173 rowsCSV — whole table, not this view

Sources in this table

uw_multileg600,173 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:source = uw_multileg×ticker = ORCL×

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

01a0d477-6187-7fe1-9f13-534abcf0cdb0	ORCL	2026-09-24 13:29	other	4	6	30	90740.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5724","0.5520","0.5176","0.5935"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true	true	true	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-24T17:30:19Z"}	2026-09-24	2026-09-24 17:15	2026-09-24 17:15
01a0d477-6187-7fe1-9f13-5332538093da	ORCL	2026-09-24 13:29	other	4	4	20	60360.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5716","0.5515","0.5185","0.5916"]	[]	["AMXO","MCRY","XBOX","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-6187-7fe1-9f13-5322ca27c9cb	ORCL	2026-09-24 13:29	other	4	2	15	45305.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5725","0.5515","0.5156","0.5926"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-6187-7fe1-9f13-5319f2fcf8a2	ORCL	2026-09-24 13:29	other	4	5	25	75638.00	unknown	ask	138.5701	0.4800	["100","140","150","250"]	["0.5723","0.5521","0.5180","0.5937"]	[]	["BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-6187-7fe1-9f13-53047c260248	ORCL	2026-09-24 13:29	other	4	5	25	75480.00	unknown	ask	138.5767	0.4800	["100","140","150","250"]	["0.5717","0.5517","0.5177","0.5916"]	[]	["AMXO","ARCO","MCRY","XBOX","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-55ce-7022-a2a1-8b250fd4dbe4	ORCL	2026-09-24 13:29	other	4	3	11	33281.00	unknown	ask	138.5500	0.4800	["100","140","150","250"]	["0.5731","0.5520","0.5189","0.5935"]	[]	["ARCO","EDGO","XISX"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-51e6-7363-83cd-a730898dee61	ORCL	2026-09-24 13:29	other	4	4	15	45335.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5725","0.5518","0.5205","0.5930"]	[]	["AMXO","MCRY","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-51e6-7363-83cd-a72e9d046c9e	ORCL	2026-09-24 13:29	other	4	4	21	63462.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5728","0.5518","0.5165","0.5933"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-51e6-7363-83cd-a71966682d25	ORCL	2026-09-24 13:29	other	4	8	49	148176.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5728","0.5520","0.5194","0.5933"]	[]	["ARCO","BATO","C2OX","EDGO","XBOX","XCBO","XISX"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-51e6-7363-83cd-a70ad1de0ebd	ORCL	2026-09-24 13:29	other	4	4	21	63364.00	unknown	ask	138.5400	0.4800	["100","140","150","250"]	["0.5719","0.5512","0.5198","0.5923"]	[]	["AMXO","MCRY","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dff-7723-a1ed-c6263adbe840	ORCL	2026-09-24 13:29	other	4	2	12	36180.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5503","0.5149","0.5920"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dff-7723-a1ed-c6163a82b802	ORCL	2026-09-24 13:29	other	4	6	33	99867.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5729","0.5518","0.5171","0.5935"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dfe-73a3-b068-7ef89fba3050	ORCL	2026-09-24 13:29	other	4	2	12	36252.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5511","0.5159","0.5933"]	[]	["MCRY","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dfe-73a3-b068-7eede95a7740	ORCL	2026-09-24 13:29	other	4	2	17	51268.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5722","0.5505","0.5149","0.5920"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dfe-73a3-b068-7ed86d438f1d	ORCL	2026-09-24 13:29	other	4	5	20	60536.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5729","0.5519","0.5165","0.5937"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4dfe-73a3-b068-7ecc834466c9	ORCL	2026-09-24 13:29	other	4	5	20	60616.00	unknown	ask	138.5906	0.5300	["100","140","150","250"]	["0.5735","0.5525","0.5208","0.5928"]	[]	["AMXO","MCRY","XBOX","XISX","XPHO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4247-7002-96c6-220db50c0c8b	ORCL	2026-09-24 13:29	other	4	2	24	72336.00	unknown	ask	138.5900	0.5800	["100","140","150","250"]	["0.5727","0.5495","0.5149","0.5925"]	[]	["EMLD","XMIO"]	100.0000	250.0000	8	176	false	true	true	true
01a0d477-4247-7002-96c6-21f006db4504	ORCL	2026-09-24 13:29	other	4	6	60	181520.00	unknown	ask	138.5900	0.5800	["100","140","150","250"]	["0.5735","0.5510","0.5182","0.5936"]	[]	["ARCO","BATO","C2OX","EDGO","XCBO","XISX"]	100.0000	250.0000	8	176	false	true	true	true
01a0d473-1faf-7890-8632-90a6bd1a5dd9	ORCL	2026-09-24 13:25	call_vertical_spread	2	1	5	46720.00	unknown	bid	138.3500	2.8000	["95","100"]	["0.5584","0.5444"]	["144.22"]	["BATO"]	95.0000	100.0000	176	176	false	false	false	true
01a0d46d-18b7-77e1-b450-113f7ef0736d	ORCL	2026-09-24 13:18	call_vertical_spread	2	1	5	47225.00	unknown	—	138.8505	3.4000	["95","100"]	["0.5464","0.5610"]	[]	["XMIO"]	95.0000	100.0000	176	176	false	false	false	true	false	mlet
01a0d46c-97ce-7bb2-a0f9-79a9c9286dbb	ORCL	2026-09-24 13:17	call_vertical_spread	2	2	5	27305.00	short	bid	138.8300	1.7000	["130","250"]	["0.5439","0.5629"]	["157.75"]	["XISX"]	130.0000	250.0000	484	484	false	false	false	true
01a0d469-3c6f-7580-89d9-56e1c9c8c3b6	ORCL	2026-09-24 13:14	iron_condor	4	1	25	33800.00	short	bid	139.0200	0.7900	["145","146","148","149"]	["0.6597","0.6520","0.6930","0.7190"]	["145.08","148.92"]	["XCBO"]	145.0000	149.0000	1	1	false	false	false	true
01a0d465-3917-72b2-a388-9add3abc3168	ORCL	2026-09-24 13:09	risk_reversal	2	1	250	618000.00	long	ask	138.9500	0.4500	["130","150"]	["0.5567","0.5431"]	["151.42"]	["XMIO"]	130.0000	150.0000	113	113	false	true	false	true
01a0d460-7a3e-70b0-bf06-5d2eefa5dcc0	ORCL	2026-09-24 13:04	put_diagonal_spread	2	1	6	40908.00	short	bid	138.8500	3.0500	["155","165"]	["0.5866","0.5838"]	[]	["ARCO"]	155.0000	165.0000	113	266	false	false	true	true
01a0d45f-16c7-77d3-b29e-3344a6f031da	ORCL	2026-09-24 13:03	put_diagonal_spread	2	1	12	26640.00	short	bid	138.9600	0.5000	["140","145"]	["0.5342","0.5218"]	[]	["XISX"]	140.0000	145.0000	22	57	false	false	true	true
01a0d45f-12df-7a83-bffb-df078d355fe9	ORCL	2026-09-24 13:03	put_calendar	2	1	100	279300.00	short	bid	138.9600	0.8000	["152.5"]	["0.8340"]	[]	["EDGO"]	152.5000	152.5000	1	8	false	false	true	false
01a0d45e-4ba6-7e43-ac8b-a7e4dcd0acc5	ORCL	2026-09-24 13:02	call_vertical_spread	2	1	37	29045.00	unknown	bid	138.7700	0.3600	["140","155"]	["0.4738","0.4963"]	["147.85"]	["XISX"]	140.0000	155.0000	22	22	false	true	false	true
01a0d45b-906f-79e3-a939-19936c53cecf	ORCL	2026-09-24 12:59	other	4	4	11	76915.00	unknown	ask	139.0901	1.3000	["136","139","165"]	["0.6011","0.5966","0.5721"]	[]	["XISX","XPHO"]	136.0000	165.0000	1	358	false	false	true	true
01a0d45b-906f-79e3-a939-1987609ec1ae	ORCL	2026-09-24 12:59	straddle	2	4	12	81420.00	long	ask	139.0901	0.9542	["165"]	["0.5721"]	["97.15","232.85"]	["MCRY","XISX","XPHO"]	165.0000	165.0000	358	358	false	false	false	false
01a0d45b-1b3e-7a81-abf9-8c43192070ad	ORCL	2026-09-24 12:58	put_vertical_spread	2	1	100	29000.00	unknown	bid	139.0900	0.1000	["138","139"]	["0.5969","0.5932"]	["137.05"]	["XCBO"]	138.0000	139.0000	1	1	false	true	false	true
01a0d457-621e-7a13-910f-cd618e8dffb9	ORCL	2026-09-24 12:54	other	4	1	60	140280.00	unknown	ask	138.9800	1.1500	["143","144"]	["0.5605","0.5647"]	[]	["XCBO"]	143.0000	144.0000	1	8	false	false	true	true
01a0d457-46c7-72b0-bb9f-617d732075d9	ORCL	2026-09-24 12:54	other	4	1	30	88440.00	unknown	—	139.0230	1.0500	["145","146"]	["0.5546","0.5569"]	[]	["XPHO"]	145.0000	146.0000	1	8	false	false	true	true	false	mlet
01a0d457-13ff-7b51-a621-4913ee9ec9db	ORCL	2026-09-24 12:54	put_vertical_spread	2	1	15	31455.00	unknown	ask	139.0800	0.5167	["149","150"]	["0.7085","0.8173"]	["139.02"]	["XISX"]	149.0000	150.0000	1	1	false	false	false	true
01a0d456-875f-7a63-ba4b-4300a5b2015e	ORCL	2026-09-24 12:53	other	4	1	10	36360.00	unknown	—	139.0100	1.5000	["147","148"]	["0.5290","0.5590"]	[]	["XPHO"]	147.0000	148.0000	1	8	false	false	true	true	false	mlet
01a0d456-44f6-7fd0-8c8b-019883005cb0	ORCL	2026-09-24 12:53	put_calendar	2	1	99	328284.00	short	ask	139.1199	0.8000	["155"]	["0.8091"]	[]	["XCBO"]	155.0000	155.0000	1	15	false	false	true	false
01a0d455-b087-7b11-943a-469285293246	ORCL	2026-09-24 12:52	put_vertical_spread	2	1	125	34125.00	short	bid	139.0650	0.1500	["120","125"]	["0.5226","0.5095"]	["124.25"]	["XCBO"]	120.0000	125.0000	22	22	false	true	false	true
01a0d455-2bb6-7243-a7d8-0c82852e1764	ORCL	2026-09-24 12:52	put_vertical_spread	2	2	125	34250.00	short	bid	138.9901	0.1500	["120","125"]	["0.5213","0.5091"]	["124.24"]	["XMIO"]	120.0000	125.0000	22	22	false	true	false	true
01a0d453-f71f-78c0-8bc0-7858fc5b9708	ORCL	2026-09-24 12:51	put_diagonal_spread	2	1	26	48906.00	short	bid	139.1000	0.7500	["146","148"]	["0.5165","0.6498"]	[]	["XCBO"]	146.0000	148.0000	1	15	false	false	true	true
01a0d453-5adf-7dd2-b6c1-c5ba558421d6	ORCL	2026-09-24 12:50	call_vertical_spread	2	1	37	30229.00	long	ask	139.2000	0.1900	["140","155"]	["0.4747","0.4964"]	["144.33"]	["XCBO"]	140.0000	155.0000	22	22	false	true	false	true
01a0d452-c287-7372-9376-febc9df23942	ORCL	2026-09-24 12:49	other	5	4	10	25779.00	unknown	—	139.0400	1.3000	["140","141","145","150"]	["0.4961","0.4977","0.5194","0.7098"]	[]	["XISX","XMIO","XPHO"]	140.0000	150.0000	1	15	false	false	true	true	true	mlet
01a0d451-479f-72d1-b4e7-e820672cd959	ORCL	2026-09-24 12:48	call_calendar	2	1	10	37690.00	short	ask	138.7050	0.8500	["120"]	["1.1269"]	[]	["BATO"]	120.0000	120.0000	1	8	false	false	true	false
01a0d44d-194f-7482-b518-edcbb7690ac3	ORCL	2026-09-24 12:43	call_condor	4	2	10	41310.00	long	ask	138.7750	1.2200	["120","125","145","155"]	["0.4801","0.4730","0.4748","0.5008"]	["122.09","147.91"]	["EMLD","XCBO"]	120.0000	155.0000	22	22	false	false	false	true
01a0d44b-38d7-7a00-b655-0c2cf73d7492	ORCL	2026-09-24 12:41	put_diagonal_spread	2	6	21	49177.00	short	bid	138.5000	0.6500	["148","150"]	["0.5305","0.8427"]	[]	["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"]	148.0000	150.0000	1	15	false	false	true	true
01a0d44a-9c96-7601-8b73-8553e4ac2863	ORCL	2026-09-24 12:40	call_ratio_spread	2	2	362	162186.00	unknown	bid	138.1050	0.1500	["180","230"]	["0.5577","0.5899"]	["188.96"]	["ARCO","SPHR"]	180.0000	230.0000	113	113	false	true	false	true
01a0d44a-8527-7d30-b62e-78f408d08232	ORCL	2026-09-24 12:40	call_ratio_spread	2	1	72	32580.00	long	ask	138.1200	0.1600	["180","230"]	["0.5592","0.5918"]	["182.41","277.59"]	["XCBO"]	180.0000	230.0000	113	113	false	true	false	true
01a0d447-dd77-7763-bc0d-a92060225ff2	ORCL	2026-09-24 12:37	other	4	4	112	40699.00	unknown	bid	138.2500	0.1900	["143","147","148","152.5"]	["0.4964","0.5100","0.7605","0.8313"]	[]	["ARCO","EDGO","XCBO","XISX"]	143.0000	152.5000	1	8	false	true	true	true
01a0d447-8b6f-70c2-b787-f6a9af7968bb	ORCL	2026-09-24 12:37	call_vertical_spread	2	1	5	38290.00	long	ask	138.3028	3.1000	["95","115"]	["0.5369","0.5371"]	["110.60"]	["ARCO"]	95.0000	115.0000	113	113	false	false	false	true
01a0d445-7c16-7d31-9a82-9d02ac972ca4	ORCL	2026-09-24 12:35	call_vertical_spread	2	1	5	35750.00	short	bid	138.1100	2.1000	["150","240"]	["0.5521","0.5628"]	["169.20"]	["XCBO"]	150.0000	240.0000	813	813	false	true	false	true
01a0d445-2627-76d1-8240-4522321083e8	ORCL	2026-09-24 12:34	other	3	1	25	179000.00	unknown	bid	138.1400	0.9000	["115","120","135"]	["0.5708","0.5498","0.5778"]	["146.40"]	["XISX"]	115.0000	135.0000	266	266	false	false	false	true
01a0d444-f35f-76c3-ba62-1500f043fb3d	ORCL	2026-09-24 12:34	other	3	2	17	121856.00	unknown	bid	138.1250	1.8000	["115","120","135"]	["0.5728","0.5490","0.5786"]	["146.40"]	["EDGO","XCBO"]	115.0000	135.0000	266	266	false	false	false	true