Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0871a-d3d0-7b82-823d-9293bf0b7e5e | XHB | 2026-09-09 12:57 | call_diagonal_spread | 2 | 2 | 2500 | 390000.00 | short | bid | 99.0300 | 0.4700 | ["102","116"] | ["0.4256","0.2778"] | [] | ["ARCO"] | 102.0000 | 116.0000 | 2 | 100 | true | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:58:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c99-7961-7ea0-a81a-5aff97f10220 | XHB | 2026-09-10 14:34 | other | 4 | 1 | 167 | 413870.00 | unknown | — | 96.4506 | 7.7000 | ["105","110","111","112"] | ["1.1422","0.6475","0.7013","0.7341"] | [] | ["XBOX"] | 105.0000 | 112.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:34:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9e-5390-71e1-9c2b-1b4811fdbc7d | XHB | 2026-09-10 14:39 | other | 3 | 1 | 218 | 568860.00 | unknown | — | 96.4600 | 5.7500 | ["110","111","112"] | ["0.6510","0.7047","0.7377"] | [] | ["XBOX"] | 110.0000 | 112.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:40:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0912b-9058-71b3-bde7-aef557541cdb | XHB | 2026-09-11 11:52 | other | 2 | 1 | 570 | 607500.00 | unknown | — | 98.6400 | 2.0000 | ["95","99"] | ["0.3017","0.3047"] | [] | ["AMXO"] | 95.0000 | 99.0000 | 126 | 371 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:52:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a0b4-66a8-7b60-832c-7954bfe845dc | XHB | 2026-09-14 12:16 | call_vertical_spread | 2 | 1 | 34 | 247656.00 | unknown | — | 98.2200 | 2.1000 | ["61","62"] | ["2.4696","2.2031"] | [] | ["XCBO"] | 61.0000 | 62.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:16:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-0828-7f13-92c0-3b951a28c5db | XHB | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 20 | 158500.00 | long | ask | 98.1200 | 1.9000 | ["58","59"] | ["2.9993","2.9151"] | ["58.99"] | ["XMIO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:07:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-0ff8-7b43-a051-29edbd91ecf9 | XHB | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 20 | 158540.00 | long | ask | 98.1200 | 1.9000 | ["58","59"] | ["2.9993","2.9151"] | ["58.99"] | ["XCBO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:07:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-6200-7381-971d-006dd21a1668 | XHB | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 20 | 158540.00 | long | ask | 98.0500 | 1.5000 | ["58","59"] | ["2.1461","2.1261"] | ["58.99"] | ["XCBO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:07:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-90e0-7423-8e82-75d3f6951147 | XHB | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 23 | 182321.00 | long | ask | 98.0500 | 1.5000 | ["58","59"] | ["2.1461","2.1261"] | ["58.99"] | ["XCBO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:08:23Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e5-07e0-70b1-b4e0-f652f717ffe8 | XHB | 2026-09-14 13:09 | call_vertical_spread | 2 | 1 | 26 | 206024.00 | long | ask | 98.0600 | 1.5000 | ["58","59"] | ["1.9562","2.0292"] | ["58.98"] | ["XMIO"] | 58.0000 | 59.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:09:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-08d8-7ea1-978b-4ac15dafcedc | XHB | 2026-09-14 13:16 | call_vertical_spread | 2 | 1 | 25 | 212475.00 | long | ask | 98.0050 | 1.7000 | ["55","56"] | ["3.1296","3.1179"] | ["55.99"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:17:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-1490-7701-9738-4dac549a68d9 | XHB | 2026-09-14 13:16 | call_vertical_spread | 2 | 1 | 25 | 212475.00 | long | ask | 98.0000 | 1.7000 | ["55","56"] | ["3.1372","3.1248"] | ["55.99"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:17:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-1878-7cd0-9c2a-21f8d58a21bb | XHB | 2026-09-14 13:17 | call_vertical_spread | 2 | 1 | 25 | 212525.00 | long | ask | 98.0000 | 1.7000 | ["55","56"] | ["3.1372","3.1248"] | ["55.99"] | ["XCBO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:17:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-81f0-7c23-b650-03d69c5f9138 | XHB | 2026-09-14 13:17 | call_vertical_spread | 2 | 1 | 36 | 306000.00 | long | ask | 97.9850 | 1.7000 | ["55","56"] | ["3.1596","1.5543"] | ["55.98"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ec-dfb0-7da2-b678-c8d244edd5ec | XHB | 2026-09-14 13:17 | call_vertical_spread | 2 | 1 | 29 | 224199.00 | long | ask | 97.9850 | 1.5000 | ["59","60"] | ["2.3678","2.3218"] | ["59.99"] | ["XCBO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ed-2219-7741-9c49-9e3816c3aa64 | XHB | 2026-09-14 13:18 | call_vertical_spread | 2 | 1 | 30 | 231930.00 | long | ask | 97.9600 | 1.5000 | ["59","60"] | ["2.4281","2.3783"] | ["59.99"] | ["XCBO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ed-58c8-7fe1-8006-644ad2e48aaa | XHB | 2026-09-14 13:18 | call_vertical_spread | 2 | 1 | 50 | 386450.00 | long | ask | 97.9250 | 1.5000 | ["59","60"] | ["2.4824","2.4295"] | ["59.99"] | ["XMIO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ed-9360-7061-8cb5-e2d0223fe49d | XHB | 2026-09-14 13:18 | call_vertical_spread | 2 | 1 | 52 | 402012.00 | long | ask | 97.9250 | 1.5000 | ["59","60"] | ["2.5034","2.4494"] | ["59.99"] | ["XCBO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ed-d5c8-7e43-a30b-1753dede88f6 | XHB | 2026-09-14 13:18 | call_vertical_spread | 2 | 1 | 52 | 401648.00 | unknown | — | 97.9400 | 1.5000 | ["59","60"] | ["2.3788","2.3552"] | [] | ["XPHO"] | 59.0000 | 60.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:19:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ee-52c8-7e72-9cb4-a46ab270a64d | XHB | 2026-09-14 13:19 | call_vertical_spread | 2 | 1 | 25 | 212475.00 | long | ask | 97.9400 | 1.7000 | ["55","56"] | ["2.1456","2.1581"] | ["55.99"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:20:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ee-56b0-7170-a09c-92e59be90f36 | XHB | 2026-09-14 13:19 | call_vertical_spread | 2 | 1 | 25 | 212475.00 | long | ask | 97.9400 | 1.7000 | ["55","56"] | ["2.1456","2.1581"] | ["55.99"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:20:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ef-4cc8-7ea3-98d0-292be3dd5f16 | XHB | 2026-09-14 13:20 | call_vertical_spread | 2 | 1 | 15 | 127500.00 | long | ask | 97.9200 | 1.7000 | ["55","56"] | ["2.2892","2.3243"] | ["55.98"] | ["XMIO"] | 55.0000 | 56.0000 | 4 | 4 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:20:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-15a8-77f1-9804-c235f138da43 | XHB | 2026-09-14 13:38 | call_vertical_spread | 2 | 1 | 30 | 243510.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3747","2.3375"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:38:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-5040-71f1-85de-486422eb1abb | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 20 | 162340.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3747","2.3375"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-5428-7323-b440-a36fd540958b | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 20 | 162300.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3386","2.3046"] | ["57.99"] | ["XMIO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-5bf8-79a1-bf4e-73be74205b36 | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 20 | 162300.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3386","2.3046"] | ["57.99"] | ["XMIO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-6b98-7c31-b0fc-9cc4d26fd937 | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 20 | 162340.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3747","2.3375"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-b1e9-7473-85b4-70f55088f17a | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 25 | 202875.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3386","2.3046"] | ["57.99"] | ["XMIO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a100-b9b9-7f21-a959-b0a8863c6fb1 | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 25 | 202925.00 | long | ask | 97.9600 | 1.0000 | ["57","58"] | ["2.3747","2.3375"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a101-0bc0-78e2-8bbc-c7aa288fa2ab | XHB | 2026-09-14 13:39 | call_vertical_spread | 2 | 1 | 20 | 162340.00 | long | ask | 97.9300 | 1.0000 | ["57","58"] | ["2.4686","2.4242"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:40:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a101-2ee8-70c1-9a4b-726fcf87dd29 | XHB | 2026-09-14 13:40 | call_vertical_spread | 2 | 1 | 21 | 170457.00 | long | ask | 97.9300 | 1.0000 | ["57","58"] | ["2.4686","2.4242"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:40:22Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a101-cf10-7d10-89fb-b0b369d3cadf | XHB | 2026-09-14 13:40 | call_vertical_spread | 2 | 1 | 20 | 162300.00 | long | ask | 97.9400 | 1.0000 | ["57","58"] | ["2.4076","2.3677"] | ["57.99"] | ["XMIO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:41:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a102-c911-7a80-a5e0-811de730abe5 | XHB | 2026-09-14 13:41 | call_vertical_spread | 2 | 1 | 42 | 340914.00 | long | ask | 97.9100 | 1.0000 | ["57","58"] | ["2.5232","2.4752"] | ["57.99"] | ["XCBO"] | 57.0000 | 58.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:41:59Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0b0ce-5973-7dc1-aebd-13590639e773 | XHB | 2026-09-17 15:18 | put_diagonal_spread | 2 | 1 | 250 | 184000.00 | short | bid | 97.1250 | 1.0000 | ["96","100"] | ["0.2833","0.3700"] | [] | ["XPHO"] | 96.0000 | 100.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ce-70e3-7130-8014-0783b6e227a4 | XHB | 2026-09-17 15:18 | put_diagonal_spread | 2 | 1 | 250 | 184000.00 | short | bid | 97.1250 | 0.9700 | ["96","100"] | ["0.2833","0.3700"] | [] | ["XPHO"] | 96.0000 | 100.0000 | 1 | 92 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:18:52Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b5a3-d9f7-7ef1-b77d-f5e00cfe2783 | XHB | 2026-09-18 13:50 | ratio_risk_reversal | 2 | 1 | 4500 | 1701000.00 | short | bid | 96.1250 | 1.5200 | ["90","100"] | ["0.2959","0.2566"] | ["89.90"] | ["XPHO"] | 90.0000 | 100.0000 | 63 | 63 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |