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
active:strategy = strap×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a06d-d058-7531-bf7f-351bcdcc16ab | SPX | 2026-09-14 10:59 | strap | 2 | 1 | 4 | 46590.00 | long | ask | 7597.6000 | 0.8000 | ["7685"] | ["0.1255"] | ["7452.05","7801.48"] | ["XCBO"] | 7685.0000 | 7685.0000 | 18 | 18 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:59:13Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a069-c148-7491-b8b0-4e71a994c042 | SPX | 2026-09-14 10:54 | strap | 2 | 1 | 4 | 47130.00 | long | ask | 7595.2600 | 1.0000 | ["7680"] | ["0.1268"] | ["7444.35","7797.82"] | ["XCBO"] | 7680.0000 | 7680.0000 | 18 | 18 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:54:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04c-4e38-7bc1-ab63-dda7a0ab6c0a | SPX | 2026-09-14 10:22 | strap | 2 | 1 | 4 | 36080.00 | long | ask | 7605.5600 | 1.2000 | ["7690"] | ["0.1246"] | ["7509.60","7780.20"] | ["XCBO"] | 7690.0000 | 7690.0000 | 11 | 11 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:22:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a04c-3ab0-7202-8d90-552c8c16068e | SPX | 2026-09-14 10:22 | strap | 2 | 1 | 4 | 36260.00 | long | ask | 7605.8800 | 1.1000 | ["7685"] | ["0.1253"] | ["7503.70","7775.65"] | ["XCBO"] | 7685.0000 | 7685.0000 | 11 | 11 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:22:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a025-26c8-7d93-8f04-36f08eb6d432 | MU | 2026-09-14 09:39 | strap | 2 | 2 | 10 | 54670.00 | long | ask | 906.7400 | 3.1000 | ["930"] | ["0.6160"] | ["820.66","984.67"] | ["EDGO","EMLD"] | 930.0000 | 930.0000 | 11 | 11 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:39:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09215-5418-7a00-aeb3-73aa4f082974 | SPX | 2026-09-11 16:07 | strap | 2 | 1 | 20 | 56250.00 | long | ask | 7656.9800 | 0.3000 | ["7660"] | ["0.0680"] | ["7603.75","7688.12"] | ["XCBO"] | 7660.0000 | 7660.0000 | 3 | 3 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T20:09:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cdd-bdf0-7010-bd39-64d4429c006d | SPX | 2026-09-10 15:48 | strap | 2 | 1 | 2 | 48940.00 | long | ask | 7590.7400 | 1.9000 | ["7845"] | ["0.1323"] | ["7355.60","8089.70"] | ["XCBO"] | 7845.0000 | 7845.0000 | 71 | 71 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:49:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cdc-fe87-7570-bd75-f4c9950f2ef5 | SPX | 2026-09-10 15:48 | strap | 2 | 1 | 4 | 44020.00 | long | ask | 7592.4400 | 1.0000 | ["7685"] | ["0.1303"] | ["7464.90","7795.05"] | ["XCBO"] | 7685.0000 | 7685.0000 | 15 | 15 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:48:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cdc-df49-7d00-b02f-0dedaeb816a2 | SPX | 2026-09-10 15:47 | strap | 2 | 1 | 2 | 49020.00 | long | ask | 7592.8800 | 1.8000 | ["7840"] | ["0.1326"] | ["7349.80","8085.10"] | ["XCBO"] | 7840.0000 | 7840.0000 | 71 | 71 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:47:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cdc-6248-7b92-8706-88055a2a3bc3 | SPX | 2026-09-10 15:47 | strap | 2 | 1 | 4 | 43730.00 | long | ask | 7592.9300 | 1.0000 | ["7690"] | ["0.1295"] | ["7471.35","7799.32"] | ["XCBO"] | 7690.0000 | 7690.0000 | 15 | 15 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:47:30Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7d-fe38-7812-923f-dcf1ac379f8a | VIX | 2026-09-10 14:04 | strap | 2 | 2 | 240 | 36960.00 | unknown | — | 17.6200 | 0.1000 | ["19"] | ["1.1962"] | [] | ["XCBO"] | 19.0000 | 19.0000 | 6 | 6 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:05:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0869f-cbb8-7751-a9f6-3ea0e8a5fa2b | META | 2026-09-09 10:43 | strap | 2 | 1 | 10 | 91200.00 | long | ask | 645.0150 | 1.7000 | ["700"] | ["0.4189"] | ["517.60","791.20"] | ["XISX"] | 700.0000 | 700.0000 | 128 | 128 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:43:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0829e-a250-78c0-ae0d-dae858fc6cd5 | SPX | 2026-09-08 16:03 | strap | 2 | 1 | 20 | 54000.00 | long | ask | 7673.5300 | 0.5000 | ["7675"] | ["0.1130"] | ["7621","7702.00"] | ["XCBO"] | 7675.0000 | 7675.0000 | 1 | 1 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:05:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08251-e5c8-7d70-93e6-00bf06274b3e | DRAM | 2026-09-08 14:39 | strap | 2 | 9 | 94 | 105750.00 | long | ask | 61.9200 | 0.3234 | ["65"] | ["0.7001"] | ["42.50","76.25"] | ["AMXO","ARCO","EDGO","XBOX","XCBO","XISX","XMIO","XPHO"] | 65.0000 | 65.0000 | 73 | 73 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:40:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06e0a-cc4d-7dc0-b9c4-5a4706ea7608 | SPX | 2026-09-04 16:09 | strap | 2 | 1 | 12 | 34380.00 | long | ask | 7718.6000 | 0.4000 | ["7710"] | ["0.0509"] | ["7652.70","7738.65"] | ["XCBO"] | 7710.0000 | 7710.0000 | 4 | 4 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:11:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d73-d7c5-7fa0-8da7-116d32c660cc | SPX | 2026-09-04 13:25 | strap | 2 | 1 | 2 | 32600.00 | long | ask | 7716.3800 | 2.2000 | ["7980"] | ["0.1052"] | ["7654","8143.00"] | ["XCBO"] | 7980.0000 | 7980.0000 | 42 | 42 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:25:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |