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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-3e90-7403-addb-b72973e7344f | SPCH | 2026-09-18 15:59 | put_vertical_spread | 2 | 1 | 100 | 203000.00 | unknown | — | 10.3050 | 1.0000 | ["20","21"] | ["437.2273","459.4079"] | [] | ["XCBO"] | 20.0000 | 21.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:32Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fc-3af7-7012-85a8-0f00e2510433 | SPCH | 2026-09-18 15:26 | call_vertical_spread | 2 | 1 | 75 | 128250.00 | unknown | — | 10.3638 | 0.8000 | ["1.5","2"] | ["9.4260","7.9712"] | [] | ["XMIO"] | 1.5000 | 2.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f9-934b-7b23-9de2-010006ec0f1b | SPCH | 2026-09-18 15:23 | call_vertical_spread | 2 | 1 | 300 | 513000.00 | unknown | — | 10.3950 | 0.8000 | ["1.5","2"] | ["8.8725","7.5138"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:24:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ec-841b-79e1-b06d-c9bfcd3462c5 | SPCH | 2026-09-17 15:51 | put_vertical_spread | 2 | 1 | 300 | 429000.00 | unknown | — | 10.6600 | 0.4000 | ["17.5","18"] | ["1.9823","2.0696"] | [] | ["XCBO"] | 17.5000 | 18.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:51:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0eb-b8fb-7a03-8703-298f1b5852fc | SPCH | 2026-09-17 15:50 | put_vertical_spread | 2 | 1 | 88 | 125928.00 | unknown | — | 10.6350 | 0.5000 | ["17.5","18"] | ["1.9073","1.9291"] | [] | ["XISX"] | 17.5000 | 18.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:50:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ea-74c3-7773-a51b-b7cebb9a98e7 | SPCH | 2026-09-17 15:49 | put_vertical_spread | 2 | 1 | 200 | 354000.00 | unknown | — | 10.5757 | 0.6000 | ["19","20"] | ["2.3448","2.5019"] | [] | ["XCBO"] | 19.0000 | 20.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:49:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e9-191b-7a71-9e6d-b311ba56139d | SPCH | 2026-09-17 15:47 | call_vertical_spread | 2 | 1 | 293 | 521540.00 | unknown | — | 10.6257 | 0.6000 | ["1.5","2"] | ["6.3390","5.3854"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:47:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e5-4c73-7bb3-b6e3-54b74e342a7f | SPCH | 2026-09-17 15:43 | call_vertical_spread | 2 | 1 | 251 | 421680.00 | unknown | — | 10.7150 | 0.6000 | ["2","2.5"] | ["19.2736","16.7354"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:43:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09e-5093-7b11-93f1-d72cda07e76d | SPCH | 2026-09-17 14:25 | put_vertical_spread | 2 | 1 | 249 | 440979.00 | unknown | — | 10.7100 | 0.7000 | ["19","20"] | ["2.2723","2.3742"] | [] | ["XISX"] | 19.0000 | 20.0000 | 8 | 8 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:26:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09d-2b9b-78b3-becb-7fce759e89f4 | SPCH | 2026-09-17 14:24 | put_vertical_spread | 2 | 1 | 122 | 173362.00 | unknown | — | 10.6800 | 0.7000 | ["17.5","18"] | ["1.8632","1.8811"] | [] | ["XISX"] | 17.5000 | 18.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:24:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09d-0873-79e1-aa9d-bf85bb63e118 | SPCH | 2026-09-17 14:24 | put_vertical_spread | 2 | 1 | 80 | 113680.00 | unknown | — | 10.6800 | 0.7000 | ["17.5","18"] | ["1.8632","1.8811"] | [] | ["XISX"] | 17.5000 | 18.0000 | 8 | 8 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:24:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09a-12a3-7891-9ff9-1e9b78ac3ccd | SPCH | 2026-09-17 14:21 | call_vertical_spread | 2 | 1 | 250 | 419750.00 | unknown | — | 10.7150 | 0.7000 | ["2","2.5"] | ["19.2736","16.7354"] | [] | ["XISX"] | 2.0000 | 2.5000 | 1 | 1 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:21:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b097-382b-7b62-9d7e-6dcc30fbc81f | SPCH | 2026-09-17 14:18 | call_vertical_spread | 2 | 1 | 213 | 381057.00 | unknown | — | 10.6629 | 0.5000 | ["1.5","2"] | ["6.4602","5.7892"] | [] | ["XISX"] | 1.5000 | 2.0000 | 8 | 8 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:18:15Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b017-36a3-7dd2-8f17-ff6d83b2dd8d | SPCH | 2026-09-17 11:58 | put_vertical_spread | 2 | 1 | 329 | 717220.00 | unknown | — | 10.6150 | 0.4000 | ["21","22"] | ["5.7202","6.0455"] | [] | ["XCBO"] | 21.0000 | 22.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:58:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b014-92da-7701-b7ec-2a2d3f26d9d3 | SPCH | 2026-09-17 11:55 | put_vertical_spread | 2 | 1 | 240 | 522960.00 | unknown | — | 10.5750 | 0.5000 | ["21","22"] | ["7.2357","7.6094"] | [] | ["XISX"] | 21.0000 | 22.0000 | 1 | 1 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:55:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b014-2193-72a2-ac42-68c8c7259272 | SPCH | 2026-09-17 11:55 | put_vertical_spread | 2 | 1 | 88 | 191752.00 | unknown | — | 10.5650 | 0.5000 | ["21","22"] | ["7.0688","7.4371"] | [] | ["XISX"] | 21.0000 | 22.0000 | 1 | 1 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:55:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b012-d973-7bb3-9339-a76257ff4920 | SPCH | 2026-09-17 11:53 | call_vertical_spread | 2 | 1 | 200 | 282000.00 | unknown | — | 10.5501 | 0.2000 | ["3","4"] | ["13.1621","10.3280"] | [] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:53:44Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b008-560b-7200-9b00-3c52f3762109 | SPCH | 2026-09-17 11:42 | call_vertical_spread | 2 | 1 | 88 | 138160.00 | unknown | — | 10.5650 | 0.4000 | ["2.5","3"] | ["14.1084","12.3847"] | [] | ["XCBO"] | 2.5000 | 3.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:42:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a17f-4c11-7fd1-b975-ce2658c49d8f | SPCH | 2026-09-14 15:57 | call_vertical_spread | 2 | 1 | 200 | 306000.00 | unknown | — | 9.8250 | 0.8000 | ["2","2.5"] | ["9.0530","7.8074"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:57:47Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a17e-b3b8-73a1-8e2c-4b52143ff469 | SPCH | 2026-09-14 15:57 | call_vertical_spread | 2 | 1 | 249 | 381219.00 | unknown | — | 9.8199 | 0.9000 | ["2","2.5"] | ["9.1752","8.1121"] | [] | ["XISX"] | 2.0000 | 2.5000 | 4 | 4 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:57:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08744-58b8-7880-95b1-5c436c05a324 | SPCH | 2026-09-09 13:43 | call_vertical_spread | 2 | 1 | 99 | 155529.00 | unknown | — | 9.6350 | 0.9000 | ["1.5","2"] | ["18.1292","17.4063"] | [] | ["XISX"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:44:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08744-25f0-7c82-b0c5-c69dc7aae63f | SPCH | 2026-09-09 13:43 | call_vertical_spread | 2 | 1 | 99 | 155529.00 | unknown | — | 9.6350 | 0.9000 | ["1.5","2"] | ["18.1292","17.4063"] | [] | ["XISX"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:43:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08687-fdf8-7ba2-8d27-f0af5312823e | SPCH | 2026-09-09 10:17 | call_vertical_spread | 2 | 1 | 89 | 152190.00 | unknown | — | 10.2881 | 0.4000 | ["1.5","2"] | ["11.3600","9.6491"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:17:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06de2-166d-78f1-9ea8-1d1ff2f5b142 | SPCH | 2026-09-04 15:25 | put_vertical_spread | 2 | 1 | 248 | 419120.00 | unknown | — | 10.0550 | 0.6000 | ["18","19"] | ["28.0342","30.2567"] | [] | ["XCBO"] | 18.0000 | 19.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:25:58Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcf-692e-7fc1-8cab-330d5b12b2c7 | SPCH | 2026-09-04 15:05 | put_vertical_spread | 2 | 1 | 249 | 423051.00 | unknown | — | 9.9700 | 0.5000 | ["18","19"] | ["32.8137","35.0818"] | [] | ["XISX"] | 18.0000 | 19.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:05:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |