core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d9e2-5037-7031-9fd0-081051392d2f | TWLO | 2026-09-25 14:44 | call_vertical_spread | 2 | 1 | 25 | 216739.00 | long | ask | 277.4400 | 3.2000 | ["250","300"] | ["0.6471","0.6462"] | ["272.51"] | ["XMIO"] | 250.0000 | 300.0000 | 112 | 112 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T18:45:07Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d98c-f0bf-7191-9dd3-d1ddc968702b | TWLO | 2026-09-25 13:11 | call_diagonal_spread | 2 | 1 | 5 | 180230.00 | long | ask | 278.6000 | 7.3000 | ["115","130"] | ["0.7190","0.6748"] | [] | ["XCBO"] | 115.0000 | 130.0000 | 483 | 847 | false | false | true | ||||||||||
| 01a0d960-9d16-7440-a477-e02c5c1b59e4 | TWLO | 2026-09-25 12:22 | call_calendar | 2 | 1 | 5 | 176500.00 | unknown | — | 278.0900 | 9.0000 | ["115"] | ["0.7334"] | [] | ["XMIO"] | 115.0000 | 115.0000 | 357 | 483 | false | false | true | false | false | ||||||||
| 01a0d918-16ae-71e1-868e-79a55f4a8165 | TWLO | 2026-09-25 11:03 | call_vertical_spread | 2 | 1 | 54 | 1015686.00 | short | bid | 280.5400 | 7.2000 | ["185","195"] | ["0.7120","0.7139"] | ["193.91"] | ["XCBO"] | 185.0000 | 195.0000 | 56 | 56 | false | false | false | ||||||||||
| 01a0d468-d2f7-7402-89ac-13ce211a7ffb | TWLO | 2026-09-24 13:13 | call_diagonal_spread | 2 | 1 | 10 | 249250.00 | short | bid | 301.0100 | 5.9000 | ["230","280"] | ["0.6319","0.6111"] | [] | ["XPHO"] | 230.0000 | 280.0000 | 484 | 848 | false | false | true | ||||||||||
| 01a0d447-d98f-7130-8418-b7fd49d65d89 | TWLO | 2026-09-24 12:37 | call_vertical_spread | 2 | 1 | 10 | 204670.00 | long | ask | 297.3300 | 6.7000 | ["240","250"] | ["0.6455","0.6416"] | ["245.35"] | ["XCBO"] | 240.0000 | 250.0000 | 358 | 358 | false | false | false | ||||||||||
| 01a0d400-5cc7-7a13-b4af-997bc0865cbd | TWLO | 2026-09-24 11:19 | call_vertical_spread | 2 | 1 | 4 | 142000.00 | unknown | — | 294.5350 | 5.6000 | ["115","120"] | ["8.3791","8.0255"] | [] | ["XCBO"] | 115.0000 | 120.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 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 | ||||||||||
| 01a0ceb0-3977-7602-8b6e-e845b949d4f1 | TWLO | 2026-09-23 10:34 | call_vertical_spread | 2 | 1 | 11 | 231231.00 | short | bid | 288.0000 | 4.8000 | ["165","210"] | ["0.8642","0.7495"] | ["206.09"] | ["XMIO"] | 165.0000 | 210.0000 | 58 | 58 | false | false | false | ||||||||||
| 01a0c9b2-d9a7-74b2-b073-84a4aaeffb3f | TWLO | 2026-09-22 11:18 | call_diagonal_spread | 2 | 1 | 10 | 181080.00 | long | bid | 277.4350 | 8.0000 | ["220","240"] | ["0.6491","0.6353"] | [] | ["XCBO"] | 220.0000 | 240.0000 | 268 | 360 | false | false | true | ||||||||||
| 01a0c9a1-515f-7963-b146-f05fb9c40c55 | TWLO | 2026-09-22 10:59 | call_diagonal_spread | 2 | 1 | 20 | 102200.00 | short | bid | 280.0200 | 3.9000 | ["260","290"] | ["0.6138","0.6829"] | [] | ["XPHO"] | 260.0000 | 290.0000 | 10 | 59 | false | false | true | ||||||||||
| 01a0c4d5-810f-7f51-8a1e-d918df128a93 | TWLO | 2026-09-21 12:38 | call_diagonal_spread | 2 | 1 | 5 | 121605.00 | short | ask | 259.8750 | 7.6000 | ["140","160"] | ["0.7075","0.6672"] | [] | ["XCBO"] | 140.0000 | 160.0000 | 179 | 269 | false | false | true | ||||||||||
| 01a0b5fd-4497-7772-bebe-9c64ca342862 | TWLO | 2026-09-18 15:27 | call_diagonal_spread | 2 | 1 | 8 | 201840.00 | short | bid | 243.6550 | 5.6000 | ["120","140"] | ["48.2857","0.6627"] | [] | ["XMIO"] | 120.0000 | 140.0000 | 0 | 490 | false | false | true | ||||||||||
| 01a0afc7-bee3-7a91-bbbf-bb252319ebc5 | TWLO | 2026-09-17 10:31 | call_calendar | 2 | 1 | 10 | 199830.00 | short | bid | 244.6650 | 5.7000 | ["145"] | ["1.9480"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 1 | 29 | false | false | true | false | |||||||||
| 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 | false | ||||||||
| 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 | false | ||||||||
| 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 | false | ||||||||
| 01a0a67c-ed7d-7692-99f1-ecb1dbdf10db | TWLO | 2026-09-15 15:13 | call_vertical_spread | 2 | 1 | 10 | 116700.00 | short | bid | 240.8800 | 2.8000 | ["185","195"] | ["0.6517","0.6448"] | ["192.84"] | ["XMIO"] | 185.0000 | 195.0000 | 66 | 66 | false | 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 | false | ||||||||
| 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 | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:11:59Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:23:02Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:04:08Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:13:55Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:38:14Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:20:02Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| 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 |
| false |
| mlat |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:18:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:00:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:38:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:28:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:31:39Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| 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 |
| 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 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:14:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| 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 |
| 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 |