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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b541-dc07-7150-88e6-3e267b87f9be | IWM | 2026-09-18 12:03 | call_diagonal_spread | 2 | 1 | 5 | 41150.00 | unknown | bid | 282.7710 | 0.6800 | ["240","245"] | ["0.2877","0.3789"] | [] | ["MCRY"] | 240.0000 | 245.0000 | 7 | 42 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:03:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a570-6366-7452-828f-a94c50bf0a6a | IWM | 2026-09-15 10:19 | call_diagonal_spread | 2 | 1 | 13 | 53846.00 | unknown | — | 285.5450 | 0.3300 | ["265","270"] | ["0.2822","0.2293"] | [] | ["MCRY"] | 265.0000 | 270.0000 | 15 | 45 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:20:05Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a14c-5530-74e1-838b-2b0520cde507 | IWM | 2026-09-14 15:02 | call_diagonal_spread | 2 | 1 | 10 | 52120.00 | short | ask | 288.7050 | 1.6000 | ["260","275"] | ["0.4849","0.1941"] | [] | ["XCBO"] | 260.0000 | 275.0000 | 4 | 123 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:02:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a08f-46c0-78f0-bcd0-883d50285c43 | IWM | 2026-09-14 11:35 | call_diagonal_spread | 2 | 1 | 7 | 35252.00 | long | bid | 287.9550 | 1.1800 | ["260","275"] | ["0.4950","0.1913"] | [] | ["AMXO"] | 260.0000 | 275.0000 | 4 | 123 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:35:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a080-4ad0-71b3-bc20-63fdd61c04bd | IWM | 2026-09-14 11:19 | call_diagonal_spread | 2 | 1 | 10 | 54340.00 | unknown | — | 287.1200 | 2.7800 | ["261","262"] | ["0.2054","0.2303"] | [] | ["MCRY"] | 261.0000 | 262.0000 | 18 | 46 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:19:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08197-7351-7dc1-8c50-ff08d7678577 | IWM | 2026-09-08 11:16 | call_diagonal_spread | 2 | 1 | 30 | 26340.00 | long | ask | 295.5100 | 0.3000 | ["292.5","293"] | ["0.2014","0.1614"] | [] | ["AMXO"] | 292.5000 | 293.0000 | 3 | 10 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:16:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08182-b6b8-7860-b261-a0c668a26973 | IWM | 2026-09-08 10:53 | call_diagonal_spread | 2 | 1 | 14 | 39088.00 | unknown | — | 295.1700 | 1.0300 | ["290","296"] | ["0.1915","0.1585"] | [] | ["XCBO"] | 290.0000 | 296.0000 | 1 | 282 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:53:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08180-e1f8-7861-a9c6-e96ca165a5db | IWM | 2026-09-08 10:51 | call_diagonal_spread | 2 | 1 | 11 | 30745.00 | unknown | — | 295.1500 | 0.4000 | ["290","296"] | ["0.1921","0.1580"] | [] | ["XCBO"] | 290.0000 | 296.0000 | 1 | 282 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:51:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |