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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4c6-61f7-7861-b4f8-4f9d68bec12f | LLY | 2026-09-21 12:22 | other | 3 | 1 | 10 | 131110.00 | unknown | ask | 1159.1480 | 19.5000 | ["1120","1155","1250"] | ["0.3839","0.4000","0.3978"] | ["1118.67"] | ["XCBO"] | 1120.0000 | 1250.0000 | 39 | 39 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:22:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a7-cdd7-7af0-ae3d-299f8d8789db | LLY | 2026-09-21 11:48 | other | 3 | 1 | 2 | 105596.00 | unknown | ask | 1162.6500 | 39.0500 | ["1040","1050","1500"] | ["0.3811","0.3952","0.3710"] | ["1099.78"] | ["XCBO"] | 1040.0000 | 1500.0000 | 487 | 487 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:48:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a082-c788-7821-916d-dedbfd68ab13 | LLY | 2026-09-14 11:21 | other | 4 | 1 | 40 | 1210640.00 | unknown | — | 1144.6400 | 38.6500 | ["1170","1200","1220","1230"] | ["0.3353","0.3369","0.5584","0.5904"] | [] | ["XMIO"] | 1170.0000 | 1230.0000 | 4 | 32 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:22:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0920a-6351-7e01-b7c5-abd273350340 | LLY | 2026-09-11 15:55 | other | 4 | 1 | 20 | 476820.00 | unknown | — | 1114.7100 | 32.8000 | ["1100","1120","1150","1160"] | ["0.3644","0.3635","0.2869","0.2840"] | [] | ["XCBO"] | 1100.0000 | 1160.0000 | 7 | 98 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:55:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f7-15e8-7d10-b391-55720fff9012 | LLY | 2026-09-11 15:34 | other | 4 | 1 | 6 | 140034.00 | unknown | — | 1118.1550 | 18.8500 | ["1100","1120","1150","1160"] | ["0.3682","0.3679","0.2985","0.3061"] | [] | ["XCBO"] | 1100.0000 | 1160.0000 | 7 | 98 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:35:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ab-ad38-71e3-955a-c7e34e6ef6e1 | LLY | 2026-09-11 14:12 | other | 8 | 1 | 5 | 102420.00 | unknown | — | 1120.8600 | 34.9500 | ["1110","1120","1180","1190","1200","1210"] | ["0.3045","0.2987","0.2979","0.3857","0.4001","0.3219"] | [] | ["MCRY"] | 1110.0000 | 1210.0000 | 7 | 14 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:12:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091a6-1788-7090-9e71-fbd613806cc4 | LLY | 2026-09-11 14:06 | other | 4 | 1 | 6 | 137586.00 | unknown | — | 1119.0100 | 18.6000 | ["1100","1120","1150","1160"] | ["0.3682","0.3669","0.2832","0.2818"] | [] | ["XCBO"] | 1100.0000 | 1160.0000 | 7 | 98 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:06:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0919a-3c61-7003-bba3-e551a8b93586 | LLY | 2026-09-11 13:53 | other | 4 | 1 | 5 | 111225.00 | unknown | — | 1122.9800 | 12.7500 | ["1100","1120","1150","1160"] | ["0.3679","0.3690","0.2971","0.3111"] | [] | ["XMIO"] | 1100.0000 | 1160.0000 | 7 | 98 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:53:52Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0824d-84b0-7220-993b-028c0714c9ee | LLY | 2026-09-08 14:35 | other | 4 | 1 | 7 | 106519.00 | unknown | — | 1125.0400 | 18.5500 | ["1120","1125","1140","1145"] | ["0.3277","0.3253","0.3383","0.3363"] | [] | ["XCBO"] | 1120.0000 | 1145.0000 | 17 | 24 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:35:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ef-3bf8-77a2-9d87-b300fce20f98 | LLY | 2026-09-08 12:52 | other | 4 | 1 | 15 | 137190.00 | unknown | — | 1127.9000 | 12.4500 | ["1100","1110","1120","1130"] | ["0.3430","0.3410","0.3463","0.3446"] | [] | ["XMIO"] | 1100.0000 | 1130.0000 | 10 | 17 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:52:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0817a-61e8-77b3-a4d0-82fcede609e0 | LLY | 2026-09-08 10:44 | other | 4 | 1 | 5 | 111320.00 | unknown | — | 1130.6050 | 32.0000 | ["1150","1160","1175","1180"] | ["0.3347","0.3440","0.4332","0.4943"] | [] | ["XCBO"] | 1150.0000 | 1180.0000 | 3 | 38 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:45:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08161-53d8-7442-be2e-59c497e10527 | LLY | 2026-09-08 10:17 | other | 4 | 1 | 15 | 287715.00 | unknown | — | 1126.0000 | 33.2500 | ["1090","1100","1110","1120"] | ["0.3778","0.3719","0.3311","0.3235"] | [] | ["XMIO"] | 1090.0000 | 1120.0000 | 38 | 73 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:17:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814f-8158-7333-afb3-1e2ae80aa5c0 | LLY | 2026-09-08 09:57 | other | 4 | 1 | 3 | 105063.00 | unknown | — | 1126.6250 | 38.4000 | ["1040","1050","1060","1070"] | ["0.4123","0.3488","0.3911","0.3441"] | [] | ["XMIO"] | 1040.0000 | 1070.0000 | 10 | 38 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:57:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814a-2e10-75f0-b5bf-dc260a6f7aee | LLY | 2026-09-08 09:51 | other | 4 | 1 | 18 | 161208.00 | unknown | — | 1124.8350 | 17.1000 | ["1080","1090","1100","1110"] | ["0.3354","0.3315","0.3469","0.3401"] | [] | ["XMIO"] | 1080.0000 | 1110.0000 | 10 | 38 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:52:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |