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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08143-5428-7f63-a721-7e7261cce731 | AMGN | 2026-09-08 09:44 | call_diagonal_spread | 2 | 1 | 75 | 111150.00 | short | bid | 407.0000 | 4.7500 | ["420","450"] | ["0.3757","0.3223"] | [] | ["XCBO"] | 420.0000 | 450.0000 | 10 | 73 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:44:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08154-f3e0-7b42-ab2d-0dd9cd1b234f | AMGN | 2026-09-08 10:03 | put_vertical_spread | 2 | 1 | 200 | 848000.00 | unknown | — | 401.2300 | 6.2000 | ["410","415"] | ["0.3042","0.3050"] | [] | ["XCBO"] | 410.0000 | 415.0000 | 38 | 38 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08161-1558-72d2-96e7-6710211d1182 | AMGN | 2026-09-08 10:16 | other | 4 | 1 | 175 | 123375.00 | unknown | — | 399.8400 | 6.2100 | ["450","460","470"] | ["0.4343","0.3201","0.3352"] | [] | ["XCBO"] | 450.0000 | 470.0000 | 10 | 73 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c8c-8110-7c30-9155-f6dd096a847f | AMGN | 2026-09-10 14:20 | put_vertical_spread | 2 | 1 | 12 | 102552.00 | long | ask | 382.9650 | 7.1000 | ["420","430"] | ["1.1805","1.4061"] | ["0","420"] | ["XCBO"] | 420.0000 | 430.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:20:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a079-22c8-75c0-b225-0736a60efa91 | AMGN | 2026-09-14 11:11 | call_diagonal_spread | 2 | 1 | 74 | 373552.00 | short | ask | 378.9400 | 5.6500 | ["440","480"] | ["0.2726","0.2763"] | [] | ["XMIO"] | 440.0000 | 480.0000 | 368 | 494 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:11:36Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a162-e689-79a0-ad0c-4ce64e5c27c1 | AMGN | 2026-09-14 15:26 | call_vertical_spread | 2 | 1 | 3 | 142503.00 | short | bid | 379.7700 | 7.2500 | ["140","145"] | ["3.7888","3.6816"] | ["144.99"] | ["XCBO"] | 140.0000 | 145.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:26:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0aac9-edcc-7c31-8a79-fbae8af849fe | AMGN | 2026-09-16 11:15 | call_diagonal_spread | 2 | 1 | 9 | 200637.00 | short | bid | 375.8400 | 7.7000 | ["290","300"] | ["0.2287","0.2102"] | [] | ["XCBO"] | 290.0000 | 300.0000 | 492 | 856 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:16:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b575-ffaf-72c1-ad95-185d5c496f1f | AMGN | 2026-09-18 13:00 | strangle | 2 | 1 | 200 | 556204.00 | short | bid | 383.2500 | 1.1500 | ["370","410"] | ["0.3076","0.2783"] | ["342.19","437.81"] | ["XMIO"] | 370.0000 | 410.0000 | 91 | 91 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:00:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c545-88bf-7ef2-bf4d-10f2b2a45982 | AMGN | 2026-09-21 14:41 | strangle | 2 | 1 | 200 | 419038.00 | short | bid | 393.5000 | 1.9500 | ["380","420"] | ["0.3066","0.2787"] | ["359.05","440.95"] | ["XMIO"] | 380.0000 | 420.0000 | 60 | 60 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:41:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |