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 |
|---|
| 01a09121-0521-7653-b338-0e6a383e4188 | MRNA | 2026-09-11 11:40 | other | 2 | 1 | 54 | 116208.00 | unknown | — | 147.5000 | 4.4000 | ["105","135"] | ["0.7541","0.7531"] | [] | ["XCBO"] | 105.0000 | 135.0000 | 189 | 189 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:41:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fc-4eb0-7e71-8144-fb3c81e011e3 | MRNA | 2026-09-11 11:00 | other | 4 | 1 | 55 | 131538.00 | unknown | — | 149.0100 | 3.3000 | ["150","155"] | ["0.7355","0.7027"] | [] | ["MCRY"] | 150.0000 | 155.0000 | 7 | 14 | false | false | true | true | true | mlat | |||||||
| 01a090f0-d531-7a31-8d63-5bd55f8f21ac | MRNA | 2026-09-11 10:48 | call_vertical_spread | 2 | 1 | 1375 | 959750.00 | short | bid | 147.1900 | 0.4200 | ["150","157.5"] | ["0.7107","0.7388"] | ["152.18"] | ["EDGO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | true | |||||||||
| 01a090e3-aa19-7730-a527-e686756136b5 | MRNA | 2026-09-11 10:33 | call_vertical_spread | 2 | 1 | 3000 | 1896000.00 | unknown | — | 146.2700 | 0.4900 | ["150","157.5"] | ["0.7106","0.7360"] | [] | ["EDGO"] | 150.0000 | 157.5000 | 7 | 7 | false | true | false | true | false | mlat | |||||||
| 01a08ce6-39d1-74f1-9633-15f43505b09b | MRNA | 2026-09-10 15:58 | call_calendar | 2 | 1 | 12 | 255888.00 | short | bid | 136.7601 | 6.6000 | ["30"] | ["4.7910"] | [] | ["XCBO"] | 30.0000 | 30.0000 | 8 | 36 | false | false | true | false | false | ||||||||
| 01a08ce2-8881-7033-8154-115116761614 | MRNA | 2026-09-10 15:54 | call_vertical_spread | 2 | 1 | 218 | 211024.00 | long | ask | 136.5300 | 0.5300 | ["130","135"] | ["0.7441","0.7107"] | ["133.92"] | ["XMIO"] | 130.0000 | 135.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08c76-9f80-70d3-a8ac-5178f5353ed5 | MRNA | 2026-09-10 13:56 | call_vertical_spread | 2 | 1 | 1500 | 940500.00 | short | bid | 135.3250 | 0.4500 | ["138","145"] | ["0.6587","0.6876"] | ["139.99"] | ["EDGO"] | 138.0000 | 145.0000 | 8 | 8 | true | true | false | true | |||||||||
| 01a08bf8-c0d8-7ba3-97a3-65e69843299a | MRNA | 2026-09-10 11:38 | other | 4 | 1 | 1850 | 1274650.00 | unknown | — | 133.7400 | 1.4000 | ["136","143","148","155"] | ["0.6728","0.6637","1.4142","1.4319"] | [] | ["EDGO"] | 136.0000 | 155.0000 | 1 | 8 | false | true | true | true | false | mlat | |||||||
| 01a08baf-4c28-7a22-a768-f390c89fadfd | MRNA | 2026-09-10 10:18 | other | 4 | 1 | 2000 | 1342000.00 | unknown | — | 134.1500 | 0.9850 | ["137","144","148","155"] | ["0.6785","0.7013","1.2286","1.4882"] | [] | ["EDGO"] | 137.0000 | 155.0000 | 1 | 8 | false | true | true | true | false | mlat | |||||||
| 01a0879b-fe38-7173-92c6-f8055a69cad9 | MRNA | 2026-09-09 15:18 | other | 4 | 1 | 120 | 335060.00 | unknown | — | 136.4700 | 2.2000 | ["150"] | ["0.7799"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 2 | 9 | false | false | true | false | true | mlat | |||||||
| 01a08749-d311-7502-8ee6-492aa607444b | MRNA | 2026-09-09 13:49 | call_vertical_spread | 2 | 1 | 13 | 149864.00 | short | bid | 137.8300 | 6.6000 | ["135","155"] | ["0.7017","0.7018"] | ["140.70"] | ["XCBO"] | 135.0000 | 155.0000 | 828 | 828 | false | false | false | true | |||||||||
| 01a086bc-f491-7f80-b9c3-cf181008f06b | MRNA | 2026-09-09 11:15 | call_vertical_spread | 2 | 1 | 37 | 122988.00 | long | ask | 138.2900 | 6.7500 | ["134","135"] | ["0.7605","0.7613"] | ["134.48"] | ["XCBO"] | 134.0000 | 135.0000 | 44 | 44 | false | false | false | true | |||||||||
| 01a0823b-8f08-7243-b833-8178d387b668 | MRNA | 2026-09-08 14:15 | call_diagonal_spread | 2 | 1 | 12 | 205380.00 | long | bid | 142.8450 | 5.6500 | ["56","60"] | ["5.5710","1.5124"] | [] | ["XCBO"] | 56.0000 | 60.0000 | 3 | 38 | false | false | true | true | false | ||||||||
| 01a06de7-d32d-7bd2-82df-a123502c4223 | MRNA | 2026-09-04 15:31 | other | 2 | 1 | 10 | 147240.00 | unknown | — | 146.4950 | 6.1000 | ["73"] | ["21.4827"] | [] | ["XPHO"] | 73.0000 | 73.0000 | 0 | 7 | false | false | true | false | false | mlat | |||||||
| 01a06dd1-8c0d-7a71-b0ba-e36a864f4586 | MRNA | 2026-09-04 15:07 | other | 4 | 1 | 750 | 589500.00 | unknown | — | 145.4091 | 2.1000 | ["145","148","152.5","155"] | ["1.2716","0.6957","2.0368","0.7231"] | [] | ["EDGO"] | 145.0000 | 155.0000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a06dcc-34dd-7701-ae6f-174b1fdb313d | MRNA | 2026-09-04 15:01 | other | 4 | 1 | 1500 | 1552500.00 | unknown | — | 146.0901 | 3.2900 | ["143","148","150","155"] | ["1.5244","0.6730","1.4584","0.7093"] | [] | ["EDGO"] | 143.0000 | 155.0000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a06da8-3dd5-7572-9dc7-4207c6e12ebf | MRNA | 2026-09-04 14:22 | other | 4 | 1 | 1315 | 2052719.00 | unknown | — | 146.0250 | 3.2000 | ["139","146","148","155"] | ["2.8633","1.1793","0.7104","0.7077"] | [] | ["EDGO"] | 139.0000 | 155.0000 | 0 | 7 | false | false | true | true | false | mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:01:13Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:48:24Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:34:07Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:58:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:54:16Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:56:19Z"} |
| 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-10T15:39:08Z"} |
| 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-10T14:18:35Z"} |
| 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-09T19:19:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:50:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:15:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:16:09Z"} |
| 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-04T19:31:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:07:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:02:08Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:22:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |