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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c486-8e1f-76a3-9635-0e1c6c406431 | GOOGL | 2026-09-21 11:12 | call_diagonal_spread | 2 | 1 | 4 | 161060.00 | unknown | — | 354.6350 | 7.1000 | ["155","165"] | ["1.4270","0.4362"] | [] | ["XCBO"] | 155.0000 | 165.0000 | 25 | 487 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:12:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43e-889f-71e0-b191-de072e9d03a1 | GOOGL | 2026-09-21 09:53 | call_diagonal_spread | 2 | 1 | 19 | 201039.00 | unknown | bid | 354.5900 | 1.8000 | ["355","370"] | ["0.3522","0.3558"] | [] | ["MCRY"] | 355.0000 | 370.0000 | 269 | 452 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:53:58Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5b0-1e98-7d02-842a-acea8742bdf5 | GOOGL | 2026-09-18 14:03 | call_diagonal_spread | 2 | 1 | 30 | 601710.00 | unknown | bid | 349.8850 | 3.5000 | ["250","275"] | ["8.6315","0.3687"] | [] | ["XCBO"] | 250.0000 | 275.0000 | 0 | 364 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:03:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b529-4327-7811-b3e0-c69bf470decc | GOOGL | 2026-09-18 11:36 | call_diagonal_spread | 2 | 1 | 40 | 223520.00 | short | bid | 350.0751 | 0.9000 | ["350","400"] | ["0.3507","0.3375"] | [] | ["XCBO"] | 350.0000 | 400.0000 | 91 | 272 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:36:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bb-eee0-7ad2-80da-60eb0296bf5e | GOOGL | 2026-09-18 09:36 | call_diagonal_spread | 2 | 1 | 75 | 145800.00 | long | bid | 358.0000 | 0.7000 | ["347.5","350"] | ["0.6216","0.2634"] | [] | ["XCBO"] | 347.5000 | 350.0000 | 0 | 3 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b02f-e30b-7901-98a5-dc94209b6c1e | GOOGL | 2026-09-17 12:25 | call_diagonal_spread | 2 | 1 | 30 | 566190.00 | short | ask | 345.3500 | 3.6500 | ["250","280"] | ["2.5283","0.3642"] | [] | ["XCBO"] | 250.0000 | 280.0000 | 1 | 365 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:25:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab70-575b-7d33-92d3-ffb732fdc601 | GOOGL | 2026-09-16 14:17 | call_diagonal_spread | 2 | 1 | 90 | 1416060.00 | unknown | — | 345.9350 | 2.5000 | ["275","285"] | ["0.3700","0.3555"] | [] | ["XCBO"] | 275.0000 | 285.0000 | 156 | 184 | false | false | true | true | false | mlat | 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 |
| 01a0a586-c1f6-7351-a51f-c69502ee007f | GOOGL | 2026-09-15 10:44 | call_diagonal_spread | 2 | 1 | 50 | 608284.00 | long | ask | 344.4250 | 1.9000 | ["350","355"] | ["0.3551","0.3549"] | [] | ["XCBO"] | 350.0000 | 355.0000 | 458 | 493 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:45:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a152-2578-78e1-837e-7d56fea8952b | GOOGL | 2026-09-14 15:08 | call_diagonal_spread | 2 | 1 | 10 | 109880.00 | short | ask | 347.2300 | 2.7000 | ["290","305"] | ["1.0551","0.3544"] | [] | ["XCBO"] | 290.0000 | 305.0000 | 4 | 95 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:08:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d7-2530-7df2-b93f-98a0dede5cad | GOOGL | 2026-09-14 12:54 | call_diagonal_spread | 2 | 1 | 240 | 3105840.00 | short | bid | 347.6660 | 3.7000 | ["390","410"] | ["0.3731","0.3768"] | [] | ["XMIO"] | 390.0000 | 410.0000 | 641 | 858 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:54:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090fc-0478-7bc3-85fc-6e8f9d02cac5 | GOOGL | 2026-09-11 11:00 | call_diagonal_spread | 2 | 1 | 6 | 112002.00 | long | ask | 340.3000 | 2.6500 | ["280","330"] | ["0.3988","0.3735"] | [] | ["XMIO"] | 280.0000 | 330.0000 | 462 | 826 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:00:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd0-8ef0-7d11-baea-5a052f5321df | GOOGL | 2026-09-10 15:34 | call_diagonal_spread | 2 | 1 | 30 | 238680.00 | unknown | — | 332.4600 | 0.4500 | ["270","370"] | ["0.3599","0.3529"] | [] | ["XMIO"] | 270.0000 | 370.0000 | 71 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:34:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9f-d338-7073-a9a1-8c7599cef290 | GOOGL | 2026-09-10 10:01 | call_diagonal_spread | 2 | 1 | 5 | 143905.00 | short | bid | 328.3900 | 5.6500 | ["185","190"] | ["1.7830","0.4616"] | [] | ["XCBO"] | 185.0000 | 190.0000 | 8 | 190 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:01:56Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08749-0408-7a31-8a1f-368f1a33f02d | GOOGL | 2026-09-09 13:48 | call_diagonal_spread | 2 | 1 | 30 | 167880.00 | long | ask | 330.7300 | 1.0500 | ["345","350"] | ["0.3539","0.3501"] | [] | ["XMIO"] | 345.0000 | 350.0000 | 163 | 191 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:48:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0871c-6a10-7760-90cd-87377c5c815d | GOOGL | 2026-09-09 12:59 | call_diagonal_spread | 2 | 1 | 40 | 365640.00 | short | bid | 330.0100 | 1.2000 | ["300","340"] | ["0.3622","0.3554"] | [] | ["XMIO"] | 300.0000 | 340.0000 | 163 | 281 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:00:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0818b-1358-7153-b83f-8ce9881e4320 | GOOGL | 2026-09-08 11:02 | call_diagonal_spread | 2 | 1 | 12 | 178932.00 | short | bid | 337.8100 | 6.1000 | ["340","365"] | ["0.3584","0.3610"] | [] | ["XCBO"] | 340.0000 | 365.0000 | 647 | 829 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:02:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0817c-61a0-7761-8930-86a70549fd7c | GOOGL | 2026-09-08 10:46 | call_diagonal_spread | 2 | 1 | 12 | 368390.00 | long | bid | 336.4200 | 5.5500 | ["120","330"] | ["0.9877","0.3638"] | [] | ["XCBO"] | 120.0000 | 330.0000 | 129 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:47:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08174-a910-7c42-9632-f0d8f1f0fd6d | GOOGL | 2026-09-08 10:38 | call_diagonal_spread | 2 | 1 | 24 | 310200.00 | long | bid | 334.5700 | 2.7000 | ["270","315"] | ["0.7325","0.3545"] | [] | ["XMIO"] | 270.0000 | 315.0000 | 10 | 374 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:38:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |