core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d9dd-febf-7373-9e0a-4f46da2585e7 | CMI | 2026-09-25 14:39 | other | 4 | 1 | 10 | 100070.00 | unknown | bid | 523.4000 | 7.0000 | ["510","530","540"] | ["0.3913","0.3479","0.3074"] | [] | ["XCBO"] | 510.0000 | 540.0000 | 21 | 56 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:40:08Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d9c5-5256-7f03-9bf7-76f55d0db08a | CMI | 2026-09-25 14:13 | other | 4 | 1 | 10 | 100150.00 | unknown | — | 523.6400 | 6.7000 | ["510","530","540"] | ["0.3940","0.3486","0.3110"] | [] | ["XMIO"] | 510.0000 | 540.0000 | 21 | 56 | false | false | true | true | |||||||||
| 01a0d9b1-8bd7-7e83-accc-38f579e305dc | CMI | 2026-09-25 13:51 | put_vertical_spread | 2 | 1 | 20 | 115100.00 | unknown | — | 523.6100 | 3.1000 | ["510","530"] | ["0.3939","0.3913"] | [] | ["XMIO"] | 510.0000 | 530.0000 | 56 | 56 | false | false | false | true | |||||||||
| 01a0d9ae-a5a7-7a92-aed7-8589bdb7ab59 | CMI | 2026-09-25 13:48 | other | 4 | 1 | 10 | 100360.00 | unknown | — | 523.9550 | 7.5000 | ["510","530","540"] | ["0.3957","0.3532","0.3155"] | [] | ["XMIO"] | 510.0000 | 540.0000 | 21 | 56 | false | false | true | true | |||||||||
| 01a0d999-0a67-7981-b35d-112e8d95bd6e | CMI | 2026-09-25 13:24 | other | 4 | 1 | 10 | 100100.00 | unknown | — | 523.1500 | 11.0000 | ["510","530","540"] | ["0.3946","0.3439","0.2982"] | [] | ["BATO"] | 510.0000 | 540.0000 | 21 | 56 | false | false | true | true | |||||||||
| 01a0d91e-6bc7-70e1-95dc-9581be84b2d9 | CMI | 2026-09-25 11:10 | put_diagonal_spread | 2 | 3 | 40 | 138780.00 | long | bid | 523.0250 | 4.0000 | ["490","530"] | ["0.3940","0.3058"] | [] | ["AMXO","ARCO","XMIO"] | 490.0000 | 530.0000 | 21 | 56 | false | false | |||||||||||
| 01a0d8f1-58b7-7402-b81f-62c53ad7f90c | CMI | 2026-09-25 10:21 | risk_reversal | 2 | 1 | 50 | 156810.00 | long | bid | 525.1200 | 7.2600 | ["440","650"] | ["0.3826","0.3313"] | ["438.25"] | ["MCRY"] | 440.0000 | 650.0000 | 175 | 175 | true | true | |||||||||||
| 01a0cf38-c297-7f72-91f0-c534d1bb8e26 | CMI | 2026-09-23 13:03 | put_calendar | 2 | 1 | 20 | 528600.00 | long | bid | 522.5000 | 7.2000 | ["650"] | ["0.3948"] | [] | ["ARCO"] | 650.0000 | 650.0000 | 86 | 177 | false | false | |||||||||||
| 01a0c972-6d77-7692-bcf6-c6a372caed07 | CMI | 2026-09-22 10:08 | call_vertical_spread | 2 | 2 | 18 | 115120.00 | unknown | bid | 526.3750 | 6.2000 | ["500","610"] | ["0.3555","0.3415"] | ["563.96"] | ["ARCO","XBOX"] | 500.0000 | 610.0000 | 87 | 87 | false | ||||||||||||
| 01a0c972-4667-7950-a72e-b5746b9d7a64 | CMI | 2026-09-22 10:08 | call_vertical_spread | 2 | 2 | 16 | 100506.00 | unknown | bid | 526.3750 | 6.2000 | ["500","610"] | ["0.3495","0.3341"] | ["562.82"] | ["EMLD","XBOX"] | 500.0000 | 610.0000 | 87 | 87 | false | ||||||||||||
| 01a0c971-e8a7-76a2-a6fb-4bc209ac5d9c | CMI | 2026-09-22 10:07 | call_vertical_spread | 2 | 2 | 24 | 153514.00 | unknown | bid | 526.7900 | 6.2000 | ["500","610"] | ["0.3529","0.3399"] | ["563.96"] | ["ARCO","XBOX"] | 500.0000 | 610.0000 | 87 | 87 | false | ||||||||||||
| 01a0b5fe-9c58-7202-991f-4184d326a673 | CMI | 2026-09-18 15:29 | put_vertical_spread | 2 | 1 | 150 | 188250.00 | short | bid | 528.9600 | 4.2000 | ["530","540"] | ["0.4778","1.5685"] | ["530.25"] | ["XCBO"] | 530.0000 | 540.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b0de-b4f3-7261-a65a-06aea855e696 | CMI | 2026-09-17 15:36 | call_diagonal_spread | 2 | 1 | 42 | 291228.00 | long | ask | 523.5600 | 2.9000 | ["500","520"] | ["0.3831","0.3186"] | [] | ["ARCO"] | 500.0000 | 520.0000 | 29 | 64 | false | false | |||||||||||
| 01a0b0b2-614b-7202-9171-daa6e81c32a2 | CMI | 2026-09-17 14:47 | other | 4 | 1 | 244 | 6329040.00 | unknown | — | 524.9300 | 11.7000 | ["560","600","610","660"] | ["0.9416","1.5655","1.7159","2.4019"] | [] | ["XBOX"] | 560.0000 | 660.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0b0a9-0e93-71c1-8e36-8aa438d99d8b | CMI | 2026-09-17 14:37 | put_ladder | 7 | 1 | 540 | 12615660.00 | unknown | — | 526.0050 | 22.2000 | ["580","600","610","620","630","650","660"] | ["1.4703","1.8244","1.6564","2.1531","2.3087","2.6060","2.7483"] | [] | ["XBOX"] | 580.0000 | 660.0000 | 1 | 1 | true | false | false | ||||||||||
| 01a0a619-45c6-76b0-b70a-68b8568191d1 | CMI | 2026-09-15 13:24 | call_vertical_spread | 2 | 1 | 10 | 119470.00 | unknown | — | 535.5150 | 5.6000 | ["520","550"] | ["0.3549","0.3529"] | [] | ["XPHO"] | 520.0000 | 550.0000 | 185 | 185 | false | false | false | true | |||||||||
| 01a0a0e0-25e1-7350-9b01-0162360803da | CMI | 2026-09-14 13:03 | put_calendar | 2 | 1 | 20 | 276896.00 | short | bid | 537.9550 | 5.9000 | ["600"] | ["0.4389"] | [] | ["XMIO"] | 600.0000 | 600.0000 | 4 | 95 | false | false | |||||||||||
| 01a06df5-15b5-7e51-8119-81274920f4e0 | CMI | 2026-09-04 15:46 | put_vertical_spread | 2 | 1 | 4 | 117228.00 | unknown | — | 558.7850 | 7.1000 | ["700","710"] | ["0.6570","0.6940"] | [] | ["XISX"] | 700.0000 | 710.0000 | 14 | 14 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:13:26Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:51:55Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:48:58Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:24:48Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:10:58Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:21:43Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:03:35Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:52Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:08:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:29:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:36:23Z"} |
| 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-17T18:48:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:07Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:24:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:04:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:46:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |