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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b505-926f-7c83-9180-eae3a24e1dae | ORCL | 2026-09-18 10:57 | synthetic | 2 | 2 | 1050 | 175350.00 | long | ask | 144.9200 | 0.0800 | ["145"] | ["0.6012"] | ["145.05"] | ["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-18T14:57:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abb6-9ba3-7170-b555-42a82ebd602a | ORCL | 2026-09-16 15:34 | strangle | 2 | 1 | 80 | 1572800.00 | long | ask | 142.1401 | 2.0000 | ["180","310"] | ["0.5507","0.7725"] | ["113.40","376.60"] | ["SPHR"] | 180.0000 | 310.0000 | 492 | 492 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a058-7b68-7a81-af78-1a19174f7e7a | ORCL | 2026-09-14 10:35 | call_vertical_spread | 2 | 1 | 2327 | 5340465.00 | long | ask | 143.0250 | 0.9000 | ["170","200"] | ["0.5669","0.5673"] | ["176.35"] | ["ARCO"] | 170.0000 | 200.0000 | 186 | 186 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:36:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09152-0fd0-7a82-aff1-f52db1375caa | ORCL | 2026-09-11 12:34 | call_vertical_spread | 2 | 1 | 50 | 323250.00 | long | ask | 152.0700 | 1.6000 | ["180","300"] | ["0.5622","0.5742"] | ["201.25"] | ["SPHR"] | 180.0000 | 300.0000 | 735 | 735 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:35:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0914c-a519-7693-ae1c-81387128f7fa | ORCL | 2026-09-11 12:28 | straddle | 2 | 1 | 250 | 683250.00 | long | ask | 151.7112 | 1.1000 | ["150"] | ["0.5197"] | ["122.67","177.33"] | ["XPHO"] | 150.0000 | 150.0000 | 70 | 70 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:28:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca4-3f30-7401-9593-b13619ddc3fd | ORCL | 2026-09-10 14:46 | put_butterfly_spread | 3 | 1 | 300 | 243600.00 | long | ask | 155.1050 | 0.3400 | ["130","140","150"] | ["1.0356","1.0704","1.1217"] | ["131.80","148.20"] | ["SPHR"] | 130.0000 | 150.0000 | 8 | 8 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:46:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c78-8f99-71a1-b3cb-fb3114700971 | ORCL | 2026-09-10 13:58 | call_butterfly_spread | 3 | 1 | 300 | 789000.00 | long | ask | 155.7500 | 0.9000 | ["130","155","180"] | ["1.0665","1.1411","1.2064"] | ["139","171"] | ["SPHR"] | 130.0000 | 180.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:59:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c23-c490-7313-b7f2-1fd1f0a8c35d | ORCL | 2026-09-10 12:25 | call_vertical_spread | 2 | 1 | 55 | 298595.00 | long | ask | 155.7800 | 1.8000 | ["135","140"] | ["0.6141","0.6071"] | ["138.33"] | ["SPHR"] | 135.0000 | 140.0000 | 71 | 71 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:26:23Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b99-91a8-77f2-a188-b8483a06a2be | ORCL | 2026-09-10 09:54 | call_butterfly_spread | 3 | 1 | 200 | 114900.00 | long | ask | 155.9650 | 0.2000 | ["165","180","200"] | ["2.9012","2.9477","3.0382"] | ["166.65","193.35"] | ["SPHR"] | 165.0000 | 200.0000 | 1 | 1 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:55:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8d-3d68-7c52-abc3-04a5525ac6be | ORCL | 2026-09-10 09:41 | call_calendar | 2 | 1 | 100 | 349200.00 | long | ask | 158.9600 | 0.9000 | ["160"] | ["0.6673"] | [] | ["SPHR"] | 160.0000 | 160.0000 | 36 | 99 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:41:26Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b85-2331-7091-8b71-405edafb01b8 | ORCL | 2026-09-10 09:32 | call_butterfly_spread | 3 | 1 | 100 | 77100.00 | long | ask | 156.6250 | 0.8700 | ["160","185","210"] | ["1.1488","1.1732","1.2710"] | ["164.70","205.30"] | ["SPHR"] | 160.0000 | 210.0000 | 8 | 8 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:32:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877b-a8e1-7742-9c6a-12485a688df7 | ORCL | 2026-09-09 14:43 | iron_butterfly | 4 | 1 | 50 | 792950.00 | long | bid | 163.2600 | 3.2500 | ["155","170","180"] | ["0.5925","0.5933","0.5937"] | ["157.95"] | ["SPHR"] | 155.0000 | 180.0000 | 464 | 464 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:43:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08689-f5e0-7211-aec9-17c05605d943 | ORCL | 2026-09-09 10:19 | call_vertical_spread | 2 | 1 | 500 | 277000.00 | long | ask | 160.5200 | 0.2700 | ["185","195"] | ["1.1004","1.1109"] | ["186.40"] | ["ARCO"] | 185.0000 | 195.0000 | 9 | 9 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:19:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |