core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0e852-d0e7-7393-8a93-7be7a47b761b | BNO | 2026-09-28 10:02 | other | 4 | 1 | 195 | 348660.00 | unknown | bid | 60.4200 | 2.2000 | ["55","70"] | ["0.5942","0.5927"] | [] | ["XCBO"] | 55.0000 | 70.0000 | 18 | 53 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T14:02:32Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d4ab-17ce-7812-80a1-81929d625a37 | BNO | 2026-09-24 14:26 | call_vertical_spread | 2 | 3 | 500 | 142250.00 | unknown | bid | 61.1400 | 0.3000 | ["65","70"] | ["0.5621","0.5909"] | ["67.84"] | ["XCBO","XISX","XPHO"] | 65.0000 | 70.0000 | 22 | 22 | false | true | |||||||||||
| 01a0d443-5167-7b23-8e98-3fe682992e38 | BNO | 2026-09-24 12:32 | call_calendar | 2 | 1 | 340 | 333200.00 | unknown | bid | 61.0500 | 2.0000 | ["60"] | ["0.5411"] | [] | ["XBOX"] | 60.0000 | 60.0000 | 22 | 57 | false | false | |||||||||||
| 01a0cfd5-25bf-7430-92f5-fc442e7ddaa0 | BNO | 2026-09-23 15:54 | call_vertical_spread | 2 | 1 | 50 | 112300.00 | short | bid | 60.2750 | 0.7000 | ["45","65"] | ["0.5325","0.5173"] | ["56.70"] | ["XMIO"] | 45.0000 | 65.0000 | 114 | 114 | false | false | |||||||||||
| 01a0cf97-8467-7b33-9668-223e14f5f50e | BNO | 2026-09-23 14:46 | call_calendar | 2 | 1 | 90 | 114374.00 | long | bid | 60.4400 | 1.0000 | ["60"] | ["0.5115"] | [] | ["XMIO"] | 60.0000 | 60.0000 | 58 | 114 | false | false | true | ||||||||||
| 01a0c9f8-c7ff-78d3-aac4-69de90146141 | BNO | 2026-09-22 12:35 | call_ratio_spread | 2 | 2 | 138 | 125038.00 | unknown | bid | 58.9100 | 0.4000 | ["50","60"] | ["0.5493","0.5246"] | ["61.44"] | ["XPHO"] | 50.0000 | 60.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c9f8-c7ff-78d3-aac4-69c238235b9e | BNO | 2026-09-22 12:35 | call_ratio_spread | 2 | 3 | 435 | 393385.00 | unknown | bid | 58.9100 | 0.4000 | ["50","60"] | ["0.5445","0.5231"] | ["61.43"] | ["XPHO"] | 50.0000 | 60.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c9f0-8e87-7783-879e-d8b54a121c30 | BNO | 2026-09-22 12:26 | call_ratio_spread | 2 | 3 | 434 | 324632.00 | unknown | bid | 58.9500 | 0.4000 | ["50","60"] | ["0.5348","0.5216"] | ["61.65"] | ["XPHO"] | 50.0000 | 60.0000 | 24 | 24 | false | false | |||||||||||
| 01a0a5af-77d5-7150-a605-4ab3759605d6 | BNO | 2026-09-15 11:28 | call_vertical_spread | 2 | 1 | 114 | 210786.00 | short | bid | 63.3900 | 0.6000 | ["55","56"] | ["0.5731","0.5761"] | ["55.75"] | ["XCBO"] | 55.0000 | 56.0000 | 31 | 31 | false | false | |||||||||||
| 01a0a02e-eac8-7ac3-9263-8e105fe8e066 | BNO | 2026-09-14 09:50 | call_vertical_spread | 2 | 1 | 100 | 234600.00 | short | bid | 63.8100 | 1.1000 | ["50","65"] | ["0.4965","0.5066"] | ["58.80"] | ["XMIO"] | 50.0000 | 65.0000 | 123 | 123 | false | false | |||||||||||
| 01a090b4-be61-7421-a13c-6ca45da4f4ee | BNO | 2026-09-11 09:42 | call_vertical_spread | 2 | 1 | 107 | 172912.00 | short | bid | 60.9800 | 0.8000 | ["56","64"] | ["0.4869","0.5035"] | ["59.60"] | ["C2OX"] | 56.0000 | 64.0000 | 126 | 126 | false | false | |||||||||||
| 01a08cd0-0638-7781-ac5b-fe04b5965fdb | BNO | 2026-09-10 15:33 | call_vertical_spread | 2 | 1 | 140 | 399560.00 | short | bid | 63.0200 | 0.6000 | ["44","55"] | ["0.6836","0.5485"] | ["53.70"] | ["BATO"] | 44.0000 | 55.0000 | 36 | 36 | false | false | |||||||||||
| 01a08cce-7bb0-7463-837b-944997ca6c6d | BNO | 2026-09-10 15:32 | call_vertical_spread | 2 | 2 | 50 | 142500.00 | short | bid | 63.0400 | 1.8000 | ["44","55"] | ["0.8992","0.5416"] | ["53.70"] | ["XMIO"] | 44.0000 | 55.0000 | 36 | 36 | false | false | |||||||||||
| 01a08c18-6668-7e73-8f44-4bb0505a1c41 | BNO | 2026-09-10 12:13 | call_calendar | 2 | 1 | 160 | 116800.00 | short | bid | 62.5000 | 0.4500 | ["70"] | ["0.5573"] | [] | ["BATO"] | 70.0000 | 70.0000 | 36 | 127 | false | true | |||||||||||
| 01a08bf3-5a09-7320-a664-98b43f2013d9 | BNO | 2026-09-10 11:32 | call_diagonal_spread | 2 | 2 | 256 | 534272.00 | long | bid | 61.9000 | 0.6000 | ["50","60"] | ["0.5307","0.4897"] | [] | ["BATO","C2OX"] | 50.0000 | 60.0000 | 36 | 127 | false | false | |||||||||||
| 01a08bf3-5a09-7320-a664-989f555fb68f | BNO | 2026-09-10 11:32 | call_diagonal_spread | 2 | 3 | 440 | 919560.00 | long | bid | 61.9000 | 0.6000 | ["50","60"] | ["0.5356","0.4908"] | [] | ["EMLD","SPHR","XPHO"] | 50.0000 | 60.0000 | 36 | 127 | false | false | |||||||||||
| 01a08bf3-5a09-7320-a664-9884ecc8853e | BNO | 2026-09-10 11:32 | call_diagonal_spread | 2 | 5 | 583 | 1216949.00 | long | bid | 61.9000 | 0.6000 | ["50","60"] | ["0.5313","0.4898"] | [] | ["EMLD","SPHR","XBOX"] | 50.0000 | 60.0000 | 36 | 127 | false | false | |||||||||||
| 01a08b87-49f9-7361-8f6b-c299f9716c1b | BNO | 2026-09-10 09:34 | call_vertical_spread | 2 | 2 | 49 | 151116.00 | short | bid | 61.3350 | 1.7000 | ["45","52"] | ["0.5087","0.5065"] | ["50.20"] | ["AMXO","ARCO"] | 45.0000 | 52.0000 | 127 | 127 | false | false | |||||||||||
| 01a08264-ae61-7d00-b82b-fb4bfee83d0c | BNO | 2026-09-08 15:00 | call_diagonal_spread | 2 | 1 | 100 | 306900.00 | long | bid | 57.5850 | 0.6000 | ["40","45"] | ["0.7658","0.5381"] | [] | ["XCBO"] | 40.0000 | 45.0000 | 10 | 38 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:26:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:33:07Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:54:09Z"} |
| 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-23T18:47:20Z"} |
| 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-22T16:36:04Z"} |
| 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-22T16:36:04Z"} |
| 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-22T16:26:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:29:25Z"} |
| 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-14T13:50:24Z"} |
| 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-11T13:42:41Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:34:00Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:32:20Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:13:49Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:32:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:32:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:32:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:34:57Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:01:06Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |