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 = mlft×ticker = SMH×
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
01a091e4-5cf0-7700-9b02-cc825299233aSMH2026-09-11 15:14other815779900210.00unknown569.370024.7000["640","645","650","660","665","675","690","700"]["0.5924","0.6091","0.6287","0.6845","0.7117","0.7752","0.8688","0.8919"][]["XBOX"]640.0000700.000077falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T19:14:20Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a091a3-e509-7f61-a174-733c68e8a332SMH2026-09-11 14:03call_vertical_spread21330171600.00unknown571.55000.4400["585","605"]["0.2928","0.2964"][]["XBOX"]585.0000605.000077falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:04:32Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0919b-8c50-7331-8999-e6a5a3a1bf52SMH2026-09-11 13:54put_vertical_spread215001017500.00longask572.19002.0000["450","525"]["0.4253","0.3815"]["512.65"]["XBOX"]450.0000525.00007070falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:54:44Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0910c-f468-7b82-a6c2-fdf9606a9758SMH2026-09-11 11:18strangle211301904500.00shortbid570.97008.3500["500","700"]["0.4075","0.3658"]["353.50","846.50"]["AMXO"]500.0000700.0000644644falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T15:19:16Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08cbe-7a08-7d81-8410-cd40b0dae145SMH2026-09-10 15:14call_diagonal_spread222162916.00longbid561.24004.9500["547.5","550"]["0.5467","0.3176"][]["AMXO"]547.5000550.000014falsefalsetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T19:15:20Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08ca1-9b69-7792-96c7-442abe0a05b1SMH2026-09-10 14:43other3142863310.00unknown561.77009.6500["650","660","700"]["0.3997","0.7008","0.8955"][]["XBOX"]650.0000700.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:43:48Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c9f-6cd0-7a61-a17e-3f76fa170dbbSMH2026-09-10 14:40other71113222194688.00unknown562.060024.1000["640","645","650","665","675","695","705"]["0.6348","0.6630","0.6870","0.7633","0.8233","0.3534","0.3547"][]["XBOX"]640.0000705.0000836falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:41:19Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c99-4699-75c0-b9d2-2eb9382e33b8SMH2026-09-10 14:34other41891902360.00unknown561.680013.2500["650","680","690","700"]["0.6587","0.8072","0.8702","0.8864"][]["XBOX"]650.0000700.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T18:34:10Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bae-6998-7fb2-bed8-a89c59842f00SMH2026-09-10 10:17put_vertical_spread21100325500.00unknown558.98001.8000["560","575"]["0.3503","0.3365"][]["XBOX"]560.0000575.000088falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T14:17:42Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a087a4-4751-7a00-a652-df7c593b7f95SMH2026-09-09 15:28other331000504000.00unknown573.53001.8800["605","625","665"]["0.3281","0.3255","0.3730"][]["AMXO"]605.0000665.00001616truetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:28:32Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086e5-6fd8-7711-b756-9ea748f925baSMH2026-09-09 11:59straddle213356599500.00shortbid574.19008.9000["580"]["0.3912"]["383","777.00"]["XBOX"]580.0000580.0000464464falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T16:00:05Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a086be-c181-7f93-a512-a042e0837d86SMH2026-09-09 11:17other41639813013532.00unknown572.99001.6600["475","485","540","545"]["0.4369","0.5328","0.3861","0.3950"][]["SPHR"]475.0000545.0000937falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T15:17:44Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08698-3e20-7eb2-b59e-78d036fa2620SMH2026-09-09 10:35other2124971712.00unknown575.98500.4400["545"]["0.3770"][]["XBOX"]545.0000545.000056falsetruetruefalsefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:35:23Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a0828e-b818-7461-9cfe-dab6d5f8192cSMH2026-09-08 15:46other211400887600.00unknown572.95500.5600["530","560"]["0.4002","0.3686"][]["ARCO"]530.0000560.00001038falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:46:27Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0828a-5318-7230-85d5-542746851d80SMH2026-09-08 15:41straddle2120038400.00shortbid573.47001.7400["572.5"]["0.6471"]["570.58","574.42"]["AMXO"]572.5000572.500000falsefalsefalsefalsetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:42:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08275-c948-7b01-a79c-43db6ab6c427SMH2026-09-08 15:19put_vertical_spread2121480270.00unknown574.61005.7000["675","700"]["0.6602","0.7725"][]["XBOX"]675.0000700.00001010falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:19:15Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0826c-8a18-7912-9936-f356f765947bSMH2026-09-08 15:09put_vertical_spread2120457400.00unknown574.37005.7500["675","700"]["0.6439","0.7546"][]["XBOX"]675.0000700.00001010falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T19:09:34Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08262-54d1-7162-88ec-2056079a06aaSMH2026-09-08 14:57other214464136204.00unknown574.75003.7500["565"]["0.3804"][]["XPHO"]565.0000565.000010192falsefalsetruefalsefalsemlftmarket_whaleuw_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
01a081a7-2ac1-73c0-a2a3-766855e8518cSMH2026-09-08 11:33other4445374130.00unknown577.36844.2000["570","580"]["0.3800","0.3612"][]["AMXO"]570.0000580.00001038falsefalsetruetruetruemlftmarket_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
01a08183-b0b8-7b21-8b73-e53b50f640f9SMH2026-09-08 10:54other331261198890.00unknown575.33003.7000["570","585"]["0.3549","0.3656"][]["ARCO"]570.0000585.000038101falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:54:58Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06df3-0a46-7483-ad5c-b6ac9dd653e4SMH2026-09-04 15:43put_vertical_spread2121513996.00unknown565.40007.2500["675","700"]["0.5358","0.6247"][]["XPHO"]675.0000700.00001414falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:44:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd6-3375-7bc3-98c8-ac40ffb59fefSMH2026-09-04 15:12put_vertical_spread2121525210.00unknown563.68006.5500["675","700"]["0.6122","0.7068"][]["XBOX"]675.0000700.00001414falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:12:56Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d96-4ffd-70b3-9363-ee28da162aceSMH2026-09-04 14:02other311308687286.00unknown563.94500.5800["515","530"]["0.3498","0.3343"][]["XBOX"]515.0000530.0000714falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T18:03:22Z"}2026-09-042026-09-07 00:532026-09-07 00:53