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×net_side = ask×
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
01a0b5f5-9ba8-7433-99fe-2c9669f57856UBER2026-09-18 15:19put_vertical_spread21100177200.00unknownask70.65001.6500["79","80"]["0.4504","0.4922"]["70.64"]["XPHO"]79.000080.000077falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:19:45Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f5-45b7-7942-b605-6dcfeb1fb701PEP2026-09-18 15:19put_vertical_spread2125112300.00unknownask129.96045.1000["150","155"]["0.3367","0.3987"]["130.04"]["XPHO"]150.0000155.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:19:22Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f3-d687-7c80-9b66-873877cbfd01XOM2026-09-18 15:17call_diagonal_spread21220964700.00shortask162.09000.9500["145","165"]["0.2767","0.2475"][]["AMXO"]145.0000165.0000119490falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:17:49Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f1-a020-7fd2-921c-9e7986e0419aQQQ2026-09-18 15:15strangle22150209400.00longask719.22000.0400["710","740"]["0.1812","0.1447"]["696.04","753.96"]["AMXO"]710.0000740.00002828falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:15:21Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f1-1f38-7540-9d6b-f1832bc8d651SMH2026-09-18 15:14synthetic2130057000.00longask565.44000.4300["565"]["0.4447"]["565.70"]["XPHO"]565.0000565.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:14:50Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5f0-d4ff-7e93-be12-2fee9a3b97c9DIA2026-09-18 15:14straddle22500186000.00longask516.29000.3100["520"]["0.3242"]["516.28","523.72"]["AMXO"]520.0000520.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:14:17Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ed-42f0-7ae3-b4cd-24234b490d81CORZ2026-09-18 15:10call_diagonal_spread211900146300.00unknownask17.63000.1800["17.5","18.5"]["1.4975","0.6761"][]["XPHO"]17.500018.5000014falsefalsetruetruefalsemlftmarket_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
01a0b5ec-25c8-78b3-bbcc-cd6e29ff9e22SYF2026-09-18 15:09call_vertical_spread21528217008.00unknownask74.85500.4500["75","77.5"]["0.3108","0.3004"]["78.30"]["XBOX"]75.000077.50002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:09:26Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ea-d9bf-7163-9c72-0512485ba026AMD2026-09-18 15:07call_diagonal_spread21126536760.00unknownask544.65001.2500["510","585"]["4.3485","0.4883"][]["XBOX"]510.0000585.0000014falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:08:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ea-742f-7fc1-9786-9602819871a0NOC2026-09-18 15:07put_vertical_spread211004906000.00unknownask525.940015.0000["760","780"]["0.5359","0.5651"]["524.70"]["XPHO"]760.0000780.0000119119falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:07:33Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e9-bc97-7730-920f-19a2c5178665NEE2026-09-18 15:06put_diagonal_spread21100144600.00unknownask80.57502.6000["85","90"]["0.3829","0.4667"][]["XPHO"]85.000090.0000714falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:06:39Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e9-2ff7-7cc0-a5ce-ea28b0ac5b70MU2026-09-18 15:05put_vertical_spread212324825600.00unknownask1009.31608.1500["720","780"]["0.5996","0.5999"]["646"]["XPHO"]720.0000780.0000455455falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:06:15Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5e4-f9d7-7bc0-92f3-760d54bf3186GGAL2026-09-18 15:01call_calendar211990415910.00unknownask41.75500.3500["50"]["0.4650"][]["XBOX"]50.000050.000028119falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T19:01:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5df-4cb7-7a40-9cac-ed61e579294fMU2026-09-18 14:55call_diagonal_spread221001443000.00unknownask1008.62008.7500["900","1000"]["0.4826","0.4905"][]["AMXO"]900.00001000.0000710falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:55:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5df-2990-7672-b7b1-a5a49fbe9679AEM2026-09-18 14:54straddle223002901000.00longask199.70005.7000["240"]["0.4857"]["143.30","336.70"]["AMXO"]240.0000240.0000490490truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:55:08Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5dd-d5b7-7992-aac3-1439cbfd28a5NVO2026-09-18 14:53strangle22800368000.00longask43.49500.2100["35","55"]["0.4176","0.3832"]["30.40","59.60"]["AMXO"]35.000055.0000272272falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:53:29Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5db-87df-70c2-af5e-3eb72ec4bcc3FPS2026-09-18 14:50call_ratio_spread21750222000.00longask39.31500.6000["45","55"]["0.7493","0.7327"]["46.44","72.12"]["SPHR"]45.000055.00006363falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:51:00Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d9-d260-7f01-8f85-e990a0884e3bCOST2026-09-18 14:49put_calendar2130217050.00unknownask897.12008.7500["925"]["0.3049"][]["AMXO"]925.0000925.0000721falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:49:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d8-5390-7d62-86c0-95dd049edcfeAAPL2026-09-18 14:47call_vertical_spread215445684.00longask336.16000.2500["335","337.5"]["0.2260","0.2178"]["336.4"]["SPHR"]335.0000337.500077falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:47:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d7-0f57-7782-93b5-e51e723580e8BURL2026-09-18 14:46put_vertical_spread21300029970000.00unknownask238.27507.2000["285","290"]["0.6408","0.6877"]["237.55"]["XPHO"]285.0000290.00001414falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:46:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d6-ccf0-7192-8a81-ff4720fe4214BKNG2026-09-18 14:45other311401044320.00unknownask168.160010.7000["200","205","215"]["0.6933","0.6013","1.2395"][]["XPHO"]200.0000215.0000721falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:46:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d4-adf8-7a41-b4cd-6e1e2e66269bHIMS2026-09-18 14:43call_calendar21100159200.00shortask27.93000.4500["20"]["8.1276"][]["SPHR"]20.000020.0000028falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:43:51Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d3-8ce8-73d2-89a6-aecec467e3abXLF2026-09-18 14:42other441250014887500.00unknownask55.88500.3300["50"]["2.4658"][]["AMXO"]50.000050.0000028falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:42:16Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d2-6bd7-76b1-9d5a-420925d36171AMZN2026-09-18 14:40call_diagonal_spread213751357875.00shortask253.27501.3500["235","245"]["3.5088","0.3783"][]["AMXO"]235.0000245.0000042falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:41:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d0-c20f-7a81-958b-675b54095fafJNJ2026-09-18 14:39put_frontspread216783542220.00longask271.38000.4500["260","265"]["0.2413","0.2460"]["257.68"]["SPHR"]260.0000265.000077falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:39:24Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d0-a2d0-7032-b1db-4db9ec95147cMARA2026-09-18 14:39call_vertical_spread211800189000.00unknownask13.18500.0300["13","14"]["0.8548","0.8735"]["14.02"]["XBOX"]13.000014.000077falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:39:24Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5d0-9aff-74f2-95ce-35ea815cc220DIA2026-09-18 14:39call_calendar22100380500.00shortask515.90007.3000["545"]["0.1331"][]["AMXO"]545.0000545.0000272285falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:39:24Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cf-cbf7-7302-83ad-c3cf60da330bHYG2026-09-18 14:38call_diagonal_spread2210000130000.00shortask78.54500.1500["79","80"]["0.0191","0.0097"][]["AMXO"]79.000080.000028119falsetruetruetruefalsemlftmarket_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
01a0b5cf-81c0-71b3-92a7-55073b061d68IWM2026-09-18 14:37synthetic2247876002.00shortask283.45500.1200["285"]["0.2735"]["283.45"]["AMXO"]285.0000285.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:38:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cc-ce57-75d0-ab55-fec594c20be1DIA2026-09-18 14:34call_calendar22100380500.00shortask515.97007.3000["545"]["0.1329"][]["AMXO"]545.0000545.0000272285falsetruetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:35:01Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5cb-4f88-7822-9b2f-7b841a01f036QQQ2026-09-18 14:33ratio_risk_reversal22420221200.00longask717.88500.0200["710","722"]["0.1603","0.1221"]["723.29"]["AMXO"]710.0000722.000077falsetruefalsetruetruemlftmarket_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
01a0b5c8-0b97-7f73-969c-e52e82cbda99AA2026-09-18 14:29call_vertical_spread215000590000.00longask44.61000.0700["50","55"]["0.5334","0.5337"]["50.64"]["AMXO"]50.000055.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:29:54Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c5-294f-7cb2-8888-b84f8f3d5e4eQQQ2026-09-18 14:26ratio_risk_reversal22420222880.00longask717.80600.0300["710","722"]["0.1605","0.1235"]["723.29"]["AMXO"]710.0000722.000077falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:26:45Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5c1-e178-7e43-a67a-03f36628a703META2026-09-18 14:22straddle2110044400.00longask671.36500.3400["670"]["0.5915"]["665.56","674.44"]["AMXO"]670.0000670.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:23:14Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bf-d607-7c53-8fae-80c07746e8fbGLW2026-09-18 14:20put_diagonal_spread212501136000.00shortask149.07004.0500["100","170"]["0.6325","0.5981"][]["SPHR"]100.0000170.0000119490falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:20:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bf-60d8-7eb3-aaee-83a0cb381b61WBD2026-09-18 14:20put_vertical_spread211000115000.00longask27.92500.2300["25","28"]["0.3813","0.3097"]["27.25"]["SPHR"]25.000028.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:20:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5bc-1517-79d0-afae-e8a6dc31f1dfPLTR2026-09-18 14:16call_diagonal_spread2189742527.00shortask176.32000.5500["130","140"]["8.0862","0.5871"][]["SPHR"]130.0000140.0000021falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:16:59Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5ba-adb7-7ee1-a12d-f63846045f31IREN2026-09-18 14:15ratio_risk_reversal21500473750.00unknownask45.73500.4500["35","55"]["0.8940","0.8928"]["25.52","73.95"]["SPHR"]35.000055.0000182182falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:15:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b5-f2c8-7b32-a186-7b4ef3772099CLX2026-09-18 14:09straddle2110002630000.00longask83.68842.2000["90"]["0.3406"]["63.70","116.30"]["AMXO"]90.000090.0000490490truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:10:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b5-d387-7310-b1f8-9b60d929d013MDT2026-09-18 14:09call_diagonal_spread21662678550.00unknownask92.43001.0100["85","97.5"]["3.6947","0.2358"][]["AMXO"]85.000097.5000091falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:10:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b4-412f-74c2-b84a-3a6e5fb8980bCOP2026-09-18 14:08call_diagonal_spread22366750300.00shortask131.79000.6500["115","145"]["3.5750","0.3029"][]["ARCO"]115.0000145.0000091falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:08:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b4-412f-74c2-b84a-39ce4d24e57cKRYS2026-09-18 14:08call_diagonal_spread2158302528.00shortask336.90006.7000["310","320"]["3.8842","0.3855"][]["SPHR"]310.0000320.0000028falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:08:13Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b5b1-8dc7-7260-ad4a-406c053e3b42QQQ2026-09-18 14:05put_vertical_spread227002647400.00unknownask717.55500.3800["610","690"]["0.2700","0.2291"]["652.18"]["AMXO"]610.0000690.0000182182falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:05:06Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59f-de6f-7492-8296-d1724d31e853META2026-09-18 13:45straddle2110046000.00longask671.37500.5300["670"]["0.5220"]["665.40","674.60"]["XPHO"]670.0000670.000000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:46:22Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59f-9437-7a12-b2ab-b1ed3263ffe4HYG2026-09-18 13:45put_vertical_spread224200504000.00unknownask78.50500.1500["78","79"]["0.0733","0.0847"]["77.90"]["AMXO"]78.000079.00002828falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:45:43Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59d-6d6f-7e73-b8c4-16d837c384bdV2026-09-18 13:43synthetic22877397281.00longask369.43990.1800["365"]["0.4136"]["369.51"]["AMXO"]365.0000365.000000falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:43:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59c-ec88-7db2-ab3d-df4d7e240ba9EWZ2026-09-18 13:42call_vertical_spread211000163000.00unknownask37.41500.0600["39","42"]["0.4401","0.4249"]["40.63"]["ARCO"]39.000042.00002828falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:43:04Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59a-8b27-7040-96e3-cab3306baf7eQQQ2026-09-18 13:39call_diagonal_spread215009100000.00unknownask717.39005.5200["555","697"]["0.8873","0.2056"][]["XPHO"]555.0000697.000037truefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:40:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b59a-19df-76f1-91b9-d1f712206ad6SXT2026-09-18 13:39call_calendar21100200000.00unknownask129.00004.8000["120"]["2.3409"][]["XPHO"]120.0000120.0000028falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:40:12Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b599-a4af-7b13-8e97-d399d35d41c0META2026-09-18 13:38call_diagonal_spread215007746500.00longask670.61004.0500["625","670"]["0.4380","0.4229"][]["SPHR"]625.0000670.000063154falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:39:27Z"}2026-09-182026-09-18 17:152026-09-18 17:15