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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ed-75b7-7db2-b089-e7f43471ecf8 | INTC | 2026-09-18 15:10 | call_diagonal_spread | 2 | 1 | 380 | 66500.00 | short | bid | 106.9400 | 0.1000 | ["110","118"] | ["1.8632","0.6290"] | [] | ["XBOX"] | 110.0000 | 118.0000 | 0 | 14 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:11:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b504-cf1f-78c2-a49e-626af1849bbd | INTC | 2026-09-18 10:56 | call_vertical_spread | 2 | 1 | 50 | 69000.00 | short | bid | 107.4950 | 0.4000 | ["150","185"] | ["0.6674","0.6919"] | ["154"] | ["SPHR"] | 150.0000 | 185.0000 | 182 | 182 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b095-ffab-7fb2-a3ca-97309bda7170 | INTC | 2026-09-17 14:16 | call_vertical_spread | 2 | 1 | 50 | 92750.00 | long | ask | 110.6400 | 0.3000 | ["120","140"] | ["0.6810","0.6938"] | ["125.15"] | ["SPHR"] | 120.0000 | 140.0000 | 92 | 92 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:17:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa5-2b53-71c2-aa51-28987afb3318 | INTC | 2026-09-17 09:53 | call_vertical_spread | 2 | 1 | 100 | 82400.00 | short | bid | 108.3500 | 0.3600 | ["105","130"] | ["0.6363","0.7021"] | ["111.60"] | ["SPHR"] | 105.0000 | 130.0000 | 15 | 15 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:54:03Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aa6c-9743-7653-8273-a01f2dce7459 | INTC | 2026-09-16 09:33 | call_diagonal_spread | 2 | 1 | 109 | 61040.00 | short | bid | 102.4000 | 0.2100 | ["103","115"] | ["0.8670","0.6385"] | [] | ["SPHR"] | 103.0000 | 115.0000 | 2 | 30 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a087b5-3b28-7de0-abc3-7f5d4b270808 | INTC | 2026-09-09 15:46 | call_vertical_spread | 2 | 1 | 404 | 47672.00 | short | bid | 105.8400 | 0.0500 | ["110","115"] | ["0.7622","0.8311"] | ["110.62"] | ["XBOX"] | 110.0000 | 115.0000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:46:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a0-ecc9-7240-8fe9-801c1474370d | INTC | 2026-09-09 10:44 | call_diagonal_spread | 2 | 1 | 90 | 87300.00 | short | ask | 105.9050 | 0.2000 | ["101","102"] | ["1.0947","0.7384"] | [] | ["SPHR"] | 101.0000 | 102.0000 | 0 | 2 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:44:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |