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×net_side = bid×ticker = SPY×
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
01a0c543-3ae7-7d21-87c3-cb460869927cSPY2026-09-21 14:38put_vertical_spread217505066250.00unknownbid773.91000.2600["730","770"]["0.2003","0.1865"]["716.22"]["XPHO"]730.0000770.0000361361falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:38:51Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c506-2dfe-7461-a84e-a49bc61871a5SPY2026-09-21 13:31put_vertical_spread216001933200.00shortbid772.59990.1100["725","735"]["0.1870","0.1809"]["733.16"]["XPHO"]725.0000735.0000179179falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:32:15Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4e9-66cf-7c52-a8cf-c1fec727382cSPY2026-09-21 13:00call_vertical_spread2120026800.00shortbid772.37000.0200["772","773"]["0.1199","0.1259"]["772.44"]["SPHR"]772.0000773.000000falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T17:00:58Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4e5-387f-7661-97ed-c6edecec42feSPY2026-09-21 12:55call_vertical_spread2120025800.00shortbid772.28000.0200["772","773"]["0.1223","0.1266"]["772.43"]["SPHR"]772.0000773.000000falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:56:07Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c454-3b4f-7592-977b-bb254d4bae77SPY2026-09-21 10:17call_vertical_spread2118025920.00shortbid768.30000.0200["768","769"]["0.0997","0.1001"]["768.46"]["SPHR"]768.0000769.000000falsefalsefalsetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T14:17:44Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b4f2-605f-7480-a039-950c9bc646e1SPY2026-09-18 10:36put_vertical_spread22220294360.00unknownbid759.08000.0600["700","755"]["0.2043","0.1394"]["741.62"]["AMXO"]700.0000755.00004242falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:36:23Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4ba-ae8f-7222-934b-002dc8881d9dSPY2026-09-18 09:35other411001422100.00unknownbid760.82006.7600["742","752"]["0.1522","0.1503"][]["SPHR"]742.0000752.000035161falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T13:35:37Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b0ff-586b-7e31-9149-1a14da29439aSPY2026-09-17 16:11synthetic21150327900.00longbid762.64310.5500["775"]["0.1177"]["763"]["AMXO"]775.0000775.00002929falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T20:12:57Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b0a6-3beb-7180-a3c6-fcb9fc4b6aa6SPY2026-09-17 14:34call_vertical_spread2120561960.00shortbid762.54195.8400["520","724"]["4.0242","0.6509"]["724"]["XPHO"]520.0000724.000011falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:34:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b008-560b-7200-9b00-3c417f573723SPY2026-09-17 11:42synthetic227501619250.00shortbid762.30000.0600["740"]["0.2594"]["761.33"]["AMXO"]740.0000740.000011falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:42:26Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aba9-9f6b-7971-a6ef-396e588060ceSPY2026-09-16 15:20put_vertical_spread2111754138350.00shortbid751.32000.3000["725","735"]["0.1857","0.1783"]["732.58"]["XPHO"]725.0000735.0000121121falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:20:19Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aba5-3684-74e1-918c-da00cab63d34SPY2026-09-16 15:15put_vertical_spread21200760000.00shortbid752.04000.4200["760","770"]["0.1501","0.1486"]["763.80"]["SPHR"]760.0000770.00003030falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:15:40Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aba3-ee63-7ed0-84ab-b7adb6224315SPY2026-09-16 15:14put_vertical_spread2160101400.00shortbid751.39500.2900["730","760"]["0.1980","0.1549"]["750.20"]["SPHR"]730.0000760.00001414falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:14:11Z"}2026-09-162026-09-16 17:152026-09-16 17:15
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
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
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
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
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
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
01a08196-d711-7881-bf08-fe6b09dfa904SPY2026-09-08 11:15risk_reversal212601516060.00longbid768.00500.1800["730","845"]["0.2010","0.1405"]["726.67"]["XPHO"]730.0000845.0000374374falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T15:15:42Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a0817f-e028-7230-b790-ab100d5f4380SPY2026-09-08 10:50risk_reversal225003789500.00shortbid767.38500.4500["685","790"]["0.2189","0.1554"]["822.15"]["AMXO"]685.0000790.0000374374falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T14:50:40Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08146-2ab8-7143-ae8a-6974f1abb472SPY2026-09-08 09:47call_diagonal_spread2116237809.00shortbid767.38807.3500["700","750"]["0.4035","0.1657"][]["XBOX"]700.0000750.000010374falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T13:47:33Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a06de0-16b5-7750-83c5-7c163e760318SPY2026-09-04 15:23call_vertical_spread214001242400.00shortbid769.68000.3900["768","770"]["0.1167","0.1158"]["769.20"]["SPHR"]768.0000770.00004949truefalsefalsetruefalsemlftmarket_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
01a06dd2-95ad-75f0-976b-020a80c151e2SPY2026-09-04 15:08put_calendar2125151700.00shortbid769.64503.2500["800"]["0.1735"][]["XPHO"]800.0000800.0000710falsefalsetruefalsefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-04T19:09:09Z"}2026-09-042026-09-07 00:532026-09-07 00:53