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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b619-c577-7d73-93f1-214b3fc18d70 | NDX | 2026-09-18 15:58 | call_ratio_spread | 2 | 1 | 3 | 92505.00 | unknown | — | 0.0000 | 29.9000 | ["29300","30225"] | ["0.1654","0.1354"] | [] | ["XPHO"] | 29300.0000 | 30225.0000 | 14 | 14 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e4-5a87-7363-b2ea-f19a69b87c1b | NDX | 2026-09-18 10:20 | call_ratio_spread | 2 | 2 | 4 | 183184.00 | unknown | ask | 0.0000 | 23.9000 | ["29500","30400"] | ["0.1707","0.1519"] | ["30405.31"] | ["XISX","XPHO"] | 29500.0000 | 30400.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:21:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e4-2f8f-7b82-ba11-e062fec4a961 | NDX | 2026-09-18 10:20 | call_ratio_spread | 2 | 1 | 2 | 91666.00 | unknown | ask | 0.0000 | 23.9000 | ["29500","30400"] | ["0.1707","0.1519"] | ["30405.55"] | ["XPHO"] | 29500.0000 | 30400.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:20:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afcd-cdab-7682-a475-6dbdbf567d28 | NDX | 2026-09-17 10:38 | call_ratio_spread | 2 | 1 | 2 | 91705.00 | unknown | — | 0.0000 | 55.5000 | ["29500","30400"] | ["0.1687","0.1514"] | [] | ["XPHO"] | 29500.0000 | 30400.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:38:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcd-8b43-7131-a24d-a24ff6a022bf | NDX | 2026-09-17 10:37 | call_ratio_spread | 2 | 1 | 2 | 91727.00 | unknown | — | 0.0000 | 58.8000 | ["29500","30400"] | ["0.1687","0.1514"] | [] | ["XISX"] | 29500.0000 | 30400.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:38:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afcd-0673-7f92-a68f-622fec8f9c36 | NDX | 2026-09-17 10:37 | call_ratio_spread | 2 | 1 | 2 | 89577.00 | unknown | — | 0.0000 | 58.3000 | ["29500","30350"] | ["0.1673","0.1503"] | [] | ["XISX"] | 29500.0000 | 30350.0000 | 27 | 27 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:37:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af98-a833-7853-b059-50d47b846392 | NDX | 2026-09-17 09:40 | call_ratio_spread | 2 | 1 | 4 | 65780.00 | unknown | — | 0.0000 | 13.3000 | ["29175","29300"] | ["0.2464","0.2277"] | [] | ["XPHO"] | 29175.0000 | 29300.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:40:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba5-711b-77d3-97df-68e58a1fb9ab | NDX | 2026-09-16 15:15 | call_ratio_spread | 2 | 1 | 2 | 65900.00 | unknown | — | 0.0000 | 72.3000 | ["28575","29750"] | ["0.2182","0.1654"] | [] | ["XPHO"] | 28575.0000 | 29750.0000 | 9 | 9 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3e-f6bb-76c0-9e35-d4ebc16f4f2d | NDX | 2026-09-16 13:23 | call_ratio_spread | 2 | 1 | 24 | 1449432.00 | unknown | — | 0.0000 | 33.8000 | ["28500","31000"] | ["0.2019","0.1498"] | [] | ["XPHO"] | 28500.0000 | 31000.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | 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 |
| 01a0a6aa-5a66-7f10-a127-0608f16c7055 | NDX | 2026-09-15 16:02 | call_ratio_spread | 2 | 1 | 2 | 56845.00 | unknown | — | 0.0000 | 55.8000 | ["33000","39000"] | ["0.1886","0.1949"] | [] | ["XPHO"] | 33000.0000 | 39000.0000 | 185 | 185 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T20:05:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a641-1916-7fd1-a573-f24680a72a4e | NDX | 2026-09-15 14:07 | call_ratio_spread | 2 | 1 | 20 | 43850.00 | unknown | — | 0.0000 | 2.8000 | ["28980","29030"] | ["0.1299","0.1357"] | [] | ["XISX"] | 28980.0000 | 29030.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:08:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a619-f58e-7841-9286-794a6de96e1e | NDX | 2026-09-15 13:25 | call_ratio_spread | 2 | 1 | 2 | 33490.00 | unknown | — | 0.0000 | 23.2000 | ["28800","28920"] | ["0.1872","0.1504"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:25:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a616-4826-7862-803a-8b9fc06a3943 | NDX | 2026-09-15 13:21 | call_ratio_spread | 2 | 1 | 2 | 37089.00 | unknown | — | 0.0000 | 26.2000 | ["28800","28920"] | ["0.1915","0.1498"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a610-a2d6-7c12-bb88-64b98ddeb56c | NDX | 2026-09-15 13:15 | call_ratio_spread | 2 | 1 | 2 | 35609.00 | unknown | — | 0.0000 | 26.9000 | ["28800","28920"] | ["0.1887","0.1508"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:15:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a609-effe-7243-9eb5-9f150072339b | NDX | 2026-09-15 13:07 | call_ratio_spread | 2 | 1 | 2 | 38745.00 | unknown | — | 0.0000 | 24.8000 | ["28800","28920"] | ["0.1884","0.1551"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:07:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a606-1f6e-72c0-a31a-9fefefed3880 | NDX | 2026-09-15 13:03 | call_ratio_spread | 2 | 1 | 2 | 37465.00 | unknown | — | 0.0000 | 27.8000 | ["28800","28920"] | ["0.1901","0.1531"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:03:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a603-5c66-74c1-b6d6-c6a9000016d1 | NDX | 2026-09-15 13:00 | call_ratio_spread | 2 | 1 | 2 | 42435.00 | unknown | — | 0.0000 | 26.3000 | ["28800","28920"] | ["0.1881","0.1554"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:01:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fe-10ee-7f42-a369-381c7b35859d | NDX | 2026-09-15 12:54 | call_ratio_spread | 2 | 1 | 2 | 47564.00 | unknown | — | 0.0000 | 30.9000 | ["28800","28920"] | ["0.2032","0.1605"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:54:46Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fc-e80e-7890-b607-149fc8f45d88 | NDX | 2026-09-15 12:53 | call_ratio_spread | 2 | 1 | 2 | 46015.00 | unknown | — | 0.0000 | 32.7000 | ["28800","28920"] | ["0.2032","0.1605"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:54:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5fb-f1f6-7e80-a5cb-d19767b0a124 | NDX | 2026-09-15 12:52 | call_ratio_spread | 2 | 1 | 2 | 42324.00 | unknown | — | 0.0000 | 29.1000 | ["28800","28920"] | ["0.1987","0.1579"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | 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 |
| 01a0a5f5-9126-78f0-8bc1-da4ffeb45bb1 | NDX | 2026-09-15 12:45 | call_ratio_spread | 2 | 1 | 2 | 42326.00 | unknown | — | 0.0000 | 25.1000 | ["28800","28920"] | ["0.1963","0.1625"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:45:42Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f0-1e9e-7d91-9ecd-72b3408c6857 | NDX | 2026-09-15 12:39 | call_ratio_spread | 2 | 1 | 2 | 42828.00 | unknown | — | 0.0000 | 28.1000 | ["28800","28920"] | ["0.1954","0.1655"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:39:48Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ea-61de-7171-8274-51c7948bf9eb | NDX | 2026-09-15 12:33 | call_ratio_spread | 2 | 1 | 2 | 44800.00 | unknown | — | 0.0000 | 29.8000 | ["28800","28920"] | ["0.1971","0.1660"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:34:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e6-2fa6-7db2-ad90-2bc0d4a36bca | NDX | 2026-09-15 12:28 | call_ratio_spread | 2 | 1 | 2 | 47908.00 | unknown | — | 0.0000 | 27.9000 | ["28800","28920"] | ["0.1980","0.1645"] | [] | ["XISX"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:29:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e5-127e-7771-a5f4-9ace302d31e3 | NDX | 2026-09-15 12:27 | call_ratio_spread | 2 | 1 | 2 | 45688.00 | unknown | — | 0.0000 | 30.4000 | ["28800","28920"] | ["0.1913","0.1636"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:28:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5e2-d446-7a42-b65d-1e8ed3185fad | NDX | 2026-09-15 12:24 | call_ratio_spread | 2 | 1 | 2 | 46817.00 | unknown | — | 0.0000 | 26.4000 | ["28800","28920"] | ["0.1982","0.1638"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:25:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5de-b97e-7723-9b36-015adbca2efd | NDX | 2026-09-15 12:20 | call_ratio_spread | 2 | 1 | 2 | 39784.00 | unknown | — | 0.0000 | 27.9000 | ["28800","28920"] | ["0.1888","0.1591"] | [] | ["XPHO"] | 28800.0000 | 28920.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:20:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a7-8896-79e3-bb3f-948b114c82ba | NDX | 2026-09-15 11:20 | call_ratio_spread | 2 | 1 | 30 | 2254250.00 | unknown | — | 0.0000 | 71.2000 | ["28500","28975"] | ["0.2606","0.2263"] | [] | ["XPHO"] | 28500.0000 | 28975.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:20:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59f-9956-7ab2-a599-e58a40b514f2 | NDX | 2026-09-15 11:11 | call_ratio_spread | 2 | 1 | 2 | 96584.00 | unknown | — | 0.0000 | 64.1000 | ["29050","30000"] | ["0.1863","0.1615"] | [] | ["XISX"] | 29050.0000 | 30000.0000 | 28 | 28 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:11:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a59f-6e5d-7d82-9423-c0cbdff61aa5 | NDX | 2026-09-15 11:11 | call_ratio_spread | 2 | 1 | 2 | 96700.00 | unknown | — | 0.0000 | 63.2000 | ["29050","30000"] | ["0.1863","0.1615"] | [] | ["XISX"] | 29050.0000 | 30000.0000 | 28 | 28 | true | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:11:35Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a598-1775-7a81-a859-4b9d7901e681 | NDX | 2026-09-15 11:03 | call_ratio_spread | 2 | 2 | 4 | 190618.00 | unknown | — | 0.0000 | 58.9000 | ["29050","29950"] | ["0.1854","0.1615"] | [] | ["XISX","XPHO"] | 29050.0000 | 29950.0000 | 27 | 27 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:03:50Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a598-1775-7a81-a859-4b8473a9e5c7 | NDX | 2026-09-15 11:03 | call_ratio_spread | 2 | 1 | 2 | 95318.00 | unknown | — | 0.0000 | 58.9000 | ["29050","29950"] | ["0.1854","0.1615"] | [] | ["XISX"] | 29050.0000 | 29950.0000 | 27 | 27 | true | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:03:50Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a597-2546-7fa0-9d85-623cd4659618 | NDX | 2026-09-15 11:02 | call_ratio_spread | 2 | 1 | 3 | 89670.00 | unknown | — | 0.0000 | 65.0000 | ["28400","29975"] | ["0.2243","0.1567"] | [] | ["XPHO"] | 28400.0000 | 29975.0000 | 10 | 10 | false | false | false | true | false | mlet | 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 |