Multi-leg option trades

core.multileg_trades

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

677,480 rowsCSV — whole table, not this view

Sources in this table

uw_multileg677,480 rows

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:endpoint = /api/option-trades/multi-leg×net_side = bid×ticker = JNJ×

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

01a0fda6-26bf-7792-b11d-a714a28d15e2	JNJ	2026-10-02 13:25	call_diagonal_spread	2	1	10	105400.00	long	bid	255.9350	5.0500	["200","220"]	["0.3367","0.2331"]	[]	["XISX"]	200.0000	220.0000	105	258	false	false	true	true	false	mlet	market_whale	uw_multileg	/api/option-trades/multi-leg	{"limit":500,"older_than":"2026-10-02T17:25:27Z"}	2026-10-02	2026-10-02 17:15	2026-10-02 17:15
01a0f8f4-23e7-74d0-85bb-288f80bac181	JNJ	2026-10-01 15:32	put_ladder	3	1	70	157140.00	unknown	bid	259.3400	7.4000	["270","272.5","275"]	["0.8066","1.0897","1.1950"]	["260.31"]	["XBOX"]	270.0000	275.0000	1	1	false	false
01a0f2dc-574f-71b1-8fd4-78fdafec9ca1	JNJ	2026-09-30 11:08	straddle	2	1	200	572500.00	short	bid	268.0850	1.0000	["270"]	["0.2478"]	["241.38","298.62"]	["XBOX"]	270.0000	270.0000	107	107	false	false
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
01a0ed7a-4627-7833-8904-b34c21ecc24b	JNJ	2026-09-29 10:03	call_diagonal_spread	2	1	100	475800.00	long	bid	268.6603	4.7500	["240","330"]	["0.2719","0.2390"]	[]	["XMIO"]	240.0000	330.0000	80	444	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
01a0d94d-8e2e-7031-98e1-2763fab9722e	JNJ	2026-09-25 12:02	other	4	3	8	112531.00	unknown	bid	269.9580	8.4000	["240","250"]	["0.2325","0.2345"]	[]	["AMXO","ARCO","XPHO"]	240.0000	250.0000	112	448	false	false
01a0d4f4-26ee-7ac0-aafc-a0c1c7d8c5fd	JNJ	2026-09-24 15:46	put_calendar	2	2	2466	2301948.00	unknown	bid	271.7475	0.6000	["260"]	["0.2668"]	[]	["XCBO"]	260.0000	260.0000	57	85	false	true
01a0d4df-6e3e-7a23-8311-c366a4813606	JNJ	2026-09-24 15:23	put_calendar	2	1	100	133400.00	unknown	bid	271.7900	0.7000	["260"]	["0.2672"]	[]	["XISX"]	260.0000	260.0000	57	85	false	true
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
01a0b619-fc27-7b93-bf45-cb11b4b8778d	JNJ	2026-09-18 15:59	call_diagonal_spread	2	1	10	113560.00	unknown	bid	270.0600	6.2500	["210","220"]	["0.4927","0.3281"]	[]	["XCBO"]	210.0000	220.0000	28	63	false	false
01a0b5e0-2b5f-7711-9f1c-7ef5b6701312	JNJ	2026-09-18 14:55	call_calendar	2	1	200	444800.00	unknown	bid	271.6050	0.9000	["270"]	["0.2577"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b5df-73c8-7da1-866b-b5635a4ee5e1	JNJ	2026-09-18 14:55	call_calendar	2	1	100	222400.00	unknown	bid	271.6200	0.9000	["270"]	["0.2575"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b5de-3f2f-73f1-a5c8-9eb6938be05b	JNJ	2026-09-18 14:53	call_calendar	2	1	100	222400.00	unknown	bid	271.6700	0.9000	["270"]	["0.2567"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b5dc-1c4f-7b31-9344-6a4145b2f229	JNJ	2026-09-18 14:51	call_calendar	2	1	50	111200.00	unknown	bid	271.7300	1.4500	["270"]	["0.2557"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false
01a0b579-d80f-7732-8ae3-64307bcbff4c	JNJ	2026-09-18 13:04	call_calendar	2	1	100	206400.00	unknown	bid	269.9650	0.8500	["270"]	["0.2604"]	[]	["XISX"]	270.0000	270.0000	28	63	false	true
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
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
01a0a025-f9b8-72e1-8e0d-cf89dd847494	JNJ	2026-09-14 09:40	call_diagonal_spread	2	1	10	121360.00	long	bid	269.6000	6.2500	["200","220"]	["1.5628","0.4441"]	[]	["XMIO"]	200.0000	220.0000	4	32	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