Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-7d0f-78a3-b543-3e54ac933e5b | NDX | 2026-09-18 15:59 | put_diagonal_spread | 2 | 1 | 10 | 38500.00 | long | ask | 0.0000 | 6.6500 | ["28750","29590"] | ["0.1780",null] | [] | ["XISX"] | 28750.0000 | 29590.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b617-9ac8-7221-b063-109f75ac0181 | NDX | 2026-09-18 15:56 | put_diagonal_spread | 2 | 1 | 5 | 38460.00 | unknown | ask | 0.0000 | 8.9000 | ["29550","29590"] | ["0.0917",null] | [] | ["XISX"] | 29550.0000 | 29590.0000 | 0 | 3 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:56:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60f-f1d8-7960-97d8-8cb9dc5db6f9 | NDX | 2026-09-18 15:48 | put_diagonal_spread | 2 | 1 | 4 | 33212.00 | unknown | ask | 0.0000 | 7.5000 | ["29520","29540"] | ["0.0938",null] | [] | ["XISX"] | 29520.0000 | 29540.0000 | 0 | 3 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-386f-7a71-a016-1ef35b0b4284 | NDX | 2026-09-18 15:46 | put_diagonal_spread | 2 | 1 | 6 | 167940.00 | long | ask | 0.0000 | 14.2000 | ["29000","29100"] | ["0.1512","0.1691"] | [] | ["XPHO"] | 29000.0000 | 29100.0000 | 10 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ec-4507-7431-97ed-864acf83fd72 | NDX | 2026-09-18 15:09 | put_diagonal_spread | 2 | 1 | 4 | 37480.00 | long | ask | 0.0000 | 3.9000 | ["29490","29520"] | ["0.1564","0.0932"] | [] | ["XPHO"] | 29490.0000 | 29520.0000 | 0 | 3 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:09:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a7-aa88-7a60-8f55-5e88a36b3dad | NDX | 2026-09-18 13:54 | put_diagonal_spread | 2 | 2 | 2 | 143002.00 | long | ask | 0.0000 | 22.8000 | ["26400","27600"] | ["0.2601","0.2309"] | [] | ["XISX","XPHO"] | 26400.0000 | 27600.0000 | 63 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:54:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b520-32d7-7a50-849e-381f9311c271 | NDX | 2026-09-18 11:26 | put_diagonal_spread | 2 | 1 | 2 | 214988.00 | short | ask | 0.0000 | 142.1000 | ["29990","30000"] | ["0.0972","0.2977"] | [] | ["XISX"] | 29990.0000 | 30000.0000 | 0 | 3 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:26:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b04c-b20b-77d0-b7b9-339c146409f3 | NDX | 2026-09-17 12:56 | put_diagonal_spread | 2 | 1 | 2 | 239582.00 | short | ask | 0.0000 | 136.0000 | ["30000","30040"] | ["0.1614","0.3327"] | [] | ["XISX"] | 30000.0000 | 30040.0000 | 0 | 1 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:57:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbb-eeeb-7c50-9429-3c206162e349 | NDX | 2026-09-16 15:40 | put_diagonal_spread | 2 | 1 | 3 | 128733.00 | short | ask | 0.0000 | 31.2000 | ["29010","29100"] | ["0.2304","0.4903"] | [] | ["XISX"] | 29010.0000 | 29100.0000 | 0 | 1 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa4-358b-7d72-a2d9-4747c14ed818 | NDX | 2026-09-16 10:34 | put_diagonal_spread | 2 | 1 | 36 | 4169520.00 | short | ask | 0.0000 | 33.8000 | ["27500","29500"] | ["0.2384","0.1736"] | [] | ["XPHO"] | 27500.0000 | 29500.0000 | 30 | 65 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:34:53Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a1-d2ce-7920-9953-ff3ca5768a17 | NDX | 2026-09-15 15:53 | put_diagonal_spread | 2 | 2 | 2 | 25230.00 | long | ask | 0.0000 | 17.4000 | ["27200","27650"] | ["0.2621","0.2579"] | [] | ["XISX","XPHO"] | 27200.0000 | 27650.0000 | 7 | 14 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:53:56Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a17a-eaf9-7eb0-a851-4e6ad80de604 | NDX | 2026-09-14 15:53 | put_diagonal_spread | 2 | 1 | 3 | 34413.00 | long | ask | 0.0000 | 28.8000 | ["28825","29050"] | ["0.2185","0.1730"] | [] | ["XPHO"] | 28825.0000 | 29050.0000 | 1 | 2 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:53:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a099-0ea8-79a1-90c5-609cd86fc1fd | NDX | 2026-09-14 11:46 | put_diagonal_spread | 2 | 1 | 2 | 219014.00 | long | ask | 0.0000 | 127.6000 | ["29710","29720"] | ["0.1697","0.3457"] | [] | ["XPHO"] | 29710.0000 | 29720.0000 | 0 | 2 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:46:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ed-cb00-71f3-8f17-ca102d57b2f1 | NDX | 2026-09-11 15:24 | put_diagonal_spread | 2 | 1 | 5 | 213570.00 | long | ask | 0.0000 | 18.9000 | ["29000","29100"] | ["0.1723","0.1641"] | [] | ["XISX"] | 29000.0000 | 29100.0000 | 10 | 17 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:24:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce1-4c19-7f93-ad82-b5cdd5fc74de | NDX | 2026-09-10 15:52 | put_diagonal_spread | 2 | 2 | 4 | 77600.00 | long | ask | 0.0000 | 32.1000 | ["26500","27200"] | ["0.2844","0.2818"] | [] | ["XISX","XPHO"] | 26500.0000 | 27200.0000 | 14 | 28 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:52:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086d3-66a9-72f1-8c95-36b8914fb14c | NDX | 2026-09-09 11:39 | put_diagonal_spread | 2 | 1 | 4 | 307464.00 | short | ask | 0.0000 | 48.2000 | ["29450","29600"] | ["0.1912","0.1802"] | [] | ["XPHO"] | 29450.0000 | 29600.0000 | 7 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:39:59Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0829a-29c8-7891-b688-5732e956d857 | NDX | 2026-09-08 15:58 | put_diagonal_spread | 2 | 2 | 4 | 70394.00 | long | ask | 0.0000 | 32.4000 | ["27200","27850"] | ["0.2495","0.2384"] | [] | ["XISX","XPHO"] | 27200.0000 | 27850.0000 | 14 | 28 | true | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:59:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |