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 = mlet×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
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
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
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
01a0b4e2-dbb7-76d3-8663-e59d80ff9e9dSPX2026-09-18 10:19box_spread4110110030.00unknown7622.71000.7500["7600","7700"]["0.1648","0.2140"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:19:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4d7-a887-77d2-ba33-4d4c0a28f888SPX2026-09-18 10:07box_spread4110110730.00unknown7621.75000.9500["7600","7700"]["0.1638","0.2110"][]["XCBO"]7600.00007700.000000falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:07:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ce-3a78-7eb1-8394-59d6ee61e038SPX2026-09-18 09:56box_spread412486170.00unknown7631.55005.1000["6000","7010"]["0.2680","0.1948"][]["XCBO"]6000.00007010.00006363falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:57:02Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c9-19f7-7cc0-bf3b-9d609c648f5aSPX2026-09-18 09:51box_spread422093800.00unknown7633.29000.6000["7640","7645"]["0.1378","0.1373"][]["XCBO"]7640.00007645.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:51:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4c7-397f-7bd2-a2b1-35ee8272ad52SPX2026-09-18 09:49box_spread41882608.00unknown7637.11000.4500["7575","7600"]["0.1950","0.1487"][]["XCBO"]7575.00007600.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:49:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0fe-5a83-76d1-8577-4f68b414b78dSPX2026-09-17 16:10box_spread41585840.00unknown7637.76005.4500["7650","7750"]["0.0933","0.0825"][]["XCBO"]7650.00007750.000044falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T20:12:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15