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:net_side = ask×ticker = SPY×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
01a06d23-75a5-7c33-ba4b-a0a5112faaecSPY2026-09-04 11:57call_vertical_spread21162072016.00longask769.72006.8800["50","195"]["2.0948","0.6017"]["194.63"]["C2OX"]50.0000195.0000133133falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T15:57:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d27-136d-7763-afb0-6848cc784800SPY2026-09-04 12:01call_vertical_spread21135106515.00longask770.00000.0500["765","770"]["0.0660","0.0611"]["768.63"]["XCBO"]765.0000770.000044falsefalsefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:01:34Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d27-136d-7763-afb0-68392544eb21SPY2026-09-04 12:01call_vertical_spread216551285.00longask770.00000.0500["765","770"]["0.0660","0.0611"]["768.63"]["XISX"]765.0000770.000044falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:01:34Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d28-4035-71a0-8628-ace9e0b939d2SPY2026-09-04 12:02call_diagonal_spread_bearish21227820.00shortask769.91006.3300["701","705"]["0.3368","0.1471"][]["XISX"]701.0000705.00001449falsefalsetruetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:03:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d29-2a95-77d3-ba39-d2ed8956e3eeSPY2026-09-04 12:03put_frontspread211028550.00longask769.95000.0600["765","770"]["0.1511","0.1487"]["743.38"]["XISX"]765.0000770.0000105105falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:03:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d29-3e1e-76a1-9c9b-c62550376d1fSPY2026-09-04 12:03call_vertical_spread22253842.00longask769.89005.8400["653","658"]["0.1943","0.1923"]["657.51"]["EMLD","SPHR"]653.0000658.0000208208falsefalsefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:03:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d2d-be75-7cd2-aff6-79dcfdbc930fSPY2026-09-04 12:08call_condor41100217900.00longask770.38000.1000["770","775","780","790"]["0.0965","0.0937","0.0915","0.0887"]["770.01","784.99"]["XMIO"]770.0000790.00002626falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:08:43Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d30-a88d-7020-a74f-3eedc3e0b490SPY2026-09-04 12:11put_vertical_spread214055160.00longask770.47000.0400["655","730"]["0.2399","0.1754"]["723.61"]["EDGO"]655.0000730.0000105105falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:12:10Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d31-5c3d-7ff0-b15e-520f4a760090SPY2026-09-04 12:12call_diagonal_spread_bearish2110044700.00shortask770.42500.0300["767","773"]["0.1502","0.0578"][]["XCBO"]767.0000773.000004falsefalsetruetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:12:46Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d33-5fdd-7552-9198-45755f1bc966SPY2026-09-04 12:14put_vertical_spread2210025800.00longask770.69000.0200["771","772"]["0.1244","0.1293"]["771.32"]["XISX"]771.0000772.000000falsefalsefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:14:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d36-078e-7171-b733-cefcca9ca19aSPY2026-09-04 12:17put_vertical_spread215534980.00longask770.69000.0300["735","755"]["0.1608","0.1371"]["752.50"]["XBOX"]735.0000755.00002626falsetruefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:17:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d36-078e-7171-b733-ceeec2818fddSPY2026-09-04 12:17put_vertical_spread22204129744.00longask770.69000.0200["735","755"]["0.1608","0.1371"]["752.50"]["ARCO"]735.0000755.00002626falsetruefalsetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:17:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d36-078e-7171-b733-ced47ac86dccSPY2026-09-04 12:17put_vertical_spread21181115116.00longask770.69000.0200["735","755"]["0.1608","0.1371"]["752.50"]["ARCO"]735.0000755.00002626falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:17:45Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d3f-8925-78b1-8297-3010c10016c3SPY2026-09-04 12:27put_vertical_spread215043650.00longask770.78000.0300["755","770"]["0.1358","0.1221"]["765.87"]["XCBO"]755.0000770.00001414falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:28:31Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d41-2f05-7630-8bb6-faa0f46c5daaSPY2026-09-04 12:29call_calendar2124420096.00longask770.64006.7600["685"]["0.2372"][]["XISX"]685.0000685.00002842falsefalsetruefalsefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:29:55Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d42-6b6d-7ae0-9b8a-7c5569264d7aSPY2026-09-04 12:31synthetic213931239.00shortask770.60500.0200["771"]["0.0941"]["770.99"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:31:08Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d45-2e75-7230-9f78-ed46f41b0651SPY2026-09-04 12:34straddle2111390513.00longask770.83000.0200["771"]["0.0940"]["762.99","779.01"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:34:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d45-2e75-7230-9f78-ed50e8b5f107SPY2026-09-04 12:34straddle214536045.00longask770.82500.0200["771"]["0.0940"]["762.99","779.01"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:34:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d45-41fd-77b2-bde3-96962bd0634dSPY2026-09-04 12:34put_diagonal_spread_bearish214533930.00longask770.82000.0300["715","730"]["0.2037","0.1725"][]["EDGO"]715.0000730.00001477falsetruetruetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:34:11Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d46-342d-76b0-8931-9bda8685ce80SPY2026-09-04 12:35straddle213326433.00longask770.88600.0200["771"]["0.0940"]["762.99","779.01"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:35:27Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d46-b515-7093-93a7-53195e7f7491SPY2026-09-04 12:35call_calendar2110756282.00shortask770.88000.0300["769"]["0.0909"][]["XISX"]769.0000769.000004falsefalsetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:36:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d46-f395-7443-bc14-0015990f9d53SPY2026-09-04 12:35put_vertical_spread258937291.00longask770.87000.0200["763","768"]["0.1060","0.0990"]["766.77"]["ARCO","BATO","C2OX","EMLD"]763.0000768.000077falsetruefalsetruefalsemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:36:06Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d47-5d0d-7890-b3b5-d6b3a625470cSPY2026-09-04 12:36call_calendar21629544.00shortask770.81501.3800["775"]["0.1280"][]["C2OX"]775.0000775.000056175falsetruetruefalsefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:36:48Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d47-ce55-7e23-99ce-f666330ae30aSPY2026-09-04 12:36put_vertical_spread219439950.00longask770.75000.0200["763","768"]["0.1058","0.0989"]["766.75"]["MCRY"]763.0000768.000077falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:37:38Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d47-e5c5-7f01-9c2a-1b0bacffd818SPY2026-09-04 12:37put_vertical_spread213026190.00longask770.75010.0300["755","770"]["0.1355","0.1221"]["765.85"]["XCBO"]755.0000770.00001414falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:37:38Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d49-a6fd-7753-a1e7-d9cc1d296c68SPY2026-09-04 12:38call_vertical_spread211032140.00longask770.75500.0600["775","785"]["0.1253","0.1200"]["780.34"]["XCBO"]775.0000785.00007777falsetruefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:39:03Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4a-ef1d-72b1-8316-50f42ca53339SPY2026-09-04 12:40put_vertical_spread235240248.00longask770.78000.0200["760","765"]["0.1295","0.1250"]["763.66"]["EMLD","SPHR","XISX"]760.0000765.00001414falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:40:28Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4c-3f0d-75b3-b54f-5c902384a0f9SPY2026-09-04 12:41straddle219676704.00longask770.74000.0200["771"]["0.0938"]["763.01","778.99"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:41:49Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4c-fa8d-7290-ad72-068770fb6a6eSPY2026-09-04 12:42straddle2211087890.00longask770.76600.0200["771"]["0.0938"]["763.01","778.99"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:43:14Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4d-0e15-7c90-a837-dd0803c18548SPY2026-09-04 12:42straddle218567915.00longask770.74000.0200["771"]["0.0938"]["763.01","778.99"]["XISX"]771.0000771.000077falsefalsefalsefalsetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:43:14Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4d-fc5d-7b33-b013-a6f08b14dae9SPY2026-09-04 12:43put_vertical_spread21400166400.00longask770.83000.0300["763","768"]["0.1051","0.0984"]["766.76"]["MCRY"]763.0000768.000077falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:43:54Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4e-4e66-7ff3-9c89-363250bdc26dSPY2026-09-04 12:44put_vertical_spread2116032960.00longask770.94000.0300["771","772"]["0.1154","0.1186"]["771.36"]["XMIO"]771.0000772.000000falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:44:29Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d4f-f82d-70f0-bd3b-60da27fc6772SPY2026-09-04 12:45risk_reversal212428800.00shortask770.94770.0500["730","810"]["0.1724","0.1115"]["727.60"]["XMIO"]730.0000810.00007777falsetruefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:45:52Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d50-cb1d-7090-9aa2-de1c655698d2SPY2026-09-04 12:46risk_reversal2149123725.00longask770.97000.0900["768","769"]["0.1321","0.1115"]["772.75"]["XBOX"]768.0000769.00004242falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:47:14Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d51-57bd-7490-8cbc-98b73e776de3SPY2026-09-04 12:47risk_reversal2151128775.00longask771.10990.0400["768","769"]["0.1320","0.1113"]["772.89"]["XISX"]768.0000769.00004242falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:47:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d51-57bd-7490-8cbc-98e8091f99ddSPY2026-09-04 12:47risk_reversal21134338350.00longask771.10990.0400["768","769"]["0.1320","0.1113"]["772.89"]["XISX"]768.0000769.00004242falsefalsefalsetruetruemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:47:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d51-5f8d-7730-b4a4-4aa6f702f251SPY2026-09-04 12:47risk_reversal212358075.00longask771.10000.0400["768","769"]["0.1319","0.1114"]["772.89"]["XBOX"]768.0000769.00004242falsefalsefalsetruetruemesltrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:47:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-555d-7900-a41c-6945db07ae7bSPY2026-09-04 12:50put_vertical_spread21644940.00longask771.22001.6500["790","810"]["0.1460","0.1486"]["797.40"]["AMXO"]790.0000810.0000133133falsefalsefalsetruefalsemlattrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:50:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-5175-71b1-b1d5-b684f43b27f0SPY2026-09-04 12:50call_ratio_spread24100200082.00longask771.22000.0700["790","815"]["0.1264","0.1187"]["790.05","839.95"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:50:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-843e-7953-99a2-f4a65e3bcbfbSPY2026-09-04 12:50call_ratio_spread243468017.00longask771.22000.0700["790","815"]["0.1264","0.1187"]["790.05","839.95"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:50:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d54-af35-7450-966a-5b21b28b0698SPY2026-09-04 12:50call_ratio_spread21100200250.00longask771.25000.0800["790","815"]["0.1264","0.1187"]["790.05","839.95"]["XMIO"]790.0000815.0000133133falsetruefalsetruefalsemlatmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9c42aab8d92SPY2026-09-04 12:51call_ratio_spread24450900564.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.04","839.96"]["ARCO","EDGO","XCBO","XISX"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9bc52835036SPY2026-09-04 12:51call_ratio_spread2270140107.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["MCRY","XPHO"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9ae75efe81aSPY2026-09-04 12:51call_ratio_spread213672090.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["XPHO"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f99ebc7b01afSPY2026-09-04 12:51call_ratio_spread213672090.00longask771.21000.0700["790","815"]["0.1265","0.1188"]["790.05","839.95"]["XPHO"]790.0000815.0000133133falsetruefalsetruefalsemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-013d-7053-9f1a-f9836f792dc7SPY2026-09-04 12:51call_ratio_spread23108216054.00longask771.21000.0633["790","815"]["0.1264","0.1187"]["790.05","839.95"]["MCRY","XBOX","XPHO"]790.0000815.0000133133falsetruefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:51:42Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d55-6ab5-7583-acc8-7ce2018df39aSPY2026-09-04 12:51call_diagonal_spread_bearish2118225378.00shortask771.24005.3300["700","740"]["0.1860","0.1418"][]["MCRY"]700.0000740.000026133falsefalsetruetruefalsemeslmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:52:22Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d57-4f15-7f00-98ec-b5b8a1f063d5SPY2026-09-04 12:53call_vertical_spread215681245.00longask771.21807.2200["80","100"]["1.5928","1.3738"]["99.95"]["XMIO"]80.0000100.0000133133falsefalsefalsetruefalsemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:54:16Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d59-857d-7530-b31c-01400092ab94SPY2026-09-04 12:56risk_reversal211660976.00shortask771.15000.1200["695","885"]["0.2124","0.1317"]["688.19"]["XISX"]695.0000885.0000378378falsetruefalsetruetruemlettrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:56:20Z"}2026-09-042026-09-07 00:532026-09-07 00:53
01a06d59-bc2d-7353-9862-b6bbae321deeSPY2026-09-04 12:56strangle21171122094.00longask771.10000.0200["770","772"]["0.0980","0.0919"]["762.86","779.14"]["MCRY"]770.0000772.000077falsetruefalsetruetruemletmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T16:56:58Z"}2026-09-042026-09-07 00:532026-09-07 00:53