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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c586-79bf-73a0-91d7-19dd7938bb9e | SPX | 2026-09-21 15:51 | put_ladder | 3 | 1 | 100 | 94800.00 | long | bid | 7768.4000 | 0.5500 | ["7720","7770","7775"] | ["0.6201","0.1553","0.1252"] | ["7767.79"] | ["XCBO"] | 7720.0000 | 7775.0000 | 0 | 0 | false | false | false | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:52:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4ae-5d86-7c01-99fd-a55122648b21 | SPX | 2026-09-21 11:55 | put_ladder | 3 | 2 | 120 | 2533680.00 | unknown | ask | 7737.4500 | 1.6000 | ["5400","7050","7460"] | ["0.3292","0.1982","0.1701"] | ["7128.04"] | ["XCBO"] | 5400.0000 | 7460.0000 | 158 | 158 | true | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:56:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b4e6-46b7-7312-beb6-60e7c5c22cb6 | EFA | 2026-09-18 10:23 | put_ladder | 3 | 2 | 59940 | 18041940.00 | unknown | bid | 104.8162 | 1.2800 | ["75","95","107"] | ["0.2962","0.2079","0.1719"] | ["8.75","91.56"] | ["XCBO"] | 75.0000 | 107.0000 | 182 | 182 | true | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:23:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ed-c46b-7dc0-9524-cf5bcd2357a4 | SPX | 2026-09-17 15:52 | put_ladder | 8 | 3 | 606 | 1362636.00 | unknown | — | 7643.6400 | 1.4500 | ["6550","6650","6700","6850","6925","7025","7075","7175"] | ["0.3396","0.3177","0.3065","0.2722","0.2568","0.2340","0.2233","0.2028"] | [] | ["XCBO"] | 6550.0000 | 7175.0000 | 14 | 14 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:53:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe7-9f0b-75f0-9b18-78e04759307f | SPX | 2026-09-17 11:06 | put_ladder | 3 | 3 | 150 | 159240.00 | unknown | — | 7615.7900 | 0.6000 | ["7500","7525","7575"] | ["0.1903","0.1753","0.1423"] | [] | ["XCBO"] | 7500.0000 | 7575.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:06:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe6-56eb-7460-993e-c5d24a4b09e6 | SPX | 2026-09-17 11:05 | put_ladder | 3 | 4 | 200 | 236000.00 | unknown | — | 7617.7600 | 0.5000 | ["7500","7525","7575"] | ["0.1904","0.1742","0.1422"] | [] | ["XCBO"] | 7500.0000 | 7575.0000 | 1 | 1 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:05:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9d-4f9b-7610-8a4b-42938a0181ae | RUT | 2026-09-17 09:45 | put_ladder | 3 | 2 | 2715 | 6880339.00 | unknown | — | 2891.2650 | 1.1500 | ["2450","2470","2790"] | ["0.3168","0.3086","0.2016"] | [] | ["XCBO"] | 2450.0000 | 2790.0000 | 29 | 29 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:45:31Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb3-cce3-7c82-96bc-78dbf6d6f68c | SPX | 2026-09-16 15:31 | put_ladder | 3 | 1 | 378 | 1594183.00 | unknown | — | 7528.2400 | 1.7000 | ["7420","7500","7520"] | ["0.2066","0.1823","0.1771"] | [] | ["XCBO"] | 7420.0000 | 7520.0000 | 2 | 2 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:31:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa8b-e2fb-7e02-b2e4-c19f7823489a | SPX | 2026-09-16 10:08 | put_ladder | 5 | 4 | 1440 | 3868740.00 | unknown | — | 7607.9000 | 1.3000 | ["7420","7450","7470","7500","7520"] | ["0.2414","0.2297","0.2223","0.2117","0.2048"] | [] | ["XCBO"] | 7420.0000 | 7520.0000 | 2 | 2 | false | true | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:08:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a594-a88d-7ca2-8a55-ce0a4dd3ef78 | SPX | 2026-09-15 10:59 | put_ladder | 3 | 1 | 150 | 323550.00 | unknown | — | 7576.9500 | 0.9000 | ["7350","7410","7585"] | ["0.2469","0.2242","0.1672"] | [] | ["XCBO"] | 7350.0000 | 7585.0000 | 3 | 3 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:00:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a17e-7d08-72d0-9601-8e1c2e072427 | SPX | 2026-09-14 15:56 | put_ladder | 3 | 2 | 400 | 1476000.00 | long | bid | 7622.4700 | 0.5000 | ["7575","7600","7625"] | ["0.1415","0.1295","0.1189"] | ["7600.30"] | ["XCBO"] | 7575.0000 | 7625.0000 | 1 | 1 | false | false | false | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:57:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |