Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08136-ad3f-7373-8fce-0314ffd6eb09 | CRM | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 13 | 113698.00 | short | bid | 252.0550 | 6.5500 | ["210","360"] | ["0.7401","0.4460"] | [] | ["XPHO"] | 210.0000 | 360.0000 | 10 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:30:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ae-f2f1-73a1-9057-8aa4bda6bc02 | CRM | 2026-09-08 11:41 | call_diagonal_spread | 2 | 1 | 180 | 1126260.00 | long | ask | 250.1150 | 2.8500 | ["220","240"] | ["0.5158","0.4228"] | [] | ["SPHR"] | 220.0000 | 240.0000 | 10 | 129 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:42:24Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081dd-3a98-74b0-a8c7-d837666d39e3 | CRM | 2026-09-08 12:32 | call_diagonal_spread | 2 | 1 | 19 | 292353.00 | long | ask | 248.1250 | 7.0500 | ["210","240"] | ["0.4460","0.4526"] | [] | ["XISX"] | 210.0000 | 240.0000 | 500 | 829 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:33:07Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0824a-a650-7090-8051-a74f26da2121 | CRM | 2026-09-08 14:32 | call_diagonal_spread | 2 | 2 | 30 | 143250.00 | long | ask | 246.3186 | 2.1000 | ["230","250"] | ["0.4047","0.4287"] | [] | ["XISX"] | 230.0000 | 250.0000 | 38 | 129 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:32:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0a07f-f0f9-7bb1-b22b-4ef5befde26a | CRM | 2026-09-14 11:18 | call_diagonal_spread | 2 | 1 | 10 | 109400.00 | short | ask | 255.6400 | 4.4000 | ["200","220"] | ["1.4749","0.4489"] | [] | ["ARCO"] | 200.0000 | 220.0000 | 4 | 186 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:19:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a131-f731-7f50-89fc-41bb82de645a | CRM | 2026-09-14 14:33 | call_diagonal_spread | 2 | 1 | 46 | 495328.00 | short | bid | 259.0850 | 3.5000 | ["195","220"] | ["0.4598","0.7456"] | [] | ["EDGO"] | 195.0000 | 220.0000 | 4 | 95 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:33:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a59f-c066-7ff3-a7ae-9f721e9944dc | CRM | 2026-09-15 11:11 | call_diagonal_spread | 2 | 1 | 10 | 139710.00 | long | ask | 258.8500 | 3.3500 | ["190","195"] | ["0.6626","0.4532"] | [] | ["XCBO"] | 190.0000 | 195.0000 | 31 | 122 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:12:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d0-07c6-7301-be48-b82d15b6bd84 | CRM | 2026-09-15 12:04 | call_diagonal_spread | 2 | 1 | 25 | 368700.00 | short | ask | 261.0150 | 1.5500 | ["185","190"] | ["1.8011","0.5445"] | [] | ["EDGO"] | 185.0000 | 190.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:04:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a62f-cf4e-7c81-b62c-efb380acace8 | CRM | 2026-09-15 13:49 | call_diagonal_spread | 2 | 1 | 124 | 1750880.00 | unknown | — | 260.0550 | 3.2000 | ["190","210"] | ["1.3106","0.4494"] | [] | ["MCRY"] | 190.0000 | 210.0000 | 3 | 275 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:50:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a633-903e-7d10-95ca-6a88afafe23e | CRM | 2026-09-15 13:53 | call_diagonal_spread | 2 | 1 | 19 | 151544.00 | long | bid | 259.7699 | 1.7500 | ["210","250"] | ["0.9458","0.4516"] | [] | ["XISX"] | 210.0000 | 250.0000 | 3 | 94 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:53:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-14ee-7c92-8661-cf345d25f399 | CRM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 106 | 448910.00 | unknown | — | 255.4800 | 0.6500 | ["220","270"] | ["0.8247","0.4080"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:56:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-cc86-74d1-862d-98a5dd704c91 | CRM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 106 | 451136.00 | long | bid | 255.6700 | 1.5500 | ["220","270"] | ["1.1784","0.4074"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a5-841f-75d2-b4a8-d097a2c96ee0 | CRM | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 106 | 451560.00 | long | bid | 255.7100 | 1.5500 | ["220","270"] | ["1.1666","0.4069"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a6-3f9e-72e0-9da2-471f731afe5a | CRM | 2026-09-15 15:58 | call_diagonal_spread | 2 | 1 | 106 | 449018.00 | long | bid | 255.3850 | 2.0500 | ["220","270"] | ["0.7684","0.4096"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:58:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a6-fb1e-7a00-8185-79382c441cc4 | CRM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 52 | 219806.00 | long | bid | 255.3700 | 0.8000 | ["220","270"] | ["0.7361","0.4080"] | [] | ["EDGO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a6-fb1e-7a00-8185-7925b6189901 | CRM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 53 | 224455.00 | long | bid | 255.3800 | 0.8000 | ["220","270"] | ["0.7847","0.4089"] | [] | ["XMIO"] | 220.0000 | 270.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa76-18db-7541-87a1-cff45462b02a | CRM | 2026-09-16 09:44 | call_diagonal_spread | 2 | 1 | 10 | 122040.00 | unknown | — | 255.5500 | 5.7000 | ["195","200"] | ["2.1242","0.4216"] | [] | ["MCRY"] | 195.0000 | 200.0000 | 2 | 121 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:44:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaee-f25b-7402-bdd8-697c797823c2 | CRM | 2026-09-16 11:56 | call_diagonal_spread | 2 | 1 | 16 | 112008.00 | long | bid | 250.4000 | 2.2000 | ["202.5","270"] | ["1.3003","0.4293"] | [] | ["XISX"] | 202.5000 | 270.0000 | 2 | 156 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:56:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab92-a49b-7c20-8f32-1101521bc407 | CRM | 2026-09-16 14:55 | call_diagonal_spread | 2 | 2 | 37 | 531810.00 | long | bid | 252.1200 | 5.8000 | ["180","195"] | ["0.4970","0.4653"] | [] | ["AMXO","XISX"] | 180.0000 | 195.0000 | 65 | 184 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab92-a49b-7c20-8f32-10f08384ef48 | CRM | 2026-09-16 14:55 | call_diagonal_spread | 2 | 1 | 13 | 186914.00 | long | bid | 252.1200 | 5.8000 | ["180","195"] | ["0.4995","0.4658"] | [] | ["XCBO"] | 180.0000 | 195.0000 | 65 | 184 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:55:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbc-1213-7981-ad72-551a088759ee | CRM | 2026-09-16 15:40 | call_diagonal_spread | 2 | 1 | 50 | 680700.00 | long | bid | 250.1200 | 5.1500 | ["180","185"] | ["2.0150","0.4675"] | [] | ["EDGO"] | 180.0000 | 185.0000 | 2 | 30 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afce-bfdb-7190-9490-87a493d2219d | CRM | 2026-09-17 10:39 | call_diagonal_spread | 2 | 2 | 54 | 375327.00 | short | ask | 242.3300 | 4.1000 | ["210","240"] | ["0.4775","0.4535"] | [] | ["C2OX","XPHO"] | 210.0000 | 240.0000 | 29 | 183 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:39:22Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b069-522b-7440-ae55-fb301bc13ab5 | CRM | 2026-09-17 13:28 | call_diagonal_spread | 2 | 2 | 500 | 1063500.00 | long | ask | 243.1950 | 0.7000 | ["245","250"] | ["0.4801","0.4410"] | [] | ["ARCO"] | 245.0000 | 250.0000 | 1 | 92 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:28:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06d-49cb-74d0-863a-fda2649b2347 | CRM | 2026-09-17 13:32 | call_diagonal_spread | 2 | 1 | 30 | 290814.00 | short | bid | 243.2600 | 5.1500 | ["210","320"] | ["0.4506","0.4479"] | [] | ["XCBO"] | 210.0000 | 320.0000 | 120 | 855 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:32:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b562-bdff-7481-8982-99aa82bd3ca8 | CRM | 2026-09-18 12:39 | call_diagonal_spread | 2 | 1 | 60 | 283080.00 | long | ask | 238.9800 | 2.6500 | ["220","240"] | ["0.4024","0.4283"] | [] | ["XMIO"] | 220.0000 | 240.0000 | 28 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:39:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d8-e418-7dc1-aede-da742434f10c | CRM | 2026-09-18 14:48 | call_diagonal_spread | 2 | 2 | 92 | 175352.00 | short | bid | 239.4700 | 1.1500 | ["240","250"] | ["0.3936","0.3772"] | [] | ["EDGO","XCBO"] | 240.0000 | 250.0000 | 28 | 42 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:48:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |