Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 rowsexportable
active:ticker = URI×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c9b5-6dcf-7502-bfcc-157034fa6273 | URI | 2026-09-22 11:21 | call_vertical_spread | 2 | 1 | 3 | 112290.00 | short | bid | 1046.1400 | 32.4000 | ["880","1240"] | ["0.3992","0.3722"] | ["1048.90"] | ["ARCO"] | 880.0000 | 1240.0000 | 360 | 360 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:22:12Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c997-9cff-7961-94f6-0259365418e4 | URI | 2026-09-22 10:49 | put_vertical_spread | 2 | 1 | 11 | 126148.00 | long | ask | 1045.3150 | 14.5000 | ["1030","1040"] | ["0.3949","0.3941"] | ["1035.26"] | ["C2OX"] | 1030.0000 | 1040.0000 | 59 | 59 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:49:33Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c576-2ddf-7563-a9f2-e5e4ad80f7a3 | URI | 2026-09-21 15:34 | straddle | 2 | 1 | 50 | 837500.00 | long | ask | 1028.5401 | 17.8000 | ["1040"] | ["0.3631"] | ["872.50","1207.50"] | ["SPHR"] | 1040.0000 | 1040.0000 | 116 | 116 | true | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:34:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c571-152e-7272-8d75-b4afb74b07a2 | URI | 2026-09-21 15:28 | call_vertical_spread | 2 | 1 | 3 | 110145.00 | short | bid | 1029.0900 | 25.8000 | ["1280","1300"] | ["0.3679","0.3675"] | ["1285.85"] | ["XPHO"] | 1280.0000 | 1300.0000 | 851 | 851 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:28:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c489-2247-7992-8d75-0224d8e0d603 | URI | 2026-09-21 11:15 | call_butterfly_spread | 3 | 1 | 22 | 105468.00 | short | bid | 1018.6700 | 22.9000 | ["990","1060","1120"] | ["0.3144","0.3204","0.3387"] | ["1010.60","1109.40"] | ["EDGO"] | 990.0000 | 1120.0000 | 25 | 25 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:15:31Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b54f-b6e7-7771-a0fa-659dfb978715 | URI | 2026-09-18 12:18 | other | 3 | 1 | 20 | 111360.00 | unknown | — | 1003.6450 | 20.5500 | ["960","1000"] | ["1.3772","0.6663"] | [] | ["XPHO"] | 960.0000 | 1000.0000 | 0 | 0 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:18:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b4-bec3-7e02-a2b4-20e51bd16420 | URI | 2026-09-17 14:50 | other | 4 | 1 | 19 | 524916.00 | unknown | — | 1004.9200 | 63.5000 | ["1120","1140","1160","1180"] | ["1.8795","2.0993","2.2754","2.4897"] | [] | ["XBOX"] | 1120.0000 | 1180.0000 | 1 | 1 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01c-7e33-7fb2-a211-57ad64687c90 | URI | 2026-09-17 12:04 | put_diagonal_spread | 2 | 2 | 6 | 105582.00 | unknown | — | 1013.4775 | 19.3000 | ["1020","1050"] | ["0.3982","0.3218"] | [] | ["ARCO","XISX"] | 1020.0000 | 1050.0000 | 22 | 273 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:04:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af8f-9fbb-7a03-bc86-60c66cc56954 | URI | 2026-09-17 09:30 | other | 4 | 1 | 6 | 188286.00 | unknown | — | 0.0000 | 79.1000 | ["1440","1480","1620","1760"] | ["0.4131","0.4099","0.3853","0.3793"] | [] | ["XISX"] | 1440.0000 | 1760.0000 | 491 | 855 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:09Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0a638-9566-7712-96ed-1944da7436a7 | URI | 2026-09-15 13:58 | call_vertical_spread | 2 | 2 | 10 | 192895.00 | short | bid | 985.2900 | 21.8000 | ["810","1170"] | ["0.4609","0.4377"] | ["985.46"] | ["ARCO","XPHO"] | 810.0000 | 1170.0000 | 38 | 38 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:58:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a593-606e-7f01-91cc-7d3f181597fc | URI | 2026-09-15 10:58 | call_diagonal_spread | 2 | 5 | 8 | 101318.00 | unknown | — | 985.1399 | 12.4000 | ["970","1040"] | ["0.3817","0.5173"] | [] | ["AMXO","ARCO","XCBO","XISX","XMIO"] | 970.0000 | 1040.0000 | 3 | 185 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:58:22Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09171-f3e0-7b11-8a43-5dea1d8fe1a2 | URI | 2026-09-11 13:09 | put_vertical_spread | 2 | 1 | 50 | 142989.00 | long | ask | 992.4754 | 10.8000 | ["900","950"] | ["0.3348","0.3254"] | ["938.29"] | ["XMIO"] | 900.0000 | 950.0000 | 35 | 35 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:09:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fd-6bd8-76c2-9650-4f474de9ab24 | URI | 2026-09-11 11:01 | call_diagonal_spread | 2 | 1 | 19 | 604371.00 | long | ask | 993.9850 | 18.6000 | ["940","1000"] | ["0.3794","0.3912"] | [] | ["XMIO"] | 940.0000 | 1000.0000 | 189 | 371 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:02:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c0f-9c68-79a2-b740-9f517a3e7685 | URI | 2026-09-10 12:03 | other | 2 | 1 | 10 | 1006600.00 | unknown | — | 992.5650 | 32.0000 | ["500"] | ["0.6531"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 99 | 280 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:04:08Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08682-58a8-7b33-9f7b-0e988d994a4f | URI | 2026-09-09 10:11 | put_vertical_spread | 2 | 1 | 10 | 107240.00 | long | ask | 1041.0815 | 19.6000 | ["1080","1090"] | ["0.4021","0.4044"] | ["1082.40"] | ["MCRY"] | 1080.0000 | 1090.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |