core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a090b7-cf88-7193-b3f7-d92207047d96 | C | 2026-09-11 09:45 | other | 2 | 1 | 100 | 125500.00 | unknown | — | 140.0550 | 2.1000 | ["150","170"] | ["0.2980","0.2865"] | [] | ["XISX"] | 150.0000 | 170.0000 | 126 | 279 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:46:01Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c70-bbb1-7110-8527-6aace92312be | C | 2026-09-10 13:49 | call_diagonal_spread | 2 | 2 | 45 | 479475.00 | short | ask | 137.7800 | 4.8000 | ["85","87.5"] | ["0.3492","0.2136"] | [] | ["XMIO"] | 85.0000 | 87.5000 | 127 | 280 | false | false | true | true | false | ||||||||
| 01a0865f-1d21-7be3-aef0-99ca6f28f5bc | C | 2026-09-09 09:32 | other | 2 | 1 | 500 | 1677500.00 | unknown | — | 134.5150 | 1.8000 | ["140","175"] | ["0.2860","0.2826"] | [] | ["XISX"] | 140.0000 | 175.0000 | 499 | 828 | false | true | true | true | false | mlet | |||||||
| 01a0865e-32c0-75f2-b40b-ac3c5da9b73f | C | 2026-09-09 09:31 | other | 4 | 2 | 1225 | 3038971.00 | unknown | — | 134.4100 | 8.3500 | ["95","105","150","200"] | ["0.5644","0.3048","0.2880","0.2851"] | [] | ["XISX"] | 95.0000 | 200.0000 | 37 | 828 | false | false | true | true | false | mlet | |||||||
| 01a0865d-cd30-7981-b0ad-09f52006bfaf | C | 2026-09-09 09:31 | call_diagonal_spread | 2 | 1 | 500 | 127000.00 | short | bid | 134.9650 | 0.9100 | ["140","165"] | ["0.3275","0.2760"] | [] | ["XCBO"] | 140.0000 | 165.0000 | 9 | 128 | false | true | true | true | false | ||||||||
| 01a08211-0850-7ba1-846b-044a573f5fdd | C | 2026-09-08 13:29 | put_diagonal_spread | 2 | 1 | 1001 | 1885884.00 | short | bid | 137.4850 | 1.5500 | ["100","120"] | ["0.3628","0.3554"] | [] | ["XMIO"] | 100.0000 | 120.0000 | 500 | 829 | false | true | true | true | false | ||||||||
| 01a08201-b671-7081-a467-55d7db755ee3 | C | 2026-09-08 13:12 | call_vertical_spread | 2 | 1 | 939 | 4121271.00 | long | ask | 137.5999 | 4.0500 | ["150","160"] | ["0.2810","0.2792"] | ["153.75"] | ["BATO"] | 150.0000 | 160.0000 | 829 | 829 | false | true | false | true | false | ||||||||
| 01a08162-a7b0-7d01-a9e8-6fa3e55d5599 | C | 2026-09-08 10:18 | call_vertical_spread | 2 | 1 | 61 | 264374.00 | short | bid | 136.3400 | 3.6500 | ["150","160"] | ["0.2853","0.2856"] | ["153.50"] | ["XISX"] | 150.0000 | 160.0000 | 829 | 829 | false | true | false | true | false | ||||||||
| 01a08137-f219-7b02-968b-b9981942eb71 | C | 2026-09-08 09:32 | call_diagonal_spread | 2 | 1 | 1500 | 4135500.00 | short | ask | 135.9750 | 1.6500 | ["140","155"] | ["0.2869","0.2799"] | [] | ["BATO"] | 140.0000 | 155.0000 | 282 | 500 | false | true | true | true | false | ||||||||
| 01a08137-e660-7bb0-956b-8cd9597808e6 | C | 2026-09-08 09:31 | call_diagonal_spread | 2 | 1 | 1000 | 3354000.00 | short | ask | 136.0300 | 8.1203 | ["130","155"] | ["0.2987","0.2867"] | [] | ["XISX"] | 130.0000 | 155.0000 | 282 | 500 | false | false | true | true | false | ||||||||
| 01a08137-e660-7bb0-956b-8cb778deca14 | C | 2026-09-08 09:31 | other | 4 | 2 | 1000 | 4335023.00 | unknown | — | 136.2400 | 14.3750 | ["140","150","175"] | ["0.2915","0.2868","0.2782"] | [] | ["XPHO"] | 140.0000 | 175.0000 | 282 | 500 | false | true | true | true | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:50:17Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:33:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:32:01Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:31:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:29:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:12:37Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:18:54Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |