Multi-leg option trades

core.multileg_trades

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

570,195 rowsCSV — whole table, not this view

Sources in this table

uw_multileg570,195 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:direction = short×endpoint = /api/option-trades/multi-leg×ticker = JNJ×

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

01a0eea3-4566-7821-b23a-58b30bf96bfc	JNJ	2026-09-29 15:27	call_vertical_spread	2	1	9	179442.00	short	bid	267.1200	6.5500	["165","170"]	["1.7988","1.6776"]	["170"]	["XMIO"]	165.0000	170.0000	3	3	false	false	false	true	false	mlat	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-09-29T19:28:22Z"}	2026-09-29	2026-09-29 17:15	2026-09-29 17:15
01a0ee06-ab8f-7113-a8f6-179b59f2de41	JNJ	2026-09-29 12:36	call_calendar	2	1	5	103010.00	short	ask	266.8850	5.8500	["175"]	["0.3657"]	[]	["XPHO"]	175.0000	175.0000	479	843	false	false
01a0e835-cac9-7c72-8459-3206ef4fe6f1	JNJ	2026-09-28 09:30	call_diagonal_spread	2	5	13	154843.00	short	bid	270.1875	3.2423	["175","270"]	["0.3889","0.2433"]	[]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	175.0000	270.0000	109	445	false	false
01a0e835-cac9-7c72-8459-31e428a09f12	JNJ	2026-09-28 09:30	call_diagonal_spread	2	5	13	154884.00	short	bid	270.1875	3.2423	["175","270"]	["0.3889","0.2434"]	[]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	175.0000	270.0000	109	445	false	false
01a0e835-cac9-7c72-8459-31ce96baff9a	JNJ	2026-09-28 09:30	call_diagonal_spread	2	5	13	154897.00	short	bid	270.1875	3.2038	["175","270"]	["0.3889","0.2434"]	[]	["AMXO","EMLD","MCRY","XMIO","XPHO"]	175.0000	270.0000	109	445	false	false
01a0d950-c667-7621-8a10-8212f66ce618	JNJ	2026-09-25 12:05	call_diagonal_spread	2	1	15	212640.00	short	ask	270.0600	4.7000	["200","210"]	["0.2811","0.2094"]	[]	["XCBO"]	200.0000	210.0000	175	265	false	false
01a0d94d-a986-73f1-ac04-dd6878a52743	JNJ	2026-09-25 12:02	call_calendar	2	2	14	122080.00	short	ask	269.9580	4.5500	["240"]	["0.2213"]	[]	["ARCO","XBOX"]	240.0000	240.0000	112	448	false	false
01a0d40e-faf6-7f10-9c82-f0db516d1fec	JNJ	2026-09-24 11:35	risk_reversal	2	1	40	132800.00	short	bid	270.2550	3.4000	["240","310"]	["0.2886","0.2305"]	["314.80"]	["XMIO"]	240.0000	310.0000	449	449	false	true
01a0cfab-c3fe-7b81-a4bc-acedf6f56de4	JNJ	2026-09-23 15:08	call_diagonal_spread	2	1	8	187912.00	short	ask	268.5700	4.5500	["150","170"]	["0.3829","0.3531"]	[]	["XCBO"]	150.0000	170.0000	485	849	false	false
01a0b5e3-7338-7531-9399-6cdec5e35441	JNJ	2026-09-18 14:59	call_calendar	2	1	200	444000.00	short	ask	271.5500	0.7500	["270"]	["0.2580"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b5e2-1b78-78b0-b9a2-2319a3240f36	JNJ	2026-09-18 14:58	call_calendar	2	1	200	444000.00	short	ask	271.6300	0.7500	["270"]	["0.2568"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b563-0067-7c62-ba33-66811354aa3b	JNJ	2026-09-18 12:39	call_diagonal_spread	2	1	265	125610.00	short	bid	269.7201	1.1500	["280","285"]	["0.2481","0.2245"]	[]	["SPHR"]	280.0000	285.0000	7	35	false	true
01a0b52e-a60f-7123-be45-451d8ca47a3e	JNJ	2026-09-18 11:42	call_calendar	2	4	950	3016250.00	short	bid	269.2800	2.5500	["260"]	["0.2666"]	[]	["XCBO"]	260.0000	260.0000	28	63	false	false
01a0b52b-75a8-7933-b236-cf2fa8d8b259	JNJ	2026-09-18 11:38	call_calendar	2	1	50	157500.00	short	bid	269.3585	0.6000	["260"]	["0.2607"]	[]	["XISX"]	260.0000	260.0000	28	63	false	false
01a0b04b-cf7b-7c41-9ebf-65492dbff30b	JNJ	2026-09-17 12:55	risk_reversal	2	1	200	440000.00	short	bid	267.8900	1.3500	["250","290"]	["0.2756","0.2372"]	["291.30"]	["XBOX"]	250.0000	290.0000	183	183	false	true
01a0b030-583b-7f92-9b23-18c96b6d5f7d	JNJ	2026-09-17 12:25	call_diagonal_spread	2	1	175	243250.00	short	ask	268.2000	1.9000	["260","300"]	["0.5097","0.2368"]	[]	["SPHR"]	260.0000	300.0000	1	120	false	false
01a0ab6e-d88b-7bc3-9859-83ec5000952e	JNJ	2026-09-16 14:16	call_diagonal_spread	2	1	66	133914.00	short	bid	268.2600	1.5000	["260","270"]	["0.4214","0.2479"]	[]	["SPHR"]	260.0000	270.0000	2	65	false	false
01a0aad6-6d03-7b33-8400-c603d0d8abc7	JNJ	2026-09-16 11:29	strangle	2	7	41	161950.00	short	bid	267.6950	0.8671	["250","360"]	["0.2865","0.2115"]	["210.5","399.50"]	["MCRY","XCBO","XISX","XPHO"]	250.0000	360.0000	821	821	false	true
01a0a670-240e-7e93-9330-acb56bc4082d	JNJ	2026-09-15 14:59	call_calendar	2	1	15	225600.00	short	bid	265.5800	2.0000	["210"]	["0.1907"]	[]	["XISX"]	210.0000	210.0000	493	822	false	false
01a0a566-8026-7513-be33-465f949ca4c6	JNJ	2026-09-15 10:09	call_diagonal_spread	2	1	324	141264.00	short	bid	262.1600	0.6800	["270","300"]	["0.2818","0.2364"]	[]	["SPHR"]	270.0000	300.0000	3	122	false	true
01a0a563-20de-7e60-b3cc-789b87444f5b	JNJ	2026-09-15 10:05	put_diagonal_spread	2	1	455	369943.00	short	bid	261.3900	0.8600	["260","265"]	["0.2933","0.2401"]	[]	["XMIO"]	260.0000	265.0000	3	10	false	false
01a0918e-9400-7261-824a-beaa363c1a02	JNJ	2026-09-11 13:40	risk_reversal	2	2	400	920000.00	short	bid	265.8100	0.7500	["250","270"]	["0.2644","0.2446"]	["276.66"]	["AMXO"]	250.0000	270.0000	126	126	false	true
01a08243-5f08-7f60-8c25-704168efb6a6	JNJ	2026-09-08 14:24	call_calendar	2	1	13	165620.00	short	ask	270.6550	4.9500	["210"]	["0.3021"]	[]	["XISX"]	210.0000	210.0000	38	192	false	false