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 | net_sidetext |
|---|
| 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 |
|---|
| 01a0b613-0acf-7de1-a653-d697bfc61bfe | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 90 | 537660.00 | unknown | bid | 168.5600 | 1.9000 | ["120","157.5"] | ["1.3764","0.4237"] | ["168.62"] | ["XPHO"] | 120.0000 | 157.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c46b-12f7-7981-829b-7ed87f9ab579 | XLV | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 19 | 116356.00 | long | ask | 168.8800 | 4.2500 | ["135","140"] | ["0.6210","0.5628"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 11 | 11 | false | false | false | true | false | ||||||||
| 01a0c483-6d57-7cd3-8835-b29613ea9585 | XLV | 2026-09-21 11:08 | other | 3 | 1 | 871 | 73628.00 | unknown | — | 168.7500 | 1.4600 | ["120","130","140"] | ["0.2355","0.2252","0.2229"] | [] | ["XCBO"] | 120.0000 | 140.0000 | 88 | 361 | false | true | true | true | false | mfsl | |||||||
| 01a0c483-6d57-7cd3-8835-b2af338979f7 | XLV | 2026-09-21 11:09 | other | 3 | 1 | 871 | 254658.00 | unknown | bid | 168.7500 | 2.1100 | ["135","150","155"] | ["0.2185","0.2021","0.1922"] | [] | ["XCBO"] | 135.0000 | 155.0000 | 88 | 361 | false | true | true | true | false | ||||||||
| 01a0c4d4-9e7f-7e41-bf83-da23a98f241f | XLV | 2026-09-21 12:37 | call_vertical_spread | 2 | 1 | 2 | 26426.00 | long | ask | 168.6200 | 3.5500 | ["100","105"] | ["1.3333","1.2597"] | ["104.97"] | ["XMIO"] | 100.0000 | 105.0000 | 18 | 18 | false | false | false | true | false | ||||||||
| 01a0c536-ee77-7281-992a-894800dc995f | XLV | 2026-09-21 14:25 | call_diagonal_spread | 2 | 1 | 16 | 26656.00 | short | bid | 169.4450 | 2.7500 | ["190","210"] | ["0.1506","0.1485"] | [] | ["BATO"] | 190.0000 | 210.0000 | 487 | 851 | false | true | true | true | false | ||||||||
| 01a0c9f9-25bf-7f61-95fe-dcfb5b9cf7a1 | XLV | 2026-09-22 12:35 | call_vertical_spread | 2 | 1 | 50 | 323100.00 | long | ask | 170.1000 | 2.8000 | ["135","140"] | ["0.7379","0.6847"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0c9fe-59c7-73c2-841d-c93e073bda6b | XLV | 2026-09-22 12:41 | call_vertical_spread | 2 | 1 | 50 | 323000.00 | long | ask | 170.0950 | 2.8000 | ["135","140"] | ["0.7409","0.6868"] | ["139.98"] | ["XPHO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0ca00-d67f-7092-8d51-75966afebf21 | XLV | 2026-09-22 12:44 | call_vertical_spread | 2 | 1 | 3 | 34419.00 | short | bid | 170.1100 | 3.9500 | ["110","115"] | ["1.1336","1.0685"] | ["114.99"] | ["XMIO"] | 110.0000 | 115.0000 | 17 | 17 | false | false | false | true | false | ||||||||
| 01a0ca78-024f-75e1-8ca1-b80b371e3a01 | XLV | 2026-09-22 14:54 | put_diagonal_spread | 2 | 1 | 2700 | 830200.00 | unknown | ask | 170.1700 | 1.1300 | ["145","160"] | ["0.2105","0.1970"] | [] | ["XBOX"] | 145.0000 | 160.0000 | 115 | 360 | false | true | true | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:42:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:09:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:09:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:37:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:25:30Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:36:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:41:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:44:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:54:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |