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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c58d-24c6-7a90-9a05-11a71f392bba | SPX | 2026-09-21 15:59 | call_ladder | 5 | 3 | 18 | 78920.00 | unknown | ask | 7766.5900 | 0.9000 | ["7790","7795","7800","7805","7810"] | ["0.1078","0.1074","0.1073","0.1069","0.1067"] | ["7790.40","7809.60"] | ["XCBO"] | 7790.0000 | 7810.0000 | 4 | 4 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:59:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c53f-cbff-7fe0-9845-1d0c1bbb3f82 | SPY | 2026-09-21 14:34 | call_ladder | 3 | 1 | 22 | 26564.00 | unknown | bid | 773.7200 | 0.0700 | ["761","773","774"] | ["0.6331","0.1438","0.1390"] | ["774.08"] | ["XISX"] | 761.0000 | 774.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:35:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b8-c1af-77c3-a12c-a1a4b548fa3d | SPX | 2026-09-21 12:07 | call_ladder | 3 | 2 | 26 | 36275.00 | unknown | ask | 7741.5500 | 0.3500 | ["7735","7750","7755"] | ["0.1202","0.1125","0.1153"] | ["7743.69","7893.88"] | ["XCBO"] | 7735.0000 | 7755.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:07:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c49c-aa47-7711-ab96-b7be7185df7b | SPY | 2026-09-21 11:36 | call_ladder | 3 | 1 | 55 | 29342.00 | unknown | ask | 769.9975 | 0.0300 | ["767","768","769"] | ["0.1318","0.1215","0.1104"] | ["767.89","775.32"] | ["XISX"] | 767.0000 | 769.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:36:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c473-11d6-7051-ac40-a6499a82146f | SPX | 2026-09-21 10:51 | call_ladder | 3 | 1 | 13 | 31850.00 | short | bid | 7719.3300 | 0.5462 | ["7775","7800","7825"] | ["0.1007","0.1004","0.1003"] | ["7776.30","7848.70"] | ["XCBO"] | 7775.0000 | 7825.0000 | 4 | 4 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:51:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c473-11d6-7051-ac40-a62990be9a69 | SPX | 2026-09-21 10:51 | call_ladder | 3 | 2 | 72 | 176400.00 | short | bid | 7719.3300 | 0.5097 | ["7775","7800","7825"] | ["0.1007","0.1004","0.1003"] | ["7776.30","7848.70"] | ["XCBO"] | 7775.0000 | 7825.0000 | 4 | 4 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:51:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46c-766e-73d3-b9ea-7288ad9bb15e | SPX | 2026-09-21 10:43 | call_ladder | 3 | 2 | 55 | 63420.00 | unknown | ask | 7719.9400 | 0.3000 | ["7720","7725","7730"] | ["0.0945","0.0950","0.0966"] | ["7722.87"] | ["XCBO"] | 7720.0000 | 7730.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:44:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b076-236b-7633-a656-01950681d1a3 | SPX | 2026-09-17 13:42 | call_ladder | 3 | 1 | 37 | 59015.00 | long | ask | 7635.5200 | 0.7000 | ["7650","7685","7700"] | ["0.1122","0.1058","0.1086"] | ["7657.85","7727.15"] | ["XCBO"] | 7650.0000 | 7700.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:42:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b076-236b-7633-a656-0177eb6c3086 | SPX | 2026-09-17 13:42 | call_ladder | 3 | 3 | 35 | 55825.00 | long | ask | 7635.5200 | 0.7800 | ["7650","7685","7700"] | ["0.1122","0.1058","0.1086"] | ["7657.85","7727.15"] | ["XCBO"] | 7650.0000 | 7700.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:42:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06d-45e3-7e03-84f2-9f9e8155baa8 | QQQ | 2026-09-17 13:32 | call_ladder | 3 | 1 | 39 | 36556.00 | unknown | — | 716.2900 | 0.0400 | ["735","740","760"] | ["0.1507","0.1482","0.1438"] | [] | ["ARCO"] | 735.0000 | 760.0000 | 29 | 29 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:32:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b023-38db-7222-b721-f43fe4c19289 | SPX | 2026-09-17 12:11 | call_ladder | 3 | 1 | 33 | 31655.00 | unknown | — | 7634.6900 | 0.2000 | ["7635","7650","7665"] | ["0.1163","0.1140","0.1216"] | [] | ["XCBO"] | 7635.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b023-38db-7222-b721-f42e6ab29fc7 | SPX | 2026-09-17 12:11 | call_ladder | 3 | 1 | 33 | 31655.00 | unknown | — | 7634.6900 | 0.2500 | ["7635","7650","7665"] | ["0.1163","0.1140","0.1216"] | [] | ["XCBO"] | 7635.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b023-34f3-7113-a6c4-b5348a21ed03 | SPX | 2026-09-17 12:11 | call_ladder | 3 | 2 | 66 | 62980.00 | unknown | — | 7634.6800 | 0.2000 | ["7635","7650","7665"] | ["0.1164","0.1129","0.1216"] | [] | ["XCBO"] | 7635.0000 | 7665.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0afea-db2a-7df1-83e9-9eb3c42f9539 | AMD | 2026-09-17 11:09 | call_ladder | 3 | 1 | 20 | 113300.00 | unknown | — | 545.1200 | 1.8000 | ["700","780","1120"] | ["0.5681","0.5694","0.5834"] | [] | ["C2OX"] | 700.0000 | 1120.0000 | 183 | 183 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:10:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afea-cf73-7720-9a50-5dd53c1ec3b8 | AMD | 2026-09-17 11:09 | call_ladder | 3 | 1 | 20 | 113300.00 | unknown | — | 545.3499 | 1.6750 | ["700","780","1120"] | ["0.5675","0.5689","0.5831"] | [] | ["C2OX"] | 700.0000 | 1120.0000 | 183 | 183 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:10:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab3e-b06b-7611-ab54-bdbb516bf37b | SPX | 2026-09-16 13:23 | call_ladder | 3 | 2 | 15 | 37200.00 | unknown | — | 7607.4000 | 0.3644 | ["7625","7630","7635"] | ["0.4306","0.4265","0.4229"] | [] | ["XCBO"] | 7625.0000 | 7635.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:24:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5fc-20d6-7752-8a60-dd05629d7bdf | SPY | 2026-09-15 12:52 | call_ladder | 3 | 1 | 82 | 31625.00 | unknown | — | 757.7250 | 0.0300 | ["760","761","762"] | ["0.1952","0.1927","0.1899"] | [] | ["XISX"] | 760.0000 | 762.0000 | 1 | 1 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:52:41Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a597-198e-76e0-bdae-21945c74dc4a | SPX | 2026-09-15 11:02 | call_ladder | 5 | 1 | 28 | 58350.00 | unknown | — | 7579.0000 | 0.8462 | ["7565","7575","7580","7585","7595"] | ["0.1561","0.1513","0.1474","0.1475","0.1469"] | [] | ["XCBO"] | 7565.0000 | 7595.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:02:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a568-fcde-76c0-8e2d-bf6b6968e949 | SPX | 2026-09-15 10:11 | call_ladder | 7 | 1 | 66 | 48635.00 | unknown | — | 7592.1200 | 0.6000 | ["7600","7605","7610","7615","7620","7625","7710"] | ["0.1439","0.1424","0.1418","0.1412","0.1423","0.1435","0.2407"] | [] | ["XCBO"] | 7600.0000 | 7710.0000 | 0 | 0 | false | true | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:11:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09121-5b10-7cb0-abfa-2dfafdc652ac | SPX | 2026-09-11 11:41 | call_ladder | 3 | 2 | 21 | 44730.00 | long | ask | 7673.6300 | 0.2857 | ["7670","7675","7695"] | ["0.1368","0.1310","0.1228"] | ["7671.30","7698.70"] | ["XCBO"] | 7670.0000 | 7695.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:41:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a06dfe-221d-7ca0-824a-b400aac36452 | NVDA | 2026-09-04 15:56 | call_ladder | 3 | 1 | 39 | 86190.00 | short | bid | 230.5550 | 0.3200 | ["215","235","245"] | ["0.3250","0.3176","0.3182"] | ["226.50","253.50"] | ["AMXO"] | 215.0000 | 245.0000 | 14 | 14 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-221d-7ca0-824a-b3c6ce56038f | NVDA | 2026-09-04 15:56 | call_ladder | 3 | 3 | 19 | 41990.00 | short | bid | 230.5550 | 0.3200 | ["215","235","245"] | ["0.3250","0.3176","0.3182"] | ["226.50","253.50"] | ["AMXO","XBOX","XPHO"] | 215.0000 | 245.0000 | 14 | 14 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |