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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 01a0c443-6e87-7ad0-b0b3-671f60fd230e | SPX | 2026-09-21 09:59 | put_diagonal_spread | 2 | 1 | 200 | 45000.00 | unknown | — | 7705.0200 | 0.4000 | ["1800","2200"] | ["0.6439","0.8977"] | [] | ["XCBO"] | 1800.0000 | 2200.0000 | 60 | 269 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:59:24Z"} | 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 |
| 01a0b4db-abe0-7471-bbdc-1b8f3dd7c415 | SPX | 2026-09-18 10:11 | put_diagonal_spread | 2 | 1 | 200 | 46500.00 | unknown | — | 7627.9600 | 0.4000 | ["4500","5000"] | ["0.5024","0.5439"] | [] | ["XCBO"] | 4500.0000 | 5000.0000 | 28 | 63 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aff2-c29b-71d0-bb37-e4c86d02ef5a | SPX | 2026-09-17 11:18 | put_diagonal_spread | 2 | 1 | 18 | 64050.00 | unknown | — | 7625.0400 | 1.1000 | ["6375","7645"] | ["0.2756","0.1254"] | [] | ["XCBO"] | 6375.0000 | 7645.0000 | 29 | 64 | false | false | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:18:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afe0-e463-7411-9a67-ef7dd04bf92d | SPX | 2026-09-17 10:59 | put_diagonal_spread | 2 | 1 | 18 | 60060.00 | unknown | — | 7618.7000 | 0.8000 | ["6325","7620"] | ["0.2812","0.1287"] | [] | ["XCBO"] | 6325.0000 | 7620.0000 | 28 | 64 | false | false | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:59:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa9b-11b2-7de0-83d3-75e76683a355 | SPX | 2026-09-16 10:24 | put_diagonal_spread | 2 | 1 | 15 | 46920.00 | unknown | — | 7601.4500 | 4.8000 | ["6460","7675"] | ["0.2876","0.1303"] | [] | ["XCBO"] | 6460.0000 | 7675.0000 | 5 | 44 | false | false | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:25:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a674-c3a6-7b92-bad5-c73e19cd5990 | SPX | 2026-09-15 15:04 | put_diagonal_spread | 2 | 2 | 10 | 93580.00 | unknown | — | 7585.8100 | 1.0000 | ["7200","7300"] | ["0.1886","0.1793"] | [] | ["XCBO"] | 7200.0000 | 7300.0000 | 31 | 66 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:04:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c8-4f36-7102-9bf4-b028ab3d7cfb | SPX | 2026-09-15 11:56 | put_diagonal_spread | 2 | 1 | 4 | 95080.00 | unknown | — | 7586.9400 | 1.3000 | ["6800","7650"] | ["0.2548","0.1514"] | [] | ["XCBO"] | 6800.0000 | 7650.0000 | 31 | 94 | false | false | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:56:09Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5c8-4f36-7102-9bf4-b011593c39f2 | SPX | 2026-09-15 11:56 | put_diagonal_spread | 2 | 1 | 4 | 63140.00 | unknown | — | 7586.9400 | 1.6000 | ["6900","7500"] | ["0.2172","0.1547"] | [] | ["XCBO"] | 6900.0000 | 7500.0000 | 31 | 94 | false | true | true | true | false | mfsl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:56:09Z"} | 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 |