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 rowsexportable

executed_at (ET days)to

column equals (exact text)

sort

chart against executed_at

reset

active:kept_by = market_whale×ticker = JNJ×

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

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
01a0fd7b-da9e-79a1-939a-dac5f5951ee3	JNJ	2026-10-02 12:39	other	4	1	200	149000.00	unknown	ask	256.4100	1.8300	["255","257.5"]	["0.2966","0.2978"]	[]	["XISX"]	255.0000	257.5000	0	7	false	false	true	true
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	false	true
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	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	false	true
01a0ee3d-e05f-7562-bc26-df0f71904b9a	JNJ	2026-09-29 13:37	other	2	1	100	186700.00	unknown	ask	267.0500	1.0500	["260","280"]	["0.2673","0.2372"]	[]	["XMIO"]	260.0000	280.0000	80	108	false	true	true	true
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	true	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	true	true
01a0e861-b94e-70e2-8c68-4d0e024e37c4	JNJ	2026-09-28 10:18	other	2	1	20	140260.00	unknown	ask	271.7700	4.4500	["250","280"]	["0.2463","0.2951"]	[]	["XMIO"]	250.0000	280.0000	172	809	false	false	true	true
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	true	true
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	true	true
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	true	true
01a0e835-cac9-7c72-8459-31b46b7cad1a	JNJ	2026-09-28 09:30	call_diagonal_spread	2	8	16	189908.00	long	ask	270.1875	4.2500	["175","270"]	["0.3889","0.2406"]	[]	["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XCBO","XMIO"]	175.0000	270.0000	109	445	false	false	true
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	true	true
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	true	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	true	true
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	true	false
01a0d4f3-09c7-75e2-9490-da56bafc6681	JNJ	2026-09-24 15:44	call_vertical_spread	2	1	4	111120.00	unknown	—	272.0200	4.8000	["130","135"]	["7.0234","6.6974"]	[]	["XCBO"]	130.0000	135.0000	1	1	false	false	false	true	false	mlat
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	true	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	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	true	true
01a0cf71-d00e-78f1-b821-0ee52a1fe1a8	JNJ	2026-09-23 14:05	call_diagonal_spread	2	1	8	128584.00	unknown	ask	266.6150	4.3000	["200","210"]	["0.1783","0.1761"]	[]	["XISX"]	200.0000	210.0000	485	849	false	false	true	true
01a0cf2b-e987-7c41-acb7-682789814683	JNJ	2026-09-23 12:49	call_diagonal_spread	2	1	8	171634.00	unknown	ask	267.0400	6.7000	["145","175"]	["1.2020","0.3654"]	[]	["XISX"]	145.0000	175.0000	23	849	false	false	true	true
01a0cea4-4ac6-79b0-8571-ebf8a0b427b1	JNJ	2026-09-23 10:21	call_diagonal_spread	2	10	58	148326.00	long	ask	271.9500	1.1500	["280","290"]	["0.2395","0.2392"]	[]	["AMXO","ARCO","EDGO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"]	280.0000	290.0000	114	177	false	true	true
01a0cea4-42f7-7650-982a-0576d4451ebf	JNJ	2026-09-23 10:21	call_diagonal_spread	2	2	66	168894.00	long	ask	272.0000	1.3000	["280","290"]	["0.2392","0.2390"]	[]	["BATO","C2OX"]	280.0000	290.0000	114	177	false	true	true	true
01a0cea4-42f7-7650-982a-056fcef80db7	JNJ	2026-09-23 10:21	call_diagonal_spread	2	2	100	255900.00	long	ask	272.0000	1.3000	["280","290"]	["0.2392","0.2390"]	[]	["BATO","C2OX"]	280.0000	290.0000	114	177	false	true	true	true
01a0cea4-42f7-7650-982a-0551c8f04df3	JNJ	2026-09-23 10:21	call_diagonal_spread	2	3	150	383850.00	long	ask	272.0000	1.3000	["280","290"]	["0.2392","0.2390"]	[]	["BATO","C2OX","XCBO"]	280.0000	290.0000	114	177	false	true	true	true
01a0cea4-42f7-7650-982a-0521fb18e8f5	JNJ	2026-09-23 10:21	call_diagonal_spread	2	4	102	260620.00	long	ask	272.0000	1.4975	["280","290"]	["0.2389","0.2388"]	[]	["ARCO","EMLD","SPHR"]	280.0000	290.0000	114	177	false	true	true	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	true	true
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	true	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	true	false
01a0b5e0-b418-7ec3-8b2b-93d7cb7f119b	JNJ	2026-09-18 14:56	call_calendar	2	2	200	444000.00	unknown	—	271.6700	0.8000	["270"]	["0.2561"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false	true	false	false	mlet
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	true	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	true	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	true	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	true	false
01a0b5db-b6bf-75d2-9924-0f1d9a948b27	JNJ	2026-09-18 14:51	call_calendar	2	1	50	111500.00	unknown	—	271.6200	1.0000	["270"]	["0.2583"]	[]	["XISX"]	270.0000	270.0000	28	63	false	false	true	false	false	mlet
01a0b5d0-c20f-7a81-958b-675b54095faf	JNJ	2026-09-18 14:39	put_frontspread	2	1	6783	542220.00	long	ask	271.3800	0.4500	["260","265"]	["0.2413","0.2460"]	["257.68"]	["SPHR"]	260.0000	265.0000	7	7	false	true	false	true
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	true	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	true	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	true	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	true	false
01a0b091-9aab-78d2-8d8d-cdac154f061e	JNJ	2026-09-17 14:12	call_diagonal_spread	2	1	18	138438.00	long	ask	268.7500	5.1500	["260","290"]	["0.2162","0.2103"]	[]	["XISX"]	260.0000	290.0000	456	855	false	false	true	true
01a0b060-70bb-77f0-8cb6-4319f70ddd61	JNJ	2026-09-17 13:18	call_vertical_spread	2	1	4	120400.00	long	ask	267.8451	4.2000	["115","120"]	["6.5517","6.3460"]	["119.98"]	["XISX"]	115.0000	120.0000	1	1	false	false	false	true
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	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	true	true
01a0afed-1d4b-7c10-8520-ceb3488dc140	JNJ	2026-09-17 11:12	put_frontspread	2	1	6300	441000.00	long	ask	269.2150	0.3800	["255","260"]	["0.2610","0.2652"]	["252.41","260"]	["SPHR"]	255.0000	260.0000	8	8	false	true	false	true
01a0afc8-861b-7782-9eee-9ce5d24327d1	JNJ	2026-09-17 10:32	call_diagonal_spread	2	2	156	110910.00	unknown	—	269.0151	0.7400	["270","310"]	["0.3093","0.2367"]	[]	["MCRY","SPHR"]	270.0000	310.0000	1	183	false	true	true	true	false	mlet
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	true	true
01a0aad9-8213-7631-a7a8-780f08c557f9	JNJ	2026-09-16 11:32	call_vertical_spread	2	1	4	143864.00	unknown	—	267.8500	5.2000	["85","90"]	["7.3068","7.1600"]	[]	["AMXO"]	85.0000	90.0000	2	2	false	false	false	true	false	mlet