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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4bb-0b9f-7b82-834c-9001c60613dc | PSX | 2026-09-21 12:09 | call_diagonal_spread | 2 | 1 | 11 | 110940.00 | unknown | ask | 266.6350 | 5.1000 | ["270","320"] | ["0.3958","0.3683"] | [] | ["XMIO"] | 270.0000 | 320.0000 | 487 | 851 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:09:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a8-75cf-7a42-a374-81801f974bff | PSX | 2026-09-21 11:49 | call_diagonal_spread | 2 | 1 | 5 | 151325.00 | long | bid | 267.4200 | 4.4000 | ["110","135"] | ["0.4700","0.4508"] | [] | ["XISX"] | 110.0000 | 135.0000 | 487 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:49:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5c9-0597-79a3-90e8-9c82c3e08bc1 | PSX | 2026-09-18 14:30 | call_diagonal_spread | 2 | 1 | 37 | 167645.00 | short | ask | 271.7950 | 2.8000 | ["240","270"] | ["4.0897","0.4055"] | [] | ["XMIO"] | 240.0000 | 270.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c9-0597-79a3-90e8-9c7ed8d0bc4a | PSX | 2026-09-18 14:30 | call_diagonal_spread | 2 | 1 | 37 | 167647.00 | short | ask | 271.7950 | 2.8000 | ["240","270"] | ["4.1793","0.4053"] | [] | ["XMIO"] | 240.0000 | 270.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c9-0597-79a3-90e8-9c6a51ede275 | PSX | 2026-09-18 14:30 | call_diagonal_spread | 2 | 1 | 37 | 167647.00 | short | ask | 271.7950 | 2.8000 | ["240","270"] | ["4.1793","0.4053"] | [] | ["XMIO"] | 240.0000 | 270.0000 | 0 | 28 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b592-6920-7622-b624-c18c65c8839b | PSX | 2026-09-18 13:31 | call_diagonal_spread | 2 | 1 | 189 | 659836.00 | short | ask | 271.7800 | 1.5000 | ["250","290"] | ["3.1564","0.4281"] | [] | ["EDGO"] | 250.0000 | 290.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:31:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-d0a8-7240-84e0-6e314209b268 | PSX | 2026-09-18 10:59 | call_diagonal_spread | 2 | 1 | 7 | 156870.00 | long | bid | 275.8000 | 4.1000 | ["175","200"] | ["0.3377","0.3361"] | [] | ["AMXO"] | 175.0000 | 200.0000 | 490 | 854 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b502-d34f-78b2-8013-67e1c47f19dc | PSX | 2026-09-18 10:54 | call_diagonal_spread | 2 | 1 | 392 | 10799600.00 | unknown | — | 275.0700 | 6.0000 | ["145","155"] | ["0.3402","0.2409"] | [] | ["XISX"] | 145.0000 | 155.0000 | 490 | 854 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:54:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d4-e967-7fd0-8da7-9e7d25de5371 | PSX | 2026-09-18 10:04 | call_diagonal_spread | 2 | 1 | 245 | 6776700.00 | unknown | — | 274.7100 | 3.6000 | ["145","150"] | ["0.4938","0.4652"] | [] | ["XISX"] | 145.0000 | 150.0000 | 490 | 854 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a7-e99c-7613-a891-92bca922b2f1 | PSX | 2026-09-17 14:36 | call_diagonal_spread | 2 | 1 | 38 | 107008.00 | unknown | — | 273.4000 | 3.1000 | ["260","300"] | ["0.6181","0.4293"] | [] | ["EDGO"] | 260.0000 | 300.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:36:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afef-097b-7ab2-988f-2683bc89e638 | PSX | 2026-09-17 11:14 | call_diagonal_spread | 2 | 2 | 14 | 266042.00 | short | bid | 269.5000 | 7.1000 | ["180","210"] | ["0.4124","0.3645"] | [] | ["ARCO","XMIO"] | 180.0000 | 210.0000 | 120 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:14:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc3-bf73-7001-9f40-35522aa1016b | PSX | 2026-09-17 10:27 | call_diagonal_spread | 2 | 3 | 59 | 1543284.00 | unknown | — | 266.6100 | 3.2000 | ["145","150"] | ["0.3325","0.3030"] | [] | ["XBOX","XISX"] | 145.0000 | 150.0000 | 491 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:27:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab17-42ab-7d70-a36a-cecfedd030e4 | PSX | 2026-09-16 12:40 | call_diagonal_spread | 2 | 2 | 13 | 337584.00 | unknown | — | 265.4700 | 3.2000 | ["145","150"] | ["0.2735","0.2300"] | [] | ["XBOX","XISX"] | 145.0000 | 150.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:40:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab17-0813-7cc0-a2c3-a45e83cda019 | PSX | 2026-09-16 12:40 | call_diagonal_spread | 2 | 2 | 13 | 337487.00 | long | ask | 265.4700 | 3.8385 | ["145","150"] | ["0.2832","0.2300"] | [] | ["ARCO","XISX"] | 145.0000 | 150.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:40:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a65b-9656-7e41-a497-d4b538fe355b | PSX | 2026-09-15 14:36 | call_diagonal_spread | 2 | 1 | 89 | 2320586.00 | long | ask | 265.4700 | 6.5000 | ["145","150"] | ["0.3525","0.3216"] | [] | ["XISX"] | 145.0000 | 150.0000 | 493 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:37:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f0-0efe-7771-b3a9-315055d10a03 | PSX | 2026-09-15 12:39 | call_diagonal_spread | 2 | 2 | 20 | 156000.00 | unknown | — | 265.7099 | 4.6000 | ["310","360"] | ["0.3983","0.3785"] | [] | ["AMXO"] | 310.0000 | 360.0000 | 493 | 857 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:39:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d7-1c45-7c50-971d-a6ebabfbcdc9 | PSX | 2026-09-15 12:12 | call_diagonal_spread | 2 | 1 | 5 | 100200.00 | long | ask | 263.4100 | 5.1000 | ["105","230"] | ["0.8650","0.4459"] | [] | ["XISX"] | 105.0000 | 230.0000 | 66 | 122 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:12:30Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a569-432d-7e81-8714-97276ceeb1ea | PSX | 2026-09-15 10:12 | call_diagonal_spread | 2 | 1 | 7 | 102975.00 | short | bid | 261.8100 | 7.2000 | ["195","200"] | ["0.4182","0.3955"] | [] | ["XMIO"] | 195.0000 | 200.0000 | 122 | 275 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090db-6100-7851-a703-0965ec830af2 | PSX | 2026-09-11 10:24 | call_diagonal_spread | 2 | 1 | 15 | 125025.00 | long | ask | 263.2950 | 3.9000 | ["260","270"] | ["0.3907","0.3790"] | [] | ["AMXO"] | 260.0000 | 270.0000 | 279 | 371 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:25:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090bf-8819-79d1-b427-7d9daa30833e | PSX | 2026-09-11 09:54 | call_diagonal_spread | 2 | 1 | 10 | 239340.00 | long | bid | 263.8400 | 7.7000 | ["150","155"] | ["0.3470","0.3111"] | [] | ["XMIO"] | 150.0000 | 155.0000 | 434 | 497 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:54:29Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a087b9-0fa0-71a1-b091-2ea1f6951a09 | PSX | 2026-09-09 15:50 | call_diagonal_spread | 2 | 1 | 16 | 183184.00 | long | ask | 260.9900 | 4.4000 | ["210","220"] | ["0.4964","0.3863"] | [] | ["XMIO"] | 210.0000 | 220.0000 | 37 | 281 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:50:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |