core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0f852-2b0f-7bb1-b46f-4475d2b1c6ad | KRE | 2026-10-01 12:35 | put_vertical_spread | 2 | 1 | 775 | 501425.00 | short | bid | 69.3400 | 1.2500 | ["68","70"] | ["0.2931","0.2858"] | ["69.13"] | ["XPHO"] | 68.0000 | 70.0000 | 78 | 78 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T16:35:29Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f836-a046-7d42-b9e7-198ff2af8385 | KRE | 2026-10-01 12:05 | other | 3 | 4 | 351 | 100035.00 | unknown | bid | 68.9950 | 1.3800 | ["63","67","71"] | ["0.4148","0.3511","0.4745"] | [] | ["C2OX","EDGO","XCBO","XISX"] | 63.0000 | 71.0000 | 1 | 8 | false | false | |||||||||||
| 01a0f7d8-72e7-7192-8ab2-7bea7606715b | KRE | 2026-10-01 10:22 | put_ratio_spread | 2 | 3 | 217 | 135104.00 | unknown | bid | 68.0950 | 0.9500 | ["68","69"] | ["0.2692","0.2516"] | ["43.68","68.81"] | ["AMXO","XCBO","XISX"] | 68.0000 | 69.0000 | 78 | 78 | false | false | |||||||||||
| 01a0f7d4-3cc7-7843-8385-438c754d36d6 | KRE | 2026-10-01 10:17 | put_condor | 4 | 1 | 500 | 141000.00 | short | bid | 68.2200 | 0.9000 | ["64","65","67","69"] | ["0.3645","0.3517","0.3151","0.2928"] | ["68.26"] | ["XMIO"] | 64.0000 | 69.0000 | 8 | 8 | false | false | |||||||||||
| 01a0f7d2-8f17-76a3-9bae-33d4b45bd646 | KRE | 2026-10-01 10:16 | put_diagonal_spread | 2 | 1 | 750 | 495000.00 | short | bid | 68.1800 | 0.4500 | ["69","73"] | ["0.3046","0.2848"] | [] | ["SPHR"] | 69.0000 | 73.0000 | 8 | 15 | false | false | |||||||||||
| 01a0f37c-e0f7-7b31-a43a-7e460ffdac57 | KRE | 2026-09-30 14:04 | put_diagonal_spread | 2 | 1 | 1000 | 506000.00 | unknown | bid | 69.2400 | 0.5400 | ["70","73"] | ["0.2335","0.6662"] | [] | ["XBOX"] | 70.0000 | 73.0000 | 2 | 9 | false | false | |||||||||||
| 01a0f355-57df-73b2-bdc2-053c5bcdbfc7 | KRE | 2026-09-30 13:20 | put_calendar | 2 | 1 | 912 | 734160.00 | long | bid | 69.1950 | 0.6000 | ["70"] | ["0.2520"] | [] | ["BATO"] | 70.0000 | 70.0000 | 51 | 260 | false | false | true | ||||||||||
| 01a0f336-0457-76f0-8c70-0fcff0855029 | KRE | 2026-09-30 12:46 | strangle | 2 | 1 | 25000 | 7300000.00 | short | bid | 69.3524 | 0.7000 | ["67","73"] | ["0.2538","0.2659"] | ["64.08","75.92"] | ["AMXO"] | 67.0000 | 73.0000 | 51 | 51 | true | true | |||||||||||
| 01a0ee6d-fcc7-7d90-93d7-b84e6aa46f15 | KRE | 2026-09-29 14:29 | other | 3 | 1 | 12233 | 18364706.00 | unknown | bid | 69.6900 | 1.8500 | ["70","73","77"] | ["0.2553","0.2363","0.2589"] | [] | ["ARCO"] | 70.0000 | 77.0000 | 80 | 261 | false | false | |||||||||||
| 01a0ee55-aa36-7790-bac2-9eb22ab702e7 | KRE | 2026-09-29 14:03 | put_vertical_spread | 2 | 3 | 210 | 116972.00 | unknown | bid | 69.6100 | 0.5779 | ["69","70"] | ["0.2472","0.2394"] | ["66.71"] | ["AMXO","XCBO","XISX"] | 69.0000 | 70.0000 | 80 | 80 | false | false | |||||||||||
| 01a0edfe-acaf-7dd0-b2ec-27ed3f4e9842 | KRE | 2026-09-29 12:28 | other | 3 | 1 | 2532 | 2886000.00 | unknown | bid | 69.4700 | 1.5900 | ["70","75","77"] | ["0.2447","0.2323","0.2497"] | ["65.10","86.40"] | ["ARCO"] | 70.0000 | 77.0000 | 171 | 171 | false | false | |||||||||||
| 01a0d907-6927-7712-980c-b99ec7b46c44 | KRE | 2026-09-25 10:45 | synthetic | 2 | 1 | 2500 | 1340000.00 | long | bid | 71.5100 | 0.5900 | ["72"] | ["0.2399"] | ["71.94"] | ["XPHO"] | 72.0000 | 72.0000 | 56 | 56 | true | false | false | ||||||||||
| 01a0d499-ce06-76a1-9d54-5ac79c2ad222 | KRE | 2026-09-24 14:07 | put_diagonal_spread | 2 | 1 | 1500 | 1125000.00 | long | bid | 70.8100 | 1.0900 | ["72","76"] | ["0.2424","0.8266"] | [] | ["XBOX"] | 72.0000 | 76.0000 | 1 | 22 | false | false | |||||||||||
| 01a0d452-b2e7-7ae2-a01f-7cd978b05e36 | KRE | 2026-09-24 12:49 | other | 4 | 1 | 520 | 123240.00 | unknown | bid | 70.9250 | 0.5500 | ["65","67","70","72.5"] | ["0.3454","0.6012","0.2653","0.2830"] | [] | ["AMXO"] | 65.0000 | 72.5000 | 1 | 8 | false | false | |||||||||||
| 01a0ca85-3537-7bd1-a122-7fd21a168665 | KRE | 2026-09-22 15:08 | other | 3 | 2 | 3378 | 3730000.00 | unknown | bid | 71.5950 | 1.7000 | ["70","75","77"] | ["0.2439","0.2189","0.2399"] | ["76.45"] | ["AMXO"] | 70.0000 | 77.0000 | 178 | 178 | false | false | |||||||||||
| 01a0ca34-716f-7223-bd0b-ccccb56de2aa | KRE | 2026-09-22 13:40 | put_vertical_spread | 2 | 1 | 8000 | 1648000.00 | short | bid | 71.5950 | 0.2900 | ["60","68"] | ["0.2893","0.2495"] | ["66.74"] | ["XPHO"] | 60.0000 | 68.0000 | 87 | 87 | false | true | |||||||||||
| 01a0ca34-234f-7733-8f64-5aa3e73a9db5 | KRE | 2026-09-22 13:40 | put_vertical_spread | 2 | 1 | 2000 | 411250.00 | short | bid | 71.6100 | 0.2900 | ["60","68"] | ["0.2895","0.2496"] | ["66.74"] | ["XPHO"] | 60.0000 | 68.0000 | 87 | 87 | false | true | |||||||||||
| 01a0c543-3317-7c33-a072-4a7feb914bf8 | KRE | 2026-09-21 14:38 | call_vertical_spread | 2 | 1 | 65 | 123435.00 | unknown | bid | 72.2000 | 0.6000 | ["62","67"] | ["0.2486","0.2302"] | ["74.00"] | ["XCBO"] | 62.0000 | 67.0000 | 116 | 116 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T16:05:59Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:22:38Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:18:05Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:16:15Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T18:04:49Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T17:21:02Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T16:46:58Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:29:56Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:03:53Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:28:06Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:45:38Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:07:50Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:50:01Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:09:14Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:40:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:40:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:38:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |