Simplify AnalyticsMulti-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dfd-a905-7bc0-83eb-e1fab43c6ba7 | DELL | 2026-09-04 15:55 | call_diagonal_spread_bullish | 2 | 1 | 20 | 67400.00 | short | bid | 524.4300 | 0.4900 | ["500","522.5"] | ["0.5653","1.8608"] | [] | ["XISX"] | 500.0000 | 522.5000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:55:40Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dcb-17b5-7413-9bd7-2ec774edbbdb | META | 2026-09-04 15:00 | call_diagonal_spread_bullish | 2 | 2 | 10 | 70700.00 | short | bid | 614.8400 | 1.1500 | ["560","610"] | ["0.3553","0.6782"] | [] | ["XCBO"] | 560.0000 | 610.0000 | 0 | 42 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:00:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d82-eb25-70d2-8983-8c5b4399cb66 | AVGO | 2026-09-04 13:41 | call_diagonal_spread_bullish | 2 | 2 | 12 | 107940.00 | short | bid | 355.3118 | 1.9500 | ["300","325"] | ["0.3474","0.3756"] | [] | ["XCBO"] | 300.0000 | 325.0000 | 14 | 42 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:41:43Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6e-c6e5-7840-bfeb-c89b262b58c7 | META | 2026-09-04 13:19 | call_diagonal_spread_bullish | 2 | 1 | 2 | 53880.00 | short | bid | 608.8900 | 5.6000 | ["350","597.5"] | ["1.7989","0.6154"] | [] | ["C2OX"] | 350.0000 | 597.5000 | 0 | 14 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:19:31Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d6c-7525-7b83-8355-7e490a4f2539 | QQQ | 2026-09-04 13:16 | call_diagonal_spread_bullish | 2 | 1 | 20 | 540120.00 | long | ask | 718.1500 | 1.4400 | ["475","707"] | ["0.3574","0.1516"] | [] | ["XCBO"] | 475.0000 | 707.0000 | 7 | 196 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |