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 |
|---|
| 01a0a0c9-a810-7fb3-bd68-fb109aebfe99 | SMH | 2026-09-14 12:39 | synthetic | 2 | 1 | 5 | 44350.00 | long | ask | 543.6600 | 1.0000 | ["550"] | ["0.3532"] | ["550.40"] | ["MCRY"] | 550.0000 | 550.0000 | 123 | 123 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:40:05Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090fd-b228-7af3-ae87-e41df0604491 | SMH | 2026-09-11 11:02 | synthetic | 2 | 1 | 6 | 27750.00 | long | ask | 569.2200 | 0.7000 | ["570"] | ["0.3293"] | ["571.45"] | ["XMIO"] | 570.0000 | 570.0000 | 35 | 35 | false | false | false | false | true | ||||||||
| 01a08c13-c2e8-7850-a8fa-e38c92a375b2 | SMH | 2026-09-10 12:08 | other | 2 | 1 | 13 | 34580.00 | unknown | — | 563.5500 | 0.5500 | ["575"] | ["0.3383"] | [] | ["XISX"] | 575.0000 | 575.0000 | 8 | 36 | false | true | true | false | false | mesl | |||||||
| 01a08bdc-3058-7f61-b971-319f7cc02a18 | SMH | 2026-09-10 11:07 | ratio_risk_reversal | 2 | 1 | 6 | 36585.00 | long | ask | 564.5400 | 1.1000 | ["485","630"] | ["0.3967","0.3696"] | ["478.88"] | ["ARCO"] | 485.0000 | 630.0000 | 280 | 280 | false | true | false | true | true | ||||||||
| 01a08bd3-2fa8-79d3-a4d4-1b987d40eb2d | SMH | 2026-09-10 10:57 | put_vertical_spread | 2 | 1 | 15 | 79650.00 | unknown | — | 563.8800 | 2.6000 | ["510","550"] | ["0.3856","0.3698"] | [] | ["XISX"] | 510.0000 | 550.0000 | 99 | 99 | false | true | false | true | false | mesl | |||||||
| 01a08bb2-ce98-7473-babe-7482a9630b04 | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 22 | 135190.00 | short | ask | 560.3062 | 1.2000 | ["520","675"] | ["0.3867","0.3549"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | true | ||||||||
| 01a08bb2-ce98-7473-babe-7475cbf0b96c | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 6 | 36870.00 | short | ask | 560.2500 | 0.7000 | ["520","675"] | ["0.3867","0.3551"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | true | ||||||||
| 01a08bac-0c20-7f30-b68c-1947fc8861af | SMH | 2026-09-10 10:15 | put_vertical_spread | 2 | 1 | 25 | 48975.00 | short | bid | 559.4100 | 2.1400 | ["510","565"] | ["0.3843","0.3428"] | ["549.49"] | ["C2OX"] | 510.0000 | 565.0000 | 14 | 14 | true | false | false | true | false | ||||||||
| 01a0871c-4ad0-7cf0-a409-b870484b149d | SMH | 2026-09-09 12:59 | call_vertical_spread | 2 | 1 | 10 | 66750.00 | unknown | — | 574.3900 | 5.4500 | ["795","900"] | ["0.3659","0.3628"] | [] | ["ARCO"] | 795.0000 | 900.0000 | 464 | 464 | false | true | false | true | false | mesl | |||||||
| 01a08714-1159-7fb0-b89a-8ec40d08db1e | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 23 | 366965.00 | short | ask | 575.1400 | 0.3000 | ["630"] | ["0.3804"] | ["592.25"] | ["MCRY"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a08714-0988-7842-9d01-de2f48466a43 | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 2 | 31910.00 | short | ask | 575.1650 | 0.8000 | ["630"] | ["0.3804"] | ["592.25"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a08714-0988-7842-9d01-de0f318c6576 | SMH | 2026-09-09 12:50 | synthetic | 2 | 2 | 4 | 63820.00 | long | bid | 575.1750 | 1.5000 | ["630"] | ["0.3804"] | ["593.05"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a08714-0988-7842-9d01-ddf7b57c5669 | SMH | 2026-09-09 12:50 | synthetic | 2 | 2 | 3 | 47865.00 | long | bid | 575.1750 | 1.7000 | ["630"] | ["0.3804"] | ["593.05"] | ["MCRY","XPHO"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a0870d-d798-7990-8629-235415095d4d | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 8 | 127640.00 | long | ask | 574.5300 | 0.3500 | ["630"] | ["0.3803"] | ["470.45","789.55"] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a0870d-d798-7990-8629-2345e739a452 | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 3 | 47865.00 | long | ask | 574.5300 | 0.7000 | ["630"] | ["0.3804"] | ["470.45","789.55"] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a0870d-d3b0-7ab2-bb8b-5fa64729b495 | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 3 | 47865.00 | unknown | — | 574.5400 | 0.4500 | ["630"] | ["0.3804"] | [] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | |||||||
| 01a0870d-d3b0-7ab2-bb8b-5f8a7fdde218 | SMH | 2026-09-09 12:43 | straddle | 2 | 1 | 3 | 47865.00 | unknown | — | 574.5400 | 1.0000 | ["630"] | ["0.3804"] | [] | ["C2OX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | true | mesl | |||||||
| 01a086ad-b250-7be3-a606-6a20a8fec65c | SMH | 2026-09-09 10:58 | other | 2 | 1 | 38 | 45258.00 | unknown | — | 575.7100 | 0.3500 | ["520","535"] | ["0.4327","0.3845"] | [] | ["XISX"] | 520.0000 | 535.0000 | 9 | 37 | false | true | true | true | false | mesl | |||||||
| 01a086a0-0a38-71c3-a4ac-b7b77bd9175e | SMH | 2026-09-09 10:43 | call_vertical_spread | 2 | 1 | 30 | 49200.00 | short | bid | 575.2450 | 2.6500 | ["580","615"] | ["0.3487","0.3435"] | ["590.10"] | ["C2OX"] | 580.0000 | 615.0000 | 13 | 13 | true | true | false | true | |||||||||
| 01a0869c-d5e8-70e1-9d1b-3c6dfaed9f68 | SMH | 2026-09-09 10:40 | call_vertical_spread | 2 | 1 | 35 | 39515.00 | short | bid | 575.7300 | 1.5700 | ["590","640"] | ["0.3486","0.3555"] | ["598.81"] | ["C2OX"] | 590.0000 | 640.0000 | 14 | 14 | false | true | false | true | |||||||||
| 01a08698-fd88-72d0-8bb4-fb8fb5c3593c | SMH | 2026-09-09 10:36 | call_vertical_spread | 2 | 2 | 35 | 33110.00 | short | bid | 575.8500 | 2.1100 | ["595","645"] | ["0.3479","0.3624"] | ["602.34"] | ["C2OX"] | 595.0000 | 645.0000 | 14 | 14 | false | true | false | true | |||||||||
| 01a081d6-ed51-7861-b9b7-2a69b8d3ba5c | SMH | 2026-09-08 12:25 | other | 2 | 1 | 10 | 27000.00 | unknown | — | 576.7400 | 0.5500 | ["510","552.5"] | ["0.4046","0.3734"] | [] | ["ARCO"] | 510.0000 | 552.5000 | 31 | 73 | false | true | true | true | false | mesl | |||||||
| 01a08150-5830-7802-a46d-74e70c58546e | SMH | 2026-09-08 09:58 | put_vertical_spread | 2 | 3 | 48 | 25488.00 | long | ask | 574.6550 | 0.2100 | ["400","500"] | ["0.5575","0.4002"] | ["496.01"] | ["C2OX","EDGO"] | 400.0000 | 500.0000 | 38 | 38 | false | true | false | true | |||||||||
| 01a08145-6768-7660-992c-5d4ece045a3e | SMH | 2026-09-08 09:46 | put_vertical_spread | 2 | 1 | 75 | 35700.00 | short | bid | 574.3850 | 0.3600 | ["525","535"] | ["0.4323","0.4139"] | ["534.04"] | ["C2OX"] | 525.0000 | 535.0000 | 10 | 10 | false | true | false | true | false | ||||||||
| 01a06dce-f7e5-70f3-aaf6-32a90f685839 | SMH | 2026-09-04 15:04 | call_vertical_spread | 2 | 1 | 10 | 35450.00 | unknown | — | 564.3000 | 3.0000 | ["710","940"] | ["0.3491","0.3413"] | [] | ["ARCO"] | 710.0000 | 940.0000 | 286 | 286 | false | true | false | true | false | mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:02:45Z"} |
| 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-10T16:08:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:07:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:57:53Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:22:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:22:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:59:36Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:44:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:44:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:44:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:44:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:58:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:44:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:40:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:36:25Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:25:44Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:58:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:46:53Z"} |
| 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-04T19:04:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |