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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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-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 |
| 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 |
| 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 |