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×net_side = ask×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
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
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
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
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
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
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
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-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
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
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
01a0b05e-78d3-7000-899e-3506fc4130c1SPX2026-09-17 13:16box_spread412256038.00longask7634.31003.2000["7000","8000"]["0.1957","0.1244"][]["XCBO"]7000.00008000.00009292falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:16:54Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0abb2-a7eb-74e2-aa38-8a022ce0232cSPX2026-09-16 15:30box_spread4141023300.00longask7522.900013.6000["7000","8000"]["0.1982","0.1640"][]["XCBO"]7000.00008000.0000457457falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:30:12Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a63c-2f46-72b2-b7ca-604e07d90ac8SPX2026-09-15 14:02box_spread4152950222.00longask7586.1800914.0000["6000","7000"]["0.2192","0.2098"][]["XCBO"]6000.00007000.000015571557falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:03:03Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a091d7-aed8-7692-9460-e0fa9456a634SPX2026-09-11 15:00box_spread412926482.00longask7663.790036.6000["6000","7000"]["0.2251","0.2046"][]["XCBO"]6000.00007000.0000826826falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:00:53Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a081a7-3290-7742-83d1-3ca2ab6589dbSPX2026-09-08 11:33box_spread4161449948.00longask7692.52006.8000["7000","8000"]["0.1985","0.1616"][]["XCBO"]7000.00008000.0000374374falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:33:34Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0817d-bd48-7870-92ae-5ecd0f405143SPX2026-09-08 10:48box_spread414872224.00longask7686.41007.2000["7000","8000"]["0.1980","0.1550"][]["XCBO"]7000.00008000.0000311311falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:48:25Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0814a-aef8-7732-aaff-60ce02f17eacSPX2026-09-08 09:52box_spread413404448.00longask7687.73004.2000["7000","8000"]["0.1959","0.1297"][]["XCBO"]7000.00008000.0000101101falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:52:48Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08148-0360-7280-95ba-0fdb4cdd0cbfSPX2026-09-08 09:49box_spread4151062120.00longask7692.45005.6000["7700","7800"]["0.1721","0.1685"][]["XCBO"]7700.00007800.0000374374falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:49:41Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06ded-edad-7383-b28b-3bf6bd3795ecSPX2026-09-04 15:38box_spread414969792.00longask7712.60006.9000["7000","8000"]["0.1968","0.1602"][]["XCBO"]7000.00008000.0000378378falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:38:37Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dce-210e-7a10-8179-471e6be313deSPX2026-09-04 15:03box_spread415602920.00longask7714.10007.9000["7300","7700"]["0.1682","0.1411"][]["XCBO"]7300.00007700.0000118118falsefalsefalsetruetruemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:03:44Z"}2026-09-042026-09-07 00:532026-09-07 00:53