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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61c-1350-7bc0-937c-01ed20f2b4dc | SOXL | 2026-09-18 16:01 | call_diagonal_spread | 2 | 1 | 156 | 267540.00 | unknown | ask | 123.3300 | 3.1500 | ["115","119"] | ["39.8918","0.8632"] | [] | ["C2OX"] | 115.0000 | 119.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:01:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-9397-70e1-b946-f8950f34a288 | SOXL | 2026-09-18 14:50 | call_diagonal_spread | 2 | 1 | 34 | 336828.00 | unknown | ask | 118.2400 | 6.0500 | ["65","70"] | ["1.1341","1.1125"] | [] | ["XISX"] | 65.0000 | 70.0000 | 35 | 42 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c2-0888-7a43-8b88-2bb45410db80 | SOXL | 2026-09-18 14:23 | call_diagonal_spread | 2 | 1 | 10 | 168250.00 | unknown | — | 118.4400 | 6.5000 | ["40","60"] | ["0.9183","0.9309"] | [] | ["XCBO"] | 40.0000 | 60.0000 | 490 | 854 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:23:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f6-86e0-76d1-8b72-12fe3ac03dab | SOXL | 2026-09-18 10:40 | call_diagonal_spread | 2 | 2 | 474 | 329904.00 | unknown | ask | 118.3400 | 2.0900 | ["115","250"] | ["1.3104","1.0553"] | [] | ["ARCO"] | 115.0000 | 250.0000 | 0 | 91 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c9-ae68-7201-8975-946da5d2fd8b | SOXL | 2026-09-18 09:51 | call_diagonal_spread | 2 | 1 | 30 | 138150.00 | unknown | ask | 118.3500 | 1.6500 | ["110","130"] | ["1.0565","1.0753"] | [] | ["BATO"] | 110.0000 | 130.0000 | 42 | 119 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b6-39f0-70a2-aa39-0b0e164991d7 | SOXL | 2026-09-18 09:30 | call_diagonal_spread | 2 | 1 | 9 | 131328.00 | unknown | bid | 117.5000 | 8.5000 | ["60","104"] | ["1.0109","0.9902"] | [] | ["AMXO"] | 60.0000 | 104.0000 | 490 | 854 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:30:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b5-c0d9-7bb1-9787-b4ac1b34c1d9 | SOXL | 2026-09-18 09:30 | call_diagonal_spread | 2 | 1 | 10 | 146390.00 | unknown | bid | 117.1500 | 11.3500 | ["60","100"] | ["1.0152","0.9895"] | [] | ["AMXO"] | 60.0000 | 100.0000 | 490 | 854 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:30:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b023-7373-7f62-9db4-c70ce36d517e | SOXL | 2026-09-17 12:11 | call_diagonal_spread | 2 | 1 | 15 | 212805.00 | unknown | — | 114.7500 | 6.6500 | ["50","55"] | ["1.0755","0.9871"] | [] | ["XPHO"] | 50.0000 | 55.0000 | 120 | 491 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb0-0893-7ec1-bb9e-92d14f5b2a0b | SOXL | 2026-09-17 10:05 | call_diagonal_spread | 2 | 1 | 21 | 100065.00 | unknown | — | 114.3600 | 3.2500 | ["90","92"] | ["2.7676","1.2384"] | [] | ["XISX"] | 90.0000 | 92.0000 | 1 | 6 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:05:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc9-8b4b-7783-90cc-8d8451ee4303 | SOXL | 2026-09-16 15:55 | call_diagonal_spread | 2 | 2 | 30 | 107760.00 | unknown | — | 103.4760 | 2.0500 | ["95","105"] | ["1.1446","1.0718"] | [] | ["ARCO","XCBO"] | 95.0000 | 105.0000 | 30 | 65 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:55:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbe-8313-70b2-8725-a087cf25e906 | SOXL | 2026-09-16 15:43 | call_diagonal_spread | 2 | 1 | 12 | 157788.00 | unknown | — | 102.8900 | 9.0000 | ["53","75"] | ["1.0150","0.9769"] | [] | ["XISX"] | 53.0000 | 75.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:43:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab85-8153-7d83-a453-d4891b409b84 | SOXL | 2026-09-16 14:40 | call_diagonal_spread | 2 | 1 | 17 | 243984.00 | unknown | — | 106.0110 | 7.2500 | ["50","55"] | ["1.0008","0.9384"] | [] | ["XPHO"] | 50.0000 | 55.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:40:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab82-50eb-7762-b400-a9baaf544bb1 | SOXL | 2026-09-16 14:37 | call_diagonal_spread | 2 | 1 | 16 | 153392.00 | unknown | — | 104.9605 | 6.4000 | ["61","65"] | ["1.2812","1.1684"] | [] | ["XISX"] | 61.0000 | 65.0000 | 65 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:37:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aad4-bb6b-77e3-a326-bd1e23520287 | SOXL | 2026-09-16 11:27 | call_diagonal_spread | 2 | 1 | 93 | 180141.00 | unknown | — | 108.8000 | 1.9000 | ["100","110"] | ["1.4343","1.0654"] | [] | ["AMXO"] | 100.0000 | 110.0000 | 2 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:28:00Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa72-6b73-7501-8a79-198374d598f6 | SOXL | 2026-09-16 09:40 | call_diagonal_spread | 2 | 1 | 50 | 702300.00 | unknown | — | 107.1300 | 8.1000 | ["35","110"] | ["0.9558","1.0057"] | [] | ["XISX"] | 35.0000 | 110.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:40:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a612-8b1e-7833-8835-b35f3acdb105 | SOXL | 2026-09-15 13:17 | call_diagonal_spread | 2 | 1 | 160 | 984000.00 | unknown | — | 101.4250 | 4.6500 | ["70","83"] | ["3.4469","1.0779"] | [] | ["XBOX"] | 70.0000 | 83.0000 | 3 | 94 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:17:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fe-2c46-7461-abb9-0b55f6f4afed | SOXL | 2026-09-15 12:54 | call_diagonal_spread | 2 | 1 | 45 | 576000.00 | unknown | — | 102.0100 | 4.7500 | ["31","50"] | ["1.4322","1.0727"] | [] | ["XISX"] | 31.0000 | 50.0000 | 122 | 157 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:55:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a586-21ce-7983-b282-4182dbcc4ed7 | SOXL | 2026-09-15 10:43 | call_diagonal_spread | 2 | 1 | 26 | 251030.00 | unknown | — | 103.0200 | 6.9000 | ["120","150"] | ["1.0535","1.0104"] | [] | ["XISX"] | 120.0000 | 150.0000 | 493 | 857 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:44:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a551-6d9e-7760-9ad1-556734512045 | SOXL | 2026-09-15 09:46 | call_diagonal_spread | 2 | 1 | 50 | 602000.00 | unknown | — | 104.7813 | 7.6000 | ["70","105"] | ["1.0158","0.9918"] | [] | ["MCRY"] | 70.0000 | 105.0000 | 493 | 857 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:46:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a081db-0fe9-7d73-86f0-b0bd8dd4cff1 | SOXL | 2026-09-08 12:30 | call_diagonal_spread | 2 | 2 | 166 | 350426.00 | unknown | — | 124.9100 | 2.1500 | ["116","120"] | ["1.3382","1.2232"] | [] | ["C2OX","EDGO"] | 116.0000 | 120.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:30:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |