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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c508-d1c7-7d13-abfa-dd63186fa951 | GOOGL | 2026-09-21 13:34 | call_calendar | 2 | 1 | 4 | 157600.00 | short | ask | 355.9400 | 6.4000 | ["185"] | ["0.3999"] | [] | ["XISX"] | 185.0000 | 185.0000 | 816 | 851 | false | false | true | false | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:34:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4b2-ca57-7fa0-96f1-ac6377846c1f | GOOGL | 2026-09-21 12:00 | call_vertical_spread | 2 | 1 | 10 | 148950.00 | short | bid | 356.7650 | 1.1500 | ["300","400"] | ["0.3628","0.3531"] | ["348.35"] | ["XCBO"] | 300.0000 | 400.0000 | 487 | 487 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:00:55Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c462-3d3f-7662-bc6e-495bb2b9f5b6 | GOOGL | 2026-09-21 10:32 | call_vertical_spread | 2 | 1 | 200 | 1005000.00 | short | bid | 356.7350 | 0.3500 | ["345","355"] | ["0.3547","0.3537"] | ["350.45"] | ["C2OX"] | 345.0000 | 355.0000 | 60 | 60 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:33:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0abc3-41eb-72d2-99db-b4eef90d0b9e | GOOGL | 2026-09-16 15:48 | call_vertical_spread | 2 | 1 | 20 | 202900.00 | short | bid | 343.0900 | 3.1000 | ["350","700"] | ["0.3617","0.3620"] | ["418.95"] | ["XCBO"] | 350.0000 | 700.0000 | 821 | 821 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:48:27Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab70-575b-7d33-92d3-ffa7edfa5fb2 | GOOGL | 2026-09-16 14:17 | call_diagonal_spread | 2 | 1 | 10 | 157900.00 | short | ask | 345.9350 | 1.2500 | ["275","285"] | ["0.3760","0.3601"] | [] | ["XISX"] | 275.0000 | 285.0000 | 156 | 184 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:18:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5a9-70de-70d2-9b10-fe1e3469a960 | GOOGL | 2026-09-15 11:22 | call_vertical_spread | 2 | 1 | 212 | 138860.00 | short | bid | 343.9950 | 0.2900 | ["355","370"] | ["0.3011","0.3093"] | ["358.05"] | ["C2OX"] | 355.0000 | 370.0000 | 17 | 17 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:22:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a559-12a5-79c1-8b15-5303c1671767 | GOOGL | 2026-09-15 09:54 | call_vertical_spread | 2 | 1 | 200 | 931000.00 | short | bid | 345.8600 | 0.6500 | ["340","345"] | ["0.3477","0.3463"] | ["342.65"] | ["C2OX"] | 340.0000 | 345.0000 | 66 | 66 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:54:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a146-a040-7193-92be-c8eb3cf08c6f | GOOGL | 2026-09-14 14:55 | call_diagonal_spread | 2 | 1 | 4 | 112720.00 | short | bid | 347.0750 | 2.9500 | ["210","225"] | ["0.5319","0.4152"] | [] | ["XCBO"] | 210.0000 | 225.0000 | 95 | 459 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:55:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090cb-d0a0-7141-a049-7b2c4e8e8aed | GOOGL | 2026-09-11 10:07 | put_vertical_spread | 2 | 1 | 16 | 120160.00 | short | bid | 338.7300 | 2.0000 | ["300","400"] | ["0.3335","0.3471"] | ["343.10"] | ["XISX"] | 300.0000 | 400.0000 | 126 | 126 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:08:04Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c68-7298-77b1-95e7-5273dfcd200c | GOOGL | 2026-09-10 13:40 | risk_reversal | 2 | 1 | 22 | 175560.00 | short | bid | 331.5850 | 1.1000 | ["295","480"] | ["0.3736","0.3658"] | ["482.60"] | ["C2OX"] | 295.0000 | 480.0000 | 827 | 827 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:41:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-6eb0-7940-b708-12dd75bb6588 | GOOGL | 2026-09-10 13:40 | risk_reversal | 2 | 1 | 22 | 175560.00 | short | bid | 331.5850 | 1.1000 | ["295","480"] | ["0.3736","0.3658"] | ["482.60"] | ["C2OX"] | 295.0000 | 480.0000 | 827 | 827 | false | true | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:41:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |