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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a081ce-84f8-71c1-ba76-94269f759490 | TSM | 2026-09-08 12:16 | put_diagonal_spread | 2 | 1 | 100 | 482500.00 | long | bid | 439.8200 | 1.1000 | ["430","445"] | ["0.3850","0.3738"] | [] | ["C2OX"] | 430.0000 | 445.0000 | 45 | 73 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:16:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ff-8fa8-7673-9246-8c452efedbaa | TSM | 2026-09-08 13:10 | put_diagonal_spread | 2 | 1 | 52 | 165620.00 | long | bid | 440.6700 | 0.8500 | ["430","440"] | ["0.3720","0.3469"] | [] | ["EDGO"] | 430.0000 | 440.0000 | 31 | 38 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:10:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a09116-6278-7fd2-9885-bb389415a852 | TSM | 2026-09-11 11:29 | put_diagonal_spread | 2 | 1 | 150 | 471750.00 | short | bid | 434.4000 | 0.9000 | ["410","420"] | ["0.3502","0.3645"] | [] | ["XMIO"] | 410.0000 | 420.0000 | 35 | 98 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:29:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a606-7176-7c10-9999-d786cb43d6a2 | TSM | 2026-09-15 13:03 | put_diagonal_spread | 2 | 3 | 118 | 235988.00 | long | ask | 413.1200 | 1.0017 | ["412.5","415"] | ["0.3176","0.3171"] | [] | ["C2OX","XMIO","XPHO"] | 412.5000 | 415.0000 | 10 | 17 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:04:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0af8f-ce96-7da3-bd4d-5391b1bcef2d | TSM | 2026-09-17 09:30 | put_diagonal_spread | 2 | 1 | 100 | 213000.00 | short | ask | 424.9800 | 6.0000 | ["430","435"] | ["0.2890","0.5507"] | [] | ["C2OX"] | 430.0000 | 435.0000 | 1 | 8 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:27Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0b58b-ba30-7bb0-be91-4bffc85114d5 | TSM | 2026-09-18 13:23 | put_diagonal_spread | 2 | 2 | 900 | 610200.00 | unknown | bid | 430.0900 | 0.4600 | ["410","430"] | ["0.3042","0.2898"] | [] | ["ARCO"] | 410.0000 | 430.0000 | 7 | 21 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:24:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c430-57cf-7ab2-b33c-ce4c11962d0e | TSM | 2026-09-21 09:38 | put_diagonal_spread | 2 | 1 | 60 | 405960.00 | long | bid | 438.9500 | 4.9000 | ["420","430"] | ["0.3649","0.3576"] | [] | ["XPHO"] | 420.0000 | 430.0000 | 179 | 207 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:38:26Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43c-949f-72c3-82bd-4614a64b4c86 | TSM | 2026-09-21 09:51 | put_diagonal_spread | 2 | 1 | 50 | 116000.00 | unknown | ask | 438.9000 | 1.2000 | ["410","420"] | ["0.3459","0.3411"] | [] | ["AMXO"] | 410.0000 | 420.0000 | 25 | 88 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:51:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c44b-e296-7eb3-9677-f8c5aa6a0b05 | TSM | 2026-09-21 10:08 | put_diagonal_spread | 2 | 2 | 195 | 427440.00 | short | bid | 437.9500 | 0.6500 | ["430","437.5"] | ["0.3337","0.2992"] | [] | ["XMIO"] | 430.0000 | 437.5000 | 18 | 25 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:08:35Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c479-e006-71b1-b2f8-7f041c0169e7 | TSM | 2026-09-21 10:58 | put_diagonal_spread | 2 | 1 | 75 | 158250.00 | long | bid | 440.1900 | 0.6000 | ["430","440"] | ["0.3312","0.2978"] | [] | ["XMIO"] | 430.0000 | 440.0000 | 18 | 25 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:58:52Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e5-9a27-7430-8ec0-15acf7be44f3 | TSM | 2026-09-21 12:56 | put_diagonal_spread | 2 | 1 | 14 | 140700.00 | short | bid | 442.3450 | 1.3500 | ["450","500"] | ["0.3440","0.3644"] | [] | ["XISX"] | 450.0000 | 500.0000 | 88 | 116 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:56:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e6-980f-7cf3-af13-ea5b7040871a | TSM | 2026-09-21 12:57 | put_diagonal_spread | 2 | 1 | 85 | 853315.00 | long | ask | 442.3300 | 0.9000 | ["450","500"] | ["0.3439","0.3631"] | [] | ["XISX"] | 450.0000 | 500.0000 | 88 | 116 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:57:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c53c-c2a7-7ec2-a897-4377d65bee6d | TSM | 2026-09-21 14:31 | put_diagonal_spread | 2 | 1 | 5 | 148020.00 | long | ask | 442.9600 | 3.1000 | ["560","570"] | ["0.4093","0.4456"] | [] | ["XMIO"] | 560.0000 | 570.0000 | 361 | 816 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:31:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c53c-d246-7260-9115-9fbae64d2bb3 | TSM | 2026-09-21 14:31 | put_diagonal_spread | 2 | 1 | 5 | 148025.00 | short | bid | 442.9400 | 3.0500 | ["560","570"] | ["0.4096","0.4454"] | [] | ["XPHO"] | 560.0000 | 570.0000 | 361 | 816 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:31:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c546-24ff-7c41-9cc8-861f0674c245 | TSM | 2026-09-21 14:41 | put_diagonal_spread | 2 | 1 | 3 | 107523.00 | short | ask | 443.2650 | 2.4000 | ["580","620"] | ["0.4518","0.4527"] | [] | ["XMIO"] | 580.0000 | 620.0000 | 452 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:42:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c546-28e7-7f32-8add-055be6a37782 | TSM | 2026-09-21 14:41 | put_diagonal_spread | 2 | 1 | 3 | 104988.00 | unknown | ask | 443.2650 | 2.3000 | ["580","610"] | ["0.4517","0.4472"] | [] | ["XMIO"] | 580.0000 | 610.0000 | 452 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:42:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c546-53df-7f81-99e1-edd08aef8f36 | TSM | 2026-09-21 14:41 | put_diagonal_spread | 2 | 1 | 3 | 107499.00 | short | ask | 443.3000 | 2.8000 | ["580","620"] | ["0.4518","0.4525"] | [] | ["XPHO"] | 580.0000 | 620.0000 | 452 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:42:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c546-6b4f-7733-ad0e-dbc477e33aa5 | TSM | 2026-09-21 14:41 | put_diagonal_spread | 2 | 1 | 3 | 104970.00 | short | ask | 443.2800 | 2.8500 | ["580","610"] | ["0.4517","0.4470"] | [] | ["XPHO"] | 580.0000 | 610.0000 | 452 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:42:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |