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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c55e-11ff-7d73-bca4-8282d61436a8 | MTZ | 2026-09-21 15:07 | risk_reversal | 2 | 1 | 300 | 1053000.00 | long | ask | 223.3500 | 4.0000 | ["190","230"] | ["0.6071","0.6038"] | ["243.80"] | ["SPHR"] | 190.0000 | 230.0000 | 88 | 88 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:08:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b612-4397-7ed1-8ad0-d93b4837efa9 | MTZ | 2026-09-18 15:50 | put_vertical_spread | 2 | 1 | 7 | 216916.00 | long | ask | 214.7150 | 5.9000 | ["360","380"] | ["0.9631","1.0517"] | ["360.02"] | ["C2OX"] | 360.0000 | 380.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-4397-7ed1-8ad0-d925af57e6a6 | MTZ | 2026-09-18 15:50 | put_vertical_spread | 2 | 1 | 12 | 359904.00 | long | ask | 214.7150 | 5.8000 | ["360","370"] | ["0.9673","1.0102"] | ["360.02"] | ["C2OX"] | 360.0000 | 370.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-33f7-7aa1-95db-f4dbe457822c | MTZ | 2026-09-18 15:50 | 1_1_2 | 3 | 1 | 4 | 121836.00 | unknown | ask | 214.8150 | 9.0000 | ["360","370","380"] | ["0.9527","0.9987","1.0378"] | ["360.02"] | ["C2OX"] | 360.0000 | 380.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:50:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ee-06d3-7c02-a339-90b71096ee08 | MTZ | 2026-09-17 15:53 | put_vertical_spread | 2 | 1 | 8 | 172064.00 | unknown | — | 207.3850 | 5.0000 | ["310","320"] | ["0.8053","0.8568"] | [] | ["C2OX"] | 310.0000 | 320.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:53:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e6-36d2-7321-af58-e0c28a6100fb | MTZ | 2026-09-17 15:44 | other | 3 | 1 | 35 | 234990.00 | unknown | — | 208.6000 | 6.4000 | ["210","250"] | ["0.5502","2.6989"] | [] | ["EDGO"] | 210.0000 | 250.0000 | 1 | 29 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:44:51Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b1-ec1b-7e23-b6a1-6e59eca372cb | MTZ | 2026-09-17 14:47 | other | 6 | 1 | 952 | 9934192.00 | unknown | — | 211.3900 | 18.3000 | ["240","250","290","300","380","400"] | ["2.3641","2.7441","4.4052","0.9547","1.3993","0.7133"] | [] | ["XBOX"] | 240.0000 | 400.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:47:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09e-c5c3-7871-b1c5-1faf0ba51a7a | MTZ | 2026-09-17 14:26 | other | 6 | 1 | 1090 | 11836160.00 | unknown | — | 210.7700 | 16.4000 | ["240","250","270","300","310","370"] | ["1.8431","2.2548","2.9869","0.8388","0.9605","1.2280"] | [] | ["XBOX"] | 240.0000 | 370.0000 | 1 | 29 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:27:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa7-32db-71d1-a964-fc8ea75b192e | MTZ | 2026-09-17 09:56 | put_vertical_spread | 2 | 1 | 60 | 118320.00 | unknown | — | 226.3050 | 6.2000 | ["230","240"] | ["0.7056","0.8910"] | [] | ["BATO"] | 230.0000 | 240.0000 | 1 | 1 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:56:14Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a17b-48b8-78c3-a53b-082720614e7e | MTZ | 2026-09-14 15:53 | put_vertical_spread | 2 | 1 | 4 | 122788.00 | unknown | — | 228.5100 | 8.1000 | ["370","390"] | ["1.1208","1.2155"] | [] | ["XBOX"] | 370.0000 | 390.0000 | 32 | 32 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:53:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a17b-48b8-78c3-a53b-08174b752df0 | MTZ | 2026-09-14 15:53 | put_vertical_spread | 2 | 4 | 4 | 124328.00 | unknown | — | 228.5100 | 7.5000 | ["380","390"] | ["1.0247","1.0976"] | [] | ["ARCO","SPHR","XBOX"] | 380.0000 | 390.0000 | 32 | 32 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:53:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090f9-35b9-70e0-9135-cea3cb75b671 | MTZ | 2026-09-11 10:57 | other | 3 | 1 | 35 | 154420.00 | unknown | — | 240.0700 | 6.3000 | ["240","250"] | ["0.5251","0.5288"] | [] | ["EDGO"] | 240.0000 | 250.0000 | 7 | 35 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:57:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08224-8880-7483-8667-5aeb15f516a1 | MTZ | 2026-09-08 13:50 | other | 2 | 1 | 105 | 111932.00 | unknown | — | 251.7300 | 1.2000 | ["240","250"] | ["0.5993","0.5819"] | [] | ["EDGO"] | 240.0000 | 250.0000 | 10 | 10 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:50:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |