Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b609-2b77-7b63-92e5-2d17579de94d | SKHY | 2026-09-18 15:40 | put_frontspread | 2 | 1 | 2450 | 3956750.00 | long | ask | 189.7650 | 0.3000 | ["175","190"] | ["0.5819","0.5888"] | ["181.85"] | ["SPHR"] | 175.0000 | 190.0000 | 28 | 28 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a69b-d78e-7f71-a45a-c7f28ef0ad6e | SKHY | 2026-09-15 15:47 | call_ratio_spread | 2 | 1 | 3222 | 8514135.00 | unknown | — | 174.6300 | 2.5500 | ["150","225"] | ["0.5996","0.6525"] | [] | ["SPHR"] | 150.0000 | 225.0000 | 94 | 94 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:47:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091cd-4ab1-73b3-8fbf-88e092938121 | SKHY | 2026-09-11 14:49 | other | 2 | 1 | 4424 | 17585400.00 | unknown | — | 190.4550 | 2.6500 | ["150","225"] | ["0.6472","0.6648"] | [] | ["SPHR"] | 150.0000 | 225.0000 | 98 | 98 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:49:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c9b-e678-70c2-9eb6-2886db3eb131 | SKHY | 2026-09-10 14:36 | other | 2 | 1 | 2652 | 10601370.00 | unknown | — | 190.7650 | 3.6000 | ["150","225"] | ["0.6245","0.6675"] | [] | ["SPHR"] | 150.0000 | 225.0000 | 99 | 99 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:37:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087bd-f1a0-7551-a316-44e1aa122fe9 | SKHY | 2026-09-09 15:56 | other | 2 | 1 | 8000 | 35200000.00 | unknown | — | 199.5900 | 4.4000 | ["155","240"] | ["0.6615","0.7173"] | [] | ["SPHR"] | 155.0000 | 240.0000 | 100 | 100 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:56:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0878a-04a8-7502-ac28-e1ca2c7570f1 | SKHY | 2026-09-09 14:59 | other | 2 | 1 | 1500 | 2430000.00 | unknown | — | 198.4800 | 2.1500 | ["150","250"] | ["0.6801","0.7040"] | [] | ["ARCO"] | 150.0000 | 250.0000 | 100 | 100 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:59:48Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0876a-4b90-7aa0-913b-ed093f437e8e | SKHY | 2026-09-09 14:24 | other | 2 | 1 | 3000 | 1434000.00 | unknown | — | 196.9000 | 0.0900 | ["170","200"] | ["0.7449","0.7118"] | [] | ["ARCO"] | 170.0000 | 200.0000 | 9 | 9 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:25:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0824d-f210-76b2-addd-345a2aae3c68 | SKHY | 2026-09-08 14:35 | other | 2 | 1 | 3150 | 17120250.00 | unknown | — | 187.3750 | 2.6500 | ["165"] | ["0.7073"] | [] | ["ARCO"] | 165.0000 | 165.0000 | 192 | 282 | true | true | true | false | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:36:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |