core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0caae-c1ee-7bd3-900d-916a21ea6266 | HWM | 2026-09-22 15:54 | put_vertical_spread | 2 | 1 | 11 | 147290.00 | long | ask | 225.4400 | 5.0000 | ["290","295"] | ["0.5636","0.5995"] | [] | ["ARCO"] | 290.0000 | 295.0000 | 24 | 24 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:54:15Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9f2-8e3f-7163-a523-bab36c887c30 | HWM | 2026-09-22 12:28 | put_calendar | 2 | 1 | 49 | 241374.00 | short | bid | 226.6650 | 6.6000 | ["250"] | ["0.3463"] | [] | ["BATO"] | 250.0000 | 250.0000 | 24 | 38 | false | false | true | false | false | ||||||||
| 01a0b4d1-43d0-7882-ae5e-f9789719f789 | HWM | 2026-09-18 10:00 | put_vertical_spread | 2 | 1 | 16 | 124016.00 | short | bid | 225.8050 | 6.8000 | ["260","270"] | ["0.3101","0.3348"] | ["260.25"] | ["XISX"] | 260.0000 | 270.0000 | 28 | 28 | false | false | false | true | false | ||||||||
| 01a0b0cb-b1c3-7971-9f56-c22f2f25bf86 | HWM | 2026-09-17 15:15 | straddle | 2 | 1 | 25 | 213150.00 | long | ask | 225.0100 | 5.0000 | ["240"] | ["0.4132"] | ["154.74","325.26"] | ["XMIO"] | 240.0000 | 240.0000 | 491 | 491 | false | false | false | false | true | ||||||||
| 01a0b0c3-784b-7451-b4ac-4cc73c023541 | HWM | 2026-09-17 15:06 | other | 3 | 7 | 41 | 205582.00 | unknown | — | 225.4110 | 6.8000 | ["200","230","270"] | ["0.4246","0.4072","0.3863"] | [] | ["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"] | 200.0000 | 270.0000 | 183 | 183 | false | false | false | true | true | mlet | |||||||
| 01a0b0c0-3843-7800-9656-0cf1312ac6e7 | HWM | 2026-09-17 15:03 | other | 3 | 10 | 50 | 251728.00 | unknown | — | 225.7200 | 6.8000 | ["200","230","270"] | ["0.4271","0.4110","0.3855"] | [] | ["AMXO","ARCO","C2OX","EDGO","EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 200.0000 | 270.0000 | 183 | 183 | false | false | false | true | true | mlet | |||||||
| 01a0a154-5be0-7e13-a9c0-948885763526 | HWM | 2026-09-14 15:10 | other | 2 | 1 | 30 | 331950.00 | unknown | — | 228.4258 | 7.5000 | ["150","200"] | ["2.7957","0.4105"] | [] | ["XPHO"] | 150.0000 | 200.0000 | 4 | 46 | false | false | true | true | false | mlet | |||||||
| 01a090bf-c2b0-7db3-bbd0-f92debc131af | HWM | 2026-09-11 09:54 | other | 2 | 1 | 20 | 122200.00 | unknown | — | 229.1900 | 5.4000 | ["270"] | ["0.4742"] | [] | ["XMIO"] | 270.0000 | 270.0000 | 14 | 35 | false | false | true | false | false | mlet | |||||||
| 01a08c5d-a110-72b0-86b0-1b351248b29f | HWM | 2026-09-10 13:28 | other | 2 | 1 | 34 | 380426.00 | unknown | — | 228.2200 | 5.9000 | ["175","185"] | ["0.6041","0.4574"] | [] | ["XISX"] | 175.0000 | 185.0000 | 36 | 190 | false | false | true | true | false | mlet | |||||||
| 01a087a3-8400-74b3-bb8a-561c3048d209 | HWM | 2026-09-09 15:27 | other | 2 | 1 | 20 | 143600.00 | unknown | — | 233.6525 | 3.6000 | ["270"] | ["0.4050"] | [] | ["XISX"] | 270.0000 | 270.0000 | 9 | 16 | false | false | true | false | false | mlet | |||||||
| 01a08295-8e18-7253-a25c-18533a108b5b | HWM | 2026-09-08 15:53 | put_vertical_spread | 2 | 1 | 21 | 153321.00 | long | ask | 230.7100 | 6.4000 | ["265","270"] | ["0.3261","0.3365"] | ["265.15"] | ["C2OX"] | 265.0000 | 270.0000 | 24 | 24 | false | false | false | true | false | ||||||||
| 01a08295-8e18-7253-a25c-18422b6ae7ad | HWM | 2026-09-08 15:53 | put_vertical_spread | 2 | 4 | 19 | 138367.00 | long | ask | 230.7100 | 6.4000 | ["265","270"] | ["0.3328","0.3438"] | ["265.15"] | ["EMLD","SPHR","XBOX","XPHO"] | 265.0000 | 270.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0826b-45e0-77b1-ac30-f46a8ab29549 | HWM | 2026-09-08 15:07 | put_vertical_spread | 2 | 1 | 50 | 478000.00 | unknown | — | 236.5100 | 6.0000 | ["200","300"] | ["0.3976","0.3879"] | [] | ["XISX"] | 200.0000 | 300.0000 | 500 | 500 | false | false | false | true | false | mlet | |||||||
| 01a08253-35b9-7a40-b8cc-79604803d8f5 | HWM | 2026-09-08 14:41 | risk_reversal | 2 | 5 | 69 | 182781.00 | short | bid | 237.8600 | 1.5000 | ["200","270"] | ["0.4069","0.3889"] | ["276.80"] | ["ARCO","EDGO","XISX","XPHO"] | 200.0000 | 270.0000 | 192 | 192 | false | true | false | true | |||||||||
| 01a0823d-f450-7ca2-a1e8-94cfc43f80d5 | HWM | 2026-09-08 14:18 | strangle | 2 | 1 | 40 | 105440.00 | long | ask | 237.8550 | 1.3000 | ["200","270"] | ["0.4100","0.3846"] | ["173.64","296.36"] | ["ARCO"] | 200.0000 | 270.0000 | 192 | 192 | false | true | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:29:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:00:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:15:54Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:07:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:03:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:11:02Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:54:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:29:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:27:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:54:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:54:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:08:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:41:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:19:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |