core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a0e8e5-ae8f-7952-8f4c-17bfd9641e91 | XLV | 2026-09-28 12:42 | call_vertical_spread | 2 | 1 | 3 | 47088.00 | unknown | ask | 171.4699 | 2.8000 | ["90","95"] | ["1.5054","1.3745"] | ["170.98"] | ["MCRY"] | 90.0000 | 95.0000 | 11 | 11 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T16:42:54Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0d409-421f-79c1-ab3c-116613d8cab6 | XLV | 2026-09-24 11:29 | other | 4 | 1 | 88 | 25696.00 | unknown | — | 169.8300 | 1.0800 | ["167","170","173"] | ["0.1618","0.1705","0.1768"] | [] | ["XPHO"] | 167.0000 | 173.0000 | 8 | 8 | false | false | false | true | true | mlet | |||||||
| 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 | |||||||
| 01a0b612-b0f8-7421-8617-65e629495d4a | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 68800.00 | unknown | ask | 168.5850 | 4.2000 | ["90","110"] | ["0.8741","1.4075"] | [] | ["XPHO"] | 90.0000 | 110.0000 | 7 | 21 | false | false | true | ||||||||||
| 01a0b612-a53f-7d83-8365-d23d2cc83620 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 31830.00 | unknown | ask | 168.6100 | 4.3500 | ["120","154"] | ["0.8215","0.3397"] | [] | ["XPHO"] | 120.0000 | 154.0000 | 14 | 28 | false | false | true | ||||||||||
| 01a0b612-9d6f-7561-a9c3-39d1f8d69249 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 10 | 72320.00 | unknown | ask | 168.5900 | 2.8500 | ["115","150"] | ["1.6004","0.4183"] | [] | ["XPHO"] | 115.0000 | 150.0000 | 7 | 14 | 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 | ||||||||||
| 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 | ||||||||||
| 01a0aab0-d403-7350-84a4-4b7db3c8ba46 | XLV | 2026-09-16 10:48 | put_vertical_spread | 2 | 1 | 369 | 62730.00 | unknown | — | 168.1500 | 0.3500 | ["140","155"] | ["0.2175","0.1928"] | [] | ["XCBO"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | ||||||||
| 01a0aab0-c84b-7831-be26-c49dab40f0f0 | XLV | 2026-09-16 10:48 | put_vertical_spread | 2 | 1 | 187 | 28798.00 | unknown | — | 168.1500 | 0.4000 | ["140","155"] | ["0.2037","0.1889"] | [] | ["XBOX"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | ||||||||
| 01a0aaaf-ed8b-7b83-83e5-8ee27722bccf | XLV | 2026-09-16 10:47 | put_vertical_spread | 2 | 2 | 206 | 34196.00 | unknown | — | 168.1500 | 0.5100 | ["140","155"] | ["0.2190","0.1904"] | [] | ["C2OX","EDGO"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | ||||||||
| 01a0aa72-a9f3-7961-be94-f36f1bd4992b | XLV | 2026-09-16 09:40 | call_vertical_spread | 2 | 1 | 10 | 58060.00 | unknown | — | 168.2350 | 3.5500 | ["120","200"] | ["0.3174","0.1500"] | [] | ["XCBO"] | 120.0000 | 200.0000 | 492 | 492 | false | false | false | true | false | ||||||||
| 01a0a5ee-78be-7ab0-89e4-ffca68255e41 | XLV | 2026-09-15 12:37 | call_diagonal_spread | 2 | 2 | 20 | 62060.00 | unknown | — | 167.9400 | 1.2563 | ["152","155"] | ["0.5858","0.1460"] | [] | ["XISX"] | 152.0000 | 155.0000 | 3 | 94 | false | false | true | true | false | ||||||||
| 01a0a592-fec6-7e92-8f3f-0a239d9f8f5c | XLV | 2026-09-15 10:57 | call_diagonal_spread | 2 | 1 | 14 | 54796.00 | unknown | — | 166.9700 | 2.1000 | ["145","155"] | ["0.7171","0.1504"] | [] | ["MCRY"] | 145.0000 | 155.0000 | 3 | 185 | false | false | true | true | false | ||||||||
| 01a0914d-9748-7402-a419-5b0a2799a9ee | XLV | 2026-09-11 12:29 | other | 2 | 2 | 12 | 78696.00 | unknown | — | 165.5600 | 4.8500 | ["134","135"] | ["0.2215","0.2839"] | [] | ["XMIO"] | 134.0000 | 135.0000 | 98 | 126 | false | false | true | true | false | mlet | |||||||
| 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 | |||||||
| 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 | |||||||
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:29:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 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 |
| false |
| mlft |
| tracked |
| 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 |
| false |
| mlft |
| tracked |
| 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 |
| false |
| mlft |
| tracked |
| 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 |
| false |
| 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 |
| false |
| 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 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:48:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:48:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:47:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:40:43Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:37:44Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:57:57Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:29:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| 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 |
| tracked |
| 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 |
| 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 |