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 |
| 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 |
| 01a0b542-a340-7be0-bb70-df59e2a31be8 | BA | 2026-09-18 12:03 | put_diagonal_spread | 2 | 1 | 15 | 203580.00 | short | bid | 196.5000 | 4.8000 | ["260","265"] | ["0.3930","0.4152"] | [] | ["XPHO"] | 260.0000 | 265.0000 | 119 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:04:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 01a0afaf-50fb-7bf2-8ccd-85ff55095398 | BA | 2026-09-17 10:04 | put_calendar | 2 | 1 | 60 | 151440.00 | short | ask | 199.8500 | 2.9500 | ["210"] | ["0.5006"] | [] | ["XPHO"] | 210.0000 | 210.0000 | 1 | 43 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:04:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbc-f0bb-7f41-a692-3001ac2a76f5 | BA | 2026-09-16 15:41 | put_diagonal_spread | 2 | 1 | 50 | 158850.00 | short | ask | 198.4200 | 3.0000 | ["210","215"] | ["0.3470","0.8231"] | [] | ["XCBO"] | 210.0000 | 215.0000 | 2 | 30 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:41:34Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-1313-7130-af8a-25cb328e4191 | BA | 2026-09-16 15:17 | put_calendar | 2 | 1 | 30 | 143040.00 | short | bid | 198.1900 | 10.2500 | ["222.5"] | ["1.1610"] | [] | ["XMIO"] | 222.5000 | 222.5000 | 2 | 9 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a15a-ff18-72c2-a1c9-6114c7f77935 | BA | 2026-09-14 15:18 | call_diagonal_spread | 2 | 1 | 257 | 1423780.00 | short | bid | 209.8000 | 1.2500 | ["215","240"] | ["0.3569","0.3594"] | [] | ["XCBO"] | 215.0000 | 240.0000 | 276 | 494 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:18:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a041-ab90-74c3-845e-9ed3b22bbdc7 | BA | 2026-09-14 10:10 | call_calendar | 2 | 1 | 100 | 300300.00 | short | ask | 209.2400 | 2.7500 | ["195"] | ["0.4287"] | [] | ["XCBO"] | 195.0000 | 195.0000 | 4 | 11 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:11:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091b0-9af0-7ed0-8458-12df06209ff5 | BA | 2026-09-11 14:17 | call_vertical_spread | 2 | 1 | 1250 | 882520.00 | short | bid | 211.2200 | 0.7000 | ["240","270"] | ["0.3269","0.3284"] | ["243.96"] | ["EDGO"] | 240.0000 | 270.0000 | 98 | 98 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:18:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 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 |