Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c471-8b37-72d0-b7b5-6e7c41938301 | UPRO | 2026-09-21 10:49 | call_diagonal_spread | 2 | 1 | 25 | 289850.00 | short | ask | 151.6300 | 6.4000 | ["95","125"] | ["0.5363","0.4299"] | [] | ["XPHO"] | 95.0000 | 125.0000 | 116 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:49:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c470-6257-7ef3-89f9-817108404a54 | UPRO | 2026-09-21 10:48 | call_diagonal_spread | 2 | 1 | 13 | 124150.00 | short | ask | 151.5900 | 8.0000 | ["125","144"] | ["0.4503","0.4183"] | [] | ["XISX"] | 125.0000 | 144.0000 | 487 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:48:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46e-4f17-7491-b7a3-5b0baea78441 | UPRO | 2026-09-21 10:45 | call_diagonal_spread | 2 | 1 | 15 | 161400.00 | short | ask | 151.3416 | 8.6000 | ["100","133"] | ["0.5594","0.4332"] | [] | ["XMIO"] | 100.0000 | 133.0000 | 116 | 851 | false | false | true | 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 |
| 01a0c466-541f-7be2-bf30-f8cccdedae33 | UPRO | 2026-09-21 10:37 | call_diagonal_spread | 2 | 1 | 10 | 115230.00 | unknown | ask | 151.6750 | 6.8000 | ["95","111"] | ["0.5024","0.4582"] | [] | ["XPHO"] | 95.0000 | 111.0000 | 116 | 487 | false | false | true | true | false | mlet | 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 |
| 01a0c449-7197-7520-bb59-a3e0d643bb31 | UPRO | 2026-09-21 10:05 | call_diagonal_spread | 2 | 1 | 22 | 250822.00 | short | ask | 150.4400 | 9.8000 | ["110","125"] | ["0.4794","0.4383"] | [] | ["XCBO"] | 110.0000 | 125.0000 | 487 | 851 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:05:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b60a-777f-7302-8cd5-c0db42ca4141 | UPRO | 2026-09-18 15:42 | call_diagonal_spread | 2 | 1 | 21 | 155274.00 | short | bid | 146.9700 | 2.7000 | ["110","115"] | ["24.1980","0.4946"] | [] | ["AMXO"] | 110.0000 | 115.0000 | 0 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:42:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f9-2db7-7fb2-9652-315e96da90ff | UPRO | 2026-09-18 15:23 | call_diagonal_spread | 2 | 1 | 60 | 433560.00 | short | bid | 146.9650 | 1.1000 | ["112","115"] | ["15.6392","0.5006"] | [] | ["SPHR"] | 112.0000 | 115.0000 | 0 | 119 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:23:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f7-64af-7800-81b8-792036aa9ea1 | UPRO | 2026-09-18 15:21 | call_diagonal_spread | 2 | 4 | 23 | 133277.00 | short | ask | 147.0150 | 2.4478 | ["105","140"] | ["19.7610","0.4030"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 105.0000 | 140.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:21:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab94-8ce3-7b53-8c2b-cd1462b1cb16 | UPRO | 2026-09-16 14:57 | call_diagonal_spread | 2 | 1 | 17 | 113407.00 | unknown | — | 142.2350 | 5.0000 | ["110","115"] | ["2.6528","0.5880"] | [] | ["XISX"] | 110.0000 | 115.0000 | 2 | 93 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:57:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a58e-72b6-7831-9b82-853d071967cb | UPRO | 2026-09-15 10:52 | call_diagonal_spread | 2 | 1 | 296 | 2055720.00 | long | bid | 143.4399 | 2.1000 | ["109","110"] | ["1.7095","0.6556"] | [] | ["ARCO"] | 109.0000 | 110.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58e-5f2e-75d3-8095-6b5096e408cf | UPRO | 2026-09-15 10:52 | call_diagonal_spread | 2 | 1 | 100 | 697900.00 | long | bid | 143.4399 | 2.4000 | ["109","110"] | ["1.8682","0.6858"] | [] | ["ARCO"] | 109.0000 | 110.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58e-5376-71b1-b963-8af5c3c11a7a | UPRO | 2026-09-15 10:52 | call_diagonal_spread | 2 | 1 | 100 | 698900.00 | long | bid | 143.3979 | 3.0000 | ["109","110"] | ["1.9467","0.6989"] | [] | ["EDGO"] | 109.0000 | 110.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:53:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a581-dff6-7383-b8df-0a8d97cd8ab5 | UPRO | 2026-09-15 10:39 | call_diagonal_spread | 2 | 1 | 500 | 3525000.00 | long | bid | 143.8300 | 2.6000 | ["109","110"] | ["1.8214","0.6907"] | [] | ["ARCO"] | 109.0000 | 110.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:39:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a581-d056-7592-a9c2-b944b9df1eec | UPRO | 2026-09-15 10:39 | call_diagonal_spread | 2 | 1 | 500 | 3527000.00 | long | ask | 143.8300 | 2.9000 | ["109","110"] | ["1.8122","0.6991"] | [] | ["EDGO"] | 109.0000 | 110.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:39:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a581-c886-7f81-b313-ef24fe5cd9ad | UPRO | 2026-09-15 10:38 | call_diagonal_spread | 2 | 1 | 500 | 3545000.00 | long | bid | 143.8300 | 4.0000 | ["109","110"] | ["1.9834","0.7235"] | [] | ["ARCO"] | 109.0000 | 110.0000 | 3 | 31 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:39:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0871a-2fc0-74b3-a6d7-5dd4201308f4 | UPRO | 2026-09-09 12:57 | call_diagonal_spread | 2 | 1 | 50 | 348500.00 | unknown | — | 147.2701 | 5.3000 | ["113","117"] | ["0.9420","0.5121"] | [] | ["XISX"] | 113.0000 | 117.0000 | 9 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:57:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |