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 |
|---|
| 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 |
|---|
| 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 | true | 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 |
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0b0d8-d123-7611-8f96-ade8b2576981 | MRK | 2026-09-17 15:29 | other | 4 | 4 | 400 | 274994.00 | unknown | — | 147.1700 | 0.9600 | ["145","150"] | ["0.3213","0.2956"] | [] | ["AMXO"] | 145.0000 | 150.0000 | 1 | 64 | false | true | true | true | true | ||||||||
| 01a0a5da-40f6-7943-b85a-5ad8be85f9c9 | MRK | 2026-09-15 12:15 | call_diagonal_spread | 2 | 1 | 61 | 271206.00 | short | bid | 143.4600 | 1.7000 | ["125","145"] | ["0.3240","0.3033"] | [] | ["SPHR"] | 125.0000 | 145.0000 | 94 | 493 | false | false | |||||||||||
| 01a0a170-f430-74b2-843f-7174b6659375 | MRK | 2026-09-14 15:42 | call_condor | 4 | 1 | 80 | 1593440.00 | unknown | — | 144.4450 | 5.8500 | ["75","80","100","125"] | ["3.1448","2.9386","1.9374","0.8595"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a170-d4f0-70e1-9869-84ea98b0585c | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4201 | 5.8500 | ["75","80","100","125"] | ["3.1853","2.9728","1.9621","0.8746"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a170-bd80-7843-9dda-e0597e1811ec | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4400 | 5.8500 | ["75","80","100","125"] | ["3.1531","2.9456","1.9425","0.8626"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a170-a611-7da1-bcf3-00463e580bb0 | MRK | 2026-09-14 15:41 | call_condor | 4 | 1 | 60 | 1195080.00 | unknown | — | 144.4400 | 5.8500 | ["75","80","100","125"] | ["3.1531","2.9456","1.9425","0.8626"] | [] | ["XPHO"] | 75.0000 | 125.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a16d-46c8-7470-9182-2af4cab0597d | MRK | 2026-09-14 15:38 | other | 2 | 1 | 20 | 280440.00 | unknown | — | 144.6900 | 6.2000 | ["50","100"] | ["0.4415","0.5683"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 32 | 494 | false | false | true | true | false | ||||||||
| 01a0a0a1-1558-7331-9c25-84fbf40141dd | MRK | 2026-09-14 11:55 | other | 2 | 1 | 661 | 2842300.00 | unknown | — | 145.2650 | 4.2500 | ["125"] | ["0.2720"] | [] | ["XBOX"] | 125.0000 | 125.0000 | 32 | 67 | false | false | true | false | false | ||||||||
| 01a08c95-eb38-7fe2-a59f-4e5b782bccca | MRK | 2026-09-10 14:30 | put_vertical_spread | 2 | 1 | 74 | 141340.00 | unknown | — | 145.0100 | 2.7500 | ["152.5","155"] | ["1.0631","1.2685"] | [] | ["XBOX"] | 152.5000 | 155.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08bd4-f4c8-7a21-ab75-69f667f63694 | MRK | 2026-09-10 10:59 | call_calendar | 2 | 1 | 83 | 752644.00 | short | bid | 144.4350 | 2.7500 | ["100"] | ["0.6176"] | [] | ["SPHR"] | 100.0000 | 100.0000 | 8 | 190 | false | false | |||||||||||
| 01a08bd4-e528-7b33-827b-22f4f8277eeb | MRK | 2026-09-10 10:59 | call_calendar | 2 | 1 | 54 | 489672.00 | short | bid | 144.4400 | 2.7500 | ["100"] | ["0.6045"] | [] | ["SPHR"] | 100.0000 | 100.0000 | 8 | 190 | false | false |
| true |
| false |
| 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 |
| true |
| true |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:29:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:16:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:42:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:42:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:41:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:41:58Z"} |
| 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-14T19:38:42Z"} |
| 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-14T15:55:15Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:30:37Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:00:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:00:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |