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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b624-9317-7383-a936-777204312c49 | SPX | 2026-09-18 16:10 | call_butterfly_spread | 3 | 1 | 10 | 40150.00 | short | bid | 7650.5000 | 0.6200 | ["7650","7655","7660"] | ["0.0780","0.0758","0.0741"] | ["7650.30","7659.70"] | ["XCBO"] | 7650.0000 | 7660.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:11:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b622-58c7-7ad2-9425-434dcfd7b4d4 | SPX | 2026-09-18 16:08 | call_butterfly_spread | 3 | 2 | 12 | 52260.00 | short | bid | 7650.5000 | 0.5167 | ["7645","7650","7655"] | ["0.0747","0.0729","0.0715"] | ["7645.30","7654.70"] | ["XCBO"] | 7645.0000 | 7655.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:08:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b622-58c7-7ad2-9425-4324856e7ac9 | SPX | 2026-09-18 16:08 | call_butterfly_spread | 3 | 2 | 22 | 95810.00 | short | bid | 7650.5000 | 0.7000 | ["7645","7650","7655"] | ["0.0747","0.0729","0.0715"] | ["7645.30","7654.70"] | ["XCBO"] | 7645.0000 | 7655.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:08:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-5197-7b80-8346-2baf5adbb614 | SPX | 2026-09-18 15:02 | call_butterfly_spread | 3 | 2 | 18 | 71190.00 | short | bid | 7641.5300 | 0.5111 | ["7635","7640","7645"] | ["0.0649","0.0638","0.0629"] | ["7635.30","7644.70"] | ["XCBO"] | 7635.0000 | 7645.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-5197-7b80-8346-2b3860d89de9 | SPX | 2026-09-18 15:02 | call_butterfly_spread | 3 | 1 | 14 | 55430.00 | short | bid | 7641.5300 | 0.5143 | ["7635","7640","7645"] | ["0.0649","0.0638","0.0633"] | ["7635.39","7644.61"] | ["XCBO"] | 7635.0000 | 7645.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5dd-6087-7492-8b83-109fb04729bc | SPX | 2026-09-18 14:52 | call_butterfly_spread | 3 | 1 | 6 | 25430.00 | short | bid | 7643.2800 | 0.5333 | ["7635","7640","7645"] | ["0.0665","0.0654","0.0648"] | ["7635.37","7644.63"] | ["XCBO"] | 7635.0000 | 7645.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:52:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a6a7-7fed-7083-9307-1c20f2869998 | SPX | 2026-09-15 15:59 | call_butterfly_spread | 3 | 2 | 29 | 29355.00 | short | bid | 7584.1600 | 0.4208 | ["7575","7580","7585"] | [null,null,"0.2321"] | ["7579.50","7582.41"] | ["XCBO"] | 7575.0000 | 7585.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a091-61d0-77f3-a606-449fb50873de | SPX | 2026-09-14 11:37 | call_butterfly_spread | 3 | 2 | 14 | 62690.00 | short | bid | 7622.9300 | 0.7857 | ["7615","7620","7625"] | ["0.1303","0.1280","0.1267"] | ["7615.36","7624.64"] | ["XCBO"] | 7615.0000 | 7625.0000 | 1 | 1 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:38:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08d-4af0-7103-afc8-97b0daccdeb5 | SPX | 2026-09-14 11:33 | call_butterfly_spread | 3 | 1 | 10 | 57150.00 | short | bid | 7613.2600 | 0.8000 | ["7595","7600","7605"] | ["0.1329","0.1304","0.1287"] | ["7595.30","7604.70"] | ["XCBO"] | 7595.0000 | 7605.0000 | 1 | 1 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:33:38Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09173-5758-78c2-b4e7-80e7eef5305b | SPX | 2026-09-11 13:10 | call_butterfly_spread | 3 | 2 | 32 | 122430.00 | short | bid | 7671.6800 | 0.9938 | ["7670","7675","7680"] | ["0.0721","0.0693","0.0705"] | ["7671.32","7678.68"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:11:14Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09146-f410-7ab0-affe-611f9f1d7d2e | SPX | 2026-09-11 12:22 | call_butterfly_spread | 3 | 4 | 42 | 147630.00 | short | bid | 7666.4500 | 0.5000 | ["7670","7675","7680"] | ["0.0748","0.0735","0.0726"] | ["7670.30","7679.70"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:22:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09146-e858-7bc0-bcfc-4224d76920ef | SPX | 2026-09-11 12:22 | call_butterfly_spread | 3 | 2 | 36 | 127980.00 | short | bid | 7666.8600 | 0.5000 | ["7670","7675","7680"] | ["0.0748","0.0736","0.0728"] | ["7670.30","7679.70"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:22:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09135-f868-7f63-95ec-c07970b0d899 | SPX | 2026-09-11 12:03 | call_butterfly_spread | 3 | 1 | 16 | 66800.00 | short | bid | 7673.5800 | 0.4375 | ["7670","7675","7680"] | ["0.0744","0.0730","0.0721"] | ["7670.30","7679.70"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:04:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ec-a2f8-72e1-a07d-e8be78f1bec0 | SPX | 2026-09-11 10:43 | call_butterfly_spread | 3 | 2 | 20 | 59100.00 | short | bid | 7654.3400 | 0.5000 | ["7670","7675","7680"] | ["0.0830","0.0817","0.0808"] | ["7670.30","7679.70"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:43:41Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e0-9120-79f1-9453-cbe615030268 | SPX | 2026-09-11 10:30 | call_butterfly_spread | 3 | 2 | 22 | 89650.00 | short | bid | 7668.7800 | 0.5091 | ["7670","7675","7680"] | ["0.0810","0.0798","0.0789"] | ["7670.30","7679.70"] | ["XCBO"] | 7670.0000 | 7680.0000 | 3 | 3 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:30:33Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc8-d278-7fe0-8221-00ca55f951c3 | ORCL | 2026-09-10 15:26 | call_butterfly_spread | 3 | 1 | 200 | 57500.00 | short | bid | 154.7600 | 0.1100 | ["185","200","210"] | ["1.2087","1.2450","1.2733"] | ["185.87"] | ["XISX"] | 185.0000 | 210.0000 | 8 | 8 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:26:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cba-6328-7c33-89c6-06f89cdab098 | SPX | 2026-09-10 15:10 | call_butterfly_spread | 3 | 1 | 14 | 58730.00 | short | bid | 7592.4000 | 0.3000 | ["7645","7650","7655"] | ["0.1206","0.1193","0.1185"] | ["7645.30","7654.70"] | ["XCBO"] | 7645.0000 | 7655.0000 | 5 | 5 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:10:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c48-2128-7ab2-9ada-cc6111474def | SPX | 2026-09-10 13:05 | call_butterfly_spread | 3 | 1 | 18 | 125910.00 | short | bid | 7605.4600 | 0.5000 | ["7595","7600","7605"] | ["0.2020","0.1995","0.1982"] | ["7595.30","7604.70"] | ["XCBO"] | 7595.0000 | 7605.0000 | 1 | 1 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:06:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c2f-1700-7913-b300-498330fa0645 | SPX | 2026-09-10 12:38 | call_butterfly_spread | 3 | 2 | 28 | 165060.00 | short | bid | 7593.1300 | 0.5071 | ["7595","7600","7605"] | ["0.2064","0.2039","0.2025"] | ["7595.30","7604.70"] | ["XCBO"] | 7595.0000 | 7605.0000 | 1 | 1 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:38:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c23-95b0-74c2-a6c6-8fef1d245784 | SPX | 2026-09-10 12:25 | call_butterfly_spread | 3 | 2 | 13 | 75870.00 | short | bid | 7592.8000 | 0.6714 | ["7595","7600","7605"] | ["0.2062","0.2037","0.2024"] | ["7604.36"] | ["XCBO"] | 7595.0000 | 7605.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:26:23Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c07-cc69-71d2-87a7-f09b0c9d89ce | SPX | 2026-09-10 11:55 | call_butterfly_spread | 3 | 1 | 4 | 25640.00 | short | bid | 7598.4800 | 0.5000 | ["7595","7600","7605"] | ["0.2063","0.2040","0.2021"] | ["7595.20","7604.80"] | ["XCBO"] | 7595.0000 | 7605.0000 | 1 | 1 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:55:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb4-f178-7783-b791-e2eb1224ce19 | SPX | 2026-09-10 10:24 | call_butterfly_spread | 3 | 1 | 16 | 30560.00 | short | bid | 7612.4100 | 2.7000 | ["7615","7620","7625"] | ["0.1664","0.1663","0.1704"] | ["7615.60","7624.40"] | ["XCBO"] | 7615.0000 | 7625.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:24:57Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086dc-f010-7ab2-8854-504a53c952dc | SPX | 2026-09-09 11:50 | call_butterfly_spread | 3 | 2 | 8 | 35800.00 | short | bid | 7639.2300 | 0.5000 | ["7635","7640","7645"] | ["0.1417","0.1397","0.1385"] | ["7635.30","7644.70"] | ["XCBO"] | 7635.0000 | 7645.0000 | 1 | 1 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:50:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d2-2a40-7771-9403-d30ec389a402 | SPX | 2026-09-09 11:38 | call_butterfly_spread | 3 | 1 | 8 | 30840.00 | short | bid | 7633.1600 | 0.5000 | ["7635","7640","7645"] | ["0.1406","0.1385","0.1372"] | ["7635.30","7644.70"] | ["XCBO"] | 7635.0000 | 7645.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:38:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ce-6568-7541-9be3-467f6aa6f3d4 | SPX | 2026-09-09 11:34 | call_butterfly_spread | 3 | 1 | 8 | 31920.00 | short | bid | 7634.8300 | 0.5000 | ["7635","7640","7645"] | ["0.1398","0.1381","0.1364"] | ["7635.20","7644.80"] | ["XCBO"] | 7635.0000 | 7645.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:34:35Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08661-1120-7eb1-842e-081c6ac8bc9e | SPCX | 2026-09-09 09:35 | call_butterfly_spread | 3 | 1 | 86 | 46483.00 | short | bid | 151.8300 | 0.1300 | ["150","165","170"] | ["0.5886","0.6072","0.6205"] | ["154.33"] | ["XISX"] | 150.0000 | 170.0000 | 9 | 9 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:35:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |