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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a090e6-d2b1-7f40-8c6b-95ea3af1eb64 | CEG | 2026-09-11 10:37 | call_vertical_spread | 2 | 1 | 20 | 690980.00 | long | ask | 290.1350 | 6.0000 | ["125","130"] | ["0.5291","0.5287"] | ["129.13"] | ["XMIO"] | 125.0000 | 130.0000 | 497 | 497 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:37:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a05c-28d1-7ea1-a016-3950fbcb2371 | CEG | 2026-09-14 10:39 | call_diagonal_spread | 2 | 1 | 8 | 123896.00 | long | ask | 265.7000 | 5.2000 | ["270","290"] | ["0.4556","0.4582"] | [] | ["XISX"] | 270.0000 | 290.0000 | 823 | 858 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:40:07Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ce-0d11-7a03-bdd7-5cc19756bf69 | CEG | 2026-09-14 12:44 | call_diagonal_spread | 2 | 1 | 10 | 119850.00 | long | bid | 265.8500 | 4.3000 | ["270","300"] | ["0.4547","0.4572"] | [] | ["XMIO"] | 270.0000 | 300.0000 | 494 | 641 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:44:49Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a551-3ebe-7670-a3b0-7eadf8ef4a28 | CEG | 2026-09-15 09:45 | call_vertical_spread | 2 | 1 | 50 | 260950.00 | long | ask | 262.7200 | 0.2000 | ["280","300"] | ["0.4706","0.4459"] | ["288.59"] | ["XBOX"] | 280.0000 | 300.0000 | 185 | 185 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:46:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0b005-509b-7332-ad49-9b418a1684ad | CEG | 2026-09-17 11:38 | call_vertical_spread | 2 | 1 | 150 | 106500.00 | long | ask | 268.8800 | 1.0000 | ["267.5","270"] | ["0.6179","0.6057"] | ["268.82"] | ["XMIO"] | 267.5000 | 270.0000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:38:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b02b-3f8b-7370-9d9e-600a3c424ec9 | CEG | 2026-09-17 12:20 | synthetic | 2 | 2 | 25 | 176250.00 | long | bid | 268.3100 | 2.2000 | ["290"] | ["0.4473"] | ["274.30"] | ["ARCO","XBOX"] | 290.0000 | 290.0000 | 183 | 183 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:20:25Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4f6-e887-7dc2-9886-6e1be73f5c79 | CEG | 2026-09-18 10:41 | put_diagonal_spread | 2 | 1 | 105 | 243600.00 | long | bid | 258.4250 | 3.5000 | ["255","275"] | ["0.4174","1.1226"] | [] | ["XISX"] | 255.0000 | 275.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:41:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |