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 | 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 |
|---|
| 01a06dc3-5b3d-7ac3-a9fb-05bbe7864bc5 | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 1 | 10 | 38180.00 | short | bid | 717.8850 | 0.3600 | ["699","700"] | ["0.7516","0.1578"] | [] | ["XCBO"] | 699.0000 | 700.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | 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 |
| 01a06daa-7825-7613-a95f-3cccdd00d34a | QQQ | 2026-09-04 14:24 | call_diagonal_spread_bearish | 2 | 1 | 554 | 69804.00 | short | bid | 717.5300 | 0.0200 | ["718","722"] | ["0.1430","0.0815"] | [] | ["ARCO"] | 718.0000 | 722.0000 | 0 | 4 | false | true | true | ||||||||||
| 01a06d98-b15d-7622-a4c4-a1ad4219ea18 | QQQ | 2026-09-04 14:05 | call_diagonal_spread_bearish | 2 | 1 | 5 | 85980.00 | short | ask | 716.6900 | 3.9200 | ["620","670"] | ["0.3586","0.2245"] | [] | ["MCRY"] | 620.0000 | 670.0000 | 26 | 133 | false | false | true | ||||||||||
| 01a06d24-92cd-7011-b24a-4ecd31ae8b80 | QQQ | 2026-09-04 11:58 | call_diagonal_spread_bearish | 2 | 1 | 2 | 27928.00 | short | ask | 717.5097 | 5.3100 | ["650","655"] | ["0.3624","0.2279"] | [] | ["XCBO"] | 650.0000 | 655.0000 | 14 | 49 | false | false | true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:25:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:06:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:59:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |