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 = synthetic×ticker = ORCL×sorted by executed_at ↑×

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

01a06dc6-9375-7693-9c79-55f144824147	ORCL	2026-09-04 14:55	synthetic	2	1	10	45160.00	short	ask	157.2200	0.9000	["160"]	["0.5987"]	["159"]	["XPHO"]	160.0000	160.0000	133	133	false	false	false	false	true	mlet	tracked	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-04T18:55:39Z"}	2026-09-04	2026-09-07 00:53	2026-09-07 00:53
01a06df2-a89d-7f73-a65c-1c71d33c1920	ORCL	2026-09-04 15:43	synthetic	2	7	41	98032.00	long	ask	157.5200	0.5793	["157.5"]	["0.6889"]	["158.09"]	["ARCO","EMLD","MCRY","XISX","XPHO"]	157.5000	157.5000	28	28	false	false	false	false
01a06dfe-a6ed-7cd2-8378-2b8ec64d6599	ORCL	2026-09-04 15:56	synthetic	2	2	21	46515.00	long	ask	158.2600	0.6500	["145"]	["0.8131"]	["158.16"]	["ARCO","EMLD"]	145.0000	145.0000	14	14	false	false	false	false
01a08148-3240-7463-90e6-48ba48c4f504	ORCL	2026-09-08 09:49	synthetic	2	5	5	25110.00	long	ask	165.9900	1.1200	["135"]	["0.6025"]	["167.42"]	["AMXO","ARCO","EMLD","XBOX","XMIO"]	135.0000	135.0000	129	129	false	false	false	false
01a08773-38b8-7040-bb14-47d0fcbb0925	ORCL	2026-09-09 14:34	synthetic	2	1	10	31100.00	short	ask	163.3763	1.0500	["170"]	["0.6689"]	["163.70"]	["XCBO"]	170.0000	170.0000	44	44	false	false	false	false
01a08c73-e449-7d22-b197-772559f05a62	ORCL	2026-09-10 13:53	synthetic	2	1	73	136145.00	short	bid	155.9400	0.3000	["155"]	["2.8728"]	["156.05"]	["XPHO"]	155.0000	155.0000	1	1	false	false	false	false
01a08c7e-9e60-7551-9670-0581c621eee2	ORCL	2026-09-10 14:05	synthetic	2	1	3	30057.00	short	bid	155.8100	2.9500	["145"]	["0.5903"]	["166.83"]	["XPHO"]	145.0000	145.0000	827	827	false	false	false	false
01a08cbc-0139-7631-9187-e0b546a4f0e3	ORCL	2026-09-10 15:12	synthetic	2	2	27	50220.00	short	ask	154.6650	0.1000	["155"]	["2.8791"]	["154.70"]	["XISX","XPHO"]	155.0000	155.0000	1	1	false	false	false	false
01a08ce6-39d0-7030-92bc-fa3fa51e85bf	ORCL	2026-09-10 15:58	synthetic	2	1	17	32606.00	short	ask	153.0500	0.2000	["155"]	["2.9752"]	["153.08"]	["XBOX"]	155.0000	155.0000	1	1	false	false	false	false
01a090b7-9cc0-78b3-aaeb-ba250ca69e32	ORCL	2026-09-11 09:45	synthetic	2	1	20	146660.00	long	ask	157.4800	4.6500	["160"]	["0.5748"]	["163.61"]	["XMIO"]	160.0000	160.0000	399	399	false	false	false	false
01a090d1-8978-7c51-a177-70f21b7b52a2	ORCL	2026-09-11 10:14	synthetic	2	1	166	73434.00	long	bid	156.2800	0.4000	["157.5"]	["1.3436"]	["156.48"]	["C2OX"]	157.5000	157.5000	0	0	false	false	false	false
01a09206-fc38-7d43-91cf-b6266ef3343f	ORCL	2026-09-11 15:52	synthetic	2	1	20	41500.00	unknown	—	150.3700	0.9500	["155"]	["0.4980"]	[]	["XPHO"]	155.0000	155.0000	42	42	false	false	false	false	true	mlet
01a0a036-a741-7fa1-9658-0a110ecd0b69	ORCL	2026-09-14 09:58	synthetic	2	1	6	39282.00	long	ask	144.5875	1.7000	["145"]	["0.5616"]	["150.23"]	["XCBO"]	145.0000	145.0000	396	396	false	false	false	false
01a0a036-a359-7bc2-a0c1-e6a42ee9b867	ORCL	2026-09-14 09:58	synthetic	2	3	4	26280.00	long	ask	144.5875	2.0000	["145"]	["0.5636"]	["150.25"]	["ARCO","SPHR","XBOX"]	145.0000	145.0000	396	396	false	false	false	false
01a0a0d6-cb58-71a2-bdb1-901636fcb5fa	ORCL	2026-09-14 12:53	synthetic	2	3	10	33464.00	long	bid	144.1100	0.5500	["150"]	["0.5611"]	["145.42"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a0fc-8398-7240-8f9b-cb6b9f2a4cfa	ORCL	2026-09-14 13:34	synthetic	2	3	10	33320.00	long	bid	143.8800	0.7500	["150"]	["0.5588"]	["145.20"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a0fd-5e58-7293-bf43-b5270b4de695	ORCL	2026-09-14 13:35	synthetic	2	3	10	33320.00	long	bid	143.8300	0.7500	["150"]	["0.5588"]	["145.14"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a0fe-44d0-7c90-9318-69e22be21093	ORCL	2026-09-14 13:36	synthetic	2	3	10	33282.00	long	bid	143.7700	0.7000	["150"]	["0.5582"]	["145.09"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a0ff-69c8-78a1-93ca-91d54c0c0033	ORCL	2026-09-14 13:38	synthetic	2	3	8	26660.00	long	bid	143.8300	0.6500	["150"]	["0.5589"]	["145.12"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a104-3070-7180-b8fe-e9a3488e5e61	ORCL	2026-09-14 13:43	synthetic	2	3	10	33342.00	short	ask	143.7900	0.3500	["150"]	["0.5593"]	["145.11"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a10a-9cf8-7b50-b186-8815d682de3f	ORCL	2026-09-14 13:50	synthetic	2	3	8	26684.00	short	ask	143.7399	0.4000	["150"]	["0.5595"]	["145.04"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a10f-86c8-72e3-89c1-ed0970c93db9	ORCL	2026-09-14 13:55	synthetic	2	5	8	26692.00	long	bid	143.7400	0.4500	["150"]	["0.5596"]	["145.04"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a110-2ad8-74c2-b71b-5e2d7e04b862	ORCL	2026-09-14 13:56	synthetic	2	3	10	33354.00	long	bid	143.7550	0.4500	["150"]	["0.5594"]	["145.07"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a114-a748-7cd0-a0ac-37c1afd36143	ORCL	2026-09-14 14:01	synthetic	2	3	9	29935.00	long	bid	144.0800	0.5500	["150"]	["0.5577"]	["145.39"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a118-50c9-7de0-96f2-7a06f6f7b9c0	ORCL	2026-09-14 14:05	synthetic	2	4	10	32262.00	short	bid	144.1200	0.5500	["140"]	["0.5574"]	["145.41"]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false
01a0a118-50c9-7de0-96f2-79f259335ace	ORCL	2026-09-14 14:05	synthetic	2	3	10	33320.00	long	bid	144.1200	0.6500	["150"]	["0.5587"]	["145.44"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a119-0478-7a12-a9ef-1d61faa6780c	ORCL	2026-09-14 14:06	synthetic	2	3	10	33320.00	long	bid	144.1240	0.6500	["150"]	["0.5587"]	["145.46"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a119-5681-7591-b520-7f799e1db34c	ORCL	2026-09-14 14:06	synthetic	2	3	10	33380.00	long	bid	144.0850	0.4500	["150"]	["0.5597"]	["145.40"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a11a-e4f0-79c2-b501-90f9038411e1	ORCL	2026-09-14 14:08	synthetic	2	3	10	33392.00	long	bid	144.2400	0.4000	["150"]	["0.5598"]	["145.54"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a11d-5208-7583-9e4e-fe4cbb8b1733	ORCL	2026-09-14 14:10	synthetic	2	3	10	33442.00	long	bid	144.4900	0.5000	["150"]	["0.5605"]	["145.81"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a125-77f8-7442-be55-9db555452db5	ORCL	2026-09-14 14:19	synthetic	2	4	10	33376.00	long	bid	143.6700	0.6000	["150"]	["0.5598"]	["145"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a126-0c68-7582-93aa-271165e81f83	ORCL	2026-09-14 14:20	synthetic	2	3	10	32250.00	long	ask	143.6700	0.4500	["140"]	["0.5589"]	["144.95"]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false
01a0a126-0c68-7582-93aa-270e1a6d38c0	ORCL	2026-09-14 14:20	synthetic	2	3	10	33404.00	long	bid	143.6700	0.5500	["150"]	["0.5603"]	["144.98"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a127-73c8-77b0-9b97-0a09a3fdf8f4	ORCL	2026-09-14 14:21	synthetic	2	3	10	33358.00	short	ask	143.6130	0.4000	["150"]	["0.5596"]	["144.93"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a12d-c110-7253-86df-afef1064a932	ORCL	2026-09-14 14:28	synthetic	2	3	10	32216.00	long	ask	143.2900	0.4800	["140"]	["0.5597"]	["144.54"]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false
01a0a132-be68-7281-8cf9-f46f285d8de5	ORCL	2026-09-14 14:34	synthetic	2	3	10	32160.00	long	ask	143.3600	0.5500	["140"]	["0.5584"]	["144.64"]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false
01a0a14f-81b1-7d41-b199-2f5d694fa16f	ORCL	2026-09-14 15:05	synthetic	2	3	10	32320.00	unknown	—	143.8500	0.5500	["140"]	["0.5594"]	[]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false	true	mlet
01a0a151-b430-7a12-85cd-1082cacf8dbc	ORCL	2026-09-14 15:07	synthetic	2	3	8	26820.00	long	bid	143.4600	0.4000	["150"]	["0.5625"]	["144.75"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a155-55e0-7643-a8e6-bccb81e70c2a	ORCL	2026-09-14 15:11	synthetic	2	3	10	33494.00	long	bid	143.3300	0.4000	["150"]	["0.5620"]	["144.63"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a159-6108-72d2-b230-99c48952f5b7	ORCL	2026-09-14 15:16	synthetic	2	3	10	33418.00	long	bid	143.3900	0.2000	["150"]	["0.5607"]	["144.67"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a159-f960-7dd1-aba4-3df593d9d27f	ORCL	2026-09-14 15:17	synthetic	2	3	10	33446.00	short	ask	143.3800	0.3000	["150"]	["0.5611"]	["144.69"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a15d-e931-7d31-b45e-1ab936bae568	ORCL	2026-09-14 15:21	synthetic	2	3	10	33440.00	long	bid	143.3850	0.2000	["150"]	["0.5610"]	["144.68"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a15e-0870-7841-b5fe-05e5a2db14f6	ORCL	2026-09-14 15:21	synthetic	2	3	9	28998.00	long	ask	143.4150	0.5500	["140"]	["0.5593"]	["144.68"]	["AMXO","XCBO","XISX"]	140.0000	140.0000	95	95	false	false	false	false
01a0a15e-9510-7411-bd9a-ab89ccbd53e6	ORCL	2026-09-14 15:22	synthetic	2	3	10	33494.00	long	bid	143.3900	0.2000	["150"]	["0.5620"]	["144.67"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a15f-b620-77e1-bf53-2df3ff6a7a35	ORCL	2026-09-14 15:23	synthetic	2	3	8	26806.00	short	ask	143.3800	0.4000	["150"]	["0.5622"]	["144.67"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a15f-ba08-75a3-bc12-bd8d20a37850	ORCL	2026-09-14 15:23	synthetic	2	3	8	26804.00	short	ask	143.3899	0.4000	["150"]	["0.5622"]	["144.67"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a163-05c9-78e2-95b5-63fe714e28ef	ORCL	2026-09-14 15:26	synthetic	2	3	10	33328.00	long	bid	143.7452	0.6500	["150"]	["0.5590"]	["145.06"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a163-86b0-7333-9207-761bd734c0db	ORCL	2026-09-14 15:27	synthetic	2	3	10	33382.00	long	bid	143.8150	0.5000	["150"]	["0.5599"]	["145.11"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a163-a9d8-7113-acd1-6ef0ce25d016	ORCL	2026-09-14 15:27	synthetic	2	3	10	33382.00	long	bid	143.7706	0.5000	["150"]	["0.5599"]	["145.09"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false
01a0a163-c149-7242-8ad8-fa3b4f38d471	ORCL	2026-09-14 15:27	synthetic	2	3	10	33396.00	long	bid	143.8043	0.4500	["150"]	["0.5601"]	["145.10"]	["AMXO","XCBO","XISX"]	150.0000	150.0000	95	95	false	false	false	false