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 |
|---|
| 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 |
|---|
| 01a0d4bc-3a86-7c41-acc0-dec3db6baf7a | LULU | 2026-09-24 14:44 | other | 8 | 1 | 555 | 16163720.00 | unknown | ask | 100.4850 | 19.3500 | ["107","108","109","185","190","280","300"] | ["1.2758","1.7009","1.7236","0.8927","0.9624","1.3448","1.5521"] | [] | ["XBOX"] | 107.0000 | 300.0000 | 1 | 113 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T18:45:11Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d44b-b9c0-7c73-92f3-ebc31589315e | LULU | 2026-09-24 12:42 | call_diagonal_spread | 2 | 6 | 49 | 169594.00 | long | ask | 101.4200 | 1.9173 | ["140","145"] | ["0.4985","0.4911"] | [] | ["AMXO","EMLD","XBOX","XISX","XMIO","XPHO"] | 140.0000 | 145.0000 | 484 | 813 | false | true | |||||||||||
| 01a0c4db-68c7-7250-b403-b003e92e10c0 | LULU | 2026-09-21 12:45 | put_vertical_spread | 2 | 2 | 50 | 1037250.00 | long | ask | 101.7900 | 4.0900 | ["180","230"] | ["0.6465","0.8581"] | ["180.15"] | ["XISX"] | 180.0000 | 230.0000 | 269 | 269 | true | 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a0b590-2ae7-7710-870a-54aaa3009232 | LULU | 2026-09-18 13:28 | call_diagonal_spread | 2 | 1 | 18 | 111600.00 | unknown | ask | 99.1700 | 3.9000 | ["60","80"] | ["0.8407","11.9231"] | [] | ["XBOX"] | 60.0000 | 80.0000 | 0 | 91 | false | false | |||||||||||
| 01a0b534-8dc7-7d61-9ad2-78257cb9cb43 | LULU | 2026-09-18 11:48 | straddle | 2 | 1 | 1500 | 1485000.00 | long | ask | 100.1900 | 0.5300 | ["105"] | ["0.4072"] | ["95.10","114.90"] | ["AMXO"] | 105.0000 | 105.0000 | 28 | 28 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0aae2-a9d3-79a2-81e4-d1fa0c8519a5 | LULU | 2026-09-16 11:42 | put_vertical_spread | 2 | 1 | 47 | 103588.00 | long | ask | 97.4400 | 1.7500 | ["106","111"] | ["0.3522","0.6064"] | ["106.20"] | ["XCBO"] | 106.0000 | 111.0000 | 9 | 9 | false | false | |||||||||||
| 01a0aae2-a9d3-79a2-81e4-d1e41a9aed43 | LULU | 2026-09-16 11:42 | put_vertical_spread | 2 | 3 | 63 | 138474.00 | long | ask | 97.4400 | 1.8310 | ["106","111"] | ["0.3368","0.6064"] | ["106.20"] | ["ARCO","EMLD","SPHR"] | 106.0000 | 111.0000 | 9 | 9 | false | false | |||||||||||
| 01a0a557-787e-75a0-a936-cc64099733ec | LULU | 2026-09-15 09:52 | call_vertical_spread | 2 | 1 | 333 | 233766.00 | long | ask | 98.6000 | 0.9700 | ["110","150"] | ["0.5080","0.5058"] | ["115.56"] | ["SPHR"] | 110.0000 | 150.0000 | 94 | 94 | false | true | |||||||||||
| 01a0a169-9578-7572-9e6c-2e23fcd0749c | LULU | 2026-09-14 15:34 | put_vertical_spread | 2 | 1 | 45 | 289890.00 | long | ask | 100.4400 | 2.0000 | ["110","150"] | ["0.4753","0.5871"] | ["115.24"] | ["XCBO"] | 110.0000 | 150.0000 | 95 | 95 | false | false | |||||||||||
| 01a090eb-dbc0-7071-b241-b7189af08660 | LULU | 2026-09-11 10:42 | put_vertical_spread | 2 | 1 | 20 | 190180.00 | long | ask | 97.6600 | 2.8500 | ["140","150"] | ["0.5599","0.6187"] | ["140.25"] | ["XCBO"] | 140.0000 | 150.0000 | 98 | 98 | false | false | |||||||||||
| 01a08cdf-d518-7501-a66f-1c0f61a4b7c5 | LULU | 2026-09-10 15:51 | put_vertical_spread | 2 | 1 | 12 | 284040.00 | long | ask | 96.7700 | 4.8000 | ["210","220"] | ["0.9918","1.0457"] | [] | ["AMXO"] | 210.0000 | 220.0000 | 99 | 99 | false | false | |||||||||||
| 01a08c16-6a99-7480-be48-d880f540c4ad | LULU | 2026-09-10 12:11 | put_calendar | 2 | 2 | 250 | 696250.00 | long | ask | 98.2900 | 1.4000 | ["100"] | ["0.4545"] | [] | ["ARCO"] | 100.0000 | 100.0000 | 71 | 498 | false | false | |||||||||||
| 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 | |||||||||||
| 01a06dff-cfce-7132-8057-f14eb03634d5 | LULU | 2026-09-04 15:57 | put_calendar | 2 | 1 | 16 | 112456.00 | long | ask | 100.5700 | 2.4000 | ["135"] | ["0.7228"] | [] | ["XPHO"] | 135.0000 | 135.0000 | 14 | 105 | false | false | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a06d3e-b24d-7fc2-8ade-d116f270124e | LULU | 2026-09-04 12:26 | put_vertical_spread | 2 | 1 | 155 | 664020.00 | long | ask | 100.2550 | 1.5000 | ["121","122"] | ["5.2053","5.4996"] | [] | ["XISX"] | 121.0000 | 122.0000 | 0 | 0 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:42:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:45:32Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| 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 |
| false |
| false |
| mlet |
| 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 |
| false |
| false |
| mlet |
| 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 |
| false |
| false |
| mlat |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:28:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:48:57Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlft |
| 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 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:43:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:43:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:53:01Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| 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 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:43:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| 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 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:11:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| 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 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:58:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| false |
| mlat |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:27:05Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |