core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0d4db-8257-7813-a8c7-12a12ab0e103 | BRUN | 2026-09-24 15:19 | call_ratio_spread | 2 | 1 | 9300 | 558000.00 | unknown | ask | 17.0100 | 0.5500 | ["50","60"] | ["1.2077","1.2454"] | ["50.90"] | ["SPHR"] | 50.0000 | 60.0000 | 113 | 113 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:19:17Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d416-b76f-7253-8f35-f2ee7a08c04c | BRUN | 2026-09-24 11:44 | call_ratio_spread | 2 | 1 | 500 | 126000.00 | unknown | ask | 15.9750 | 1.2000 | ["20","22.5"] | ["1.2194","1.2081"] | ["0","20","28.33"] | ["AMXO"] | 20.0000 | 22.5000 | 57 | 57 | false | ||||||||||||
| 01a0d411-f4ae-78d1-a7b6-169cf76f3426 | BRUN | 2026-09-24 11:38 | call_ladder | 3 | 1 | 1250 | 295000.00 | unknown | ask | 15.9200 | 1.6500 | ["18","20","22.5"] | ["1.2614","1.2268","1.3096"] | ["18.96"] | ["XPHO"] | 18.0000 | 22.5000 | 22 | 22 | false | true | |||||||||||
| 01a0ca66-dbaf-7ed1-9dbd-df5082d4f66d | BRUN | 2026-09-22 14:35 | call_calendar | 2 | 1 | 750 | 273000.00 | short | ask | 17.4400 | 4.1000 | ["17.5"] | ["1.2554"] | [] | ["XMIO"] | 17.5000 | 17.5000 | 10 | 24 | false | true | |||||||||||
| 01a0c97e-ecaf-7e92-a1a5-c8e9cb61692f | BRUN | 2026-09-22 10:22 | call_diagonal_spread | 2 | 1 | 500 | 102500.00 | long | ask | 17.6600 | 1.3000 | ["18","20"] | ["1.4239","1.1763"] | [] | ["XMIO"] | 18.0000 | 20.0000 | 3 | 24 | false | true | |||||||||||
| 01a0b0be-5bb3-7d71-a96c-74bdb8704cfa | BRUN | 2026-09-17 15:00 | other | 3 | 1 | 2500 | 872150.00 | unknown | — | 16.5750 | 1.2500 | ["25","30","40"] | ["1.2002","1.2028","1.1211"] | [] | ["XPHO"] | 25.0000 | 40.0000 | 64 | 120 | false | true | true | true | |||||||||
| 01a0afdf-84d3-7981-8382-0db7129f51f0 | BRUN | 2026-09-17 10:57 | call_diagonal_spread | 2 | 1 | 1250 | 108750.00 | unknown | — | 16.7900 | 0.5500 | ["17.5","22.5"] | ["1.6416","1.1047"] | [] | ["XPHO"] | 17.5000 | 22.5000 | 1 | 29 | false | true | true | true | |||||||||
| 01a0afc3-177b-7a63-a054-24c1dc55b9cc | BRUN | 2026-09-17 10:26 | other | 3 | 1 | 1750 | 1336250.00 | unknown | — | 16.3600 | 3.0000 | ["15","17.5","20"] | ["1.3061","1.2800","1.8499"] | [] | ["AMXO"] | 15.0000 | 20.0000 | 1 | 29 | false | false | true | true | |||||||||
| 01a0af99-6b84-7672-9338-34ca93fc82bc | BRUN | 2026-09-17 09:40 | call_diagonal_spread | 2 | 1 | 500 | 131000.00 | short | bid | 15.5100 | 2.3000 | ["14.5","17.5"] | ["1.8085","1.2196"] | [] | ["EDGO"] | 14.5000 | 17.5000 | 1 | 29 | false | false | |||||||||||
| 01a0ab48-2e1b-7443-a6d3-c9f34a2a0402 | BRUN | 2026-09-16 13:33 | call_calendar | 2 | 2 | 1000 | 210000.00 | unknown | — | 14.8050 | 0.9000 | ["25"] | ["1.1274"] | [] | ["AMXO"] | 25.0000 | 25.0000 | 65 | 121 | false | true | true | false | |||||||||
| 01a0a13e-c870-7d10-9b9d-bb4fc4f99faa | BRUN | 2026-09-14 14:47 | put_vertical_spread | 2 | 1 | 1250 | 358750.00 | unknown | — | 14.7900 | 0.6500 | ["12.5","15"] | ["1.0904","1.1258"] | [] | ["XPHO"] | 12.5000 | 15.0000 | 32 | 32 | false | false | false | true | |||||||||
| 01a086a2-b5d0-7bd0-b147-356f0c1f751b | BRUN | 2026-09-09 10:46 | put_vertical_spread | 2 | 1 | 1250 | 376250.00 | long | ask | 18.5200 | 0.9500 | ["15","17.5"] | ["1.1152","1.1176"] | ["16.45"] | ["XPHO"] | 15.0000 | 17.5000 | 37 | 37 | true | true | |||||||||||
| 01a0866f-6ce9-7180-b6bd-6ced65101d05 | BRUN | 2026-09-09 09:50 | other | 3 | 2 | 500 | 144490.00 | unknown | — | 18.8150 | 1.8500 | ["19.5","20"] | ["1.4052","1.1868"] | [] | ["XCBO"] | 19.5000 | 20.0000 | 2 | 37 | false | true | true | true | |||||||||
| 01a06dcf-c6ed-7970-9698-51d1e87e855b | BRUN | 2026-09-04 15:05 | call_diagonal_spread_bullish | 2 | 1 | 2000 | 369844.00 | long | ask | 17.4700 | 0.3500 | ["20","22.5"] | ["1.0946","0.9506"] | [] | ["XMIO"] | 20.0000 | 22.5000 | 14 | 42 | false | ||||||||||||
| 01a06dcf-5d75-7d90-b0b4-14d4060d2a71 | BRUN | 2026-09-04 15:04 | call_diagonal_spread_bullish | 2 | 1 | 1000 | 188000.00 | long | ask | 17.4400 | 0.3500 | ["20","22.5"] | ["1.1005","1.0023"] | [] | ["EDGO"] | 20.0000 | 22.5000 | 14 | 42 | false | ||||||||||||
| 01a06dcf-0b6d-7642-9e1c-a4ee73b31dbe | BRUN | 2026-09-04 15:04 | call_diagonal_spread_bullish | 2 | 1 | 628 | 117443.00 | long | ask | 17.4100 | 0.3500 | ["20","22.5"] | ["1.1061","0.9925"] | [] | ["EDGO"] | 20.0000 | 22.5000 | 14 | 42 | false | ||||||||||||
| 01a06dce-5ba5-7a00-b9e0-fbeae30899bd | BRUN | 2026-09-04 15:03 | call_diagonal_spread_bullish | 2 | 1 | 702 | 133380.00 | long | ask | 17.4300 | 0.4500 | ["20","22.5"] | ["1.1023","1.0333"] | [] | ["EDGO"] | 20.0000 | 22.5000 | 14 | 42 | false |
| false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:44:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:39:25Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:36:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:22:35Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:01:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:57:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:26:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:41:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:34:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:47:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:46:56Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:50:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:05:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:05:17Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:04:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:04:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |