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 |
|---|
| 01a0c4a7-02b6-7d52-b233-a2b4dccdc895 | PM | 2026-09-21 11:47 | call_diagonal_spread | 2 | 1 | 22 | 322388.00 | long | bid | 187.3100 | 5.9000 | ["115","120"] | ["0.2787","0.2807"] | [] | ["XCBO"] | 115.0000 | 120.0000 | 487 | 851 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:48:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b58b-b647-77a3-b43b-892ba5921074 | PM | 2026-09-18 13:23 | call_calendar | 2 | 1 | 13 | 235690.00 | unknown | — | 189.6200 | 5.8000 | ["100"] | ["0.2841"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 490 | 854 | false | false | true | false | false | mlat | |||||||
| 01a09140-2db0-79d1-af37-d4224a8c3104 | PM | 2026-09-11 12:14 | call_calendar | 2 | 1 | 18 | 126810.00 | short | bid | 194.1500 | 5.3000 | ["160"] | ["0.2998"] | [] | ["AMXO"] | 160.0000 | 160.0000 | 70 | 98 | false | false | true | false | false | ||||||||
| 01a0824b-ea89-7880-bc7c-352fcf501d96 | PM | 2026-09-08 14:33 | call_vertical_spread | 2 | 1 | 15 | 241740.00 | short | bid | 186.6250 | 5.3000 | ["100","115"] | ["0.2747","0.2771"] | ["113.50"] | ["XMIO"] | 100.0000 | 115.0000 | 500 | 500 | false | false | false | true | false | ||||||||
| 01a06de2-e95d-78f2-930f-1e08cf3869b2 | PM | 2026-09-04 15:26 | other | 2 | 1 | 100 | 191004.00 | unknown | — | 182.5550 | 0.8000 | ["180"] | ["0.2600"] | [] | ["XMIO"] | 180.0000 | 180.0000 | 42 | 77 | false | false | true | false | false | mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:24:11Z"} |
| 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-11T16:15:29Z"} |
| 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-08T18:34: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-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |