Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 rowsexportable
active:ticker = SHEL×
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_sidetext | underlying_pricenumeric | bid_ask_spreadnumeric | strikesjsonb | ivsjsonb | breakevensjsonb | uniq_exchangesjsonb | min_strikenumeric | max_strikenumeric | min_dteinteger | max_dteinteger | all_opening_legsboolean | all_otmboolean | diff_expirationsboolean | diff_strikesboolean | diff_typesboolean | codetext | kept_bytext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c99e-4807-7572-a0f6-3a3648ddf1eb | SHEL | 2026-09-22 10:56 | call_calendar | 2 | 1 | 100 | 412000.00 | short | ask | 93.6100 | 1.8000 | ["80"] | ["0.1125"] | [] | ["SPHR"] | 80.0000 | 80.0000 | 486 | 850 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:56:29Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c4ec-dd87-71b0-a827-0ea3e40dfea3 | SHEL | 2026-09-21 13:04 | call_diagonal_spread | 2 | 1 | 118 | 509288.00 | short | ask | 93.2950 | 1.7000 | ["70","80"] | ["0.2650","0.1433"] | [] | ["SPHR"] | 70.0000 | 80.0000 | 116 | 487 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:04:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4ea-e987-74e2-95d0-972b95ed49f7 | SHEL | 2026-09-21 13:02 | call_diagonal_spread | 2 | 1 | 113 | 813035.00 | long | bid | 93.3100 | 0.9000 | ["50","70"] | ["0.5588","0.2764"] | [] | ["XMIO"] | 50.0000 | 70.0000 | 116 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:02:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42c-6be7-7a62-b66d-c57b4bfede22 | SHEL | 2026-09-21 09:33 | call_vertical_spread | 2 | 1 | 70 | 132370.00 | short | bid | 94.8250 | 5.0000 | ["82","90"] | ["0.5619","0.2252"] | ["89.23"] | ["XMIO"] | 82.0000 | 90.0000 | 32 | 32 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:34:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0ab0e-22bb-7f01-9c6c-ecb9f410e6eb | SHEL | 2026-09-16 12:30 | call_diagonal_spread | 2 | 4 | 414 | 165186.00 | short | ask | 96.5300 | 0.2750 | ["97.5","110"] | ["0.2515","0.2372"] | [] | ["XCBO"] | 97.5000 | 110.0000 | 30 | 121 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:31:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa97-b26b-7f41-ac73-9fd615d05b48 | SHEL | 2026-09-16 10:21 | strangle | 2 | 11 | 114 | 114000.00 | long | ask | 97.0819 | 0.3000 | ["85","120"] | ["0.2964","0.2215"] | ["75.0","130.00"] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 85.0000 | 120.0000 | 492 | 492 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:21:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa74-ff9b-7eb0-a0c1-12c4310ee9ff | SHEL | 2026-09-16 09:43 | put_vertical_spread | 2 | 1 | 254 | 163576.00 | long | ask | 97.2400 | 0.3500 | ["92.5","95"] | ["0.2674","0.2694"] | ["94.0"] | ["EDGO"] | 92.5000 | 95.0000 | 93 | 93 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:43:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a647-bc4e-7850-a91a-608de6fd7fcd | SHEL | 2026-09-15 14:15 | call_diagonal_spread | 2 | 1 | 56 | 113960.00 | unknown | — | 99.0600 | 1.1000 | ["90","110"] | ["0.2028","0.2078"] | [] | ["XMIO"] | 90.0000 | 110.0000 | 185 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:15:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a643-43c6-7151-bed0-9dabc210fd58 | SHEL | 2026-09-15 14:10 | call_backspread | 2 | 1 | 760 | 106780.00 | long | bid | 98.9600 | 0.2500 | ["98","100"] | ["0.2738","0.2942"] | ["98.29","101.71"] | ["AMXO"] | 98.0000 | 100.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:10:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a154-d4f8-7823-be24-b3c5dde77a4e | SHEL | 2026-09-14 15:11 | call_diagonal_spread | 2 | 1 | 314 | 100480.00 | short | ask | 96.1900 | 0.2000 | ["97.5","110"] | ["0.2384","0.2335"] | [] | ["XMIO"] | 97.5000 | 110.0000 | 32 | 95 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:11:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08151-f258-7f71-a96b-cbc041e74046 | SHEL | 2026-09-08 10:00 | put_vertical_spread | 2 | 1 | 367 | 204052.00 | long | ask | 95.6100 | 0.3000 | ["90","92.5"] | ["0.2556","0.2563"] | ["91.6"] | ["C2OX"] | 90.0000 | 92.5000 | 101 | 101 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:00:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d3e-7b9d-78a2-b8bd-02d589bc68a3 | SHEL | 2026-09-04 12:26 | call_diagonal_spread_bearish | 2 | 1 | 1976 | 158080.00 | long | ask | 93.3200 | 0.2000 | ["93","95"] | ["0.1956","0.2030"] | [] | ["EDGO"] | 93.0000 | 95.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:27:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |