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 |
|---|
| 01a0a173-e230-7300-8e21-33de94943142 | PSA | 2026-09-14 15:45 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 295.8950 | 4.4000 | ["280","290"] | ["0.3718","0.1792"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:45:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a173-cac0-7f41-8cce-b5a36e5e6fda | PSA | 2026-09-14 15:45 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 295.8950 | 4.4000 | ["280","290"] | ["0.3718","0.1792"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a173-b351-71c3-bc20-a371740057aa | PSA | 2026-09-14 15:45 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 295.9000 | 4.4000 | ["280","290"] | ["0.3707","0.1785"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-e308-7f70-aa0c-7a229805a5c4 | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.2900 | 4.4000 | ["280","290"] | ["0.5741","0.2524"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-7d78-7f81-acd9-4e90e6c127b5 | PSA | 2026-09-14 15:38 | other | 4 | 1 | 15 | 200580.00 | unknown | — | 296.3695 | 11.4000 | ["230","250","260","270"] | ["1.6823","1.2325","0.8880","0.7048"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-46c8-7470-9182-2ae3bfdcdfe5 | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-42e0-7c60-85c2-b671db4ad25e | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-3ef8-7cc2-adf2-8df1d76b2dac | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-3b10-7b50-9c98-027cbfc7aa71 | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-3728-7640-b3fa-dc9f550b3c96 | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-3340-7442-a1d7-4f3952fe1cbb | PSA | 2026-09-14 15:38 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-2b70-78d3-9257-b0722a4b649c | PSA | 2026-09-14 15:37 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-2788-74a0-9d3b-b9eb3f3cee52 | PSA | 2026-09-14 15:37 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-23a0-7a11-ab45-e4a15a4212ae | PSA | 2026-09-14 15:37 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a16d-1fb8-7f43-a62d-1dcc8b63ad08 | PSA | 2026-09-14 15:37 | call_vertical_spread | 2 | 1 | 60 | 136800.00 | unknown | — | 296.3695 | 4.4000 | ["280","290"] | ["0.5653","0.2449"] | [] | ["XPHO"] | 280.0000 | 290.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a134-d1a8-7cb2-b6ad-08bf7fc79432 | PSA | 2026-09-14 14:36 | other | 3 | 1 | 40 | 387840.00 | unknown | — | 295.8550 | 6.5000 | ["230","250","270"] | ["1.5358","0.5951","0.4245"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 4 | 4 | false | false | false | true | false | mlft | |||||||
| 01a0a0e4-fc28-7531-b322-0efff4ab28ac | PSA | 2026-09-14 13:09 | call_vertical_spread | 2 | 1 | 25 | 284100.00 | unknown | — | 296.0150 | 5.4000 | ["230","250"] | ["1.4196","1.0203"] | [] | ["XPHO"] | 230.0000 | 250.0000 | 4 | 4 | true | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:45:16Z"} |
| 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:45:16Z"} |
| 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:39:19Z"} |
| 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-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-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-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-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-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-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-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-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-14T19:37: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:37: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-14T18:37:05Z"} |
| 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-14T17:09:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |