Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5bf-d607-7c53-8fae-80c07746e8fb | GLW | 2026-09-18 14:20 | put_diagonal_spread | 2 | 1 | 250 | 1136000.00 | short | ask | 149.0700 | 4.0500 | ["100","170"] | ["0.6325","0.5981"] | [] | ["SPHR"] | 100.0000 | 170.0000 | 119 | 490 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:20:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aa78-b0eb-70d1-b172-9e08cdf8b35c | GLW | 2026-09-16 09:47 | put_diagonal_spread | 2 | 2 | 18 | 151068.00 | long | bid | 147.1100 | 4.4111 | ["160","207.5"] | ["0.6496","2.5000"] | [] | ["EMLD","XISX"] | 160.0000 | 207.5000 | 2 | 65 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:47:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a09b-29b8-7880-aeb5-fe447868aff4 | GLW | 2026-09-14 11:48 | put_diagonal_spread | 2 | 2 | 20 | 119540.00 | unknown | — | 148.0600 | 3.0000 | ["160","175"] | ["0.6524","1.0294"] | [] | ["XISX"] | 160.0000 | 175.0000 | 4 | 186 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:48:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a070-a300-7c63-988e-a8f7804ce604 | GLW | 2026-09-14 11:02 | put_diagonal_spread | 2 | 1 | 10 | 128370.00 | long | bid | 145.4000 | 5.7000 | ["200","210"] | ["0.6589","0.6772"] | [] | ["XCBO"] | 200.0000 | 210.0000 | 67 | 186 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:02:41Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0915a-4178-74f2-b9eb-dcc319dc3aed | GLW | 2026-09-11 12:43 | put_diagonal_spread | 2 | 3 | 116 | 173304.00 | short | bid | 167.1500 | 1.0000 | ["165","170"] | ["0.5858","0.5785"] | [] | ["EDGO","XCBO","XPHO"] | 165.0000 | 170.0000 | 7 | 21 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:43:26Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |