core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d45f-0b0f-7382-a762-923696665d1c | RCL | 2026-09-24 13:03 | put_calendar | 2 | 6 | 27 | 344364.00 | short | ask | 242.5300 | 4.1000 | ["300"] | ["0.4776"] | [] | ["AMXO","ARCO","XCBO","XISX","XMIO","XPHO"] | 300.0000 | 300.0000 | 85 | 176 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T17:03:16Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cfd6-6226-7fd0-a9a0-0d62466e0883 | RCL | 2026-09-23 15:55 | put_vertical_spread | 2 | 1 | 7000 | 31927000.00 | short | bid | 229.6500 | 3.6000 | ["220","250"] | ["0.4657","0.4480"] | ["233.95"] | ["SPHR"] | 220.0000 | 250.0000 | 86 | 86 | false | false | |||||||||||
| 01a0cf5a-8eef-7f62-b3c9-333e3615a81c | RCL | 2026-09-23 13:40 | put_vertical_spread | 2 | 5 | 98 | 150440.00 | short | bid | 226.6300 | 1.8000 | ["200","210"] | ["0.4899","0.4820"] | ["207.00"] | ["ARCO","BATO","C2OX","EMLD","SPHR"] | 200.0000 | 210.0000 | 58 | 58 | false | true | |||||||||||
| 01a0ca08-b61f-7650-a043-0ec64e00092a | RCL | 2026-09-22 12:52 | put_calendar | 2 | 1 | 9 | 103293.00 | short | ask | 254.0100 | 3.7000 | ["300"] | ["0.4400"] | [] | ["XCBO"] | 300.0000 | 300.0000 | 115 | 268 | false | false | |||||||||||
| 01a0c46e-629f-7fd1-8f77-42c6d906221d | RCL | 2026-09-21 10:46 | call_diagonal_spread | 2 | 1 | 5 | 115095.00 | short | bid | 249.0400 | 4.2000 | ["145","155"] | ["0.3437","0.3177"] | [] | ["BATO"] | 145.0000 | 155.0000 | 487 | 851 | false | false | |||||||||||
| 01a0c46e-629f-7fd1-8f77-42b57c0db7ca | RCL | 2026-09-21 10:46 | call_diagonal_spread | 2 | 1 | 25 | 575475.00 | short | bid | 249.0400 | 4.2000 | ["145","155"] | ["0.3437","0.3177"] | [] | ["BATO"] | 145.0000 | 155.0000 | 487 | 851 | false | false | |||||||||||
| 01a0b5d0-ba3f-7aa0-838d-2067f8e83ffb | RCL | 2026-09-18 14:39 | put_calendar | 2 | 1 | 20 | 207420.00 | short | ask | 246.7978 | 3.5000 | ["290"] | ["0.4273"] | [] | ["XPHO"] | 290.0000 | 290.0000 | 119 | 182 | false | false | |||||||||||
| 01a0b0a2-9a3b-7830-a2ac-7f78fc85f2e8 | RCL | 2026-09-17 14:30 | call_calendar | 2 | 1 | 28 | 369628.00 | short | bid | 251.4400 | 5.6000 | ["200"] | ["0.4200"] | [] | ["XPHO"] | 200.0000 | 200.0000 | 183 | 273 | false | false | |||||||||||
| 01a0af91-af0b-7e52-ac02-2c3ef75b7e85 | RCL | 2026-09-17 09:32 | put_diagonal_spread | 2 | 1 | 10 | 107450.00 | short | bid | 257.3900 | 6.5000 | ["300","310"] | ["0.4388","2.7661"] | [] | ["AMXO"] | 300.0000 | 310.0000 | 1 | 183 | false | false | |||||||||||
| 01a0abbf-4e33-7800-b2b4-18559e80c642 | RCL | 2026-09-16 15:43 | call_diagonal_spread | 2 | 1 | 11 | 175681.00 | short | ask | 252.8850 | 3.8000 | ["170","190"] | ["0.3229","0.3765"] | [] | ["XISX"] | 170.0000 | 190.0000 | 121 | 274 | false | false | |||||||||||
| 01a0a606-65be-7c01-99cb-6dde92f6b3de | RCL | 2026-09-15 13:03 | put_diagonal_spread | 2 | 1 | 58 | 177248.00 | short | bid | 251.5900 | 2.0000 | ["250","260"] | ["0.4355","0.6004"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a600-56f5-7ee0-8584-f9fbcd546ee6 | RCL | 2026-09-15 12:57 | put_diagonal_spread | 2 | 1 | 58 | 182700.00 | short | bid | 250.9500 | 3.9000 | ["250","260"] | ["0.4374","0.6145"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a600-56f5-7ee0-8584-f9e1f4e035f3 | RCL | 2026-09-15 12:57 | put_diagonal_spread | 2 | 1 | 58 | 179220.00 | short | bid | 250.9500 | 3.0000 | ["250","260"] | ["0.4314","0.5743"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a5f8-6f86-76e3-9017-30445a01eed6 | RCL | 2026-09-15 12:48 | put_diagonal_spread | 2 | 1 | 58 | 185368.00 | short | bid | 250.5263 | 1.8000 | ["250","260"] | ["0.4363","0.6172"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a5f7-f66e-7fc1-92b3-66ae06344956 | RCL | 2026-09-15 12:48 | put_diagonal_spread | 2 | 1 | 58 | 185136.00 | short | bid | 250.5700 | 1.9000 | ["250","260"] | ["0.4363","0.6188"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a5f7-f66e-7fc1-92b3-669443a8d408 | RCL | 2026-09-15 12:48 | put_diagonal_spread | 2 | 1 | 58 | 185136.00 | short | bid | 250.5700 | 1.9000 | ["250","260"] | ["0.4363","0.6188"] | [] | ["C2OX"] | 250.0000 | 260.0000 | 3 | 94 | false | false | |||||||||||
| 01a0a03e-6b88-7430-add1-a26367ea8a09 | RCL | 2026-09-14 10:07 | put_diagonal_spread | 2 | 1 | 40 | 120160.00 | short | ask | 254.6600 | 2.2000 | ["240","250"] | ["0.4352","0.4410"] | [] | ["ARCO"] | 240.0000 | 250.0000 | 67 | 95 | false | true | |||||||||||
| 01a0a03e-6b88-7430-add1-a247ca7e1360 | RCL | 2026-09-14 10:07 | put_diagonal_spread | 2 | 2 | 62 | 185070.00 | short | ask | 254.6600 | 2.7000 | ["240","250"] | ["0.4346","0.4373"] | [] | ["ARCO","C2OX"] | 240.0000 | 250.0000 | 67 | 95 | false | true | |||||||||||
| 01a08bb5-d408-77d1-8980-43a05fabceed | RCL | 2026-09-10 10:25 | put_vertical_spread | 2 | 1 | 12750 | 56100000.00 | short | bid | 261.3850 | 2.4000 | ["250","270"] | ["0.4466","0.4366"] | ["260.30"] | ["SPHR"] | 250.0000 | 270.0000 | 99 | 99 | false | false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:55:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:40:15Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:53:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:46:14Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:46:14Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:39:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:30:58Z"} |
| 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-17T13:32:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:44:07Z"} |
| 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-15T17:04:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:57:57Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:57:57Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:48:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:48:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:48:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:07:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:07:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:26:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |