Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5bd-8060-7be2-a3d6-3e5bac91fb0f | BA | 2026-09-18 14:18 | put_vertical_spread | 2 | 1 | 23 | 138092.00 | short | bid | 197.9900 | 1.9000 | ["210","240"] | ["0.3418","0.3901"] | ["215"] | ["AMXO"] | 210.0000 | 240.0000 | 63 | 63 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:18:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b547-17df-73b0-8b12-1fb72bc13016 | BA | 2026-09-18 12:08 | put_vertical_spread | 2 | 1 | 50 | 563600.00 | long | ask | 196.3850 | 3.8500 | ["250","255"] | ["0.4107","0.4298"] | ["250.14"] | ["XCBO"] | 250.0000 | 255.0000 | 91 | 91 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:08:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b545-4707-7173-ae67-7d8d77b4ba4b | BA | 2026-09-18 12:06 | put_vertical_spread | 2 | 1 | 21 | 256473.00 | short | bid | 196.3899 | 4.7500 | ["255","260"] | ["0.4204","0.4433"] | ["255.03"] | ["XMIO"] | 255.0000 | 260.0000 | 91 | 91 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:07:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0db-6933-7930-8d42-95f82a1b4525 | BA | 2026-09-17 15:32 | put_vertical_spread | 2 | 1 | 28 | 143780.00 | unknown | — | 197.9800 | 1.8000 | ["205","210"] | ["0.3538","0.3546"] | [] | ["XPHO"] | 205.0000 | 210.0000 | 273 | 273 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:33:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-ff3b-7163-ac92-f49fcd4c552d | BA | 2026-09-17 14:35 | put_vertical_spread | 2 | 1 | 40 | 470560.00 | unknown | — | 198.4800 | 4.5000 | ["255","260"] | ["0.3854","0.4039"] | [] | ["XCBO"] | 255.0000 | 260.0000 | 92 | 92 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:35:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-a562-7e51-9a54-3e305d8df9f8 | BA | 2026-09-17 14:35 | put_vertical_spread | 2 | 1 | 45 | 529380.00 | unknown | — | 198.5300 | 4.5000 | ["255","260"] | ["0.3875","0.4061"] | [] | ["XCBO"] | 255.0000 | 260.0000 | 92 | 92 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:35:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a6-3fd3-7341-8882-5e03b4b2b97e | BA | 2026-09-17 14:34 | put_vertical_spread | 2 | 1 | 10 | 117640.00 | unknown | — | 198.5700 | 4.5000 | ["255","260"] | ["0.3892","0.4079"] | [] | ["XCBO"] | 255.0000 | 260.0000 | 92 | 92 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a0-d51a-7801-b63d-766da8ea8356 | BA | 2026-09-17 14:28 | put_vertical_spread | 2 | 1 | 20 | 193720.00 | unknown | — | 198.7700 | 5.1500 | ["245","250"] | ["0.3589","0.3767"] | [] | ["XCBO"] | 245.0000 | 250.0000 | 64 | 64 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:29:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a0-8ae3-7461-88c1-b63a96ff2651 | BA | 2026-09-17 14:28 | put_vertical_spread | 2 | 1 | 20 | 193460.00 | short | bid | 198.7700 | 5.4000 | ["245","250"] | ["0.3548","0.3715"] | ["245.15"] | ["XCBO"] | 245.0000 | 250.0000 | 64 | 64 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:28:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb0-cb5b-7eb2-adfc-8890e6ed85f5 | BA | 2026-09-16 15:28 | put_vertical_spread | 2 | 1 | 50 | 644800.00 | unknown | — | 197.7000 | 5.2500 | ["260","265"] | ["0.4214","0.4408"] | [] | ["XCBO"] | 260.0000 | 265.0000 | 93 | 93 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:28:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb0-88f3-7303-b045-868d02f4ba02 | BA | 2026-09-16 15:27 | put_vertical_spread | 2 | 1 | 45 | 580320.00 | unknown | — | 197.7700 | 5.2500 | ["260","265"] | ["0.4243","0.4438"] | [] | ["XCBO"] | 260.0000 | 265.0000 | 93 | 93 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:28:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abaf-5843-7210-9e75-6a2bbb396b8a | BA | 2026-09-16 15:26 | put_vertical_spread | 2 | 1 | 157 | 2162832.00 | unknown | — | 197.4999 | 8.6000 | ["265","270"] | ["0.4016","0.4237"] | [] | ["XMIO"] | 265.0000 | 270.0000 | 93 | 93 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abad-b263-7be2-aa0e-9e6b88357f55 | BA | 2026-09-16 15:24 | put_vertical_spread | 2 | 1 | 48 | 422352.00 | unknown | — | 198.4650 | 8.3500 | ["240","245"] | ["0.4064","0.4405"] | [] | ["XCBO"] | 240.0000 | 245.0000 | 37 | 37 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:24:48Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba1-8533-79b2-97b2-c73a2fa74e5d | BA | 2026-09-16 15:11 | put_vertical_spread | 2 | 1 | 20 | 137140.00 | unknown | — | 198.4750 | 7.7500 | ["230","235"] | ["0.3860","0.4148"] | [] | ["AMXO"] | 230.0000 | 235.0000 | 30 | 30 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:11:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab9b-cc5b-77c2-b4f6-72fdab42a7ee | BA | 2026-09-16 15:05 | put_vertical_spread | 2 | 1 | 46 | 230414.00 | unknown | — | 199.5200 | 7.6500 | ["222.5","227.5"] | ["1.3621","1.5432"] | [] | ["XMIO"] | 222.5000 | 227.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:05:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab9a-e1fb-7f03-ad68-1057822a9ae0 | BA | 2026-09-16 15:04 | put_vertical_spread | 2 | 1 | 30 | 161700.00 | unknown | — | 199.5900 | 7.6500 | ["222.5","227.5"] | ["1.3791","1.5616"] | [] | ["XBOX"] | 222.5000 | 227.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:04:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a090eb-85d0-7d72-85fa-04e154dc5493 | BA | 2026-09-11 10:42 | put_vertical_spread | 2 | 1 | 25 | 113550.00 | long | ask | 208.2500 | 1.6500 | ["210","240"] | ["0.3310","0.3430"] | ["218.80"] | ["XMIO"] | 210.0000 | 240.0000 | 70 | 70 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:42:35Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ccf-69f8-76c3-b2bb-ad309bff42dd | BA | 2026-09-10 15:33 | put_vertical_spread | 2 | 1 | 50 | 420100.00 | unknown | — | 205.0051 | 7.9000 | ["245","250"] | ["0.3267","0.3558"] | [] | ["XCBO"] | 245.0000 | 250.0000 | 43 | 43 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:33:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca5-a2a8-77a2-9ac4-066c1444339e | BA | 2026-09-10 14:47 | put_vertical_spread | 2 | 1 | 57 | 249432.00 | long | ask | 205.2600 | 2.5500 | ["225","230"] | ["0.4464","0.4893"] | ["225.02"] | ["XMIO"] | 225.0000 | 230.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:47:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca5-73c8-74a0-b973-4834ae9f4e9a | BA | 2026-09-10 14:47 | put_vertical_spread | 2 | 1 | 50 | 220750.00 | short | bid | 205.2550 | 3.3000 | ["225","230"] | ["0.2571","0.3003"] | ["225.01"] | ["XMIO"] | 225.0000 | 230.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:47:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca1-e1b8-7c50-9c85-0e159c40fa16 | BA | 2026-09-10 14:43 | put_vertical_spread | 2 | 1 | 50 | 193500.00 | unknown | — | 205.4624 | 3.8000 | ["222.5","227.5"] | ["0.2508","0.5493"] | [] | ["XMIO"] | 222.5000 | 227.5000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087c0-7240-70b2-a0cc-19faae0f5c77 | BA | 2026-09-09 15:58 | put_vertical_spread | 2 | 1 | 45 | 200610.00 | long | ask | 206.6600 | 6.3500 | ["227.5","232.5"] | ["0.4748","0.5427"] | ["227.56"] | ["XCBO"] | 227.5000 | 232.5000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:59:07Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087bf-e989-7362-a147-5a105b1161fa | BA | 2026-09-09 15:58 | put_vertical_spread | 2 | 1 | 155 | 772985.00 | long | ask | 206.6300 | 6.8000 | ["230","235"] | ["0.5506","0.6199"] | ["230.01"] | ["XCBO"] | 230.0000 | 235.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:58:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b6-0e18-7ba1-9ee7-c5968466efe4 | BA | 2026-09-09 15:47 | put_vertical_spread | 2 | 1 | 46 | 111826.00 | unknown | — | 207.6700 | 2.5500 | ["217.5","222.5"] | ["0.5368","0.7142"] | [] | ["XMIO"] | 217.5000 | 222.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:48:04Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08720-bb88-72b0-8881-7ad410f62d7e | BA | 2026-09-09 13:04 | put_vertical_spread | 2 | 2 | 46 | 141956.00 | short | bid | 209.2300 | 2.9000 | ["222.5","227.5"] | ["0.6233","0.7848"] | ["0","222.5"] | ["XMIO"] | 222.5000 | 227.5000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:05:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |