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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dde-49c5-7833-981d-c56c59535188 | SNXX | 2026-09-04 15:21 | other | 2 | 1 | 144 | 112320.00 | unknown | — | 16.8820 | 0.7000 | ["30","32"] | ["1.5548","1.5528"] | [] | ["XISX"] | 30.0000 | 32.0000 | 133 | 196 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:21:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08138-7eb8-7c70-834b-51492849c606 | SNXX | 2026-09-08 09:32 | call_diagonal_spread | 2 | 1 | 454 | 134384.00 | long | bid | 17.8450 | 1.3500 | ["21","25"] | ["1.6870","1.6561"] | [] | ["C2OX"] | 21.0000 | 25.0000 | 17 | 31 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:32:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ae-81a8-7bb0-9728-a40da3512f6f | SNXX | 2026-09-08 11:41 | other | 2 | 1 | 1000 | 280000.00 | unknown | — | 18.4508 | 0.2500 | ["22","26"] | ["1.6099","1.6337"] | [] | ["MCRY"] | 22.0000 | 26.0000 | 17 | 31 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:41:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b9-8dc8-7ef0-87a0-41df40475f66 | SNXX | 2026-09-08 11:53 | call_diagonal_spread | 2 | 5 | 319 | 130471.00 | short | ask | 18.5815 | 0.3138 | ["21","25"] | ["1.6035","1.5906"] | [] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 21.0000 | 25.0000 | 24 | 38 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:53:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081dc-7b30-7100-abc8-23962174aca7 | SNXX | 2026-09-08 12:31 | call_vertical_spread | 2 | 1 | 200 | 200000.00 | long | ask | 18.4901 | 0.8000 | ["20","25"] | ["1.6098","1.6084"] | ["21.30"] | ["XMIO"] | 20.0000 | 25.0000 | 101 | 101 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08285-4a08-7ad2-92aa-f6d4778a2a46 | SNXX | 2026-09-08 15:36 | call_diagonal_spread | 2 | 1 | 439 | 202379.00 | short | bid | 17.8350 | 0.3000 | ["16","19"] | ["1.6635","1.5763"] | [] | ["XISX"] | 16.0000 | 19.0000 | 3 | 24 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:36:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0b00b-a5b2-7e50-ba7f-b7f051522d4c | SNXX | 2026-09-17 11:45 | call_diagonal_spread | 2 | 1 | 1000 | 178000.00 | unknown | — | 14.5900 | 0.1500 | ["17.5","25"] | ["2.0271","1.4232"] | [] | ["XISX"] | 17.5000 | 25.0000 | 1 | 92 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:46:14Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5a5-7fd8-74a0-bd56-e1eff7676899 | SNXX | 2026-09-18 13:51 | call_diagonal_spread | 2 | 1 | 200 | 119000.00 | long | bid | 17.1050 | 0.3500 | ["20","25"] | ["1.4648","1.4422"] | [] | ["C2OX"] | 20.0000 | 25.0000 | 63 | 91 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a5-7bef-7cb1-84dc-7676fbfd46cb | SNXX | 2026-09-18 13:51 | call_diagonal_spread | 2 | 1 | 200 | 119000.00 | long | bid | 17.1050 | 0.3500 | ["20","25"] | ["1.4648","1.4422"] | [] | ["C2OX"] | 20.0000 | 25.0000 | 63 | 91 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a5-7bef-7cb1-84dc-766162e636ab | SNXX | 2026-09-18 13:51 | call_diagonal_spread | 2 | 1 | 200 | 119041.00 | long | bid | 17.1050 | 0.3500 | ["20","25"] | ["1.4659","1.4418"] | [] | ["C2OX"] | 20.0000 | 25.0000 | 63 | 91 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a5-7bef-7cb1-84dc-76544ecd8fe7 | SNXX | 2026-09-18 13:51 | call_diagonal_spread | 2 | 1 | 200 | 119000.00 | long | bid | 17.1050 | 0.3500 | ["20","25"] | ["1.4648","1.4422"] | [] | ["XPHO"] | 20.0000 | 25.0000 | 63 | 91 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c42f-deb7-7691-ab7a-5392ae2ffebb | SNXX | 2026-09-21 09:37 | call_diagonal_spread | 2 | 1 | 150 | 238350.00 | unknown | ask | 18.2950 | 1.4000 | ["3","20"] | ["1.9666","1.6232"] | [] | ["XISX"] | 3.0000 | 20.0000 | 4 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:37:45Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c54d-f8e7-7643-abf4-6c11dda4ed1a | SNXX | 2026-09-21 14:50 | call_diagonal_spread | 2 | 1 | 120 | 162120.00 | short | bid | 17.3399 | 1.0000 | ["17.5","27"] | ["1.3759","1.3386"] | [] | ["XISX"] | 17.5000 | 27.0000 | 116 | 487 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:50:29Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c58b-82cf-7220-b02a-26fdf4cfce8a | SNXX | 2026-09-21 15:57 | call_diagonal_spread | 2 | 1 | 350 | 548800.00 | unknown | bid | 17.5850 | 1.0000 | ["15","27"] | ["1.3318","1.3269"] | [] | ["XISX"] | 15.0000 | 27.0000 | 179 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:57:35Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c58c-4def-7c33-a8f0-01f2e5fef59e | SNXX | 2026-09-21 15:58 | call_vertical_spread | 2 | 1 | 220 | 248600.00 | short | bid | 17.5850 | 0.9000 | ["18","25"] | ["1.3661","1.3966"] | ["19.60"] | ["XISX"] | 18.0000 | 25.0000 | 179 | 179 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:58:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |