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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5f7-456f-7963-88a4-9ebc68289f0d | SLV | 2026-09-18 15:21 | call_calendar | 2 | 1 | 139 | 226987.00 | short | bid | 60.0700 | 0.2500 | ["52"] | ["0.3727"] | [] | ["XMIO"] | 52.0000 | 52.0000 | 7 | 14 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:21:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d7-9117-70e1-8fe3-7c4fe2212b23 | SLV | 2026-09-18 10:06 | call_vertical_spread | 2 | 1 | 120 | 101040.00 | short | bid | 59.8300 | 0.1400 | ["60","72"] | ["0.4110","0.4510"] | ["63.36"] | ["XMIO"] | 60.0000 | 72.0000 | 119 | 119 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:07:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ce-cee7-70a3-a8da-08a47df3ab20 | SLV | 2026-09-18 09:57 | call_diagonal_spread | 2 | 1 | 35 | 100310.00 | long | bid | 59.8000 | 0.3500 | ["45","47"] | ["4.1892","0.4074"] | [] | ["XMIO"] | 45.0000 | 47.0000 | 0 | 91 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:57:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c0-6f37-7a63-99f3-b4ab7fa9fa4d | SLV | 2026-09-18 09:41 | strangle | 2 | 1 | 50 | 113366.00 | short | bid | 59.9450 | 0.6500 | ["59","60"] | ["0.4498","0.4157"] | ["36.33","82.67"] | ["XMIO"] | 59.0000 | 60.0000 | 490 | 490 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:41:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a08bdd-12e9-7912-976c-092352590b05 | SLV | 2026-09-10 11:08 | call_diagonal_spread | 2 | 1 | 300 | 117900.00 | short | bid | 58.1900 | 0.1300 | ["56.5","57.5"] | ["0.6823","0.4698"] | [] | ["XMIO"] | 56.5000 | 57.5000 | 1 | 8 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:08:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086de-5389-7b51-bf2f-880cdfcf2626 | SLV | 2026-09-09 11:51 | call_vertical_spread | 2 | 1 | 217 | 119784.00 | short | bid | 60.9550 | 0.1200 | ["60","68"] | ["0.4466","0.4870"] | ["62.58"] | ["XCBO"] | 60.0000 | 68.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:52:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0825c-f1e8-76a2-b764-8b8adf69ad2e | SLV | 2026-09-08 14:52 | call_vertical_spread | 2 | 1 | 160 | 241280.00 | short | bid | 59.3500 | 0.3500 | ["55","60"] | ["0.4374","0.4482"] | ["57.40"] | ["XMIO"] | 55.0000 | 60.0000 | 129 | 129 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:52:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |