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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5d3-8ce8-73d2-89a6-aecec467e3ab | XLF | 2026-09-18 14:42 | other | 4 | 4 | 12500 | 14887500.00 | unknown | ask | 55.8850 | 0.3300 | ["50"] | ["2.4658"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 0 | 28 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:42:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e3-54cf-7383-8fcc-289ce85df0ad | XLF | 2026-09-18 10:19 | other | 3 | 2 | 12400 | 541334.00 | unknown | bid | 55.7800 | 0.0722 | ["54","57","61"] | ["0.1832","0.1317","0.1544"] | ["53.64"] | ["AMXO"] | 54.0000 | 61.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:20:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0abab-7fe3-74c3-9207-c25672df42fc | XLF | 2026-09-16 15:22 | other | 4 | 5 | 7500 | 8523750.00 | unknown | — | 55.4850 | 0.4400 | ["50"] | ["0.4908"] | [] | ["AMXO"] | 50.0000 | 50.0000 | 2 | 30 | false | false | true | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:22:22Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a645-0116-73d0-b3b6-69db1f6d5256 | XLF | 2026-09-15 14:12 | other | 4 | 1 | 820 | 195000.00 | unknown | — | 56.6600 | 0.2200 | ["57","58"] | ["0.2072","0.2330"] | [] | ["XBOX"] | 57.0000 | 58.0000 | 3 | 3 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:12:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091b8-e7f0-70b1-8481-3afa16f2c838 | XLF | 2026-09-11 14:26 | other | 3 | 3 | 1125 | 157750.00 | unknown | — | 57.2700 | 0.1400 | ["56","58"] | ["0.1732","0.1692"] | [] | ["AMXO"] | 56.0000 | 58.0000 | 7 | 35 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:27:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0878f-8ea1-7d32-a34b-4d03706d86ba | XLF | 2026-09-09 15:05 | other | 2 | 2 | 1200 | 81000.00 | unknown | — | 57.1450 | 0.0700 | ["48","53"] | ["0.2548","0.1970"] | [] | ["AMXO"] | 48.0000 | 53.0000 | 100 | 128 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:05:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08691-8f30-7ba0-95d9-fd4775f25ec9 | XLF | 2026-09-09 10:27 | other | 2 | 1 | 58700 | 1096600.00 | unknown | — | 57.2250 | 0.1100 | ["60.5","62"] | ["0.1551","0.1550"] | [] | ["SPHR"] | 60.5000 | 62.0000 | 23 | 100 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:28:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |