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 | direction |
|---|
| 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 |
|---|
| 01a0ca62-7e7f-7642-b618-d2da9e9bed06 | SPCX | 2026-09-22 14:30 | call_calendar | 2 | 1 | 8 | 32680.00 | long | bid | 154.0600 | 0.4000 | ["140"] | ["0.5174"] | [] | ["MCRY"] | 140.0000 | 140.0000 | 24 | 87 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:30:51Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c4b1-7a67-74b0-abb2-ebe29527a6fd | SPCX | 2026-09-21 11:59 | call_calendar | 2 | 1 | 10 | 34250.00 | unknown | bid | 155.2200 | 0.5000 | ["200"] | ["0.5374"] | [] | ["XPHO"] | 200.0000 | 200.0000 | 116 | 487 | false | true | true | false | |||||||||
| 01a0b5ed-b81f-7aa1-bbcd-76dd3a73fcd0 | SPCX | 2026-09-18 15:10 | call_calendar | 2 | 1 | 166 | 29880.00 | unknown | ask | 151.4300 | 0.0300 | ["155"] | ["1.9400"] | [] | ["ARCO"] | 155.0000 | 155.0000 | 0 | 7 | false | true | true | false | |||||||||
| 01a0b4f0-5107-7b02-96e8-74ad771a4598 | SPCX | 2026-09-18 10:34 | call_calendar | 2 | 1 | 20 | 49400.00 | short | ask | 151.9700 | 0.6000 | ["140"] | ["1.0053"] | [] | ["XISX"] | 140.0000 | 140.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0b099-10d3-7531-9959-5eeadf544982 | SPCX | 2026-09-17 14:20 | call_calendar | 2 | 1 | 10 | 103700.00 | unknown | — | 155.0862 | 2.2000 | ["160"] | ["0.5625"] | [] | ["XISX"] | 160.0000 | 160.0000 | 638 | 855 | false | true | true | false | false | mesl | |||||||
| 01a0b000-ef83-7750-a56e-45652facc92f | SPCX | 2026-09-17 11:34 | call_calendar | 2 | 1 | 31 | 305040.00 | short | bid | 153.9700 | 0.5000 | ["105"] | ["1.8616"] | [] | ["XBOX"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0b000-ef83-7750-a56e-4506a69ba50c | SPCX | 2026-09-17 11:34 | call_calendar | 2 | 2 | 32 | 314880.00 | short | bid | 153.9700 | 0.5000 | ["105"] | ["1.8616"] | [] | ["XBOX","XPHO"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0b000-ef83-7750-a56e-44dbbe578eee | SPCX | 2026-09-17 11:34 | call_calendar | 2 | 1 | 31 | 305040.00 | short | bid | 153.9700 | 0.5000 | ["105"] | ["1.8616"] | [] | ["XBOX"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0b000-ef83-7750-a56e-4483e2a40461 | SPCX | 2026-09-17 11:34 | call_calendar | 2 | 1 | 14 | 137760.00 | short | bid | 153.9700 | 0.5000 | ["105"] | ["1.8616"] | [] | ["XBOX"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0b000-ef83-7750-a56e-4446d8a72770 | SPCX | 2026-09-17 11:34 | call_calendar | 2 | 2 | 35 | 344400.00 | short | bid | 153.9700 | 0.5000 | ["105"] | ["1.8616"] | [] | ["XBOX","XPHO"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0aff2-7c4b-7aa2-9a58-4a8bb7bc2ea1 | SPCX | 2026-09-17 11:18 | call_calendar | 2 | 1 | 28 | 139580.00 | short | bid | 154.0400 | 0.2000 | ["130"] | ["0.9880"] | [] | ["C2OX"] | 130.0000 | 130.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0afca-37b3-7d73-8667-2e96579872b1 | SPCX | 2026-09-17 10:34 | call_calendar | 2 | 1 | 24 | 240000.00 | short | bid | 154.6850 | 1.5000 | ["105"] | ["1.8876"] | [] | ["C2OX"] | 105.0000 | 105.0000 | 1 | 29 | false | false | true | false | |||||||||
| 01a0a5a9-0f36-7f30-9893-35b3ffa87d42 | SPCX | 2026-09-15 11:21 | call_calendar | 2 | 1 | 5 | 30850.00 | long | bid | 145.2200 | 1.8000 | ["130"] | ["0.7327"] | [] | ["MCRY"] | 130.0000 | 130.0000 | 3 | 493 | false | false | true | false | |||||||||
| 01a0a100-aa18-7ba2-b69a-8b81e970fbdf | SPCX | 2026-09-14 13:39 | call_calendar | 2 | 1 | 200 | 76200.00 | short | ask | 151.8700 | 0.0600 | ["160"] | ["0.5694"] | [] | ["XISX"] | 160.0000 | 160.0000 | 4 | 11 | false | true | true | false | |||||||||
| 01a0a038-4938-7ea3-bf5f-053b2d9bf739 | SPCX | 2026-09-14 10:00 | call_calendar | 2 | 1 | 200 | 52600.00 | short | bid | 148.5640 | 0.0400 | ["160"] | ["0.5994"] | [] | ["XISX"] | 160.0000 | 160.0000 | 4 | 11 | false | true | true | false | |||||||||
| 01a09147-59a0-7f83-ad66-f347d9f7fdce | SPCX | 2026-09-11 12:22 | call_calendar | 2 | 1 | 200 | 109400.00 | unknown | — | 148.6501 | 0.1200 | ["155"] | ["0.5190"] | [] | ["XISX"] | 155.0000 | 155.0000 | 7 | 14 | false | true | true | false | false | mesl |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:59:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:11:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:34:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:20:34Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:34:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:34:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:34:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:34:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:34:48Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:18:41Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:34:22Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:22:15Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:39:45Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:00: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-11T16:22:57Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |