core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| directiontext |
|---|
| 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 |
|---|
| 01a0d965-e4a7-7e41-9465-879f817bd691 | CAT | 2026-09-25 12:28 | call_ladder | 3 | 3 | 7 | 37868.00 | unknown | ask | 820.4800 | 6.7000 | ["820","855","860"] | ["0.3415","0.3361","0.3384"] | ["863.03"] | ["ARCO","XPHO"] | 820.0000 | 860.0000 | 21 | 21 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:29:01Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0cf03-acbf-7062-be0d-53d71d9ba6a6 | CAT | 2026-09-23 12:05 | call_ladder | 3 | 1 | 2 | 35080.00 | unknown | bid | 804.5050 | 8.4000 | ["760","790","850"] | ["0.4091","0.4032","0.4011"] | ["827.77"] | ["XPHO"] | 760.0000 | 850.0000 | 58 | 58 | false | false | |||||||||||
| 01a0afcb-1e2b-70d2-b107-816d025c89cd | CAT | 2026-09-17 10:35 | call_ladder | 3 | 2 | 24 | 72948.00 | long | ask | 801.9150 | 9.4500 | ["822.5","850","865"] | ["0.3788","0.3778","0.3754"] | ["824.92","890.08"] | ["ARCO","XPHO"] | 822.5000 | 865.0000 | 15 | 15 | false | true | |||||||||||
| 01a0a055-79e0-70f2-ad22-6944e1cf1bb0 | CAT | 2026-09-14 10:32 | call_ladder | 3 | 4 | 14 | 28036.00 | short | bid | 787.8350 | 4.6600 | ["860","880","1000"] | ["0.3617","0.3696","0.4274"] | ["861.57","1018.43"] | ["ARCO","EMLD","SPHR","XBOX"] | 860.0000 | 1000.0000 | 32 | 32 | false |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:05:45Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:35:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:32:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |