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
uw_multileg312,778 rowsexportable
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e8-7478-7102-9901-12890e1a80f7 | MATX | 2026-09-18 15:05 | call_diagonal_spread | 2 | 3 | 80 | 180000.00 | short | ask | 232.5400 | 3.9000 | ["220","230"] | ["4.2201","0.3047"] | [] | ["XCBO"] | 220.0000 | 230.0000 | 0 | 28 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:05:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b3-666f-7881-8235-75ec1232a69f | AAPL | 2026-09-18 14:07 | call_diagonal_spread | 2 | 4 | 609 | 2894577.00 | short | ask | 335.5400 | 0.5500 | ["300","350"] | ["3.5773","0.2466"] | [] | ["XCBO"] | 300.0000 | 350.0000 | 0 | 91 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:07:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b572-0428-74d3-8f12-0427c6c5d8dc | TGT | 2026-09-18 12:55 | call_diagonal_spread | 2 | 3 | 420 | 1127700.00 | short | bid | 157.9399 | 2.2000 | ["145","150"] | ["3.6224","0.3432"] | [] | ["XCBO"] | 145.0000 | 150.0000 | 0 | 63 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:56:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53a-1ba7-74e0-b5b3-7df861d88dcf | NEM | 2026-09-18 11:54 | call_diagonal_spread | 2 | 3 | 500 | 599000.00 | short | ask | 122.5350 | 2.1000 | ["115","125"] | ["1.2037","0.3971"] | [] | ["XCBO"] | 115.0000 | 125.0000 | 0 | 28 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:54:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-ff47-7f00-8b06-36b04dcb6682 | JCI | 2026-09-18 10:31 | call_diagonal_spread | 2 | 2 | 6100 | 67472100.00 | short | ask | 141.5600 | 3.0000 | ["85","90"] | ["0.5796","0.4111"] | [] | ["XCBO"] | 85.0000 | 90.0000 | 91 | 182 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:31:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b038-62d3-76a0-ba39-39979bf97b2e | PBR | 2026-09-17 12:34 | call_diagonal_spread | 2 | 3 | 550 | 117150.00 | short | bid | 20.9700 | 0.2260 | ["20","21"] | ["0.7178","0.4680"] | [] | ["XCBO"] | 20.0000 | 21.0000 | 1 | 29 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:34:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0affd-9bf3-7d01-b818-9c03dbc15899 | S | 2026-09-17 11:30 | call_diagonal_spread | 2 | 4 | 3600 | 2181600.00 | short | ask | 23.6650 | 0.7500 | ["20","25"] | ["2.0079","0.5887"] | [] | ["XCBO"] | 20.0000 | 25.0000 | 1 | 92 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:30:53Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a09134-cba0-7c23-9b62-e91cd5d11e5c | SPX | 2026-09-11 12:02 | call_diagonal_spread | 2 | 1 | 80 | 88560.00 | short | bid | 7673.5300 | 0.1500 | ["7730","7755"] | ["0.0666","0.0935"] | [] | ["XCBO"] | 7730.0000 | 7755.0000 | 3 | 5 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:02:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8a-3ef0-7f51-bdf4-493ec0d26479 | SPX | 2026-09-10 14:17 | call_diagonal_spread | 2 | 2 | 400 | 1600000.00 | short | bid | 7588.7900 | 1.2000 | ["7800","10000"] | ["0.1164","0.1302"] | [] | ["XCBO"] | 7800.0000 | 10000.0000 | 8 | 463 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:17:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba8-6e58-7ae2-b7fc-6beddb66e4fe | SPX | 2026-09-10 10:11 | call_diagonal_spread | 2 | 1 | 100 | 110900.00 | short | bid | 7581.8900 | 0.6000 | ["7790","7800"] | ["0.1229","0.1112"] | [] | ["XCBO"] | 7790.0000 | 7800.0000 | 8 | 12 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:11:08Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087cf-1070-7ca1-b942-ff0e37f96d75 | SPX | 2026-09-09 16:14 | call_diagonal_spread | 2 | 1 | 200 | 71000.00 | short | bid | 7636.3600 | 0.2500 | ["7775","7825"] | ["0.1326","0.1055"] | [] | ["XCBO"] | 7775.0000 | 7825.0000 | 2 | 7 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086fc-ef78-7371-9d09-b08673bda73e | SPX | 2026-09-09 12:25 | call_diagonal_spread | 2 | 1 | 60 | 54060.00 | short | bid | 7631.4300 | 0.2500 | ["7730","7735"] | ["0.1284","0.1011"] | [] | ["XCBO"] | 7730.0000 | 7735.0000 | 1 | 6 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:25:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f0-8b98-7c20-81a1-f1355384367a | SPX | 2026-09-09 12:11 | call_diagonal_spread | 2 | 1 | 60 | 57060.00 | short | bid | 7630.8600 | 0.3000 | ["7730","7735"] | ["0.1309","0.1034"] | [] | ["XCBO"] | 7730.0000 | 7735.0000 | 1 | 6 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:11:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866b-abf8-79a1-ac03-477834fb2402 | SPX | 2026-09-09 09:46 | call_diagonal_spread | 2 | 1 | 140 | 30380.00 | short | bid | 7650.3400 | 0.1500 | ["7770","7775"] | ["0.2337","0.1390"] | [] | ["XCBO"] | 7770.0000 | 7775.0000 | 0 | 2 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:46:52Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0816b-fe50-7461-8399-4395e7c8bdd9 | SPX | 2026-09-08 10:28 | call_diagonal_spread | 2 | 1 | 100 | 2619500.00 | short | bid | 7681.6400 | 1.8000 | ["8275","8600"] | ["0.1182","0.1376"] | [] | ["XCBO"] | 8275.0000 | 8600.0000 | 101 | 374 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:29:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |