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 |
| 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 |
| 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 |
| 01a0ab39-5d23-7462-a4e1-23d0f9cbbdf5 | AMZN | 2026-09-16 13:17 | risk_reversal | 2 | 1 | 5 | 35625.00 | long | bid | 247.4960 | 0.6000 | ["270","280"] | ["0.3744","0.3663"] | ["255.55"] | ["XPHO"] | 270.0000 | 280.0000 | 366 | 366 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:18:02Z"} | 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 |
| 01a0a694-6d1e-78d0-9003-d06eabebdadd | AMZN | 2026-09-15 15:38 | call_calendar | 2 | 1 | 37 | 47656.00 | long | bid | 248.0100 | 0.0600 | ["270"] | ["0.3347"] | [] | ["C2OX"] | 270.0000 | 270.0000 | 31 | 94 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:39:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a690-fe36-73a3-8f22-77df3a5a7ae2 | AMZN | 2026-09-15 15:35 | risk_reversal | 2 | 1 | 4 | 28540.00 | long | bid | 248.0600 | 0.5500 | ["270","280"] | ["0.3569","0.3764"] | ["256.15"] | ["XPHO"] | 270.0000 | 280.0000 | 367 | 367 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:35:42Z"} | 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 |
| 01a0a08f-c7a9-7573-8ffa-70ec1c2bfa15 | AMZN | 2026-09-14 11:36 | risk_reversal | 2 | 1 | 5 | 32430.00 | long | bid | 253.5600 | 0.4000 | ["270","300"] | ["0.3719","0.3642"] | ["254.94"] | ["XBOX"] | 270.0000 | 300.0000 | 368 | 368 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:36:27Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ee-b948-7de0-81e5-994111038c88 | AMZN | 2026-09-11 15:25 | synthetic | 2 | 5 | 5 | 42377.00 | long | bid | 257.3000 | 1.2500 | ["320"] | ["0.3665"] | ["265.85"] | ["EMLD","XBOX","XISX","XMIO","XPHO"] | 320.0000 | 320.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:25:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ee-0d68-7db0-9c3e-5cf3e058c856 | AMZN | 2026-09-11 15:24 | synthetic | 2 | 2 | 4 | 33900.00 | long | bid | 257.3500 | 1.2500 | ["320"] | ["0.3666"] | ["265.85"] | ["XISX","XPHO"] | 320.0000 | 320.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:24:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ed-de88-7960-8843-4b3ae5e10079 | AMZN | 2026-09-11 15:24 | synthetic | 2 | 3 | 5 | 42350.00 | long | bid | 257.3400 | 1.3000 | ["320"] | ["0.3663"] | ["265.90"] | ["XISX","XMIO","XPHO"] | 320.0000 | 320.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:24:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ec-b1c0-7443-b4f9-93f1bd341584 | AMZN | 2026-09-11 15:23 | synthetic | 2 | 2 | 4 | 31740.00 | long | bid | 257.2200 | 0.3000 | ["310"] | ["0.3644"] | ["265.95"] | ["XISX","XPHO"] | 310.0000 | 310.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ec-add8-74b1-b5ca-4e5a762a29a7 | AMZN | 2026-09-11 15:23 | synthetic | 2 | 2 | 6 | 47610.00 | long | bid | 257.2200 | 0.3000 | ["310"] | ["0.3644"] | ["265.95"] | ["XISX","XPHO"] | 310.0000 | 310.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ec-add8-74b1-b5ca-4e4a864df8f0 | AMZN | 2026-09-11 15:23 | synthetic | 2 | 2 | 9 | 71415.00 | long | bid | 257.2200 | 0.3000 | ["310"] | ["0.3644"] | ["265.95"] | ["XISX","XPHO"] | 310.0000 | 310.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ec-a9f0-7842-a3c4-a9aa94794e9c | AMZN | 2026-09-11 15:23 | synthetic | 2 | 1 | 6 | 47610.00 | long | bid | 257.2200 | 0.3500 | ["310"] | ["0.3644"] | ["265.95"] | ["XPHO"] | 310.0000 | 310.0000 | 279 | 279 | false | false | false | false | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 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 |
| 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 |
| 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 |