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×ticker = XLF×
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
01a0b5d3-8ce8-73d2-89a6-aecec467e3abXLF2026-09-18 14:42other441250014887500.00unknownask55.88500.3300["50"]["2.4658"][]["AMXO"]50.000050.0000028falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T18:42:16Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b555-48b0-7583-8fd2-2ce20d9ffff4XLF2026-09-18 12:24risk_reversal21700123200.00longbid55.73500.0800["54","59"]["0.1834","0.1513"]["53.66"]["AMXO"]54.000059.00009191falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T16:24:25Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0b4e3-54cf-7383-8fcc-289ce85df0adXLF2026-09-18 10:19other3212400541334.00unknownbid55.78000.0722["54","57","61"]["0.1832","0.1317","0.1544"]["53.64"]["AMXO"]54.000061.00002828falsetruefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-18T14:20:10Z"}2026-09-182026-09-18 17:152026-09-18 17:15
01a0abc7-c243-7993-bb51-a814a8e98068XLF2026-09-16 15:53put_diagonal_spread2110000150000.00longask55.88500.0600["55","55.5"]["0.2692","1.6420"][]["SPHR"]55.000055.500002falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:53:11Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0abab-7fe3-74c3-9207-c25672df42fcXLF2026-09-16 15:22other4575008523750.00unknown—55.48500.4400["50"]["0.4908"][]["AMXO"]50.000050.0000230falsefalsetruefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T19:22:22Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0aa7c-e70c-7510-b4d4-c2e8dda01528XLF2026-09-16 09:51put_ratio_spread218000352000.00unknown—56.51000.1400["56.5","57"]["0.3448","0.4685"][]["SPHR"]56.500057.000000falsefalsefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-16T13:51:53Z"}2026-09-162026-09-16 17:152026-09-16 17:15
01a0a685-4635-7c92-9e84-425ddd53682cXLF2026-09-15 15:22put_diagonal_spread22108694435.00unknown—56.89000.1400["55.5","57"]["0.2004","0.2052"][]["AMXO"]55.500057.0000317falsefalsetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:22:46Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a672-8186-7d02-8d63-c7a4980f2d67XLF2026-09-15 15:01synthetic211240262880.00shortask56.83430.1500["57"]["0.1605"]["56.72"]["XBOX"]57.000057.00003131falsefalsefalsefalsetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T19:02:08Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a0a645-0116-73d0-b3b6-69db1f6d5256XLF2026-09-15 14:12other41820195000.00unknown—56.66000.2200["57","58"]["0.2072","0.2330"][]["XBOX"]57.000058.000033falsefalsefalsetruetruemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-15T18:12:19Z"}2026-09-152026-09-15 19:282026-09-15 19:28
01a091b8-e7f0-70b1-8481-3afa16f2c838XLF2026-09-11 14:26other331125157750.00unknown—57.27000.1400["56","58"]["0.1732","0.1692"][]["AMXO"]56.000058.0000735falsefalsetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-11T18:27:23Z"}2026-09-112026-09-11 17:152026-09-11 17:15
01a08c4f-4d18-7ed0-830e-d2feeb819a49XLF2026-09-10 13:13strangle21700120400.00shortbid56.84000.0900["53","61"]["0.1979","0.1521"]["51.28","62.72"]["XPHO"]53.000061.0000127127falsetruefalsetruetruemlftmarket_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
01a0878f-8ea1-7d32-a34b-4d03706d86baXLF2026-09-09 15:05other22120081000.00unknown—57.14500.0700["48","53"]["0.2548","0.1970"][]["AMXO"]48.000053.0000100128falsetruetruetruefalsemlfttrackeduw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T19:05:47Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08691-8f30-7ba0-95d9-fd4775f25ec9XLF2026-09-09 10:27other21587001096600.00unknown—57.22500.1100["60.5","62"]["0.1551","0.1550"][]["SPHR"]60.500062.000023100falsetruetruetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-09T14:28:23Z"}2026-09-092026-09-09 17:152026-09-09 17:15
01a08229-5ec9-7232-90e7-11a3d49207b0XLF2026-09-08 13:55put_vertical_spread211000176000.00longask57.54500.1100["53","57"]["0.2010","0.1770"]["56.06"]["SPHR"]53.000057.00007373falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:55:47Z"}2026-09-082026-09-08 21:502026-09-08 21:50
01a08208-80b8-7f91-92bf-b9034f5c2989XLF2026-09-08 13:19put_vertical_spread211853598519.00unknown—57.51010.2700["46","51"]["0.2504","0.2305"][]["SPHR"]46.000051.0000465465falsetruefalsetruefalsemlftmarket_whaleuw_multileg/api/option-trades/multi-leg{"limit":500,"older_than":"2026-09-08T17:19:51Z"}2026-09-082026-09-08 21:502026-09-08 21:50