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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4e0-e31e-7e23-898b-7a4fd7c87491 | ITB | 2026-09-21 12:51 | strangle | 2 | 1 | 1200 | 1033200.00 | short | bid | 88.4000 | 0.4000 | ["82.46","90.46"] | ["0.3082","0.3015"] | ["73.85","99.07"] | ["ARCO"] | 82.4600 | 90.4600 | 116 | 116 | true | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:51:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a586-9ae6-7772-a3e3-1607344d3eab | ITB | 2026-09-15 10:44 | put_vertical_spread | 2 | 3 | 679 | 160220.00 | short | bid | 88.5100 | 0.3491 | ["85.46","89.46"] | ["0.4955","0.4259"] | ["88.06"] | ["ARCO","XPHO"] | 85.4600 | 89.4600 | 3 | 3 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:44:21Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090d7-26f8-7773-8ea0-babbd82e8ebe | ITB | 2026-09-11 10:20 | risk_reversal | 2 | 1 | 127 | 226822.00 | long | bid | 88.7700 | 1.7000 | ["85","105"] | ["0.3401","0.2982"] | ["84.30"] | ["XCBO"] | 85.0000 | 105.0000 | 497 | 497 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:20:35Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c80-7708-7090-972c-594566f50f6b | ITB | 2026-09-10 14:07 | put_vertical_spread | 2 | 5 | 1605 | 657874.00 | short | bid | 87.9400 | 0.4000 | ["86","90"] | ["0.3655","0.3627"] | ["87.98"] | ["AMXO","ARCO","XISX","XMIO","XPHO"] | 86.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:07:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd1-e3a1-7b51-8009-04f44a20e8fd | ITB | 2026-09-10 10:56 | put_vertical_spread | 2 | 2 | 289 | 108958.00 | short | bid | 87.9100 | 0.2500 | ["85","90"] | ["0.3758","0.3431"] | ["87.80"] | ["ARCO","XBOX"] | 85.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:56:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd1-dfb9-7fb1-89a5-f9a41e1f8c51 | ITB | 2026-09-10 10:56 | put_vertical_spread | 2 | 2 | 1120 | 414280.00 | short | bid | 87.9100 | 0.4500 | ["85","90"] | ["0.3792","0.3250"] | ["87.90"] | ["EDGO","XBOX"] | 85.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:56:40Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-7381-7723-9681-7a67bf0cc20b | ITB | 2026-09-10 10:16 | put_vertical_spread | 2 | 5 | 667 | 274631.00 | short | bid | 87.9500 | 0.3499 | ["86","90"] | ["0.3735","0.3608"] | ["88.03"] | ["AMXO","ARCO","XMIO","XPHO"] | 86.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-7381-7723-9681-7a3f3f5504b3 | ITB | 2026-09-10 10:16 | put_vertical_spread | 2 | 2 | 274 | 113710.00 | short | bid | 87.9200 | 0.3000 | ["86","90"] | ["0.3748","0.3601"] | ["88.03"] | ["AMXO"] | 86.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-7381-7723-9681-7a255340de60 | ITB | 2026-09-10 10:16 | put_vertical_spread | 2 | 3 | 679 | 281785.00 | short | bid | 87.9200 | 0.3000 | ["86","90"] | ["0.3748","0.3601"] | ["88.03"] | ["ARCO","XPHO"] | 86.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bad-7381-7723-9681-7a12e730ae07 | ITB | 2026-09-10 10:16 | put_vertical_spread | 2 | 1 | 352 | 146080.00 | short | bid | 87.9200 | 0.4000 | ["86","90"] | ["0.3748","0.3601"] | ["88.03"] | ["XISX"] | 86.0000 | 90.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:16:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |