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 | directiontext | net_side |
|---|
| 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 |
|---|
| 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 | 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 |
| 01a06d99-70c6-7851-9abf-221fe53adff2 | MRK | 2026-09-04 14:06 | straddle | 2 | 5 | 62 | 179118.00 | long | ask | 150.3468 | 0.6581 | ["155"] | ["0.3279"] | ["126.11","183.89"] | ["ARCO","MCRY","XBOX","XPHO"] | 155.0000 | 155.0000 | 196 | 196 | false | false | false | false | |||||||||
| 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 | true | |||||||||
| 01a08c66-bd18-7913-b1da-348a70e166d4 | MRK | 2026-09-10 13:38 | call_calendar | 2 | 1 | 81 | 743904.00 | short | ask | 144.9800 | 2.6500 | ["100"] | ["0.6491"] | [] | ["XPHO"] | 100.0000 | 100.0000 | 8 | 190 | false | false | true | false | 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 | 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 | 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 | true | |||||||||
| 01a0a0b6-2010-7b62-a1a3-1326622ea407 | MRK | 2026-09-14 12:18 | call_diagonal_spread | 2 | 1 | 227 | 251970.00 | long | ask | 145.1500 | 1.8000 | ["140","146"] | ["0.2904","0.2978"] | [] | ["XMIO"] | 140.0000 | 146.0000 | 4 | 46 | false | false | true | 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 | true | |||||||||
| 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 | true | |||||||||
| 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 | |||||||||
| 01a0a126-56a1-77e3-848e-b1902c0204c1 | MRK | 2026-09-14 14:20 | call_calendar | 2 | 1 | 12 | 134016.00 | short | ask | 145.2800 | 3.4500 | ["90"] | ["0.3593"] | [] | ["EDGO"] | 90.0000 | 90.0000 | 123 | 214 | false | false | true | false | false | ||||||||
| 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 | true | |||||||||
| 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 | true | |||||||||
| 01a0c44a-1d77-7142-b650-044028838211 | MRK | 2026-09-21 10:06 | call_diagonal_spread | 2 | 1 | 14 | 103754.00 | long | ask | 148.3100 | 4.7000 | ["125","135"] | ["0.2724","0.2604"] | [] | ["XCBO"] | 125.0000 | 135.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0c46d-58ff-79a1-9012-3124a1b46ffa | MRK | 2026-09-21 10:44 | risk_reversal | 2 | 1 | 500 | 667500.00 | long | ask | 148.7350 | 0.4500 | ["145","150"] | ["0.3275","0.3266"] | ["152.11"] | ["ARCO"] | 145.0000 | 150.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c9a6-5a6f-7481-842c-3ebd97dd17be | MRK | 2026-09-22 11:05 | call_diagonal_spread | 2 | 1 | 10000 | 11850000.00 | short | ask | 152.0525 | 0.5100 | ["150","175"] | ["0.3247","0.2991"] | [] | ["SPHR"] | 150.0000 | 175.0000 | 59 | 87 | false | false | true | true | |||||||||
| 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 | |||||||||
| 01a0ca38-9bd7-7cf0-b2ad-d5eed996552c | MRK | 2026-09-22 13:45 | call_calendar | 2 | 1 | 21 | 336420.00 | short | ask | 151.7700 | 6.3500 | ["75"] | ["0.4399"] | [] | ["XISX"] | 75.0000 | 75.0000 | 486 | 850 | false | false | true | false | false | ||||||||
| 01a0ca4d-9ebf-78d3-83ea-a7991305151f | MRK | 2026-09-22 14:07 | strangle | 2 | 1 | 750 | 3300000.00 | long | ask | 151.9350 | 3.2500 | ["165","170"] | ["0.3589","0.2934"] | ["121","214.00"] | ["SPHR"] | 165.0000 | 170.0000 | 486 | 486 | true | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:39:29Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| 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 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:18:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:21:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:06:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:45:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:05:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:45:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:08:46Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |