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.

367,592 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:direction = long×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
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
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
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
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
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
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
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
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