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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c57d-bf5f-7592-86b7-8a6afdbc928b | TSM | 2026-09-21 15:42 | other | 2 | 1 | 500 | 2738000.00 | unknown | bid | 444.8800 | 1.1000 | ["440","480"] | ["0.3353","0.3615"] | [] | ["ARCO"] | 440.0000 | 480.0000 | 39 | 207 | true | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:42:46Z"} | 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 |
| 01a0b597-1c3f-7943-be26-a2787ba3c987 | TSM | 2026-09-18 13:36 | put_ratio_spread | 2 | 1 | 540 | 422550.00 | unknown | bid | 430.3300 | 0.7000 | ["380","430"] | ["0.3513","0.3243"] | ["351.70","419.62"] | ["XBOX"] | 380.0000 | 430.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:36:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b596-02ff-7ae3-8d6d-f88d0a024d68 | TSM | 2026-09-18 13:34 | put_ratio_spread | 2 | 1 | 540 | 766800.00 | unknown | bid | 430.1250 | 0.7000 | ["400","430"] | ["0.3337","0.3232"] | ["355.90","422.05"] | ["XBOX"] | 400.0000 | 430.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:35:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b593-bcf7-7463-99a8-4d8e82186b9d | TSM | 2026-09-18 13:32 | put_calendar | 2 | 1 | 270 | 645975.00 | unknown | ask | 430.3650 | 0.9500 | ["430"] | ["0.3088"] | [] | ["XBOX"] | 430.0000 | 430.0000 | 14 | 28 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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 |
| 01a0b0ed-dfc3-7a12-8f68-b19ca90d4748 | TSM | 2026-09-17 15:52 | put_vertical_spread | 2 | 2 | 900 | 831600.00 | unknown | — | 428.8625 | 0.6200 | ["410","430"] | ["0.3056","0.2884"] | [] | ["AMXO"] | 410.0000 | 430.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:53:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c0-0963-74e1-a5b2-3e2195e3b0a4 | TSM | 2026-09-17 15:02 | put_vertical_spread | 2 | 1 | 52 | 275600.00 | unknown | — | 429.4800 | 4.4000 | ["450","460"] | ["0.7572","0.9980"] | [] | ["XBOX"] | 450.0000 | 460.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:03:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcd-be0b-7a31-ac6d-f195f36295d8 | TSM | 2026-09-17 10:38 | other | 4 | 1 | 350 | 249200.00 | unknown | — | 425.0000 | 0.2900 | ["432.5","437.5","440","447.5"] | ["0.2955","0.3767","0.2959","0.3690"] | [] | ["XBOX"] | 432.5000 | 447.5000 | 1 | 8 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:38:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a67b-5b26-7692-b98e-d344780658a3 | TSM | 2026-09-15 15:11 | call_ladder | 6 | 1 | 10 | 1088880.00 | unknown | — | 414.7200 | 17.0000 | ["110","130","135","155","160","175"] | ["6.9789","6.1852","5.8305","5.0396","4.8861","4.6835"] | [] | ["XPHO"] | 110.0000 | 175.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:12:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-cece-7740-91e5-09264ee21cb2 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 80 | 13346880.00 | unknown | — | 414.6000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.6637","4.5163","4.3239","3.9516","3.8140","3.5778","3.4370","3.1629"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-693e-70b1-bb97-11472842b502 | TSM | 2026-09-15 15:08 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.4600 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7921","4.6248","4.4078","4.0530","3.9009","3.6603","3.5087","3.2347"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a677-6f3e-7781-991f-475f55128ee9 | TSM | 2026-09-15 15:07 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5500 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7113","4.5563","4.3546","3.9891","3.8459","3.6081","3.4632","3.1892"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a676-dace-7453-b59f-15c68ac28801 | TSM | 2026-09-15 15:06 | call_ladder | 8 | 1 | 60 | 10010160.00 | unknown | — | 414.5000 | 23.0000 | ["170","180","195","200","210","220","230","240"] | ["4.7570","4.5949","4.3845","4.0251","3.8768","3.6374","3.4887","3.2148"] | [] | ["XPHO"] | 170.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:07:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f1-eb8e-7723-bdb3-aca076f37e6c | TSM | 2026-09-15 12:41 | call_vertical_spread | 2 | 2 | 125 | 280000.00 | unknown | — | 413.1550 | 0.4500 | ["420","430"] | ["0.3238","0.3233"] | [] | ["AMXO"] | 420.0000 | 430.0000 | 31 | 31 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:41:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a4-776d-7a83-8dfa-aee520974b2b | TSM | 2026-09-15 11:16 | put_calendar | 2 | 1 | 390 | 190840.00 | unknown | — | 413.8950 | 0.3400 | ["400"] | ["0.3642"] | [] | ["SPHR"] | 400.0000 | 400.0000 | 3 | 17 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:17:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a152-5840-7e01-9b28-034c5047f238 | TSM | 2026-09-14 15:08 | other | 2 | 1 | 1000 | 688500.00 | unknown | — | 423.3401 | 0.7500 | ["400","420"] | ["0.4069","0.3284"] | [] | ["ARCO"] | 400.0000 | 420.0000 | 4 | 25 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:08:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a129-e0e0-7023-84ab-0ae3d1e6e5e5 | TSM | 2026-09-14 14:24 | other | 2 | 1 | 320 | 305600.00 | unknown | — | 422.4700 | 0.6000 | ["420"] | ["0.3643"] | [] | ["XBOX"] | 420.0000 | 420.0000 | 4 | 11 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:24:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0919c-9208-7ac1-b6f1-1d8f38d63ee2 | TSM | 2026-09-11 13:55 | other | 5 | 2 | 330 | 417000.00 | unknown | — | 432.9800 | 1.4000 | ["320","540","560","570","580"] | ["0.3911","0.3734","0.3759","0.3771","0.3779"] | [] | ["AMXO"] | 320.0000 | 580.0000 | 189 | 189 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:56:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0915c-4518-7cc0-a170-241cccc251ba | TSM | 2026-09-11 12:45 | other | 3 | 1 | 128 | 368640.00 | unknown | — | 433.1500 | 2.3100 | ["380","440","450"] | ["0.3779","0.5718","0.3336"] | [] | ["SPHR"] | 380.0000 | 450.0000 | 0 | 14 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:46:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09138-f220-7351-96e1-64810061bef6 | TSM | 2026-09-11 12:07 | other | 3 | 1 | 100 | 232000.00 | unknown | — | 435.0150 | 0.8600 | ["380","437.5","450"] | ["0.3845","0.3484","0.3282"] | [] | ["SPHR"] | 380.0000 | 450.0000 | 0 | 14 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:07:03Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0912b-4df0-7e43-bb01-fc2e15c4c141 | TSM | 2026-09-11 11:52 | call_vertical_spread | 2 | 1 | 69 | 207000.00 | unknown | — | 434.7700 | 1.8500 | ["415","425"] | ["1.2720","0.7230"] | [] | ["ARCO"] | 415.0000 | 425.0000 | 0 | 0 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:52:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b8f-50a8-7e51-ab67-78dd239cbec1 | TSM | 2026-09-10 09:43 | other | 2 | 1 | 25 | 372000.00 | unknown | — | 427.1050 | 3.7500 | ["380"] | ["0.3835"] | [] | ["AMXO"] | 380.0000 | 380.0000 | 162 | 190 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:43:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877d-4ec1-7fb2-b9be-2b5d777cf32f | TSM | 2026-09-09 14:45 | put_vertical_spread | 2 | 1 | 900 | 1359000.00 | unknown | — | 433.6750 | 0.4500 | ["400","430"] | ["0.3381","0.3307"] | [] | ["XBOX"] | 400.0000 | 430.0000 | 23 | 23 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:45:36Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f8-9248-7293-9a67-36641f25f8e1 | TSM | 2026-09-09 12:20 | other | 2 | 1 | 1800 | 1290600.00 | unknown | — | 433.7500 | 0.5200 | ["400","430"] | ["0.3571","0.3392"] | [] | ["XBOX"] | 400.0000 | 430.0000 | 16 | 16 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:21:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086e2-dbb1-72f3-ac51-d8690c92c317 | TSM | 2026-09-09 11:56 | other | 2 | 1 | 1200 | 1075200.00 | unknown | — | 435.0850 | 0.8000 | ["340","410"] | ["0.4041","0.3795"] | [] | ["XBOX"] | 340.0000 | 410.0000 | 72 | 72 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:56:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081bc-8f50-76f0-8a69-eb50f7c52612 | TSM | 2026-09-08 11:56 | other | 2 | 1 | 750 | 6262500.00 | unknown | — | 441.4200 | 1.1000 | ["450","500"] | ["0.3842","0.3938"] | [] | ["AMXO"] | 450.0000 | 500.0000 | 129 | 282 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:56:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08185-6638-7f72-8b04-e0702a24bb67 | TSM | 2026-09-08 10:56 | other | 2 | 1 | 125 | 628800.00 | unknown | — | 435.5600 | 2.9500 | ["400","430"] | ["0.3814","0.4230"] | [] | ["XBOX"] | 400.0000 | 430.0000 | 129 | 647 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:57:00Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d62-14e5-7271-8cb8-d15579a6938c | TSM | 2026-09-04 13:05 | other | 2 | 1 | 250 | 1557000.00 | unknown | — | 427.7299 | 3.0000 | ["430"] | ["0.3779"] | [] | ["AMXO"] | 430.0000 | 430.0000 | 133 | 286 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:05:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |