core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a08685-b7f0-7f51-9399-7c59d766968a | SPCH | 2026-09-09 10:15 | call_vertical_spread | 2 | 1 | 88 | 150920.00 | long | ask | 10.3079 | 0.5000 | ["1.5","2"] | ["11.3944","10.5571"] | ["1.99"] | ["XMIO"] | 1.5000 | 2.0000 | 2 | 2 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:15:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08687-fdf8-7ba2-8d27-f0af5312823e | SPCH | 2026-09-09 10:17 | call_vertical_spread | 2 | 1 | 89 | 152190.00 | unknown | — | 10.2881 | 0.4000 | ["1.5","2"] | ["11.3600","9.6491"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a08743-eb58-7040-a91b-66f4cf7e8d96 | SPCH | 2026-09-09 13:42 | call_vertical_spread | 2 | 1 | 99 | 156123.00 | long | ask | 9.6400 | 0.9000 | ["1.5","2"] | ["17.9854","17.3091"] | ["1.99"] | ["XCBO"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a08744-25f0-7c82-b0c5-c69dc7aae63f | SPCH | 2026-09-09 13:43 | call_vertical_spread | 2 | 1 | 99 | 155529.00 | unknown | — | 9.6350 | 0.9000 | ["1.5","2"] | ["18.1292","17.4063"] | [] | ["XISX"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a08744-58b8-7880-95b1-5c436c05a324 | SPCH | 2026-09-09 13:43 | call_vertical_spread | 2 | 1 | 99 | 155529.00 | unknown | — | 9.6350 | 0.9000 | ["1.5","2"] | ["18.1292","17.4063"] | [] | ["XISX"] | 1.5000 | 2.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0a17e-b3b8-73a1-8e2c-4b52143ff469 | SPCH | 2026-09-14 15:57 | call_vertical_spread | 2 | 1 | 249 | 381219.00 | unknown | — | 9.8199 | 0.9000 | ["2","2.5"] | ["9.1752","8.1121"] | [] | ["XISX"] | 2.0000 | 2.5000 | 4 | 4 | true | false | false | true | false | ||||||||
| 01a0a17f-4c11-7fd1-b975-ce2658c49d8f | SPCH | 2026-09-14 15:57 | call_vertical_spread | 2 | 1 | 200 | 306000.00 | unknown | — | 9.8250 | 0.8000 | ["2","2.5"] | ["9.0530","7.8074"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0b008-1b73-7671-89c2-8ec446e6f6cc | SPCH | 2026-09-17 11:41 | call_vertical_spread | 2 | 1 | 88 | 138072.00 | short | bid | 10.5650 | 0.6000 | ["2.5","3"] | ["13.3675","12.3847"] | ["2.99"] | ["XCBO"] | 2.5000 | 3.0000 | 1 | 1 | true | false | false | ||||||||||
| 01a0b008-560b-7200-9b00-3c52f3762109 | SPCH | 2026-09-17 11:42 | call_vertical_spread | 2 | 1 | 88 | 138160.00 | unknown | — | 10.5650 | 0.4000 | ["2.5","3"] | ["14.1084","12.3847"] | [] | ["XCBO"] | 2.5000 | 3.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b00e-ce4b-75f3-8479-6dcaac2e98d8 | SPCH | 2026-09-17 11:49 | call_vertical_spread | 2 | 1 | 88 | 124696.00 | long | ask | 10.5600 | 0.3000 | ["3","4"] | ["11.3363","9.4575"] | ["3.99"] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b010-58d2-7d81-8e55-5d8cbbbe1db2 | SPCH | 2026-09-17 11:50 | call_vertical_spread | 2 | 1 | 80 | 113360.00 | long | ask | 10.5600 | 0.3000 | ["3","4"] | ["11.3363","9.4575"] | ["3.99"] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b011-acab-7af0-bde3-255ea6c150a5 | SPCH | 2026-09-17 11:52 | call_vertical_spread | 2 | 1 | 80 | 113200.00 | long | ask | 10.5601 | 0.3000 | ["3","4"] | ["10.2770","8.8628"] | ["3.99"] | ["XMIO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0b012-d973-7bb3-9339-a76257ff4920 | SPCH | 2026-09-17 11:53 | call_vertical_spread | 2 | 1 | 200 | 282000.00 | unknown | — | 10.5501 | 0.2000 | ["3","4"] | ["13.1621","10.3280"] | [] | ["XCBO"] | 3.0000 | 4.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b097-382b-7b62-9d7e-6dcc30fbc81f | SPCH | 2026-09-17 14:18 | call_vertical_spread | 2 | 1 | 213 | 381057.00 | unknown | — | 10.6629 | 0.5000 | ["1.5","2"] | ["6.4602","5.7892"] | [] | ["XISX"] | 1.5000 | 2.0000 | 8 | 8 | true | false | false | true | false | ||||||||
| 01a0b09a-12a3-7891-9ff9-1e9b78ac3ccd | SPCH | 2026-09-17 14:21 | call_vertical_spread | 2 | 1 | 250 | 419750.00 | unknown | — | 10.7150 | 0.7000 | ["2","2.5"] | ["19.2736","16.7354"] | [] | ["XISX"] | 2.0000 | 2.5000 | 1 | 1 | true | false | false | true | false | ||||||||
| 01a0b0e5-4c73-7bb3-b6e3-54b74e342a7f | SPCH | 2026-09-17 15:43 | call_vertical_spread | 2 | 1 | 251 | 421680.00 | unknown | — | 10.7150 | 0.6000 | ["2","2.5"] | ["19.2736","16.7354"] | [] | ["XCBO"] | 2.0000 | 2.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0e9-191b-7a71-9e6d-b311ba56139d | SPCH | 2026-09-17 15:47 | call_vertical_spread | 2 | 1 | 293 | 521540.00 | unknown | — | 10.6257 | 0.6000 | ["1.5","2"] | ["6.3390","5.3854"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 8 | 8 | false | false | false | true | false | ||||||||
| 01a0b5d6-d4bf-79e1-8be9-3c0357ac15e6 | SPCH | 2026-09-18 14:45 | call_vertical_spread | 2 | 1 | 80 | 102480.00 | long | ask | 10.1150 | 0.7000 | ["3.5","4"] | ["46.8555","43.2602"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5d7-4dd8-7a41-84ec-bfb89c446236 | SPCH | 2026-09-18 14:46 | call_vertical_spread | 2 | 1 | 249 | 318969.00 | long | ask | 10.1233 | 0.7000 | ["3.5","4"] | ["45.0012","41.8973"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5db-83f7-7be1-ad98-fe808e4c2f30 | SPCH | 2026-09-18 14:50 | call_vertical_spread | 2 | 1 | 89 | 114009.00 | long | ask | 10.1150 | 0.7000 | ["3.5","4"] | ["48.5654","44.8389"] | ["3.99"] | ["XISX"] | 3.5000 | 4.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5f4-6af7-7752-9a8a-1fc7fd36098f | SPCH | 2026-09-18 15:18 | call_vertical_spread | 2 | 1 | 248 | 394568.00 | long | ask | 10.3450 | 0.9000 | ["2","2.5"] | ["102.3557","110.5968"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 0 | 0 | true | false | false | ||||||||||
| 01a0b5f5-1ac0-7812-9759-8314f21437cc | SPCH | 2026-09-18 15:18 | call_vertical_spread | 2 | 1 | 245 | 389795.00 | long | ask | 10.3250 | 0.9000 | ["2","2.5"] | ["109.5767","114.9518"] | ["2.49"] | ["XISX"] | 2.0000 | 2.5000 | 0 | 0 | false | false | false | ||||||||||
| 01a0b5f7-8bc0-7981-a9dc-e610039a7b7e | SPCH | 2026-09-18 15:21 | call_vertical_spread | 2 | 1 | 245 | 416255.00 | long | ask | 10.3480 | 0.7000 | ["1.5","2"] | ["7.6630","6.4987"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 7 | 7 | true | false | false | ||||||||||
| 01a0b5f8-8d90-79d1-b0c7-555bbdeff197 | SPCH | 2026-09-18 15:22 | call_vertical_spread | 2 | 1 | 220 | 375980.00 | long | ask | 10.3699 | 0.9000 | ["1.5","2"] | ["9.3228","7.8861"] | ["1.99"] | ["XISX"] | 1.5000 | 2.0000 | 7 | 7 | false | false | false | ||||||||||
| 01a0b5f9-934b-7b23-9de2-010006ec0f1b | SPCH | 2026-09-18 15:23 | call_vertical_spread | 2 | 1 | 300 | 513000.00 | unknown | — | 10.3950 | 0.8000 | ["1.5","2"] | ["8.8725","7.5138"] | [] | ["XCBO"] | 1.5000 | 2.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a0b5fc-3af7-7012-85a8-0f00e2510433 | SPCH | 2026-09-18 15:26 | call_vertical_spread | 2 | 1 | 75 | 128250.00 | unknown | — | 10.3638 | 0.8000 | ["1.5","2"] | ["9.4260","7.9712"] | [] | ["XMIO"] | 1.5000 | 2.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a0c99d-136f-7c41-8bb4-31e83830b72b | SPCH | 2026-09-22 10:55 | call_vertical_spread | 2 | 1 | 200 | 181800.00 | long | ask | 10.6393 | 3.6000 | ["18","20"] | ["0.9602","0.9622"] | ["18.25"] | ["XISX"] | 18.0000 | 20.0000 | 850 | 850 | true | true | false | ||||||||||
| 01a0c9fe-7137-7400-a8b9-a5993e849639 | SPCH | 2026-09-22 12:41 | call_vertical_spread | 2 | 1 | 150 | 133500.00 | long | ask | 10.4105 | 4.0000 | ["18","20"] | ["0.9660","0.9753"] | ["18.20"] | ["XCBO"] | 18.0000 | 20.0000 | 850 | 850 | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:17:43Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:43:14Z"} |
| 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-09T17:43:14Z"} |
| 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-09T17:44:14Z"} |
| 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-14T19:57:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:57:47Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:41:57Z"} |
| 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-17T15:42:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:49:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:51:08Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:52:31Z"} |
| 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-17T15:53:44Z"} |
| 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-17T18:18:15Z"} |
| 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-17T18:21:24Z"} |
| 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-17T19:43:55Z"} |
| 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-17T19:47:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:51:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:18:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:18:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:21:41Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:22:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:24:15Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:26:59Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:55:18Z"} |
| 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-22T16:41:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |