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 = 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
01a0c584-00ef-72b1-ae58-af052642ace7SPX2026-09-21 15:49box_spread412836594.00longask7772.70005.9000["5700","5800"]["0.3406","0.2853"][]["XCBO"]5700.00005800.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:49:18Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c582-dbf7-74b1-9bdf-bbdaf561a94eSPX2026-09-21 15:48box_spread4192480526.00longask7773.51008.6000["7000","7300"]["0.2032","0.1915"][]["XCBO"]7000.00007300.0000361361falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:48:24Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c57d-bb76-7b70-af3d-90fda09e4f31SPX2026-09-21 15:42box_spread412578238.00shortbid7774.46006.5000["6000","7275"]["0.2593","0.1818"][]["XCBO"]6000.00007275.0000179179falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:42:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c578-e146-7191-913d-9c80548d0062SPX2026-09-21 15:37box_spread412206756.00longask7775.43002.6000["7550","8140"]["0.1566","0.1259"][]["XCBO"]7550.00008140.0000101101falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:37:16Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c578-1df7-7891-94d0-26e369f1bf2eSPX2026-09-21 15:36box_spread412716350.00unknown—7775.27008.7000["6000","7000"]["0.2445","0.2030"][]["XCBO"]6000.00007000.0000333333falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:36:19Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c575-1886-7eb0-872a-b772c93bb008SPX2026-09-21 15:32box_spread412206654.00shortbid7773.19002.5000["7550","8140"]["0.1565","0.1258"][]["XCBO"]7550.00008140.0000101101falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:33:26Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c574-87ff-7522-b4c5-9d435f773352SPX2026-09-21 15:32box_spread41101933620.00longask7772.96005.0000["6500","7500"]["0.2439","0.1596"][]["XCBO"]6500.00007500.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:32:27Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c55b-3786-7e43-9e0a-3574fae51dedSPX2026-09-21 15:04box_spread41589670.00longask7772.60008.2500["7800","7900"]["0.1017","0.1239"][]["XCBO"]7800.00007900.000022falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:04:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c558-e1df-7332-abf6-5c0724503420XSP2026-09-21 15:02box_spread413378427.80shortbid777.25002.8700["700","800"]["0.2030","0.1624"][]["XCBO"]700.0000800.0000333333falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:02:21Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c54c-b0c7-7120-8ad9-74fa0870e927SPX2026-09-21 14:48box_spread41331356.00unknown—7772.92002.7000["7710","7770"]["0.1288","0.1079"][]["XCBO"]7710.00007770.000011falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:49:04Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c549-12ff-7a30-936b-a2aca723e37dSPX2026-09-21 14:44box_spread41101027400.00shortbid7770.77004.5000["7250","8250"]["0.1892","0.1175"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:45:02Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53d-2067-7502-a7ec-2fe310b86fe4QQQ2026-09-21 14:31box_spread411685840.00shortbid740.37000.2600["742","746"]["0.1740","0.1716"][]["XCBO"]742.0000746.00002525falsefalsefalsetruetruemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:32:11Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c53b-d45f-7033-8476-2e469105d34dSPX2026-09-21 14:30box_spread41101027700.00shortbid7768.76004.4000["7250","8250"]["0.1885","0.1190"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:30:31Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c539-4fd6-7a72-b86d-8611549e3c20SPX2026-09-21 14:27box_spread41101027650.00unknown—7767.70004.8000["7250","8250"]["0.1892","0.1176"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:27:43Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a4-a926-7333-8ee3-e903376e3b56SPX2026-09-21 11:45box_spread416872004.00shortbid7738.50004.9000["7400","7900"]["0.1722","0.1456"][]["XCBO"]7400.00007900.0000179179falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:45:28Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c49b-fa7f-7c40-aa66-eefef3c2b2d5SPX2026-09-21 11:35box_spread413599742.00shortbid7729.01006.7000["7400","7500"]["0.1796","0.1750"][]["XCBO"]7400.00007500.0000269269falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:35:55Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c481-562e-7692-8915-328dadb40074SPX2026-09-21 11:06box_spread414531968.00shortbid7725.010012.3000["7200","8200"]["0.1816","0.1235"][]["XCBO"]7200.00008200.0000116116falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c481-2b36-7413-9bc4-1aa48c40ca6cSPX2026-09-21 11:06box_spread4181043744.00longask7724.88006.1000["7000","8000"]["0.1976","0.1256"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:07:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47c-dda6-7ec3-bce7-435b2c773f5aSPX2026-09-21 11:01box_spread4151076180.00longask7722.43006.7000["8000","9000"]["0.1621","0.1382"][]["XCBO"]8000.00009000.0000361361falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:02:15Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c465-330e-7ce2-8ff0-1473ac6363c0SPX2026-09-21 10:35box_spread4141694012.00longask7721.840024.5000["4500","7000"]["0.4324","0.1974"][]["XCBO"]4500.00007000.0000116116falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:36:03Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c44f-229f-78e3-9397-a42b68256767SPX2026-09-21 10:11box_spread412366122.00longask7705.280022.9000["6500","7500"]["0.2406","0.1556"][]["XCBO"]6500.00007500.00008888falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:11:58Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c445-b877-71f2-9af5-f30910c896daSPX2026-09-21 10:01box_spread412701326.00longask7707.290026.6000["7450","8050"]["0.1944","0.1811"][]["XCBO"]7450.00008050.0000816816falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:01:49Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c436-1876-7d52-a94c-b78168e9f475SPX2026-09-21 09:44box_spread412475928.00longask7697.87008.5000["7000","8050"]["0.2002","0.1592"][]["XCBO"]7000.00008050.0000361361falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T13:44:46Z"}2026-09-212026-09-21 17:152026-09-21 17:15
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
01a0b5f2-9a1f-76f3-bc62-ff451cbe2e0dSPX2026-09-18 15:16box_spread412276376.00longask7641.67004.8000["7000","8000"]["0.1938","0.1257"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:16:14Z"}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
01a0b5e3-5fb0-71b2-852f-ddf7747f9738SPX2026-09-18 14:59box_spread412410520.00longask7642.08003.6000["6000","7925"]["0.2869","0.1178"][]["XCBO"]6000.00007925.00006363falsefalsefalsetruetruemlatmarket_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
01a0b5cf-c427-7782-97ff-3ec40ec031c2SPX2026-09-18 14:38box_spread415244400.00longask7633.700010.6000["7430","7830"]["0.1452","0.0980"][]["XCBO"]7430.00007830.00002121falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5af-18df-73e0-b130-0fa439673bcbSPX2026-09-18 14:02box_spread412207212.00longask7629.22005.0000["7400","8100"]["0.1602","0.1216"][]["XCBO"]7400.00008100.00009191falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:02:45Z"}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
01a0b554-0c48-7b92-8eff-b0fc7b876ac3SPX2026-09-18 12:22box_spread412734680.00unknown—7619.720012.6000["6000","7000"]["0.2294","0.1986"][]["XCBO"]6000.00007000.0000455455falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:23:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54e-2c60-7bb0-85c8-52d38c66f0fdSPX2026-09-18 12:16box_spread412275430.00longask7619.91003.8000["7000","8000"]["0.1935","0.1266"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:17:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54d-6528-7183-8067-77c13eff0035SPX2026-09-18 12:15box_spread412275462.00longask7620.10004.1000["7000","8000"]["0.1937","0.1265"][]["XCBO"]7000.00008000.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:15:44Z"}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-e8b7-7290-8198-576a7c9d6f07SPX2026-09-18 12:10box_spread412513564.00longask7621.500027.4000["6000","7000"]["0.2645","0.1924"][]["XCBO"]6000.00007000.0000104104falsefalsefalsetruetruemlatmarket_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
01a0b548-582f-7df1-90d7-31289984af7dSPX2026-09-18 12:10box_spread412513736.00longask7622.000027.0000["6000","7000"]["0.2644","0.1925"][]["XCBO"]6000.00007000.0000104104falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:10:23Z"}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
01a0b4fe-955f-78f3-95fc-b38cce907722SPX2026-09-18 10:49box_spread412607958.00unknown—7624.70005.0500["6000","6250"]["0.3822","0.2856"][]["XCBO"]6000.00006250.00002828falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:49:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4fe-6297-7441-bbb3-4e7b6970f0c7SPX2026-09-18 10:49box_spread423940848.00longask7624.00007.4500["6000","6150"]["0.3821","0.3575"][]["XCBO"]6000.00006150.00002828falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:49:42Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4fe-3f70-7e12-8cbd-087caa100cf2SPX2026-09-18 10:49box_spread413955647.00longask7623.63007.3000["6000","6100"]["0.3823","0.3660"][]["XCBO"]6000.00006100.00002828falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:49:17Z"}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
01a0b4c7-7fcf-7b60-b652-a8c3c9064ac6SPX2026-09-18 09:49box_spread412264902.00longask7637.35008.0000["7000","8000"]["0.1926","0.1259"][]["XCBO"]7000.00008000.0000104104falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:49:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c6-6a77-7752-9696-e8ba16ac7104BE2026-09-18 09:48box_spread415139760.00unknown—273.83829.4200["125","170"]["0.9196","0.8642"][]["XCBO"]125.0000170.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:48:24Z"}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