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:source = uw_multileg×strategy = box_spread×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
01a06d29-26ad-7692-b041-35c6b4c9a3d9SPX2026-09-04 12:03box_spread41101357280.00shortbid7715.31004.8000["7000","8025"]["0.1906","0.1242"][]["XCBO"]7000.00008025.0000105105falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:03:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d30-98ed-7580-b852-0dbb12878827SPX2026-09-04 12:11box_spread415805935.00longask7720.00004.3000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:11:37Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d31-ecc5-7193-a2ca-0ef8d4bbe48aSPX2026-09-04 12:13box_spread415806170.00longask7720.98004.4000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-3ecd-71d2-adaa-5d08692245acSPX2026-09-04 12:13box_spread415806480.00longask7721.54004.8000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-4e6d-74b2-b8a2-a0f6413bcf80SPX2026-09-04 12:13box_spread415806480.00longask7721.54004.8000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-7d4d-7321-ba71-7416531297feSPX2026-09-04 12:13box_spread415806405.00longask7721.23004.6000["7000","8000"]["0.1916","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-db0d-7f31-a6e8-07d0f5ed9b88SPX2026-09-04 12:14box_spread415806445.00longask7721.49004.3000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:14:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d33-503d-7161-b2a0-4f037e84f663SPX2026-09-04 12:14box_spread4181290366.00longask7721.73004.7000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:14:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d36-74ed-7660-84f9-36223f3d63b7SPX2026-09-04 12:17box_spread41131178580.00shortbid7722.57003.1000["7700","7800"]["0.1393","0.1336"][]["XCBO"]7700.00007800.0000105105falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:18:31Z"}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
01a06d39-e3d5-7401-89c7-19f93267b5dfSPX2026-09-04 12:21box_spread41625680.00shortbid7726.17000.4000["7735","7750"]["0.1186","0.1310"]["0","7735","7750"]["XCBO"]7735.00007750.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:21:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d53-4005-7553-992a-1f30478c723cSPX2026-09-04 12:49box_spread412464972.00shortbid7728.10008.2000["7300","7500"]["0.1852","0.1770"][]["XCBO"]7300.00007500.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:49:50Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d5e-f41c-7c92-9c15-2e3e86674d45SPX2026-09-04 13:02box_spread412531192.00shortbid7723.44006.3000["6000","8000"]["0.2442","0.1433"][]["XCBO"]6000.00008000.0000224224falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:02:26Z"}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
01a06d6b-f055-7970-9677-e00fdb847090SPX2026-09-04 13:16box_spread414432308.00shortbid7718.62004.4000["7000","8000"]["0.1927","0.1064"][]["XCBO"]7000.00008000.00004242falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:16:28Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d86-3eb5-7e83-a86f-daef32786958SPX2026-09-04 13:45box_spread412436732.00shortbid7709.09005.5000["8000","9000"]["0.1601","0.1393"][]["XCBO"]8000.00009000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T17:45:08Z"}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
01a06dad-817d-7c12-b759-06eb14fcbb88SPX2026-09-04 14:27box_spread412211256.00shortbid7714.20002.2000["7500","8000"]["0.1539","0.1266"][]["XCBO"]7500.00008000.0000118118falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:28:25Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dae-2975-7770-bfc9-66c98fd91427SPX2026-09-04 14:28box_spread412411088.00longask7714.13006.6000["7500","8000"]["0.1772","0.1574"][]["XCBO"]7500.00008000.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:29:10Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dae-a675-75a0-a02b-2d6c49aac424SPX2026-09-04 14:29box_spread414586328.00shortbid7713.29004.4000["7000","8000"]["0.1917","0.1284"][]["XCBO"]7000.00008000.0000133133falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:29:59Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06daf-d726-77b1-a3df-1988d1461461SPX2026-09-04 14:30box_spread412211092.00shortbid7715.07002.5000["7500","8000"]["0.1536","0.1265"][]["XCBO"]7500.00008000.0000118118falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:31:18Z"}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
01a06db9-3595-70f0-ad53-065d74389a70SPX2026-09-04 14:40box_spread4161405656.00shortbid7714.53004.6000["6000","7980"]["0.2641","0.1290"][]["XCBO"]6000.00007980.0000133133falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:41:32Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dba-6e15-7b21-a31d-21dbaed1de87SPX2026-09-04 14:42box_spread413625962.00longask7715.14005.4000["7000","8000"]["0.1949","0.1508"][]["XCBO"]7000.00008000.0000286286falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:42:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dbd-c58d-7723-b265-cbdf410c7707SPX2026-09-04 14:45box_spread412554848.00longask7716.740010.5000["7000","7800"]["0.1984","0.1723"][]["XCBO"]7000.00007800.0000469469falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:46:13Z"}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
01a06dcf-9bf5-7ae3-af76-bf1f6c5bebbfSPX2026-09-04 15:05box_spread41132125292.00longask7712.91008.6000["7300","7700"]["0.1745","0.1537"][]["XCBO"]7300.00007700.0000208208falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:05:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd1-da2d-7ae2-96e8-f45ce274efa3SPX2026-09-04 15:07box_spread41142772112.00longask7712.52005.0000["7300","7700"]["0.1815","0.1633"][]["XCBO"]7300.00007700.0000286286falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:07:50Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd7-dd3e-7990-b7d5-8a67f8696748SPX2026-09-04 15:14box_spread412436500.00shortbid7712.51007.1000["8000","9000"]["0.1601","0.1392"][]["XCBO"]8000.00009000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:14:49Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd7-e8f5-7032-8f39-c971d58ec705SPX2026-09-04 15:14box_spread4151211630.00longask7712.06007.4000["7000","8000"]["0.1967","0.1601"][]["XCBO"]7000.00008000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:14:49Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd9-c96d-7d63-8636-2d8a7cd57059SPX2026-09-04 15:16box_spread422436506.00longask7711.780012.8000["8000","9000"]["0.1602","0.1392"][]["XCBO"]8000.00009000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:16:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de4-48ed-71d0-b350-ce89b85f5ea4BE2026-09-04 15:27box_spread41100360600.00longask249.12505.6000["255","260"]["10.6023","10.3882"]["0","255","260"]["XPHO"]255.0000260.000000falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:28:02Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de7-468d-7082-90e9-df9d182c9cedSPX2026-09-04 15:31box_spread414824736.00longask7715.01007.4000["7500","8000"]["0.1777","0.1579"][]["XCBO"]7500.00008000.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:31:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06deb-8095-7dd2-8ea3-aa0d1049b83dSPX2026-09-04 15:35box_spread4121088572.00shortbid7715.0100133.5000["6000","7000"]["0.2233","0.2098"][]["XCBO"]6000.00007000.000012041204falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:36:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dec-5b55-7b02-8664-68b27887d5bfSPX2026-09-04 15:36box_spread4161713876.00longask7715.21008.9000["6900","6950"]["0.2021","0.2001"][]["XCBO"]6900.00006950.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:36:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
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
01a06df0-3f6d-7981-82af-ccb3daaa2f75SPX2026-09-04 15:40box_spread4194215618.00shortbid7713.830039.1000["6000","7000"]["0.2243","0.2047"][]["XCBO"]6000.00007000.0000833833falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:41:10Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df7-a20d-7060-99de-55d9aa5e78ddSPX2026-09-04 15:48box_spread416195654.00shortbid7716.80001.9000["7650","7700"]["0.1136","0.1084"][]["XCBO"]7650.00007700.00001919falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:49:04Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a08136-859a-7e82-8160-940fb3bae035SPX2026-09-08 09:30box_spread41227230.00shortbid7710.92005.3000["7725","7820"]["0.1397","0.2605"][]["XCBO"]7725.00007820.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:30:19Z"}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
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
01a08155-1af0-7333-84c3-0a46f58d018dSPX2026-09-08 10:03box_spread4161903056.00shortbid7683.880032.6000["6500","7500"]["0.2155","0.1838"][]["XCBO"]6500.00007500.0000465465falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:04:12Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08164-e9d1-7873-89ae-0674a0e26834SPX2026-09-08 10:21box_spread412414438.00longask7683.360027.0000["6650","7050"]["0.2209","0.1909"][]["XCBO"]6650.00007050.0000114114falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:21:32Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0816c-6f98-75e3-abe8-ed8b521b24efSPX2026-09-08 10:29box_spread41240756.00shortbid7680.02001.1000["7645","7650"]["0.1151","0.1144"][]["XCBO"]7645.00007650.000077falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:29:39Z"}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
01a0818a-8e88-7c83-9e46-ef3dd89351e8SPX2026-09-08 11:02box_spread41584480.00shortbid7691.95002.0000["7650","7750"]["0.1408","0.1239"][]["XCBO"]7650.00007750.000033falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:02:25Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08197-9678-7c83-b997-7c4c799f0b33SPX2026-09-08 11:16box_spread412928622.00shortbid7697.510040.5000["6000","7050"]["0.2253","0.2044"][]["XCBO"]6000.00007050.0000829829falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:16:53Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0819c-af28-7cb2-bec9-715c62967a61SPX2026-09-08 11:22box_spread412211590.00unknown—7691.13005.5000["7190","8190"]["0.1823","0.1146"][]["XCBO"]7190.00008190.00003838falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:22:13Z"}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
01a081b4-8c88-78e3-b9c6-b60c72c7e81aSPX2026-09-08 11:48box_spread414865852.00shortbid7692.37005.5000["7675","7700"]["0.1730","0.1721"][]["XCBO"]7675.00007700.0000374374falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:48:07Z"}2026-09-082026-09-08 21:502026-09-08 21:50