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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b618-17c7-7132-8198-17bd449ff717 | CDE | 2026-09-18 15:57 | call_vertical_spread | 2 | 1 | 244 | 443836.00 | long | ask | 19.7250 | 0.8000 | ["10.5","11"] | ["2.7372","2.6075"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:57:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b616-6a17-75f1-a54a-ff8d9be0c95e | CDE | 2026-09-18 15:55 | call_vertical_spread | 2 | 1 | 248 | 480872.00 | long | ask | 19.7200 | 2.7000 | ["10","10.5"] | ["3.3879","3.2147"] | ["10.49"] | ["XISX"] | 10.0000 | 10.5000 | 7 | 7 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a177-7c11-73e3-94c0-7cb3eae80d48 | CDE | 2026-09-14 15:49 | put_vertical_spread | 2 | 1 | 88 | 112288.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8168"] | ["26.02"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:49:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a177-39a8-7db1-bbf3-309f9fce65f1 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 80 | 102160.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8330"] | ["26.01"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:49:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a176-dbe8-7b72-ac27-c760c6e34a70 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 88 | 113432.00 | long | ask | 19.9350 | 1.0000 | ["26","26.5"] | ["0.8848","0.9184"] | ["26.01"] | ["XMIO"] | 26.0000 | 26.5000 | 18 | 18 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:48:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a13b-3e30-7e23-adec-28c19d6b037b | CDE | 2026-09-14 14:43 | call_vertical_spread | 2 | 1 | 88 | 168872.00 | long | ask | 20.0600 | 0.6000 | ["10","11"] | ["3.0974","2.8434"] | ["10.99"] | ["XISX"] | 10.0000 | 11.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:44:16Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a13a-d8a0-7161-9c52-eb910dff838f | CDE | 2026-09-14 14:43 | call_vertical_spread | 2 | 1 | 180 | 345420.00 | long | ask | 20.0600 | 0.6000 | ["10","11"] | ["3.0974","2.8434"] | ["10.99"] | ["XISX"] | 10.0000 | 11.0000 | 4 | 4 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:43:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a139-55e8-7413-8567-75f6a7692755 | CDE | 2026-09-14 14:41 | call_vertical_spread | 2 | 1 | 180 | 262980.00 | long | ask | 20.0650 | 0.4000 | ["12.5","13"] | ["2.2389","2.7358"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:41:32Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a139-03e1-7ba0-a644-0f428e87b37e | CDE | 2026-09-14 14:41 | call_vertical_spread | 2 | 1 | 88 | 128568.00 | long | ask | 20.0550 | 0.4000 | ["12.5","13"] | ["2.3437","2.7799"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:41:32Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cda-4350-7dc3-8486-b45bd00b0628 | CDE | 2026-09-10 15:45 | call_vertical_spread | 2 | 1 | 188 | 251356.00 | long | ask | 20.3800 | 0.6000 | ["13.5","14"] | ["4.2919","4.1026"] | ["13.99"] | ["XISX"] | 13.5000 | 14.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:45:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cda-2028-7811-a1bc-629915a66204 | CDE | 2026-09-10 15:44 | call_vertical_spread | 2 | 1 | 88 | 117656.00 | long | ask | 20.3750 | 0.6000 | ["13.5","14"] | ["4.3657","4.1648"] | ["13.99"] | ["XISX"] | 13.5000 | 14.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:45:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0871a-a8d8-7111-9780-3f4c9466fded | CDE | 2026-09-09 12:57 | call_diagonal_spread | 2 | 1 | 470 | 477990.00 | short | ask | 21.1999 | 0.7000 | ["16","16.5"] | ["1.0906","0.7569"] | [] | ["XCBO"] | 16.0000 | 16.5000 | 9 | 23 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:57:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |