Simplify Analytics
← Data Explorer

Multi-leg option trades

core.multileg_trades

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

312,778 rowsCSV — whole table, not this view

Sources in this table

executed_at (ET days)to
column equals (exact text)
sort
chart against executed_at
reset
active:ticker = JNJ×sorted by executed_at ↑×
idtexttickertextexecuted_at ↑timestamp with time zonestrategytextleg_countintegertxnsintegersizebiginttotal_premiumnumericdirectiontextnet_sidetextunderlying_pricenumericbid_ask_spreadnumericstrikesjsonbivsjsonbbreakevensjsonbuniq_exchangesjsonbmin_strikenumericmax_strikenumericmin_dteintegermax_dteintegerall_opening_legsbooleanall_otmbooleandiff_expirationsbooleandiff_strikesbooleandiff_typesbooleancodetextkept_bytextsourcetextendpointtextrequest_paramsjsonbas_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zone
01a06d3e-836d-7982-ac3e-6f7a8cc0198eJNJ2026-09-04 12:26call_vertical_spread214107048.00longask276.49502.8000["140","145"]["2.2928","2.2649"]["144.98"]["XCBO"]140.0000145.000077falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:27:05Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d40-63e6-7240-a173-f7948484a001JNJ2026-09-04 12:28call_vertical_spread214107064.00longask276.44002.7000["140","145"]["2.3411","2.3048"]["144.98"]["XCBO"]140.0000145.000077falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:29:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a0814b-89b8-78b3-b4f6-8b92b4c5e4d3JNJ2026-09-08 09:53other2114188104.00unknown—269.56027.7500["220","230"]["0.1986","0.1946"][]["XCBO"]220.0000230.0000500829falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:53:42Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081cc-3ef0-7b63-8267-1b429f13bc93JNJ2026-09-08 12:13call_vertical_spread213111573.00longask268.60002.4000["80","85"]["3.3098","3.1459"]["84.97"]["XPHO"]80.000085.00001010falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:14:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08243-5f08-7f60-8c25-704168efb6a6JNJ2026-09-08 14:24call_calendar2113165620.00shortask270.65504.9500["210"]["0.3021"][]["XISX"]210.0000210.000038192falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:24:11Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08706-0b81-7b31-a9d4-ceba1f337808JNJ2026-09-09 12:35put_vertical_spread21250346500.00unknown—267.39001.0500["220","260"]["0.2892","0.2683"][]["XBOX"]220.0000260.0000128128falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:35:31Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a087b7-0c00-70b2-913c-c9446c5d796dJNJ2026-09-09 15:48strangle_swap41125203375.00unknown—268.28990.9000["260","280"]["0.2509","0.2461"][]["XMIO"]260.0000280.00003037falsetruetruetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:48:40Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08cb5-b7d8-78d3-8226-fac8c0b5ef3cJNJ2026-09-10 15:05other3176159640.00unknown—266.81006.9000["275","277.5","280"]["0.5708","0.9447","1.0535"][]["XBOX"]275.0000280.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:05:25Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0918e-9400-7261-824a-beaa363c1a02JNJ2026-09-11 13:40risk_reversal22400920000.00shortbid265.81000.7500["250","270"]["0.2644","0.2446"]["276.66"]["AMXO"]250.0000270.0000126126falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:40:40Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09196-b608-7771-8e23-3d5e63817c09JNJ2026-09-11 13:49other22120100680.00unknown—265.84000.4500["260","265"]["0.2571","0.3555"][]["ARCO","C2OX"]260.0000265.0000070falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:49:38Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09196-b220-7f60-b717-ac6e2496976bJNJ2026-09-11 13:49other22120100680.00unknown—265.84000.4500["260","265"]["0.2571","0.3555"][]["ARCO","C2OX"]260.0000265.0000070falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:49:38Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09196-b9f0-7a91-b659-48fc81394e92JNJ2026-09-11 13:49other22120100650.00unknown—265.84000.4500["260","265"]["0.2571","0.3555"][]["ARCO","C2OX"]260.0000265.0000070falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:49:38Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091b6-3c58-7b83-ac3e-a7ffbaaea01dJNJ2026-09-11 14:23other22120100950.00unknown—265.54000.4200["260","265"]["0.2542","0.4023"][]["ARCO","C2OX"]260.0000265.0000070falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:24:15Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0a025-f9b8-72e1-8e0d-cf89dd847494JNJ2026-09-14 09:40call_diagonal_spread2110121360.00longbid269.60006.2500["200","220"]["1.5628","0.4441"][]["XMIO"]200.0000220.0000432falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:40:39Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a558-b8ce-7a01-b6ea-c608ad48c88fJNJ2026-09-15 09:54put_diagonal_spread2146001749312.00unknown—261.25001.8700["255","265"]["0.2593","0.2717"][]["XBOX"]255.0000265.0000310falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:54:39Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a563-20de-7e60-b3cc-789b87444f5bJNJ2026-09-15 10:05put_diagonal_spread21455369943.00shortbid261.39000.8600["260","265"]["0.2933","0.2401"][]["XMIO"]260.0000265.0000310falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:05:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a566-8026-7513-be33-465f949ca4c6JNJ2026-09-15 10:09call_diagonal_spread21324141264.00shortbid262.16000.6800["270","300"]["0.2818","0.2364"][]["SPHR"]270.0000300.00003122falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:09:12Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5d2-365e-7c90-a6a6-fe4e703020baJNJ2026-09-15 12:06call_vertical_spread217254450.00longask264.12504.2000["80","85"]["5.0301","4.8837"]["84.98"]["XISX"]80.000085.000033falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:07:21Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a670-240e-7e93-9330-acb56bc4082dJNJ2026-09-15 14:59call_calendar2115225600.00shortbid265.58002.0000["210"]["0.1907"][]["XISX"]210.0000210.0000493822falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:00:00Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a689-e5ce-7433-bf84-bfda24815721JNJ2026-09-15 15:27call_diagonal_spread22156460372.00unknown—265.71005.4000["250","270"]["0.2428","0.2352"][]["XCBO"]250.0000270.0000122213falsefalsetruetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:27:53Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0aad6-6d03-7b33-8400-c603d0d8abc7JNJ2026-09-16 11:29strangle2741161950.00shortbid267.69500.8671["250","360"]["0.2865","0.2115"]["210.5","399.50"]["MCRY","XCBO","XISX","XPHO"]250.0000360.0000821821falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:29:34Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aad9-8213-7631-a7a8-780f08c557f9JNJ2026-09-16 11:32call_vertical_spread214143864.00unknown—267.85005.2000["85","90"]["7.3068","7.1600"][]["AMXO"]85.000090.000022falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:33:01Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab6e-d88b-7bc3-9859-83ec5000952eJNJ2026-09-16 14:16call_diagonal_spread2166133914.00shortbid268.26001.5000["260","270"]["0.4214","0.2479"][]["SPHR"]260.0000270.0000265falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:16:01Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0afc8-861b-7782-9eee-9ce5d24327d1JNJ2026-09-17 10:32call_diagonal_spread22156110910.00unknown—269.01510.7400["270","310"]["0.3093","0.2367"][]["MCRY","SPHR"]270.0000310.00001183falsetruetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:32:34Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afed-1d4b-7c10-8520-ceb3488dc140JNJ2026-09-17 11:12put_frontspread216300441000.00longask269.21500.3800["255","260"]["0.2610","0.2652"]["252.41","260"]["SPHR"]255.0000260.000088falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:12:31Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b030-583b-7f92-9b23-18c96b6d5f7dJNJ2026-09-17 12:25call_diagonal_spread21175243250.00shortask268.20001.9000["260","300"]["0.5097","0.2368"][]["SPHR"]260.0000300.00001120falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:26:24Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b04b-cf7b-7c41-9ebf-65492dbff30bJNJ2026-09-17 12:55risk_reversal21200440000.00shortbid267.89001.3500["250","290"]["0.2756","0.2372"]["291.30"]["XBOX"]250.0000290.0000183183falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:55:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b060-70bb-77f0-8cb6-4319f70ddd61JNJ2026-09-17 13:18call_vertical_spread214120400.00longask267.84514.2000["115","120"]["6.5517","6.3460"]["119.98"]["XISX"]115.0000120.000011falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:18:35Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b091-9aab-78d2-8d8d-cdac154f061eJNJ2026-09-17 14:12call_diagonal_spread2118138438.00longask268.75005.1500["260","290"]["0.2162","0.2103"][]["XISX"]260.0000290.0000456855falsefalsetruetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:12:38Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b52b-75a8-7933-b236-cf2fa8d8b259JNJ2026-09-18 11:38call_calendar2150157500.00shortbid269.35850.6000["260"]["0.2607"][]["XISX"]260.0000260.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:39:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b52e-a60f-7123-be45-451d8ca47a3eJNJ2026-09-18 11:42call_calendar249503016250.00shortbid269.28002.5500["260"]["0.2666"][]["XCBO"]260.0000260.00002863falsefalsetruefalsefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:42:11Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b563-0067-7c62-ba33-66811354aa3bJNJ2026-09-18 12:39call_diagonal_spread21265125610.00shortbid269.72011.1500["280","285"]["0.2481","0.2245"][]["SPHR"]280.0000285.0000735falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:39:40Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b579-d80f-7732-8ae3-64307bcbff4cJNJ2026-09-18 13:04call_calendar21100206400.00unknownbid269.96500.8500["270"]["0.2604"][]["XISX"]270.0000270.00002863falsetruetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:04:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d0-c20f-7a81-958b-675b54095fafJNJ2026-09-18 14:39put_frontspread216783542220.00longask271.38000.4500["260","265"]["0.2413","0.2460"]["257.68"]["SPHR"]260.0000265.000077falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:39:24Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5db-b6bf-75d2-9924-0f1d9a948b27JNJ2026-09-18 14:51call_calendar2150111500.00unknown—271.62001.0000["270"]["0.2583"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:51:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5dc-1c4f-7b31-9344-6a4145b2f229JNJ2026-09-18 14:51call_calendar2150111200.00unknownbid271.73001.4500["270"]["0.2557"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:51:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5de-3f2f-73f1-a5c8-9eb6938be05bJNJ2026-09-18 14:53call_calendar21100222400.00unknownbid271.67000.9000["270"]["0.2567"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:54:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5df-73c8-7da1-866b-b5635a4ee5e1JNJ2026-09-18 14:55call_calendar21100222400.00unknownbid271.62000.9000["270"]["0.2575"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:55:34Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e0-2b5f-7711-9f1c-7ef5b6701312JNJ2026-09-18 14:55call_calendar21200444800.00unknownbid271.60500.9000["270"]["0.2577"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:56:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e0-b418-7ec3-8b2b-93d7cb7f119bJNJ2026-09-18 14:56call_calendar22200444000.00unknown—271.67000.8000["270"]["0.2561"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:57:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e2-1b78-78b0-b9a2-2319a3240f36JNJ2026-09-18 14:58call_calendar21200444000.00shortask271.63000.7500["270"]["0.2568"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:58:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e3-7338-7531-9399-6cdec5e35441JNJ2026-09-18 14:59call_calendar21200444000.00shortask271.55000.7500["270"]["0.2580"][]["XISX"]270.0000270.00002863falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:59:36Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-fc27-7b93-bf45-cb11b4b8778dJNJ2026-09-18 15:59call_diagonal_spread2110113560.00unknownbid270.06006.2500["210","220"]["0.4927","0.3281"][]["XCBO"]210.0000220.00002863falsefalsetruetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15