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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c563-4606-7220-a94f-3c031b270cfb | SMH | 2026-09-21 15:13 | call_vertical_spread | 2 | 3 | 181 | 934160.00 | short | bid | 596.2100 | 0.1550 | ["600","650"] | ["0.3643","0.3571"] | ["618.81"] | ["C2OX"] | 600.0000 | 650.0000 | 60 | 60 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:13:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c552-2737-77d1-b65f-aee4cc2a3d20 | SMH | 2026-09-21 14:54 | call_vertical_spread | 2 | 1 | 130 | 393250.00 | short | bid | 595.9500 | 0.1500 | ["600","625"] | ["0.3383","0.3346"] | ["609.55"] | ["C2OX"] | 600.0000 | 625.0000 | 25 | 25 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:55:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c490-debe-7523-80ca-489ecfd4ae40 | SMH | 2026-09-21 11:23 | call_vertical_spread | 2 | 1 | 4 | 75140.00 | short | bid | 590.2300 | 5.8500 | ["480","520"] | ["0.5671","0.4573"] | ["515.15"] | ["XISX"] | 480.0000 | 520.0000 | 25 | 25 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:23:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48a-2fcf-7750-ae97-28493b3332e6 | SMH | 2026-09-21 11:16 | call_vertical_spread | 2 | 2 | 109 | 246330.00 | short | bid | 590.3900 | 0.3000 | ["605","630"] | ["0.3354","0.3360"] | ["612.5"] | ["EDGO","XISX"] | 605.0000 | 630.0000 | 25 | 25 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:16:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a657-6fd6-7493-9736-4f5773772c5e | SMH | 2026-09-15 14:32 | call_vertical_spread | 2 | 2 | 10 | 31800.00 | long | ask | 541.7950 | 0.7000 | ["600","620"] | ["0.3389","0.3369"] | ["604.90"] | ["C2OX"] | 600.0000 | 620.0000 | 94 | 94 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:32:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0871c-4ad0-7cf0-a409-b870484b149d | SMH | 2026-09-09 12:59 | call_vertical_spread | 2 | 1 | 10 | 66750.00 | unknown | — | 574.3900 | 5.4500 | ["795","900"] | ["0.3659","0.3628"] | [] | ["ARCO"] | 795.0000 | 900.0000 | 464 | 464 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:59:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a0-0a38-71c3-a4ac-b7b77bd9175e | SMH | 2026-09-09 10:43 | call_vertical_spread | 2 | 1 | 30 | 49200.00 | short | bid | 575.2450 | 2.6500 | ["580","615"] | ["0.3487","0.3435"] | ["590.10"] | ["C2OX"] | 580.0000 | 615.0000 | 13 | 13 | true | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:44:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0869c-d5e8-70e1-9d1b-3c6dfaed9f68 | SMH | 2026-09-09 10:40 | call_vertical_spread | 2 | 1 | 35 | 39515.00 | short | bid | 575.7300 | 1.5700 | ["590","640"] | ["0.3486","0.3555"] | ["598.81"] | ["C2OX"] | 590.0000 | 640.0000 | 14 | 14 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:40:31Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08698-fd88-72d0-8bb4-fb8fb5c3593c | SMH | 2026-09-09 10:36 | call_vertical_spread | 2 | 2 | 35 | 33110.00 | short | bid | 575.8500 | 2.1100 | ["595","645"] | ["0.3479","0.3624"] | ["602.34"] | ["C2OX"] | 595.0000 | 645.0000 | 14 | 14 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:36:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dce-f7e5-70f3-aaf6-32a90f685839 | SMH | 2026-09-04 15:04 | call_vertical_spread | 2 | 1 | 10 | 35450.00 | unknown | — | 564.3000 | 3.0000 | ["710","940"] | ["0.3491","0.3413"] | [] | ["ARCO"] | 710.0000 | 940.0000 | 286 | 286 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:04:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |