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:code = mlft×ticker = JNJ×
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
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
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
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
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
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
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
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
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
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
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