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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c49a-6827-7bc1-864a-f346c7d411dc | VLO | 2026-09-21 11:34 | call_vertical_spread | 2 | 1 | 20 | 369840.00 | long | ask | 404.6150 | 6.2000 | ["480","490"] | ["0.4249","0.4241"] | ["483.18"] | ["XCBO"] | 480.0000 | 490.0000 | 851 | 851 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:34:16Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0cd-76e3-7073-9b95-8d08924d6b07 | VLO | 2026-09-17 15:17 | call_vertical_spread | 2 | 1 | 20 | 413502.00 | long | ask | 412.6958 | 7.3000 | ["460","470"] | ["0.4226","0.4224"] | ["463.36"] | ["XMIO"] | 460.0000 | 470.0000 | 855 | 855 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:16Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b03b-f4e3-7c02-a613-80277f592e56 | VLO | 2026-09-17 12:38 | call_vertical_spread | 2 | 1 | 5 | 130240.00 | short | bid | 409.1700 | 6.0000 | ["270","300"] | ["0.5055","0.5109"] | ["296.80"] | ["EDGO"] | 270.0000 | 300.0000 | 92 | 92 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:39:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abaa-7e13-71a0-95d7-d5a622ca58b6 | VLO | 2026-09-16 15:21 | call_vertical_spread | 2 | 1 | 5 | 123120.00 | long | ask | 402.1678 | 6.5000 | ["330","340"] | ["0.4558","0.4559"] | ["335.52"] | ["XMIO"] | 330.0000 | 340.0000 | 457 | 457 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:21:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a090e0-e328-74c2-ac15-724464b659d5 | VLO | 2026-09-11 10:30 | call_vertical_spread | 2 | 1 | 20 | 102760.00 | short | bid | 393.9400 | 5.0000 | ["370","372.5"] | ["0.4970","0.4887"] | ["372.12"] | ["XCBO"] | 370.0000 | 372.5000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:30:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d2-e908-76d0-a574-8965a5c30013 | VLO | 2026-09-11 10:15 | call_vertical_spread | 2 | 1 | 20 | 365400.00 | long | ask | 394.2000 | 8.2000 | ["450","460"] | ["0.4179","0.4177"] | ["453.24"] | ["XMIO"] | 450.0000 | 460.0000 | 826 | 826 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:15:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08294-c6e0-7203-9c14-a6d68b8ee5bb | VLO | 2026-09-08 15:53 | call_vertical_spread | 2 | 1 | 5 | 107245.00 | short | bid | 383.8500 | 7.0000 | ["360","400"] | ["0.4101","0.4108"] | ["375.95"] | ["XCBO"] | 360.0000 | 400.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:53:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |