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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0814b-4b39-7390-bf2f-40311bd7c7da | LLY | 2026-09-08 09:53 | call_diagonal_spread | 2 | 1 | 4 | 166236.00 | long | bid | 1126.3000 | 24.4500 | ["920","930"] | ["0.6732","0.4141"] | [] | ["XISX"] | 920.0000 | 930.0000 | 10 | 45 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:53:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081bb-81c8-7e41-8967-69876d4a8be5 | LLY | 2026-09-08 11:55 | call_diagonal_spread | 2 | 3 | 99 | 102708.00 | short | bid | 1120.3300 | 0.6900 | ["1260","1300"] | ["0.3380","0.4116"] | [] | ["EDGO","XCBO","XISX"] | 1260.0000 | 1300.0000 | 10 | 38 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:56:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a086bd-f661-7043-a532-1221b926d637 | LLY | 2026-09-09 11:16 | call_diagonal_spread | 2 | 1 | 4 | 120368.00 | long | ask | 1126.3450 | 19.3500 | ["950","1340"] | ["0.3867","0.3712"] | [] | ["XPHO"] | 950.0000 | 1340.0000 | 128 | 281 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:16:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08714-f3e9-70b2-b4fe-2b4def72fb02 | LLY | 2026-09-09 12:51 | call_diagonal_spread | 2 | 1 | 8 | 212344.00 | unknown | — | 1125.4775 | 18.9500 | ["980","1160"] | ["0.5709","0.3731"] | [] | ["XISX"] | 980.0000 | 1160.0000 | 9 | 191 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:51:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c7b-3748-7e51-bd39-dd8a62bbc098 | LLY | 2026-09-10 14:01 | call_diagonal_spread | 2 | 1 | 61 | 863150.00 | long | ask | 1128.8050 | 7.7500 | ["1180","1200"] | ["0.3655","0.3596"] | [] | ["BATO"] | 1180.0000 | 1200.0000 | 99 | 127 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:01:27Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7e-9e60-7551-9670-0536e8feef07 | LLY | 2026-09-10 14:05 | call_diagonal_spread | 2 | 1 | 24 | 376512.00 | long | ask | 1127.6700 | 9.5500 | ["1160","1180"] | ["0.3662","0.3619"] | [] | ["XMIO"] | 1160.0000 | 1180.0000 | 99 | 127 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:05:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090fc-42f8-73c1-874e-c5929ab9c006 | LLY | 2026-09-11 11:00 | call_diagonal_spread | 2 | 1 | 2 | 102112.00 | short | bid | 1121.1400 | 25.1000 | ["870","880"] | ["0.9077","0.3549"] | [] | ["XMIO"] | 870.0000 | 880.0000 | 7 | 98 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:00:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09132-b090-7411-8b35-2dae34359d57 | LLY | 2026-09-11 12:00 | call_diagonal_spread | 2 | 1 | 3 | 204351.00 | short | bid | 1123.7500 | 24.9500 | ["770","800"] | ["0.6574","0.6356"] | [] | ["ARCO"] | 770.0000 | 800.0000 | 35 | 49 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:00:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09132-cfd0-73b3-81f8-4557f220ff6b | LLY | 2026-09-11 12:00 | call_diagonal_spread | 2 | 1 | 3 | 204423.00 | short | bid | 1123.4300 | 24.7000 | ["770","800"] | ["0.6562","0.6852"] | [] | ["XPHO"] | 770.0000 | 800.0000 | 35 | 49 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:00:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09133-6828-7471-ad2f-ab62d284eb7d | LLY | 2026-09-11 12:00 | call_diagonal_spread | 2 | 1 | 3 | 165588.00 | short | bid | 1123.4300 | 18.2500 | ["820","880"] | ["0.4210","1.1076"] | [] | ["XPHO"] | 820.0000 | 880.0000 | 7 | 49 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:01:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a0ad-9490-78b3-b2d6-9e7f679b6277 | LLY | 2026-09-14 12:08 | call_diagonal_spread | 2 | 2 | 10 | 159500.00 | short | ask | 1149.7625 | 7.8000 | ["1060","1280"] | ["0.3364","0.3609"] | [] | ["AMXO","XPHO"] | 1060.0000 | 1280.0000 | 32 | 123 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:08:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a5b5-f3fe-73b2-8989-e541aac32c06 | LLY | 2026-09-15 11:35 | call_diagonal_spread | 2 | 1 | 15 | 460125.00 | unknown | — | 1144.1300 | 17.7000 | ["1040","1100"] | ["0.3766","0.3795"] | [] | ["XCBO"] | 1040.0000 | 1100.0000 | 94 | 185 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:36:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a61b-e98e-7063-bd3b-7b29461f96ac | LLY | 2026-09-15 13:27 | call_diagonal_spread | 2 | 1 | 3 | 400368.00 | short | ask | 1141.0600 | 32.6000 | ["480","510"] | ["0.7367","0.4724"] | [] | ["XMIO"] | 480.0000 | 510.0000 | 122 | 493 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:28:07Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa98-ac6b-7c12-ab37-24c439b200f2 | LLY | 2026-09-16 10:22 | call_diagonal_spread | 2 | 1 | 26 | 927656.00 | unknown | — | 1140.5800 | 33.1000 | ["1500","1560"] | ["0.3856","0.3835"] | [] | ["EDGO"] | 1500.0000 | 1560.0000 | 821 | 856 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:22:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1c-43eb-7db2-95d2-42ce8f32e28f | LLY | 2026-09-16 12:45 | call_diagonal_spread | 2 | 1 | 11 | 168452.00 | long | ask | 1141.1150 | 13.8500 | ["1100","1200"] | ["0.5447","0.3763"] | [] | ["XCBO"] | 1100.0000 | 1200.0000 | 2 | 184 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:45:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afaa-47eb-7b91-b64f-f1c33bc04a61 | LLY | 2026-09-17 09:59 | call_diagonal_spread | 2 | 1 | 8 | 1161008.00 | unknown | — | 1155.6250 | 32.3500 | ["400","500"] | ["0.8126","0.4899"] | [] | ["XCBO"] | 400.0000 | 500.0000 | 120 | 491 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:59:29Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b001-7c23-7c22-a2e6-6c6c38393811 | LLY | 2026-09-17 11:34 | call_diagonal_spread | 2 | 1 | 2 | 158056.00 | short | ask | 1144.3200 | 26.7500 | ["750","850"] | ["4.5244","0.4000"] | [] | ["EMLD"] | 750.0000 | 850.0000 | 1 | 491 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:34:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4f4-8b0f-7692-8f88-5e2beebd42dc | LLY | 2026-09-18 10:38 | call_diagonal_spread | 2 | 1 | 43 | 281908.00 | short | bid | 1146.3400 | 5.2000 | ["1120","1150"] | ["0.6821","0.3108"] | [] | ["XMIO"] | 1120.0000 | 1150.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:39:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b549-b3d7-75b0-a2bc-7375f6afe7de | LLY | 2026-09-18 12:11 | call_diagonal_spread | 2 | 2 | 8 | 863545.00 | long | bid | 1143.6100 | 17.5500 | ["570","670"] | ["16.5315","0.4266"] | [] | ["XCBO","XISX"] | 570.0000 | 670.0000 | 0 | 272 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b549-b3d7-75b0-a2bc-7369aad2d61e | LLY | 2026-09-18 12:11 | call_diagonal_spread | 2 | 1 | 2 | 215640.00 | long | bid | 1143.6100 | 17.5500 | ["570","670"] | ["15.8632","0.4188"] | [] | ["AMXO"] | 570.0000 | 670.0000 | 0 | 272 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54f-ca6f-7902-b79c-5bfba0edae21 | LLY | 2026-09-18 12:18 | call_diagonal_spread | 2 | 1 | 8 | 329560.00 | short | bid | 1143.1750 | 15.0000 | ["1120","1160"] | ["0.3743","0.3726"] | [] | ["XMIO"] | 1120.0000 | 1160.0000 | 364 | 455 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:18:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56d-9f28-7e43-af16-bbfbc374c47c | LLY | 2026-09-18 12:50 | call_diagonal_spread | 2 | 1 | 2 | 228016.00 | unknown | ask | 1144.7650 | 19.5500 | ["570","580"] | ["18.4589","1.0227"] | [] | ["XMIO"] | 570.0000 | 580.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:51:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59b-f66f-7fb0-908e-6485ad68531d | LLY | 2026-09-18 13:41 | call_diagonal_spread | 2 | 3 | 125 | 145680.00 | unknown | bid | 1144.7100 | 1.1700 | ["1160","1190"] | ["0.4928","0.3073"] | [] | ["XISX"] | 1160.0000 | 1190.0000 | 0 | 14 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:41:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c429-52f3-7b10-a935-caae9634e708 | LLY | 2026-09-21 09:30 | call_diagonal_spread | 2 | 1 | 8 | 679600.00 | unknown | ask | 1141.8300 | 42.7000 | ["500","900"] | ["1.0614","0.4051"] | [] | ["XBOX"] | 500.0000 | 900.0000 | 88 | 851 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c460-9f30-73b0-898f-c9ae4b593828 | LLY | 2026-09-21 10:30 | call_diagonal_spread | 2 | 1 | 5 | 146855.00 | short | bid | 1163.6100 | 10.0000 | ["1000","1220"] | ["0.3758","0.3868"] | [] | ["XISX"] | 1000.0000 | 1220.0000 | 39 | 269 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:31:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c461-7dd7-7311-bff7-3a233e9fcd4f | LLY | 2026-09-21 10:31 | call_diagonal_spread | 2 | 1 | 10 | 158700.00 | long | ask | 1164.6100 | 14.0000 | ["1150","1180"] | ["0.3610","0.3570"] | [] | ["XISX"] | 1150.0000 | 1180.0000 | 60 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:32:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c477-d0af-7ff2-99a5-1a40cdb98f67 | LLY | 2026-09-21 10:56 | call_diagonal_spread | 2 | 2 | 56 | 112840.00 | short | bid | 1166.4400 | 2.8571 | ["1245","1400"] | ["0.3158","0.3735"] | [] | ["XISX"] | 1245.0000 | 1400.0000 | 18 | 60 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:56:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c553-b1bf-7aa1-a32d-4838f1f075df | LLY | 2026-09-21 14:56 | call_diagonal_spread | 2 | 1 | 5 | 148305.00 | unknown | bid | 1166.6400 | 15.1500 | ["1140","1200"] | ["0.3750","0.3728"] | [] | ["XCBO"] | 1140.0000 | 1200.0000 | 179 | 269 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:56:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |