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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c444-2237-7943-9888-ff87d4a2f49c | NDX | 2026-09-21 09:59 | risk_reversal | 2 | 1 | 2 | 33300.00 | long | ask | 0.0000 | 8.5000 | ["29400","30100"] | ["0.2111","0.1494"] | ["30238.30"] | ["XISX"] | 29400.0000 | 30100.0000 | 2 | 2 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:59:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b581-5220-7910-b955-e8c01d285715 | NDX | 2026-09-18 13:12 | call_vertical_spread | 2 | 1 | 6 | 107160.00 | long | ask | 0.0000 | 17.2000 | ["29350","29360"] | ["0.1496","0.1461"] | ["29359"] | ["XISX"] | 29350.0000 | 29360.0000 | 0 | 0 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:12:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa8d-decb-7002-b30c-7b5c65f02ee8 | NDX | 2026-09-16 10:10 | call_vertical_spread | 2 | 1 | 20 | 59400.00 | long | ask | 0.0000 | 1.9000 | ["29430","29440"] | ["0.3175","0.3180"] | ["29431.30"] | ["XISX"] | 29430.0000 | 29440.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:10:36Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a091-4e48-7750-ad0b-dadccdf5d2b6 | NDX | 2026-09-14 11:37 | call_vertical_spread | 2 | 2 | 22 | 37180.00 | long | ask | 0.0000 | 4.8500 | ["29250","29450"] | ["0.1817","0.2257"] | ["29265.90"] | ["XISX","XPHO"] | 29250.0000 | 29450.0000 | 0 | 0 | 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 |
| 01a0a031-c929-74f0-b1ee-b368fa3aa5ad | NDX | 2026-09-14 09:53 | synthetic | 2 | 2 | 2 | 100380.00 | long | ask | 0.0000 | 19.8000 | ["29000"] | ["0.2088"] | ["29014.90"] | ["XISX","XPHO"] | 29000.0000 | 29000.0000 | 4 | 4 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:53:42Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09208-e869-7193-9d7d-c6c0728fd5aa | NDX | 2026-09-11 15:54 | synthetic | 2 | 2 | 2 | 102000.00 | long | ask | 0.0000 | 8.2000 | ["29400"] | ["0.1622"] | ["29410.00"] | ["XISX","XPHO"] | 29400.0000 | 29400.0000 | 7 | 7 | false | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:54:30Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e1-b230-7721-b35e-2ce8841ec959 | NDX | 2026-09-11 10:31 | call_vertical_spread | 2 | 1 | 7 | 27090.00 | long | ask | 0.0000 | 2.9000 | ["29500","29510"] | [null,null] | ["29502.50"] | ["XISX"] | 29500.0000 | 29510.0000 | 0 | 0 | false | false | false | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:31:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a086bd-d721-7b90-bc79-ade021fce9af | NDX | 2026-09-09 11:16 | put_vertical_spread | 2 | 1 | 4 | 151840.00 | long | ask | 0.0000 | 6.5000 | ["29370","29380"] | ["0.2216","0.2211"] | ["29375.60"] | ["XISX"] | 29370.0000 | 29380.0000 | 2 | 2 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:16:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |