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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b627-f647-77c0-b7d4-5bf073b61d66 | SPX | 2026-09-18 16:14 | iron_condor | 4 | 2 | 157 | 392186.00 | unknown | ask | 7650.5000 | 0.9000 | ["7625","7630","7695","7700"] | ["0.0676","0.0655","0.0664","0.0658"] | ["7615.01","7709.99"] | ["XCBO"] | 7625.0000 | 7700.0000 | 3 | 3 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-c50f-7532-9127-97f3563e6458 | SPX | 2026-09-18 15:46 | iron_condor | 4 | 2 | 200 | 1040600.00 | unknown | ask | 7644.2100 | 0.7000 | ["7555","7600","7740","7785"] | ["0.1198","0.1101","0.0853","0.0818"] | ["7568.03"] | ["XCBO"] | 7555.0000 | 7785.0000 | 7 | 7 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b2-1680-7c83-b19c-1f0023c7055d | SPX | 2026-09-18 14:05 | iron_condor | 4 | 1 | 271 | 41118830.00 | unknown | ask | 7628.8200 | 4.2000 | ["7000","8000"] | ["0.1922","0.1316"] | ["6900.60"] | ["XCBO"] | 7000.0000 | 8000.0000 | 154 | 154 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:06:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ad-ad97-7b42-b0b4-e28a3af4b338 | SPX | 2026-09-18 14:00 | iron_condor | 4 | 2 | 1000 | 5991000.00 | long | ask | 7627.5200 | 0.8000 | ["7615","7620","7635","7640"] | ["0.0775","0.0767","0.0649","0.0643"] | ["7615.85","7639.15"] | ["XCBO"] | 7615.0000 | 7640.0000 | 3 | 3 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:00:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b58a-52cf-71f3-9d34-85f6533f289b | SPX | 2026-09-18 13:22 | iron_condor | 4 | 1 | 599 | 1269281.00 | unknown | ask | 7624.0900 | 0.7000 | ["7410","7415","7750","7755"] | ["0.1555","0.1545","0.0866","0.0865"] | ["7406.08"] | ["XCBO"] | 7410.0000 | 7755.0000 | 7 | 7 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:22:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b574-ea58-7641-8eae-96a4245f1f14 | SPX | 2026-09-18 12:58 | iron_condor | 4 | 2 | 150 | 39534900.00 | unknown | ask | 7623.8300 | 7.3000 | ["6000","7000"] | ["0.2727","0.1944"] | ["7702.50"] | ["XCBO"] | 6000.0000 | 7000.0000 | 119 | 119 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b519-4950-7f83-8f5e-20463aef9d32 | SPX | 2026-09-18 11:18 | iron_condor | 4 | 1 | 146 | 18543168.00 | unknown | ask | 7625.9500 | 4.3000 | ["7000","8000"] | ["0.1936","0.1242"] | ["7756.07"] | ["XCBO"] | 7000.0000 | 8000.0000 | 91 | 91 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:19:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ec-0b47-7661-b5a6-02693b2cb965 | SPX | 2026-09-18 10:29 | iron_condor | 4 | 2 | 50 | 8000250.00 | unknown | ask | 7624.1400 | 4.3000 | ["6500","7500"] | ["0.2451","0.1490"] | ["7665.10"] | ["XCBO"] | 6500.0000 | 7500.0000 | 63 | 63 | false | false | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:29:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a674-98ae-7922-939e-74bb262a69a7 | SPX | 2026-09-15 15:04 | iron_condor | 4 | 1 | 100 | 929100.00 | long | ask | 7585.6100 | 0.8000 | ["7560","7580","7595","7615"] | ["0.2043","0.1984","0.1925","0.1859"] | ["7563.45","7611.55"] | ["XCBO"] | 7560.0000 | 7615.0000 | 1 | 1 | false | true | false | true | true | mfsl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:04:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |