core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0d9db-d40f-7141-bc33-99d92bbbe9ab | SMH | 2026-09-25 14:37 | call_diagonal_spread | 2 | 1 | 5 | 203300.00 | short | bid | 606.8700 | 3.6000 | ["405","465"] | ["0.6943","0.4025"] | [] | ["XISX"] | 405.0000 | 465.0000 | 21 | 483 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:38:14Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0cfd3-a306-7481-9383-c9a7d5c4ffa1 | SMH | 2026-09-23 15:52 | put_vertical_spread | 2 | 3 | 174 | 157992.00 | long | ask | 599.2300 | 0.2200 | ["430","510"] | ["0.4909","0.4154"] | ["504.28"] | ["C2OX","XCBO","XISX"] | 430.0000 | 510.0000 | 58 | 58 | false | true | false | ||||||||||
| 01a0caac-31af-7973-862e-e0f6bd2d6650 | SMH | 2026-09-22 15:51 | call_vertical_spread | 2 | 1 | 15 | 114975.00 | short | bid | 607.6850 | 2.8500 | ["562.5","577.5"] | ["0.4042","0.4017"] | ["576.85"] | ["XCBO"] | 562.5000 | 577.5000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca50-e2af-7860-9ae8-9c1d8375407b | SMH | 2026-09-22 14:11 | strangle | 2 | 2 | 234 | 535860.00 | short | bid | 604.8509 | 0.1286 | ["587.5","630"] | ["0.3318","0.3233"] | ["564.6","652.90"] | ["AMXO"] | 587.5000 | 630.0000 | 24 | 24 | false | true | false | ||||||||||
| 01a0c9b3-3b4e-7471-9d81-7db5353ca535 | SMH | 2026-09-22 11:19 | put_calendar | 2 | 1 | 232 | 243136.00 | long | bid | 601.3700 | 0.1300 | ["575"] | ["0.3580"] | [] | ["XISX"] | 575.0000 | 575.0000 | 3 | 24 | false | true | true | false | |||||||||
| 01a0c98e-9097-7273-8903-991f7dfd5ed5 | SMH | 2026-09-22 10:39 | straddle | 2 | 2 | 59 | 648885.00 | short | bid | 602.1000 | 0.6093 | ["545"] | ["0.3798"] | ["435.02","654.98"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c978-af07-7501-8134-b56e8e70a84e | SMH | 2026-09-22 10:15 | put_vertical_spread | 2 | 1 | 100 | 496000.00 | long | ask | 600.5200 | 1.0000 | ["570","590"] | ["0.3780","0.3739"] | ["582"] | ["C2OX"] | 570.0000 | 590.0000 | 59 | 59 | false | true | false | ||||||||||
| 01a0c563-4606-7220-a94f-3c031b270cfb | SMH | 2026-09-21 15:13 | call_vertical_spread | 2 | 3 | 181 | 934160.00 | short | bid | 596.2100 | 0.1550 | ["600","650"] | ["0.3643","0.3571"] | ["618.81"] | ["C2OX"] | 600.0000 | 650.0000 | 60 | 60 | false | true | false | ||||||||||
| 01a0c552-2737-77d1-b65f-aee4cc2a3d20 | SMH | 2026-09-21 14:54 | call_vertical_spread | 2 | 1 | 130 | 393250.00 | short | bid | 595.9500 | 0.1500 | ["600","625"] | ["0.3383","0.3346"] | ["609.55"] | ["C2OX"] | 600.0000 | 625.0000 | 25 | 25 | false | true | false | ||||||||||
| 01a0c4a9-2597-7331-8126-f7389f028a02 | SMH | 2026-09-21 11:50 | put_diagonal_spread | 2 | 7 | 115 | 299920.00 | short | bid | 590.9000 | 0.3500 | ["435","560"] | ["0.5532","0.3692"] | [] | ["BATO","EMLD","XCBO","XISX","XPHO"] | 435.0000 | 560.0000 | 25 | 88 | false | true | true | ||||||||||
| 01a0c4a5-fcfe-7e21-822a-035469ce376f | SMH | 2026-09-21 11:46 | put_diagonal_spread | 2 | 5 | 47 | 122482.00 | unknown | ask | 591.2500 | 0.2187 | ["435","560"] | ["0.5503","0.3703"] | [] | ["AMXO","ARCO","XCBO","XISX","XPHO"] | 435.0000 | 560.0000 | 25 | 88 | false | true | true | ||||||||||
| 01a0c48a-2fcf-7750-ae97-28493b3332e6 | SMH | 2026-09-21 11:16 | call_vertical_spread | 2 | 2 | 109 | 246330.00 | short | bid | 590.3900 | 0.3000 | ["605","630"] | ["0.3354","0.3360"] | ["612.5"] | ["EDGO","XISX"] | 605.0000 | 630.0000 | 25 | 25 | false | true | false | ||||||||||
| 01a0c479-efa6-78f1-91fd-47875bd07328 | SMH | 2026-09-21 10:58 | straddle | 2 | 3 | 12 | 122085.00 | short | bid | 587.9400 | 1.3125 | ["545"] | ["0.3693"] | ["443.26","646.74"] | ["ARCO"] | 545.0000 | 545.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0afba-bec3-78b2-af79-651ea2a588c3 | SMH | 2026-09-17 10:17 | straddle | 2 | 1 | 30 | 423750.00 | long | ask | 561.3600 | 1.1000 | ["580"] | ["0.3677"] | ["438.75","721.25"] | ["C2OX"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | |||||||||
| 01a0afb5-dcc3-78a3-8235-43244f99826f | SMH | 2026-09-17 10:12 | straddle | 2 | 1 | 17 | 239870.00 | long | ask | 559.8700 | 2.3500 | ["580"] | ["0.3678"] | ["438.90","721.10"] | ["C2OX"] | 580.0000 | 580.0000 | 273 | 273 | false | false | false | false | |||||||||
| 01a0a607-3c95-7743-8b2e-377928eb8a63 | SMH | 2026-09-15 13:04 | put_diagonal_spread | 2 | 1 | 7 | 105210.00 | short | bid | 540.5200 | 1.4000 | ["610","615"] | ["0.3462","0.3480"] | [] | ["C2OX"] | 610.0000 | 615.0000 | 24 | 66 | false | false | true | ||||||||||
| 01a0a110-abc1-7fb0-b0ab-e2fa4f0bba7c | SMH | 2026-09-14 13:56 | strangle | 2 | 5 | 65 | 131950.00 | long | ask | 545.5200 | 0.3000 | ["520","575"] | ["0.3437","0.3121"] | ["499.70","595.30"] | ["AMXO","EMLD","XCBO","XISX","XPHO"] | 520.0000 | 575.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a08bb2-ce98-7473-babe-7482a9630b04 | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 22 | 135190.00 | short | ask | 560.3062 | 1.2000 | ["520","675"] | ["0.3867","0.3549"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | ||||||||||
| 01a08714-1159-7fb0-b89a-8ec40d08db1e | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 23 | 366965.00 | short | ask | 575.1400 | 0.3000 | ["630"] | ["0.3804"] | ["592.25"] | ["MCRY"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a0870d-d798-7990-8629-235415095d4d | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 8 | 127640.00 | long | ask | 574.5300 | 0.3500 | ["630"] | ["0.3803"] | ["470.45","789.55"] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:52:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:51:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:19:35Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:39:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:15:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:13:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:55:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:50:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:47:00Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:16:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:58:52Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:17:29Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:12:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:05:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:57:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:22:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:44:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |