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.

312,778 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 = long×strategy = box_spread×sorted by executed_at ↑×
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
01a06d30-98ed-7580-b852-0dbb12878827SPX2026-09-04 12:11box_spread415805935.00longask7720.00004.3000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:11:37Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d31-ecc5-7193-a2ca-0ef8d4bbe48aSPX2026-09-04 12:13box_spread415806170.00longask7720.98004.4000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-3ecd-71d2-adaa-5d08692245acSPX2026-09-04 12:13box_spread415806480.00longask7721.54004.8000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-4e6d-74b2-b8a2-a0f6413bcf80SPX2026-09-04 12:13box_spread415806480.00longask7721.54004.8000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-7d4d-7321-ba71-7416531297feSPX2026-09-04 12:13box_spread415806405.00longask7721.23004.6000["7000","8000"]["0.1916","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:13:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d32-db0d-7f31-a6e8-07d0f5ed9b88SPX2026-09-04 12:14box_spread415806445.00longask7721.49004.3000["7000","8000"]["0.1915","0.1336"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:14:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d33-503d-7161-b2a0-4f037e84f663SPX2026-09-04 12:14box_spread4181290366.00longask7721.73004.7000["7000","8000"]["0.1915","0.1337"][]["XCBO"]7000.00008000.0000168168falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:14:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dae-2975-7770-bfc9-66c98fd91427SPX2026-09-04 14:28box_spread412411088.00longask7714.13006.6000["7500","8000"]["0.1772","0.1574"][]["XCBO"]7500.00008000.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:29:10Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dba-6e15-7b21-a31d-21dbaed1de87SPX2026-09-04 14:42box_spread413625962.00longask7715.14005.4000["7000","8000"]["0.1949","0.1508"][]["XCBO"]7000.00008000.0000286286falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:42:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dbd-c58d-7723-b265-cbdf410c7707SPX2026-09-04 14:45box_spread412554848.00longask7716.740010.5000["7000","7800"]["0.1984","0.1723"][]["XCBO"]7000.00007800.0000469469falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:46:13Z"}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
01a06dcf-9bf5-7ae3-af76-bf1f6c5bebbfSPX2026-09-04 15:05box_spread41132125292.00longask7712.91008.6000["7300","7700"]["0.1745","0.1537"][]["XCBO"]7300.00007700.0000208208falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:05:17Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd1-da2d-7ae2-96e8-f45ce274efa3SPX2026-09-04 15:07box_spread41142772112.00longask7712.52005.0000["7300","7700"]["0.1815","0.1633"][]["XCBO"]7300.00007700.0000286286falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:07:50Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd7-e8f5-7032-8f39-c971d58ec705SPX2026-09-04 15:14box_spread4151211630.00longask7712.06007.4000["7000","8000"]["0.1967","0.1601"][]["XCBO"]7000.00008000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:14:49Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd9-c96d-7d63-8636-2d8a7cd57059SPX2026-09-04 15:16box_spread422436506.00longask7711.780012.8000["8000","9000"]["0.1602","0.1392"][]["XCBO"]8000.00009000.0000378378falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:16:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de4-48ed-71d0-b350-ce89b85f5ea4BE2026-09-04 15:27box_spread41100360600.00longask249.12505.6000["255","260"]["10.6023","10.3882"]["0","255","260"]["XPHO"]255.0000260.000000falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:28:02Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de7-468d-7082-90e9-df9d182c9cedSPX2026-09-04 15:31box_spread414824736.00longask7715.01007.4000["7500","8000"]["0.1777","0.1579"][]["XCBO"]7500.00008000.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:31:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dec-5b55-7b02-8664-68b27887d5bfSPX2026-09-04 15:36box_spread4161713876.00longask7715.21008.9000["6900","6950"]["0.2021","0.2001"][]["XCBO"]6900.00006950.0000350350falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:36:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
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
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
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
01a08164-e9d1-7873-89ae-0674a0e26834SPX2026-09-08 10:21box_spread412414438.00longask7683.360027.0000["6650","7050"]["0.2209","0.1909"][]["XCBO"]6650.00007050.0000114114falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:21:32Z"}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
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
01a081c8-4368-7963-adc3-23c536805bf2SPX2026-09-08 12:09box_spread4131063188.00longask7690.090032.6000["8000","10000"]["0.1824","0.1487"][]["XCBO"]8000.000010000.0000829829falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:10:11Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081fc-fb80-7023-899b-a1e9e07c7edbWDC2026-09-08 13:07box_spread41381606.00longask484.500016.7000["400","500"]["0.7467","0.7746"][]["C2OX"]400.0000500.00007373falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:07:30Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08202-5698-72c0-866d-637f55462671SPX2026-09-08 13:13box_spread414878680.00longask7691.51007.0000["8000","9000"]["0.1613","0.1405"][]["XCBO"]8000.00009000.0000374374falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:13:27Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0826d-ed91-7c52-a84c-9bf5cb8dcc72SPX2026-09-08 15:10box_spread41101004380.00longask7684.03005.6000["7000","8000"]["0.2618","0.1203"][]["XCBO"]7000.00008000.00001010falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:10:57Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0827c-a718-7b51-b4ae-9398849b27d6SPX2026-09-08 15:26box_spread4173679284.00longask7681.0700775.4000["7000","8000"]["0.2105","0.1985"][]["XCBO"]7000.00008000.000015641564falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:27:04Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0828e-5e40-73f3-b4b1-ee86f4abd081SPX2026-09-08 15:46box_spread42627750.00longask7680.43000.7500["7640","7680"]["0.3767","0.1958"][]["XCBO"]7640.00007680.000000falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:46:02Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0828f-5070-7741-a423-4a3e338e9911SPX2026-09-08 15:47box_spread4152808035.00longask7680.7300751.9000["6000","8300"]["0.2197","0.1939"][]["XCBO"]6000.00008300.000015641564falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:47:40Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a086ad-ece8-7e50-8ad7-dba01d4268e5MU2026-09-09 10:58box_spread41237396.00longask1034.99998.9700["920","970"]["0.9788","0.7255"][]["XCBO"]920.0000970.000022falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:59:18Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086d8-e100-7f92-a6c3-d56033e6c8b2SPX2026-09-09 11:45box_spread411035820.00longask7636.59000.6000["7630","7635"]["0.1318","0.1292"]["0","7630","7635"]["XCBO"]7630.00007635.000000falsefalsefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:46:13Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08725-43b0-7762-874e-528bab143155SPX2026-09-09 13:09box_spread4152944040.00longask7640.79001077.4000["7000","8000"]["0.2159","0.2050"][]["XCBO"]7000.00008000.000019271927falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:09:27Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08727-2810-7fe3-bfef-1b5866f51c60SPX2026-09-09 13:11box_spread4153014015.00longask7641.63001073.1000["6000","9200"]["0.2228","0.1872"][]["XCBO"]6000.00009200.000019271927falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:11:33Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08727-2bf8-7811-829c-963069331d7eSPX2026-09-09 13:11box_spread4131808409.00longask7641.79001073.1000["6000","9200"]["0.2228","0.1872"][]["XCBO"]6000.00009200.000019271927falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:11:33Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08781-a038-7480-9c4f-965fa22e7670SPX2026-09-09 14:50box_spread413714564.00longask7645.37005.7000["7000","8000"]["0.1985","0.1613"][]["XCBO"]7000.00008000.0000373373falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:51:03Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08785-70c8-7782-a747-9580e400f7d1SPX2026-09-09 14:54box_spread413715062.00longask7647.78006.2000["7000","8000"]["0.1985","0.1613"][]["XCBO"]7000.00008000.0000373373falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:54:38Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08789-be58-76b1-b9fc-09d46b85ece8SPX2026-09-09 14:59box_spread412476028.00longask7644.11005.2000["7000","8000"]["0.1984","0.1612"][]["XCBO"]7000.00008000.0000373373falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:59:48Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a087be-b108-7fc2-bd73-5a09d86d710eSPX2026-09-09 15:56box_spread412475652.00longask7637.88006.6000["7000","8000"]["0.1986","0.1613"][]["XCBO"]7000.00008000.0000373373falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:57:02Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a087c4-0068-7181-b875-ae386f1586d6SPX2026-09-09 16:02box_spread4312226600.00longask7636.49005.5250["7670","7735"]["0.1096","0.0973"][]["XCBO"]7670.00007735.000055falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T20:04:35Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08b83-3ed2-77a2-85d6-7736b0a5e2f3SPY2026-09-10 09:30box_spread4117310080.00longask758.14002.0500["755","775"]["0.1751","0.1683"][]["XISX"]755.0000775.0000280280falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:30:26Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b90-9cb1-7d62-a928-8b4ef873fda7SPX2026-09-10 09:45box_spread4121374880.00longask7593.9300811.5000["5000","6000"]["0.2228","0.2223"][]["XCBO"]5000.00006000.000015621562falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:45:04Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b92-ee70-74d2-987c-c21caf05b87cSPX2026-09-10 09:47box_spread4121273462.00longask7599.4400854.1000["5500","6500"]["0.2242","0.2172"][]["XCBO"]5500.00006500.000015621562falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:47:55Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb0-0b90-7431-966a-628fbc78a0c8SPX2026-09-10 10:19box_spread412407460.00longask7591.44006.4000["7000","8000"]["0.1999","0.1538"][]["XCBO"]7000.00008000.0000280280falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:19:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bd3-c030-71e1-aa19-d0fd886ceb4dSPX2026-09-10 10:58box_spread41101067800.00longask7607.03007.9000["7000","8000"]["0.2161","0.1134"][]["XCBO"]7000.00008000.00003636falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:58:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bda-1d18-7532-bd6e-c51a894015b4SPX2026-09-10 11:05box_spread4142584920.00longask7604.4600846.9000["5000","7000"]["0.2219","0.2119"][]["XCBO"]5000.00007000.000015621562falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:05:50Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bdd-bec8-7172-bbf5-0395d36b36dcSPX2026-09-10 11:09box_spread4152242350.00longask7606.0300124.4000["7000","8000"]["0.2094","0.1915"][]["XCBO"]7000.00008000.000011981198falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:09:58Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bf0-5498-70c0-b9f1-54b7a2c23a9bSPX2026-09-10 11:29box_spread4141661112.00longask7605.780025.2000["6000","6975"]["0.2296","0.2039"][]["XCBO"]6000.00006975.0000645645falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:29:52Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bf0-8b48-7b92-99a3-532ebd1e1f05SPX2026-09-10 11:29box_spread412775396.00longask7605.760021.9000["6000","7625"]["0.2298","0.1859"][]["XCBO"]6000.00007625.0000645645falsefalsefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:29:52Z"}2026-09-102026-09-10 17:152026-09-10 17:15