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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4dc-b4cf-7aa3-8c24-1ac29785db87 | IWM | 2026-09-21 12:46 | call_diagonal_spread | 2 | 2 | 252 | 44100.00 | short | ask | 285.8100 | 0.0300 | ["285","286"] | ["0.1617","0.1553"] | [] | ["ARCO"] | 285.0000 | 286.0000 | 0 | 1 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:46:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a4-3bc7-7ab1-964e-b4bd60a24c07 | IWM | 2026-09-21 11:44 | call_diagonal_spread | 2 | 1 | 2 | 27392.00 | short | bid | 285.9000 | 2.3400 | ["220","225"] | ["0.3708","0.2308"] | [] | ["XCBO"] | 220.0000 | 225.0000 | 60 | 242 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:44:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b551-7c07-71d1-9fa5-f29371e707c4 | IWM | 2026-09-18 12:20 | call_diagonal_spread | 2 | 1 | 25 | 152800.00 | unknown | ask | 282.7550 | 0.8200 | ["225","284"] | ["0.2076","0.1801"] | [] | ["XISX"] | 225.0000 | 284.0000 | 0 | 119 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:20:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b518-ad0f-7a60-8b51-3f5769334999 | IWM | 2026-09-18 11:18 | call_diagonal_spread | 2 | 1 | 23 | 101936.00 | unknown | ask | 282.8600 | 0.3100 | ["250","290"] | ["0.2143","0.1578"] | [] | ["MCRY"] | 250.0000 | 290.0000 | 28 | 182 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:18:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aaca-8a0b-78a0-b59c-76117ce7d7f1 | IWM | 2026-09-16 11:16 | call_diagonal_spread | 2 | 1 | 20 | 29940.00 | unknown | — | 286.2800 | 0.1200 | ["280","295"] | ["0.3366","0.1801"] | [] | ["XISX"] | 280.0000 | 295.0000 | 2 | 93 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:16:55Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5bf-1006-7cf1-960f-794797048593 | IWM | 2026-09-15 11:45 | call_diagonal_spread | 2 | 3 | 249 | 110058.00 | long | ask | 284.8200 | 0.0500 | ["287","291"] | ["0.1912","0.2321"] | [] | ["ARCO","C2OX"] | 287.0000 | 291.0000 | 3 | 17 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:45:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5bf-1006-7cf1-960f-792e4b51d02b | IWM | 2026-09-15 11:45 | call_diagonal_spread | 2 | 2 | 64 | 28288.00 | long | ask | 284.8200 | 0.0500 | ["287","291"] | ["0.1912","0.2321"] | [] | ["BATO","EMLD"] | 287.0000 | 291.0000 | 3 | 17 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:45:59Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a585-6e1e-7061-ba3e-b1dfdc6aa09c | IWM | 2026-09-15 10:42 | call_diagonal_spread | 2 | 1 | 22 | 60368.00 | unknown | — | 284.6500 | 0.1700 | ["280","290"] | ["0.2064","0.1875"] | [] | ["ARCO"] | 280.0000 | 290.0000 | 66 | 157 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:43:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a585-6e1e-7061-ba3e-b1b59a0636d4 | IWM | 2026-09-15 10:42 | call_diagonal_spread | 2 | 1 | 19 | 52136.00 | unknown | — | 284.6500 | 0.1700 | ["280","290"] | ["0.2064","0.1875"] | [] | ["XISX"] | 280.0000 | 290.0000 | 66 | 157 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:43:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091d8-52e8-76f1-8ef3-2ce8b766b232 | IWM | 2026-09-11 15:01 | call_diagonal_spread | 2 | 2 | 36 | 31320.00 | short | bid | 289.2650 | 0.1500 | ["281","290"] | ["0.1486","0.1920"] | [] | ["XISX"] | 281.0000 | 290.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:01:31Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09199-6588-75b2-9036-c5a36079d36d | IWM | 2026-09-11 13:52 | call_diagonal_spread | 2 | 2 | 14 | 52318.00 | short | bid | 289.5000 | 0.6900 | ["280","300"] | ["0.1916","0.1837"] | [] | ["C2OX"] | 280.0000 | 300.0000 | 98 | 292 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:53:04Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c85-4199-7292-b0de-7ed5f2b1f2a0 | IWM | 2026-09-10 14:12 | call_diagonal_spread | 2 | 2 | 166 | 30876.00 | short | bid | 287.3400 | 0.0300 | ["295","305"] | ["0.1861","0.1645"] | [] | ["C2OX"] | 295.0000 | 305.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:12:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c81-3a58-7e12-919a-184934be52e8 | IWM | 2026-09-10 14:07 | call_diagonal_spread | 2 | 2 | 133 | 25802.00 | short | bid | 287.5750 | 0.0400 | ["295","305"] | ["0.1858","0.1647"] | [] | ["EMLD","XISX"] | 295.0000 | 305.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0a-a6e1-78a3-8cc4-c9e4f9f724e5 | IWM | 2026-09-10 11:58 | call_diagonal_spread | 2 | 2 | 106 | 32542.00 | short | bid | 288.3650 | 0.0200 | ["298","300"] | ["0.1682","0.1774"] | [] | ["ARCO"] | 298.0000 | 300.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:58:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0a-a6e1-78a3-8cc4-c9a911ab2b33 | IWM | 2026-09-10 11:58 | call_diagonal_spread | 2 | 2 | 106 | 32542.00 | short | bid | 288.3650 | 0.0200 | ["298","300"] | ["0.1682","0.1774"] | [] | ["ARCO"] | 298.0000 | 300.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:58:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0a-a6e1-78a3-8cc4-c97c2d861bb9 | IWM | 2026-09-10 11:58 | call_diagonal_spread | 2 | 2 | 106 | 32542.00 | short | bid | 288.3650 | 0.0200 | ["298","300"] | ["0.1682","0.1774"] | [] | ["ARCO"] | 298.0000 | 300.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:58:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0a-a6e1-78a3-8cc4-c96fa946306f | IWM | 2026-09-10 11:58 | call_diagonal_spread | 2 | 2 | 106 | 32542.00 | short | bid | 288.3650 | 0.0200 | ["298","300"] | ["0.1682","0.1774"] | [] | ["ARCO"] | 298.0000 | 300.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:58:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c0a-a6e0-7341-bd57-eb69cb8ba519 | IWM | 2026-09-10 11:58 | call_diagonal_spread | 2 | 4 | 105 | 32235.00 | short | bid | 288.3650 | 0.0200 | ["298","300"] | ["0.1682","0.1774"] | [] | ["ARCO","BATO"] | 298.0000 | 300.0000 | 8 | 36 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:58:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb9-3f08-7180-b099-f2458e37eb05 | IWM | 2026-09-10 10:29 | call_diagonal_spread | 2 | 2 | 6 | 30492.00 | short | bid | 289.2800 | 0.9700 | ["265","270"] | ["0.2965","0.2070"] | [] | ["ARCO","XBOX"] | 265.0000 | 270.0000 | 8 | 99 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:29:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08766-1d40-7f93-9e7f-cd70642837b0 | IWM | 2026-09-09 14:20 | call_diagonal_spread | 2 | 1 | 9 | 46188.00 | long | ask | 290.9950 | 0.4000 | ["245","292"] | ["0.2117","0.2261"] | [] | ["XISX"] | 245.0000 | 292.0000 | 2 | 113 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:20:54Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0872d-b7c0-7652-8f73-7c41d882378e | IWM | 2026-09-09 13:18 | call_diagonal_spread | 2 | 1 | 6 | 40632.00 | short | ask | 291.0600 | 3.4600 | ["257","258"] | ["0.8772","0.3577"] | [] | ["XCBO"] | 257.0000 | 258.0000 | 2 | 30 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:19:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |