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 | direction |
|---|
| 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 |
|---|
| 01a06d71-14bd-7541-898c-f543c7fda4c4 | MULL | 2026-09-04 13:21 | call_vertical_spread | 2 | 1 | 5000 | 14455000.00 | short | bid | 23.1200 | 4.2000 | ["8.4","8.6"] | ["1.5058","1.4734"] | ["8.49"] | ["XMIO"] | 8.4000 | 8.6000 | 133 | 133 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:22:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd8-d73e-7b12-b6c5-764d21aed825 | MULL | 2026-09-04 15:15 | other | 4 | 1 | 75 | 143100.00 | unknown | — | 23.3100 | 6.7500 | ["22","24","26"] | ["1.3087","1.2700","1.3912"] | [] | ["XISX"] | 22.0000 | 26.0000 | 14 | 105 | false | false | true | true | false | ||||||||
| 01a08157-0ef0-7280-bfd1-591023641dfc | MULL | 2026-09-08 10:05 | other | 2 | 1 | 30 | 122550.00 | unknown | — | 24.0600 | 4.4000 | ["2","5"] | ["14.6059","3.1088"] | [] | ["XPHO"] | 2.0000 | 5.0000 | 10 | 101 | true | false | true | true | false | ||||||||
| 01a08173-16b8-74f3-afa7-187e8d1173ae | MULL | 2026-09-08 10:36 | call_vertical_spread | 2 | 1 | 68 | 144024.00 | unknown | — | 23.8800 | 3.2000 | ["13.2","13.6"] | ["2.0087","1.9961"] | [] | ["XCBO"] | 13.2000 | 13.6000 | 10 | 10 | false | false | false | true | |||||||||
| 01a0818e-1cb0-7873-9946-987b95b064dd | MULL | 2026-09-08 11:06 | put_diagonal_spread | 2 | 1 | 81 | 153819.00 | short | ask | 23.9100 | 2.2000 | ["31","33.6"] | ["1.2163","1.9963"] | [] | ["EMLD"] | 31.0000 | 33.6000 | 10 | 38 | false | false | |||||||||||
| 01a081e7-f4b1-7761-b215-d06332fbc449 | MULL | 2026-09-08 12:44 | other | 2 | 5 | 122 | 128100.00 | unknown | — | 24.0206 | 2.6000 | ["19.2","22"] | ["1.4817","1.3674"] | [] | ["EMLD","XMIO","XPHO"] | 19.2000 | 22.0000 | 10 | 38 | false | false | true | true | false | ||||||||
| 01a081e7-f4b1-7761-b215-d0554e286aed | MULL | 2026-09-08 12:44 | other | 2 | 6 | 192 | 201600.00 | unknown | — | 24.0206 | 2.6000 | ["19.2","22"] | ["1.4817","1.3674"] | [] | ["EMLD","XMIO","XPHO"] | 19.2000 | 22.0000 | 10 | 38 | false | false | true | true | false | ||||||||
| 01a081e7-f4b1-7761-b215-d049f5a7706f | MULL | 2026-09-08 12:44 | other | 2 | 5 | 131 | 137550.00 | unknown | — | 24.0206 | 2.6000 | ["19.2","22"] | ["1.4817","1.3674"] | [] | ["EMLD","XMIO","XPHO"] | 19.2000 | 22.0000 | 10 | 38 | false | false | true | true | false | ||||||||
| 01a081e7-f4b1-7761-b215-d0236ce5fa31 | MULL | 2026-09-08 12:44 | other | 2 | 8 | 154 | 161700.00 | unknown | — | 24.0206 | 2.6000 | ["19.2","22"] | ["1.4817","1.3674"] | [] | ["AMXO","ARCO","EMLD","XMIO","XPHO"] | 19.2000 | 22.0000 | 10 | 38 | false | false | true | true | |||||||||
| 01a086f1-79e0-7ef1-8dac-fce8fc682c73 | MULL | 2026-09-09 12:12 | put_diagonal_spread | 2 | 1 | 50 | 112450.00 | short | ask | 24.1100 | 2.7000 | ["31","37.6"] | ["1.2620","2.2003"] | [] | ["XISX"] | 31.0000 | 37.6000 | 9 | 37 | false | false | |||||||||||
| 01a0aa6d-79d3-71a2-af03-a66a5a7f6643 | MULL | 2026-09-16 09:34 | call_diagonal_spread | 2 | 2 | 286 | 114824.00 | long | ask | 19.6894 | 1.7000 | ["25","27"] | ["1.3237","1.1970"] | [] | ["ARCO","XCBO"] | 25.0000 | 27.0000 | 30 | 93 | false | true | |||||||||||
| 01a0afa0-6c7b-77a3-8e10-4f076aab232d | MULL | 2026-09-17 09:48 | put_diagonal_spread | 2 | 1 | 50 | 132050.00 | short | ask | 22.0353 | 2.9000 | ["31","38"] | ["1.0885","9.6955"] | [] | ["BATO"] | 31.0000 | 38.0000 | 1 | 29 | false | false | |||||||||||
| 01a0aff9-69bb-7541-bc4e-e8cd3b36a8a4 | MULL | 2026-09-17 11:25 | call_diagonal_spread | 2 | 1 | 325 | 451750.00 | short | bid | 21.8800 | 1.8000 | ["15.2","16"] | ["4.1733","1.0686"] | [] | ["XPHO"] | 15.2000 | 16.0000 | 1 | 64 | false | false | |||||||||||
| 01a0b007-0233-7b02-bc76-1a7edf6f4f3c | MULL | 2026-09-17 11:40 | call_diagonal_spread | 2 | 2 | 478 | 120700.00 | unknown | — | 21.8400 | 0.8490 | ["31","36"] | ["1.2419","1.1570"] | [] | ["AMXO","XISX"] | 31.0000 | 36.0000 | 29 | 92 | false | true | true | true | |||||||||
| 01a0b012-9edb-71b0-8f93-a8a3cbd33433 | MULL | 2026-09-17 11:53 | call_diagonal_spread | 2 | 1 | 222 | 303696.00 | unknown | — | 21.8200 | 1.1000 | ["15.2","16"] | ["4.9832","1.0727"] | [] | ["XISX"] | 15.2000 | 16.0000 | 1 | 64 | false | false | true | true | |||||||||
| 01a0b080-7fc3-7c60-abae-ec2b41a9530c | MULL | 2026-09-17 13:53 | call_diagonal_spread | 2 | 1 | 400 | 146800.00 | long | ask | 21.6300 | 1.4500 | ["36","38"] | ["1.1456","1.1388"] | [] | ["XMIO"] | 36.0000 | 38.0000 | 92 | 120 | false | true | |||||||||||
| 01a0b081-6a23-7c70-8783-f71247165359 | MULL | 2026-09-17 13:54 | call_diagonal_spread | 2 | 1 | 500 | 188000.00 | unknown | — | 21.6400 | 1.3000 | ["36","38"] | ["1.1773","1.1311"] | [] | ["XMIO"] | 36.0000 | 38.0000 | 92 | 120 | false | true | true | true | |||||||||
| 01a0b085-d6f3-7293-907a-aae28f9e8579 | MULL | 2026-09-17 13:59 | call_calendar | 2 | 1 | 500 | 196500.00 | short | ask | 21.7085 | 2.5500 | ["36"] | ["1.1393"] | [] | ["XISX"] | 36.0000 | 36.0000 | 92 | 120 | false | true | true | ||||||||||
| 01a0c45e-b6e7-7811-a194-8a5420949e4a | MULL | 2026-09-21 10:28 | call_diagonal_spread | 2 | 1 | 300 | 273000.00 | long | bid | 24.4005 | 1.6000 | ["27","38"] | ["1.1416","1.1673"] | [] | ["XISX"] | 27.0000 | 38.0000 | 88 | 179 | false | true | |||||||||||
| 01a0c583-a32e-7ff3-9eba-c511c5e17361 | MULL | 2026-09-21 15:48 | call_diagonal_spread | 2 | 1 | 30 | 115230.00 | short | ask | 24.9000 | 3.5000 | ["5","6"] | ["4.8134","2.2344"] | [] | ["XPHO"] | 5.0000 | 6.0000 | 25 | 88 | false | false | |||||||||||
| 01a0c99e-347e-72a3-be4d-a158f1543407 | MULL | 2026-09-22 10:56 | call_vertical_spread | 2 | 1 | 300 | 322500.00 | long | ask | 26.1700 | 4.5000 | ["38","38.2"] | ["1.1734","1.1692"] | ["38.07"] | ["XMIO"] | 38.0000 | 38.2000 | 178 | 178 | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:36:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:06:30Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:13:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:35:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:48:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:25:53Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:40:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:53:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:54:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:55:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:59:44Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:28:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:48:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:56:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |