Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a08c2d-26e9-7c82-af23-6f44a83dde69 | AMZN | 2026-09-10 12:36 | other | 2 | 1 | 11 | 27192.00 | unknown | — | 252.2400 | 0.4400 | ["245","265"] | ["0.3592","0.3128"] | [] | ["XBOX"] | 245.0000 | 265.0000 | 8 | 99 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:36:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08744-e558-71b1-86d1-cd27e54653ec | AMZN | 2026-09-09 13:43 | other | 2 | 1 | 38 | 37050.00 | unknown | — | 252.1400 | 0.1500 | ["255","260"] | ["0.3086","0.3129"] | [] | ["XISX"] | 255.0000 | 260.0000 | 9 | 30 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:44:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871c-9508-7fd3-aa96-2945f2b12c7d | AMZN | 2026-09-09 12:59 | strangle | 2 | 1 | 32 | 76960.00 | long | ask | 251.8500 | 0.1500 | ["240","285"] | ["0.3516","0.3520"] | ["215.95","309.05"] | ["C2OX"] | 240.0000 | 285.0000 | 128 | 128 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871c-9508-7fd3-aa96-292b8a03c19f | AMZN | 2026-09-09 12:59 | strangle | 2 | 2 | 16 | 38480.00 | long | ask | 251.8500 | 0.1500 | ["240","285"] | ["0.3516","0.3520"] | ["215.95","309.05"] | ["EMLD","XPHO"] | 240.0000 | 285.0000 | 128 | 128 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871c-9508-7fd3-aa96-28f6570a30b9 | AMZN | 2026-09-09 12:59 | strangle | 2 | 8 | 22 | 52910.00 | long | ask | 251.8600 | 0.2000 | ["240","285"] | ["0.3517","0.3519"] | ["215.95","309.05"] | ["ARCO","EMLD","XCBO","XISX","XMIO","XPHO"] | 240.0000 | 285.0000 | 128 | 128 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 01a086c5-0310-73f2-a7de-c2169564299c | AMZN | 2026-09-09 11:24 | call_vertical_spread | 2 | 1 | 100 | 156000.00 | long | ask | 250.9400 | 0.1000 | ["255","260"] | ["0.3199","0.3189"] | ["257"] | ["XISX"] | 255.0000 | 260.0000 | 37 | 37 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:24:15Z"} | 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 |
| 01a08688-53e8-7721-989c-128e67b915d9 | AMZN | 2026-09-09 10:17 | other | 2 | 1 | 8 | 52400.00 | unknown | — | 251.7950 | 1.2500 | ["220"] | ["0.5897"] | [] | ["XISX"] | 220.0000 | 220.0000 | 2 | 30 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:18:09Z"} | 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 |
| 01a08667-52b0-7533-b637-79a1cfe1996b | AMZN | 2026-09-09 09:41 | put_vertical_spread | 2 | 1 | 10 | 29400.00 | long | ask | 252.7700 | 0.4000 | ["235","250"] | ["0.3558","0.3547"] | ["243.60"] | ["XCBO"] | 235.0000 | 250.0000 | 128 | 128 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0827d-b888-71f0-8279-043699aa4d42 | AMZN | 2026-09-08 15:27 | other | 2 | 1 | 400 | 115600.00 | unknown | — | 257.2200 | 0.0900 | ["195","200"] | ["0.6097","0.3756"] | [] | ["XISX"] | 195.0000 | 200.0000 | 10 | 129 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:28:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0818a-c538-7b90-ac63-5b904a991130 | AMZN | 2026-09-08 11:02 | other | 3 | 1 | 210 | 476700.00 | unknown | — | 256.7985 | 0.9200 | ["130","300","410"] | ["0.4139","0.3715","0.3706"] | [] | ["XISX"] | 130.0000 | 410.0000 | 465 | 465 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:02:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 01a06d24-bdc5-7373-a53c-9bbb6f3c000a | AMZN | 2026-09-04 11:58 | call_vertical_spread | 2 | 1 | 10 | 28600.00 | unknown | — | 256.0050 | 0.3000 | ["265","275"] | ["0.3440","0.3423"] | [] | ["XISX"] | 265.0000 | 275.0000 | 105 | 105 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:59:04Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |