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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c518-566f-7f11-8811-ec8e5ed8030e | AMZN | 2026-09-21 13:51 | put_vertical_spread | 2 | 1 | 15 | 58575.00 | long | ask | 258.3600 | 0.4500 | ["225","240"] | ["0.3638","0.3626"] | ["234.25"] | ["C2OX"] | 225.0000 | 240.0000 | 361 | 361 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:52:26Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c513-3dbf-7e03-bded-042104d0aebd | AMZN | 2026-09-21 13:46 | straddle | 2 | 2 | 150 | 26250.00 | long | ask | 258.9900 | 0.0500 | ["257.5"] | ["0.3663"] | ["255.75","259.25"] | ["XISX"] | 257.5000 | 257.5000 | 0 | 0 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:46:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c511-ab67-7a82-ab13-c7a26a35ddc2 | AMZN | 2026-09-21 13:44 | call_diagonal_spread | 2 | 1 | 10 | 33050.00 | short | ask | 258.8500 | 0.5500 | ["260","300"] | ["0.3554","0.3577"] | [] | ["XISX"] | 260.0000 | 300.0000 | 116 | 151 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:44:49Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c507-1477-72c1-9518-49329b5f2106 | AMZN | 2026-09-21 13:32 | call_vertical_spread | 2 | 1 | 10 | 71150.00 | long | ask | 257.7500 | 0.6500 | ["240","250"] | ["0.3728","0.3670"] | ["245.85"] | ["XCBO"] | 240.0000 | 250.0000 | 179 | 179 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:32:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e4-6977-7990-8d5f-c7a3337c33a0 | AMZN | 2026-09-21 12:54 | call_diagonal_spread | 2 | 1 | 20 | 32600.00 | unknown | ask | 257.9850 | 0.3100 | ["265","272.5"] | ["0.3615","1.1468"] | [] | ["XBOX"] | 265.0000 | 272.5000 | 0 | 88 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:55:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d0-4537-74c2-b704-d76bc3f18905 | AMZN | 2026-09-21 12:32 | put_diagonal_spread | 2 | 1 | 15 | 48690.00 | unknown | ask | 258.0450 | 0.3200 | ["257.5","285"] | ["0.3432","0.3789"] | [] | ["XISX"] | 257.5000 | 285.0000 | 0 | 60 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:33:12Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b615-6c2f-75b1-a47d-34243bc28499 | AMZN | 2026-09-18 15:54 | call_vertical_spread | 2 | 1 | 60 | 43500.00 | unknown | ask | 254.2800 | 0.1000 | ["305","350"] | ["0.3395","0.3468"] | ["312.25"] | ["XISX"] | 305.0000 | 350.0000 | 119 | 119 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b006-98bb-7402-85da-9ed76123e21a | AMZN | 2026-09-17 11:40 | call_ladder | 3 | 1 | 21 | 47670.00 | long | ask | 252.1500 | 0.2500 | ["270","290","300"] | ["0.3519","0.3501","0.3507"] | ["270.80","319.20"] | ["C2OX"] | 270.0000 | 300.0000 | 92 | 92 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:40:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab9a-e5e3-7c60-8247-c181ef7e19c1 | AMZN | 2026-09-16 15:04 | call_vertical_spread | 2 | 1 | 40 | 78000.00 | long | ask | 246.2850 | 0.4500 | ["350","380"] | ["0.3624","0.3636"] | ["353.60"] | ["XISX"] | 350.0000 | 380.0000 | 366 | 366 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:04:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae3-616b-79c0-ab24-e2e3b343419c | AMZN | 2026-09-16 11:43 | call_vertical_spread | 2 | 1 | 4 | 34020.00 | long | ask | 247.4750 | 0.7000 | ["220","225"] | ["0.3799","0.3757"] | ["223.35"] | ["XCBO"] | 220.0000 | 225.0000 | 184 | 184 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:44:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69f-ac06-7703-93fa-6901f813f25a | AMZN | 2026-09-15 15:51 | call_calendar | 2 | 1 | 14 | 91350.00 | long | ask | 247.5500 | 0.6500 | ["215"] | ["1.2407"] | [] | ["C2OX"] | 215.0000 | 215.0000 | 1 | 3 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:51:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69f-a81e-7ca3-8f25-da72bb1188cc | AMZN | 2026-09-15 15:51 | call_calendar | 2 | 1 | 4 | 26100.00 | long | ask | 247.5550 | 0.6500 | ["215"] | ["1.2360"] | [] | ["C2OX"] | 215.0000 | 215.0000 | 1 | 3 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:51:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69f-a81e-7ca3-8f25-da63b875e9e2 | AMZN | 2026-09-15 15:51 | call_calendar | 2 | 1 | 4 | 26100.00 | long | ask | 247.5550 | 0.6500 | ["215"] | ["1.2360"] | [] | ["C2OX"] | 215.0000 | 215.0000 | 1 | 3 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:51:26Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69e-dcfe-7c30-875e-ef2cd493d749 | AMZN | 2026-09-15 15:50 | call_calendar | 2 | 1 | 5 | 32775.00 | long | ask | 247.7100 | 0.7000 | ["215"] | ["1.2520"] | [] | ["C2OX"] | 215.0000 | 215.0000 | 1 | 3 | false | false | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:50:52Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a142-3370-7a82-8132-ddeebaf34957 | AMZN | 2026-09-14 14:51 | call_vertical_spread | 2 | 2 | 25 | 230625.00 | long | ask | 254.9650 | 0.5000 | ["260","270"] | ["0.3720","0.3690"] | ["264.45"] | ["XCBO"] | 260.0000 | 270.0000 | 494 | 494 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:52:04Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 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 |
| 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 |
| 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 |