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:direction = unknown×strategy = box_spread×
idtexttickertextexecuted_attimestamp 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
01a0c586-a4b7-75a0-9e6b-c0f9be5509c5SPX2026-09-21 15:52box_spread41303079020.00unknown7769.44005.6500["7250","8250"]["0.1851","0.1205"][]["XCBO"]7250.00008250.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T19:52:30Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c578-1df7-7891-94d0-26e369f1bf2eSPX2026-09-21 15:36box_spread412716350.00unknown7775.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.00unknown7772.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.00unknown7767.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
01a0c51e-ceaf-7491-8d63-45d3d565836cSPX2026-09-21 13:58box_spread412648020.00unknown7759.790021.7500["5000","7520"]["0.4609","0.1548"][]["XCBO"]5000.00007520.00006060falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:58:47Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4fb-9326-7240-9ba3-f6f9ee79e99dMSFT2026-09-21 13:20box_spread412845808.00unknown497.74001.0400["495","500"]["0.2722","0.2673"][]["SPHR"]495.0000500.000022falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:20:17Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4a1-808e-74b3-ac6c-bd71ee019803SPX2026-09-21 11:41box_spread4110010089000.00unknown7734.71004.0000["7710","7760"]["0.1455","0.1424"][]["XCBO"]7710.00007760.0000116116truefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:42:10Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c48d-5c4e-7e61-8eef-c1328eac7ea9SPY2026-09-21 11:19box_spread41749504.00unknown770.17000.3700["765","770"]["0.1421","0.1383"][]["XISX"]765.0000770.00006060falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:19:56Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c47d-089f-7501-98d2-28003d9645d6SPX2026-09-21 11:02box_spread416782100.00unknown7722.54004.0000["7000","8000"]["0.1976","0.1256"][]["XCBO"]7000.00008000.00008888falsefalsefalsetruetruemletmarket_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
01a0c472-044f-7351-b724-84b3f4f21597SPX2026-09-21 10:49box_spread4110102430.00unknown7721.00001.1500["7650","7750"]["0.1976","0.1273"][]["XCBO"]7650.00007750.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:50:13Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c467-6d5f-7b32-8911-2695bd02c6e0SPX2026-09-21 10:38box_spread413307560.00unknown7724.47004.0000["7650","7750"]["0.1486","0.1422"][]["XCBO"]7650.00007750.0000116116falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:38:37Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c456-c7a6-77a3-a80a-0bcd6ef5f594SPX2026-09-21 10:20box_spread413480630.00unknown7715.13005.6000["7325","7925"]["0.1773","0.1473"][]["XCBO"]7325.00007925.0000207207falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:20:24Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c451-a727-77f3-bfd9-d80c1bb88d25AMZN2026-09-21 10:14box_spread412002287200.00unknown256.90502.9100["200","300"]["0.3979","0.3642"][]["XISX"]200.0000300.00008888falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:14:49Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c447-df3f-75d0-abb5-1a26281114f9SPX2026-09-21 10:03box_spread41276649155.00unknown7705.30009.1500["6000","7000"]["0.3550","0.2199"][]["XCBO"]6000.00007000.00002525falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:04:08Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b61a-a037-7651-b6f9-df68cb8fcddbSPX2026-09-18 15:59box_spread424508200.00unknown7647.45005.2000["7000","8000"]["0.1921","0.1230"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b61a-947f-7451-bf90-6e20d2a03678SPX2026-09-18 15:59box_spread415500595.00unknown7647.810010.3500["7000","8000"]["0.2863","0.1429"][]["XCBO"]7000.00008000.000077falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:59:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b619-9a7f-7d62-b97e-b4e84f657153SPX2026-09-18 15:58box_spread414508160.00unknown7646.87004.4000["7000","8000"]["0.1925","0.1228"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:58:52Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b617-7b87-7f10-bef4-59bb8b1e0d19SPX2026-09-18 15:56box_spread41252885375.00unknown7646.82005.1000["7000","8000"]["0.1954","0.1156"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:56:28Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b613-8fa0-7392-bbda-e9f954fd3eb0SPX2026-09-18 15:52box_spread417807310.00unknown7642.23004.4000["7000","8000"]["0.1969","0.1148"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:52:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b60e-b187-75b0-a318-9487696f8f36SPX2026-09-18 15:46box_spread412230820.00unknown7644.23003.8000["7000","8000"]["0.1966","0.1151"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:47:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ed-6617-7320-8717-4c1250564331SPX2026-09-18 15:10box_spread4110100330.00unknown7642.34001.5500["7600","7700"]["0.3297","0.3119"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:10:30Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e9-2828-7d20-84ff-285616e9e9bfSPX2026-09-18 15:05box_spread4110100330.00unknown7643.07001.3500["7600","7700"]["0.3252","0.2959"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:05:50Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cb-5370-7f82-a080-4302a99b9742SPX2026-09-18 14:33box_spread4151164515.00unknown7633.58008.9500["6000","7000"]["0.3814","0.2059"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:33:48Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b577-cc9f-7310-928c-7b030cb8856bSPX2026-09-18 13:01box_spread411543335.00unknown7622.99000.6000["7615","7630"]["0.1202","0.1138"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:02:35Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-2967-7891-993f-771df9e14bd9SPX2026-09-18 12:54box_spread411854792.00unknown7624.82000.5000["7615","7630"]["0.1230","0.1192"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-257f-7d12-8c1f-04e57d2703c2SPX2026-09-18 12:54box_spread411648784.00unknown7624.85000.6000["7615","7630"]["0.1234","0.1193"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b571-1daf-7561-a1ce-3e6e0f8f0c75SPX2026-09-18 12:54box_spread411442756.00unknown7624.76000.5000["7615","7630"]["0.1238","0.1195"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:55:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b570-d377-77b3-9cf8-1702bb3ebbbdSPX2026-09-18 12:54box_spread41758240.00unknown7624.91000.8000["7620","7625"]["0.0754","0.0746"][]["XCBO"]7620.00007625.000033falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:54:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55f-37a7-73e3-aa29-30223dcb8d4dSPX2026-09-18 12:35box_spread413380550.00unknown7621.58003.8000["7000","8000"]["0.1938","0.1239"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:35:18Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55c-2e4f-7ee3-ab80-a0438ed9e3c1SPX2026-09-18 12:31box_spread41253170000.00unknown7617.91003.6000["7000","8000"]["0.1937","0.1242"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:32:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55a-b74f-7ea3-b9a7-7690e41f36c9SPX2026-09-18 12:30box_spread41243042480.00unknown7617.51004.0000["7000","8000"]["0.1933","0.1243"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:30:34Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b55a-9810-7e42-8329-cd40cf348e7aSPX2026-09-18 12:30box_spread41253170000.00unknown7617.86003.4000["7000","8000"]["0.1934","0.1244"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:30:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b554-eed7-7e52-bc5d-4c320a823957SPX2026-09-18 12:23box_spread41222787400.00unknown7614.11003.6000["7000","8000"]["0.1934","0.1244"][]["XCBO"]7000.00008000.00009191falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:24:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b554-0c48-7b92-8eff-b0fc7b876ac3SPX2026-09-18 12:22box_spread412734680.00unknown7619.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
01a0b552-6667-78f0-91e6-633c7d715611SPX2026-09-18 12:21box_spread41204604380.00unknown7620.75004.7500["6000","7000"]["0.3806","0.2029"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:21:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54e-e7df-7e71-9e13-d147e1de634bSPX2026-09-18 12:17box_spread411446452.00unknown7620.53000.5000["7615","7630"]["0.1225","0.1231"][]["XCBO"]7615.00007630.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:17:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b54d-5d57-7ad0-8d18-8f2c866e80d6SPX2026-09-18 12:15box_spread412194460.00unknown7620.27002.8000["7535","7635"]["0.1509","0.1438"][]["XCBO"]7535.00007635.0000104104falsefalsefalsetruetruemletmarket_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
01a0b54c-6357-76c1-b9e4-02972f6ff5e1SPX2026-09-18 12:14box_spread41204607900.00unknown7621.11004.5000["6000","7000"]["0.3804","0.2042"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:15:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b544-dd90-7771-a6c5-6840ce7b7c2fSPX2026-09-18 12:06box_spread4192071602.00unknown7619.98004.3500["6000","7000"]["0.3803","0.2044"][]["XCBO"]6000.00007000.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:06:38Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b542-745f-7e23-9c41-18eba285077dSPX2026-09-18 12:03box_spread411452640.00unknown7619.43000.3500["7615","7635"]["0.1272","0.1268"][]["XCBO"]7615.00007635.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:04:02Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b538-71e0-7de3-8fc2-a5a793f312d7SPX2026-09-18 11:52box_spread4231799748.00unknown7621.620016.3500["2000","8010"]["1.4851","0.1084"][]["XCBO"]2000.00008010.00002828falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:53:07Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50f-e6f7-77d2-b381-c0a612801cd3SPX2026-09-18 11:08box_spread412483830.00unknown7628.69007.7000["6000","7020"]["0.2703","0.1943"][]["XCBO"]6000.00007020.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:08:47Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50d-7dc7-7143-b90a-53f4f094c45cSPX2026-09-18 11:05box_spread412414210.00unknown7628.91004.1000["6000","7520"]["0.2744","0.1464"][]["XCBO"]6000.00007520.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:06:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b50b-fb10-7812-ac5f-0a8fb9da6880SPX2026-09-18 11:04box_spread412483090.00unknown7627.73006.5000["6000","7020"]["0.2765","0.1935"][]["XCBO"]6000.00007020.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:04:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b506-ea2f-79d3-b8c4-5e22330d436eSPX2026-09-18 10:58box_spread41142941540.00unknown7627.59005.0000["6000","8030"]["0.2742","0.1172"][]["XCBO"]6000.00008030.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:59:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b504-1b6f-7903-9e3c-b08b1c4fe744SPX2026-09-18 10:55box_spread413647835.00unknown7628.51003.5000["6000","7360"]["0.2659","0.1612"][]["XCBO"]6000.00007360.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:55:47Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b501-bdf7-7832-adbd-ef367abce79aSPX2026-09-18 10:53box_spread412413740.00unknown7629.25005.0000["6000","7525"]["0.2793","0.1458"][]["XCBO"]6000.00007525.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:53:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4fe-955f-78f3-95fc-b38cce907722SPX2026-09-18 10:49box_spread412607958.00unknown7624.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
01a0b4fa-ff68-73f0-81d9-0aa4ccb6ca88SPX2026-09-18 10:45box_spread41161846240.00unknown7619.98006.4000["7000","8000"]["0.1956","0.1181"][]["XCBO"]7000.00008000.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:45:58Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ee-708f-7033-a2ec-cfe6ae8e049cSPX2026-09-18 10:31box_spread4110108730.00unknown7621.94001.2500["7600","7700"]["0.1544","0.2172"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_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