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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5bb-6938-74a3-9229-d965c5d93b8e | ORCL | 2026-09-18 14:15 | iron_butterfly | 4 | 1 | 25 | 72600.00 | short | ask | 146.1400 | 0.6300 | ["145","160","165"] | ["0.4845","0.4922","0.4804"] | ["149.20"] | ["XMIO"] | 145.0000 | 165.0000 | 28 | 28 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:15:53Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a08cc9-4b90-7513-81e6-4efe64ba7deb | ORCL | 2026-09-10 15:26 | iron_butterfly | 4 | 1 | 15 | 60825.00 | unknown | — | 154.4100 | 0.8000 | ["155","165","167.5"] | ["1.1475","1.1821","1.1990"] | [] | ["XCBO"] | 155.0000 | 167.5000 | 8 | 8 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:26:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08741-d818-7111-9773-e6c5be703aae | ORCL | 2026-09-09 13:40 | iron_butterfly | 4 | 1 | 7 | 38199.00 | unknown | — | 163.2650 | 2.0000 | ["144","147","149"] | ["0.7035","0.7052","0.7065"] | [] | ["AMXO"] | 144.0000 | 149.0000 | 30 | 30 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:41:16Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08283-4668-7d41-bb4a-30a47a830564 | ORCL | 2026-09-08 15:33 | iron_butterfly | 4 | 1 | 5 | 25980.00 | unknown | — | 161.8800 | 1.3000 | ["140","144","147"] | ["0.7327","0.7412","0.7490"] | [] | ["XCBO"] | 140.0000 | 147.0000 | 24 | 24 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:34:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |