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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c42d-0ff7-78c3-9a95-c3071daf1b48 | LLY | 2026-09-21 09:34 | call_calendar | 2 | 1 | 3 | 150723.00 | long | ask | 1149.5725 | 34.1500 | ["1240"] | ["0.3807"] | [] | ["XMIO"] | 1240.0000 | 1240.0000 | 634 | 816 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:34:43Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5a4-37b8-7fb2-829c-f718e291765e | LLY | 2026-09-18 13:50 | call_calendar | 2 | 1 | 2 | 139722.00 | unknown | ask | 1145.1800 | 21.9000 | ["800"] | ["6.9834"] | [] | ["XISX"] | 800.0000 | 800.0000 | 0 | 91 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0af92-5aeb-7411-bc2f-2746fb04e46e | LLY | 2026-09-17 09:33 | call_calendar | 2 | 1 | 3 | 139638.00 | short | bid | 1148.0000 | 25.9000 | ["920"] | ["1.5563"] | [] | ["XISX"] | 920.0000 | 920.0000 | 1 | 64 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:33:20Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0af8f-78a8-7a53-9316-59f1e0a9300c | LLY | 2026-09-17 09:30 | call_calendar | 2 | 1 | 14 | 1293040.00 | short | ask | 1149.9100 | 32.8000 | ["760"] | ["0.4156"] | [] | ["XISX"] | 760.0000 | 760.0000 | 456 | 491 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:04Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0aac3-3323-7d13-a4a9-c1dd0be8664d | LLY | 2026-09-16 11:08 | call_calendar | 2 | 1 | 3 | 374412.00 | short | bid | 1141.0200 | 32.6500 | ["540"] | ["0.4055"] | [] | ["XMIO"] | 540.0000 | 540.0000 | 274 | 366 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:09:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-43b8-7861-ae00-caefb4903ad8 | LLY | 2026-09-16 09:30 | call_calendar | 2 | 1 | 3 | 108549.00 | long | bid | 1136.1600 | 30.6500 | ["1240"] | ["0.3770"] | [] | ["XMIO"] | 1240.0000 | 1240.0000 | 457 | 492 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:07Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d3-2c76-7482-8740-93b8fb903143 | LLY | 2026-09-15 12:07 | call_calendar | 2 | 1 | 12 | 265380.00 | short | ask | 1141.5300 | 14.1250 | ["1050"] | ["0.3642"] | [] | ["XISX"] | 1050.0000 | 1050.0000 | 31 | 38 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:08:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a035-66f0-7481-8063-46402e25b2dc | LLY | 2026-09-14 09:57 | call_calendar | 2 | 1 | 4 | 114280.00 | short | ask | 1136.5016 | 14.6500 | ["1000"] | ["0.5541"] | [] | ["XISX"] | 1000.0000 | 1000.0000 | 4 | 32 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:57:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a086d3-14a0-75d3-8283-96b06b9cb977 | LLY | 2026-09-09 11:39 | call_calendar | 2 | 2 | 24 | 839028.00 | short | ask | 1127.5130 | 13.9500 | ["1000"] | ["0.3735"] | [] | ["EDGO","XPHO"] | 1000.0000 | 1000.0000 | 100 | 128 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:39:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ce-1748-7e81-a440-d766929403f9 | LLY | 2026-09-09 11:34 | call_calendar | 2 | 2 | 46 | 936675.00 | unknown | — | 1127.2050 | 7.2500 | ["1120"] | ["0.3664"] | [] | ["EDGO","XISX"] | 1120.0000 | 1120.0000 | 100 | 128 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:34:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06deb-8c4e-7762-9755-fc9578b5d810 | LLY | 2026-09-04 15:35 | call_calendar | 2 | 1 | 40 | 281160.00 | long | ask | 1143.4950 | 3.2000 | ["1190"] | ["0.3297"] | [] | ["XPHO"] | 1190.0000 | 1190.0000 | 14 | 77 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:36:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06deb-653d-7430-8a72-73b7607f9c45 | LLY | 2026-09-04 15:35 | call_calendar | 2 | 1 | 40 | 281000.00 | long | ask | 1143.4100 | 3.3000 | ["1190"] | ["0.3297"] | [] | ["XPHO"] | 1190.0000 | 1190.0000 | 14 | 77 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:35:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06deb-653d-7430-8a72-73aee5d64cc0 | LLY | 2026-09-04 15:35 | call_calendar | 2 | 1 | 40 | 281160.00 | long | ask | 1143.4100 | 3.3000 | ["1190"] | ["0.3299"] | [] | ["XPHO"] | 1190.0000 | 1190.0000 | 14 | 77 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:35:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06deb-653d-7430-8a72-739e1f095228 | LLY | 2026-09-04 15:35 | call_calendar | 2 | 1 | 40 | 281160.00 | long | ask | 1143.4100 | 3.3000 | ["1190"] | ["0.3299"] | [] | ["XISX"] | 1190.0000 | 1190.0000 | 14 | 77 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:35:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6c-1b4d-72c0-b752-7eba37351247 | LLY | 2026-09-04 13:16 | call_calendar | 2 | 2 | 2 | 140484.00 | long | ask | 1143.6725 | 10.9000 | ["800"] | ["0.7224"] | [] | ["EMLD","XBOX"] | 800.0000 | 800.0000 | 14 | 105 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6c-1b4d-72c0-b752-7ea219394aeb | LLY | 2026-09-04 13:16 | call_calendar | 2 | 6 | 7 | 494074.00 | long | bid | 1143.6725 | 10.2500 | ["800"] | ["0.7167"] | [] | ["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"] | 800.0000 | 800.0000 | 14 | 105 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6c-1765-7751-aa7a-5071b5a6334d | LLY | 2026-09-04 13:16 | call_calendar | 2 | 6 | 9 | 636722.00 | long | bid | 1143.6725 | 10.9500 | ["800"] | ["0.7492"] | [] | ["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"] | 800.0000 | 800.0000 | 14 | 105 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |