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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c588-a46f-7183-a492-18661277b2ca | COP | 2026-09-21 15:54 | call_diagonal_spread | 2 | 1 | 129 | 419379.00 | long | ask | 127.6000 | 1.0500 | ["115","135"] | ["0.2963","0.2767"] | [] | ["XISX"] | 115.0000 | 135.0000 | 88 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c588-a46f-7183-a492-185fb037cefb | COP | 2026-09-21 15:54 | call_diagonal_spread | 2 | 2 | 69 | 224481.00 | long | ask | 127.6000 | 1.0587 | ["115","135"] | ["0.2970","0.2769"] | [] | ["EDGO","XISX"] | 115.0000 | 135.0000 | 88 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c588-a46f-7183-a492-184c0656f2de | COP | 2026-09-21 15:54 | call_diagonal_spread | 2 | 1 | 141 | 459096.00 | unknown | ask | 127.6000 | 1.3500 | ["115","135"] | ["0.2975","0.2772"] | [] | ["XISX"] | 115.0000 | 135.0000 | 88 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c588-a46f-7183-a492-182134ca8498 | COP | 2026-09-21 15:54 | call_diagonal_spread | 2 | 8 | 195 | 654207.00 | long | ask | 127.6000 | 3.7500 | ["115","135"] | ["0.3253","0.2857"] | [] | ["AMXO","ARCO","EMLD","MCRY","XBOX","XMIO","XPHO"] | 115.0000 | 135.0000 | 88 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c588-5a37-7f32-bfff-ad1f411c2619 | COP | 2026-09-21 15:54 | call_diagonal_spread | 2 | 1 | 108 | 358776.00 | long | ask | 127.6400 | 3.7500 | ["115","135"] | ["0.3144","0.2825"] | [] | ["XCBO"] | 115.0000 | 135.0000 | 88 | 487 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:54:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c504-804f-7c11-8233-4c4a1a62ef2d | COP | 2026-09-21 13:29 | call_diagonal_spread | 2 | 1 | 655 | 138205.00 | short | bid | 127.6000 | 0.5500 | ["135","140"] | ["0.3061","0.4377"] | [] | ["XBOX"] | 135.0000 | 140.0000 | 4 | 32 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:30:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4bd-846e-7e63-8ecf-00408513f5c0 | COP | 2026-09-21 12:12 | call_diagonal_spread | 2 | 1 | 13 | 113373.00 | long | ask | 127.4100 | 5.5500 | ["90","95"] | ["0.2237","0.1953"] | [] | ["XISX"] | 90.0000 | 95.0000 | 487 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:12:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5b5-eee0-7550-b377-08a9c173b9c1 | COP | 2026-09-18 14:09 | call_diagonal_spread | 2 | 7 | 81 | 157707.00 | short | bid | 131.8200 | 0.2988 | ["135","150"] | ["0.3039","0.2958"] | [] | ["ARCO","EDGO","MCRY","XCBO","XISX","XPHO"] | 135.0000 | 150.0000 | 119 | 364 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:10:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b4-412f-74c2-b84a-3a6e5fb8980b | COP | 2026-09-18 14:08 | call_diagonal_spread | 2 | 2 | 366 | 750300.00 | short | ask | 131.7900 | 0.6500 | ["115","145"] | ["3.5750","0.3029"] | [] | ["ARCO"] | 115.0000 | 145.0000 | 0 | 91 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:08:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b590-5db0-7601-b684-0360c87497bf | COP | 2026-09-18 13:28 | call_diagonal_spread | 2 | 1 | 467 | 362002.00 | short | bid | 131.9800 | 1.1900 | ["130","135"] | ["0.5566","0.3061"] | [] | ["EDGO"] | 130.0000 | 135.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:29:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53c-e297-7592-bde1-9181360ea12a | COP | 2026-09-18 11:57 | call_diagonal_spread | 2 | 3 | 404 | 1043532.00 | unknown | bid | 132.8300 | 0.9500 | ["120","125"] | ["3.6912","0.3007"] | [] | ["XCBO"] | 120.0000 | 125.0000 | 0 | 91 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:57:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b533-b6ef-72f3-bf12-d85fe18a6fb9 | COP | 2026-09-18 11:47 | call_diagonal_spread | 2 | 3 | 599 | 983558.00 | unknown | bid | 132.6400 | 1.0500 | ["125","135"] | ["2.3465","0.3014"] | [] | ["XCBO"] | 125.0000 | 135.0000 | 0 | 119 | false | false | true | true | false | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:47:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d3-b0a3-7901-95d4-5d72625ee335 | COP | 2026-09-17 15:24 | call_diagonal_spread | 2 | 1 | 90 | 195840.00 | unknown | — | 132.9500 | 1.4000 | ["115","125"] | ["1.7699","0.3092"] | [] | ["XCBO"] | 115.0000 | 125.0000 | 1 | 29 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:24:34Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d3-2bd3-7031-9921-d9643a4d0ba5 | COP | 2026-09-17 15:23 | call_diagonal_spread | 2 | 1 | 60 | 131900.00 | unknown | — | 132.9400 | 1.4500 | ["115","125"] | ["1.4425","0.3208"] | [] | ["XISX"] | 115.0000 | 125.0000 | 1 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:23:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b00b-346b-7ac0-928b-e07ea8814333 | COP | 2026-09-17 11:45 | call_diagonal_spread | 2 | 1 | 300 | 529558.00 | short | bid | 132.0300 | 0.7500 | ["130","140"] | ["0.3177","0.3012"] | [] | ["EDGO"] | 130.0000 | 140.0000 | 64 | 183 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:45:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abab-9f24-7ad1-a461-dc6f6ac656dd | COP | 2026-09-16 15:22 | call_diagonal_spread | 2 | 1 | 31 | 154132.00 | short | bid | 132.6200 | 1.8500 | ["110","125"] | ["0.3233","0.2797"] | [] | ["XCBO"] | 110.0000 | 125.0000 | 93 | 492 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:22:38Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abab-9f24-7ad1-a461-dc5473c0e570 | COP | 2026-09-16 15:22 | call_diagonal_spread | 2 | 6 | 31 | 154284.00 | unknown | — | 132.6400 | 2.8726 | ["110","125"] | ["0.3238","0.2799"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 110.0000 | 125.0000 | 93 | 492 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:22:38Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab66-87a3-7a12-a174-6285b1b16308 | COP | 2026-09-16 14:06 | call_diagonal_spread | 2 | 1 | 92 | 103408.00 | unknown | — | 134.1500 | 0.8700 | ["125","185"] | ["0.6787","0.3348"] | [] | ["XBOX"] | 125.0000 | 185.0000 | 2 | 184 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:06:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a1-51e6-7143-9def-f39a1ce1e443 | COP | 2026-09-15 15:53 | call_diagonal_spread | 2 | 1 | 138 | 207690.00 | unknown | — | 140.7900 | 0.8000 | ["135","140"] | ["0.4252","0.3333"] | [] | ["XMIO"] | 135.0000 | 140.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:53:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a691-9e5e-7222-8fa5-e49aaaef7d8f | COP | 2026-09-15 15:35 | call_diagonal_spread | 2 | 1 | 200 | 297000.00 | long | ask | 140.6000 | 0.7000 | ["135","140"] | ["0.4302","0.3358"] | [] | ["XISX"] | 135.0000 | 140.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:36:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68b-743e-7f50-af45-9afe1628cbb8 | COP | 2026-09-15 15:29 | call_diagonal_spread | 2 | 1 | 200 | 297200.00 | unknown | — | 140.6500 | 0.7000 | ["135","140"] | ["0.4431","0.3316"] | [] | ["MCRY"] | 135.0000 | 140.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:29:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a562-b766-7db0-a93a-edb0766188d5 | COP | 2026-09-15 10:05 | call_diagonal_spread | 2 | 2 | 350 | 883400.00 | long | bid | 139.0650 | 2.0000 | ["125","130"] | ["0.5970","0.3152"] | [] | ["XPHO"] | 125.0000 | 130.0000 | 3 | 31 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:05:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a124-b0c0-78b0-990a-8d70d2d71e00 | COP | 2026-09-14 14:18 | call_diagonal_spread | 2 | 1 | 90 | 150390.00 | short | bid | 137.4500 | 1.1000 | ["130","135"] | ["0.3617","0.3102"] | [] | ["AMXO"] | 130.0000 | 135.0000 | 4 | 67 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:19:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a113-e3f8-7083-b571-a4cd07610c69 | COP | 2026-09-14 14:00 | call_diagonal_spread | 2 | 2 | 64 | 106432.00 | short | bid | 137.2100 | 0.7500 | ["130","135"] | ["0.4455","0.3139"] | [] | ["EMLD","SPHR"] | 130.0000 | 135.0000 | 4 | 67 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:00:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a113-d071-7c30-bc98-cb0dbc85c788 | COP | 2026-09-14 14:00 | call_diagonal_spread | 2 | 3 | 70 | 115560.00 | short | bid | 137.2100 | 1.0500 | ["130","135"] | ["0.4227","0.3113"] | [] | ["XBOX","XCBO"] | 130.0000 | 135.0000 | 4 | 67 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:00:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03e-adf0-76d2-98b3-98b418c570c9 | COP | 2026-09-14 10:07 | call_diagonal_spread | 2 | 1 | 9 | 103446.00 | short | bid | 138.9600 | 5.5500 | ["82.5","85"] | ["0.3884","0.3995"] | [] | ["EDGO"] | 82.5000 | 85.0000 | 368 | 459 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08ce7-9d48-7c73-a825-fc299dbe8be2 | COP | 2026-09-10 15:59 | call_diagonal_spread | 2 | 1 | 150 | 384900.00 | short | bid | 136.9700 | 1.5500 | ["125","150"] | ["0.4236","0.2904"] | [] | ["XCBO"] | 125.0000 | 150.0000 | 8 | 372 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:59:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |