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 |
|---|
| 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 |
|---|
| 01a0b4ed-8247-7f41-84d8-3c51b94178c7 | MCHP | 2026-09-18 10:30 | call_vertical_spread | 2 | 1 | 169 | 138580.00 | unknown | — | 71.9400 | 0.6000 | ["70","72.5"] | ["0.4564","0.4543"] | [] | ["XMIO"] | 70.0000 | 72.5000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ad-8b03-7160-94ea-54728968d042 | MCHP | 2026-09-17 14:42 | put_vertical_spread | 2 | 1 | 86 | 279500.00 | unknown | — | 70.6600 | 3.4000 | ["85","87.5"] | ["2.9419","3.2539"] | [] | ["XBOX"] | 85.0000 | 87.5000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0ad-6bc3-7020-ab55-5a3e4e68f830 | MCHP | 2026-09-17 14:42 | other | 4 | 1 | 1563 | 3362670.00 | unknown | — | 70.6600 | 5.6000 | ["77.5","82.5","85","92.5"] | ["1.3994","2.7263","2.9419","4.2328"] | [] | ["XBOX"] | 77.5000 | 92.5000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0a9-9363-72c0-9289-1e5f31cad92e | MCHP | 2026-09-17 14:38 | put_ladder | 5 | 1 | 557 | 1465350.00 | unknown | — | 70.6300 | 10.3000 | ["82.5","85","87.5","92.5","95"] | ["2.6973","2.9083","3.7102","4.2002","4.7313"] | [] | ["XBOX"] | 82.5000 | 95.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b072-85a2-79c2-ac0b-1dd8dd509c38 | MCHP | 2026-09-17 13:38 | other | 4 | 1 | 3680 | 765440.00 | unknown | — | 70.6350 | 0.5000 | ["72","74","75","77"] | ["0.4342","0.4397","0.7504","0.9978"] | [] | ["XPHO"] | 72.0000 | 77.0000 | 1 | 8 | false | true | true | true | false | mlat | |||||||
| 01a0a136-3138-7ac3-939f-27b661f5d850 | MCHP | 2026-09-14 14:37 | other | 2 | 1 | 500 | 765000.00 | unknown | — | 72.0700 | 0.9000 | ["65","72.5"] | ["0.4976","0.4692"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a0cd-3e08-7411-8b67-973e40ae4d8f | MCHP | 2026-09-14 12:43 | other | 2 | 1 | 500 | 747500.00 | unknown | — | 71.6750 | 0.9000 | ["65","72.5"] | ["0.5041","0.4753"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a0a3-47d8-7e61-b717-2a7e85a16507 | MCHP | 2026-09-14 11:57 | other | 2 | 1 | 500 | 735000.00 | unknown | — | 71.5150 | 0.7000 | ["65","72.5"] | ["0.5011","0.4730"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a07f-4130-7fc0-838a-bd45915724ff | MCHP | 2026-09-14 11:18 | other | 2 | 1 | 471 | 670704.00 | unknown | — | 71.0800 | 0.6000 | ["65","72.5"] | ["0.5031","0.4769"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a061-2241-7eb0-97be-4fc057c8e94c | MCHP | 2026-09-14 10:45 | other | 2 | 1 | 500 | 721000.00 | unknown | — | 71.4300 | 0.6000 | ["65","72.5"] | ["0.4940","0.4626"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a055-9d08-74d0-969d-1154540ffbce | MCHP | 2026-09-14 10:32 | other | 2 | 1 | 500 | 724000.00 | unknown | — | 71.4450 | 0.7000 | ["65","72.5"] | ["0.4955","0.4653"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a053-c078-7142-95f6-688cb509929b | MCHP | 2026-09-14 10:30 | other | 2 | 1 | 495 | 716760.00 | unknown | — | 71.3800 | 0.7000 | ["65","72.5"] | ["0.4992","0.4691"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a047-06a8-77f0-b4cf-4d8ad02c038c | MCHP | 2026-09-14 10:16 | call_diagonal_spread | 2 | 3 | 540 | 788045.00 | long | ask | 71.4400 | 0.7000 | ["65","72.5"] | ["0.5022","0.4695"] | [] | ["ARCO","XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | |||||||||
| 01a0a047-06a8-77f0-b4cf-4d74160e615c | MCHP | 2026-09-14 10:16 | call_diagonal_spread | 2 | 2 | 278 | 405324.00 | long | ask | 71.4400 | 0.7000 | ["65","72.5"] | ["0.5022","0.4679"] | [] | ["ARCO","XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | |||||||||
| 01a0a040-fbc8-7d73-a605-67db8349f5f4 | MCHP | 2026-09-14 10:10 | other | 2 | 1 | 499 | 736025.00 | unknown | — | 71.5950 | 0.9000 | ["65","72.5"] | ["0.4990","0.4706"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a0a03f-36a8-72b0-a9e7-450c989ef38d | MCHP | 2026-09-14 10:08 | other | 2 | 2 | 500 | 747500.00 | unknown | — | 71.6300 | 1.1000 | ["65","72.5"] | ["0.5066","0.4780"] | [] | ["XPHO"] | 65.0000 | 72.5000 | 32 | 95 | false | false | true | true | false | mlet | |||||||
| 01a091f4-2400-7ed3-be55-6dd33d91912e | MCHP | 2026-09-11 15:31 | other | 4 | 1 | 3627 | 848718.00 | unknown | — | 74.0800 | 0.5000 | ["74","75","76","77"] | ["0.6729","0.4272","2.4770","0.4376"] | [] | ["XPHO"] | 74.0000 | 77.0000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a08208-e260-7792-9499-96ac84534772 | MCHP | 2026-09-08 13:20 | strangle | 2 | 4 | 106 | 132500.00 | long | ask | 73.9800 | 0.4000 | ["70","82.5"] | ["0.5247","0.4970"] | ["57.50","95.00"] | ["AMXO","XCBO","XPHO"] | 70.0000 | 82.5000 | 129 | 129 | false | true | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:43:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:42:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:38:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:38:08Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:38:45Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:43:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:57:58Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:18:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:45:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:32:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:30:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:10:21Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:08:17Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:31:32Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:20:23Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |