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:code = mlet×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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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