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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0a0e2-6418-74a1-b0c9-a257099e52f2 | UPRO | 2026-09-14 13:06 | put_vertical_spread | 2 | 1 | 102 | 195840.00 | long | ask | 147.0900 | 1.3000 | ["131","145"] | ["0.5148","0.4613"] | ["140.48"] | ["EDGO"] | 131.0000 | 145.0000 | 95 | 95 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:06:46Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e1-5a79-7603-8025-f0fe8e4b800f | UPRO | 2026-09-14 13:05 | put_vertical_spread | 2 | 1 | 70 | 132020.00 | long | ask | 147.1276 | 2.3000 | ["135","140"] | ["0.5064","0.4875"] | ["138.40"] | ["XCBO"] | 135.0000 | 140.0000 | 95 | 95 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:05:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0df-04d0-7ea1-9956-9ea0d17497bd | UPRO | 2026-09-14 13:02 | put_vertical_spread | 2 | 2 | 400 | 430200.00 | long | ask | 147.1600 | 1.1000 | ["135","140"] | ["0.4954","0.4660"] | ["138.72"] | ["C2OX","EDGO"] | 135.0000 | 140.0000 | 46 | 46 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:03:32Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |