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:code = mlft×ticker = NDX×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
01a06d32-5e0d-7112-b74e-06929849c869NDX2026-09-04 12:13synthetic215351450.00shortbid0.000039.4000["29525"]["0.1527"]["29525"]["XPHO"]29525.000029525.00001414falsefalsefalsefalsetruemlftmarket_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
01a06d43-174d-7990-a50e-14cb76d640faNDX2026-09-04 12:31straddle2111754820.00shortbid0.000051.0000["29550"]["0.1509"]["28863.80","30236.20"]["XPHO"]29550.000029550.00001414falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:32:18Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d43-26ed-7061-997a-0a775861c245NDX2026-09-04 12:31other31181891800.00unknown0.000079.7000["25700","30000","31400"]["0.2650","0.1634","0.1509"][]["XPHO"]25700.000031400.00004277falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:32:18Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d98-057d-7231-8c32-beb98369fa95NDX2026-09-04 14:04other41102042324.00unknown0.0000160.6000["29000","30250","31800","33000"]["0.1849","0.1908","0.1775","0.1597"][]["XPHO"]29000.000033000.000042105falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:05:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06da0-46c5-7af3-9c39-cf9f6c194e84NDX2026-09-04 14:13call_diagonal_spread_bearish21687660.00shortbid0.000022.2000["32500","37000"]["0.1558","0.1843"][]["XPHO"]32500.000037000.000042196falsefalsetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:13:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a08148-a771-7a60-a080-c9860b27f354NDX2026-09-08 09:50synthetic212139820.00shortbid0.000044.0000["29500"]["0.1817"]["29500"]["XPHO"]29500.000029500.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:50:22Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08174-c080-7203-ab97-6d9432e68dabNDX2026-09-08 10:38other6121016039932.00unknown0.000087.8000["23000","28000","29500","31000"]["0.3452","0.2225","0.1791","0.1759"][]["XPHO"]23000.000031000.00001073falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:38:39Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0819c-1ab8-7a30-ae40-570a6a7ae7e3NDX2026-09-08 11:21synthetic21171186770.00longask0.000044.8000["29550"]["0.1790"]["29611.54"]["XPHO"]29550.000029550.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:21:48Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0819c-1ab8-7a30-ae40-56a2bfcf1519NDX2026-09-08 11:21other6181774438.00unknown0.0000217.2000["28900","29000","29900"]["0.1963","0.1931","0.1712"][]["XPHO"]28900.000029900.00002729falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:21:48Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081a4-0de0-7421-be29-504a2d86953dNDX2026-09-08 11:30strangle21207400000.00longask0.0000218.7000["29000","35000"]["0.2424","0.2133"]["25300","38700.00"]["XPHO"]29000.000035000.0000465465falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:30:32Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081ca-b469-7243-979c-478099ea43a3NDX2026-09-08 12:12other21241221056.00unknown0.000048.8000["22500","28200"]["0.3028","0.2169"][]["XPHO"]22500.000028200.000038282falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:12:32Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081ce-0be0-7af3-8518-c5cc6268ba84NDX2026-09-08 12:15synthetic216400080.00longbid0.000035.9000["29600"]["0.1732"]["29600"]["XPHO"]29600.000029600.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:16:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081ce-1799-7ff3-b136-e249aa15aa62NDX2026-09-08 12:15other219827076.00unknown0.000030.4000["30000","34000"]["0.1759","0.1818"][]["XPHO"]30000.000034000.000038101falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:16:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081d0-78f8-7191-b014-313c269fd0dbNDX2026-09-08 12:18synthetic212133640.00longbid0.000039.9000["29600"]["0.1742"]["29600"]["XPHO"]29600.000029600.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:19:09Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081d2-1708-7c91-8424-a02cb0ee1b00NDX2026-09-08 12:20synthetic217467810.00longbid0.000042.3000["29600"]["0.1741"]["29600"]["XPHO"]29600.000029600.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:20:23Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081d5-37d0-78b2-af81-b384decb5ec7NDX2026-09-08 12:23other2110100500.00unknown0.000020.4000["32500","37000"]["0.1630","0.1929"][]["XPHO"]32500.000037000.000038192falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T16:24:15Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081f6-e8d1-76a3-b0e0-92b7da98b665NDX2026-09-08 13:00synthetic213201720.00longbid0.000050.1000["29600"]["0.1739"]["29600"]["XPHO"]29600.000029600.00001010falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:01:04Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a081f6-ecb8-7071-83ca-14a1e9f79c45NDX2026-09-08 13:00other21352085100.00unknown0.000054.7000["31800","35000"]["0.1618","0.2030"][]["XPHO"]31800.000035000.000038282falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:01:04Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0868a-b930-7b12-b274-e6f08c0171c0NDX2026-09-09 10:20synthetic21261781000.00longbid0.000013.9000["29550"]["0.1859"]["29500"]["XPHO"]29550.000029550.000099falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:20:45Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086c9-25a8-7b33-8316-5fedf68589c5NDX2026-09-09 11:28synthetic216419280.00longbid0.000017.0000["29450"]["0.1909"]["29390"]["XPHO"]29450.000029450.000099falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:29:19Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086f3-fa81-7e43-8650-53eacf9cca0dNDX2026-09-09 12:15other21363674700.00unknown0.000065.1000["30000","32000"]["0.2007","0.1902"][]["XPHO"]30000.000032000.000072100falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:15:46Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08703-2168-7ce1-ba9d-eb3fcc5e6167NDX2026-09-09 12:32synthetic212139440.00shortask0.000012.6000["29425"]["0.1914"]["29415"]["XPHO"]29425.000029425.000099falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:32:33Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08703-3cc0-7563-91f8-b53e6385c1faNDX2026-09-09 12:32other2115760420.00unknown0.000039.7000["25300","30000"]["0.2898","0.1827"][]["XPHO"]25300.000030000.00003772falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:32:33Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08718-7270-7150-aaf0-e7309203a8baNDX2026-09-09 12:55other2175207950.00unknown0.000018.5000["33000","40000"]["0.1681","0.2039"][]["XPHO"]33000.000040000.000037191falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:55:25Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08726-2e10-75a3-9275-8f30db88012cNDX2026-09-09 13:10synthetic21151044450.00longask0.000014.0000["29400"]["0.1913"]["29460.00"]["XPHO"]29400.000029400.000099falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:10:32Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08726-4969-7103-b303-91279a562652NDX2026-09-09 13:10other21363562560.00unknown0.000057.4000["26000","31500"]["0.2606","0.1857"][]["XPHO"]26000.000031500.000072191falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:10:32Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08bb8-be20-78c2-b716-43d078b33680NDX2026-09-10 10:28synthetic21332298120.00shortbid0.000047.8000["29125"]["0.2035"]["29205.00"]["XPHO"]29125.000029125.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:29:19Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb8-ed00-7f32-96c5-508e475ad1aaNDX2026-09-10 10:29other213017438700.00unknown0.00001286.5000["32000"]["0.2211"][]["XPHO"]32000.000032000.0000280463falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:29:19Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bbd-c731-74c2-999c-59298d5b70fbNDX2026-09-10 10:34synthetic215339410.00shortask0.000040.9000["29225"]["0.1986"]["29217.38"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:34:32Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bbd-c731-74c2-999c-58cf74fb370dNDX2026-09-10 10:34other218530990.00unknown0.000058.7000["29800","29900"]["0.1827","0.1787"][]["XPHO"]29800.000029900.00002829truefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:34:32Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bc7-25a0-7d63-b4b6-b32735b24b3bNDX2026-09-10 10:44risk_reversal21879200.00shortbid0.000018.3000["23000","31500"]["0.3985","0.1681"]["31528.00"]["XPHO"]23000.000031500.00003636falsefalsefalsetruetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:45:04Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08be2-4ec0-7612-b9f0-8eb659c865caNDX2026-09-10 11:14call_vertical_spread211033714600.00unknown0.00001277.2000["12000","13000"]["0.6653","0.6215"][]["XPHO"]12000.000013000.00009999falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:14:18Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bf1-a0a0-7722-9107-db04512bba0fNDX2026-09-10 11:31synthetic213203250.00shortbid0.000037.3000["29200"]["0.1979"]["29230.00"]["XPHO"]29200.000029200.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:31:24Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c33-29f8-7351-b02e-f1fd8742ac8bNDX2026-09-10 12:42synthetic21181223820.00shortbid0.000036.6000["29175"]["0.2017"]["29175"]["XPHO"]29175.000029175.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:43:00Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c33-9f28-7c71-b870-b7cc864e4c4dNDX2026-09-10 12:43other21663208104.00unknown0.000021.3000["29800","31300"]["0.1858","0.1667"][]["XPHO"]29800.000031300.00003636falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:43:51Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c3b-7ae0-77c0-897d-670aab8b8c59NDX2026-09-10 12:51other51506986000.00unknown0.000068.8000["27500","28000","28500","29000"]["0.2525","0.2333","0.2171","0.1983"][]["XPHO"]27500.000029000.00002050falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:51:48Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c50-75f8-7ac0-9868-c7c0fd536b35NDX2026-09-10 13:14synthetic217473130.00shortbid0.000038.3000["29225"]["0.1974"]["29225"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:14:37Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c50-8598-7c72-b4b8-d4f89a1cbe21NDX2026-09-10 13:14other2130664440.00unknown0.000014.9000["23500","30500"]["0.5653","0.1731"][]["XPHO"]23500.000030500.0000836falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:15:39Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c56-51f8-7371-8458-41fd57a35a4eNDX2026-09-10 13:20straddle2110662260.00shortbid0.000056.4000["29225"]["0.1969"]["28562.74","29887.26"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:21:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c56-5db0-7d93-b4d1-12505fcdbc61NDX2026-09-10 13:21other21202762700.00unknown0.0000148.4000["26800","31000"]["0.2652","0.2098"][]["XPHO"]26800.000031000.000036190falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:21:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c59-47c8-74e3-82b1-048b09766047NDX2026-09-10 13:24straddle216404400.00longask0.000056.3000["29225"]["0.1972"]["28551","29899.00"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:24:55Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c59-5381-7042-b8c6-51007069eca5NDX2026-09-10 13:24other21201300600.00unknown0.000070.0000["22800","33000"]["0.4024","0.1983"][]["XPHO"]22800.000033000.000036190falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:24:55Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a090ea-4969-74a3-bf57-27ebf23bbc1dNDX2026-09-11 10:41synthetic21251353500.00longbid0.000012.4000["29450"]["0.1679"]["29400"]["XPHO"]29450.000029450.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:41:37Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0912c-e818-76c2-b141-17699461f584NDX2026-09-11 11:53synthetic212104220.00longbid0.000011.7000["29475"]["0.1622"]["29455"]["XPHO"]29475.000029475.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:54:08Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0912d-0371-72a2-a9d2-d9b363517582NDX2026-09-11 11:53other211203905680.00unknown0.000052.9000["19000","22000"]["0.3543","0.3077"][]["XPHO"]19000.000022000.0000279279falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:54:08Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0913c-e9c1-7170-97a2-35b2f52e2571NDX2026-09-11 12:11synthetic217363370.00longbid0.000010.3000["29475"]["0.1617"]["29465"]["XPHO"]29475.000029475.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:11:51Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0913d-2840-7ed3-b356-8c683916b56aNDX2026-09-11 12:11other21122659080.00unknown0.0000135.5000["17000","31000"]["0.3604","0.2155"][]["XPHO"]17000.000031000.0000279462falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:11:51Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09140-83a0-7620-8a39-e0e622c684ccNDX2026-09-11 12:15other2145213840.00unknown0.000029.2000["16000","39000"]["0.4430","0.2124"][]["XPHO"]16000.000039000.000098189falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:15:29Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09148-4fb8-7201-a564-2d26cb06b18bNDX2026-09-11 12:23synthetic214207400.00longbid0.000013.1000["29450"]["0.1618"]["29425"]["XPHO"]29450.000029450.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:24:08Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09163-2ab8-7640-903f-59b1342c5466NDX2026-09-11 12:53strangle21405800000.00longask0.000075.2000["27000","33000"]["0.2439","0.1923"]["25550","34450.00"]["XPHO"]27000.000033000.0000189189falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:53:25Z"}2026-09-112026-09-11 17:152026-09-11 17:15