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×direction = short×ticker = NDX×
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
01a0c595-372f-77a0-b60f-6ca83144289aNDX2026-09-21 16:08synthetic21102357600.00shortask0.000074.3000["30800"]["0.1990"]["30775"]["XPHO"]30800.000030800.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T20:09:30Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c52b-f5df-7933-a883-6342d8b66c24NDX2026-09-21 14:13synthetic216815971160.00shortbid0.000071.7000["30700"]["0.1986"]["30700"]["XPHO"]30700.000030700.00008888truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T18:13:37Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4c4-a0bf-7d23-88a6-88755b3098b4NDX2026-09-21 12:20synthetic21184248720.00shortbid0.000066.9000["30600"]["0.2005"]["30630.00"]["XPHO"]30600.000030600.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:20:24Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4c0-050f-7863-b465-e3c4128ab943NDX2026-09-21 12:15synthetic2151181300.00shortbid0.000064.0000["30600"]["0.2003"]["30650.00"]["XPHO"]30600.000030600.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:15:16Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4bb-ea47-7321-9d90-d4171e826c6fNDX2026-09-21 12:10synthetic21174011660.00shortbid0.000071.1000["30600"]["0.2005"]["30640.00"]["XPHO"]30600.000030600.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:11:01Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c4bb-3697-74f1-ae07-a0a625a9c468NDX2026-09-21 12:09synthetic21174016930.00shortbid0.000068.7000["30600"]["0.2001"]["30630.00"]["XPHO"]30600.000030600.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T16:10:14Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0c499-c02f-7eb2-b732-2cd844189f88NDX2026-09-21 11:33synthetic2171628270.00shortbid0.000059.8000["30575"]["0.1980"]["30575"]["XPHO"]30575.000030575.00008888falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-21T15:33:41Z"}2026-09-212026-09-21 17:152026-09-21 17:15
01a0b587-ab1f-72a0-b113-718c2e88445cNDX2026-09-18 13:19synthetic21173895720.00shortbid0.000036.6000["29725"]["0.1963"]["29725"]["XPHO"]29725.000029725.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b587-5cff-7a32-a8d1-e5a647e26f57NDX2026-09-18 13:18synthetic21327333120.00shortbid0.000036.6000["29725"]["0.1964"]["29735.00"]["XPHO"]29725.000029725.00009191truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:19:46Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b560-646f-7690-80c8-672a9b0cd9a8NDX2026-09-18 12:36synthetic21153443400.00shortbid0.000045.3000["29700"]["0.1972"]["29700"]["XPHO"]29700.000029700.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:37:09Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b550-e3af-7d61-a13a-bc13ea33afc4NDX2026-09-18 12:19synthetic21255745500.00shortbid0.000041.0000["29700"]["0.1971"]["29700"]["XPHO"]29700.000029700.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:19:56Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b097-43e3-70d2-8b8c-e75667e76516NDX2026-09-17 14:18synthetic213690450.00shortbid0.000036.7000["29725"]["0.1966"]["29725"]["XPHO"]29725.000029725.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:19:04Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b001-800b-7073-9913-0396c81260d9NDX2026-09-17 11:34synthetic212467060.00shortbid0.000035.7000["29700"]["0.1996"]["29700"]["XPHO"]29700.000029700.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:34:48Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0aff6-0e5b-7bb0-9b23-5430e5203a02NDX2026-09-17 11:22synthetic212466540.00shortbid0.000037.0000["29675"]["0.1996"]["29675"]["XPHO"]29675.000029675.00009292truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T15:22:46Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0afc3-ea6b-7212-8261-b0a3bedc9ad5NDX2026-09-17 10:27synthetic2111025589300.00shortbid0.000045.2000["29700"]["0.1986"]["29700"]["XPHO"]29700.000029700.00009292truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:27:45Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0ab43-b1ab-7ad0-b28d-46ca98d37e73NDX2026-09-16 13:28synthetic2151179600.00shortbid0.000035.0000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:28:54Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab41-775b-7312-aa33-b4e680361607NDX2026-09-16 13:26risk_reversal21183337200.00shortask0.000083.5000["26900","34000"]["0.2466","0.1979"]["26543"]["XPHO"]26900.000034000.0000274274falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:26:40Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab41-6f8b-76b2-a314-56d64f05f2daNDX2026-09-16 13:26synthetic21102358100.00shortbid0.000036.1000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:26:40Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab3e-eeeb-7db0-9e76-2ed29878e365NDX2026-09-16 13:23straddle2161414536.00shortbid0.000035.1000["29450"]["0.2018"]["27092.44","31807.56"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:24:04Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab3b-d9db-7393-b75f-60b5bfebeaa1NDX2026-09-16 13:20put_diagonal_spread21501184500.00shortbid0.000019.7000["25300","25500"]["0.2909","0.3052"][]["XPHO"]25300.000025500.00003065falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:21:03Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab3b-d20b-7112-99a6-8cd109d05f96NDX2026-09-16 13:20synthetic212472300.00shortbid0.000034.2000["29450"]["0.2018"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:21:03Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab2e-166b-7493-9a7e-810b8d52f985NDX2026-09-16 13:05synthetic2181882320.00shortask0.000035.0000["29475"]["0.2016"]["29445"]["XPHO"]29475.000029475.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:05:34Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaeb-681b-70a0-a49f-d0b506d2dbdfNDX2026-09-16 11:52synthetic21143311000.00shortbid0.000039.4000["29500"]["0.2022"]["29500"]["XPHO"]29500.000029500.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:53:12Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaad-7c8b-7e61-8ba0-221505cdc4bbNDX2026-09-16 10:44ratio_risk_reversal211003832400.00shortask0.000030.3000["28000","30000"]["0.2202","0.1606"]["27859.50"]["XPHO"]28000.000030000.00003030falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:45:07Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaad-70d3-7c13-a263-9958a7141f2bNDX2026-09-16 10:44synthetic21389029180.00shortbid0.000049.4000["29450"]["0.2029"]["29450"]["XPHO"]29450.000029450.00009393truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:45:07Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaa4-358b-7d72-a2d9-4747c14ed818NDX2026-09-16 10:34put_diagonal_spread21364169520.00shortask0.000033.8000["27500","29500"]["0.2384","0.1736"][]["XPHO"]27500.000029500.00003065falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:34:53Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa9d-9253-71f3-8482-7ed678debc50NDX2026-09-16 10:27risk_reversal21124348440.00shortask0.000012.0000["22800","32000"]["0.4116","0.1524"]["22787.50"]["XPHO"]22800.000032000.00003030falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:27:28Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a648-ba36-72a2-9814-1e6172070b60NDX2026-09-15 14:16synthetic2151189700.00shortbid0.000038.4000["29275"]["0.2036"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:16:33Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61f-50a5-7111-86f8-35587069842cNDX2026-09-15 13:31risk_reversal21203701400.00shortask0.000084.5000["26900","34000"]["0.2456","0.1980"]["26450"]["XPHO"]26900.000034000.0000275275falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:31:24Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a61f-48d6-7082-8de4-82f6819ff7f4NDX2026-09-15 13:31synthetic21112622290.00shortbid0.000041.3000["29250"]["0.2044"]["29250"]["XPHO"]29250.000029250.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:31:24Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5fe-ebae-7320-a6b3-b8deca270270NDX2026-09-15 12:55synthetic21255972250.00shortbid0.000039.1000["29275"]["0.2045"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:56:14Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5f3-a8de-7b91-84cd-ba5d2d0713bcNDX2026-09-15 12:43synthetic213717870.00shortbid0.000040.4000["29275"]["0.2046"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:43:54Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5e5-9366-7f52-b8c8-ffc83487f1dbNDX2026-09-15 12:27synthetic21276466770.00shortbid0.000040.9000["29250"]["0.2050"]["29280.00"]["XPHO"]29250.000029250.00009494truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:28:18Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5cf-82f6-79c1-9dbd-0534567d598aNDX2026-09-15 12:03synthetic21133113110.00shortbid0.000039.6000["29275"]["0.2052"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:04:47Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5cd-e0fe-7b61-b76a-452ed1137a1aNDX2026-09-15 12:02synthetic21317423570.00shortbid0.000039.6000["29275"]["0.2051"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:02:07Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b0-6a06-7300-bf6f-13d91742a96dNDX2026-09-15 11:29synthetic2192171610.00shortbid0.000052.2000["29275"]["0.2063"]["29275"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:30:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5a8-867e-7092-a6df-41b037177375NDX2026-09-15 11:21synthetic21245794800.00shortbid0.000037.9000["29275"]["0.2063"]["29275"]["XPHO"]29275.000029275.00009494truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:21:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a593-5c86-7fa3-9a27-2329b21bec36NDX2026-09-15 10:58straddle21133139552.00shortbid0.000041.3000["29275"]["0.2071"]["26859.96","31690.04"]["XPHO"]29275.000029275.00009494truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:58:22Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a122-b8d8-7552-94e4-11997de6afe8NDX2026-09-14 14:16synthetic21102422700.00shortbid0.0000140.3000["29575"]["0.2043"]["29575"]["XPHO"]29575.000029575.00009595truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T18:17:24Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0b0-d498-7483-9e40-4abe027a76a4NDX2026-09-14 12:12synthetic21112648360.00shortbid0.000090.9000["29450"]["0.2049"]["29450"]["XPHO"]29450.000029450.00009595truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:12:19Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a097-d240-7a61-9fe0-3c83ff935320NDX2026-09-14 11:44straddle2115510108635.00shortbid0.000064.2000["29000"]["0.1846"]["28347.83","29652.17"]["XPHO"]29000.000029000.000088truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:45:15Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a097-93c1-7f01-9644-0dc824acdb3aNDX2026-09-14 11:44straddle211477671489.00shortbid0.000047.6000["29000"]["0.2116"]["28478.13","29521.87"]["XPHO"]29000.000029000.000044falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:44:52Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a087-0190-7062-b12d-719b0dc254f7NDX2026-09-14 11:26straddle21153630000.00shortbid0.0000144.8000["29350"]["0.2063"]["26930","31770.00"]["XPHO"]29350.000029350.00009595truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:26:48Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091cf-c768-7010-9c23-260d7d3db6b4NDX2026-09-11 14:51synthetic2111552860.00shortask0.000010.5000["29450"]["0.1586"]["29430"]["XPHO"]29450.000029450.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:52:07Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a0919a-ec28-7602-a627-92db509ddc2bNDX2026-09-11 13:54put_vertical_spread2124814080.00shortbid0.000021.8000["23000","28500"]["0.3968","0.2036"]["28211.90"]["XPHO"]23000.000028500.00003535falsefalsefalsetruefalsemlftmarket_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
01a0919a-c518-77e2-97be-4d6a4d6b6fe1NDX2026-09-11 13:53synthetic216304080.00shortbid0.000011.3000["29450"]["0.1588"]["29464.00"]["XPHO"]29450.000029450.000077falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T17:53:52Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c56-51f8-7371-8458-41fd57a35a4eNDX2026-09-10 13:20straddle2110662260.00shortbid0.000056.4000["29225"]["0.1969"]["28562.74","29887.26"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:21:33Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c50-75f8-7ac0-9868-c7c0fd536b35NDX2026-09-10 13:14synthetic217473130.00shortbid0.000038.3000["29225"]["0.1974"]["29225"]["XPHO"]29225.000029225.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T17:14:37Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08c33-29f8-7351-b02e-f1fd8742ac8bNDX2026-09-10 12:42synthetic21181223820.00shortbid0.000036.6000["29175"]["0.2017"]["29175"]["XPHO"]29175.000029175.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T16:43:00Z"}2026-09-102026-09-10 17:152026-09-10 17:15
01a08bf1-a0a0-7722-9107-db04512bba0fNDX2026-09-10 11:31synthetic213203250.00shortbid0.000037.3000["29200"]["0.1979"]["29230.00"]["XPHO"]29200.000029200.000088falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-10T15:31:24Z"}2026-09-102026-09-10 17:152026-09-10 17:15