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 |
|---|
| 01a0c56b-c5ce-7f00-bdaf-4caab1c47752 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 9 | 112770.00 | unknown | ask | 369.9750 | 2.5500 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:22:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56b-c5ce-7f00-bdaf-4c97b5d1b394 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 6 | 75180.00 | unknown | ask | 369.9750 | 2.6000 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | ||||||||||
| 01a0c56b-c5ce-7f00-bdaf-4c8372730363 | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 3 | 37590.00 | unknown | ask | 369.9750 | 2.6000 | ["460","470"] | ["0.5793","0.5636"] | ["272.05","595.30"] | ["XISX"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | ||||||||||
| 01a0c56b-c5ce-7f00-bdaf-4c6849b0f4fe | PANW | 2026-09-21 15:22 | ratio_risk_reversal | 2 | 1 | 3 | 37490.00 | unknown | ask | 369.9750 | 2.0000 | ["460","470"] | ["0.5742","0.5644"] | ["272.55","594.97"] | ["XCBO"] | 460.0000 | 470.0000 | 269 | 269 | false | false | false | ||||||||||
| 01a0c4c9-24fe-7a70-bb60-e2f9164b2830 | PANW | 2026-09-21 12:25 | call_diagonal_spread | 2 | 2 | 15 | 35625.00 | unknown | bid | 370.5700 | 1.2000 | ["367.5","370"] | ["0.5060","0.5582"] | [] | ["C2OX"] | 367.5000 | 370.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c466-7747-78e3-965f-0947c49cb386 | PANW | 2026-09-21 10:37 | call_diagonal_spread | 2 | 1 | 201 | 4426020.00 | unknown | ask | 373.3000 | 10.5500 | ["440","500"] | ["0.5751","0.5670"] | [] | ["XISX"] | 440.0000 | 500.0000 | 816 | 851 | false | true | true | ||||||||||
| 01a0b602-6ce8-78b2-942e-3b8d3923e50e | PANW | 2026-09-18 15:33 | straddle | 2 | 1 | 33 | 396990.00 | long | ask | 361.8050 | 1.1000 | ["400"] | ["0.5599"] | ["279.70","520.30"] | ["ARCO"] | 400.0000 | 400.0000 | 182 | 182 | false | false | false | false | |||||||||
| 01a0b5f5-1ac0-7812-9759-835519b642a9 | PANW | 2026-09-18 15:18 | call_diagonal_spread | 2 | 1 | 3 | 62220.00 | short | ask | 361.9600 | 8.5000 | ["260","300"] | ["28.1101","0.5382"] | [] | ["MCRY"] | 260.0000 | 300.0000 | 0 | 272 | false | false | true | ||||||||||
| 01a0b597-ef30-7e63-a082-2334a370ec1c | PANW | 2026-09-18 13:37 | put_diagonal_spread | 2 | 1 | 10 | 28050.00 | unknown | bid | 362.5400 | 6.1500 | ["372.5","375"] | ["0.4702","1.5834"] | [] | ["C2OX"] | 372.5000 | 375.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a0b591-1548-7290-bbca-29bca94b38fd | PANW | 2026-09-18 13:29 | put_vertical_spread | 2 | 2 | 20 | 47500.00 | short | bid | 361.1100 | 1.2500 | ["280","290"] | ["0.5510","0.5432"] | ["287.85"] | ["C2OX"] | 280.0000 | 290.0000 | 119 | 119 | false | true | false | ||||||||||
| 01a0b4fb-2677-7540-8af3-13ee6bd14148 | PANW | 2026-09-18 10:45 | call_diagonal_spread | 2 | 1 | 3 | 97110.00 | short | bid | 359.6900 | 9.5500 | ["200","210"] | ["13.5649","0.5303"] | [] | ["MCRY"] | 200.0000 | 210.0000 | 0 | 272 | false | false | true | ||||||||||
| 01a0b0df-83fb-7602-8564-34556831a0a5 | PANW | 2026-09-17 15:37 | call_diagonal_spread | 2 | 1 | 9 | 59670.00 | short | bid | 376.9200 | 2.3000 | ["350","400"] | ["0.9309","0.5361"] | [] | ["XCBO"] | 350.0000 | 400.0000 | 1 | 120 | false | false | true | ||||||||||
| 01a0afbb-0ce3-7960-9b37-35cbc50236f4 | PANW | 2026-09-17 10:17 | call_diagonal_spread | 2 | 1 | 5 | 30150.00 | unknown | — | 378.4300 | 4.9500 | ["350","410"] | ["1.0259","0.5555"] | [] | ["XCBO"] | 350.0000 | 410.0000 | 1 | 92 | false | false | true | true | false | ||||||||
| 01a0ab48-3203-7492-938e-8b8ef420eb75 | PANW | 2026-09-16 13:33 | call_calendar | 2 | 1 | 6 | 198450.00 | short | bid | 380.4500 | 5.4000 | ["220"] | ["2.0630"] | [] | ["XCBO"] | 220.0000 | 220.0000 | 2 | 184 | false | false | true | false | |||||||||
| 01a0aa8b-71b3-7181-a4c8-7e41f688b32b | PANW | 2026-09-16 10:07 | call_diagonal_spread | 2 | 1 | 9 | 69525.00 | unknown | — | 380.2450 | 5.0000 | ["345","350"] | ["0.8291","0.5354"] | [] | ["XCBO"] | 345.0000 | 350.0000 | 2 | 30 | false | false | true | true | false | ||||||||
| 01a0a600-10a6-7e92-babb-08c8a3d68262 | PANW | 2026-09-15 12:56 | call_diagonal_spread | 2 | 1 | 10 | 63050.00 | unknown | — | 380.0100 | 7.5500 | ["335","380"] | ["1.0909","0.5508"] | [] | ["C2OX"] | 335.0000 | 380.0000 | 3 | 17 | false | false | true | true | false | ||||||||
| 01a0a5ed-8a76-7e31-b970-5989c3b37d21 | PANW | 2026-09-15 12:36 | put_vertical_spread | 2 | 2 | 10 | 37200.00 | short | bid | 378.8400 | 4.7500 | ["360","370"] | ["0.5370","0.5312"] | ["365.90"] | ["C2OX"] | 360.0000 | 370.0000 | 38 | 38 | false | true | false | ||||||||||
| 01a0a547-ad86-7020-86ce-28e7f12b37b4 | PANW | 2026-09-15 09:35 | strangle | 2 | 1 | 10 | 25650.00 | unknown | — | 372.2500 | 3.5500 | ["350","400"] | ["0.5273","0.5429"] | [] | ["C2OX"] | 350.0000 | 400.0000 | 31 | 31 | false | true | false | true | true | mesl | |||||||
| 01a0a145-c968-7673-a9b1-900a6498ef1a | PANW | 2026-09-14 14:54 | call_diagonal_spread | 2 | 1 | 5 | 38750.00 | short | bid | 376.8700 | 3.2700 | ["340","390"] | ["0.6991","0.5673"] | [] | ["XCBO"] | 340.0000 | 390.0000 | 4 | 95 | false | false | true | ||||||||||
| 01a0a100-92a8-7272-8b54-e6c3758e84c0 | PANW | 2026-09-14 13:39 | call_diagonal_spread | 2 | 3 | 7 | 25665.00 | short | bid | 376.6801 | 4.3929 | ["590","610"] | ["0.5813","0.5655"] | [] | ["C2OX"] | 590.0000 | 610.0000 | 186 | 276 | false | true | true | ||||||||||
| 01a0a048-1049-7972-a78f-8bbeaa2cabb7 | PANW | 2026-09-14 10:17 | call_vertical_spread | 2 | 1 | 5 | 28600.00 | short | bid | 365.8017 | 3.3500 | ["330","360"] | ["0.5726","0.6011"] | ["350.40"] | ["C2OX"] | 330.0000 | 360.0000 | 11 | 11 | false | false | false | ||||||||||
| 01a0a038-06d1-77f1-a0d5-48d45f5d7861 | PANW | 2026-09-14 10:00 | other | 4 | 1 | 12 | 51000.00 | unknown | — | 355.2450 | 8.0500 | ["320","330","350","360"] | ["0.5112","0.5196","0.5209","0.5119"] | [] | ["XCBO"] | 320.0000 | 360.0000 | 32 | 32 | false | false | false | true | false | ||||||||
| 01a09119-44c0-7fe3-95fe-665ef2a530f2 | PANW | 2026-09-11 11:32 | other | 2 | 1 | 10 | 104600.00 | unknown | — | 329.8900 | 8.3500 | ["380"] | ["0.5618"] | [] | ["XCBO"] | 380.0000 | 380.0000 | 7 | 35 | false | false | true | false | false | mesl |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:22:58Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:25:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:37:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:33:26Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:18:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:37:27Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:29:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:45:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:37:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:17:52Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:34:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:08:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:57:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:36:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:55:03Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mesl |
| tracked |
| 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 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:18:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:00:30Z"} |
| 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-11T15:33:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |