Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b595-5eef-7441-9e3a-6cbe79a06cb9 | GEV | 2026-09-18 13:34 | put_diagonal_spread | 2 | 1 | 135 | 2997000.00 | unknown | bid | 930.3600 | 13.1000 | ["920","960"] | ["0.4695","0.5010"] | [] | ["XBOX"] | 920.0000 | 960.0000 | 63 | 272 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:34:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4da-735f-7221-9d71-75f814ba3b52 | GEV | 2026-09-18 10:10 | put_diagonal_spread | 2 | 1 | 5 | 120345.00 | long | ask | 932.3300 | 14.9000 | ["1010","1040"] | ["0.5030","0.4783"] | [] | ["XISX"] | 1010.0000 | 1040.0000 | 28 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:10:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aaeb-48db-78f2-b18b-5659562ed84a | GEV | 2026-09-16 11:52 | put_diagonal_spread | 2 | 3 | 13 | 245624.00 | short | ask | 928.4445 | 13.6000 | ["910","1080"] | ["0.4580","1.3766"] | [] | ["BATO","SPHR","XMIO"] | 910.0000 | 1080.0000 | 2 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:53:12Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa87-cc1b-7c21-9e27-2123bcf4bd3e | GEV | 2026-09-16 10:03 | put_diagonal_spread | 2 | 1 | 15 | 159360.00 | long | bid | 898.6800 | 8.5000 | ["860","950"] | ["0.4952","0.6314"] | [] | ["XMIO"] | 860.0000 | 950.0000 | 2 | 65 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:03:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5e8-a876-7533-978e-236d0504db8e | GEV | 2026-09-15 12:31 | put_diagonal_spread | 2 | 1 | 5 | 125600.00 | short | bid | 878.4272 | 11.2000 | ["960","1000"] | ["0.4769","0.8905"] | [] | ["XCBO"] | 960.0000 | 1000.0000 | 3 | 94 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:31:49Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b4-b3ae-7de3-b37f-6f21360a4f2c | GEV | 2026-09-15 11:34 | put_diagonal_spread | 2 | 1 | 8 | 104720.00 | short | bid | 875.9150 | 8.6000 | ["890","940"] | ["0.4933","0.5300"] | [] | ["MCRY"] | 890.0000 | 940.0000 | 3 | 45 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:34:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a566-8fc6-7f43-bd5c-32faf36c180e | GEV | 2026-09-15 10:09 | put_diagonal_spread | 2 | 1 | 9 | 196074.00 | unknown | — | 894.0000 | 9.1000 | ["990","1000"] | ["0.4626","0.4980"] | [] | ["XISX"] | 990.0000 | 1000.0000 | 10 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:09:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a144-6208-7d22-82a5-cadd925cdbc7 | GEV | 2026-09-14 14:53 | put_diagonal_spread | 2 | 1 | 9 | 159219.00 | long | ask | 878.7500 | 12.3000 | ["860","900"] | ["0.4964","0.5049"] | [] | ["XCBO"] | 860.0000 | 900.0000 | 46 | 186 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:54:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a127-21c1-76e1-a528-76542052c275 | GEV | 2026-09-14 14:21 | put_diagonal_spread | 2 | 1 | 10 | 141990.00 | short | bid | 876.5800 | 10.2000 | ["860","940"] | ["0.4973","0.6113"] | [] | ["XISX"] | 860.0000 | 940.0000 | 4 | 95 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:21:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03e-7358-7162-b823-043ec87eccd5 | GEV | 2026-09-14 10:07 | put_diagonal_spread | 2 | 1 | 45 | 177975.00 | long | ask | 886.7850 | 10.7000 | ["870","875"] | ["0.5048","0.6118"] | [] | ["XMIO"] | 870.0000 | 875.0000 | 4 | 11 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03c-6bd0-74a2-8176-b37b008fe52d | GEV | 2026-09-14 10:05 | put_diagonal_spread | 2 | 1 | 45 | 202230.00 | long | ask | 880.3100 | 6.3000 | ["870","880"] | ["0.4859","0.5759"] | [] | ["XMIO"] | 870.0000 | 880.0000 | 4 | 11 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:05:26Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c12-6740-7641-b07a-7300063199c4 | GEV | 2026-09-10 12:06 | put_diagonal_spread | 2 | 1 | 5 | 103460.00 | long | ask | 927.4000 | 4.0000 | ["940","950"] | ["0.4838","0.4881"] | [] | ["XCBO"] | 940.0000 | 950.0000 | 99 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:06:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c12-6358-71a3-a859-3b937754054d | GEV | 2026-09-10 12:06 | put_diagonal_spread | 2 | 1 | 9 | 186111.00 | short | bid | 927.4000 | 4.4000 | ["940","950"] | ["0.4832","0.4882"] | [] | ["BATO"] | 940.0000 | 950.0000 | 99 | 127 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:06:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086a2-f068-7342-b66f-c60bf4ab07e8 | GEV | 2026-09-09 10:46 | put_diagonal_spread | 2 | 2 | 12 | 100764.00 | short | bid | 954.3700 | 6.6000 | ["960","975"] | ["0.5279","0.4933"] | [] | ["XISX"] | 960.0000 | 975.0000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:47:31Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |