Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0f2-507b-77f2-8ac6-ace45295cd59 | CRCL | 2026-09-17 15:57 | call_vertical_spread | 2 | 1 | 29 | 152076.00 | long | ask | 84.9600 | 2.4000 | ["140","190"] | ["0.8041","0.8023"] | ["146.60"] | ["BATO"] | 140.0000 | 190.0000 | 820 | 820 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b02b-0cc3-7eb2-a783-2957ecfb07b6 | CRCL | 2026-09-17 12:20 | call_vertical_spread | 2 | 1 | 77 | 120739.00 | unknown | — | 84.3200 | 0.5700 | ["70","85"] | ["1.4404","0.9356"] | [] | ["XISX"] | 70.0000 | 85.0000 | 1 | 1 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:20:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba9-ca63-76f2-9d6f-d5e62d540109 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274800.00 | long | ask | 78.6200 | 4.9000 | ["75","125"] | ["0.8318","0.8207"] | ["86.12"] | ["XMIO"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-ca63-76f2-9d6f-d5d634edb344 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274800.00 | long | ask | 78.6200 | 4.9000 | ["75","125"] | ["0.8315","0.8210"] | ["86.10"] | ["XMIO"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-c67b-7ca1-a128-3da8a8cb9445 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274600.00 | long | ask | 78.6200 | 4.9500 | ["75","125"] | ["0.8555","0.8009"] | ["87.85"] | ["XISX"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-c67b-7ca1-a128-3d91dbf06992 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 278200.00 | long | ask | 78.6200 | 5.9500 | ["75","125"] | ["0.8786","0.8029"] | ["88.57"] | ["XISX"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae6-014b-79c3-a1fb-7e2cf009c72d | CRCL | 2026-09-16 11:46 | call_vertical_spread | 2 | 1 | 47 | 105891.00 | long | ask | 81.0368 | 1.2500 | ["190","230"] | ["0.8318","0.8405"] | ["192.75"] | ["EDGO"] | 190.0000 | 230.0000 | 492 | 492 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:47:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa5-8963-7af2-adb2-beb892909408 | CRCL | 2026-09-16 10:36 | call_vertical_spread | 2 | 1 | 200 | 248800.00 | unknown | — | 80.0800 | 0.3500 | ["90","100"] | ["0.8091","0.8217"] | [] | ["XISX"] | 90.0000 | 100.0000 | 65 | 65 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:36:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a05a-2148-7691-8cb0-0641e8fbaa66 | CRCL | 2026-09-14 10:37 | call_vertical_spread | 2 | 2 | 58 | 140534.00 | short | bid | 92.4050 | 4.1000 | ["85","96"] | ["0.8229","0.8338"] | ["90.09"] | ["ARCO","XISX"] | 85.0000 | 96.0000 | 46 | 46 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:37:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05a-2148-7691-8cb0-061af9e92226 | CRCL | 2026-09-14 10:37 | call_vertical_spread | 2 | 2 | 90 | 216720.00 | short | bid | 92.4050 | 4.1000 | ["85","96"] | ["0.8148","0.8296"] | ["90.05"] | ["ARCO","XISX"] | 85.0000 | 96.0000 | 46 | 46 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:37:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03d-b7d8-7521-b887-af92a98ef68d | CRCL | 2026-09-14 10:06 | call_vertical_spread | 2 | 1 | 99 | 141471.00 | long | ask | 93.1994 | 5.9000 | ["98","115"] | ["0.8515","0.8744"] | ["102.57"] | ["XPHO"] | 98.0000 | 115.0000 | 46 | 46 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:06:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09161-a418-7191-a292-addc1ca2a5e5 | CRCL | 2026-09-11 12:51 | call_vertical_spread | 2 | 1 | 58 | 456924.00 | unknown | — | 92.6000 | 5.3000 | ["53","54"] | ["16.0908","15.8139"] | [] | ["XISX"] | 53.0000 | 54.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0912e-2099-7050-bdf4-9bd5e19ce770 | CRCL | 2026-09-11 11:55 | call_vertical_spread | 2 | 1 | 27 | 207468.00 | long | ask | 92.3450 | 8.3500 | ["55","56"] | ["19.5371","19.0637"] | ["55.98"] | ["EDGO"] | 55.0000 | 56.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:55:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b3-c078-71c2-80b0-73ce8c69804c | CRCL | 2026-09-11 09:41 | call_vertical_spread | 2 | 1 | 200 | 486000.00 | unknown | — | 92.1450 | 2.2000 | ["90","100"] | ["0.8011","0.8090"] | [] | ["XISX"] | 90.0000 | 100.0000 | 70 | 70 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:41:37Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a081cf-6788-7ff2-952c-39e6640f1f79 | CRCL | 2026-09-08 12:17 | call_vertical_spread | 2 | 6 | 1143 | 2719029.00 | short | bid | 97.9000 | 2.3227 | ["94","100"] | ["0.8132","0.8275"] | ["96.57"] | ["AMXO","ARCO","XCBO","XISX","XPHO"] | 94.0000 | 100.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:17:50Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08188-8701-7c33-94db-2f229512252b | CRCL | 2026-09-08 11:00 | call_vertical_spread | 2 | 5 | 18 | 160376.00 | short | bid | 98.2400 | 7.8500 | ["100","140"] | ["0.8444","0.8472"] | ["108.50"] | ["ARCO","XCBO"] | 100.0000 | 140.0000 | 829 | 829 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:00:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08158-b4d1-7d23-9e53-7a7246a35b23 | CRCL | 2026-09-08 10:07 | call_vertical_spread | 2 | 3 | 612 | 1389546.00 | unknown | — | 97.9450 | 2.2500 | ["92","105"] | ["0.8025","0.8196"] | [] | ["ARCO","XISX","XPHO"] | 92.0000 | 105.0000 | 45 | 45 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:08:00Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08156-9da8-7681-932d-e6fc510752f5 | CRCL | 2026-09-08 10:05 | call_vertical_spread | 2 | 1 | 309 | 728004.00 | short | bid | 98.4800 | 2.6000 | ["91","105"] | ["0.7841","0.8147"] | ["97"] | ["XPHO"] | 91.0000 | 105.0000 | 45 | 45 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:05:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08156-1cc0-7e41-bf3d-e785e1da4d9f | CRCL | 2026-09-08 10:04 | call_vertical_spread | 2 | 3 | 334 | 786125.00 | short | bid | 98.3585 | 3.3500 | ["91","105"] | ["0.7923","0.8157"] | ["97.06"] | ["ARCO","EMLD","XISX"] | 91.0000 | 105.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:04:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dcf-22dd-7d01-8c69-160d2c4cb804 | CRCL | 2026-09-04 15:04 | call_vertical_spread | 2 | 1 | 80 | 471200.00 | long | ask | 101.8050 | 2.7000 | ["65","80"] | ["1.3240","0.7186"] | ["79.62"] | ["XISX"] | 65.0000 | 80.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:04:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4b-29b6-7090-9cde-64374b0b1bc1 | CRCL | 2026-09-04 12:40 | call_vertical_spread | 2 | 1 | 40 | 146920.00 | long | ask | 102.5100 | 2.9500 | ["95","170"] | ["0.8004","0.8196"] | ["113.55"] | ["ARCO"] | 95.0000 | 170.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4b-25cd-77d1-9be5-eb338fa796c0 | CRCL | 2026-09-04 12:40 | call_vertical_spread | 2 | 1 | 40 | 146920.00 | long | ask | 102.5100 | 2.9500 | ["95","170"] | ["0.7960","0.8241"] | ["113.31"] | ["ARCO"] | 95.0000 | 170.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |