Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60d-cb10-7220-868b-b15633cb5f62 | IWM | 2026-09-18 15:45 | put_vertical_spread | 2 | 1 | 3750 | 877500.00 | long | ask | 283.8200 | 0.0600 | ["273","278"] | ["0.1956","0.1774"] | ["277.26"] | ["AMXO"] | 273.0000 | 278.0000 | 14 | 14 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b608-b25f-7970-972b-ef2f4dbc488d | IWM | 2026-09-18 15:40 | put_vertical_spread | 2 | 1 | 2500 | 400000.00 | long | ask | 283.7400 | 0.1000 | ["284","285"] | ["0.2085","0.5063"] | ["284.02"] | ["AMXO"] | 284.0000 | 285.0000 | 0 | 0 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:40:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58f-57f7-78e0-8569-84f12ad6a7f3 | IWM | 2026-09-18 13:27 | put_vertical_spread | 2 | 1 | 7500 | 637500.00 | long | ask | 283.2600 | 0.0400 | ["282","284"] | ["0.1967","0.1625"] | ["283.23"] | ["ARCO"] | 282.0000 | 284.0000 | 0 | 0 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:28:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b566-b1b7-7b01-979a-143e51ee54bd | IWM | 2026-09-18 12:43 | strangle | 2 | 1 | 1000 | 378000.00 | long | ask | 282.9800 | 0.0500 | ["275","295"] | ["0.1960","0.1508"] | ["271.22","298.78"] | ["AMXO"] | 275.0000 | 295.0000 | 28 | 28 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:43:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b507-866f-74f3-a079-3d54523eae2f | IWM | 2026-09-18 10:59 | call_diagonal_spread | 2 | 1 | 2250 | 573000.00 | unknown | ask | 283.1100 | 0.0700 | ["290","320"] | ["0.1577","0.1589"] | [] | ["AMXO"] | 290.0000 | 320.0000 | 28 | 91 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fd-8bbf-7711-a535-eda7a55fe5b5 | IWM | 2026-09-18 10:48 | call_diagonal_spread | 2 | 1 | 1500 | 315000.00 | unknown | ask | 283.0800 | 0.0700 | ["298","305"] | ["0.1485","0.1619"] | [] | ["ARCO"] | 298.0000 | 305.0000 | 28 | 63 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:48:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a06d3d-6a2d-7552-a1c0-149929b61d2f | IWM | 2026-09-04 12:25 | strangle | 2 | 1 | 3000 | 561000.00 | long | ask | 295.9300 | 0.0500 | ["286","303"] | ["0.1929","0.1326"] | ["284.13","304.87"] | ["ARCO"] | 286.0000 | 303.0000 | 14 | 14 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:25:47Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |