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 |
|---|
| 01a0caa9-2c3e-7840-bcd4-26d47b46ba54 | CIA | 2026-09-22 15:47 | put_calendar | 2 | 1 | 500 | 177500.00 | short | ask | 3.7199 | 0.3000 | ["5"] | ["1.1977"] | [] | ["XPHO"] | 5.0000 | 5.0000 | 59 | 150 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:48:17Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c489-d5f6-7cf3-bf9a-9d423b2001e6 | CIA | 2026-09-21 11:15 | put_calendar | 2 | 1 | 600 | 218400.00 | short | ask | 3.5400 | 0.5000 | ["5"] | ["1.0906"] | [] | ["XPHO"] | 5.0000 | 5.0000 | 60 | 151 | false | false | true | false | false | mlft | |||||||
| 01a0b500-46f8-7363-8a13-a7abe424fe94 | CIA | 2026-09-18 10:51 | put_calendar | 2 | 1 | 500 | 181500.00 | unknown | bid | 3.5266 | 0.4000 | ["5"] | ["1.0535"] | [] | ["XPHO"] | 5.0000 | 5.0000 | 63 | 154 | false | false | true | false | false | mlft | |||||||
| 01a0a022-6f79-7643-9dd7-a03a6ecf40df | CIA | 2026-09-14 09:36 | put_calendar | 2 | 1 | 1000 | 358000.00 | short | ask | 3.5502 | 0.5000 | ["5"] | ["1.0085"] | [] | ["XPHO"] | 5.0000 | 5.0000 | 67 | 158 | false | false | true | false | false | mlft | |||||||
| 01a08b95-9a09-7eb0-af55-13d1c3fdcffc | CIA | 2026-09-10 09:50 | other | 2 | 1 | 1000 | 364000.00 | unknown | — | 3.5900 | 0.7500 | ["5"] | ["1.0697"] | [] | ["XPHO"] | 5.0000 | 5.0000 | 71 | 162 | false | false | true | false | false | mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:16:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:51:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:36:45Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:50:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |