core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 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 | 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 |
| 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 | true | 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 | false | true | |||||||||
| 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 | true | |||||||||
| 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 | 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 | true | true | |||||||||
| 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 | true | true | |||||||||
| 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 | true | 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 | true | true | |||||||||
| 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 | true | true | |||||||||
| 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 | true | true | |||||||||
| 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 | true | 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 | true | |||||||||
| 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 | true | 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 | 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 | false | true | |||||||||
| 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 | true | |||||||||
| 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 | true | 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 | false | false | true | ||||||||
| 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 | false | true |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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-15T15:41:53Z"} |
| 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-09T19:20:29Z"} |
| 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-08T14:25:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |