core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0cfa4-3a4e-73a0-a7ee-a244f309d241 | TWLO | 2026-09-23 15:00 | call_ratio_spread | 2 | 1 | 24 | 352000.00 | unknown | bid | 288.3200 | 6.5000 | ["250","350"] | ["0.6260","0.6033"] | ["378.00"] | ["XCBO"] | 250.0000 | 350.0000 | 485 | 485 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T19:01:07Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cf9c-e74f-7bd3-82d2-eac9f4096622 | TWLO | 2026-09-23 14:52 | call_ratio_spread | 2 | 3 | 12 | 178000.00 | unknown | ask | 287.6300 | 5.1500 | ["250","350"] | ["0.6394","0.6146"] | ["379.00"] | ["XISX"] | 250.0000 | 350.0000 | 485 | 485 | false | false | |||||||||||
| 01a0ced6-b507-7501-8e0a-977740e4e983 | TWLO | 2026-09-23 11:16 | call_vertical_spread | 2 | 1 | 12 | 116520.00 | unknown | — | 294.7300 | 5.8000 | ["240","260"] | ["0.6041","0.6124"] | [] | ["XMIO"] | 240.0000 | 260.0000 | 23 | 23 | false | false | false | true | |||||||||
| 01a0ceb0-3977-7602-8b6e-e824484362d2 | TWLO | 2026-09-23 10:34 | call_vertical_spread | 2 | 1 | 8 | 167760.00 | unknown | — | 288.0000 | 6.6000 | ["165","210"] | ["0.8092","0.7467"] | [] | ["BATO"] | 165.0000 | 210.0000 | 58 | 58 | false | false | false | true | |||||||||
| 01a0cea3-5c7f-7d12-88b4-d3f475973236 | TWLO | 2026-09-23 10:20 | strangle_swap | 4 | 1 | 6 | 138846.00 | unknown | bid | 290.8000 | 12.0000 | ["210","220","240","260"] | ["0.6599","0.6343","0.6322","0.6168"] | [] | ["XCBO"] | 210.0000 | 260.0000 | 177 | 205 | false | false | |||||||||||
| 01a0cea1-f51f-7430-bbfe-4db64ea8b162 | TWLO | 2026-09-23 10:18 | call_diagonal_spread | 2 | 3 | 105 | 279099.00 | unknown | bid | 292.3650 | 5.2000 | ["290","410"] | ["0.5966","0.6288"] | [] | ["C2OX","MCRY","SPHR"] | 290.0000 | 410.0000 | 23 | 177 | false | false | |||||||||||
| 01a0c55c-0a77-7b31-ab94-8a193466816d | TWLO | 2026-09-21 15:05 | put_diagonal_spread | 2 | 2 | 35 | 269465.00 | unknown | ask | 262.7301 | 8.0000 | ["210","230"] | ["0.6325","0.6207"] | [] | ["AMXO"] | 210.0000 | 230.0000 | 361 | 487 | false | true | |||||||||||
| 01a0b4bc-9ea7-79b1-8822-84eb198e796a | TWLO | 2026-09-18 09:37 | other | 4 | 3 | 8 | 133852.00 | unknown | ask | 242.0650 | 13.6000 | ["160","175","190","200"] | ["7.2225","0.6371","6.2624","0.5928"] | [] | ["XISX"] | 160.0000 | 200.0000 | 0 | 182 | false | false | |||||||||||
| 01a0ab8d-4983-7012-a483-3a99bde1b519 | TWLO | 2026-09-16 14:49 | call_diagonal_spread | 2 | 1 | 20 | 425800.00 | unknown | — | 240.4400 | 5.9000 | ["135","140"] | ["3.6481","0.6927"] | [] | ["XISX"] | 135.0000 | 140.0000 | 2 | 156 | false | false | true | true | |||||||||
| 01a0ab25-0a03-77b0-a02f-8dea2266ede0 | TWLO | 2026-09-16 12:55 | call_vertical_spread | 2 | 1 | 10 | 113000.00 | unknown | — | 238.3000 | 6.2000 | ["185","195"] | ["0.6733","0.6609"] | [] | ["XPHO"] | 185.0000 | 195.0000 | 65 | 65 | false | false | false | true | |||||||||
| 01a0ab14-f4d2-7fe0-ba51-856e6eac03ba | TWLO | 2026-09-16 12:37 | call_diagonal_spread | 2 | 2 | 28 | 104748.00 | unknown | — | 239.5400 | 2.3000 | ["230","235"] | ["0.5022","0.5090"] | [] | ["ARCO","C2OX"] | 230.0000 | 235.0000 | 30 | 37 | false | false | true | true | |||||||||
| 01a0aa84-af3b-7aa3-b8bb-d8f738d7bf49 | TWLO | 2026-09-16 10:00 | call_calendar | 2 | 1 | 5 | 107965.00 | unknown | — | 243.0125 | 6.5000 | ["135"] | ["2.9648"] | [] | ["XISX"] | 135.0000 | 135.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0aa6c-2dcb-7322-8908-d1f04eb5ac80 | TWLO | 2026-09-16 09:33 | call_vertical_spread | 2 | 1 | 10 | 118600.00 | unknown | — | 242.5350 | 5.2000 | ["185","195"] | ["0.6427","0.6268"] | [] | ["C2OX"] | 185.0000 | 195.0000 | 65 | 65 | false | false | false | true | |||||||||
| 01a0a697-534e-7332-802b-8314236fe89f | TWLO | 2026-09-15 15:42 | call_vertical_spread | 2 | 1 | 12 | 143520.00 | unknown | — | 242.8200 | 5.6000 | ["185","195"] | ["0.6441","0.6356"] | [] | ["BATO"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a693-7aee-7cd0-945b-26f3b0266c0d | TWLO | 2026-09-15 15:37 | call_vertical_spread | 2 | 1 | 10 | 119600.00 | unknown | — | 242.8300 | 5.6000 | ["185","195"] | ["0.6437","0.6353"] | [] | ["XISX"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a680-73d5-7fb0-a84c-d45196523eb0 | TWLO | 2026-09-15 15:17 | call_vertical_spread | 2 | 1 | 76 | 888364.00 | unknown | — | 240.8150 | 3.0000 | ["185","195"] | ["0.6597","0.6495"] | [] | ["XCBO"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a680-4cc6-7c50-8de5-cc1855c10885 | TWLO | 2026-09-15 15:16 | call_vertical_spread | 2 | 1 | 32 | 374016.00 | unknown | — | 240.8300 | 3.2000 | ["185","195"] | ["0.6587","0.6490"] | [] | ["XCBO"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a680-0e46-70b0-b3e9-8204b5816ce7 | TWLO | 2026-09-15 15:16 | call_vertical_spread | 2 | 5 | 54 | 630940.00 | unknown | — | 240.8300 | 3.2000 | ["185","195"] | ["0.6582","0.6479"] | [] | ["ARCO","EMLD","SPHR","XBOX","XISX"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a67f-4edd-7bd3-92ce-d68afcb9bdc8 | TWLO | 2026-09-15 15:15 | call_vertical_spread | 2 | 1 | 10 | 116850.00 | unknown | — | 241.0500 | 3.1000 | ["185","195"] | ["0.6486","0.6421"] | [] | ["XCBO"] | 185.0000 | 195.0000 | 66 | 66 | false | false | false | true | |||||||||
| 01a0a567-dbce-76a3-bf14-9cd29325e12c | TWLO | 2026-09-15 10:10 | call_diagonal_spread | 2 | 1 | 6 | 167520.00 | unknown | — | 232.3400 | 7.7000 | ["82.5","110"] | ["0.8431","0.7010"] | [] | ["ARCO"] | 82.5000 | 110.0000 | 122 | 213 | false | false | true | true | |||||||||
| 01a0a17b-c1d0-77a1-ba0b-ffb7764002d4 | TWLO | 2026-09-14 15:53 | other | 3 | 1 | 549 | 535824.00 | unknown | — | 232.5750 | 3.3500 | ["215","230","247.5"] | ["0.4850","0.5077","0.5927"] | [] | ["MCRY"] | 215.0000 | 247.5000 | 4 | 11 | false | true | true | true | |||||||||
| 01a09133-50b9-7210-8016-26a5d02b66c6 | TWLO | 2026-09-11 12:00 | other | 2 | 1 | 5 | 124775.00 | unknown | — | 228.6350 | 5.6500 | ["115"] | ["0.6931"] | [] | ["XISX"] | 115.0000 | 115.0000 | 279 | 371 | false | false | true | false | false | ||||||||
| 01a09132-ef10-7ba2-bb1b-952700aef513 | TWLO | 2026-09-11 12:00 | other | 2 | 1 | 5 | 120620.00 | unknown | — | 228.6900 | 4.2000 | ["115"] | ["0.6827"] | [] | ["XISX"] | 115.0000 | 115.0000 | 189 | 279 | false | false | true | false | false | ||||||||
| 01a0876e-00c9-7423-879a-19ab804bb83a | TWLO | 2026-09-09 14:28 | other | 3 | 3 | 100 | 124385.00 | unknown | — | 228.3850 | 4.4500 | ["200","220","230"] | ["0.5207","0.5361","0.6115"] | [] | ["XPHO"] | 200.0000 | 230.0000 | 2 | 16 | false | false | true | true | |||||||||
| 01a08671-64d0-7ba2-a3d7-a7f3f5fdb125 | TWLO | 2026-09-09 09:52 | other | 3 | 1 | 181 | 253219.00 | unknown | — | 227.0200 | 6.8500 | ["200","220","230"] | ["0.5446","0.5321","0.6105"] | [] | ["XPHO"] | 200.0000 | 230.0000 | 2 | 16 | false | false | true | true | |||||||||
| 01a081e7-8368-7b60-bc7d-5a084030c305 | TWLO | 2026-09-08 12:43 | other | 3 | 1 | 622 | 971652.00 | unknown | — | 223.9600 | 4.1500 | ["200","215","230"] | ["0.5128","0.5506","0.5817"] | [] | ["SPHR"] | 200.0000 | 230.0000 | 3 | 17 | false | false | true | true | |||||||||
| 01a06d84-cb9e-7a81-9eb8-09ef044db77e | TWLO | 2026-09-04 13:43 | call_vertical_spread | 2 | 2 | 55 | 111915.00 | unknown | — | 234.8800 | 2.1000 | ["235","240"] | ["0.4923","0.4958"] | [] | ["BATO","C2OX"] | 235.0000 | 240.0000 | 21 | 21 | true | true | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:53:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:16:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:34:22Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:20:17Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:18:42Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:05:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:37:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:49:52Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:56:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:38:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:00:19Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:33:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:42:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:38:20Z"} |
| 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:17:45Z"} |
| 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:17:45Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:16:57Z"} |
| 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:16:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:10:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:54: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-11T16:01:10Z"} |
| 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-11T16:01:10Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:29:19Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:53:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:44:09Z"} |
| 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-04T17:43:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |