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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06da6-2e7e-73c0-85cc-15eff87c8311 | CEG | 2026-09-04 14:20 | iron_butterfly | 4 | 1 | 25 | 143475.00 | unknown | — | 296.4800 | 10.6000 | ["290","295","300"] | ["0.4231","0.4303","0.4171"] | [] | ["XCBO"] | 290.0000 | 300.0000 | 35 | 35 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:20:35Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dbf-9a4d-7df0-b0e4-a8eb6445bf53 | CEG | 2026-09-04 14:47 | call_vertical_spread | 2 | 1 | 9 | 171846.00 | short | bid | 297.2550 | 7.9000 | ["280","290"] | ["0.4533","0.4529"] | ["284.10"] | ["XCBO"] | 280.0000 | 290.0000 | 833 | 833 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:48:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dee-533d-78b3-8fcd-9be444d557c6 | CEG | 2026-09-04 15:38 | put_condor | 4 | 1 | 8 | 101128.00 | unknown | — | 298.1600 | 8.4000 | ["290","300","310","320"] | ["0.4591","0.4617","0.4607","0.4668"] | [] | ["XMIO"] | 290.0000 | 320.0000 | 105 | 105 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:39:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08154-3091-7980-a851-e358e956375e | CEG | 2026-09-08 10:02 | call_vertical_spread | 2 | 1 | 200 | 1160140.00 | short | bid | 301.0300 | 4.7000 | ["290","300"] | ["0.4647","0.4659"] | ["295.01"] | ["XCBO"] | 290.0000 | 300.0000 | 73 | 73 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:02Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08172-a570-7402-a7f9-01e1ef974c09 | CEG | 2026-09-08 10:36 | other | 4 | 1 | 330 | 1773766.00 | unknown | — | 302.0733 | 5.5500 | ["210","290","330"] | ["0.4747","0.4648","0.4825"] | [] | ["XCBO"] | 210.0000 | 330.0000 | 10 | 129 | false | true | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:36:13Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08698-2a98-7c62-bd54-8fcbefb94472 | CEG | 2026-09-09 10:35 | call_vertical_spread | 2 | 1 | 20 | 145180.00 | unknown | — | 296.4750 | 3.8000 | ["300","330"] | ["0.4784","0.4783"] | [] | ["XBOX"] | 300.0000 | 330.0000 | 191 | 191 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:35:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 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 |
| 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 |