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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c585-1a2f-7de3-81a2-3ce94e95135f | LLY | 2026-09-21 15:50 | call_vertical_spread | 2 | 1 | 7 | 534793.00 | short | bid | 1164.4200 | 29.8500 | ["780","785"] | ["2.6713","2.3556"] | ["784.99"] | ["XCBO"] | 780.0000 | 785.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:50:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c57a-d547-72b2-a895-27a435261efd | LLY | 2026-09-21 15:39 | call_vertical_spread | 2 | 1 | 6 | 452058.00 | short | bid | 1163.5500 | 22.2500 | ["785","790"] | ["1.5152","1.4973"] | ["789.99"] | ["XMIO"] | 785.0000 | 790.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:39:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c56f-9277-7e63-8596-43ca2987919f | LLY | 2026-09-21 15:26 | call_vertical_spread | 2 | 1 | 4 | 299984.00 | short | bid | 1162.4000 | 18.5500 | ["785","790"] | ["2.2541","2.2081"] | ["789.98"] | ["XCBO"] | 785.0000 | 790.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:27:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55f-812f-7553-918e-23b17995e0db | LLY | 2026-09-21 15:09 | call_vertical_spread | 2 | 1 | 3 | 230679.00 | short | bid | 1163.8250 | 24.5000 | ["780","785"] | ["2.0977","2.0700"] | ["784.99"] | ["EDGO"] | 780.0000 | 785.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:09:32Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c557-dc26-73e3-9ab7-039beeabf361 | LLY | 2026-09-21 15:01 | call_vertical_spread | 2 | 1 | 2 | 146614.00 | short | bid | 1167.2500 | 21.4000 | ["800","805"] | ["1.7851","1.7608"] | ["804.99"] | ["XCBO"] | 800.0000 | 805.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:01:21Z"} | 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 |
| 01a0c53f-b0a7-7bd2-bcda-1004bef65cb7 | LLY | 2026-09-21 14:34 | call_vertical_spread | 2 | 1 | 2 | 151086.00 | unknown | bid | 1168.5300 | 19.7000 | ["790","795"] | ["1.8218","1.7976"] | ["1170.22"] | ["XCBO"] | 790.0000 | 795.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:35:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c53f-b0a7-7bd2-bcda-0ff40484bad2 | LLY | 2026-09-21 14:34 | call_vertical_spread | 2 | 1 | 4 | 302172.00 | unknown | bid | 1168.5300 | 19.7000 | ["790","795"] | ["1.8218","1.7976"] | ["1170.22"] | ["XCBO"] | 790.0000 | 795.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:35:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c524-163f-7ab3-a3fd-08791f04c804 | LLY | 2026-09-21 14:04 | call_vertical_spread | 2 | 1 | 3 | 224733.00 | short | bid | 1166.3200 | 21.7500 | ["790","795"] | ["1.5354","1.5166"] | ["794.99"] | ["XCBO"] | 790.0000 | 795.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:04:57Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c490-dad7-76f3-a9bb-ce9fbe2f219f | LLY | 2026-09-21 11:23 | call_vertical_spread | 2 | 1 | 10 | 119830.00 | short | bid | 1165.7200 | 7.9000 | ["1130","1135"] | ["0.3269","0.3261"] | ["1133.23"] | ["XCBO"] | 1130.0000 | 1135.0000 | 25 | 25 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:23:47Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c476-f207-7652-969b-bf8475aa976e | LLY | 2026-09-21 10:55 | call_vertical_spread | 2 | 1 | 10 | 118530.00 | short | bid | 1166.3400 | 16.5000 | ["1130","1135"] | ["0.3175","0.3164"] | ["1133.29"] | ["XCBO"] | 1130.0000 | 1135.0000 | 25 | 25 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:55:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c459-57e8-7440-9833-04593abc5c8b | LLY | 2026-09-21 10:23 | call_vertical_spread | 2 | 1 | 3 | 146499.00 | short | bid | 1163.9100 | 28.5500 | ["1100","1120"] | ["0.3688","0.3680"] | ["1110.19"] | ["XMIO"] | 1100.0000 | 1120.0000 | 452 | 452 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:23:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5e0-b02f-7e31-ab00-edb3ff0fd1fb | LLY | 2026-09-18 14:56 | put_vertical_spread | 2 | 1 | 6 | 102948.00 | short | bid | 1155.1300 | 6.9500 | ["1100","1200"] | ["0.3600","0.3606"] | ["1150.04"] | ["XMIO"] | 1100.0000 | 1200.0000 | 119 | 119 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:57:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab59-5c8b-75e0-97f2-4389ed775c21 | LLY | 2026-09-16 13:52 | call_vertical_spread | 2 | 1 | 3 | 133944.00 | short | bid | 1139.7650 | 19.8500 | ["900","1200"] | ["0.3883","0.3739"] | ["1071.30"] | ["XCBO"] | 900.0000 | 1200.0000 | 274 | 274 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:52:44Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5cb-876e-7ee1-b7ff-4abac15ae8ed | LLY | 2026-09-15 11:59 | call_vertical_spread | 2 | 1 | 3 | 122325.00 | short | bid | 1144.7785 | 25.8500 | ["1450","1460"] | ["0.3988","0.3987"] | ["1452.73"] | ["XCBO"] | 1450.0000 | 1460.0000 | 822 | 822 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:59:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a158-cc98-7983-a24b-bacf5022c33f | LLY | 2026-09-14 15:15 | call_vertical_spread | 2 | 1 | 21 | 408429.00 | short | bid | 1140.0500 | 7.2000 | ["1050","1070"] | ["0.3318","0.3282"] | ["1065.65"] | ["XCBO"] | 1050.0000 | 1070.0000 | 32 | 32 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:16:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d9-c8f8-7e70-957c-a8aad3f31fa7 | LLY | 2026-09-14 12:56 | call_vertical_spread | 2 | 1 | 12 | 244752.00 | short | bid | 1144.2400 | 10.9500 | ["1050","1070"] | ["0.3479","0.3416"] | ["1065.90"] | ["XCBO"] | 1050.0000 | 1070.0000 | 32 | 32 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:57:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0871c-a0c0-74f2-ad6f-fa0f97c50485 | LLY | 2026-09-09 12:59 | call_vertical_spread | 2 | 1 | 19 | 257013.00 | short | bid | 1125.1250 | 7.3500 | ["1120","1180"] | ["0.3722","0.3700"] | ["1146.25"] | ["XMIO"] | 1120.0000 | 1180.0000 | 72 | 72 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08251-0b08-7c51-b302-3e3bffd7b560 | LLY | 2026-09-08 14:39 | call_vertical_spread | 2 | 1 | 5 | 100912.00 | short | bid | 1123.8950 | 16.1000 | ["1080","1090"] | ["0.3835","0.3828"] | ["1085.76"] | ["XCBO"] | 1080.0000 | 1090.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:39:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818e-e7d0-7ab2-a0da-29a617fa5b3d | LLY | 2026-09-08 11:06 | call_vertical_spread | 2 | 1 | 5 | 157185.00 | short | bid | 1132.1700 | 15.2500 | ["1100","1200"] | ["0.3753","0.3727"] | ["1145.05"] | ["XMIO"] | 1100.0000 | 1200.0000 | 282 | 282 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:07:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813e-eb41-7992-9cea-41935f92557a | LLY | 2026-09-08 09:39 | call_vertical_spread | 2 | 1 | 32 | 336640.00 | short | bid | 1121.5100 | 19.0000 | ["1480","1500"] | ["0.3731","0.3734"] | ["1483.30"] | ["XMIO"] | 1480.0000 | 1500.0000 | 282 | 282 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:39:37Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dc8-a2ce-75d1-ae35-38983ff2c0ec | LLY | 2026-09-04 14:57 | call_calendar | 2 | 1 | 200 | 1616600.00 | long | bid | 1140.4000 | 8.4500 | ["1170"] | ["0.3250"] | [] | ["XMIO"] | 1170.0000 | 1170.0000 | 14 | 77 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:57:54Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |