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 = mlat×direction = short×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
01a0b617-ecd0-7883-884e-9cda44d9de2dSPX2026-09-18 15:56box_spread41101154150.00shortbid7646.89005.1000["7000","8000"]["0.1955","0.1155"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:57:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fc-7d5f-7372-beb2-63845b39ae89SPX2026-09-18 15:26box_spread4121041992.00shortbid7640.3300150.0000["6000","7400"]["0.2238","0.2025"][]["XCBO"]6000.00007400.000011901190falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:26:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5fa-9517-7a32-8b63-5a9a94513fadSPX2026-09-18 15:24box_spread41285582.00shortbid7640.04005.6000["7600","7800"]["0.1255","0.1051"][]["XCBO"]7600.00007800.00002828falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:25:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ea-9370-72a3-9b46-2972ff24ab8aSPX2026-09-18 15:07box_spread412714508.00shortbid7641.490011.2000["6000","7250"]["0.2295","0.1904"][]["XCBO"]6000.00007250.0000455455falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:07:33Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b590-32b8-71e1-812a-42ecf971378aSPX2026-09-18 13:28box_spread413795120.00shortbid7625.96008.7000["7100","7700"]["0.1950","0.1751"][]["XCBO"]7100.00007700.0000455455falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:29:16Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b57c-b66f-7a12-9994-10064877d0e9SPX2026-09-18 13:07box_spread41269350.00shortbid7624.680010.2000["7500","7750"]["0.1345","0.0994"][]["XCBO"]7500.00007750.00001414falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:08:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b549-0fc7-72d2-aa5a-61c7e63b3f8bSPX2026-09-18 12:10box_spread412326770.00shortbid7621.59004.2000["7000","8000"]["0.1915","0.1379"][]["XCBO"]7000.00008000.0000182182falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:11:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b548-bdc0-7c81-afa4-3dec8505ca23SPX2026-09-18 12:10box_spread412326758.00shortbid7622.02003.8000["7000","8000"]["0.1915","0.1378"][]["XCBO"]7000.00008000.0000182182falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:11:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b510-38ff-7873-be3e-189cf60caf6dSPX2026-09-18 11:08box_spread412445378.00shortbid7629.66005.3000["6000","7265"]["0.2524","0.1702"][]["XCBO"]6000.00007265.00006363falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:09:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b502-6207-7843-a41a-ff02901db279SPX2026-09-18 10:53box_spread413651585.00shortbid7629.10005.6000["6000","8130"]["0.2777","0.1168"][]["XCBO"]6000.00008130.00006363falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:54:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ee-7c48-7512-88e5-4ec0b0c3f65bSPX2026-09-18 10:32box_spread4121147132.00shortbid7621.8800161.8000["5950","6200"]["0.2227","0.2199"][]["XCBO"]5950.00006200.000011901190falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:32:03Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4da-d8ef-7200-a505-d7e6b1fef19fSPX2026-09-18 10:10box_spread415454720.00shortbid7627.08002.6000["7500","7700"]["0.1531","0.1388"][]["XCBO"]7500.00007700.00009191falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:10:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c5-8bcf-7331-9ce9-b6087d9a22fdBE2026-09-18 09:47box_spread415140070.00shortbid274.21009.8200["125","170"]["0.9191","0.8642"][]["XCBO"]125.0000170.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:47:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0f1-eaeb-7d30-a4a7-de7e9015b9c1SPX2026-09-17 15:57box_spread412174326.00shortbid7642.68002.1000["7620","7725"]["0.1452","0.1380"][]["XCBO"]7620.00007725.00009292falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:57:28Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a8-56fc-7793-89d1-a5d052426f43SPX2026-09-17 14:36box_spread4132776254.00shortbid7634.2700818.6000["2800","5000"]["0.3246","0.2501"][]["XCBO"]2800.00005000.000019191919falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:37:26Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b088-8e43-7032-9b24-9dec94930beeSPX2026-09-17 14:02box_spread413986808.00shortbid7638.050010.6000["6000","8050"]["0.2276","0.1633"][]["XCBO"]6000.00008050.0000456456falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:02:43Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afeb-3cd3-73f2-8ae0-51a295577a49SPX2026-09-17 11:10box_spread412232758.00shortbid7618.55004.8000["7000","8000"]["0.1994","0.1190"][]["XCBO"]7000.00008000.00006464falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:10:50Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab62-8833-7f93-978a-bba70c92b91aSPX2026-09-16 14:02box_spread4161312824.00shortbid7603.160021.1000["6000","7520"]["0.2831","0.1550"][]["XCBO"]6000.00007520.00009393falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:02:47Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab2d-c84b-7ff2-b92f-9f2da95a7c73SPX2026-09-16 13:04box_spread412445212.00shortbid7605.20006.5000["7000","8000"]["0.1982","0.1561"][]["XCBO"]7000.00008000.0000338338falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:05:34Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab2d-149b-73b0-9556-6a03f8f4a1e8SPX2026-09-16 13:04box_spread412398454.00shortbid7604.72006.3000["7000","8000"]["0.1963","0.1497"][]["XCBO"]7000.00008000.0000274274falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:04:28Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaee-d703-7290-9e02-af226eee3fc4SPY2026-09-16 11:56box_spread4110215620.00shortbid760.81001.0200["755","775"]["0.1789","0.1731"][]["XPHO"]755.0000775.0000366366falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:56:33Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a6a6-e795-7342-8d47-0da08b830dddSPX2026-09-15 15:59box_spread4171473948.00shortbid7584.99005.1000["7600","7650"]["0.1733","0.1714"][]["XCBO"]7600.00007650.0000367367falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:59:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a62b-145d-7af0-a05b-977e8fdbdeafSPX2026-09-15 13:43box_spread4152218245.00shortbid7582.0700102.1000["7000","8000"]["0.2072","0.1896"][]["XCBO"]7000.00008000.000011931193falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:43:55Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a624-e656-7130-847d-0658901b04e7SPX2026-09-15 13:37box_spread412834016.00shortbid7581.680035.7000["6000","7850"]["0.2221","0.1823"][]["XCBO"]6000.00007850.0000822822falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:37:56Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a611-6a0d-7e50-add7-4157af9e74cdSPX2026-09-15 13:15box_spread412349808.00shortbid7581.73005.5000["7000","8000"]["0.1952","0.1421"][]["XCBO"]7000.00008000.0000213213falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:16:18Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a609-3c4e-7391-bd35-f5ae7b135a25SPX2026-09-15 13:06box_spread415468230.00shortbid7583.59003.2000["7500","7700"]["0.1578","0.1426"][]["XCBO"]7500.00007700.00009494falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:07:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a584-9b2e-7983-afad-5026859803faSPX2026-09-15 10:42box_spread412384246.00shortbid7581.84007.3000["7500","7600"]["0.1742","0.1696"][]["XCBO"]7500.00007600.0000304304falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:42:05Z"}2026-09-152026-09-15 19:282026-09-15 19:28
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
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
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
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
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
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