core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a0816c-a648-70e0-af7e-a9109b371f1a | XOM | 2026-09-08 10:29 | call_condor | 4 | 1 | 6 | 32436.00 | short | bid | 161.3400 | 7.1000 | ["150","170","180","185"] | ["0.2488","0.2567","0.2629","0.2637"] | ["158.40"] | ["XMIO"] | 150.0000 | 185.0000 | 282 | 282 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:29:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c5d-fae8-7c73-b139-516cee55e1e4 | XOM | 2026-09-10 13:29 | call_condor | 4 | 1 | 5 | 57285.00 | long | ask | 165.5475 | 8.6000 | ["135","140","175","180"] | ["0.1998","0.2172","0.2436","0.2472"] | ["136.37","178.63"] | ["XMIO"] | 135.0000 | 180.0000 | 498 | 498 | false | false | false | true | |||||||||
| 01a0a0ab-b030-7d23-881e-863e71da2085 | XOM | 2026-09-14 12:06 | call_condor | 4 | 1 | 10 | 79460.00 | short | bid | 166.0350 | 9.2000 | ["150","175","180","200"] | ["0.2589","0.2666","0.2680","0.2746"] | ["156.40","198.60"] | ["XPHO"] | 150.0000 | 200.0000 | 459 | 459 | false | false | false | true | |||||||||
| 01a0a15b-9b58-7c83-8083-829c760319c8 | XOM | 2026-09-14 15:18 | call_condor | 4 | 1 | 5 | 53085.00 | long | ask | 164.3500 | 10.5000 | ["140","145","180","185"] | ["0.2630","0.2677","0.2720","0.2741"] | ["141.37","183.63"] | ["XMIO"] | 140.0000 | 185.0000 | 494 | 494 | false | false | false | true | |||||||||
| 01a0a5a3-6dce-7ee0-8448-4533b50066af | XOM | 2026-09-15 11:15 | call_condor | 4 | 1 | 5 | 51350.00 | short | bid | 168.3900 | 7.4000 | ["145","150","185","190"] | ["0.2121","0.2196","0.2543","0.2555"] | ["146.40","188.60"] | ["XCBO"] | 145.0000 | 190.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a679-921e-7f92-b871-6c8f4c94bb84 | XOM | 2026-09-15 15:09 | call_condor | 4 | 1 | 5 | 48425.00 | unknown | — | 168.5800 | 4.3000 | ["150","155","190","195"] | ["0.2408","0.2434","0.2606","0.2594"] | [] | ["XPHO"] | 150.0000 | 195.0000 | 493 | 493 | false | false | false | true | false | mlet |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:29:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:06:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:18:53Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:15:56Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:09:39Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |