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