core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a0c4ee-680e-70c1-a8be-7fd4a7bb104e | BA | 2026-09-21 13:05 | call_diagonal_spread | 2 | 1 | 10 | 147750.00 | long | ask | 200.8700 | 9.0000 | ["130","160"] | ["0.5043","0.3880"] | [] | ["XCBO"] | 130.0000 | 160.0000 | 88 | 851 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:06:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4f2-82d6-7ef2-bcd3-9358089a3c79 | BA | 2026-09-21 13:10 | call_vertical_spread | 2 | 1 | 60 | 387000.00 | long | ask | 200.9800 | 3.3000 | ["205","230"] | ["0.3638","0.3590"] | ["214.90"] | ["XMIO"] | 205.0000 | 230.0000 | 487 | 487 | false | true | false | true | false | ||||||||
| 01a0c4fc-5676-7491-8aad-e6c3b8446a28 | BA | 2026-09-21 13:21 | call_diagonal_spread | 2 | 1 | 20 | 275860.00 | long | ask | 200.8600 | 3.3500 | ["135","170"] | ["0.5246","0.3876"] | [] | ["XMIO"] | 135.0000 | 170.0000 | 88 | 851 | false | false | true | true | false | ||||||||
| 01a0c55a-54f7-7dc0-a9ea-531dd9156197 | BA | 2026-09-21 15:03 | call_calendar | 2 | 1 | 47 | 405563.00 | unknown | ask | 201.1200 | 1.3500 | ["200"] | ["0.3702"] | [] | ["ARCO"] | 200.0000 | 200.0000 | 487 | 634 | false | false | true | false | false | ||||||||
| 01a0c566-ff27-7c41-8fc0-1e80588bcf8d | BA | 2026-09-21 15:17 | put_calendar | 2 | 1 | 20 | 155940.00 | short | bid | 200.8200 | 4.7500 | ["230"] | ["0.3541"] | [] | ["XMIO"] | 230.0000 | 230.0000 | 269 | 361 | false | false | true | false | false | ||||||||
| 01a0c56e-13a7-7c32-b6d4-276b048cb8f4 | BA | 2026-09-21 15:25 | other | 4 | 1 | 44 | 637736.00 | unknown | — | 200.9800 | 7.2000 | ["230","235","250","255"] | ["0.3484","0.3438","0.3768","0.4082"] | [] | ["ARCO"] | 230.0000 | 255.0000 | 88 | 88 | false | false | false | true | false | mlet | |||||||
| 01a0c95f-d7a7-7d02-8bed-7cc5474fccb2 | BA | 2026-09-22 09:48 | call_calendar | 2 | 1 | 51 | 477156.00 | short | bid | 200.6100 | 7.0000 | ["210"] | ["0.3799"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 633 | 850 | false | true | true | false | false | ||||||||
| 01a0c969-45b7-7aa3-b976-b4fdaaf17aac | BA | 2026-09-22 09:58 | call_calendar | 2 | 1 | 150 | 218100.00 | short | bid | 200.5600 | 1.1000 | ["195"] | ["0.3809"] | [] | ["XISX"] | 195.0000 | 195.0000 | 3 | 10 | false | false | true | false | false | ||||||||
| 01a0c970-e6d7-75c0-89e5-1622d68ed7b7 | BA | 2026-09-22 10:06 | call_calendar | 2 | 1 | 25 | 230750.00 | short | ask | 200.1000 | 7.6000 | ["210"] | ["0.3771"] | [] | ["XMIO"] | 210.0000 | 210.0000 | 633 | 850 | false | true | true | false | false | ||||||||
| 01a0c97a-58cf-7992-be8a-7a543ab59ec1 | BA | 2026-09-22 10:17 | other | 4 | 8 | 60 | 270225.00 | unknown | — | 199.1000 | 7.9671 | ["225","230"] | ["0.3391","0.3425"] | [] | ["ARCO","EMLD","MCRY","XISX","XPHO"] | 225.0000 | 230.0000 | 59 | 59 | false | false | false | true | true | mlet | |||||||
| 01a0c98d-d12f-7683-9878-5be01728ca3f | BA | 2026-09-22 10:38 | call_vertical_spread | 2 | 1 | 39 | 151398.00 | short | bid | 197.8050 | 8.6500 | ["200","230"] | ["0.3655","0.3610"] | ["211.14"] | ["XMIO"] | 200.0000 | 230.0000 | 241 | 241 | true | true | false | true | false | ||||||||
| 01a0c98f-964f-7820-b5df-cd0876925bec | BA | 2026-09-22 10:40 | call_vertical_spread | 2 | 1 | 100 | 308000.00 | short | bid | 197.6450 | 6.0500 | ["180","190"] | ["0.3554","0.3304"] | ["188"] | ["XPHO"] | 180.0000 | 190.0000 | 24 | 24 | false | false | false | true | false | ||||||||
| 01a0c9a9-215f-73d3-a342-5b4db7d65f2b | BA | 2026-09-22 11:08 | call_calendar | 2 | 1 | 20 | 106600.00 | short | bid | 198.4800 | 2.3000 | ["200"] | ["0.3505"] | [] | ["XMIO"] | 200.0000 | 200.0000 | 115 | 486 | false | true | true | false | false | ||||||||
| 01a0c9be-e3af-7091-ac64-0e3b3b1e28b6 | BA | 2026-09-22 11:32 | risk_reversal | 2 | 1 | 75 | 105300.00 | short | ask | 198.6450 | 2.2000 | ["180","235"] | ["0.3469","0.3246"] | ["178.16"] | ["ARCO"] | 180.0000 | 235.0000 | 150 | 150 | false | true | false | true | true | ||||||||
| 01a0ca2c-3027-7823-8ede-b9d12f875160 | BA | 2026-09-22 13:31 | call_vertical_spread | 2 | 1 | 13 | 129727.00 | short | bid | 197.6450 | 2.8000 | ["200","210"] | ["0.3716","0.3695"] | ["204.17"] | ["AMXO"] | 200.0000 | 210.0000 | 850 | 850 | false | true | false | true | false | ||||||||
| 01a0ca2f-3d67-7cc1-abf6-a29c22c8b246 | BA | 2026-09-22 13:34 | straddle | 2 | 1 | 60 | 194940.00 | long | ask | 197.5400 | 1.5500 | ["215"] | ["0.3307"] | ["182.51","247.49"] | ["C2OX"] | 215.0000 | 215.0000 | 115 | 115 | false | false | false | false | true | ||||||||
| 01a0ca2f-3d67-7cc1-abf6-a28e0cc3600a | BA | 2026-09-22 13:34 | straddle | 2 | 2 | 120 | 387840.00 | long | ask | 197.5400 | 1.4908 | ["215"] | ["0.3287"] | ["182.68","247.32"] | ["MCRY","SPHR"] | 215.0000 | 215.0000 | 115 | 115 | false | false | false | false | true | ||||||||
| 01a0ca5b-df2f-7892-8189-f3dcb2613c7f | BA | 2026-09-22 14:23 | call_ratio_spread | 2 | 1 | 100 | 115630.00 | unknown | ask | 197.4483 | 0.9000 | ["192.5","195"] | ["0.3121","0.3129"] | ["193.12","205.68"] | ["XMIO"] | 192.5000 | 195.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0ca85-5477-7af1-bf22-6868424169f2 | BA | 2026-09-22 15:08 | other | 3 | 2 | 100 | 272600.00 | unknown | bid | 197.9001 | 3.9000 | ["185","210","250"] | ["0.3381","0.3399","0.3405"] | ["185","210"] | ["XISX"] | 185.0000 | 250.0000 | 150 | 150 | false | true | false | true | true | ||||||||
| 01a0caa4-3e87-73e1-b562-960dba4dd676 | BA | 2026-09-22 15:42 | other | 4 | 1 | 28 | 260232.00 | unknown | — | 198.1652 | 8.7400 | ["195","240","245"] | ["0.3112","1.7701","0.3607"] | [] | ["XISX"] | 195.0000 | 245.0000 | 3 | 24 | false | false | true | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:10:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:21:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:04:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:17:35Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:25:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:48:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:58:45Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:07:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:17:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:38:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:40:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:08:37Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:32:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:31:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:35:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:35:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:24:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:09:14Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:42:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |