core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a0c47d-c807-7a72-8c40-48aa6b8551da | LULU | 2026-09-21 11:02 | put_calendar | 2 | 1 | 30 | 178440.00 | short | bid | 99.2000 | 2.4000 | ["110"] | ["0.5159"] | [] | ["BATO"] | 110.0000 | 110.0000 | 816 | 851 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:03:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c47d-4eef-7311-b1d2-9dd000acae0d | LULU | 2026-09-21 11:02 | put_calendar | 2 | 1 | 26 | 206024.00 | short | bid | 99.2500 | 2.6000 | ["125"] | ["0.5289"] | [] | ["BATO"] | 125.0000 | 125.0000 | 816 | 851 | false | false | true | false | false | ||||||||
| 01a0c47c-f8ff-78c3-a222-fabb0f844ad4 | LULU | 2026-09-21 11:01 | put_calendar | 2 | 1 | 10 | 100940.00 | short | ask | 99.2200 | 3.9500 | ["140"] | ["0.5451"] | [] | ["XISX"] | 140.0000 | 140.0000 | 816 | 851 | false | false | true | false | false | ||||||||
| 01a0c47c-9f26-74f1-bd35-f9d0345d3193 | LULU | 2026-09-21 11:01 | put_calendar | 2 | 1 | 20 | 172600.00 | short | ask | 99.2800 | 3.1000 | ["130"] | ["0.5344"] | [] | ["XMIO"] | 130.0000 | 130.0000 | 816 | 851 | false | false | true | false | false | ||||||||
| 01a0c47b-996f-7d00-a85f-e2901ee7da30 | LULU | 2026-09-21 11:00 | put_calendar | 2 | 1 | 60 | 254340.00 | short | ask | 99.2200 | 2.3000 | ["95"] | ["0.5104"] | [] | ["XMIO"] | 95.0000 | 95.0000 | 816 | 851 | false | true | true | false | false | ||||||||
| 01a0c47a-b2f7-7033-96c3-309129da2d50 | LULU | 2026-09-21 10:59 | put_calendar | 2 | 1 | 13 | 151879.00 | short | ask | 99.3000 | 6.0500 | ["150"] | ["0.5631"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 816 | 851 | false | false | true | false | false | ||||||||
| 01a0c47a-0ee8-7d00-b359-d62eede13e4e | LULU | 2026-09-21 10:58 | put_calendar | 2 | 1 | 10 | 109030.00 | short | bid | 99.2674 | 6.0500 | ["145"] | ["0.5559"] | [] | ["XPHO"] | 145.0000 | 145.0000 | 816 | 851 | false | false | true | false | false | ||||||||
| 01a0b612-6e8f-74e0-93d6-b975131837a4 | LULU | 2026-09-18 15:50 | put_vertical_spread | 2 | 3 | 5 | 112550.00 | short | bid | 97.5100 | 4.2000 | ["200","220"] | ["0.9074","1.0091"] | ["200.02"] | ["BATO","C2OX","EDGO"] | 200.0000 | 220.0000 | 119 | 119 | false | false | false | true | |||||||||
| 01a0b612-6e8f-74e0-93d6-b96f12570c4f | LULU | 2026-09-18 15:50 | put_vertical_spread | 2 | 2 | 8 | 180128.00 | short | bid | 97.5100 | 4.2000 | ["200","220"] | ["0.9098","1.0116"] | ["200.02"] | ["EMLD","SPHR"] | 200.0000 | 220.0000 | 119 | 119 | false | false | false | true | |||||||||
| 01a0b60f-9fcf-7e23-9cbb-e8c878e57963 | LULU | 2026-09-18 15:47 | put_vertical_spread | 2 | 1 | 7 | 185486.00 | short | bid | 97.2600 | 2.0500 | ["210","250"] | ["0.9351","1.1272"] | [] | ["MCRY"] | 210.0000 | 250.0000 | 119 | 119 | false | false | false | true | |||||||||
| 01a0afd6-5543-70c3-99fc-153c1a1df821 | LULU | 2026-09-17 10:47 | synthetic | 2 | 1 | 450 | 2466000.00 | short | ask | 95.7000 | 3.6500 | ["130"] | ["0.5000"] | ["101.40"] | ["XBOX"] | 130.0000 | 130.0000 | 491 | 491 | false | false | false | false | true | ||||||||
| 01a0aa7e-469a-7821-a5f9-cd22084c7fc4 | LULU | 2026-09-16 09:53 | put_vertical_spread | 2 | 1 | 7 | 149786.00 | short | bid | 97.8000 | 7.0000 | ["200","210"] | ["0.6873","0.7250"] | ["200.06"] | ["XCBO"] | 200.0000 | 210.0000 | 492 | 492 | false | false | false | true | |||||||||
| 01a0aa7e-469a-7821-a5f9-cd14a4372966 | LULU | 2026-09-16 09:53 | put_vertical_spread | 2 | 1 | 13 | 278200.00 | short | bid | 97.8000 | 7.0000 | ["200","210"] | ["0.6876","0.7253"] | ["200.06"] | ["XMIO"] | 200.0000 | 210.0000 | 492 | 492 | false | false | false | true | |||||||||
| 01a0a169-9191-7c12-85b7-3d019db906f4 | LULU | 2026-09-14 15:34 | put_vertical_spread | 2 | 1 | 108 | 225072.00 | short | bid | 100.5100 | 3.5500 | ["108","113"] | ["0.4408","0.4870"] | ["108.42"] | ["XCBO"] | 108.0000 | 113.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a0a0f7-ff58-7613-b358-34fa86063b7e | LULU | 2026-09-14 13:29 | straddle | 2 | 1 | 500 | 2500000.00 | short | bid | 100.8050 | 2.2500 | ["120"] | ["0.5011"] | ["70","170.00"] | ["SPHR"] | 120.0000 | 120.0000 | 494 | 494 | false | false | false | false | true | ||||||||
| 01a09201-08c8-7fc3-a216-a298e56fc5c4 | LULU | 2026-09-11 15:45 | put_vertical_spread | 2 | 1 | 6 | 164304.00 | short | bid | 98.5800 | 6.3000 | ["230","240"] | ["1.1377","1.1882"] | [] | ["AMXO"] | 230.0000 | 240.0000 | 98 | 98 | false | false | false | true | |||||||||
| 01a0912a-f800-7801-92b1-6de28c8d2aec | LULU | 2026-09-11 11:51 | straddle | 2 | 1 | 50 | 132500.00 | short | bid | 97.6100 | 2.1000 | ["100"] | ["0.4747"] | ["73.50","126.50"] | ["XMIO"] | 100.0000 | 100.0000 | 189 | 189 | false | false | false | false | true | ||||||||
| 01a08cdf-d518-7501-a66f-1bb922ac4024 | LULU | 2026-09-10 15:51 | put_vertical_spread | 2 | 2 | 4 | 150640.00 | short | bid | 96.7700 | 5.0000 | ["280","290"] | ["1.3087","1.3504"] | [] | ["EMLD","SPHR"] | 280.0000 | 290.0000 | 99 | 99 | false | false | false | true | |||||||||
| 01a08cb6-dcd0-7311-978d-1aaa0695f4a8 | LULU | 2026-09-10 15:06 | put_vertical_spread | 2 | 1 | 12 | 164712.00 | short | bid | 95.7700 | 4.6500 | ["155","175"] | ["0.5737","0.7014"] | ["0","155"] | ["XCBO"] | 155.0000 | 175.0000 | 127 | 127 | false | false | false | true | |||||||||
| 01a081f2-e190-7133-b891-c26af3a33429 | LULU | 2026-09-08 12:56 | put_calendar | 2 | 1 | 200 | 942800.00 | short | ask | 102.8000 | 1.5000 | ["105"] | ["0.5044"] | [] | ["XMIO"] | 105.0000 | 105.0000 | 500 | 829 | false | false | true | false | false | ||||||||
| 01a0817f-f798-7911-8d19-a3151f318fa2 | LULU | 2026-09-08 10:50 | put_vertical_spread | 2 | 1 | 29 | 114869.00 | short | bid | 100.6450 | 3.0000 | ["120","121"] | ["1.4943","1.6022"] | [] | ["XMIO"] | 120.0000 | 121.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a06dbc-b41d-7141-99b1-e6afa8aef556 | LULU | 2026-09-04 14:44 | put_calendar | 2 | 1 | 8 | 135520.00 | short | ask | 100.5200 | 5.2000 | ["185"] | ["0.6912"] | [] | ["XCBO"] | 185.0000 | 185.0000 | 133 | 378 | false | false | true | false | false | ||||||||
| 01a06d79-b3c6-7220-94b9-d5bf06cfeb77 | LULU | 2026-09-04 13:31 | straddle | 2 | 1 | 1200 | 1814400.00 | short | bid | 100.8350 | 0.5500 | ["100"] | ["0.4116"] | ["84.88","115.12"] | ["XBOX"] | 100.0000 | 100.0000 | 77 | 77 | false | false | false | false | true | ||||||||
| 01a06d44-8a66-76b0-9a11-c872193d09a3 | LULU | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 1 | 10 | 106020.00 | short | ask | 100.1150 | 4.5500 | ["150","155"] | ["0.5418","0.6291"] | [] | ["AMXO"] | 150.0000 | 155.0000 | 105 | 196 | false | false | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:02:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:02:15Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:01:48Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:00:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:59:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:58:52Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:51:04Z"} |
| 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-18T19:51:04Z"} |
| 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-18T19:47:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:47:42Z"} |
| 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-16T13:53:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:53:17Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:34:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:30:20Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:45:50Z"} |
| 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-11T15:51:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:51:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:06:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:56:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:50:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:44:57Z"} |
| 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-04T17:31:38Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |