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×direction = unknown×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
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
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
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
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
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
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-0ae7-7182-9eca-4fb6537cfb15BE2026-09-18 09:46box_spread4110281380.00unknown—275.969910.1200["125","170"]["0.8822","0.8491"][]["XCBO"]125.0000170.0000119119falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:47:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0d7-0433-7d33-98c5-8e6e4af87059SPX2026-09-17 15:27box_spread412511990.00unknown—7637.350028.1000["6000","7000"]["0.2740","0.1959"][]["XCBO"]6000.00007000.00009292falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T19:28:00Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b071-7433-74d3-9835-0799f61cffc2SPX2026-09-17 13:36box_spread412682170.00unknown—7633.56007.7000["6000","7050"]["0.2372","0.1962"][]["XCBO"]6000.00007050.0000365365falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:37:12Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b05d-2114-7901-aef0-e8206a6ec891SPX2026-09-17 13:14box_spread412798218.00unknown—7634.450020.2000["4000","7790"]["0.5773","0.1267"][]["XCBO"]4000.00007790.00006464falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:15:00Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b01d-550b-7de2-9ab7-4f1ce8047fc5SPX2026-09-17 12:05box_spread413285540.00unknown—7635.43006.9000["7500","8000"]["0.1551","0.1256"][]["XCBO"]7500.00008000.00009292falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:05:37Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afeb-217b-7d72-bd92-60b8bcafa30fSPX2026-09-17 11:10box_spread414174520.00unknown—7618.45003.4000["7600","7660"]["0.1301","0.1230"][]["XCBO"]7600.00007660.00002929falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:10:19Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afe9-6bfb-7f73-a356-d550417f89bdSPX2026-09-17 11:08box_spread412484314.00unknown—7618.19005.0000["6000","7010"]["0.2940","0.1990"][]["XCBO"]6000.00007010.00006464falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:08:37Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afcd-9ae3-71c0-a6f5-71c2ebbbe425SPX2026-09-17 10:38box_spread413411045.00unknown—7630.38007.1000["7000","8275"]["0.1996","0.1182"][]["XCBO"]7000.00008275.00006464falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:38:03Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab8c-ad43-72d1-a543-78a9f1e6f493SPX2026-09-16 14:48box_spread41102317890.00unknown—7591.49007.1000["6000","7250"]["0.2786","0.1777"][]["XCBO"]6000.00007250.00009393falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:48:39Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab4a-2dd3-7173-9d28-4687383ffe7bSPX2026-09-16 13:35box_spread413448716.00unknown—7608.95004.9000["7000","7200"]["0.1998","0.1825"][]["XCBO"]7000.00007200.00009393falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:36:13Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab3e-895b-7f30-a3d5-5212549c630fSPX2026-09-16 13:23box_spread412558092.00unknown—7607.95006.3000["6450","6550"]["0.2275","0.2215"][]["XCBO"]6450.00006550.0000184184falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:24:04Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab27-dcab-7082-bb14-3b37ac6b3563SPX2026-09-16 12:58box_spread4110128350.00unknown—7610.16000.5000["7550","7650"]["0.4684","0.3911"][]["XCBO"]7550.00007650.000000falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:59:37Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaf5-4773-7fb2-a7cf-3b3a20a5df9aSPX2026-09-16 12:03box_spread4151226740.00unknown—7616.12009.1000["7500","7700"]["0.1810","0.1744"][]["XCBO"]7500.00007700.0000457457falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:03:47Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aab6-13c3-7de1-8f84-5b9f11b378d1SPX2026-09-16 10:54box_spread412200300.00unknown—7608.85005.0000["7000","8000"]["0.5173","0.2573"][]["XCBO"]7000.00008000.000022falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:54:36Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aab2-b093-7883-a92c-91775bd1c2a9SPX2026-09-16 10:50box_spread413966390.00unknown—7607.99007.2000["6000","7000"]["0.2424","0.1971"][]["XCBO"]6000.00007000.0000303303falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:50:44Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa8c-311b-7f61-935f-761ad02e7d03SPX2026-09-16 10:08box_spread413722175.00unknown—7608.02005.3000["6000","7025"]["0.3073","0.2030"][]["XCBO"]6000.00007025.00006565falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:08:34Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a660-d9fd-74c3-aee7-0a7d1dd44db7SPX2026-09-15 14:42box_spread412520126.00unknown—7585.00005.4000["6000","7000"]["0.2791","0.1985"][]["XCBO"]6000.00007000.0000122122falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:43:13Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a654-6a65-76b1-9c10-0d7849be83c0SPX2026-09-15 14:29box_spread414440800.00unknown—7587.570022.8000["6800","7900"]["0.5543","0.2413"][]["XCBO"]6800.00007900.000033falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:29:36Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a652-5ef6-7e52-aa0d-5b1ef5687847SPX2026-09-15 14:26box_spread414440620.00unknown—7585.640020.9000["6800","7900"]["0.5584","0.2327"][]["XCBO"]6800.00007900.000033falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:27:51Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a610-ed0e-7122-b95c-11a9676d6542SPX2026-09-15 13:15box_spread4151034790.00unknown—7581.85004.9000["6000","7225"]["0.3743","0.1903"][]["XCBO"]6000.00007225.00003131falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:15:24Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5e3-070d-7420-80e3-617d47d2ebc6SPX2026-09-15 12:25box_spread414392520.00unknown—7588.27002.9000["7500","8000"]["0.1581","0.1277"][]["XCBO"]7500.00008000.00009494falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:25:47Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b9-0cf6-73e3-b890-a7d4d25103e5SPX2026-09-15 11:39box_spread4151559265.00unknown—7584.780019.6000["7000","8000"]["0.2002","0.1728"][]["XCBO"]7000.00008000.0000640640falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:39:34Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a579-0656-7551-ae9c-0871c881bdb7SPX2026-09-15 10:29box_spread415136020.00unknown—7587.46003.4000["7450","7550"]["0.2164","0.1827"][]["XCBO"]7450.00007550.000033falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:29:43Z"}2026-09-152026-09-15 19:282026-09-15 19:28
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
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
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
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
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