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-c1ff-7200-bd06-b7b98d670dcf | BE | 2026-09-21 11:34 | put_diagonal_spread | 2 | 1 | 100 | 112200.00 | long | ask | 278.7500 | 0.6700 | ["195","210"] | ["0.8443","0.8833"] | [] | ["XISX"] | 195.0000 | 210.0000 | 25 | 60 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:34:44Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b0f2-8343-7213-b50b-59602250fc79 | BE | 2026-09-17 15:57 | put_diagonal_spread | 2 | 2 | 49 | 104366.00 | long | ask | 281.0750 | 0.3476 | ["270","275"] | ["0.7763","0.9150"] | [] | ["XISX","XPHO"] | 270.0000 | 275.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f2-2583-7c90-86d9-b8e3c1d7eaeb | BE | 2026-09-17 15:57 | put_diagonal_spread | 2 | 4 | 110 | 236084.00 | long | ask | 280.7650 | 0.2700 | ["270","275"] | ["0.7762","0.9053"] | [] | ["ARCO","XBOX","XCBO","XISX"] | 270.0000 | 275.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f1-eed3-7920-84ac-06a23e0f47b3 | BE | 2026-09-17 15:57 | put_diagonal_spread | 2 | 3 | 148 | 317888.00 | long | ask | 280.7200 | 0.2900 | ["270","275"] | ["0.7759","0.9042"] | [] | ["ARCO","XBOX","XISX"] | 270.0000 | 275.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f1-bc0b-7da3-82c5-856d22fc90c0 | BE | 2026-09-17 15:57 | put_diagonal_spread | 2 | 4 | 143 | 304320.00 | long | ask | 280.9500 | 0.3100 | ["270","275"] | ["0.7764","0.8945"] | [] | ["ARCO","C2OX","EDGO","XBOX"] | 270.0000 | 275.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0f1-79a3-7c42-8431-f617ee54baf7 | BE | 2026-09-17 15:56 | put_diagonal_spread | 2 | 7 | 116 | 250112.00 | long | ask | 280.5316 | 0.2690 | ["270","275"] | ["0.7764","0.8919"] | [] | ["AMXO","ARCO","MCRY","SPHR","XBOX","XCBO","XISX"] | 270.0000 | 275.0000 | 1 | 29 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9e-93d3-7942-91b7-25e75af26092 | BE | 2026-09-17 09:46 | put_diagonal_spread | 2 | 1 | 36 | 191484.00 | unknown | — | 281.1200 | 3.3000 | ["220","230"] | ["0.8442","0.8436"] | [] | ["BATO"] | 220.0000 | 230.0000 | 120 | 155 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:46:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abcb-6fab-7f22-9d2c-60056eb0fbec | BE | 2026-09-16 15:57 | put_diagonal_spread | 2 | 1 | 31 | 348843.00 | unknown | — | 270.8996 | 4.9500 | ["175","185"] | ["0.8941","0.8863"] | [] | ["BATO"] | 175.0000 | 185.0000 | 639 | 856 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:57:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abcb-6fab-7f22-9d2c-5ffbb1bea4b6 | BE | 2026-09-16 15:57 | put_diagonal_spread | 2 | 1 | 22 | 241230.00 | unknown | — | 270.8996 | 6.0000 | ["175","185"] | ["0.8770","0.8714"] | [] | ["XBOX"] | 175.0000 | 185.0000 | 639 | 856 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:57:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba1-cb83-7211-b05d-a51b36eec78a | BE | 2026-09-16 15:11 | put_diagonal_spread | 2 | 1 | 12 | 127884.00 | short | bid | 262.7350 | 4.6500 | ["290","295"] | ["0.8875","0.8950"] | [] | ["XISX"] | 290.0000 | 295.0000 | 44 | 65 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:11:47Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab68-0a5b-7f52-8499-ee4c765526bf | BE | 2026-09-16 14:08 | put_diagonal_spread | 2 | 1 | 76 | 154622.00 | unknown | — | 271.7100 | 4.7300 | ["130","160"] | ["0.9087","0.8895"] | [] | ["AMXO"] | 130.0000 | 160.0000 | 121 | 492 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:08:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08b94-a7d9-7d61-b987-bf4547cc9b0a | BE | 2026-09-10 09:49 | put_diagonal_spread | 2 | 1 | 30 | 107100.00 | unknown | — | 258.4450 | 2.1000 | ["267.5","275"] | ["0.8353","1.1685"] | [] | ["ARCO"] | 267.5000 | 275.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:49:36Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08150-d149-79e1-abf4-5e2674532d22 | BE | 2026-09-08 09:59 | put_diagonal_spread | 2 | 1 | 20 | 139980.00 | short | bid | 278.2177 | 3.1500 | ["290","300"] | ["0.9018","0.9965"] | [] | ["XMIO"] | 290.0000 | 300.0000 | 10 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:59:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |