core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0c9b5-b807-72f0-bce0-65ce9691652b | MRK | 2026-09-22 11:22 | call_diagonal_spread | 2 | 1 | 31 | 179862.00 | long | ask | 153.2000 | 4.9000 | ["145","160"] | ["0.2810","0.2713"] | [] | ["XPHO"] | 145.0000 | 160.0000 | 486 | 850 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:22:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b603-5747-7f90-8e86-08bc0a099296 | MRK | 2026-09-18 15:34 | call_diagonal_spread | 2 | 1 | 10 | 101520.00 | short | ask | 146.0800 | 4.7500 | ["95","100"] | ["0.4380","0.3845"] | [] | ["ARCO"] | 95.0000 | 100.0000 | 119 | 182 | false | false | true | ||||||||||
| 01a0a56f-b39e-7c73-8384-7a20f2c7be84 | MRK | 2026-09-15 10:19 | call_diagonal_spread | 2 | 1 | 10 | 103760.00 | short | ask | 143.2400 | 5.0000 | ["90","95"] | ["0.3553","0.3482"] | [] | ["XMIO"] | 90.0000 | 95.0000 | 94 | 122 | false | false | true | ||||||||||
| 01a0a114-12d8-7d13-840f-25eb6b50cec1 | MRK | 2026-09-14 14:00 | call_diagonal_spread | 2 | 1 | 385 | 518210.00 | unknown | — | 145.2950 | 0.7500 | ["140","145"] | ["0.2795","0.3017"] | [] | ["EDGO"] | 140.0000 | 145.0000 | 4 | 67 | false | false | true | true | false | ||||||||
| 01a0a0ec-d3f8-7da1-9396-945c6c90e3af | MRK | 2026-09-14 13:17 | call_diagonal_spread | 2 | 1 | 22 | 132836.00 | short | ask | 145.2100 | 3.0500 | ["115","120"] | ["0.4801","0.2834"] | [] | ["XMIO"] | 115.0000 | 120.0000 | 32 | 214 | false | false | true | ||||||||||
| 01a0a0e7-b378-7e50-bfb8-98fe124f47c6 | MRK | 2026-09-14 13:12 | call_diagonal_spread | 2 | 1 | 58 | 352176.00 | short | ask | 145.2000 | 2.1500 | ["115","120"] | ["0.2152","0.2811"] | [] | ["ARCO"] | 115.0000 | 120.0000 | 95 | 186 | false | false | true | ||||||||||
| 01a0a0bb-4861-76b1-ad40-335bac39f1cb | MRK | 2026-09-14 12:23 | call_diagonal_spread | 2 | 1 | 9 | 106038.00 | unknown | — | 145.2300 | 5.6500 | ["85","100"] | ["0.2115","0.2201"] | [] | ["XMIO"] | 85.0000 | 100.0000 | 494 | 858 | false | false | true | true | false | ||||||||
| 01a0a0ab-8538-7e81-b776-740ec01c59b3 | MRK | 2026-09-14 12:06 | call_diagonal_spread | 2 | 1 | 46 | 110676.00 | long | bid | 145.0600 | 1.3500 | ["130","150"] | ["0.1810","0.2953"] | [] | ["BATO"] | 130.0000 | 150.0000 | 32 | 123 | false | false | true | ||||||||||
| 01a0a09d-b9f8-7251-93aa-c29338e3d3c1 | MRK | 2026-09-14 11:51 | call_diagonal_spread | 2 | 4 | 53 | 204608.00 | short | ask | 145.1400 | 1.4500 | ["110","200"] | ["1.3193","0.3137"] | [] | ["AMXO","EDGO","XCBO","XISX"] | 110.0000 | 200.0000 | 4 | 276 | false | false | true | ||||||||||
| 01a0a09d-b9f8-7251-93aa-c27e0a0680cd | MRK | 2026-09-14 11:51 | call_diagonal_spread | 2 | 3 | 32 | 123680.00 | short | ask | 145.1400 | 1.1406 | ["110","200"] | ["1.3838","0.3136"] | [] | ["XBOX","XPHO"] | 110.0000 | 200.0000 | 4 | 276 | false | false | true | ||||||||||
| 01a0a09d-b9f8-7251-93aa-c237c5a1f63a | MRK | 2026-09-14 11:51 | call_diagonal_spread | 2 | 4 | 36 | 139164.00 | long | bid | 145.1100 | 1.0708 | ["110","200"] | ["1.4235","0.3138"] | [] | ["XBOX","XMIO","XPHO"] | 110.0000 | 200.0000 | 4 | 276 | false | false | true | ||||||||||
| 01a0a09d-2971-7382-9c6f-5f5e1fbe5fb8 | MRK | 2026-09-14 11:50 | call_diagonal_spread | 2 | 4 | 42 | 161930.00 | long | bid | 145.0253 | 1.1786 | ["110","200"] | ["1.4340","0.3142"] | [] | ["AMXO","XBOX","XMIO","XPHO"] | 110.0000 | 200.0000 | 4 | 276 | false | false | true | ||||||||||
| 01a0917f-3668-7472-a062-858737450cee | MRK | 2026-09-11 13:23 | call_diagonal_spread | 2 | 1 | 32 | 297152.00 | short | bid | 145.4000 | 2.4000 | ["100","105"] | ["0.3530","0.2442"] | [] | ["XISX"] | 100.0000 | 105.0000 | 126 | 497 | false | false | true | ||||||||||
| 01a0917f-3668-7472-a062-85759078e09a | MRK | 2026-09-11 13:23 | call_diagonal_spread | 2 | 1 | 32 | 297152.00 | short | bid | 145.4000 | 2.4000 | ["100","105"] | ["0.3530","0.2442"] | [] | ["XPHO"] | 100.0000 | 105.0000 | 126 | 497 | false | false | true | ||||||||||
| 01a09179-9500-7632-adcb-6fca1002c62b | MRK | 2026-09-11 13:17 | call_diagonal_spread | 2 | 1 | 70 | 637000.00 | unknown | — | 145.5700 | 3.6000 | ["100","105"] | ["0.3162","0.2370"] | [] | ["XISX"] | 100.0000 | 105.0000 | 98 | 371 | false | false | true | true | false | ||||||||
| 01a090bd-3270-7900-b7ba-c9f610f72570 | MRK | 2026-09-11 09:51 | call_diagonal_spread | 2 | 1 | 65 | 387270.00 | short | ask | 144.9600 | 4.7500 | ["115","130"] | ["0.3795","0.2821"] | [] | ["XMIO"] | 115.0000 | 130.0000 | 98 | 371 | false | false | true | ||||||||||
| 01a090ba-34d0-7cf2-b66e-0822d9a38d12 | MRK | 2026-09-11 09:48 | call_diagonal_spread | 2 | 2 | 244 | 581208.00 | short | bid | 145.1400 | 2.0500 | ["135","140"] | ["0.2380","0.2942"] | [] | ["ARCO"] | 135.0000 | 140.0000 | 35 | 98 | false | false | true | ||||||||||
| 01a08ba0-8300-7e50-bcba-48a4a2d211d8 | MRK | 2026-09-10 10:02 | call_diagonal_spread | 2 | 1 | 44 | 222816.00 | long | bid | 146.2450 | 3.1000 | ["120","135"] | ["0.8790","0.3071"] | [] | ["XMIO"] | 120.0000 | 135.0000 | 8 | 280 | false | false | true | ||||||||||
| 01a08b8a-0918-7871-8d72-4db34310542b | MRK | 2026-09-10 09:37 | call_diagonal_spread | 2 | 1 | 40 | 301960.00 | short | ask | 146.8800 | 5.5500 | ["100","125"] | ["1.6174","0.3037"] | [] | ["XMIO"] | 100.0000 | 125.0000 | 8 | 190 | false | false | true | ||||||||||
| 01a08667-7da9-7112-8ed4-4df4cce11419 | MRK | 2026-09-09 09:42 | call_diagonal_spread | 2 | 1 | 11 | 134420.00 | long | bid | 148.4350 | 6.6500 | ["85","90"] | ["2.5073","0.6437"] | [] | ["XCBO"] | 85.0000 | 90.0000 | 9 | 100 | false | false | true | ||||||||||
| 01a08253-4940-70b3-bec9-715e5c4df5a0 | MRK | 2026-09-08 14:41 | call_diagonal_spread | 2 | 1 | 20 | 178600.00 | long | bid | 148.6300 | 4.4000 | ["95","120"] | ["0.5716","0.2965"] | [] | ["XMIO"] | 95.0000 | 120.0000 | 101 | 282 | false | false | true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:34:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:19:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:01:24Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:12:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:23:55Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:06:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:51:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:51:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:51:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:50:52Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:24:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:24:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:17:55Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:52:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:48:51Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:02:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:38:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:42:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:41:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |