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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0e0-08cb-75c1-8497-aa70cb7cc155 | CRCL | 2026-09-17 15:37 | call_vertical_spread | 2 | 1 | 1000 | 346000.00 | unknown | — | 85.0600 | 0.2200 | ["88","93"] | ["0.7035","0.7304"] | [] | ["EDGO"] | 88.0000 | 93.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:38:12Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0dc-47db-7300-be74-2b561a7a7f96 | CRCL | 2026-09-17 15:33 | call_vertical_spread | 2 | 1 | 1000 | 348000.00 | unknown | — | 84.9800 | 0.3200 | ["88","93"] | ["0.7120","0.7379"] | [] | ["EDGO"] | 88.0000 | 93.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:33:51Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b09c-02bb-7243-a50a-826932d849c4 | CRCL | 2026-09-17 14:23 | call_vertical_spread | 2 | 1 | 1000 | 355000.00 | unknown | — | 85.1000 | 0.2800 | ["88","93"] | ["0.7105","0.7387"] | [] | ["EDGO"] | 88.0000 | 93.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:24:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b099-e3c3-72b1-b1f9-2b8b1f8405e6 | CRCL | 2026-09-17 14:21 | call_vertical_spread | 2 | 1 | 1000 | 352000.00 | unknown | — | 84.9200 | 0.2900 | ["88","93"] | ["0.7211","0.7467"] | [] | ["EDGO"] | 88.0000 | 93.0000 | 8 | 8 | true | true | false | true | false | mlat | 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 |
| 01a09161-e298-7170-a7c4-41a544051a74 | CRCL | 2026-09-11 12:51 | call_vertical_spread | 2 | 1 | 68 | 571064.00 | long | ask | 92.5200 | 8.4500 | ["51","52"] | ["21.9661","21.4721"] | ["51.98"] | ["XCBO"] | 51.0000 | 52.0000 | 0 | 0 | false | false | false | true | false | mlat | 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 |
| 01a09161-5210-75a0-89fc-040837e16ae5 | CRCL | 2026-09-11 12:51 | call_vertical_spread | 2 | 1 | 16 | 113488.00 | unknown | — | 92.6200 | 4.3000 | ["57","58"] | ["14.7635","14.3887"] | [] | ["XCBO"] | 57.0000 | 58.0000 | 0 | 0 | false | false | false | true | false | mlat | 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 |
| 01a087c0-fee0-7b41-b812-9c46ae883c34 | CRCL | 2026-09-09 15:59 | call_vertical_spread | 2 | 1 | 350 | 236600.00 | unknown | — | 92.8550 | 0.2700 | ["95","99"] | ["0.8493","0.8677"] | [] | ["XISX"] | 95.0000 | 99.0000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:59:26Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08188-8701-7c33-94db-2f07bf45a949 | CRCL | 2026-09-08 11:00 | call_vertical_spread | 2 | 1 | 12 | 106848.00 | short | bid | 98.2400 | 7.8500 | ["100","140"] | ["0.8442","0.8463"] | ["108.54"] | ["XCBO"] | 100.0000 | 140.0000 | 829 | 829 | false | true | false | true | false | mlat | 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 |
| 01a08148-0b31-7e52-aa86-f8ad2192ba4f | CRCL | 2026-09-08 09:49 | call_vertical_spread | 2 | 1 | 150 | 171300.00 | unknown | — | 98.3150 | 0.6000 | ["97","100"] | ["0.8796","0.8834"] | [] | ["XCBO"] | 97.0000 | 100.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:49:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd6-b45d-7e12-a34c-28e99eea3120 | CRCL | 2026-09-04 15:12 | call_vertical_spread | 2 | 1 | 343 | 782726.00 | short | bid | 101.6000 | 2.7000 | ["88","92"] | ["11.8453","9.0282"] | ["92"] | ["EDGO"] | 88.0000 | 92.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:13:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2f-d985-7b91-bed3-236e6677ef45 | CRCL | 2026-09-04 12:10 | call_vertical_spread | 2 | 1 | 343 | 184877.00 | long | ask | 102.0250 | 0.6000 | ["104","108"] | ["0.7388","0.7600"] | ["105.25"] | ["XCBO"] | 104.0000 | 108.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:10:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |