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
01a0b587-b2ef-7973-a3b6-5c8ae0c2366dNDX2026-09-18 13:19call_vertical_spread21509984000.00unknownbid0.000088.5000["31500","37000"]["0.2086","0.1949"]["33496.80"]["XPHO"]31500.000037000.0000272272falsefalsefalsetruefalsemlftmarket_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-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
01a0b579-f74f-7ee0-9d1c-abbd95970f50NDX2026-09-18 13:04ratio_risk_reversal2112462656.00unknownbid0.000026.0000["29800","33000"]["0.1874","0.1662"]["28643.36","33385.55"]["XPHO"]29800.000033000.00006363falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:04:41Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b579-d040-7090-90ee-37f533051b0dNDX2026-09-18 13:04synthetic213686970.00longbid0.000037.3000["29750"]["0.1963"]["29740"]["XPHO"]29750.000029750.00009191falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T17:04:41Z"}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-eb80-7cb0-bf5f-37b0fe3d2611NDX2026-09-18 12:19other511005866800.00unknownask0.000051.0000["24000","26000","31000","34000","41000"]["0.3646","0.2852","0.1716","0.1737","0.2017"][]["XPHO"]24000.000041000.000028272falsefalsetruetruetruemlftmarket_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
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
01a0b53c-3aa0-7af3-9a2e-59d081c0a448NDX2026-09-18 11:56risk_reversal21262400.00longbid0.000017.5000["28500","31000"]["0.1972","0.1443"]["28314.50"]["XPHO"]28500.000031000.00002828falsefalsefalsetruetruemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T15:57:05Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b09f-cb7b-7ae2-b58f-b82c7870cadeNDX2026-09-17 14:27other213153000.00unknown—0.000023.0000["28000","32500"]["0.2231","0.1730"][]["XPHO"]28000.000032500.00006492falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T18:27:53Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b097-5383-70d0-b69d-9292e67d8959NDX2026-09-17 14:18other2118444048.00unknown—0.000020.9000["24000","32000"]["0.3082","0.1659"][]["XPHO"]24000.000032000.00006492falsefalsetruetruetruemlftmarket_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
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
01a0b079-6b43-73e3-a60a-580d143ddbf3NDX2026-09-17 13:45put_frontspread21142088952.00longask0.000059.3000["26400","30000"]["0.2504","0.2082"]["23182.86","29617.14"]["XPHO"]26400.000030000.0000183183falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:45:59Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b063-2bf3-72e2-b123-82349aeadab8NDX2026-09-17 13:21other3114637296.00unknown—0.000052.6000["28200","31300","35000"]["0.2082","0.1446","0.1962"][]["XPHO"]28200.000035000.000029273falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:21:25Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b061-fb43-7550-b7c0-894d93028e0fNDX2026-09-17 13:20synthetic2151155150.00longbid0.000053.5000["29750"]["0.1973"]["29750"]["XPHO"]29750.000029750.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:20:38Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b061-340b-7e12-8247-634f91a813faNDX2026-09-17 13:19synthetic2151156000.00longbid0.000039.2000["29750"]["0.1973"]["29750"]["XPHO"]29750.000029750.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T17:19:14Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b020-bc23-71a1-ab5e-653568b8827bNDX2026-09-17 12:08other21702354100.00unknown—0.000020.2000["24500","32000"]["0.2991","0.1685"][]["XPHO"]24500.000032000.00006492falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:08:55Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b020-9ce3-7eb2-b097-0aa952629c2bNDX2026-09-17 12:08synthetic21163721280.00longbid0.000036.7000["29750"]["0.1987"]["29740"]["XPHO"]29750.000029750.00009292truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T16:08:55Z"}2026-09-172026-09-17 17:152026-09-17 17:15
01a0b001-83f3-78d1-820b-43fa8a21cec7NDX2026-09-17 11:34other2115413360.00unknown—0.000023.8000["27000","38000"]["0.2508","0.1966"][]["XPHO"]27000.000038000.000029273falsefalsetruetruetruemlftmarket_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
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
01a0afdd-b7e3-7e11-90fa-11564e3a1e6cNDX2026-09-17 10:55synthetic21609000000.00longbid0.000052.6000["31000"]["0.1834"]["30267.96"]["XPHO"]31000.000031000.00009292falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-17T14:55:37Z"}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
01a0ab7d-f7a3-7e92-8537-edf980664380NDX2026-09-16 14:32other4115623567076.00unknown—0.0000150.1000["29200"]["0.1793"][]["XPHO"]29200.000029200.0000035falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T18:32:46Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab50-2142-7643-86db-5627a9a37a0cNDX2026-09-16 13:42other413834180.00unknown—0.000062.8000["29200"]["0.2167"][]["XPHO"]29200.000029200.0000293falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:42:31Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab43-bd63-7e42-bdc9-6357823f1be0NDX2026-09-16 13:28other2112954528.00unknown—0.000045.6000["23000","31000"]["0.3027","0.1828"][]["XPHO"]23000.000031000.000093184falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:30:04Z"}2026-09-162026-09-16 17:152026-09-16 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-f6bb-76c0-9e35-d4ebc16f4f2dNDX2026-09-16 13:23call_ratio_spread21241449432.00unknown—0.000033.8000["28500","31000"]["0.2019","0.1498"][]["XPHO"]28500.000031000.00003030falsefalsefalsetruefalsemlftmarket_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
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-54eb-76f2-908a-0c0faa903288NDX2026-09-16 13:05other3117975380.00unknown—0.000038.5000["25200","28200","30000"]["0.2829","0.2114","0.1605"][]["XPHO"]25200.000030000.00003093falsefalsetruetruetruemlftmarket_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
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
01a0ab28-ee1b-7a70-87eb-b82c255f93c8NDX2026-09-16 12:59other21202069200.00unknown—0.000028.4000["27000","30000"]["0.2529","0.1943"][]["XPHO"]27000.000030000.00003093falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T17:00:24Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab12-06d3-7d01-9fa4-f639dbbec335NDX2026-09-16 12:34ratio_risk_reversal21401430800.00longbid0.000030.1000["28000","37000"]["0.2273","0.1904"]["27327"]["XPHO"]28000.000037000.00009393falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:34:59Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab11-f733-7760-a8ad-e5f63db031faNDX2026-09-16 12:34synthetic2161420020.00longbid0.000040.8000["29475"]["0.2022"]["29475"]["XPHO"]29475.000029475.00009393falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:34:59Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0ab05-1a3b-7ec1-9b5c-c84c5500637cNDX2026-09-16 12:20straddle_swap41267466940.00unknown—0.000067.9000["29650"]["0.2035"][]["XPHO"]29650.000029650.0000293falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T16:20:55Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaed-b9db-7d32-a5c9-a39f40892348NDX2026-09-16 11:54other41267450404.00unknown—0.000068.8000["29650"]["0.2054"][]["XPHO"]29650.000029650.0000293falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:55:39Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aaeb-6feb-7c51-b1af-d4a118d74a74NDX2026-09-16 11:52other21503575000.00unknown—0.000053.8000["25000","30500"]["0.2997","0.2042"][]["XPHO"]25000.000030500.000065184falsefalsetruetruetruemlftmarket_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
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
01a0aad4-175b-7f83-9592-cbdecc76bb3fNDX2026-09-16 11:26other31693597780.00unknown—0.000074.9000["22500","30300","38000"]["0.3019","0.1553","0.1969"][]["XPHO"]22500.000038000.000030274falsefalsetruetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:27:12Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aad3-9673-7a02-92c3-a35cd6165970NDX2026-09-16 11:26synthetic21184254120.00longbid0.000042.0000["29525"]["0.2017"]["29525"]["XPHO"]29525.000029525.00009393truefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T15:26:32Z"}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
01a0aaa4-2dbb-7a62-a0c4-95c7f5957dc8NDX2026-09-16 10:34synthetic21122857920.00longbid0.000043.2000["29450"]["0.2034"]["29450"]["XPHO"]29450.000029450.00009393falsefalsefalsefalsetruemlftmarket_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
01a0aaa1-9994-71d3-8ca9-7d360f315c17NDX2026-09-16 10:31other41233705047.00unknown—0.000041.8000["29125"]["0.2064"][]["XPHO"]29125.000029125.0000230falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T14:32:09Z"}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