core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a08794-d630-7560-97ac-7142a012040d | TROW | 2026-09-09 15:11 | other | 2 | 1 | 396 | 150480.00 | unknown | — | 108.3300 | 0.8000 | ["105","110"] | ["0.3115","0.3717"] | [] | ["XPHO"] | 105.0000 | 110.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:11:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0a0f6-0388-7293-8453-c8ca67ebcd10 | TROW | 2026-09-14 13:27 | other | 4 | 1 | 60 | 324600.00 | unknown | — | 105.8500 | 8.3000 | ["50","90","95","100"] | ["0.8119","1.0215","0.8343","0.5757"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-1710-7213-9c19-61a5f5eb58ea | TROW | 2026-09-14 13:27 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.8500 | 8.3000 | ["50","90","95","100"] | ["0.8119","0.9718","0.8446","0.5684"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-2a99-79c2-a5f3-02158b318cbb | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.8500 | 8.3000 | ["50","90","95","100"] | ["0.8119","0.9718","0.8446","0.5684"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-3a39-7252-9238-ffde5dc71087 | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.9250 | 8.3000 | ["50","90","95","100"] | ["0.7950","0.9017","0.8088","0.5443"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-49d9-74c2-86b9-3dbd98835ab3 | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.9250 | 8.3000 | ["50","90","95","100"] | ["0.7950","0.9017","0.8088","0.5443"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-6148-7313-8c67-22ef905d82a0 | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.9250 | 8.3000 | ["50","90","95","100"] | ["0.7950","0.9017","0.8088","0.5443"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-6d01-77c0-9778-2ad950c60512 | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.9250 | 8.3000 | ["50","90","95","100"] | ["0.7950","0.9017","0.8088","0.5443"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-78b8-7dc2-a30f-e99505634550 | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324000.00 | unknown | — | 105.9250 | 8.3000 | ["50","90","95","100"] | ["0.7950","0.9017","0.8088","0.5443"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-9be0-72e2-b727-19b2fc2665eb | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9250 | 8.2000 | ["50","90","95","100"] | ["0.7950","0.9229","0.8250","0.5481"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-a799-77f2-a9d3-1dc2a4b6814c | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9250 | 8.2000 | ["50","90","95","100"] | ["0.7950","0.9229","0.8250","0.5481"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a0f6-b350-78f2-805d-cbc9bf963c3c | TROW | 2026-09-14 13:28 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9250 | 8.2000 | ["50","90","95","100"] | ["0.7950","0.8747","0.8028","0.5329"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a100-0dd8-7461-9b65-bcca31d04ec2 | TROW | 2026-09-14 13:38 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9800 | 8.2000 | ["50","90","95","100"] | ["0.7818","0.8627","0.7976","0.5295"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a100-2160-7080-a82d-d5e81e949dd9 | TROW | 2026-09-14 13:38 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9800 | 8.2000 | ["50","90","95","100"] | ["0.7818","0.8627","0.7976","0.5295"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a100-34e8-78d0-bf1f-ba5155d13609 | TROW | 2026-09-14 13:38 | other | 4 | 1 | 60 | 324240.00 | unknown | — | 105.9800 | 8.2000 | ["50","90","95","100"] | ["0.7818","0.8627","0.7976","0.5295"] | [] | ["XPHO"] | 50.0000 | 100.0000 | 4 | 123 | false | false | true | true | |||||||||
| 01a0a169-eb69-7da1-9620-9b561c4f4083 | TROW | 2026-09-14 15:34 | call_vertical_spread | 2 | 1 | 100 | 257000.00 | unknown | — | 105.7600 | 5.2000 | ["90","95"] | ["0.5549","0.2460"] | [] | ["XPHO"] | 90.0000 | 95.0000 | 32 | 32 | false | false | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:28:18Z"} |
| 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-14T17:29:01Z"} |
| 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-14T17:29:01Z"} |
| 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-14T17:29:01Z"} |
| 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-14T17:29:01Z"} |
| 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-14T17:38:59Z"} |
| 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-14T17:38:59Z"} |
| 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-14T17:38:59Z"} |
| 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:34:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |