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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0cf-b903-79d0-87ee-832a88c05cfa | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3450 | 8.0000 | ["32","35"] | ["0.2644","0.1220"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-b133-76b2-9801-c881e1f57fb8 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3600 | 8.0000 | ["32","35"] | ["0.2596","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-ad4b-7531-af0c-17af190b173c | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-a57b-71c0-be37-97ddd05d919b | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-a193-7760-80ff-90f1db1e9e3a | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-9dab-7261-a3b3-5a4bab0b6679 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-99c3-7fd2-a563-a9ec2e4a14e8 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-95db-7dc2-b281-3f78c7042a70 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-91f3-7003-91a7-98f63219939c | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-8e0b-7830-93a2-e3fb26aecb44 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-8a23-7d42-826a-3a5cf1ae679c | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-8253-73e3-bfeb-477a1135465e | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-7e6b-7e82-bae0-26890390ba00 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.3800 | 8.0000 | ["32","35"] | ["0.2526","0.2366"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-7a83-7780-b4ac-d39795708e50 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:20:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-769b-7010-8a8a-0d2c36a6390c | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-6ecb-7ac0-9735-5ce6a2a6c34c | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-6ae3-7bd1-ba5c-eb7bcb336476 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-66fb-7253-b69a-2c894c962ff1 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-5f2b-7242-b4b7-0e02c6ac0009 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-5b43-7450-bf81-6ae366772993 | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0cf-5373-70a2-b4a3-37525fd80dfb | FRO | 2026-09-17 15:19 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.4150 | 8.0000 | ["32","35"] | ["0.2379","0.2376"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:19:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c1-da3b-7130-927e-051d2b5ec1ae | FRO | 2026-09-17 15:04 | call_vertical_spread | 2 | 1 | 30 | 109620.00 | unknown | — | 54.5600 | 3.0000 | ["35","38"] | ["4.9848","4.1926"] | [] | ["XPHO"] | 35.0000 | 38.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:05:17Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c1-6123-7b12-aae4-2b3f4659913d | FRO | 2026-09-17 15:04 | call_vertical_spread | 2 | 1 | 30 | 109620.00 | unknown | — | 54.5750 | 3.0000 | ["35","38"] | ["4.9151","4.1319"] | [] | ["XPHO"] | 35.0000 | 38.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:04:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0c0-ad73-7360-978b-86bb40d36460 | FRO | 2026-09-17 15:03 | call_vertical_spread | 2 | 1 | 40 | 146160.00 | unknown | — | 54.5900 | 3.0000 | ["35","38"] | ["4.8420","4.0684"] | [] | ["XPHO"] | 35.0000 | 38.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:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0bf-cae3-7932-a729-2aecdd68532b | FRO | 2026-09-17 15:02 | call_vertical_spread | 2 | 1 | 40 | 144960.00 | unknown | — | 54.5500 | 3.3000 | ["35","38"] | ["4.1032","3.4244"] | [] | ["XPHO"] | 35.0000 | 38.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 |
| 01a0b0be-b973-7f70-92bc-d7cb85c80414 | FRO | 2026-09-17 15:01 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.5900 | 8.0000 | ["32","35"] | ["0.2845","0.2484"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:01:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0be-a9d3-76d2-8f54-43e224d70b6b | FRO | 2026-09-17 15:01 | call_vertical_spread | 2 | 1 | 90 | 378000.00 | unknown | — | 54.5900 | 8.0000 | ["32","35"] | ["0.2845","0.2484"] | [] | ["XPHO"] | 32.0000 | 35.0000 | 491 | 491 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:01:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |