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 |
|---|
| 01a08ce4-5188-7fd3-9ddd-21554e9b0f0f | ORCL | 2026-09-10 15:56 | call_butterfly_spread | 3 | 1 | 180 | 43650.00 | long | ask | 153.4800 | 0.0400 | ["180","190","200"] | ["3.0186","3.0043","3.0223"] | ["180.53","199.47"] | ["XCBO"] | 180.0000 | 200.0000 | 1 | 1 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:56:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c74-9fc8-7be3-88d7-2746d08aa0d1 | ORCL | 2026-09-10 13:54 | call_butterfly_spread | 3 | 1 | 10 | 42835.00 | long | ask | 155.7175 | 2.2000 | ["190","220","260"] | ["0.5931","0.5994","0.6079"] | ["190.55","249.45"] | ["XCBO"] | 190.0000 | 260.0000 | 372 | 372 | false | true | false | ||||||||||
| 01a08c65-9820-74c2-81fc-3012d8b9c3e9 | ORCL | 2026-09-10 13:37 | call_butterfly_spread | 3 | 1 | 54 | 42903.00 | long | ask | 156.3200 | 0.1100 | ["160","185","210"] | ["1.1615","1.2199","1.2842"] | ["164.21","205.79"] | ["XCBO"] | 160.0000 | 210.0000 | 8 | 8 | false | true | false | ||||||||||
| 01a086d7-6618-7c20-aa51-52508ace0bdd | ORCL | 2026-09-09 11:44 | call_butterfly_spread | 3 | 1 | 40 | 31480.00 | long | ask | 161.2350 | 0.7700 | ["350","400","450"] | ["0.6414","0.6546","0.6663"] | ["350.62","449.38"] | ["XCBO"] | 350.0000 | 450.0000 | 281 | 281 | false | true | false | ||||||||||
| 01a086b7-cc40-74d0-91ca-111f5fd05c09 | ORCL | 2026-09-09 11:09 | call_butterfly_spread | 3 | 1 | 20 | 26000.00 | long | ask | 161.5700 | 0.5000 | ["160","170","180"] | ["1.9556","2.0043","2.0330"] | ["161.32","178.68"] | ["XCBO"] | 160.0000 | 180.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0867d-9db9-7a22-a7a0-3112ed95b9f6 | ORCL | 2026-09-09 10:06 | call_butterfly_spread | 3 | 1 | 40 | 29600.00 | unknown | — | 161.3300 | 0.3200 | ["165","185","195"] | ["1.9836","2.0752","2.1210"] | [] | ["XCBO"] | 165.0000 | 195.0000 | 2 | 2 | false | true | false | true | false | ||||||||
| 01a081d7-fad8-7a53-89b6-f6acfb1e04a3 | ORCL | 2026-09-08 12:26 | call_butterfly_spread | 3 | 1 | 124 | 105090.00 | unknown | — | 162.5600 | 0.3600 | ["170","190","195"] | ["1.0219","1.0645","1.0781"] | [] | ["MCRY"] | 170.0000 | 195.0000 | 10 | 10 | false | true | false | true | false | ||||||||
| 01a081d7-4ef8-7150-935d-f351f6bf9bd1 | ORCL | 2026-09-08 12:26 | call_butterfly_spread | 3 | 1 | 154 | 131593.00 | unknown | — | 162.7053 | 0.3600 | ["170","190","195"] | ["1.0207","1.0643","1.0786"] | [] | ["XCBO"] | 170.0000 | 195.0000 | 10 | 10 | false | true | false | true | false | ||||||||
| 01a08169-f6c8-7083-8951-3ca770e2bcaa | ORCL | 2026-09-08 10:26 | call_butterfly_spread | 3 | 1 | 54 | 55404.00 | short | bid | 163.5226 | 0.7300 | ["195","220","240"] | ["0.6324","0.6490","0.6642"] | ["197.20"] | ["EDGO"] | 195.0000 | 240.0000 | 73 | 73 | false | true | false | ||||||||||
| 01a08156-fb68-7871-952b-d164342303fd | ORCL | 2026-09-08 10:05 | call_butterfly_spread | 3 | 1 | 24 | 26544.00 | long | ask | 162.9200 | 0.4500 | ["165","175","185"] | ["1.6206","1.6579","1.6946"] | ["166.24","183.76"] | ["XCBO"] | 165.0000 | 185.0000 | 3 | 3 | false | true | false |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:54:18Z"} |
| 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-10T17:37:55Z"} |
| 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-09T15:44:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:09:58Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:06:27Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:27:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:26:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:26:49Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |