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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57b-2f1f-78d1-8121-9df55ccd5625 | SPX | 2026-09-21 15:39 | put_diagonal_spread | 2 | 1 | 70 | 2181060.00 | short | bid | 7778.7600 | 1.9000 | ["6950","7575"] | ["0.2121","0.1580"] | [] | ["XCBO"] | 6950.0000 | 7575.0000 | 88 | 333 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:39:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c527-17c7-79e3-80ef-c42c3556c309 | SPX | 2026-09-21 14:07 | put_diagonal_spread | 2 | 1 | 128 | 57856.00 | short | bid | 7762.9400 | 0.2500 | ["7580","7585"] | ["0.1814","0.1671"] | [] | ["XCBO"] | 7580.0000 | 7585.0000 | 2 | 3 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:08:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4da-efaf-7a12-94f3-4a2a4cf631ec | SPX | 2026-09-21 12:44 | put_diagonal_spread | 2 | 1 | 500 | 7572000.00 | unknown | bid | 7751.1800 | 0.9000 | ["7250","7450"] | ["0.1848","0.1675"] | [] | ["XCBO"] | 7250.0000 | 7450.0000 | 88 | 116 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:45:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c490-233e-7be3-b1a9-b0a49b169609 | SPX | 2026-09-21 11:22 | put_diagonal_spread | 2 | 1 | 134 | 93800.00 | short | bid | 7730.0900 | 0.3000 | ["7400","7450"] | ["0.2125","0.1601"] | [] | ["XCBO"] | 7400.0000 | 7450.0000 | 4 | 9 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:23:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c48b-701f-7082-81a6-b26b9d711231 | SPX | 2026-09-21 11:17 | put_diagonal_spread | 2 | 1 | 60 | 125700.00 | unknown | bid | 7729.6100 | 0.1500 | ["7640","7650"] | ["0.1542","0.1120"] | [] | ["XCBO"] | 7640.0000 | 7650.0000 | 1 | 8 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:17:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c459-639e-7613-8b8f-c2d783307b33 | SPX | 2026-09-21 10:23 | put_diagonal_spread | 2 | 1 | 200 | 66000.00 | short | bid | 7720.4400 | 0.4500 | ["2000","2200"] | ["0.6145","0.7452"] | [] | ["XCBO"] | 2000.0000 | 2200.0000 | 116 | 269 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:23:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c449-8137-74b3-be8b-f0e34bc96dac | SPX | 2026-09-21 10:05 | put_diagonal_spread | 2 | 1 | 177 | 273465.00 | unknown | bid | 7702.6800 | 0.3000 | ["7640","7645"] | ["0.1252","0.1364"] | [] | ["XCBO"] | 7640.0000 | 7645.0000 | 1 | 3 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:05:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c448-dd26-7aa3-bd4e-81f6f2e6f364 | SPX | 2026-09-21 10:05 | put_diagonal_spread | 2 | 1 | 100 | 401000.00 | unknown | bid | 7705.5800 | 0.5000 | ["7500","7510"] | ["0.1428","0.1371"] | [] | ["XCBO"] | 7500.0000 | 7510.0000 | 14 | 18 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:05:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c446-971e-73a1-9a8a-fceb79169aa0 | SPX | 2026-09-21 10:02 | put_diagonal_spread | 2 | 1 | 200 | 303800.00 | unknown | bid | 7705.8700 | 0.4000 | ["7640","7645"] | ["0.1280","0.1400"] | [] | ["XCBO"] | 7640.0000 | 7645.0000 | 1 | 3 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:02:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43f-c8ef-7d53-a79e-ea6f1e2afdaa | SPX | 2026-09-21 09:55 | put_diagonal_spread | 2 | 1 | 18 | 43896.00 | unknown | bid | 7705.3600 | 1.0000 | ["6375","7645"] | ["0.2805","0.1250"] | [] | ["XCBO"] | 6375.0000 | 7645.0000 | 25 | 60 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:55:15Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5e3-9277-7513-a594-62c2f0dda6f9 | SPX | 2026-09-18 14:59 | put_diagonal_spread | 2 | 1 | 300 | 627300.00 | unknown | bid | 7641.7600 | 1.1000 | ["6400","7710"] | ["0.2714","0.1409"] | [] | ["XCBO"] | 6400.0000 | 7710.0000 | 63 | 91 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:00:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b587-7087-7a61-b19c-5a55b6c00b73 | SPX | 2026-09-18 13:19 | put_diagonal_spread | 2 | 1 | 60 | 145800.00 | unknown | bid | 7623.5200 | 0.4000 | ["7525","7560"] | ["0.1265","0.1075"] | [] | ["XCBO"] | 7525.0000 | 7560.0000 | 4 | 6 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:19:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50b-2fef-7ce2-bf6a-98c1cf98d909 | SPX | 2026-09-18 11:03 | put_diagonal_spread | 2 | 1 | 596 | 2281600.00 | unknown | bid | 7626.5700 | 0.7000 | ["6200","6875"] | ["0.2799","0.2173"] | [] | ["XCBO"] | 6200.0000 | 6875.0000 | 63 | 91 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:03:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e5-509f-78d0-a387-9d78054f589b | SPX | 2026-09-18 10:21 | put_diagonal_spread | 2 | 1 | 198 | 1112760.00 | long | bid | 7623.3600 | 0.4000 | ["7615","7650"] | ["0.1009","0.1556"] | [] | ["XCBO"] | 7615.0000 | 7650.0000 | 0 | 4 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:22:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abc3-595b-7591-aa00-7b785006d801 | SPX | 2026-09-16 15:48 | put_diagonal_spread | 2 | 1 | 175 | 402500.00 | short | bid | 7543.5000 | 0.2500 | ["7495","7520"] | ["0.1911","0.5366"] | [] | ["XCBO"] | 7495.0000 | 7520.0000 | 0 | 2 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:48:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5ac-5af6-7120-a983-2d361a70572a | SPX | 2026-09-15 11:25 | put_diagonal_spread | 2 | 1 | 600 | 27321000.00 | short | bid | 7585.3600 | 1.9000 | ["6800","7200"] | ["0.2144","0.1995"] | [] | ["XCBO"] | 6800.0000 | 7200.0000 | 275 | 367 | false | true | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:25:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a545-e096-76f1-a67c-ad3ca2ef50ae | SPX | 2026-09-15 09:33 | put_diagonal_spread | 2 | 1 | 280 | 26040.00 | short | bid | 7605.4900 | 0.1500 | ["7050","7090"] | ["0.4470","0.8282"] | [] | ["XCBO"] | 7050.0000 | 7090.0000 | 0 | 2 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:33:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |