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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60e-4427-7420-88fc-0f5b9061c2aa | IWM | 2026-09-18 15:46 | synthetic | 2 | 2 | 478 | 55926.00 | short | ask | 283.8250 | 0.0800 | ["285"] | ["0.4754"] | ["283.85"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:28Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5cf-81c0-71b3-92a7-55073b061d68 | IWM | 2026-09-18 14:37 | synthetic | 2 | 2 | 478 | 76002.00 | short | ask | 283.4550 | 0.1200 | ["285"] | ["0.2735"] | ["283.45"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:38:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55b-bd07-7681-9502-92adf22bd555 | IWM | 2026-09-18 12:31 | straddle | 2 | 1 | 350 | 74900.00 | short | bid | 282.8100 | 0.1200 | ["285"] | ["0.2577"] | ["282.86","287.14"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:31:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b555-3910-7ac3-b163-035e05010eb5 | IWM | 2026-09-18 12:24 | synthetic | 2 | 1 | 250 | 61000.00 | short | ask | 282.5900 | 0.1200 | ["285"] | ["0.2281"] | ["282.60"] | ["AMXO"] | 285.0000 | 285.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:24:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abad-6443-70e1-8182-b32bb78cfc17 | IWM | 2026-09-16 15:24 | put_vertical_spread | 2 | 1 | 50 | 93150.00 | long | ask | 281.2450 | 0.3700 | ["285","290"] | ["0.1921","0.1909"] | ["286.83"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:24:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-7c8b-7053-a56f-a00c85dbc7d3 | IWM | 2026-09-16 15:17 | put_vertical_spread | 2 | 1 | 49 | 84966.00 | long | ask | 282.1600 | 0.3500 | ["285","290"] | ["0.1900","0.1873"] | ["286.98"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:56Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba4-53f3-7c43-9f5e-55ca96909dc0 | IWM | 2026-09-16 15:14 | put_vertical_spread | 2 | 1 | 49 | 83741.00 | long | ask | 282.2400 | 0.2000 | ["285","290"] | ["0.1889","0.1833"] | ["287.07"] | ["SPHR"] | 285.0000 | 290.0000 | 30 | 30 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:14:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a629-cc3e-7632-b7de-03bb011a3a27 | IWM | 2026-09-15 13:42 | put_vertical_spread | 2 | 2 | 385 | 72380.00 | unknown | — | 285.1200 | 0.0600 | ["278","282"] | ["0.3369","0.3114"] | [] | ["ARCO"] | 278.0000 | 282.0000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:43:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58b-4a1e-7ec1-a1aa-c4f334c0192e | IWM | 2026-09-15 10:49 | put_vertical_spread | 2 | 1 | 200 | 84200.00 | long | ask | 284.5100 | 0.0200 | ["280","285"] | ["0.2958","0.2667"] | ["283.31"] | ["SPHR"] | 280.0000 | 285.0000 | 3 | 3 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:49:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a183-3be0-7473-99f3-2a7f6e70a466 | IWM | 2026-09-14 16:02 | other | 6 | 1 | 10 | 74240.00 | unknown | — | 287.7900 | 15.6900 | ["263","264","265","273","274"] | ["0.3708","0.3544","0.3420","0.3725","0.3043"] | [] | ["XPHO"] | 263.0000 | 274.0000 | 7 | 9 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T20:03:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a148-9058-7ba2-a89c-da637a911ed9 | IWM | 2026-09-14 14:58 | other | 6 | 1 | 5 | 87950.00 | unknown | — | 288.7200 | 7.5000 | ["225","261","263","264","271","272"] | ["2.1551","0.6854","0.6360","0.6018","0.6245","0.6043"] | [] | ["XPHO"] | 225.0000 | 272.0000 | 1 | 7 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:58:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091d2-7ad0-7e21-82eb-23960997a687 | IWM | 2026-09-11 14:54 | other | 2 | 2 | 300 | 68800.00 | unknown | — | 289.3300 | 0.0700 | ["272","289"] | ["0.2879","0.2058"] | [] | ["AMXO"] | 272.0000 | 289.0000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:55:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e8-3240-7d40-9780-b551c1fc289c | IWM | 2026-09-11 10:38 | put_diagonal_spread | 2 | 1 | 100 | 50200.00 | short | bid | 288.8101 | 0.2800 | ["290","291"] | ["0.1824","0.2173"] | [] | ["SPHR"] | 290.0000 | 291.0000 | 0 | 4 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:38:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c77-5b00-79c2-b47d-854db5875db6 | IWM | 2026-09-10 13:57 | put_calendar | 2 | 1 | 75 | 77325.00 | short | bid | 287.6950 | 0.2700 | ["292"] | ["0.2629"] | [] | ["SPHR"] | 292.0000 | 292.0000 | 1 | 5 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:57:17Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06d91-1fdd-7243-8319-2e404b7e5d53 | IWM | 2026-09-04 13:57 | put_ladder | 3 | 2 | 225 | 66600.00 | short | ask | 295.1700 | 0.0500 | ["288","291","294"] | ["0.1627","0.1516","0.1412"] | ["291.90"] | ["AMXO"] | 288.0000 | 294.0000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:57:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d8d-3bc5-7033-8674-f25820d0c587 | IWM | 2026-09-04 13:52 | call_vertical_spread | 2 | 2 | 900 | 90000.00 | long | ask | 295.1200 | 0.0200 | ["296","297"] | ["0.0804","0.0790"] | ["296.32"] | ["AMXO"] | 296.0000 | 297.0000 | 4 | 4 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:53:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |