core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a06dd9-b5e5-78f3-9617-41a75bf521e2 | LMND | 2026-09-04 15:16 | call_vertical_spread | 2 | 1 | 99 | 310959.00 | long | ask | 53.2900 | 2.5000 | ["37","38"] | ["29.9685","29.6292"] | ["37.99"] | ["XISX"] | 37.0000 | 38.0000 | 0 | 0 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:16:27Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dda-59f5-7291-b4f3-3352d0371efe | LMND | 2026-09-04 15:16 | call_vertical_spread | 2 | 1 | 99 | 310959.00 | long | ask | 53.3200 | 2.5000 | ["37","38"] | ["29.7768","29.4906"] | ["37.99"] | ["XISX"] | 37.0000 | 38.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06dde-1ae6-7dc3-bcae-c7b6e8914eb4 | LMND | 2026-09-04 15:21 | call_vertical_spread | 2 | 1 | 99 | 191169.00 | long | ask | 53.4100 | 2.7000 | ["43","44"] | ["19.7525","19.3898"] | ["43.99"] | ["XISX"] | 43.0000 | 44.0000 | 0 | 0 | true | false | false | ||||||||||
| 01a06dde-3e0e-7ce0-bd79-3d460c2dfd5c | LMND | 2026-09-04 15:21 | call_vertical_spread | 2 | 1 | 99 | 191169.00 | long | ask | 53.3950 | 2.7000 | ["43","44"] | ["19.9819","19.5892"] | ["43.99"] | ["XISX"] | 43.0000 | 44.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06ddf-a956-7c40-a6be-839b7cf22c60 | LMND | 2026-09-04 15:22 | call_vertical_spread | 2 | 1 | 198 | 384120.00 | unknown | — | 53.2900 | 2.8000 | ["43","44"] | ["22.8464","21.0611"] | [] | ["XCBO"] | 43.0000 | 44.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a06de0-1a9e-7143-940d-c20675ee15a3 | LMND | 2026-09-04 15:23 | put_vertical_spread | 2 | 1 | 99 | 412929.00 | unknown | — | 53.2100 | 4.8000 | ["74","75"] | ["31.3245","31.0787"] | [] | ["XISX"] | 74.0000 | 75.0000 | 0 | 0 | true | false | false | true | false | ||||||||
| 01a06de1-37c5-7632-bf6f-dcaa7d9a6ac9 | LMND | 2026-09-04 15:24 | put_vertical_spread | 2 | 1 | 99 | 412929.00 | long | ask | 53.2100 | 4.7000 | ["74","75"] | ["31.8564","31.6065"] | ["74.01"] | ["XISX"] | 74.0000 | 75.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06dfa-af4d-7083-b596-c7a507534a79 | LMND | 2026-09-04 15:52 | call_vertical_spread | 2 | 1 | 198 | 639540.00 | unknown | — | 53.4100 | 6.6000 | ["37","38"] | ["60.1578","56.5199"] | [] | ["XCBO"] | 37.0000 | 38.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a09147-d2b8-77f0-a8f1-db9a02ba7ca1 | LMND | 2026-09-11 12:23 | put_calendar | 2 | 1 | 1000 | 275000.00 | long | bid | 49.1800 | 0.8000 | ["50"] | ["0.8439"] | [] | ["XBOX"] | 50.0000 | 50.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a091d2-6748-7d12-868f-4950ac9a1bb1 | LMND | 2026-09-11 14:54 | put_vertical_spread | 2 | 1 | 88 | 486728.00 | unknown | — | 49.4701 | 3.5000 | ["77","78"] | ["26.9031","26.3083"] | [] | ["XISX"] | 77.0000 | 78.0000 | 0 | 0 | true | false | false | true | false | ||||||||
| 01a091d2-a5c8-7920-a06c-0a55246ff5c7 | LMND | 2026-09-11 14:54 | put_vertical_spread | 2 | 1 | 188 | 1039828.00 | unknown | — | 49.4850 | 3.5000 | ["77","78"] | ["27.1050","26.5280"] | [] | ["XISX"] | 77.0000 | 78.0000 | 0 | 0 | true | false | false | true | false | ||||||||
| 01a091d6-b0f0-7211-ba26-97ab2837e106 | LMND | 2026-09-11 14:59 | put_vertical_spread | 2 | 1 | 188 | 1039828.00 | unknown | — | 49.5300 | 3.5000 | ["77","78"] | ["28.5235","27.9805"] | [] | ["XISX"] | 77.0000 | 78.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a0920a-1148-71a0-8c97-9aa408efd5d1 | LMND | 2026-09-11 15:55 | put_vertical_spread | 2 | 1 | 440 | 2437600.00 | unknown | — | 49.4000 | 3.6000 | ["77","78"] | ["99.0532","101.1502"] | [] | ["XCBO"] | 77.0000 | 78.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a0b0bf-b373-76d3-a6b1-22e916d3a03e | LMND | 2026-09-17 15:02 | other | 4 | 1 | 152 | 330440.00 | unknown | — | 49.0100 | 8.2000 | ["55","60","65","70"] | ["1.4649","4.4211","5.3877","6.2297"] | [] | ["XBOX"] | 55.0000 | 70.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b610-1500-7270-ad5e-d8471f3589a6 | LMND | 2026-09-18 15:48 | put_calendar | 2 | 1 | 55 | 146245.00 | short | ask | 47.0950 | 1.2000 | ["45"] | ["0.7046"] | [] | ["XISX"] | 45.0000 | 45.0000 | 490 | 854 | false | true | true | false | |||||||||
| 01a0c511-e5ff-7ce0-aa7b-e0b2ae4b8020 | LMND | 2026-09-21 13:44 | box_spread | 4 | 1 | 15 | 126810.00 | long | ask | 47.7550 | 1.4000 | ["35","75"] | ["0.6982","0.7241"] | [] | ["BATO"] | 35.0000 | 75.0000 | 851 | 851 | false | false | false | true | |||||||||
| 01a0ca78-11ef-7052-96e8-c09705a147f2 | LMND | 2026-09-22 14:54 | call_diagonal_spread | 2 | 1 | 50 | 118450.00 | long | ask | 46.8000 | 1.2000 | ["70","75"] | ["0.6917","0.7022"] | [] | ["XISX"] | 70.0000 | 75.0000 | 486 | 850 | false | true | true | true | |||||||||
| 01a0ca7a-158f-7c42-a382-12b4a935c122 | LMND | 2026-09-22 14:56 | call_diagonal_spread | 2 | 1 | 50 | 118000.00 | long | ask | 46.8900 | 1.0000 | ["70","75"] | ["0.6878","0.6986"] | [] | ["XPHO"] | 70.0000 | 75.0000 | 486 | 850 | false | true | true | true | |||||||||
| 01a0ca7f-70a7-7d42-949c-16afefa38c54 | LMND | 2026-09-22 15:02 | strangle | 2 | 1 | 30 | 124500.00 | short | bid | 47.1200 | 3.8333 | ["50","55"] | ["0.7150","0.7232"] | ["13.50","91.50"] | ["XISX"] | 50.0000 | 55.0000 | 850 | 850 | true | false | false | true | |||||||||
| 01a0d42f-86ff-7452-a151-468af365f651 | LMND | 2026-09-24 12:11 | put_calendar | 2 | 1 | 1000 | 590000.00 | short | bid | 43.4200 | 0.9500 | ["46"] | ["0.8740"] | [] | ["XBOX"] | 46.0000 | 46.0000 | 1 | 8 | false | false | true | false | |||||||||
| 01a0d4c3-27f7-7a32-88d4-c1f04fce2dbb | LMND | 2026-09-24 14:52 | other | 4 | 1 | 965 | 965700.00 | unknown | bid | 44.5800 | 4.3000 | ["48","48.5","50","53"] | ["0.9956","2.6635","2.2005","3.5964"] | ["44.13"] | ["XBOX"] | 48.0000 | 53.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a0d4d9-24df-7012-ac0e-194a4b1e9e2f | LMND | 2026-09-24 15:16 | put_ladder | 6 | 1 | 298 | 532380.00 | unknown | ask | 44.9300 | 9.6000 | ["49.5","50","51","52","53","55"] | ["2.7762","1.8915","4.0759","4.3589","2.4579","5.0034"] | ["40.51"] | ["XBOX"] | 49.5000 | 55.0000 | 1 | 1 | false | false | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:17:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:21:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:21:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:23:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:23:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:24:53Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:23:22Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:55:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:55:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:59:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:55:30Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:02:29Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:48:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:44:49Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:54:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:57:18Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:02:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:11:41Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:52:53Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:16:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |