core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0eeaf-a948-7b20-a2e3-aea76565cf35 | TWLO | 2026-09-29 15:41 | iron_butterfly | 4 | 1 | 5 | 103975.00 | long | bid | 290.0425 | 10.5500 | ["180","190","200"] | ["0.7208","0.7138","0.6928"] | ["180.05","199.95"] | ["XMIO"] | 180.0000 | 200.0000 | 80 | 80 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T19:41:43Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0eead-20d7-7103-9095-769a6e773c00 | TWLO | 2026-09-29 15:38 | iron_butterfly | 4 | 1 | 5 | 103980.00 | long | bid | 290.1650 | 10.5500 | ["180","190","200"] | ["0.7259","0.7074","0.6909"] | ["180.32","199.68"] | ["XMIO"] | 180.0000 | 200.0000 | 80 | 80 | false | false | |||||||||||
| 01a0e8d3-10ef-78a3-9755-0c1127b4239c | TWLO | 2026-09-28 12:22 | other | 5 | 1 | 1000 | 3448150.00 | unknown | bid | 284.1650 | 13.9500 | ["240","310","315","330","350"] | ["0.6164","0.7682","0.6099","0.7699","0.7635"] | [] | ["XMIO"] | 240.0000 | 350.0000 | 25 | 39 | true | true | |||||||||||
| 01a0e8ac-cc0f-7240-b8a5-dc9e4b920d96 | TWLO | 2026-09-28 11:40 | put_ratio_spread | 2 | 1 | 277 | 582265.00 | unknown | bid | 283.8400 | 3.6000 | ["275","285"] | ["0.6335","0.6322"] | ["280.32"] | ["SPHR"] | 275.0000 | 285.0000 | 11 | 11 | false | false | |||||||||||
| 01a0e83f-f0df-7d90-b42d-9b62fe228aff | TWLO | 2026-09-28 09:41 | other | 4 | 1 | 10 | 252480.00 | unknown | bid | 273.9900 | 12.1000 | ["160","200","230"] | ["0.6851","0.6600","0.6450"] | [] | ["XPHO"] | 160.0000 | 230.0000 | 109 | 480 | 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 | |||||||||||
| 01a0d8fb-c0c7-7133-a707-7d6a10a8c83a | TWLO | 2026-09-25 10:32 | put_vertical_spread | 2 | 2 | 500 | 1274500.00 | short | bid | 279.7750 | 1.9000 | ["250","290"] | ["0.6157","0.5650"] | ["274.25"] | ["ARCO"] | 250.0000 | 290.0000 | 21 | 21 | true | 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 | |||||||||||
| 01a0d39c-215a-76f3-b239-0e243b3f4a14 | TWLO | 2026-09-24 09:30 | call_diagonal_spread | 2 | 1 | 35 | 617785.00 | short | bid | 289.2800 | 13.9000 | ["290","360"] | ["0.6073","0.5919"] | [] | ["XCBO"] | 290.0000 | 360.0000 | 484 | 848 | false | true | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0ceb0-3977-7602-8b6e-e83e6e47b1e1 | TWLO | 2026-09-23 10:34 | call_vertical_spread | 2 | 1 | 8 | 166800.00 | short | bid | 288.0000 | 4.5000 | ["165","210"] | ["0.7101","0.7180"] | ["205.70"] | ["XCBO"] | 165.0000 | 210.0000 | 58 | 58 | false | false | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0c4b0-556e-7851-aced-a1ed47d53288 | TWLO | 2026-09-21 11:58 | call_diagonal_spread | 2 | 1 | 17 | 106930.00 | short | bid | 260.8400 | 3.4000 | ["260","280"] | ["0.6483","0.6031"] | [] | ["XMIO"] | 260.0000 | 280.0000 | 60 | 151 | false | false | |||||||||||
| 01a0c4ae-f5df-7c42-93ae-15010434890d | TWLO | 2026-09-21 11:56 | call_diagonal_spread | 2 | 1 | 17 | 106760.00 | short | bid | 260.7000 | 3.2000 | ["260","280"] | ["0.6490","0.6034"] | [] | ["C2OX"] | 260.0000 | 280.0000 | 60 | 151 | false | false | |||||||||||
| 01a0c47f-a87f-7e11-954a-eaa8e2b13ead | TWLO | 2026-09-21 11:04 | call_diagonal_spread | 2 | 1 | 8 | 202192.00 | short | bid | 256.2600 | 7.5000 | ["160","190"] | ["0.6448","0.6192"] | [] | ["XCBO"] | 160.0000 | 190.0000 | 487 | 851 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0b011-d3bb-7122-850d-77524d30f875 | TWLO | 2026-09-17 11:52 | call_diagonal_spread | 2 | 1 | 10 | 109000.00 | long | bid | 244.0900 | 5.3000 | ["200","310"] | ["0.5978","0.5858"] | [] | ["XISX"] | 200.0000 | 310.0000 | 120 | 491 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0aaf7-f30b-7f23-b770-5aeb1ec7999c | TWLO | 2026-09-16 12:06 | call_vertical_spread | 2 | 1 | 10 | 113950.00 | short | bid | 239.3000 | 6.3000 | ["185","195"] | ["0.6573","0.6473"] | ["192.85"] | ["XMIO"] | 185.0000 | 195.0000 | 65 | 65 | false | 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 | |||||||||||
| 01a0a5bb-33be-71c0-8215-965b814be583 | TWLO | 2026-09-15 11:41 | call_calendar | 2 | 1 | 8 | 154784.00 | short | bid | 236.9150 | 6.6000 | ["140"] | ["2.2010"] | [] | ["BATO"] | 140.0000 | 140.0000 | 3 | 31 | false | false | |||||||||||
| 01a0879c-e4b0-7e42-a522-70d41ed79d45 | TWLO | 2026-09-09 15:19 | straddle | 2 | 1 | 500 | 6100000.00 | short | bid | 227.1900 | 5.9000 | ["280"] | ["0.5995"] | ["158","402.00"] | ["SPHR"] | 280.0000 | 280.0000 | 373 | 373 | true | false | |||||||||||
| 01a08169-3760-7e53-bc54-638e61b9bf5a | TWLO | 2026-09-08 10:25 | call_vertical_spread | 2 | 1 | 197 | 194636.00 | short | bid | 223.0250 | 1.2500 | ["222.5","250"] | ["0.5638","0.5646"] | ["229.96"] | ["ARCO"] | 222.5000 | 250.0000 | 10 | 10 | false | false |
| true |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:38:41Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:22:35Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:40:45Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:41:51Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| 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 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:33:15Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:30:12Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| 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 |
| true |
| 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 |
| true |
| false |
| mesl |
| 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 |
| 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 |
| true |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:58:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:56:47Z"} |
| 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-21T15:04:55Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:53:05Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:07:08Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| 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 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:41:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:20:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |