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 | net_side |
|---|
| 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 |
|---|
| 01a08188-96a0-7a90-ad60-a7626c2f0091 | NRG | 2026-09-08 11:00 | other | 2 | 1 | 100 | 357500.00 | unknown | — | 120.3900 | 1.7000 | ["100","120"] | ["0.4575","0.5028"] | [] | ["XISX"] | 100.0000 | 120.0000 | 10 | 282 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:00:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a087bd-0f11-7400-9cf6-a8bb2197987f | NRG | 2026-09-09 15:55 | call_vertical_spread | 2 | 1 | 498 | 243024.00 | long | ask | 115.6800 | 1.0500 | ["145","170"] | ["0.4910","0.4953"] | ["147.50"] | ["ARCO"] | 145.0000 | 170.0000 | 100 | 100 | false | true | false | true | false | ||||||||
| 01a087bf-f159-71f2-8426-095c2e0f0be1 | NRG | 2026-09-09 15:58 | call_vertical_spread | 2 | 1 | 2000 | 960000.00 | long | ask | 115.5500 | 0.9500 | ["145","170"] | ["0.4932","0.4874"] | ["147.60"] | ["AMXO"] | 145.0000 | 170.0000 | 100 | 100 | false | true | false | true | false | ||||||||
| 01a0a04a-65f0-7f22-9782-eaf7232a2870 | NRG | 2026-09-14 10:20 | put_calendar | 2 | 1 | 32 | 311008.00 | short | bid | 109.0650 | 2.6000 | ["155"] | ["0.5344"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 186 | 276 | false | false | true | false | false | ||||||||
| 01a0a04a-65f0-7f22-9782-eae38c3624d6 | NRG | 2026-09-14 10:20 | put_calendar | 2 | 1 | 32 | 311008.00 | short | bid | 109.0650 | 2.6000 | ["155"] | ["0.5344"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 186 | 276 | false | false | true | false | false | ||||||||
| 01a0a04a-65f0-7f22-9782-ead9f8818717 | NRG | 2026-09-14 10:20 | put_calendar | 2 | 1 | 32 | 311072.00 | short | bid | 109.0650 | 2.6000 | ["155"] | ["0.5347"] | [] | ["AMXO"] | 155.0000 | 155.0000 | 186 | 276 | false | false | true | false | false | ||||||||
| 01a0a04a-6208-7900-b0bc-cccf0e441867 | NRG | 2026-09-14 10:20 | put_calendar | 2 | 2 | 64 | 622016.00 | short | bid | 109.0650 | 2.6000 | ["155"] | ["0.5344"] | [] | ["AMXO","XPHO"] | 155.0000 | 155.0000 | 186 | 276 | false | false | true | false | false | ||||||||
| 01a0a5dd-d6ee-71b2-8328-8fe17f0e9cbd | NRG | 2026-09-15 12:19 | call_diagonal_spread | 2 | 1 | 95 | 209950.00 | short | bid | 105.2550 | 2.8000 | ["100","114"] | ["0.4876","0.5158"] | [] | ["XMIO"] | 100.0000 | 114.0000 | 10 | 275 | true | false | true | true | false | ||||||||
| 01a0aacb-6c9a-7c33-a31f-88c77beb2c29 | NRG | 2026-09-16 11:17 | call_vertical_spread | 2 | 1 | 50 | 118900.00 | short | bid | 108.1799 | 1.6000 | ["105","110"] | ["0.5066","0.5063"] | ["107.36"] | ["XCBO"] | 105.0000 | 110.0000 | 93 | 93 | false | false | false | true | false | ||||||||
| 01a0afac-43bb-7e01-8781-a3891dde21a7 | NRG | 2026-09-17 10:01 | call_vertical_spread | 2 | 1 | 50 | 124950.00 | short | bid | 108.4350 | 4.4000 | ["105","110"] | ["0.5297","0.5318"] | ["107.31"] | ["XCBO"] | 105.0000 | 110.0000 | 92 | 92 | false | false | false | true | false | ||||||||
| 01a0b0b3-76a3-74f2-97ab-38cce21fcc43 | NRG | 2026-09-17 14:49 | put_ladder | 3 | 1 | 721 | 3135580.00 | unknown | — | 106.4700 | 6.0000 | ["120","135","140"] | ["1.5470","2.6308","3.2694"] | [] | ["XBOX"] | 120.0000 | 140.0000 | 1 | 1 | true | false | false | true | false | mlft | |||||||
| 01a0b0b5-14b3-7211-818f-e742189a1e9c | NRG | 2026-09-17 14:50 | put_ladder | 5 | 1 | 20 | 105880.00 | unknown | — | 106.2500 | 9.3000 | ["131","133","135","136","137"] | ["2.1537","1.9721","2.0834","2.4626","2.1922"] | [] | ["XBOX"] | 131.0000 | 137.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0c430-7327-74d0-938c-9b9661c2ca00 | NRG | 2026-09-21 09:38 | call_vertical_spread | 2 | 2 | 200 | 215600.00 | long | ask | 102.1200 | 3.4500 | ["110","130"] | ["0.5300","0.5219"] | ["114.94"] | ["ARCO"] | 110.0000 | 130.0000 | 88 | 88 | false | true | false | true | false | ||||||||
| 01a0c435-a347-7873-8207-5885d092dd79 | NRG | 2026-09-21 09:44 | call_vertical_spread | 2 | 1 | 160 | 155040.00 | long | ask | 101.3856 | 2.1000 | ["110","130"] | ["0.5034","0.5162"] | ["114.33"] | ["C2OX"] | 110.0000 | 130.0000 | 88 | 88 | false | true | false | true | false | ||||||||
| 01a0c9be-6e7f-72d3-9db2-4607fba3ec5a | NRG | 2026-09-22 11:31 | call_diagonal_spread | 2 | 1 | 15000 | 4090000.00 | unknown | ask | 103.7150 | 0.4500 | ["120","125"] | ["0.5125","0.4918"] | [] | ["XBOX"] | 120.0000 | 125.0000 | 24 | 59 | false | true | true | true | false | ||||||||
| 01a0ca94-40c7-7b32-ba5c-0d3b7b49ba80 | NRG | 2026-09-22 15:25 | call_ladder | 3 | 2 | 27500 | 7560000.00 | unknown | ask | 103.3350 | 1.7000 | ["125","145","170"] | ["0.5108","0.4982","0.5076"] | ["125.15","159.18"] | ["AMXO"] | 125.0000 | 170.0000 | 87 | 87 | false | true | false | true | false | ||||||||
| 01a0ca9c-66b7-7e60-a9b5-0efa8f698754 | NRG | 2026-09-22 15:33 | call_diagonal_spread | 2 | 1 | 100 | 128000.00 | long | ask | 103.3700 | 1.2000 | ["105","120"] | ["0.4936","0.5014"] | [] | ["XMIO"] | 105.0000 | 120.0000 | 59 | 87 | false | true | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:55:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:58:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:20:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:20:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:20:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:20:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:19:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:17:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:01:39Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:49:10Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:51:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:38:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:44:15Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:31:44Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:25:08Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:34:02Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |