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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a06df8-d2bd-7d60-a850-047e9ce82935 | CEG | 2026-09-04 15:50 | call_vertical_spread | 2 | 2 | 20 | 166810.00 | short | bid | 299.0300 | 6.7000 | ["290","310"] | ["0.4482","0.4485"] | ["298.92"] | ["ARCO","C2OX"] | 290.0000 | 310.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:50:29Z"} | 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 |
| 01a0818b-55c1-7843-ae5c-e084006e0342 | CEG | 2026-09-08 11:03 | call_vertical_spread | 2 | 1 | 10 | 136440.00 | unknown | — | 300.5000 | 7.2000 | ["250","400"] | ["0.4671","0.4666"] | [] | ["XISX"] | 250.0000 | 400.0000 | 500 | 500 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:03:37Z"} | 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 |
| 01a0a026-2899-7090-8bc8-907066e803d4 | CEG | 2026-09-14 09:40 | call_vertical_spread | 2 | 2 | 32 | 232720.00 | short | bid | 271.8200 | 5.5000 | ["260","360"] | ["0.4563","0.4693"] | ["291.36"] | ["ARCO","XISX"] | 260.0000 | 360.0000 | 276 | 276 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 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 |
| 01a0af9a-425b-7a50-81da-fd90f1692da3 | CEG | 2026-09-17 09:41 | call_vertical_spread | 2 | 1 | 10 | 254700.00 | short | bid | 264.0600 | 6.6000 | ["150","155"] | ["0.4600","0.4622"] | ["153.70"] | ["XMIO"] | 150.0000 | 155.0000 | 491 | 491 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:41:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af9c-22d3-7a32-ae7d-2bf39d16d8d7 | CEG | 2026-09-17 09:43 | call_vertical_spread | 2 | 2 | 14 | 165690.00 | short | bid | 264.2200 | 5.7000 | ["280","430"] | ["0.4540","0.4639"] | ["315.57"] | ["ARCO","XMIO"] | 280.0000 | 430.0000 | 855 | 855 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:43:59Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |