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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c551-b5ee-7b63-b26f-a0c03a44e89d | V | 2026-09-21 14:54 | call_vertical_spread | 2 | 1 | 3 | 105552.00 | unknown | bid | 368.7700 | 5.3000 | ["190","195"] | ["3.2712","3.1555"] | ["368.42"] | ["XCBO"] | 190.0000 | 195.0000 | 4 | 4 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:54:32Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c549-d64f-7d93-a18a-f3ead376ad90 | V | 2026-09-21 14:45 | put_vertical_spread | 2 | 1 | 200 | 220000.00 | short | bid | 368.5400 | 0.9500 | ["310","315"] | ["0.2731","0.2682"] | ["314.36"] | ["BATO"] | 310.0000 | 315.0000 | 179 | 179 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:45:52Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b619-a637-7150-af9b-37a974a99bb9 | V | 2026-09-18 15:58 | call_vertical_spread | 2 | 1 | 17 | 194820.00 | unknown | bid | 368.2900 | 5.6000 | ["390","400"] | ["0.2366","0.2349"] | ["452.30"] | ["XBOX"] | 390.0000 | 400.0000 | 819 | 819 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b534-1897-72c2-88e1-4811d192071b | V | 2026-09-18 11:48 | call_calendar | 2 | 1 | 50 | 197700.00 | unknown | bid | 369.5200 | 0.9500 | ["370"] | ["0.2134"] | [] | ["BATO"] | 370.0000 | 370.0000 | 7 | 272 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:48:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bc-73af-70a1-b291-50b46b88b749 | V | 2026-09-18 09:37 | call_diagonal_spread | 2 | 2 | 48 | 190128.00 | short | bid | 367.1358 | 1.0500 | ["350","355"] | ["0.9985","0.2310"] | [] | ["ARCO","XMIO"] | 350.0000 | 355.0000 | 0 | 63 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b021-f88a-7fe2-99f2-500694dfafc8 | V | 2026-09-17 12:10 | call_diagonal_spread | 2 | 1 | 47 | 430238.00 | short | bid | 371.3150 | 5.1000 | ["325","335"] | ["1.5549","0.2312"] | [] | ["XCBO"] | 325.0000 | 335.0000 | 1 | 120 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:10:40Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba8-8dfb-7d71-a77b-dadde24eda96 | V | 2026-09-16 15:19 | call_diagonal_spread | 2 | 1 | 20 | 168520.00 | short | bid | 368.7600 | 4.8500 | ["365","380"] | ["0.2474","0.2450"] | [] | ["XPHO"] | 365.0000 | 380.0000 | 274 | 457 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:19:03Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5a0-5ca6-7492-b7c7-1720a45c50a8 | V | 2026-09-15 11:12 | call_diagonal_spread | 2 | 1 | 45 | 132975.00 | short | bid | 373.9900 | 2.0000 | ["360","375"] | ["0.3244","0.2222"] | [] | ["BATO"] | 360.0000 | 375.0000 | 3 | 66 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:12:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a558-3016-73e3-b01a-318e513ecb81 | V | 2026-09-15 09:53 | call_calendar | 2 | 6 | 6 | 133903.00 | long | bid | 374.9150 | 3.7917 | ["265"] | ["1.1151"] | [] | ["ARCO","BATO","C2OX","EDGO","XCBO","XISX"] | 265.0000 | 265.0000 | 3 | 94 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:54:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a558-3016-73e3-b01a-3177450075b3 | V | 2026-09-15 09:53 | call_calendar | 2 | 7 | 11 | 245391.00 | long | bid | 374.9150 | 3.8000 | ["265"] | ["1.1564"] | [] | ["AMXO","EMLD","MCRY","XBOX","XCBO","XMIO","XPHO"] | 265.0000 | 265.0000 | 3 | 94 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:54:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a558-2c2e-71c1-bb39-a1b97f5d9b72 | V | 2026-09-15 09:53 | call_calendar | 2 | 5 | 5 | 111470.00 | long | bid | 374.9150 | 3.9500 | ["265"] | ["1.1665"] | [] | ["AMXO","XBOX","XCBO","XISX","XPHO"] | 265.0000 | 265.0000 | 3 | 94 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:54:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0e4-3cc0-7f20-9dc7-bdbebde81ad4 | V | 2026-09-14 13:08 | call_vertical_spread | 2 | 1 | 18 | 229000.00 | short | bid | 376.1800 | 5.1500 | ["390","400"] | ["0.2424","0.2419"] | ["394.52"] | ["XMIO"] | 390.0000 | 400.0000 | 823 | 823 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:09:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a091-1799-7412-b49e-64c13fdf31f0 | V | 2026-09-14 11:37 | call_diagonal_spread | 2 | 1 | 12 | 143568.00 | short | bid | 375.0400 | 4.7000 | ["380","390"] | ["0.2422","0.2415"] | [] | ["AMXO"] | 380.0000 | 390.0000 | 641 | 732 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:37:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05b-03d8-7f82-85ab-c56798105a71 | V | 2026-09-14 10:38 | call_calendar | 2 | 1 | 20 | 128020.00 | long | bid | 375.9250 | 4.3000 | ["350"] | ["0.3239"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 4 | 123 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:38:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0918d-6350-7bf0-bf60-a228909e0d82 | V | 2026-09-11 13:39 | call_calendar | 2 | 1 | 44 | 100804.00 | long | bid | 370.9400 | 0.4000 | ["360"] | ["0.5756"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:39:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09144-38d9-78c3-8e35-a028e5e2c798 | V | 2026-09-11 12:19 | call_calendar | 2 | 1 | 50 | 136200.00 | short | bid | 369.9150 | 0.8000 | ["360"] | ["0.2102"] | [] | ["BATO"] | 360.0000 | 360.0000 | 7 | 35 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:19:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0871c-9cd8-7062-ac98-cb3e841a1539 | V | 2026-09-09 12:59 | call_diagonal_spread | 2 | 1 | 32 | 154880.00 | long | bid | 368.3940 | 2.0000 | ["345","360"] | ["0.2851","0.2294"] | [] | ["XMIO"] | 345.0000 | 360.0000 | 9 | 100 | false | false | true | true | false | mlet | 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 |
| 01a086fa-6321-7ac2-a504-66230843568a | V | 2026-09-09 12:22 | call_diagonal_spread | 2 | 1 | 93 | 435240.00 | short | bid | 367.6451 | 2.6500 | ["345","360"] | ["0.2280","0.2283"] | [] | ["XPHO"] | 345.0000 | 360.0000 | 9 | 100 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:22:43Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ef-4f30-7d10-8a4c-52adfa7491cd | V | 2026-09-09 12:10 | call_vertical_spread | 2 | 1 | 205 | 261375.00 | short | bid | 367.0000 | 0.9500 | ["395","410"] | ["0.2205","0.2186"] | ["398.43"] | ["XPHO"] | 395.0000 | 410.0000 | 100 | 100 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:11:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06da8-5d15-7651-b725-c509d181380d | V | 2026-09-04 14:22 | call_vertical_spread | 2 | 1 | 15 | 243555.00 | short | bid | 375.7000 | 4.0000 | ["290","300"] | ["0.4933","0.4698"] | ["299.95"] | ["XCBO"] | 290.0000 | 300.0000 | 14 | 14 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:22:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |