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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c533-5496-7820-9f62-53233490bfa8 | CRCL | 2026-09-21 14:21 | other | 4 | 1 | 642 | 629160.00 | unknown | bid | 94.0400 | 0.7500 | ["78","81","92","95"] | ["0.9845","0.9134","0.7696","0.7779"] | [] | ["XPHO"] | 78.0000 | 95.0000 | 4 | 11 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:21:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4da-824e-70c0-bde0-7b54f53a143a | CRCL | 2026-09-21 12:44 | strangle | 2 | 1 | 25 | 258675.00 | unknown | ask | 94.1200 | 9.2000 | ["90","120"] | ["0.8224","0.8457"] | ["101.36"] | ["XCBO"] | 90.0000 | 120.0000 | 851 | 851 | true | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:44:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5a1-e20f-7fe0-8403-0a4b2232794d | CRCL | 2026-09-18 13:47 | other | 4 | 1 | 1100 | 602072.00 | unknown | bid | 91.2500 | 0.6600 | ["90","93.5","94","99"] | ["1.0672","1.1866","0.7382","0.7837"] | [] | ["EDGO"] | 90.0000 | 99.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:48:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 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-d47b-7e51-b3a0-ae8984604b8f | CRCL | 2026-09-17 15:34 | put_vertical_spread | 2 | 1 | 647 | 626296.00 | unknown | — | 84.9800 | 1.1500 | ["88","91"] | ["0.8595","0.9504"] | [] | ["EDGO"] | 88.0000 | 91.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:34:32Z"} | 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 |
| 01a09207-59f9-7e63-a5b7-bbbc0d834ee6 | CRCL | 2026-09-11 15:52 | iron_butterfly | 4 | 1 | 103 | 103000.00 | unknown | — | 90.9000 | 0.7900 | ["82","90","98"] | ["0.7475","0.7652","0.8038"] | [] | ["XCBO"] | 82.0000 | 98.0000 | 7 | 7 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:52:34Z"} | 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 |
| 01a090d3-c7b0-7aa3-b7ec-30013faa6846 | CRCL | 2026-09-11 10:16 | other | 4 | 1 | 100 | 144700.00 | unknown | — | 94.4950 | 1.8600 | ["89","94","95","99"] | ["2.0916","1.3275","0.8727","0.8696"] | [] | ["AMXO"] | 89.0000 | 99.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:16:48Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbd-9778-71c1-99e4-ed910e119a2a | CRCL | 2026-09-10 15:13 | other | 4 | 1 | 336 | 205296.00 | unknown | — | 91.1590 | 0.9600 | ["93","97","104","108"] | ["0.8147","0.8448","1.2414","1.7102"] | [] | ["EDGO"] | 93.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:14:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7b-cbb8-76e0-9397-764688266cee | CRCL | 2026-09-10 14:01 | other | 4 | 1 | 500 | 318500.00 | unknown | — | 91.0000 | 0.4400 | ["92","96","103","108"] | ["0.7957","0.8176","1.0929","1.3692"] | [] | ["EDGO"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:02:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c65-ced1-7870-8ab1-d2da5e356284 | CRCL | 2026-09-10 13:37 | other | 4 | 1 | 500 | 330600.00 | unknown | — | 91.3600 | 0.3900 | ["92","96","103","108"] | ["0.7904","0.8102","1.0626","1.3411"] | [] | ["EDGO"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:37:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c16-bca0-7393-a7b0-2dfff1ad75a2 | CRCL | 2026-09-10 12:11 | put_vertical_spread | 2 | 1 | 642 | 466734.00 | unknown | — | 90.7600 | 0.4300 | ["88","91"] | ["0.7936","0.7958"] | [] | ["XCBO"] | 88.0000 | 91.0000 | 8 | 8 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:11:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bdf-0eb9-7b41-a146-7479efc09f74 | CRCL | 2026-09-10 11:10 | other | 4 | 1 | 175 | 134050.00 | unknown | — | 91.8500 | 0.5100 | ["92","96","103","108"] | ["0.8438","0.8574","1.2431","1.3725"] | [] | ["XISX"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:11:16Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bcc-8c70-7a31-9912-71776a1266d0 | CRCL | 2026-09-10 10:50 | other | 4 | 1 | 400 | 288400.00 | unknown | — | 92.4500 | 0.6200 | ["93","97","105","110"] | ["0.8284","0.8470","1.2386","1.3841"] | [] | ["EDGO"] | 93.0000 | 110.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:50:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 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 |
| 01a0870c-7bf0-7ca1-81ce-079d28439531 | CRCL | 2026-09-09 12:42 | other | 2 | 1 | 300 | 171600.00 | unknown | — | 94.9200 | 0.4000 | ["90","95"] | ["0.8167","0.9631"] | [] | ["XCBO"] | 90.0000 | 95.0000 | 2 | 16 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:42:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0815d-9ab8-77a0-bc1e-4c4afc893564 | CRCL | 2026-09-08 10:13 | other | 3 | 1 | 75 | 315825.00 | unknown | — | 97.9800 | 3.3000 | ["55","80","120"] | ["0.8136","0.8034","0.8291"] | [] | ["XCBO"] | 55.0000 | 120.0000 | 129 | 129 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:13:25Z"} | 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 |
| 01a06dc9-6ded-75c3-a3c2-d21c0d066471 | CRCL | 2026-09-04 14:58 | other | 4 | 1 | 300 | 387900.00 | unknown | — | 101.3090 | 0.9200 | ["95","100","103","108"] | ["3.0355","1.0884","0.7319","0.7553"] | [] | ["XISX"] | 95.0000 | 108.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:59:01Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da3-a9f5-74a0-b38c-2cfc1e4de5b4 | CRCL | 2026-09-04 14:17 | other | 4 | 1 | 300 | 376500.00 | unknown | — | 101.2800 | 1.6500 | ["95","100","103","108"] | ["3.5194","0.8253","0.7127","0.7549"] | [] | ["EDGO"] | 95.0000 | 108.0000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:17:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |