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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c497-04f7-70a1-aac1-cf9e25fab4d5 | BE | 2026-09-21 11:30 | call_diagonal_spread | 2 | 1 | 16 | 199136.00 | long | ask | 279.5450 | 3.7500 | ["270","300"] | ["0.8585","0.8607"] | [] | ["XCBO"] | 270.0000 | 300.0000 | 88 | 242 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:30:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c464-7b77-7b62-b0cc-3e06e1734868 | BE | 2026-09-21 10:35 | call_diagonal_spread | 2 | 1 | 10 | 119560.00 | short | ask | 271.1200 | 4.9500 | ["200","280"] | ["1.1551","0.8333"] | [] | ["XCBO"] | 200.0000 | 280.0000 | 4 | 116 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:35:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5dd-2207-72e0-91bb-57bb087859fa | BE | 2026-09-18 14:52 | call_diagonal_spread | 2 | 1 | 20 | 174040.00 | long | ask | 270.5650 | 5.1500 | ["240","260"] | ["0.7688","0.8587"] | [] | ["XMIO"] | 240.0000 | 260.0000 | 35 | 63 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:52:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b524-6127-7e13-93dc-b282289da195 | BE | 2026-09-18 11:30 | call_diagonal_spread | 2 | 1 | 20 | 190800.00 | long | bid | 269.4900 | 6.2000 | ["220","225"] | ["4.8971","0.8764"] | [] | ["XMIO"] | 220.0000 | 225.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f3-c77b-7462-9be8-fa370b80341b | BE | 2026-09-17 15:59 | call_diagonal_spread | 2 | 1 | 11 | 111936.00 | short | ask | 281.0700 | 4.1000 | ["230","240"] | ["0.8592","0.7905"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 8 | 29 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:59:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb0-ea9b-7f33-aca5-58a1799f19f8 | BE | 2026-09-16 15:28 | call_diagonal_spread | 2 | 1 | 10 | 294820.00 | long | ask | 263.3600 | 5.2500 | ["190","220"] | ["0.8870","0.8842"] | [] | ["XCBO"] | 190.0000 | 220.0000 | 639 | 821 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:28:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3b-83eb-7b72-aec2-cce1aa8447e3 | BE | 2026-09-16 13:19 | call_diagonal_spread | 2 | 1 | 6 | 209574.00 | long | bid | 268.8700 | 8.4000 | ["135","160"] | ["0.9026","0.8900"] | [] | ["XCBO"] | 135.0000 | 160.0000 | 639 | 821 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:20:07Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5fd-b716-7872-8e7b-9524cb3d5496 | BE | 2026-09-15 12:54 | call_diagonal_spread | 2 | 1 | 8 | 149392.00 | long | ask | 263.0843 | 4.5500 | ["210","230"] | ["0.8832","0.8626"] | [] | ["XCBO"] | 210.0000 | 230.0000 | 213 | 275 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:54:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09186-6e10-7e90-b7af-e3f5bd7177a4 | BE | 2026-09-11 13:31 | call_diagonal_spread | 2 | 1 | 20 | 174440.00 | short | bid | 274.7300 | 1.7000 | ["250","300"] | ["0.7841","0.8618"] | [] | ["XCBO"] | 250.0000 | 300.0000 | 35 | 126 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:31:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914e-b859-79c3-a369-5b4f8b43ce3b | BE | 2026-09-11 12:30 | call_diagonal_spread | 2 | 1 | 5 | 131245.00 | unknown | — | 275.8300 | 6.0000 | ["240","280"] | ["0.9056","0.9039"] | [] | ["XCBO"] | 240.0000 | 280.0000 | 553 | 644 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:31:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0913d-3fb0-7492-99f6-58800ddce676 | BE | 2026-09-11 12:11 | call_diagonal_spread | 2 | 1 | 9 | 294318.00 | unknown | — | 276.3750 | 6.8500 | ["180","210"] | ["0.9043","0.9047"] | [] | ["XCBO"] | 180.0000 | 210.0000 | 644 | 826 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:11:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0865d-4860-7450-898f-8af2817ced92 | BE | 2026-09-09 09:30 | call_diagonal_spread | 2 | 1 | 23 | 194465.00 | short | bid | 276.7999 | 3.3000 | ["235","240"] | ["1.3567","0.8648"] | [] | ["XCBO"] | 235.0000 | 240.0000 | 2 | 16 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:59Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865d-0dc8-7151-aeca-291fa3f6fbbd | BE | 2026-09-09 09:30 | call_diagonal_spread | 2 | 2 | 30 | 209850.00 | long | ask | 276.1000 | 3.1000 | ["250","300"] | ["0.9251","0.9538"] | [] | ["XMIO"] | 250.0000 | 300.0000 | 9 | 72 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0826b-22b8-7bb2-93e1-81ad270f8f44 | BE | 2026-09-08 15:07 | call_diagonal_spread | 2 | 1 | 15 | 196125.00 | long | ask | 282.0899 | 4.6000 | ["220","240"] | ["0.8075","0.9376"] | [] | ["XCBO"] | 220.0000 | 240.0000 | 3 | 73 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:08:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0816c-0a09-70c1-9133-e14b18492fef | BE | 2026-09-08 10:28 | call_diagonal_spread | 2 | 1 | 10 | 268240.00 | long | ask | 273.5600 | 7.0000 | ["250","300"] | ["0.9113","0.9112"] | [] | ["XMIO"] | 250.0000 | 300.0000 | 556 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:29:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08150-fc40-7ff3-970a-360bc57467ac | BE | 2026-09-08 09:59 | call_diagonal_spread | 2 | 1 | 8 | 293144.00 | long | bid | 278.3300 | 7.8500 | ["115","200"] | ["0.9291","0.9182"] | [] | ["XMIO"] | 115.0000 | 200.0000 | 647 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:59:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08138-4038-77e3-a4fa-73949ab2cd0b | BE | 2026-09-08 09:32 | call_diagonal_spread | 2 | 1 | 10 | 202580.00 | short | bid | 272.9050 | 8.1500 | ["270","290"] | ["0.9341","0.9192"] | [] | ["XMIO"] | 270.0000 | 290.0000 | 282 | 500 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:32:32Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |