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 |
|---|
| 01a08222-3e90-7aa3-877e-e40780d39286 | XLV | 2026-09-08 13:47 | other | 2 | 1 | 41 | 44936.00 | unknown | — | 167.9200 | 0.6600 | ["170","180"] | ["0.1576","0.1507"] | [] | ["BATO"] | 170.0000 | 180.0000 | 129 | 192 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08220-bbd8-7952-a753-7fce438b7b6c | XLV | 2026-09-08 13:46 | other | 2 | 1 | 52 | 56992.00 | unknown | — | 167.8700 | 0.6600 | ["170","180"] | ["0.1582","0.1511"] | [] | ["XISX"] | 170.0000 | 180.0000 | 129 | 192 | false | true | true | true | false | mlet | |||||||
| 01a081e2-a169-7f81-8a41-5cca6432067a | XLV | 2026-09-08 12:38 | call_vertical_spread | 2 | 1 | 12 | 132840.00 | long | ask | 167.7200 | 3.2000 | ["110","115"] | ["2.0091","1.8657"] | ["114.98"] | ["XISX"] | 110.0000 | 115.0000 | 3 | 3 | false | false | false | true | false | ||||||||
| 01a081df-6160-7f73-91f9-18d06de56f32 | XLV | 2026-09-08 12:34 | call_vertical_spread | 2 | 1 | 11 | 198924.00 | long | ask | 167.8000 | 2.9000 | ["75","80"] | ["1.7880","1.7198"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a081dc-aa10-7d60-bdb9-731fc9f16fe7 | XLV | 2026-09-08 12:31 | call_vertical_spread | 2 | 1 | 37 | 669182.00 | long | ask | 167.8300 | 2.9000 | ["75","80"] | ["1.6329","1.6247"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a081d3-ff51-7cf0-b0c0-3f61ba1bea93 | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 2 | 36168.00 | long | ask | 167.5550 | 2.9000 | ["75","80"] | ["2.3198","2.1663"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a081d3-e010-73f1-b456-2a40bcba270d | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 48 | 868128.00 | long | ask | 167.5200 | 2.9000 | ["75","80"] | ["2.3724","2.2139"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a081ba-5500-7673-b7e5-d5e2436e5ce9 | XLV | 2026-09-08 11:54 | other | 4 | 1 | 6 | 40368.00 | unknown | — | 167.1600 | 5.0800 | ["100","135","136","147"] | ["0.4404","0.9597","0.2732","0.1936"] | [] | ["XPHO"] | 100.0000 | 147.0000 | 10 | 101 | false | false | true | true | true | mlet | |||||||
| 01a081b6-af68-7c62-95fa-b7a1f3d03b0d | XLV | 2026-09-08 11:50 | put_vertical_spread | 2 | 1 | 10000 | 3120000.00 | unknown | — | 167.2350 | 0.8800 | ["150","157"] | ["0.1970","0.1893"] | [] | ["SPHR"] | 150.0000 | 157.0000 | 101 | 101 | false | true | false | true | false | mlft | |||||||
| 01a06d87-57f5-7012-b9dd-7f8393e94e33 | XLV | 2026-09-04 13:46 | call_diagonal_spread_bearish | 2 | 1 | 5 | 27655.00 | long | bid | 171.4900 | 2.7500 | ["144","146"] | ["0.5226","0.1896"] | [] | ["XCBO"] | 144.0000 | 146.0000 | 14 | 133 | false | false | true | true | false |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:46:42Z"} |
| 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-08T16:38:28Z"} |
| 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-08T16:34:56Z"} |
| 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-08T16:32:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:22:41Z"} |
| 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-08T16:22:41Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:54:58Z"} |
| 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-08T15:50:48Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:46:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |