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 | net_side |
|---|
| 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 |
|---|
| 01a06d4a-1845-7163-be3b-a81560c238f3 | LULU | 2026-09-04 12:39 | other | 2 | 1 | 60 | 238083.00 | unknown | — | 100.3501 | 3.1000 | ["115","140"] | ["0.4746","0.5461"] | [] | ["XCBO"] | 115.0000 | 140.0000 | 77 | 133 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:39:51Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d5b-797d-7311-ab18-1b5b80a4274c | LULU | 2026-09-04 12:58 | other | 2 | 1 | 40 | 435770.00 | unknown | — | 100.4529 | 5.0000 | ["155","170"] | ["0.5486","0.6397"] | [] | ["XCBO"] | 155.0000 | 170.0000 | 196 | 286 | false | false | true | true | false | mlat | |||||||
| 01a06da1-e0ed-7540-a525-ab830ba2a29f | LULU | 2026-09-04 14:15 | other | 2 | 1 | 36 | 210240.00 | unknown | — | 100.5100 | 3.6000 | ["130"] | ["6.8144"] | [] | ["AMXO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | false | mlat | |||||||
| 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 | |||||||||
| 01a06dc2-22bd-7960-8a82-6f59f664bc4a | LULU | 2026-09-04 14:50 | other | 2 | 1 | 824 | 144612.00 | unknown | — | 100.6100 | 0.1400 | ["90","100"] | ["0.4287","0.4105"] | [] | ["XPHO"] | 90.0000 | 100.0000 | 14 | 14 | false | true | false | true | false | mlat | |||||||
| 01a06de4-588d-7b92-a9e5-06914c2c3b73 | LULU | 2026-09-04 15:27 | other | 2 | 1 | 120 | 816360.00 | unknown | — | 100.3150 | 3.0000 | ["130","170"] | ["0.4912","0.8061"] | [] | ["XMIO"] | 130.0000 | 170.0000 | 77 | 196 | false | false | true | true | false | mlat | |||||||
| 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 | true | 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 | |||||||||
| 01a086ee-af08-7683-bde6-74465cc4df36 | LULU | 2026-09-09 12:09 | other | 4 | 1 | 20 | 107720.00 | unknown | — | 99.1600 | 3.4500 | ["90","100","105","115"] | ["0.4819","0.4806","0.4905","0.5021"] | [] | ["XMIO"] | 90.0000 | 115.0000 | 100 | 191 | false | false | true | true | false | mlat | |||||||
| 01a08744-1e20-7b41-8996-ca89b9d17ef6 | LULU | 2026-09-09 13:43 | other | 2 | 1 | 1600 | 196800.00 | unknown | — | 100.1500 | 0.2300 | ["105"] | ["0.4755"] | [] | ["XCBO"] | 105.0000 | 105.0000 | 2 | 9 | false | true | true | false | false | mlat | |||||||
| 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 | |||||||||
| 01a08cbf-7bd8-7080-ac81-9ccab3166ab6 | LULU | 2026-09-10 15:15 | other | 4 | 1 | 37 | 759536.00 | unknown | — | 96.1550 | 10.3000 | ["125","135","155","165"] | ["0.4965","0.5124","0.5665","0.6213"] | [] | ["XMIO"] | 125.0000 | 165.0000 | 190 | 372 | false | false | true | true | false | mlat | |||||||
| 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 | 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 | |||||||||
| 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 | false | true | |||||||||
| 01a0abad-50bb-7141-8b08-3218cbc784de | LULU | 2026-09-16 15:24 | put_vertical_spread | 2 | 1 | 100 | 103900.00 | unknown | — | 96.5500 | 0.4600 | ["80","95"] | ["0.4827","0.4772"] | [] | ["XCBO"] | 80.0000 | 95.0000 | 93 | 93 | false | true | false | true | false | mlat | |||||||
| 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-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 | |||||||||
| 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 | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:59:09Z"} |
| 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-04T18:16:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:50:32Z"} |
| 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:28:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| 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-09T16:09:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:43:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 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-10T19:15:59Z"} |
| 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-11T14:43:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:24:27Z"} |
| 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-21T14:59:19Z"} |
| 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:39Z"} |
| 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-22T15:04:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |