core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0da1e-5f37-7793-bdcd-f1616e707e31 | LULU | 2026-09-25 15:50 | put_vertical_spread | 2 | 1 | 4 | 108144.00 | short | bid | 99.7050 | 4.9500 | ["230","240"] | ["1.1186","1.1724"] | [] | ["AMXO"] | 230.0000 | 240.0000 | 84 | 84 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:50:20Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0da1e-5f37-7793-bdcd-f147823b63ac | LULU | 2026-09-25 15:50 | put_vertical_spread | 2 | 2 | 4 | 108152.00 | short | bid | 99.7050 | 4.9500 | ["230","240"] | ["1.1197","1.1735"] | [] | ["EMLD","SPHR"] | 230.0000 | 240.0000 | 84 | 84 | false | false | false | ||||||||||
| 01a0d946-d388-7f71-823b-6fd12cc0c3fc | LULU | 2026-09-25 11:54 | put_calendar | 2 | 1 | 20 | 220800.00 | long | bid | 101.8250 | 6.5500 | ["155"] | ["0.5557"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 175 | 448 | false | false | true | false | |||||||||
| 01a0d923-bb27-7aa0-a92a-7baa5b17ffff | LULU | 2026-09-25 11:16 | iron_butterfly | 4 | 1 | 20 | 107860.00 | long | bid | 101.8700 | 6.1400 | ["120","130","140"] | ["0.4761","0.5008","0.5231"] | ["120.61","139.39"] | ["XMIO"] | 120.0000 | 140.0000 | 84 | 84 | false | false | false | ||||||||||
| 01a0d4fa-87c0-7852-8d3b-7b944c8491e6 | LULU | 2026-09-24 15:53 | put_vertical_spread | 2 | 1 | 4 | 103088.00 | short | bid | 101.4500 | 3.6500 | ["210","250"] | ["0.9521","1.1465"] | [] | ["AMXO"] | 210.0000 | 250.0000 | 113 | 113 | false | false | false | ||||||||||
| 01a0d448-98f7-7271-ad5a-ff62b6eb2d9f | LULU | 2026-09-24 12:38 | call_diagonal_spread | 2 | 6 | 49 | 169260.00 | unknown | bid | 101.1300 | 1.7184 | ["140","145"] | ["0.5005","0.4930"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 140.0000 | 145.0000 | 484 | 813 | false | true | true | ||||||||||
| 01a0cf92-8af7-7683-985a-11ad42511633 | LULU | 2026-09-23 14:41 | straddle | 2 | 1 | 1100 | 932800.00 | short | bid | 102.4900 | 0.4500 | ["105"] | ["0.3995"] | ["96.52","113.48"] | ["AMXO"] | 105.0000 | 105.0000 | 23 | 23 | false | false | false | false | |||||||||
| 01a0c9a5-c5ff-7cb2-b2d6-483e4606f1e6 | LULU | 2026-09-22 11:04 | call_vertical_spread | 2 | 1 | 400 | 147600.00 | unknown | bid | 102.6999 | 0.3200 | ["102","103"] | ["0.4644","0.4598"] | ["104.34"] | ["XCBO"] | 102.0000 | 103.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c47f-1027-7021-8735-85b949f35273 | LULU | 2026-09-21 11:04 | put_calendar | 2 | 1 | 70 | 508130.00 | unknown | bid | 99.1500 | 2.7000 | ["120"] | ["0.5251"] | [] | ["XPHO"] | 120.0000 | 120.0000 | 816 | 851 | false | false | true | false | |||||||||
| 01a0c47e-e916-74d0-b777-efd8249f6983 | LULU | 2026-09-21 11:04 | put_calendar | 2 | 1 | 62 | 296670.00 | unknown | bid | 99.1800 | 2.6500 | ["100"] | ["0.5120"] | [] | ["XISX"] | 100.0000 | 100.0000 | 816 | 851 | false | false | true | false | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 01a0c47a-60ef-78a1-b953-314fd5ed7927 | LULU | 2026-09-21 10:59 | put_calendar | 2 | 1 | 57 | 135717.00 | unknown | bid | 99.2674 | 1.9500 | ["75"] | ["0.5100"] | [] | ["XCBO"] | 75.0000 | 75.0000 | 816 | 851 | false | true | true | 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 | |||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | |||||||||
| 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 | ||||||||||
| 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 | |||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:50:20Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:54:54Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:16:40Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:53:07Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:39:16Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:41:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:04:42Z"} |
| 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-21T15:04:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:04:33Z"} |
| 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-21T15:03:08Z"} |
| 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-21T15:02:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:59:19Z"} |
| 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-21T14:58:52Z"} |
| 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-18T19:51:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| mlft |
| 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 |
| false |
| 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 |
| mlet |
| 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 |
| false |
| 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 |
| false |
| 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 |
| false |
| 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 |
| mlft |
| 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 |