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 |
|---|
| 01a06dc3-6add-73c2-86fe-ae83b15234f2 | PFE | 2026-09-04 14:51 | other | 2 | 1 | 3000 | 102000.00 | unknown | — | 28.5150 | 0.0500 | ["28.5"] | ["0.2125"] | [] | ["XCBO"] | 28.5000 | 28.5000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:52:02Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08262-4d00-72e1-8e60-c8a1d6e8ffc4 | PFE | 2026-09-08 14:57 | other | 2 | 1 | 9499 | 759920.00 | unknown | — | 27.8300 | 0.0300 | ["28","29"] | ["0.2371","0.2344"] | [] | ["XBOX"] | 28.0000 | 29.0000 | 10 | 38 | false | true | true | true | false | mlct | |||||||
| 01a0a0e8-d870-7d21-a89e-14f49ea89cf7 | PFE | 2026-09-14 13:13 | other | 2 | 1 | 100 | 161300.00 | unknown | — | 27.7550 | 1.8500 | ["20"] | ["1.0540"] | [] | ["ARCO"] | 20.0000 | 20.0000 | 4 | 67 | false | false | true | false | false | mlet | |||||||
| 01a0a14b-18c8-7f51-9f71-cdeaaa0febf7 | PFE | 2026-09-14 15:00 | other | 3 | 1 | 1800 | 390600.00 | unknown | — | 27.7450 | 0.4100 | ["27"] | ["0.2547"] | [] | ["SPHR"] | 27.0000 | 27.0000 | 4 | 494 | false | false | true | false | true | mlft | |||||||
| 01a0b0b3-5f33-7e23-a696-83f38f9698d3 | PFE | 2026-09-17 14:48 | other | 5 | 1 | 728 | 171648.00 | unknown | — | 27.6850 | 1.3700 | ["28.5","29","29.5","30"] | ["0.3795","0.7998","0.6656","1.3749"] | [] | ["XBOX"] | 28.5000 | 30.0000 | 1 | 8 | false | false | true | true | false | mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:58:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:13:38Z"} |
| 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:01:06Z"} |
| 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-17T18:49:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |