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.

403,968 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 = mlat×strategy = box_spread×
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
01a0a575-02fd-7980-beaa-2d8722c179bfSPX2026-09-15 10:25box_spread413240630.00unknown—7587.86003.6000["7435","7770"]["0.1618","0.1325"][]["XCBO"]7435.00007770.00006666falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:25:23Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a573-f18e-7fe0-bc7b-2879e11a92f7SPX2026-09-15 10:23box_spread41251270.00unknown—7583.49001.3000["7535","7540"]["0.1577","0.1565"][]["XCBO"]7535.00007540.000066falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:23:59Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a550-d15e-7793-94aa-b7ed790e5620SPX2026-09-15 09:45box_spread413641109.00unknown—7613.40005.5000["6000","7420"]["0.3012","0.1627"][]["XCBO"]6000.00007420.00006666falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:45:48Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a15c-4b20-70f0-a78a-2667ce8f38f5SPX2026-09-14 15:19box_spread412508610.00unknown—7630.71005.4000["6000","8275"]["0.2542","0.1311"][]["XCBO"]6000.00008275.0000186186falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:19:36Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a12d-d880-7971-9a5b-715a15b98b4aSPX2026-09-14 14:28box_spread412402982.00shortbid7632.570040.7000["6000","8000"]["0.4203","0.1069"][]["XCBO"]6000.00008000.00003232falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:29:13Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a063-6461-7d71-9db4-1b2c43f81578SPX2026-09-14 10:47box_spread4161215210.00unknown—7598.830011.1000["6000","8010"]["0.3549","0.1126"][]["XCBO"]6000.00008010.00003232falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:47:57Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091d7-aed8-7692-9460-e0fa9456a634SPX2026-09-11 15:00box_spread412926482.00longask7663.790036.6000["6000","7000"]["0.2251","0.2046"][]["XCBO"]6000.00007000.0000826826falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:00:53Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090cc-0b38-7c13-9dec-d1d65151d3dcSPX2026-09-11 10:08box_spread412886730.00shortbid7664.550085.8000["7400","7900"]["0.2032","0.1944"][]["XCBO"]7400.00007900.000011971197falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:08:27Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08ce2-9ff0-7d80-8388-78dbb0c0478cSPX2026-09-10 15:54box_spread4141649432.00shortbid7590.530022.9000["6000","7000"]["0.2302","0.2033"][]["XCBO"]6000.00007000.0000645645falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:54:16Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cdd-8b28-77c1-a9d4-6ccb8d0ea1a5SPX2026-09-10 15:48box_spread412666898.00shortbid7591.76008.8000["6000","7000"]["0.2445","0.2013"][]["XCBO"]6000.00007000.0000344344falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:49:04Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cdc-1bf8-7db2-b8e3-c9f2836ed78fSPX2026-09-10 15:47box_spread415536135.00unknown—7591.62007.5000["7000","8000"]["0.2216","0.1131"][]["XCBO"]7000.00008000.00003636falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:47:30Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cb1-5aa9-7473-82e1-f85840ca3455SPX2026-09-10 15:00box_spread412484124.00unknown—7590.68008.5000["7550","7850"]["0.1819","0.1719"][]["XCBO"]7550.00007850.0000463463falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:00:58Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c6c-4711-7461-aa28-f03f240766bcSPX2026-09-10 13:44box_spread4151324950.00shortbid7597.400010.4000["7000","8000"]["0.2010","0.1674"][]["XCBO"]7000.00008000.0000463463falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:45:05Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b83-0c54-7ee3-9509-c4e609d7080dSPX2026-09-10 09:30box_spread412423772.00shortbid7591.980028.6000["7675","7700"]["0.1739","0.1726"][]["XCBO"]7675.00007700.0000372372falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:30:08Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a087b5-cf98-7502-93a8-4935ba36dd05SPX2026-09-09 15:47box_spread412475770.00unknown—7641.28006.2000["7000","8000"]["0.1985","0.1612"][]["XCBO"]7000.00008000.0000373373falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:47:26Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a087b2-f520-7b61-8a45-19a60b267bedSPX2026-09-09 15:44box_spread415891265.00shortbid7641.57003.8000["7500","8000"]["0.1742","0.1525"][]["XCBO"]7500.00008000.0000281281falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:44:24Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0878a-c410-79a1-8989-1bb2c9cc475dSPX2026-09-09 15:00box_spread412758922.00unknown—7643.44007.7000["6000","9700"]["0.2406","0.1349"][]["XCBO"]6000.00009700.0000345345falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:00:25Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08785-1ad8-7110-93e8-358fcbabbe19SPX2026-09-09 14:53box_spread412559588.00shortbid7648.14005.3000["6000","8000"]["0.2436","0.1527"][]["XCBO"]6000.00008000.0000281281falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:54:38Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0870d-8591-7a91-b3a1-03cad3ab500cSPX2026-09-09 12:43box_spread413632178.00shortbid7636.01005.2000["7550","8050"]["0.1781","0.1601"][]["XCBO"]7550.00008050.0000373373falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:44:02Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08701-f4a1-72f1-95e0-20c4fda7c616SPX2026-09-09 12:30box_spread4161403724.00shortbid7632.05006.4000["7200","7700"]["0.1917","0.1726"][]["XCBO"]7200.00007700.0000373373falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:31:37Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08297-3fb0-71d2-9c82-4a3917d0f476SPX2026-09-08 15:55box_spread41101117030.00shortbid7672.48004.7000["7600","7650"]["0.1528","0.1496"][]["XCBO"]7600.00007650.0000129129falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:56:03Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0822a-4158-7691-9e20-b022e247ec41SPX2026-09-08 13:56box_spread4121285114.00shortbid7691.79001017.4500["6000","7600"]["0.2219","0.2091"][]["XCBO"]6000.00007600.000019281928falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:56:43Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081a7-3290-7742-83d1-3ca2ab6589dbSPX2026-09-08 11:33box_spread4161449948.00longask7692.52006.8000["7000","8000"]["0.1985","0.1616"][]["XCBO"]7000.00008000.0000374374falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:33:34Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0817d-bd48-7870-92ae-5ecd0f405143SPX2026-09-08 10:48box_spread414872224.00longask7686.41007.2000["7000","8000"]["0.1980","0.1550"][]["XCBO"]7000.00008000.0000311311falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:48:25Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0814a-aef8-7732-aaff-60ce02f17eacSPX2026-09-08 09:52box_spread413404448.00longask7687.73004.2000["7000","8000"]["0.1959","0.1297"][]["XCBO"]7000.00008000.0000101101falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:52:48Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08148-0360-7280-95ba-0fdb4cdd0cbfSPX2026-09-08 09:49box_spread4151062120.00longask7692.45005.6000["7700","7800"]["0.1721","0.1685"][]["XCBO"]7700.00007800.0000374374falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:49:41Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06ded-edad-7383-b28b-3bf6bd3795ecSPX2026-09-04 15:38box_spread414969792.00longask7712.60006.9000["7000","8000"]["0.1968","0.1602"][]["XCBO"]7000.00008000.0000378378falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:38:37Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dce-210e-7a10-8179-471e6be313deSPX2026-09-04 15:03box_spread415602920.00longask7714.10007.9000["7300","7700"]["0.1682","0.1411"][]["XCBO"]7300.00007700.0000118118falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:03:44Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06db0-b5cd-7a62-93ff-18cdf4addf77SPX2026-09-04 14:31box_spread41102132280.00shortbid7714.31005.4000["7725","7750"]["0.1694","0.1685"][]["XCBO"]7725.00007750.0000378378falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:32:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d90-8f55-7b01-ba56-70a47fe8bc3fSPX2026-09-04 13:56box_spread4184014440.00shortbid7708.9000105.7000["6000","8200"]["0.2226","0.1877"][]["XCBO"]6000.00008200.000012041204falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:56:56Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d69-063d-78e1-a76a-e12b933d3de5SPX2026-09-04 13:13box_spread4121178776.00shortbid7719.9200908.0000["6000","7500"]["0.2210","0.2056"][]["XCBO"]6000.00007500.000015681568falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:13:28Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d38-5d35-7300-964f-a6ea4fb8d11aSPX2026-09-04 12:20box_spread418725792.00shortbid7723.76002.9000["7700","7800"]["0.1394","0.1336"][]["XCBO"]7700.00007800.0000105105falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:20:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53