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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b545-3f37-7c83-95e7-5f6322c2bf11 | USO | 2026-09-18 12:06 | call_diagonal_spread | 2 | 1 | 61 | 346175.00 | short | bid | 155.3800 | 4.0500 | ["127","129"] | ["0.5468","0.6457"] | [] | ["XCBO"] | 127.0000 | 129.0000 | 14 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:07:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-65c7-7b43-855e-94f11a18fb5f | USO | 2026-09-18 11:10 | call_diagonal_spread | 2 | 1 | 17 | 165257.00 | short | ask | 155.9500 | 1.3000 | ["100","115"] | ["9.5452","0.6255"] | [] | ["XCBO"] | 100.0000 | 115.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b510-506f-7c90-b43f-cdb68af4f853 | USO | 2026-09-18 11:08 | call_diagonal_spread | 2 | 1 | 23 | 223307.00 | short | ask | 155.8400 | 1.0500 | ["100","115"] | ["6.8464","0.4540"] | [] | ["XCBO"] | 100.0000 | 115.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:09:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab5f-adbb-7d11-9dac-cfc91961ca27 | USO | 2026-09-16 13:59 | call_diagonal_spread | 2 | 1 | 10 | 108780.00 | long | bid | 156.4200 | 2.0000 | ["95","110"] | ["3.3551","0.6699"] | [] | ["XCBO"] | 95.0000 | 110.0000 | 2 | 30 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:59:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa6c-c23b-7331-a9a0-db048452844c | USO | 2026-09-16 09:34 | call_diagonal_spread | 2 | 1 | 10 | 105310.00 | short | bid | 158.9500 | 4.9500 | ["110","112"] | ["0.5068","0.4627"] | [] | ["XCBO"] | 110.0000 | 112.0000 | 121 | 212 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5ea-988e-7420-91ad-a788a6aaa617 | USO | 2026-09-15 12:33 | call_diagonal_spread | 2 | 1 | 20 | 206200.00 | long | bid | 161.3306 | 2.8500 | ["100","120"] | ["3.0460","0.5091"] | [] | ["XCBO"] | 100.0000 | 120.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:34:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a092-bd78-72b3-bd47-4bc36649c8ed | USO | 2026-09-14 11:39 | call_diagonal_spread | 2 | 1 | 500 | 718500.00 | unknown | — | 157.5700 | 0.8100 | ["150","170"] | ["0.5490","0.7191"] | [] | ["XMIO"] | 150.0000 | 170.0000 | 4 | 25 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:39:46Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05c-8e60-7021-9ecd-9c708e967ef9 | USO | 2026-09-14 10:40 | call_diagonal_spread | 2 | 1 | 20 | 199420.00 | long | bid | 159.3221 | 1.1500 | ["100","120"] | ["1.9661","0.5871"] | [] | ["XCBO"] | 100.0000 | 120.0000 | 4 | 32 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:40:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08268-6398-7f12-916f-01c121bdc4f8 | USO | 2026-09-08 15:04 | call_diagonal_spread | 2 | 1 | 300 | 189600.00 | long | ask | 145.5800 | 0.4300 | ["150","155"] | ["0.4548","0.5302"] | [] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 31 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:04:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |