core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 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 |
|---|
| 01a0c49e-fc07-7560-becf-97beeefa6df8 | MRK | 2026-09-21 11:39 | call_diagonal_spread | 2 | 1 | 295 | 166085.00 | short | bid | 148.9000 | 0.1900 | ["155","160"] | ["0.3204","0.3553"] | [] | ["XPHO"] | 155.0000 | 160.0000 | 4 | 60 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:39:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a0ed-0aa8-72d3-9225-79c175b66e7a | MRK | 2026-09-14 13:18 | call_diagonal_spread | 2 | 1 | 28 | 168980.00 | short | ask | 145.3200 | 2.9000 | ["115","120"] | ["0.4495","0.2787"] | [] | ["XMIO"] | 115.0000 | 120.0000 | 32 | 214 | false | false | true | true | |||||||||
| 01a0a0a2-3668-7070-961b-588a79b0e89a | MRK | 2026-09-14 11:56 | call_calendar | 2 | 1 | 40 | 167200.00 | short | bid | 145.2450 | 2.7000 | ["125"] | ["0.2452"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a0a0a2-22e0-7752-9ca7-ca4fc17b37ed | MRK | 2026-09-14 11:56 | call_calendar | 2 | 1 | 35 | 144830.00 | short | bid | 145.2100 | 2.7500 | ["125"] | ["0.2360"] | [] | ["XMIO"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | |||||||||
| 01a06d64-9585-7a12-9726-10d4909d3bf2 | MRK | 2026-09-04 13:08 | call_diagonal_spread_bearish | 2 | 1 | 748 | 477218.00 | short | ask | 150.3700 | 1.9300 | ["145","165"] | ["0.2733","0.2780"] | [] | ["XMIO"] | 145.0000 | 165.0000 | 7 | 21 | false | false | true | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:18:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:56:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:56:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:08:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |