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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60a-9e90-78b3-9c85-278c19343b4a | O | 2026-09-18 15:42 | put_diagonal_spread | 2 | 1 | 100 | 119000.00 | unknown | — | 56.7640 | 1.0000 | ["60","65"] | ["0.2061","17.5808"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:42:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58d-63f7-7a53-a521-4e9e69c16d4a | O | 2026-09-18 13:25 | put_diagonal_spread | 2 | 1 | 100 | 247100.00 | unknown | bid | 56.6250 | 1.7000 | ["67.5","70"] | ["0.3003","0.5482"] | [] | ["ARCO"] | 67.5000 | 70.0000 | 28 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:26:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58d-5c27-7c93-bd7d-0e7777fed881 | O | 2026-09-18 13:25 | put_diagonal_spread | 2 | 1 | 100 | 247200.00 | unknown | bid | 56.6272 | 1.7000 | ["67.5","70"] | ["0.3019","0.5452"] | [] | ["ARCO"] | 67.5000 | 70.0000 | 28 | 182 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:25:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b564-40b7-7f20-871a-8617d3f7e6d6 | O | 2026-09-18 12:40 | put_diagonal_spread | 2 | 2 | 100 | 148500.00 | unknown | — | 56.6450 | 0.5000 | ["62.5","65"] | ["0.2511","3.6842"] | [] | ["XCBO"] | 62.5000 | 65.0000 | 0 | 119 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:40:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b542-551f-7dd1-a2e6-d4dcc8790f14 | O | 2026-09-18 12:03 | other | 4 | 1 | 74 | 217338.00 | unknown | ask | 56.7000 | 1.3000 | ["60","62.5","65","67.5"] | ["0.2174","0.2525","3.8843","4.0436"] | [] | ["XCBO"] | 60.0000 | 67.5000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:04:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53d-c90f-7d32-9f67-475265633148 | O | 2026-09-18 11:58 | put_diagonal_spread | 2 | 2 | 100 | 122500.00 | unknown | — | 56.7250 | 0.7000 | ["60","65"] | ["0.2123","4.0131"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:59:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53d-82bf-73d3-b94a-dd25cf2884b6 | O | 2026-09-18 11:58 | put_diagonal_spread | 2 | 1 | 100 | 122500.00 | unknown | — | 56.7450 | 0.7000 | ["60","65"] | ["0.2136","4.1318"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:58:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53d-7ed7-7941-9f84-f40c3c07ab16 | O | 2026-09-18 11:58 | put_diagonal_spread | 2 | 1 | 100 | 122500.00 | unknown | — | 56.7450 | 0.7000 | ["60","65"] | ["0.2136","4.1316"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:58:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53d-5f98-74e0-b184-18d6a74f2837 | O | 2026-09-18 11:58 | put_diagonal_spread | 2 | 1 | 100 | 122500.00 | unknown | — | 56.7450 | 0.7000 | ["60","65"] | ["0.2136","4.1307"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:58:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b008-5ddb-71c2-b58e-c0abeb418428 | O | 2026-09-17 11:42 | other | 6 | 5 | 88 | 132162.00 | unknown | — | 57.1000 | 5.5000 | ["52.5","55","60","62.5"] | ["0.1897","0.1549","0.1846","0.2034"] | [] | ["ARCO","EMLD","XMIO","XPHO"] | 52.5000 | 62.5000 | 29 | 491 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:42:26Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |