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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0cc-6d43-7862-80b0-75bb0ee39191 | CAT | 2026-09-17 15:16 | strangle | 2 | 2 | 50 | 636250.00 | long | ask | 796.1899 | 4.5960 | ["900","1000"] | ["0.4181","0.4134"] | ["772.75","1127.25"] | ["AMXO"] | 900.0000 | 1000.0000 | 64 | 64 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:16:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afea-7983-7ac2-8324-74a9b0f0bb52 | CAT | 2026-09-17 11:09 | strangle | 2 | 3 | 3 | 27595.00 | long | ask | 798.0800 | 7.7500 | ["780","870"] | ["0.4163","0.3959"] | ["688.02","961.98"] | ["ARCO","C2OX","EDGO"] | 780.0000 | 870.0000 | 92 | 92 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:09:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a6a1-1f1e-7650-9f25-75f3f21f5fb5 | CAT | 2026-09-15 15:52 | strangle | 2 | 2 | 29 | 48836.00 | long | ask | 781.6850 | 1.1500 | ["770","785"] | ["0.4160","0.4112"] | ["753.16","801.84"] | ["AMXO","XMIO"] | 770.0000 | 785.0000 | 3 | 3 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:52:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a693-e466-7ea0-8a0c-22f09899cfae | CAT | 2026-09-15 15:38 | strangle | 2 | 1 | 2 | 27580.00 | long | ask | 781.5200 | 20.7000 | ["640","1100"] | ["0.4299","0.4118"] | ["502.10","1237.90"] | ["XBOX"] | 640.0000 | 1100.0000 | 493 | 493 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:38:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a686-d0be-7692-b9e6-95ee3c1b1323 | CAT | 2026-09-15 15:24 | strangle | 2 | 7 | 7 | 81368.00 | long | ask | 781.5750 | 1.8929 | ["720","1000"] | ["0.4079","0.3979"] | ["603.76","1116.24"] | ["AMXO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 720.0000 | 1000.0000 | 275 | 275 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:24:36Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a644-5536-71c3-9d17-1cc7119a3326 | CAT | 2026-09-15 14:11 | strangle | 2 | 1 | 6 | 46044.00 | long | ask | 783.8200 | 4.1000 | ["790","810"] | ["0.3601","0.3521"] | ["733.26","866.74"] | ["SPHR"] | 790.0000 | 810.0000 | 31 | 31 | false | false | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:11:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a06dad-9505-7e40-9f25-5ca5bb0d7f7c | CAT | 2026-09-04 14:28 | strangle | 2 | 1 | 6 | 103554.00 | long | ask | 810.4200 | 12.5000 | ["680","1020"] | ["0.4426","0.4116"] | ["507.41","1192.59"] | ["XISX"] | 680.0000 | 1020.0000 | 469 | 469 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:28:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4b-6065-7ef2-8acb-e5f2470f36da | CAT | 2026-09-04 12:40 | strangle | 2 | 2 | 2 | 39368.00 | long | ask | 813.1850 | 13.6000 | ["760","1100"] | ["0.4424","0.4055"] | ["563.16","1296.84"] | ["C2OX","XISX"] | 760.0000 | 1100.0000 | 504 | 504 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4a-fad5-7c70-861b-84f29450277c | CAT | 2026-09-04 12:40 | strangle | 2 | 3 | 3 | 59052.00 | long | ask | 813.1400 | 13.9167 | ["760","1100"] | ["0.4421","0.4057"] | ["563.16","1296.84"] | ["XCBO","XISX","XPHO"] | 760.0000 | 1100.0000 | 504 | 504 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:40:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4a-f6ed-76e2-b18e-716e104045bc | CAT | 2026-09-04 12:40 | strangle | 2 | 3 | 3 | 59052.00 | long | ask | 813.1400 | 14.3667 | ["760","1100"] | ["0.4424","0.4055"] | ["563.16","1296.84"] | ["EMLD","XISX","XMIO"] | 760.0000 | 1100.0000 | 504 | 504 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:40:28Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |