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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56e-3ab6-7da3-bc4d-a9c3e3e9f234 | SPCX | 2026-09-21 15:25 | put_vertical_spread | 2 | 1 | 912 | 1400832.00 | short | bid | 152.2150 | 0.2000 | ["145","157.5"] | ["0.5025","0.5047"] | ["151.26"] | ["SPHR"] | 145.0000 | 157.5000 | 25 | 25 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:25:31Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b611-5d20-7ed0-b8f5-3df92239f876 | SPCX | 2026-09-18 15:49 | put_vertical_spread | 2 | 1 | 80 | 78400.00 | long | ask | 153.2095 | 0.0600 | ["145","160"] | ["0.4973","0.5193"] | ["152.62"] | ["SPHR"] | 145.0000 | 160.0000 | 7 | 7 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:49:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0bd-32d3-71b0-9185-2d74b39545c3 | SPCX | 2026-09-17 14:59 | put_vertical_spread | 2 | 1 | 4445 | 146685.00 | unknown | — | 154.6000 | 0.0200 | ["136","148"] | ["1.1092","0.6836"] | [] | ["XBOX"] | 136.0000 | 148.0000 | 1 | 1 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:00:08Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-f243-71c3-9565-f913362b20e1 | SPCX | 2026-09-17 14:29 | put_vertical_spread | 2 | 1 | 15000 | 139650000.00 | unknown | — | 154.8450 | 4.2500 | ["200","205"] | ["3.4842","3.4816"] | [] | ["XBOX"] | 200.0000 | 205.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:30:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b08c-c463-7852-b90e-e32c1047e3c6 | SPCX | 2026-09-17 14:06 | put_vertical_spread | 2 | 1 | 3500 | 33264000.00 | long | ask | 154.7900 | 4.3000 | ["200","205"] | ["3.4473","3.4358"] | ["0","200"] | ["XPHO"] | 200.0000 | 205.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:07:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc6-dc53-7dc2-a2c5-7ddb8c98b593 | SPCX | 2026-09-17 10:30 | put_vertical_spread | 2 | 1 | 100 | 251800.00 | unknown | — | 154.8800 | 0.9500 | ["157.5","160"] | ["0.5135","0.5106"] | [] | ["XBOX"] | 157.5000 | 160.0000 | 43 | 43 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:30:44Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a68a-b0ee-7bf3-a17d-801acefc566f | SPCX | 2026-09-15 15:28 | put_vertical_spread | 2 | 1 | 15000 | 177600000.00 | unknown | — | 143.8505 | 2.5000 | ["200","205"] | ["2.1459","2.2707"] | [] | ["XBOX"] | 200.0000 | 205.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:28:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a64b-f656-7ea3-a4fb-ef06bdb75b06 | SPCX | 2026-09-15 14:19 | put_vertical_spread | 2 | 1 | 2000 | 29392000.00 | unknown | — | 144.1800 | 5.2500 | ["205","230"] | ["1.8993","2.4096"] | [] | ["XPHO"] | 205.0000 | 230.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:20:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a158-9db8-7c52-82c7-e0af9220611d | SPCX | 2026-09-14 15:15 | put_vertical_spread | 2 | 1 | 1200 | 16000800.00 | unknown | — | 150.1600 | 4.7000 | ["205","230"] | ["1.7546","2.2504"] | [] | ["XPHO"] | 205.0000 | 230.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cd8-89e8-78a3-84e2-511b54a30502 | SPCX | 2026-09-10 15:43 | put_vertical_spread | 2 | 1 | 15000 | 165600000.00 | unknown | — | 147.4900 | 4.5500 | ["200","205"] | ["1.1108","1.1849"] | [] | ["XPHO"] | 200.0000 | 205.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:43:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ccc-1280-78d3-aff0-834f99f995a5 | SPCX | 2026-09-10 15:29 | put_vertical_spread | 2 | 1 | 5000 | 54040000.00 | unknown | — | 148.1600 | 6.9000 | ["200","205"] | ["1.4123","1.8350"] | [] | ["XPHO"] | 200.0000 | 205.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:29:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cc7-9610-76f3-8acc-83bfb893d780 | SPCX | 2026-09-10 15:24 | put_vertical_spread | 2 | 1 | 5000 | 54800000.00 | unknown | — | 147.4999 | 7.8500 | ["200","205"] | ["1.5055","1.7136"] | [] | ["XPHO"] | 200.0000 | 205.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:24:53Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08669-df08-7633-b1ef-5d5e820fb1df | SPCX | 2026-09-09 09:44 | put_vertical_spread | 2 | 1 | 900 | 10191600.00 | long | ask | 152.1300 | 3.1000 | ["110","245"] | ["0.5839","0.6311"] | ["156"] | ["XPHO"] | 110.0000 | 245.0000 | 373 | 373 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:44:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08142-bfb8-7311-8dd5-b153e11b3c6e | SPCX | 2026-09-08 09:43 | put_vertical_spread | 2 | 1 | 1500 | 17757000.00 | unknown | — | 145.5800 | 3.2500 | ["110","245"] | ["0.5868","0.6557"] | [] | ["XPHO"] | 110.0000 | 245.0000 | 374 | 374 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df3-73bd-7013-b02f-852d953b658e | SPCX | 2026-09-04 15:44 | put_vertical_spread | 2 | 1 | 33 | 602514.00 | unknown | — | 148.6100 | 4.8000 | ["230","250"] | ["1.0526","1.2365"] | [] | ["XPHO"] | 230.0000 | 250.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:44:39Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |