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 = mlft×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
01a0aa9d-8a83-7252-923c-58838e66c8beNDX2026-09-16 10:27synthetic2151187000.00longbid0.000043.4000["29475"]["0.2032"]["29475"]["XPHO"]29475.000029475.00009393truefalsefalsefalsetruemlftmarket_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
01a0a6b4-2a1e-7510-b097-999123c1e753NDX2026-09-15 16:13straddle212477052.00longask0.000061.6000["29275"]["0.2047"]["26889.74","31660.26"]["XPHO"]29275.000029275.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a67f-7dbe-78e0-ba13-1965d3670de8NDX2026-09-15 15:16other41258345544.00unknown—0.0000121.8000["29000","31000","32000"]["0.2200","0.2106","0.2048"][]["XPHO"]29000.000032000.00003275falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:16:20Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a670-33ad-77f1-b06f-eb52f57180d7NDX2026-09-15 14:59other41258355918.00unknown—0.0000121.1000["29000","31000","32000"]["0.2216","0.2106","0.2047"][]["XPHO"]29000.000032000.00003275falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:00:00Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a65d-4fbe-7342-a925-5254bd67cb5dNDX2026-09-15 14:38other21363584.00unknown—0.000037.9500["23000","32500"]["0.3010","0.1633"][]["XPHO"]23000.000032500.000031185falsefalsetruetruetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:38:51Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a649-5a5e-7280-b30b-2be7e3b24e05NDX2026-09-15 14:16call_diagonal_spread21322790144.00unknown—0.000051.7000["30000","32000"]["0.2070","0.1685"][]["XPHO"]30000.000032000.000066185falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:17:20Z"}2026-09-152026-09-15 19:282026-09-15 19:28
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
01a0a63d-2945-7741-b34b-c85a34f98b08NDX2026-09-15 14:03other414813795968.00unknown—0.000048.4000["29000"]["0.2144"][]["XPHO"]29000.000029000.0000394falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:03:56Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a63b-d956-7b83-8008-9cb05812eff9NDX2026-09-15 14:02synthetic214811682192.00longask0.000037.0000["29000"]["0.2086"]["29261.05"]["XPHO"]29000.000029000.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:02:18Z"}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
01a0a61e-db76-7e92-819b-6a1a905aebd4NDX2026-09-15 13:30synthetic2151190900.00longbid0.000039.5000["29300"]["0.2036"]["29270"]["XPHO"]29300.000029300.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T17:30:34Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5fe-f37d-7d12-bf8a-99ffae35e5abNDX2026-09-15 12:55other31502706900.00unknown—0.000031.6000["24000","27500","30000"]["0.3072","0.2373","0.1619"][]["XPHO"]24000.000030000.00003194falsefalsetruetruetruemlftmarket_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
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
01a0a5f3-9555-71a3-9269-f0eca53eff35NDX2026-09-15 12:43other2120437120.00unknown—0.000023.4000["27500","35000"]["0.3500","0.1879"][]["XPHO"]27500.000035000.00003185falsefalsetruetruetruemlftmarket_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
01a0a5e8-3b15-74a2-93ca-73fa13f1d4d3NDX2026-09-15 12:30synthetic212478200.00longbid0.000037.6000["29300"]["0.2041"]["29280"]["XPHO"]29300.000029300.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:31:03Z"}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-8ac6-75d1-8271-b97b028602f4NDX2026-09-15 12:03put_frontspread211001668000.00longask0.000010.1000["28200","29000"]["0.2820","0.2226"]["27540","28860"]["XPHO"]28200.000029000.000033falsefalsefalsetruefalsemlftmarket_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
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-e8ce-77b1-b1df-f82b4f2aceaaNDX2026-09-15 12:02put_diagonal_spread21524437420.00unknown—0.000034.9000["19000","29500"]["0.4341","0.1763"][]["XPHO"]19000.000029500.00003194falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T16:02:54Z"}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
01a0a5c2-e095-7203-9f46-1006ad85123eNDX2026-09-15 11:50other41226256608.00unknown—0.0000127.5500["30000","30200","31600","35500"]["0.2083","0.1959","0.1836","0.1881"][]["XPHO"]30000.000035500.0000122185falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:50:06Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5bd-8d4e-7bf0-8ca1-42d926837763NDX2026-09-15 11:44other4181176288.00unknown—0.0000165.0000["28800","29500","29700"]["0.1942","0.1741","0.1659"][]["XPHO"]28800.000029700.00002829truefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:44:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5bd-8d4e-7bf0-8ca1-41ed3eae803aNDX2026-09-15 11:44straddle21112651000.00longask0.000039.5000["29300"]["0.2053"]["26890","31710.00"]["XPHO"]29300.000029300.00009494falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:44:37Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a5b0-71d6-7d03-bad0-89e7a3f90943NDX2026-09-15 11:29other21781380288.00unknown—0.000027.7000["22800","31000"]["0.4136","0.1846"][]["XPHO"]22800.000031000.00003194falsefalsetruetruetruemlftmarket_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
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-8e4e-7a23-9aea-09ba1ea24a44NDX2026-09-15 11:21call_diagonal_spread2113811391072.00unknown—0.000018.5000["29500","30500"]["0.2025","0.1563"][]["XPHO"]29500.000030500.00003194falsefalsetruetruefalsemlftmarket_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
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
01a0a5a7-8896-79e3-bb3f-948b114c82baNDX2026-09-15 11:20call_ratio_spread21302254250.00unknown—0.000071.2000["28500","28975"]["0.2606","0.2263"][]["XPHO"]28500.000028975.000033falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T15:20:25Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a593-e925-75a3-85ea-5ec1e436ee38NDX2026-09-15 10:58other31452964750.00unknown—0.000053.6000["26600","29200","38000"]["0.2714","0.1862","0.1995"][]["XPHO"]26600.000038000.000031275falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T14:59:00Z"}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-c490-7e23-b78a-55dd1f4fc9f5NDX2026-09-14 14:16other21303838380.00unknown—0.000080.6000["30000","33000"]["0.1984","0.1912"][]["XPHO"]30000.000033000.000095186falsefalsetruetruefalsemlftmarket_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
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
01a0a0c3-2be8-7bf0-8750-61bdfed742d6NDX2026-09-14 12:32ratio_risk_reversal21381175004.00longask0.000035.0000["26600","29800"]["0.2663","0.1687"]["29947.50"]["XPHO"]26600.000029800.00003232falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:32:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0c3-1c48-79c2-9335-2761cb51f223NDX2026-09-14 12:32synthetic21112647150.00longbid0.000061.9000["29500"]["0.2038"]["29500"]["XPHO"]29500.000029500.00009595falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:32:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a0ba-7570-7aa2-80af-aeb6e5405687NDX2026-09-14 12:22other2112741512.00unknown—0.000063.4000["30000","31000"]["0.2112","0.1513"][]["XPHO"]30000.000031000.000032186falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T16:23:23Z"}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
01a0a0a3-a598-7e32-a6a1-183d2561af11NDX2026-09-14 11:57other41641196137026.00unknown—0.0000189.8000["29000"]["0.2112"][]["XPHO"]29000.000029000.0000495falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T15:57:58Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a097-d240-7a61-9fe0-3d12daa4eaf7NDX2026-09-14 11:44straddle211558300715.00longask0.000049.9000["29000"]["0.2116"]["28464.47","29535.53"]["XPHO"]29000.000029000.000044falsefalsefalsefalsetruemlftmarket_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-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
01a0a097-93c1-7f01-9644-0d657af242edNDX2026-09-14 11:44straddle211476009801.00longask0.000041.8000["29000"]["0.2112"]["28591.17","29408.83"]["XPHO"]29000.000029000.000022truefalsefalsefalsetruemlftmarket_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
01a0a087-0190-7062-b12d-71614784bc91NDX2026-09-14 11:26other31201442480.00unknown—0.000099.3000["28800","29700","29800"]["0.1978","0.1682","0.1627"][]["XPHO"]28800.000029800.00002528falsefalsetruetruetruemlftmarket_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
01a0a051-f770-79e2-a57d-bc51cbaad078NDX2026-09-14 10:28other3171562984.00unknown—0.000084.5000["29025","30000"]["0.2063","0.2121"][]["XPHO"]29025.000030000.00004186falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:29:00Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a04d-7718-70e0-a027-305d695c5102NDX2026-09-14 10:23other41402768280.00unknown—0.000091.6000["26100","27900","30900","34000"]["0.2853","0.2260","0.1564","0.2007"][]["XPHO"]26100.000034000.000032276falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:23:47Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a04d-7331-76c1-b8f8-cc1693ef8f48NDX2026-09-14 10:23synthetic214977600.00longbid0.000099.6000["29375"]["0.2077"]["29375"]["XPHO"]29375.000029375.00009595truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:23:47Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a0a04c-13a0-72e2-9dbd-7f345c15a6dcNDX2026-09-14 10:22straddle214210206000.00longask0.000056.7000["29500"]["0.2059"]["27070","31930.00"]["XPHO"]29500.000029500.00009595falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-14T14:22:24Z"}2026-09-142026-09-14 17:152026-09-14 17:15
01a091d0-34c8-7373-95f4-2faef37a5f2cNDX2026-09-11 14:52other21542930544.00unknown—0.000046.7000["26000","33500"]["0.2563","0.1767"][]["XPHO"]26000.000033500.000098189falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:52:54Z"}2026-09-112026-09-11 17:152026-09-11 17:15