Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5fe-afdf-71a0-bcc9-35b845264082 | AMZN | 2026-09-18 15:29 | call_vertical_spread | 2 | 1 | 10 | 25650.00 | short | bid | 254.6971 | 0.2500 | ["245","250"] | ["0.2973","0.2940"] | ["248.25"] | ["C2OX"] | 245.0000 | 250.0000 | 28 | 28 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:29:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52e-1d57-7eb1-bb21-a7b6884936c3 | AMZN | 2026-09-18 11:41 | iron_condor | 4 | 1 | 320 | 88640.00 | short | bid | 252.8260 | 0.1600 | ["230","240","272.5","282.5"] | ["0.3285","0.2976","0.2924","0.3051"] | ["238.57","273.93"] | ["XISX"] | 230.0000 | 282.5000 | 14 | 14 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:42:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b524-3a17-7890-9e3e-5a972976597b | AMZN | 2026-09-18 11:30 | put_vertical_spread | 2 | 1 | 41 | 99425.00 | short | bid | 253.1450 | 0.7000 | ["170","175"] | ["0.3831","0.3814"] | ["173.85"] | ["C2OX"] | 170.0000 | 175.0000 | 819 | 819 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fb-bae7-76a3-9a91-0ac049874315 | AMZN | 2026-09-18 10:46 | put_vertical_spread | 2 | 1 | 17 | 40885.00 | short | bid | 252.8550 | 1.0000 | ["170","175"] | ["0.3813","0.3797"] | ["173.85"] | ["C2OX"] | 170.0000 | 175.0000 | 819 | 819 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:46:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-0643-7e02-b748-776e671819cd | AMZN | 2026-09-17 15:57 | put_diagonal_spread | 2 | 1 | 13 | 32370.00 | short | bid | 251.4050 | 0.3000 | ["260","265"] | ["0.3693","0.2887"] | [] | ["XCBO"] | 260.0000 | 265.0000 | 1 | 29 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b065-c403-7033-bcf0-e2465813babf | AMZN | 2026-09-17 13:24 | put_calendar | 2 | 2 | 26 | 54470.00 | short | bid | 251.1600 | 0.7000 | ["260"] | ["0.3353"] | [] | ["XCBO"] | 260.0000 | 260.0000 | 1 | 22 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:24:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afbe-8783-7531-afc9-1cf4bbc5ae40 | AMZN | 2026-09-17 10:21 | straddle | 2 | 1 | 20 | 116100.00 | short | bid | 251.0500 | 0.4700 | ["200"] | ["0.3934"] | ["141.95","258.05"] | ["MCRY"] | 200.0000 | 200.0000 | 92 | 92 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:21:33Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa86-fd13-7640-9379-1504ff588ee9 | AMZN | 2026-09-16 10:02 | iron_condor | 4 | 1 | 125 | 34625.00 | short | bid | 248.1750 | 0.0800 | ["230","235","262.5","267.5"] | ["0.3554","0.3349","0.3184","0.3266"] | ["234.13","263.37"] | ["XISX"] | 230.0000 | 267.5000 | 9 | 9 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:02:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69d-277e-7b93-bca6-f5a570b3281b | AMZN | 2026-09-15 15:48 | put_vertical_spread | 2 | 1 | 33 | 46200.00 | short | bid | 247.4000 | 0.2000 | ["225","230"] | ["0.3860","0.3808"] | ["228.60"] | ["XISX"] | 225.0000 | 230.0000 | 66 | 66 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a635-3a06-74d1-8888-c4dc94ec6891 | AMZN | 2026-09-15 13:54 | call_vertical_spread | 2 | 2 | 653 | 69871.00 | short | bid | 248.7304 | 0.0256 | ["257.5","260"] | ["0.3671","0.3779"] | ["257.75"] | ["XISX"] | 257.5000 | 260.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:55:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a161-b5d8-7f10-bf11-7d14bfb617d7 | AMZN | 2026-09-14 15:25 | call_diagonal_spread | 2 | 1 | 25 | 250125.00 | short | bid | 253.6100 | 1.4000 | ["205","210"] | ["0.9206","0.3758"] | [] | ["XCBO"] | 205.0000 | 210.0000 | 4 | 123 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:26:10Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d4-fa80-7543-9c5c-9bfdc49b71e6 | AMZN | 2026-09-14 12:51 | call_diagonal_spread | 2 | 1 | 3 | 27465.00 | short | bid | 254.8800 | 1.3000 | ["210","215"] | ["0.7304","0.3863"] | [] | ["XCBO"] | 210.0000 | 215.0000 | 4 | 95 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:51:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09f-c568-7202-9cb1-fcebe18c68a6 | AMZN | 2026-09-14 11:53 | call_diagonal_spread | 2 | 1 | 106 | 48548.00 | short | bid | 254.0301 | 0.1600 | ["270","280"] | ["0.3025","0.3869"] | [] | ["XPHO"] | 270.0000 | 280.0000 | 4 | 39 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:53:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a043-f581-7ff2-a839-d3687bac3068 | AMZN | 2026-09-14 10:13 | put_calendar | 2 | 1 | 10 | 26500.00 | short | bid | 252.5900 | 1.8500 | ["265"] | ["0.3227"] | [] | ["XISX"] | 265.0000 | 265.0000 | 4 | 14 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:31Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08ce1-c149-7481-b54c-3d54048be416 | AMZN | 2026-09-10 15:53 | call_diagonal_spread | 2 | 2 | 12 | 53040.00 | short | bid | 251.2650 | 1.1000 | ["235","250"] | ["0.3355","0.3549"] | [] | ["XCBO"] | 235.0000 | 250.0000 | 36 | 127 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:53:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08701-9eb0-7d13-81e3-8603bcc22ab3 | AMZN | 2026-09-09 12:30 | call_diagonal_spread | 2 | 2 | 5 | 76225.00 | short | ask | 251.1950 | 1.8000 | ["175","195"] | ["1.0675","0.3931"] | [] | ["XCBO"] | 175.0000 | 195.0000 | 9 | 373 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:30:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c4-3408-7ee3-ad07-4a75256fa588 | AMZN | 2026-09-09 11:23 | call_vertical_spread | 2 | 1 | 65 | 1061775.00 | short | bid | 251.0100 | 1.5000 | ["170","175"] | ["0.4775","0.4638"] | ["174.75"] | ["XISX"] | 170.0000 | 175.0000 | 100 | 100 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:23:18Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-c1d8-7c22-8235-5d85e60c242e | AMZN | 2026-09-09 10:14 | call_vertical_spread | 2 | 2 | 4 | 29880.00 | short | bid | 252.5050 | 1.2500 | ["220","230"] | ["0.3764","0.3737"] | ["227.10"] | ["XCBO"] | 220.0000 | 230.0000 | 100 | 100 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:14:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08682-50d8-73a0-98a5-3a8e3643c82c | AMZN | 2026-09-09 10:11 | call_calendar | 2 | 1 | 160 | 29920.00 | short | bid | 252.1950 | 0.0200 | ["285"] | ["0.3539"] | [] | ["XCBO"] | 285.0000 | 285.0000 | 9 | 37 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866f-5190-7420-b8d1-e2b1ed43964c | AMZN | 2026-09-09 09:50 | call_calendar | 2 | 1 | 6 | 38190.00 | short | ask | 252.4100 | 1.3500 | ["240"] | ["0.3719"] | [] | ["C2OX"] | 240.0000 | 240.0000 | 128 | 163 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:52Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08139-e618-7ba1-8e25-dd69e9839edd | AMZN | 2026-09-08 09:34 | put_diagonal_spread | 2 | 1 | 10 | 26250.00 | short | bid | 256.4800 | 1.3500 | ["267.5","270"] | ["0.4247","0.3277"] | [] | ["C2OX"] | 267.5000 | 270.0000 | 3 | 10 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dda-3ab5-76f2-9cf8-a6d1a5d11cb2 | AMZN | 2026-09-04 15:16 | iron_condor | 4 | 1 | 50 | 26300.00 | short | bid | 258.1599 | 0.0600 | ["245","255","262.5","272.5"] | ["0.2813","0.2675","0.2658","0.2838"] | ["251.36","266.14"] | ["XISX"] | 245.0000 | 272.5000 | 7 | 7 | false | true | false | true | true | mesl | tracked | 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 |
| 01a06dbe-84f5-7972-9797-f39ca73cac95 | AMZN | 2026-09-04 14:46 | risk_reversal | 2 | 2 | 197 | 71314.00 | short | ask | 257.5900 | 0.0600 | ["250","275"] | ["0.2899","0.2914"] | ["248.38"] | ["ARCO","C2OX"] | 250.0000 | 275.0000 | 14 | 14 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:46:50Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dbd-d52d-7de3-a8fd-9040fdc0b2c6 | AMZN | 2026-09-04 14:45 | risk_reversal | 2 | 1 | 71 | 25347.00 | short | ask | 257.7000 | 0.0800 | ["250","275"] | ["0.2876","0.2918"] | ["248.47"] | ["XBOX"] | 250.0000 | 275.0000 | 14 | 14 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:46:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dbd-d52d-7de3-a8fd-90217c830083 | AMZN | 2026-09-04 14:45 | risk_reversal | 2 | 1 | 109 | 39022.00 | short | ask | 257.7450 | 0.0700 | ["250","275"] | ["0.2883","0.2921"] | ["248.48"] | ["ARCO"] | 250.0000 | 275.0000 | 14 | 14 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:46:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7b-b765-7911-a737-5109645ebc05 | AMZN | 2026-09-04 13:33 | call_diagonal_spread_bearish | 2 | 1 | 12 | 56160.00 | short | bid | 256.8200 | 0.3000 | ["235","250"] | ["0.3228","0.3505"] | [] | ["C2OX"] | 235.0000 | 250.0000 | 14 | 105 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |