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_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 |
|---|
| 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 | mlet | 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 |
| 01a08756-c778-7163-a9cd-0b062b8f3edc | XLV | 2026-09-09 14:03 | call_diagonal_spread | 2 | 1 | 23 | 90459.00 | long | bid | 166.7200 | 2.5000 | ["147","150"] | ["0.4655","0.1551"] | [] | ["XCBO"] | 147.0000 | 150.0000 | 9 | 128 | false | false | true | true | |||||||||
| 01a08be0-52f0-7290-be31-4d08a82f9b4b | XLV | 2026-09-10 11:12 | call_vertical_spread | 2 | 1 | 44 | 58997.00 | short | bid | 165.7700 | 1.9000 | ["165","180"] | ["0.1587","0.1563"] | ["171.24"] | ["XCBO"] | 165.0000 | 180.0000 | 190 | 190 | false | false | false | true | |||||||||
| 01a0a04f-e819-7753-b7ee-f7c9797953ae | XLV | 2026-09-14 10:26 | call_vertical_spread | 2 | 1 | 2 | 26062.00 | short | bid | 167.0700 | 2.5000 | ["100","105"] | ["1.6065","1.4871"] | ["104.97"] | ["XPHO"] | 100.0000 | 105.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a0a5db-5266-7e90-af60-bceecbb3112b | XLV | 2026-09-15 12:16 | call_vertical_spread | 2 | 1 | 10 | 39570.00 | short | bid | 167.4700 | 2.6500 | ["145","150"] | ["1.0852","0.7118"] | ["149.17"] | ["XCBO"] | 145.0000 | 150.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a673-d946-7be2-8691-391ec4b87521 | XLV | 2026-09-15 15:03 | straddle | 2 | 1 | 310 | 201019.00 | short | bid | 167.5900 | 0.3000 | ["167"] | ["0.1653"] | ["160.52","173.48"] | ["XMIO"] | 167.0000 | 167.0000 | 31 | 31 | true | false | false | false | |||||||||
| 01a0b530-e447-7863-90ef-df1e403fab41 | XLV | 2026-09-18 11:44 | call_diagonal_spread | 2 | 1 | 10 | 26790.00 | unknown | bid | 168.1800 | 2.2400 | ["150","170"] | ["0.1473","0.1273"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 7 | 364 | false | false | true | true | |||||||||
| 01a0b539-0e20-74c1-a470-688ee6a0345c | XLV | 2026-09-18 11:53 | put_ratio_spread | 2 | 1 | 15000 | 5200000.00 | unknown | bid | 167.9800 | 1.8700 | ["90","135"] | ["0.2687","0.2198"] | ["6.20","131.90"] | ["ARCO"] | 90.0000 | 135.0000 | 854 | 854 | true | true | false | true | |||||||||
| 01a0b5db-2638-70e0-8b86-aba972f01f82 | XLV | 2026-09-18 14:50 | call_ladder | 6 | 1 | 5 | 127220.00 | unknown | bid | 168.8500 | 6.4000 | ["90","95","100","155","158","159"] | ["1.9959","1.8323","1.6771","0.3287","0.2653","0.2075"] | ["134.40","168.80"] | ["XPHO"] | 90.0000 | 159.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a0b5e3-9277-7513-a594-622890c7e896 | XLV | 2026-09-18 14:59 | call_diagonal_spread | 2 | 1 | 45 | 26685.00 | unknown | bid | 168.7900 | 0.9000 | ["166","172"] | ["1.3497","0.1471"] | [] | ["XISX"] | 166.0000 | 172.0000 | 0 | 63 | false | false | true | true | |||||||||
| 01a0b612-c868-7633-a6f3-c1a97d5fd962 | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 60 | 582960.00 | short | bid | 168.6150 | 2.0500 | ["115","125"] | ["1.5861","1.2009"] | ["125"] | ["XPHO"] | 115.0000 | 125.0000 | 7 | 7 | false | false | false | true | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:04:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:12:54Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:26:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:17:18Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:04:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:45:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:53:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:50:33Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:00:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:51:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| 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 |
| mfsl |
| 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 |
| mlet |
| 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 |
| mlat |
| 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 |