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 |
|---|
| 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 |
|---|
| 01a08c1d-f060-7800-9bb2-83a43c0d4997 | XOM | 2026-09-10 12:19 | risk_reversal | 2 | 1 | 17 | 40664.00 | long | ask | 165.2150 | 2.2000 | ["145","190"] | ["0.3265","0.2535"] | ["192.48"] | ["MCRY"] | 145.0000 | 190.0000 | 463 | 463 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:20:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c1d-f060-7800-9bb2-839a69df97e4 | XOM | 2026-09-10 12:19 | risk_reversal | 2 | 1 | 14 | 33488.00 | long | ask | 165.2150 | 2.6000 | ["145","190"] | ["0.3265","0.2535"] | ["192.48"] | ["XPHO"] | 145.0000 | 190.0000 | 463 | 463 | false | true | false | true | |||||||||
| 01a0aaa0-ab4b-7a23-bbc0-b81bb78989cf | XOM | 2026-09-16 10:30 | risk_reversal | 2 | 1 | 21 | 54327.00 | long | bid | 165.1300 | 1.6500 | ["150","195"] | ["0.3286","0.2574"] | ["149.95"] | ["XMIO"] | 150.0000 | 195.0000 | 492 | 492 | false | true | false | true | |||||||||
| 01a0ca81-c267-77e2-9b1b-2318e3dcf822 | XOM | 2026-09-22 15:04 | risk_reversal | 2 | 1 | 23 | 25438.00 | short | bid | 159.0050 | 1.0500 | ["140","180"] | ["0.3218","0.2754"] | ["180.94"] | ["XCBO"] | 140.0000 | 180.0000 | 178 | 178 | false | true | false | true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:20:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:31:23Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |