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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b610-95e7-7003-a0d4-e6f85e25fede | ORCL | 2026-09-18 15:48 | straddle | 2 | 1 | 300 | 756000.00 | short | bid | 148.4700 | 0.2500 | ["150"] | ["0.5121"] | ["124.80","175.20"] | ["XBOX"] | 150.0000 | 150.0000 | 63 | 63 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59b-237f-71a0-9c4d-7c2d74425f87 | ORCL | 2026-09-18 13:40 | synthetic | 2 | 2 | 876 | 116508.00 | short | bid | 146.1100 | 0.0500 | ["145"] | ["0.4902"] | ["146.01"] | ["AMXO"] | 145.0000 | 145.0000 | 0 | 0 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:40:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab8b-8c33-73b0-80af-ebd29149b6ed | ORCL | 2026-09-16 14:47 | synthetic | 2 | 1 | 75 | 639750.00 | short | bid | 144.2050 | 3.0000 | ["140"] | ["0.5650"] | ["152.40"] | ["XBOX"] | 140.0000 | 140.0000 | 730 | 730 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:47:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1b-51bb-78b3-8e9a-0bbcb61bb9ac | ORCL | 2026-09-16 12:44 | synthetic | 2 | 1 | 100 | 717000.00 | short | bid | 143.9250 | 1.0500 | ["145"] | ["0.5605"] | ["150.20"] | ["XBOX"] | 145.0000 | 145.0000 | 492 | 492 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:44:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a555-ea0e-7591-9376-b84ff66eeea1 | ORCL | 2026-09-15 09:51 | call_vertical_spread | 2 | 1 | 199 | 115818.00 | short | bid | 141.1800 | 0.2300 | ["141","143"] | ["0.6363","0.6366"] | ["141.90"] | ["SPHR"] | 141.0000 | 143.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:51:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0a5-f758-7293-b697-f9036df4a96f | ORCL | 2026-09-14 12:00 | straddle | 2 | 1 | 150 | 879000.00 | short | bid | 143.5455 | 1.5000 | ["160"] | ["0.5623"] | ["101.40","218.60"] | ["SPHR"] | 160.0000 | 160.0000 | 276 | 276 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:00:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02b-8799-7473-a629-1bae4e2f2cde | ORCL | 2026-09-14 09:46 | call_vertical_spread | 2 | 1 | 100 | 285300.00 | short | bid | 142.5550 | 0.8500 | ["140","160"] | ["0.5588","0.5650"] | ["147.55"] | ["SPHR"] | 140.0000 | 160.0000 | 95 | 95 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:46:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091a0-cc11-7df3-bc3d-af3b3ac81e01 | ORCL | 2026-09-11 14:00 | call_calendar | 2 | 1 | 50 | 98700.00 | short | bid | 152.2450 | 1.0500 | ["143"] | ["1.5286"] | [] | ["SPHR"] | 143.0000 | 143.0000 | 0 | 7 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:00:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c88-3768-75e1-88ca-444d70ccf995 | ORCL | 2026-09-10 14:15 | call_diagonal_spread | 2 | 1 | 65 | 238875.00 | short | bid | 155.5500 | 0.6000 | ["140","141"] | ["2.6329","1.0886"] | [] | ["SPHR"] | 140.0000 | 141.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:16:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c75-ad50-7e51-9df2-3876282e82fb | ORCL | 2026-09-10 13:55 | strangle | 2 | 1 | 300 | 708000.00 | short | bid | 155.8300 | 0.5600 | ["175","250"] | ["1.1804","1.4117"] | ["151.40","273.60"] | ["SPHR"] | 175.0000 | 250.0000 | 8 | 8 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:55:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087b6-f490-7071-b136-49abb753f0ca | ORCL | 2026-09-09 15:48 | risk_reversal | 2 | 1 | 200 | 950000.00 | short | ask | 161.8500 | 0.7500 | ["175","180"] | ["0.6193","0.6127"] | ["162.10"] | ["XPHO"] | 175.0000 | 180.0000 | 128 | 128 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:48:40Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |