core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 01a06d95-7d0d-7ad0-a143-d83e9a5c2686 | JPM | 2026-09-04 14:01 | call_calendar | 2 | 1 | 200 | 4007000.00 | long | bid | 358.7700 | 3.9000 | ["260"] | ["0.4176"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 42 | 105 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:01:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db3-da7d-7c11-8e2c-ba3a0eb11c2f | JPM | 2026-09-04 14:34 | call_calendar | 2 | 1 | 10 | 109970.00 | short | ask | 359.3800 | 7.3500 | ["305"] | ["0.4912"] | [] | ["XISX"] | 305.0000 | 305.0000 | 21 | 28 | false | false | true | false | |||||||||
| 01a08723-a1b8-7251-8f5b-84c2a1e0ddbb | JPM | 2026-09-09 13:07 | call_calendar | 2 | 1 | 156 | 138528.00 | short | bid | 355.0609 | 0.8000 | ["375"] | ["0.2342"] | [] | ["BATO"] | 375.0000 | 375.0000 | 37 | 44 | false | true | true | false | |||||||||
| 01a08b83-2452-7943-b4f0-fa940f317eda | JPM | 2026-09-10 09:30 | call_calendar | 2 | 1 | 10 | 325700.00 | short | ask | 353.8700 | 7.8000 | ["195"] | ["0.4829"] | [] | ["AMXO"] | 195.0000 | 195.0000 | 127 | 498 | false | false | true | false | |||||||||
| 01a08bce-fd70-7870-8abc-c4c163babd0c | JPM | 2026-09-10 10:53 | call_calendar | 2 | 1 | 17 | 655656.00 | short | bid | 352.7500 | 6.4500 | ["160"] | ["1.8978"] | [] | ["ARCO"] | 160.0000 | 160.0000 | 8 | 71 | false | false | true | false | |||||||||
| 01a090e8-6509-7a01-8c4c-cdcc88852763 | JPM | 2026-09-11 10:39 | call_calendar | 2 | 1 | 65 | 579800.00 | short | ask | 355.5800 | 5.1500 | ["315"] | ["0.3987"] | [] | ["XISX"] | 315.0000 | 315.0000 | 7 | 98 | false | false | true | false | |||||||||
| 01a0a03a-c5f0-7993-8fb4-3dc029e25903 | JPM | 2026-09-14 10:03 | call_calendar | 2 | 1 | 36 | 180396.00 | short | ask | 352.6200 | 4.6000 | ["330"] | ["0.3757"] | [] | ["XCBO"] | 330.0000 | 330.0000 | 4 | 32 | false | false | true | false | |||||||||
| 01a0a07a-b909-7301-b93f-3c0d7f81776c | JPM | 2026-09-14 11:13 | call_calendar | 2 | 1 | 4 | 132740.00 | short | ask | 351.2450 | 5.6500 | ["190"] | ["0.5014"] | [] | ["MCRY"] | 190.0000 | 190.0000 | 123 | 494 | false | false | true | false | |||||||||
| 01a0a0b6-6278-7bf1-baf9-ea03842f0305 | JPM | 2026-09-14 12:18 | call_calendar | 2 | 1 | 25 | 585575.00 | short | ask | 351.2800 | 5.5500 | ["235"] | ["1.2242"] | [] | ["XCBO"] | 235.0000 | 235.0000 | 4 | 67 | false | false | true | false | |||||||||
| 01a0a0d2-a8c0-7142-a2c9-37a1e26dfef4 | JPM | 2026-09-14 12:49 | call_calendar | 2 | 1 | 9 | 282276.00 | short | ask | 352.8800 | 6.3500 | ["200"] | ["0.3993"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 123 | 494 | false | false | true | false | |||||||||
| 01a0a5e6-4ee6-74a3-a412-d245c116851e | JPM | 2026-09-15 12:28 | call_calendar | 2 | 1 | 9 | 218970.00 | short | bid | 344.7200 | 6.2000 | ["225"] | ["0.4456"] | [] | ["XPHO"] | 225.0000 | 225.0000 | 94 | 185 | false | false | true | false | |||||||||
| 01a0ab80-b6c4-7b42-8fac-343a12ed3274 | JPM | 2026-09-16 14:35 | call_calendar | 2 | 1 | 23 | 876070.00 | unknown | — | 350.0500 | 6.7000 | ["160"] | ["2.8786"] | [] | ["XPHO"] | 160.0000 | 160.0000 | 2 | 65 | false | false | true | false | false | mlet | |||||||
| 01a0b4d7-5e50-7971-a2a2-2d1c8055a95f | JPM | 2026-09-18 10:06 | call_calendar | 2 | 1 | 20 | 389120.00 | long | bid | 346.8500 | 6.1000 | ["250"] | ["3.6683"] | [] | ["XMIO"] | 250.0000 | 250.0000 | 0 | 91 | false | false | true | false | |||||||||
| 01a0b5c2-4320-7a50-a347-c093829f45a7 | JPM | 2026-09-18 14:23 | call_calendar | 2 | 1 | 30 | 166170.00 | short | ask | 348.2800 | 3.4500 | ["450"] | ["0.2254"] | [] | ["XCBO"] | 450.0000 | 450.0000 | 819 | 854 | false | true | true | false | |||||||||
| 01a0c973-0d9f-77f1-b687-6ce0e3f00aa6 | JPM | 2026-09-22 10:09 | call_calendar | 2 | 4 | 174 | 1129426.00 | short | bid | 343.4000 | 1.0000 | ["350"] | ["0.2321"] | [] | ["C2OX","EDGO","XCBO","XPHO"] | 350.0000 | 350.0000 | 268 | 360 | false | true | true | false | |||||||||
| 01a0c98e-7927-7393-9851-6b39a0690d98 | JPM | 2026-09-22 10:39 | call_calendar | 2 | 1 | 12 | 178608.00 | long | ask | 340.4350 | 6.1000 | ["270"] | ["0.2963"] | [] | ["XMIO"] | 270.0000 | 270.0000 | 24 | 178 | false | false | true | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:35:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:08:17Z"} |
| 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-10T13:30:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:53:45Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:39:11Z"} |
| 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-14T14:03: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-14T15:13:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:18:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:49:32Z"} |
| 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-15T16:29:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:35:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:06:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:23:43Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:09:19Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:39:15Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |