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 = SPY×
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
01a0a610-48fe-7623-a31e-d2f264ac0392SPY2026-09-15 13:14call_diagonal_spread2162222518.00shortbid757.24002.2000["740","741"]["0.3391","0.1526"][]["SPHR"]740.0000741.000017falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:14:38Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5cc-6de6-7703-8333-3893cb570a6cSPY2026-09-15 12:00other6443503810600.00unknown757.10000.1200["670","680","705","715","740","750"]["0.2696","0.5150","0.2170","0.3435","0.1701","0.2206"][]["ARCO"]670.0000750.0000331falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:01:16Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a585-5a96-7d51-9e9b-e8af2aa03ad3SPY2026-09-15 10:42call_calendar215001380500.00longask757.10010.0800["760"]["0.1504"][]["XPHO"]760.0000760.0000394falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:43:10Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a578-4ad6-7603-b825-0abf4a63f40bSPY2026-09-15 10:28put_vertical_spread2211003977600.00unknown757.53000.1800["735","745"]["0.1778","0.1710"][]["XPHO"]735.0000745.0000122122falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:29:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a557-b6fe-7433-92bc-261f9d3c8062SPY2026-09-15 09:53other65800512400.00unknown759.73000.1300["650","680","700","720","750","760"]["0.3599","0.5173","0.2496","0.3239","0.1629","0.2085"][]["AMXO"]650.0000760.0000315falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T13:53:31Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a17f-34a0-7010-b8f9-e0d21363ec47SPY2026-09-14 15:57other21375180625.00unknown761.13500.0600["735","820"]["0.1751","0.1119"][]["AMXO"]735.0000820.00003267falsetruetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T19:57:47Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a11b-b7e0-7523-8c3a-3a53b2b7b984SPY2026-09-14 14:09other21375219750.00unknown762.53000.0500["700","740"]["0.2250","0.1703"][]["AMXO"]700.0000740.00003232falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:09:45Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0bd-a5d9-71d0-ba6e-756ee21d2c0bSPY2026-09-14 12:26put_vertical_spread2111753937425.00longask762.05000.1600["735","745"]["0.1779","0.1711"]["742.59"]["SPHR"]735.0000745.0000123123falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:26:41Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a08c-2dc9-7853-808a-2b8787791c75SPY2026-09-14 11:32risk_reversal226604387020.00shortbid759.53000.2100["720","815"]["0.2062","0.1455"]["820.95"]["ARCO"]720.0000815.0000368368falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:32:18Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a07d-aaf0-71b3-87f6-405d80f23f69SPY2026-09-14 11:16other21375261250.00unknown758.63000.0600["700","740"]["0.2261","0.1709"][]["AMXO"]700.0000740.00003232falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:17:03Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a07a-6700-7110-947b-974eb3e925b8SPY2026-09-14 11:12ratio_risk_reversal2140052600.00unknown758.80000.0200["758","759"]["0.1407","0.1306"][]["SPHR"]758.0000759.000000falsetruefalsetruetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:13:01Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a044-6ab0-7932-87e5-1a02657420baSPY2026-09-14 10:13other41137558549.00unknown760.63000.1600["759","760","767","768"]["0.1466","0.1406","0.1350","0.1338"][]["SPHR"]759.0000768.0000077falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:13:56Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a02e-e2f8-7702-8428-228b81a85773SPY2026-09-14 09:50put_vertical_spread216002194200.00longask760.44000.1900["715","725"]["0.1962","0.1905"]["722.95"]["XPHO"]715.0000725.0000186186falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:50:24Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a02d-3161-7ad1-88e5-7ecc9cd8f814SPY2026-09-14 09:48put_vertical_spread2110633752390.00unknown759.94000.2100["735","745"]["0.1793","0.1724"][]["XPHO"]735.0000745.0000123123falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:48:30Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a029-f928-7f43-a7de-34b6af14ff33SPY2026-09-14 09:44other41361811680713.00unknown759.40990.2400["780","790","805","815"]["0.1336","0.1290","0.1234","0.1207"][]["XPHO"]780.0000815.0000123123falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:45:01Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a023-9470-79d1-b4f3-57169fa3be79SPY2026-09-14 09:37call_diagonal_spread2114241304.00shortask758.57003.9400["660","750"]["0.2609","0.1668"][]["XBOX"]660.0000750.000095276falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:38:02Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a022-4868-7e01-a208-420f26478b3bSPY2026-09-14 09:36other4120003792000.00unknown758.77000.1300["745","755"]["0.1964","0.1768"][]["XPHO"]745.0000755.0000416falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T13:36:45Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0921a-1ea8-73d0-8a60-6b3d775606e0SPY2026-09-11 16:12iron_condor44350547400.00unknown764.33000.1600["717","747","782","793"]["0.1941","0.1556","0.1045","0.1004"][]["AMXO"]717.0000793.00003535falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-112026-09-11 17:152026-09-11 17:15
01a091fb-4050-7d23-abca-f3df3c288d68SPY2026-09-11 15:39other51550289000.00unknown764.92000.0600["680","690","720","750","760"]["0.3799","0.3415","0.2445","0.1641","0.1459"][]["XBOX"]680.0000760.000077falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:39:19Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091f3-5110-7b83-a427-42419b451112SPY2026-09-11 15:30put_vertical_spread21200413600.00longask765.07500.0900["705","710"]["0.1978","0.1942"]["709.30"]["SPHR"]705.0000710.0000126126falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:30:39Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091f0-b518-7761-86b9-b2741b1ba476SPY2026-09-11 15:27put_vertical_spread217002396800.00unknown765.12000.1500["715","725"]["0.1906","0.1843"][]["XPHO"]715.0000725.0000189189falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:28:07Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09133-9af0-76e0-9404-67a8fb88de68SPY2026-09-11 12:01call_diagonal_spread2190329760.00longbid765.90000.3700["750","763"]["0.1119","0.1304"][]["SPHR"]750.0000763.00001449falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T16:01:46Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09132-4b00-73c2-97c2-842e31850e21SPY2026-09-11 11:59put_vertical_spread216000012600000.00shortbid765.73000.0200["730","750"]["0.2139","0.1657"]["748.84"]["AMXO"]730.0000750.000077falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:59:56Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a09111-bb11-7c80-9f8b-2c24a88bd9ccSPY2026-09-11 11:24strangle22300145200.00shortbid765.60000.0200["760","775"]["0.1501","0.0969"]["755.16","779.84"]["AMXO"]760.0000775.000077falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:24:24Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090d5-1b88-7620-8408-5bb80798c4d9SPY2026-09-11 10:17call_vertical_spread2140077200.00shortbid764.82000.0200["765","766"]["0.1630","0.1585"]["765.45"]["SPHR"]765.0000766.000000falsetruefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T14:18:22Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090ba-3ca0-7433-993c-777af98774e5SPY2026-09-11 09:48put_vertical_spread2152167856.00longask765.01000.1800["750","770"]["0.1635","0.1496"]["763.22"]["SPHR"]750.0000770.00007070falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:48:51Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a090b5-9920-7c30-b9c3-0f0cb4b18789SPY2026-09-11 09:43other42363614129496.00unknown765.30000.2100["780","790","805","815"]["0.1340","0.1292","0.1233","0.1206"][]["XPHO"]780.0000815.0000126126falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T13:43:38Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08cf4-5b00-7531-8a7d-8464196f5c42SPY2026-09-10 16:13other21100682000.00unknown758.48006.7800["785","800"]["0.3475","0.2929"][]["XPHO"]785.0000800.000014falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ce6-a730-78d1-bb65-1f686a7f4fb7SPY2026-09-10 15:58put_vertical_spread2116005292800.00unknown757.93500.2000["774","775"]["0.1934","0.2036"][]["XPHO"]774.0000775.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:58:55Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cd2-11a8-7502-ac5b-d8fb2871b240SPY2026-09-10 15:36put_diagonal_spread21150132600.00longask757.82000.0400["761","762"]["0.1801","0.4203"][]["SPHR"]761.0000762.000001falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:36:14Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ccb-37c0-7d31-807a-518d3080c536SPY2026-09-10 15:28put_vertical_spread2110003182000.00unknown757.54000.2600["773","774"]["0.1720","0.1816"][]["XPHO"]773.0000774.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:29:20Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08cbf-c9f8-7bc3-8aad-ffeb51b5a60dSPY2026-09-10 15:16synthetic22500850000.00longask757.75000.1500["750"]["0.1751"]["757.70"]["AMXO"]750.0000750.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:16:43Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c6a-62b0-7a93-a9c7-0cb70b2954e2SPY2026-09-10 13:42other413250038030000.00unknown758.21000.1000["730","733","750","760"]["0.2182","0.2123","0.1810","0.1668"][]["XPHO"]730.0000760.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:43:13Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c4f-58d0-7b71-9f9c-455dcc1d5c61SPY2026-09-10 13:13strangle21250424500.00shortbid759.29000.1000["746","770"]["0.1642","0.1236"]["729.02","786.98"]["XPHO"]746.0000770.00003636falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:13:39Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c4e-2c09-70b2-ae0d-c3d48d6ddb44SPY2026-09-10 13:12other436643174457566.00unknown759.33500.1100["740","745","750","760"]["0.1965","0.1875","0.1783","0.1642"][]["AMXO"]740.0000760.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:12:45Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c2f-3640-7ac2-8302-5fa3edc36ad9SPY2026-09-10 12:38other31977303056.00unknown758.00000.0600["748","754","760"]["0.2338","0.2116","0.1849"][]["XPHO"]748.0000760.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:38:59Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c24-d600-7761-af21-6588ef3574d1SPY2026-09-10 12:26other54550708700.00unknown757.86500.0700["680","690","720","750","760"]["0.3489","0.3262","0.2433","0.1841","0.1679"][]["AMXO"]680.0000760.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:27:11Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb2-d668-7f53-9264-68672f1b5916SPY2026-09-10 10:22call_vertical_spread217573071149.00longask758.28000.2700["880","890"]["0.1405","0.1388"]["882.77"]["XPHO"]880.0000890.0000463463falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:22:28Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bb0-abb8-7372-b3c6-4825977eb133SPY2026-09-10 10:20put_vertical_spread2111504356200.00longask758.01000.2100["735","745"]["0.1802","0.1741"]["742.28"]["XPHO"]735.0000745.0000127127falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:20:04Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08b8c-e778-7bf2-bcad-2dde955b58cdSPY2026-09-10 09:40other41392413345524.00unknown758.46000.3000["780","790","805","815"]["0.1366","0.1323","0.1271","0.1246"][]["XPHO"]780.0000815.0000127127falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T13:41:07Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a0877f-7588-76e1-a972-94bb91de0d3eSPY2026-09-09 14:47call_diagonal_spread21721087272.00longbid763.09003.2300["680","765"]["0.3353","0.1651"][]["SPHR"]680.0000765.00009373falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:48:00Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08767-7118-7601-bf85-646d68edfcd5SPY2026-09-09 14:21call_diagonal_spread2153746558.00shortask762.81002.5600["690","765"]["0.3465","0.1650"][]["SPHR"]690.0000765.00009373falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T18:21:41Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0872e-fbf8-7451-b05d-e7e2979c7e77SPY2026-09-09 13:19put_vertical_spread2120073400.00longask762.87000.0300["764","765"]["0.1343","0.1469"]["764.15"]["SPHR"]764.0000765.000000falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T17:20:12Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0870a-0320-7d01-a64b-45e835bf615aSPY2026-09-09 12:39other441125876750.00unknown762.11000.0900["720","730","750","760"]["0.2299","0.2078","0.1692","0.1554"][]["AMXO"]720.0000760.000099falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:39:51Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086f6-b1d0-7703-86f5-aeebf584159aSPY2026-09-09 12:18put_vertical_spread2120036600.00shortbid761.44000.0200["761","762"]["0.1440","0.1343"]["761.55"]["SPHR"]761.0000762.000000falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:18:50Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086a0-0a38-71c3-a4ac-b76d155ebb34SPY2026-09-09 10:43put_diagonal_spread21126110124.00longbid763.67000.0600["765","768"]["0.1463","0.1265"][]["SPHR"]765.0000768.000012falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:44:22Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0868b-f1b0-7611-b1f1-31f3beae9a8cSPY2026-09-09 10:21put_vertical_spread2111503868600.00unknown762.88820.1800["735","745"]["0.1767","0.1700"][]["XPHO"]735.0000745.0000128128falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:22:01Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0829c-fc70-7b51-bec0-cf079d33c227SPY2026-09-08 16:01put_vertical_spread2111754328700.00unknown765.88000.1500["745","755"]["0.1695","0.1635"][]["ARCO"]745.0000755.0000129129falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T20:03:21Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08295-1cd0-7a72-ab2d-2eb7ddddcb07SPY2026-09-08 15:53put_diagonal_spread2111078760.00shortask765.84500.0600["768","770"]["0.1023","1.1270"][]["SPHR"]768.0000770.000001falsefalsetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:53:33Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08262-1651-7ef3-9319-e0127e969912SPY2026-09-08 14:57put_vertical_spread2115849454.00longask767.03000.0300["750","765"]["0.1752","0.1352"]["762.69"]["SPHR"]750.0000765.000033falsetruefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T18:58:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50