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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08225-5789-7be1-bcf4-d3eb7029c201 | GOOGL | 2026-09-08 13:51 | call_vertical_spread | 2 | 2 | 170 | 219300.00 | long | ask | 339.3300 | 0.4200 | ["370","440"] | ["0.3534","0.3738"] | ["379.20"] | ["AMXO","XISX"] | 370.0000 | 440.0000 | 73 | 73 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:51:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08662-ce70-7031-88a3-e5aef4297955 | GOOGL | 2026-09-09 09:36 | put_vertical_spread | 2 | 1 | 150 | 108450.00 | long | ask | 329.6600 | 0.1800 | ["320","325"] | ["0.3244","0.3239"] | ["323.33"] | ["XISX"] | 320.0000 | 325.0000 | 9 | 9 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:37:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08687-7d10-7231-b898-2a63b2421e8d | GOOGL | 2026-09-09 10:16 | call_vertical_spread | 2 | 1 | 500 | 337000.00 | unknown | — | 330.5500 | 0.1800 | ["330","332.5"] | ["0.3725","0.3732"] | [] | ["XISX"] | 330.0000 | 332.5000 | 2 | 2 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:17:01Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 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 |
| 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 |
| 01a09103-47d8-7953-87eb-4bc33b207edc | GOOGL | 2026-09-11 11:08 | call_vertical_spread | 2 | 1 | 13 | 152295.00 | unknown | — | 341.6400 | 0.8000 | ["270","340"] | ["0.3777","0.3509"] | [] | ["MCRY"] | 270.0000 | 340.0000 | 161 | 161 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:08:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 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 |
| 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 |
| 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 |
| 01a0a631-03e6-74e0-a405-1c54290d99c4 | GOOGL | 2026-09-15 13:50 | put_vertical_spread | 2 | 1 | 20 | 109200.00 | long | ask | 343.1600 | 0.5000 | ["325","350"] | ["0.3466","0.3467"] | ["338.10"] | ["XCBO"] | 325.0000 | 350.0000 | 185 | 185 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:51:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 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 |
| 01a0b000-284b-77f3-8e06-dd874ec79e63 | GOOGL | 2026-09-17 11:33 | call_vertical_spread | 2 | 1 | 20 | 244500.00 | long | ask | 347.5225 | 1.0000 | ["340","380"] | ["0.3559","0.3508"] | ["357.55"] | ["XCBO"] | 340.0000 | 380.0000 | 491 | 491 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:33:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0c45d-5b3e-7e93-abec-d362facd8392 | GOOGL | 2026-09-21 10:27 | synthetic | 2 | 1 | 27 | 423900.00 | long | ask | 356.2700 | 3.6500 | ["380"] | ["0.3740"] | ["392.50"] | ["XCBO"] | 380.0000 | 380.0000 | 851 | 851 | true | false | false | false | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:27:40Z"} | 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 |
| 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 |
| 01a0c4e0-2b87-75c3-bd8d-f0a942e127c3 | GOOGL | 2026-09-21 12:50 | put_diagonal_spread | 2 | 1 | 49 | 212072.00 | unknown | ask | 355.3400 | 0.2200 | ["350","390"] | ["0.4174","0.3433"] | [] | ["XPHO"] | 350.0000 | 390.0000 | 0 | 88 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:50:41Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 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 |