core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0c98e-9097-7273-8903-98ff13246016 | SMH | 2026-09-22 10:39 | synthetic | 2 | 1 | 9 | 98892.00 | long | ask | 602.1000 | 4.1000 | ["545"] | ["0.3793"] | ["608.48"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:39:47Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c986-f35f-7eb2-8323-213c214f3010 | SMH | 2026-09-22 10:30 | synthetic | 2 | 1 | 10 | 110800.00 | long | ask | 602.2156 | 3.4000 | ["545"] | ["0.3832"] | ["608.58"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c476-f9d7-7a23-bf8d-d29625e8da73 | SMH | 2026-09-21 10:55 | synthetic | 2 | 1 | 6 | 33930.00 | long | ask | 586.9800 | 0.5000 | ["545"] | ["0.3679"] | ["588.61"] | ["AMXO"] | 545.0000 | 545.0000 | 25 | 25 | false | false | false | false | |||||||||
| 01a0b5f1-1f38-7540-9d6b-f1832bc8d651 | SMH | 2026-09-18 15:14 | synthetic | 2 | 1 | 300 | 57000.00 | long | ask | 565.4400 | 0.4300 | ["565"] | ["0.4447"] | ["565.70"] | ["XPHO"] | 565.0000 | 565.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b529-3387-71a0-a7e9-3f5fb796255b | SMH | 2026-09-18 11:36 | synthetic | 2 | 2 | 800 | 217600.00 | long | ask | 565.3500 | 0.4500 | ["565"] | ["0.2677"] | ["565.50"] | ["AMXO"] | 565.0000 | 565.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0b505-3897-7ab1-b2d6-eacfd13f5c67 | SMH | 2026-09-18 10:56 | synthetic | 2 | 1 | 180 | 699480.00 | long | ask | 565.2400 | 1.1000 | ["565"] | ["0.3115"] | ["567.34"] | ["XBOX"] | 565.0000 | 565.0000 | 28 | 28 | false | false | false | false | |||||||||
| 01a0a55b-be3e-7dc0-b5ae-19b2a10d7b2e | SMH | 2026-09-15 09:57 | synthetic | 2 | 1 | 570 | 544350.00 | long | ask | 546.9400 | 2.1000 | ["545"] | ["0.4129"] | ["547.45"] | ["XPHO"] | 545.0000 | 545.0000 | 1 | 1 | true | false | false | false | |||||||||
| 01a0a0c9-abf9-79d2-8489-cddfbd687cb7 | SMH | 2026-09-14 12:39 | synthetic | 2 | 1 | 3 | 26640.00 | long | ask | 543.6600 | 0.8000 | ["550"] | ["0.3536"] | ["550.30"] | ["XPHO"] | 550.0000 | 550.0000 | 123 | 123 | false | false | false | false | |||||||||
| 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 | |||||||||
| 01a0a022-2d10-7c33-af14-8a4c897d73a8 | SMH | 2026-09-14 09:36 | synthetic | 2 | 1 | 154 | 1406328.00 | short | ask | 538.0900 | 3.5500 | ["545"] | ["0.3673"] | ["544.04"] | ["ARCO"] | 545.0000 | 545.0000 | 123 | 123 | false | false | false | false | |||||||||
| 01a090fe-8ce8-7a32-bd76-ab76a8ab0c2f | SMH | 2026-09-11 11:03 | synthetic | 2 | 1 | 5 | 25355.00 | short | ask | 569.1200 | 2.9000 | ["572.5"] | ["0.3288"] | ["571.37"] | ["AMXO"] | 572.5000 | 572.5000 | 42 | 42 | false | false | false | false | |||||||||
| 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 | |||||||||
| 01a090e7-1130-7780-ad36-0c1108753ede | SMH | 2026-09-11 10:37 | synthetic | 2 | 2 | 18 | 150300.00 | long | ask | 568.4850 | 0.7000 | ["565"] | ["0.3573"] | ["574.77"] | ["AMXO","ARCO"] | 565.0000 | 565.0000 | 98 | 98 | false | false | false | false | |||||||||
| 01a090e6-d699-75c0-a955-cbaad0f27059 | SMH | 2026-09-11 10:37 | synthetic | 2 | 1 | 8 | 66864.00 | long | ask | 568.7000 | 0.7500 | ["565"] | ["0.3575"] | ["575.18"] | ["AMXO"] | 565.0000 | 565.0000 | 98 | 98 | false | false | false | false | |||||||||
| 01a08ba9-7fc8-7cf3-9f04-9f881c265802 | SMH | 2026-09-10 10:12 | synthetic | 2 | 1 | 11 | 94930.00 | long | ask | 559.9300 | 1.0000 | ["565"] | ["0.3705"] | ["566.36"] | ["ARCO"] | 565.0000 | 565.0000 | 99 | 99 | false | false | false | false | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 01a0870d-00c1-7fb1-8e3a-b158849839d9 | SMH | 2026-09-09 12:42 | synthetic | 2 | 1 | 10 | 159350.00 | short | ask | 574.5700 | 3.3000 | ["630"] | ["0.3799"] | ["589.95"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a081ec-32a0-73a3-a223-5f7b94898320 | SMH | 2026-09-08 12:48 | synthetic | 2 | 1 | 4 | 37092.00 | short | ask | 575.0000 | 4.5500 | ["590"] | ["0.3810"] | ["581.61"] | ["ARCO"] | 590.0000 | 590.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081eb-f420-77e1-9447-c4de1980cafd | SMH | 2026-09-08 12:48 | synthetic | 2 | 1 | 4 | 37060.00 | long | ask | 575.2200 | 4.0000 | ["565"] | ["0.3861"] | ["581.81"] | ["ARCO"] | 565.0000 | 565.0000 | 101 | 101 | false | false | false | false | |||||||||
| 01a081e3-fd10-7ee1-86ea-1d82955f289e | SMH | 2026-09-08 12:39 | synthetic | 2 | 2 | 19 | 103341.00 | short | ask | 575.0500 | 1.6000 | ["580"] | ["0.3665"] | ["577.32"] | ["ARCO","XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081e3-f928-7251-a3a1-2bf623874e6d | SMH | 2026-09-08 12:39 | synthetic | 2 | 1 | 11 | 59818.00 | short | ask | 575.0500 | 2.0500 | ["580"] | ["0.3664"] | ["576.88"] | ["XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a081d2-6140-7ce3-9498-4a8ad0e878b0 | SMH | 2026-09-08 12:20 | synthetic | 2 | 2 | 10 | 54500.00 | short | ask | 576.3900 | 1.6500 | ["580"] | ["0.3670"] | ["578.25"] | ["C2OX","XBOX"] | 580.0000 | 580.0000 | 38 | 38 | false | false | false | false | |||||||||
| 01a06d79-a80d-7893-bd2b-be7e495cc314 | SMH | 2026-09-04 13:31 | synthetic | 2 | 4 | 5 | 54569.00 | short | ask | 564.2250 | 2.1400 | ["630"] | ["0.3475"] | ["571.15"] | ["EMLD","SPHR","XBOX"] | 630.0000 | 630.0000 | 133 | 133 | false | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:31:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:55:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:14:50Z"} |
| 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-18T15:36:25Z"} |
| 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-18T14:57:13Z"} |
| 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-15T13:57:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:36:27Z"} |
| 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-11T15:03:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:37:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:37:21Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:12:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| 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 |
| mesl |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:43:08Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:48:57Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:48:57Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:21:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:31:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |