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
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c53a-e617-7dc2-87c0-a6007599d7a6 | LITE | 2026-09-21 14:29 | call_diagonal_spread | 2 | 1 | 10 | 156170.00 | long | ask | 958.7100 | 9.7000 | ["950","965"] | ["0.7168","0.7117"] | [] | ["XCBO"] | 950.0000 | 965.0000 | 25 | 32 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:29:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c50e-9657-7f91-b7e9-332d617f5cf2 | LITE | 2026-09-21 13:41 | call_diagonal_spread | 2 | 1 | 5 | 250535.00 | short | ask | 957.5400 | 23.1000 | ["700","740"] | ["0.8083","0.7628"] | [] | ["XCBO"] | 700.0000 | 740.0000 | 25 | 39 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:41:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4ec-358f-7f42-8732-0cf5ff7dc826 | LITE | 2026-09-21 13:03 | call_diagonal_spread | 2 | 1 | 2 | 143550.00 | long | ask | 960.8450 | 32.5000 | ["1000","1020"] | ["0.7729","0.7688"] | [] | ["XMIO"] | 1000.0000 | 1020.0000 | 487 | 634 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:03:49Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c451-8fb7-7b53-a96f-1338187a0959 | LITE | 2026-09-21 10:14 | call_diagonal_spread | 2 | 1 | 3 | 107160.00 | long | ask | 976.2250 | 20.4000 | ["880","900"] | ["0.7740","0.7539"] | [] | ["XMIO"] | 880.0000 | 900.0000 | 60 | 88 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:14:49Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d4-e0bf-7970-924a-fb06bd74c078 | LITE | 2026-09-18 14:43 | call_diagonal_spread | 2 | 1 | 9 | 1241064.00 | short | ask | 913.3000 | 21.3000 | ["190","260"] | ["69.9576","1.2727"] | [] | ["XMIO"] | 190.0000 | 260.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:43:51Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b5-623f-7cb3-93ad-07140244423e | LITE | 2026-09-18 14:09 | call_diagonal_spread | 2 | 1 | 3 | 463980.00 | long | bid | 914.4400 | 28.4000 | ["105","200"] | ["63.7617","0.8743"] | [] | ["XMIO"] | 105.0000 | 200.0000 | 0 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:09:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0af99-0dc3-72c0-9ea0-18da243af04a | LITE | 2026-09-17 09:40 | call_diagonal_spread | 2 | 1 | 22 | 109340.00 | short | ask | 921.3350 | 4.8000 | ["910","960"] | ["0.9749","0.7382"] | [] | ["XMIO"] | 910.0000 | 960.0000 | 1 | 8 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:40:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba4-9273-74b3-b7e0-4e87e531fd58 | LITE | 2026-09-16 15:14 | call_diagonal_spread | 2 | 2 | 50 | 111890.00 | unknown | — | 898.8600 | 2.5000 | ["980","1100"] | ["0.8952","0.7380"] | [] | ["XBOX","XISX"] | 980.0000 | 1100.0000 | 2 | 30 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:14:48Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab92-d37b-7741-b816-d0a14d185771 | LITE | 2026-09-16 14:55 | call_diagonal_spread | 2 | 1 | 50 | 186700.00 | unknown | — | 903.7750 | 3.1000 | ["950","1050"] | ["0.8827","0.7370"] | [] | ["XISX"] | 950.0000 | 1050.0000 | 2 | 30 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a172-1159-7760-bf96-81c20a704113 | LITE | 2026-09-14 15:43 | call_diagonal_spread | 2 | 1 | 2 | 102840.00 | short | bid | 835.4000 | 23.3000 | ["600","650"] | ["0.8502","0.7936"] | [] | ["XCBO"] | 600.0000 | 650.0000 | 32 | 158 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:43:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a051-0d10-7783-a4b3-a2352b04fce5 | LITE | 2026-09-14 10:27 | call_diagonal_spread | 2 | 1 | 3 | 107922.00 | short | bid | 857.1400 | 22.3000 | ["950","1000"] | ["0.7926","0.7966"] | [] | ["XCBO"] | 950.0000 | 1000.0000 | 186 | 276 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:27:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091af-a0f1-7050-8fb4-54a859a2b912 | LITE | 2026-09-11 14:16 | call_diagonal_spread | 2 | 1 | 3 | 123918.00 | short | ask | 928.1200 | 20.5000 | ["720","730"] | ["11.1853","1.1287"] | [] | ["EDGO"] | 720.0000 | 730.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:17:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08737-1249-7711-99be-6d1a3f2248a9 | LITE | 2026-09-09 13:28 | call_diagonal_spread | 2 | 1 | 21 | 1040046.00 | long | ask | 1008.3000 | 19.5000 | ["770","820"] | ["1.0360","0.8394"] | [] | ["XCBO"] | 770.0000 | 820.0000 | 9 | 72 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:28:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820a-5960-7db1-9005-136c9a7c1acb | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 3 | 103614.00 | long | bid | 993.9450 | 22.6000 | ["1000","1140"] | ["0.8268","0.8254"] | [] | ["XCBO"] | 1000.0000 | 1140.0000 | 101 | 164 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:22:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08209-b551-7502-9133-48080d2dfb6d | LITE | 2026-09-08 13:21 | call_diagonal_spread | 2 | 1 | 50 | 3011500.00 | short | bid | 993.0000 | 28.9000 | ["1300","1500"] | ["0.8048","0.8082"] | [] | ["XCBO"] | 1300.0000 | 1500.0000 | 500 | 647 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:21:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |