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 = mfsl×sorted by executed_at ↑×
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
01a06dd6-2ba5-7dc1-974c-1f6eff84d20cSPX2026-09-04 15:12strangle2128250103504.00shortbid7713.260018.1000["6000","7000"]["0.2345","0.2037"]["5223.28","7776.72"]["XCBO"]6000.00007000.00005656falsefalsefalsetruetruemfslmarket_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
01a06dd7-a68d-7f01-a908-c75ad33c3a29SPX2026-09-04 15:14strangle2188691960.00shortbid7712.420038.9000["200","11200"]["1.2641","0.3286"][]["XCBO"]200.000011200.0000105105falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:14:13Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dd8-2b5d-7e51-b45c-89c8e6c0694dSPX2026-09-04 15:14synthetic21505614000.00longbid7711.94004.6000["8200"]["0.1607"]["8105.80"]["XCBO"]8200.00008200.0000469469falsefalsefalsefalsetruemfslmarket_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
01a06dde-ce95-70d1-8e91-2bafff9becdbSPX2026-09-04 15:21other43200019981800.00unknown—7713.60001.9000["7550","7720","7800"]["0.1304","0.1039","0.0926"][]["XCBO"]7550.00007800.00001414falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:21:59Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06ddf-f775-7900-83f8-78a0f514757aSPX2026-09-04 15:23other41481128432.00unknown—7712.47006.8000["6510","7060","7610","8175"]["0.2471","0.1938","0.1458","0.1226"][]["XCBO"]6510.00008175.00008787falsefalsefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:23:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de0-5535-76b0-ba94-ad35ca5adb16SPX2026-09-04 15:23synthetic212002490000.00longbid7712.32000.9000["7720"]["0.1033"]["7718.30"]["XCBO"]7720.00007720.00001414falsefalsefalsefalsetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:23:44Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de0-beae-7253-95fb-da279e5c2182SPX2026-09-04 15:23put_ratio_spread22200404640.00longbid7712.38000.4000["6800","6850"]["0.2339","0.2270"]["6844.19"]["XCBO"]6800.00006850.00004242falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:24:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de1-149e-7293-a187-6dd527a81ce0VIX2026-09-04 15:24call_ratio_spread226500731500.00longask14.32000.0600["25","60"]["1.4703","1.7853"]["25.77","102.49"]["XCBO"]25.000060.00007575falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:24:53Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de1-2055-77c0-98ac-c5ca468b0397SPX2026-09-04 15:24other2120265520.00unknown—7712.70001.1000["7630","7695"]["0.4868","0.0894"][]["XCBO"]7630.00007695.000007falsefalsetruetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:24:53Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de6-5075-7642-a777-765c4d64451aSPX2026-09-04 15:30other21248231132.00unknown—7715.25000.4000["7655","7680"]["0.0706","0.0651"][]["XCBO"]7655.00007680.000044falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:30:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06de9-619d-79a2-886e-0225eadc18d0VIX2026-09-04 15:33other3275001414125.00unknown—14.28000.1500["19","29"]["0.8915","1.5174"][]["XCBO"]19.000029.00007575falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:33:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dea-8a7d-7560-ad80-5a6cb3675c3fSPX2026-09-04 15:34call_vertical_spread21501821500.00unknown—7715.69001.1000["7700","7710"]["0.1270","0.1263"][]["XCBO"]7700.00007710.00005656falsefalsefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:34:46Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df1-c225-7df0-8647-02ae777bf0b0SPX2026-09-04 15:42other211501381800.00unknown—7714.96000.9000["7750"]["0.3354"][]["XCBO"]7750.00007750.000007falsefalsetruefalsefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:42:41Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df1-e54d-7380-96cb-6158a3085334SPX2026-09-04 15:42other21100921200.00unknown—7714.87000.6000["7750"]["0.3305"][]["XCBO"]7750.00007750.000007falsefalsetruefalsefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:43:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df3-b625-7a01-958c-b40ed0b3d2d1VIX2026-09-04 15:44other324000648960.00unknown—14.35000.2300["19","40"]["1.0680","1.4668"][]["XCBO"]19.000040.0000103103falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:45:03Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df6-bf7d-7ad0-8487-4ffae2a1447cVIX2026-09-04 15:48other212000215000.00unknown—14.37000.1100["16","18"]["0.5815","1.4857"][]["XCBO"]16.000018.00004747falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:48:12Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df7-3c7d-7c90-ab6a-7483997b2d29SPX2026-09-04 15:48call_vertical_spread231304225130.00unknown—7716.71001.8000["7800","7825"]["0.1263","0.1249"][]["XCBO"]7800.00007825.00007777falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:48:38Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06df8-0f6d-7990-b4fb-c7a50bff75cdVIX2026-09-04 15:49ratio_risk_reversal215000568000.00longbid14.39000.1200["19","40"]["0.7402","1.6705"]["40.30"]["XCBO"]19.000040.00007575falsefalsefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:49:31Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dfa-3e05-79d0-a66f-a15855ca3b1cSPX2026-09-04 15:51other31505038380.00unknown—7718.26004.1000["7720","8000"]["0.1068","0.1607"][]["XCBO"]7720.00008000.000014378falsefalsetruetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:51:59Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dfa-c2d5-7171-9aae-ea7bfb8ec16fSPX2026-09-04 15:52other413006077700.00unknown—7719.18002.5000["7500","7600","7720"]["0.1468","0.1365","0.1025"][]["XCBO"]7500.00007720.00001442falsefalsetruetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:52:44Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dfd-187d-7811-89ee-5a310f849248SPX2026-09-04 15:54synthetic211002480000.00shortask7719.92002.1000["7750"]["0.1187"]["7746.30"]["XCBO"]7750.00007750.00004242falsefalsefalsefalsetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:55:02Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dfd-6a85-7d21-8921-9a9bb9b3f326SPX2026-09-04 15:55other4355011891750.00unknown—7719.21002.8000["7500","7600","7720"]["0.1471","0.1368","0.1047"][]["XCBO"]7500.00007720.00001442falsefalsetruetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:55:19Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06dff-56b6-72b2-a2ff-a3ebc08ffc31SPX2026-09-04 15:57iron_condor41500540000.00unknown—7719.34000.4500["7640","7650","7765","7775"]["0.0795","0.0770","0.0471","0.0479"][]["XCBO"]7640.00007775.000044falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:57:24Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e01-75ad-7ed0-8a50-e2b99caae375SPX2026-09-04 15:59call_vertical_spread213107970.00unknown—7715.70002.7000["8325","8450"]["0.1342","0.1314"][]["XCBO"]8325.00008450.0000259259falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:59:49Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e03-8505-71b0-98dc-c281129ebe49SPX2026-09-04 16:01other41583064778.00unknown—7718.36003.4000["6825","7325","7750","7875"]["0.2124","0.1735","0.1451","0.1385"][]["XCBO"]6825.00007875.0000133133falsefalsefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:02:41Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e04-a9fd-7ba1-b046-41b963d0794fSPX2026-09-04 16:03risk_reversal21150069142500.00longask7718.42000.8000["7700","7720"]["0.1479","0.1352"]["7794.75"]["XCBO"]7700.00007720.0000105105falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:05:00Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e04-a9fd-7ba1-b046-41ac6c7650b1SPX2026-09-04 16:03other425500388292500.00unknown—7718.42001.9000["7600","7700","7720","7820"]["0.1545","0.1479","0.1352","0.1298"][]["XCBO"]7600.00007820.0000105105truetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:05:00Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e04-f434-7773-9099-66bd95d41811SPX2026-09-04 16:03strangle22175815500.00shortbid7718.53000.8000["6300","8500"]["0.2656","0.1134"]["6253.40","8546.60"]["XCBO"]6300.00008500.0000105105falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:05:00Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e06-76ed-7233-96b6-458958bede18SPX2026-09-04 16:05risk_reversal22125581250.00longbid7718.60000.9000["6300","8500"]["0.2656","0.1133"]["6289.52"]["XCBO"]6300.00008500.0000105105falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:07:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e06-f3ed-7062-834d-9586e90be5e4SPX2026-09-04 16:05ratio_risk_reversal2410005254500.00longbid7718.60000.6000["7500","7900"]["0.1433","0.0932"]["7491.28"]["XCBO"]7500.00007900.00002626falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:07:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e06-f3ed-7062-834d-955e2131da04SPX2026-09-04 16:05synthetic244004754000.00longbid7718.60001.4000["7725"]["0.1039"]["7716.85"]["XCBO"]7725.00007725.00001414falsefalsefalsefalsetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:07:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e07-c6dd-7361-8d8e-60b4d9e4233aSPX2026-09-04 16:06ratio_risk_reversal225002454500.00longbid7718.60000.6000["7500","7900"]["0.1433","0.0931"]["7494.26"]["XCBO"]7500.00007900.00002626falsetruefalsetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:07:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e07-c6dd-7361-8d8e-60722ab733b7SPX2026-09-04 16:06synthetic222002254000.00longbid7718.60001.2000["7725"]["0.1043"]["7710.70"]["XCBO"]7725.00007725.00001414falsefalsefalsefalsetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:07:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e09-d635-77e1-9555-1724bb7093e3SPX2026-09-04 16:08other21200916300.00unknown—7718.60001.1000["6100","6700"]["0.2846","0.2296"][]["XCBO"]6100.00006700.0000105105falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:11:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0a-189d-75a1-b3d4-fcc2a3ddb967SPX2026-09-04 16:09put_vertical_spread2225427940.00unknown—7718.60000.2000["6925","7125"]["0.3274","0.2608"][]["XCBO"]6925.00007125.000066falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:11:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0a-9985-79f1-a6db-89ad697ad112SPX2026-09-04 16:09straddle211004510000.00longask7718.60002.1000["7785"]["0.1367"]["7334","8236.00"]["XCBO"]7785.00007785.0000105105truefalsefalsefalsetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:11:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0a-c095-7322-9fa1-7d5af420f40aSPX2026-09-04 16:09put_vertical_spread2130033000.00unknown—7718.60000.2000["6925","7125"]["0.3274","0.2608"][]["XCBO"]6925.00007125.000066falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:11:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0b-5505-7580-9f84-50f868fc9a21SPX2026-09-04 16:10put_vertical_spread2227129810.00unknown—7718.60000.2000["6925","7125"]["0.3274","0.2608"][]["XCBO"]6925.00007125.000066falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T20:11:23Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0d-6845-78e3-913b-26f11e43dc19SPX2026-09-04 16:12other512505824080.00unknown—7718.60004.6000["5175","7720","8000"]["0.4009","0.1042","0.1369"][]["XCBO"]5175.00008000.000014196falsefalsetruetruetruemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-042026-09-07 00:532026-09-07 00:53
01a06e0d-ed15-7371-bc17-28019b1661d9SPX2026-09-04 16:13put_vertical_spread2125427940.00unknown—7718.60000.2000["6925","7125"]["0.3274","0.2608"][]["XCBO"]6925.00007125.000066falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-042026-09-07 00:532026-09-07 00:53
01a08137-1b40-7961-98b9-c829bbdb8f8fSPX2026-09-08 09:31put_vertical_spread2213437788.00unknown—7710.72000.1500["7640","7660"]["0.2092","0.1895"][]["XCBO"]7640.00007660.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:31:07Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08137-6578-78a2-b346-b02454fdb41fSPX2026-09-08 09:31other2255049830.00unknown—7706.81000.1000["7610","7630"]["0.2328","0.2081"][]["XCBO"]7610.00007630.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:31:35Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08137-f9e8-7ce3-a7ef-89a397139294SPX2026-09-08 09:32other2232536800.00unknown—7705.48000.1000["7620","7640"]["0.2210","0.1972"][]["XCBO"]7620.00007640.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:32:03Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08138-24e1-7492-95a4-33c2e73d1779C2026-09-08 09:32other2215002317500.00unknown—136.20501.3929["150","170"]["0.2861","0.2775"][]["XCBO"]150.0000170.0000282500falsetruetruetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:32:16Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08139-1ee1-79e2-a382-845ed56e5244SPX2026-09-08 09:33put_vertical_spread2120050000.00unknown—7702.56000.1500["7645","7650"]["0.1858","0.1800"][]["XCBO"]7645.00007650.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:33:29Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08139-1ee1-79e2-a382-843fe554722dSPX2026-09-08 09:33put_vertical_spread2120050000.00unknown—7702.56000.1500["7645","7650"]["0.1858","0.1800"][]["XCBO"]7645.00007650.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:33:29Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08139-45f0-7073-94d6-56ada94459cbSPX2026-09-08 09:33put_vertical_spread2220028400.00unknown—7702.86000.1000["7605","7645"]["0.2310","0.1832"][]["XCBO"]7605.00007645.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:33:29Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08139-de48-7313-8d6e-b0a8dad923deSPX2026-09-08 09:34other22250327000.00unknown—7705.06000.5000["6300","6400"]["0.3040","0.2902"][]["XCBO"]6300.00006400.00004545falsetruefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:34:21Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0813a-1110-7023-b5fd-b2848d5dd1e6SPX2026-09-08 09:34call_vertical_spread2220036000.00unknown—7704.98000.1500["7740","7750"]["0.1260","0.1337"][]["XCBO"]7740.00007750.000000falsetruefalsetruefalsemfsltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:34:21Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0813a-3ff0-74c1-a5a0-5ac32939c7bcSPX2026-09-08 09:34call_vertical_spread2130258120.00unknown—7705.92000.4000["7705","7720"]["0.1027","0.1012"][]["XCBO"]7705.00007720.000077falsefalsefalsetruefalsemfslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:34:38Z"}2026-09-082026-09-08 21:502026-09-08 21:50