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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0cf-a193-7760-80ff-910106e48bd2 | CAT | 2026-09-17 15:19 | risk_reversal | 2 | 1 | 4 | 25900.00 | short | ask | 795.2600 | 2.0500 | ["740","960"] | ["0.3963","0.3871"] | ["722.59"] | ["XISX"] | 740.0000 | 960.0000 | 120 | 120 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c3-39cb-75d0-8337-f17cfb9a26af | CAT | 2026-09-17 15:06 | risk_reversal | 2 | 2 | 6 | 38850.00 | short | ask | 795.6950 | 2.2000 | ["740","960"] | ["0.3975","0.3860"] | ["722.49"] | ["XISX","XPHO"] | 740.0000 | 960.0000 | 120 | 120 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:06:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0bc-40a3-7190-b4e5-fdd417746f1c | CAT | 2026-09-17 14:58 | risk_reversal | 2 | 1 | 4 | 25900.00 | long | bid | 795.4000 | 2.1000 | ["740","960"] | ["0.3980","0.3854"] | ["722.15"] | ["XISX"] | 740.0000 | 960.0000 | 120 | 120 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:59:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b1-b183-7742-8428-ce7a9b8dbac8 | CAT | 2026-09-17 14:47 | risk_reversal | 2 | 2 | 7 | 45386.00 | short | ask | 796.6000 | 1.7071 | ["740","960"] | ["0.4006","0.3835"] | ["722.13"] | ["XBOX","XISX"] | 740.0000 | 960.0000 | 120 | 120 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:47:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af91-0afb-79a2-affe-f12777a27bcd | CAT | 2026-09-17 09:31 | risk_reversal | 2 | 1 | 3 | 26736.00 | long | bid | 812.0355 | 16.6500 | ["760","900"] | ["0.4076","0.3888"] | ["758"] | ["ARCO"] | 760.0000 | 900.0000 | 120 | 120 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:32:01Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0a693-e466-7ea0-8a0c-22e13e3dd685 | CAT | 2026-09-15 15:38 | risk_reversal | 2 | 3 | 3 | 38350.00 | short | bid | 781.5200 | 20.7000 | ["640","1100"] | ["0.4115","0.3968"] | ["1103.00"] | ["EMLD","SPHR","XBOX"] | 640.0000 | 1100.0000 | 493 | 493 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:38:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a661-4b46-78f3-bb03-34615981603f | CAT | 2026-09-15 14:43 | risk_reversal | 2 | 1 | 26 | 128102.00 | short | bid | 782.5300 | 3.4000 | ["640","990"] | ["0.4195","0.4000"] | ["992.03"] | ["XCBO"] | 640.0000 | 990.0000 | 157 | 157 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:43:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f5-cfa6-71e2-8346-c4b7bd8bae9a | CAT | 2026-09-15 12:45 | risk_reversal | 2 | 2 | 13 | 38311.00 | long | bid | 782.6075 | 4.2000 | ["680","920"] | ["0.4213","0.4036"] | ["679.65"] | ["XCBO"] | 680.0000 | 920.0000 | 66 | 66 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:46:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08c79-3791-7cd2-add3-ee9881ee51a2 | CAT | 2026-09-10 13:59 | risk_reversal | 2 | 4 | 4 | 31924.00 | long | bid | 803.6000 | 0.9625 | ["760","900"] | ["0.4141","0.4038"] | ["751.85"] | ["EDGO","XCBO","XMIO","XPHO"] | 760.0000 | 900.0000 | 99 | 99 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:00:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086ce-ea38-79a0-8082-e58677cc3570 | CAT | 2026-09-09 11:34 | risk_reversal | 2 | 1 | 7 | 27566.00 | short | ask | 814.0500 | 1.8500 | ["780","880"] | ["0.3819","0.3763"] | ["773.78"] | ["EDGO"] | 780.0000 | 880.0000 | 37 | 37 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:35:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08174-4380-7a30-a602-779725444a19 | CAT | 2026-09-08 10:37 | risk_reversal | 2 | 1 | 6 | 105852.00 | long | ask | 821.8300 | 24.9500 | ["680","1020"] | ["0.4432","0.4182"] | ["1052.60"] | ["XMIO"] | 680.0000 | 1020.0000 | 465 | 465 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:38:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814e-77b8-7e11-86dd-6310485ffd48 | CAT | 2026-09-08 09:56 | risk_reversal | 2 | 1 | 11 | 37598.00 | short | bid | 827.1650 | 6.0500 | ["680","1020"] | ["0.4361","0.3949"] | ["1020.10"] | ["XMIO"] | 680.0000 | 1020.0000 | 101 | 101 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:56:37Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dfd-763d-7a11-82d6-3d7453399b6c | CAT | 2026-09-04 15:55 | risk_reversal | 2 | 1 | 6 | 105618.00 | long | ask | 812.0950 | 35.3000 | ["680","1020"] | ["0.4446","0.4186"] | ["1045.85"] | ["XCBO"] | 680.0000 | 1020.0000 | 469 | 469 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:55:40Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |