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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0aff6-e533-7481-8d75-a1cd03c1f237 | SOFI | 2026-09-17 11:23 | put_calendar | 2 | 1 | 200 | 430800.00 | unknown | — | 16.8072 | 0.4000 | ["27"] | ["0.6583"] | [] | ["XCBO"] | 27.0000 | 27.0000 | 120 | 491 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:23:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab63-3be3-7292-92c5-3e2d28a803e6 | SOFI | 2026-09-16 14:03 | put_vertical_spread | 2 | 1 | 400 | 345600.00 | long | ask | 16.8450 | 0.4300 | ["17","22"] | ["0.5686","0.5974"] | ["18.50"] | ["XCBO"] | 17.0000 | 22.0000 | 184 | 184 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:03:24Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a174-ad50-7ea2-aab4-9088fc061036 | SOFI | 2026-09-14 15:46 | call_diagonal_spread | 2 | 1 | 500 | 201500.00 | long | bid | 17.6700 | 0.1000 | ["32","40"] | ["0.6103","0.6191"] | [] | ["XMIO"] | 32.0000 | 40.0000 | 494 | 641 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:46:46Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a059-e2c8-7731-b1a7-6b1be73f34d4 | SOFI | 2026-09-14 10:37 | call_calendar | 2 | 1 | 160 | 196160.00 | short | bid | 17.3500 | 0.4000 | ["18"] | ["0.6194"] | [] | ["XMIO"] | 18.0000 | 18.0000 | 641 | 823 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:37:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08b88-7e91-7110-8b7a-fe685afd75af | SOFI | 2026-09-10 09:36 | other | 4 | 1 | 250 | 192500.00 | unknown | — | 17.0862 | 0.3000 | ["16.5","18","20"] | ["0.7190","0.7380","0.5743"] | [] | ["XMIO"] | 16.5000 | 20.0000 | 1 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:36:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b87-ea20-73a0-8c1c-d95b7853ddde | SOFI | 2026-09-10 09:35 | other | 4 | 1 | 250 | 193500.00 | unknown | — | 17.0100 | 0.2900 | ["16.5","18","20"] | ["0.6608","0.6850","0.5598"] | [] | ["XCBO"] | 16.5000 | 20.0000 | 1 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:35:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087bf-5900-7553-830f-a680f2004bb4 | SOFI | 2026-09-09 15:57 | call_vertical_spread | 2 | 1 | 300 | 219600.00 | unknown | — | 17.3550 | 0.2000 | ["20","25"] | ["0.6019","0.6050"] | [] | ["XCBO"] | 20.0000 | 25.0000 | 499 | 499 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:57:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08207-5008-7dd0-9ade-afd6b2640ec2 | SOFI | 2026-09-08 13:18 | put_calendar | 2 | 1 | 201 | 197181.00 | unknown | — | 18.1250 | 0.2500 | ["23"] | ["0.5754"] | [] | ["XCBO"] | 23.0000 | 23.0000 | 24 | 31 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:18:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08147-bd10-7813-bea5-8f01c31c3f84 | SOFI | 2026-09-08 09:49 | put_calendar | 2 | 1 | 400 | 187600.00 | long | ask | 18.2150 | 0.3300 | ["15"] | ["0.5816"] | [] | ["XMIO"] | 15.0000 | 15.0000 | 374 | 465 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:49:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d93-bfbe-7193-bcca-a88e1ba0a263 | SOFI | 2026-09-04 13:59 | call_calendar | 2 | 1 | 1470 | 124950.00 | short | bid | 18.1850 | 0.0300 | ["18.5"] | ["0.7551"] | [] | ["XISX"] | 18.5000 | 18.5000 | 0 | 28 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:00:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d52-3e35-7ca0-9fd5-960c0b031d8a | SOFI | 2026-09-04 12:48 | put_calendar | 2 | 1 | 400 | 123200.00 | short | bid | 18.1950 | 0.0900 | ["15"] | ["0.5715"] | [] | ["XMIO"] | 15.0000 | 15.0000 | 133 | 378 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:48:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |