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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4a7-ba4f-7db0-8117-d57247442560 | ORCL | 2026-09-21 11:48 | call_calendar | 2 | 3 | 54 | 54492.00 | short | ask | 149.3200 | 0.3500 | ["148"] | ["0.5233"] | [] | ["XBOX","XCBO","XISX"] | 148.0000 | 148.0000 | 4 | 11 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:48:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5a4-4757-7b81-85e7-2330c9f6e2f3 | ORCL | 2026-09-18 13:50 | call_calendar | 2 | 1 | 6 | 44658.00 | short | ask | 146.3400 | 0.7500 | ["110"] | ["4.2145"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 0 | 63 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab42-2ef3-7be0-8577-9399693e684f | ORCL | 2026-09-16 13:27 | call_calendar | 2 | 1 | 47 | 229078.00 | unknown | — | 143.8290 | 0.8000 | ["120"] | ["0.8874"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 2 | 30 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:27:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae3-c6fb-77f1-a770-13ae40993a26 | ORCL | 2026-09-16 11:44 | call_calendar | 2 | 1 | 10 | 30600.00 | unknown | — | 143.8200 | 0.3000 | ["130"] | ["0.5769"] | [] | ["AMXO"] | 130.0000 | 130.0000 | 2 | 30 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:44:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae1-753b-7972-bba7-398f787f1c6f | ORCL | 2026-09-16 11:41 | call_calendar | 2 | 1 | 10 | 49260.00 | unknown | — | 143.9260 | 0.7000 | ["120"] | ["0.8722"] | [] | ["XMIO"] | 120.0000 | 120.0000 | 2 | 30 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:42:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a5d9-7da6-77b2-9c81-0a358fadfc17 | ORCL | 2026-09-15 12:14 | call_calendar | 2 | 1 | 20 | 295540.00 | short | ask | 143.7682 | 1.0000 | ["70"] | ["2.4219"] | [] | ["XCBO"] | 70.0000 | 70.0000 | 3 | 31 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:14:55Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56a-b25e-7b30-b6c0-f2cd61dc7ab8 | ORCL | 2026-09-15 10:13 | call_calendar | 2 | 1 | 49 | 103292.00 | unknown | — | 141.2550 | 0.6000 | ["160"] | ["0.5484"] | [] | ["XCBO"] | 160.0000 | 160.0000 | 94 | 122 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:14:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c6-d180-7352-aae3-157b94f36276 | ORCL | 2026-09-14 12:36 | call_calendar | 2 | 1 | 800 | 508800.00 | long | ask | 143.9200 | 0.1100 | ["180"] | ["0.6155"] | [] | ["XCBO"] | 180.0000 | 180.0000 | 11 | 95 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a034-5198-7ee3-976a-151eb44c3fed | ORCL | 2026-09-14 09:56 | call_calendar | 2 | 1 | 12 | 65112.00 | short | bid | 144.3837 | 2.0500 | ["150"] | ["0.5545"] | [] | ["MCRY"] | 150.0000 | 150.0000 | 123 | 494 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:56:36Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0914f-1a01-7df0-a19d-cf33b748b489 | ORCL | 2026-09-11 12:31 | call_calendar | 2 | 1 | 4 | 53580.00 | short | bid | 151.7200 | 1.4000 | ["85"] | ["1.3238"] | [] | ["XMIO"] | 85.0000 | 85.0000 | 7 | 70 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:31:17Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d5-94a0-7a72-9d40-526a502af2ec | ORCL | 2026-09-11 10:18 | call_calendar | 2 | 1 | 50 | 33250.00 | long | ask | 154.3550 | 0.3600 | ["155"] | ["0.9685"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 0 | 7 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:18:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090cb-8a50-7762-8342-ef0ff4462a1a | ORCL | 2026-09-11 10:07 | call_calendar | 2 | 1 | 20 | 63440.00 | short | bid | 155.2700 | 1.5500 | ["140"] | ["1.3785"] | [] | ["XMIO"] | 140.0000 | 140.0000 | 0 | 14 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:07:42Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090c4-98f9-7582-a4fe-fb4ba84465d8 | ORCL | 2026-09-11 09:59 | call_calendar | 2 | 1 | 10 | 26280.00 | short | ask | 156.4200 | 2.9500 | ["145"] | ["0.5510"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 7 | 14 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:00:03Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c88-4321-7ae0-aea7-c57f427f1a1a | ORCL | 2026-09-10 14:15 | call_calendar | 2 | 1 | 35 | 27615.00 | long | ask | 155.5200 | 0.1500 | ["175"] | ["2.1064"] | [] | ["XCBO"] | 175.0000 | 175.0000 | 1 | 8 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:16:10Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8a-b110-7920-a3c3-82d0d6235196 | ORCL | 2026-09-10 09:38 | call_calendar | 2 | 1 | 100 | 330600.00 | long | bid | 157.3800 | 1.3000 | ["160"] | ["0.6654"] | [] | ["XCBO"] | 160.0000 | 160.0000 | 36 | 99 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:38Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8a-2088-7091-994b-5e0333fd2772 | ORCL | 2026-09-10 09:37 | call_calendar | 2 | 1 | 100 | 331000.00 | long | ask | 157.2350 | 0.8000 | ["160"] | ["0.6695"] | [] | ["XMIO"] | 160.0000 | 160.0000 | 36 | 99 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:38:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0876a-91e0-7711-8f62-fe896790abfe | ORCL | 2026-09-09 14:25 | call_calendar | 2 | 1 | 22 | 31680.00 | short | ask | 164.4350 | 0.3000 | ["180"] | ["0.8929"] | [] | ["XCBO"] | 180.0000 | 180.0000 | 9 | 37 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:25:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ac-4af0-7763-b52e-1a7359cb5fe3 | ORCL | 2026-09-09 10:57 | call_calendar | 2 | 1 | 24 | 41640.00 | long | ask | 162.1300 | 0.3000 | ["165"] | ["1.4933"] | [] | ["XCBO"] | 165.0000 | 165.0000 | 2 | 9 | false | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:57:24Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0867f-ef78-70a3-b77d-7b73afa7e775 | ORCL | 2026-09-09 10:08 | call_calendar | 2 | 1 | 50 | 121450.00 | long | bid | 161.2850 | 0.5000 | ["160"] | ["1.2967"] | [] | ["AMXO"] | 160.0000 | 160.0000 | 2 | 37 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:08:56Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dc1-ccce-7233-b01d-612ad016cf95 | ORCL | 2026-09-04 14:50 | call_calendar | 2 | 1 | 4 | 35112.00 | short | bid | 157.4900 | 1.9000 | ["120"] | ["0.5839"] | [] | ["XCBO"] | 120.0000 | 120.0000 | 105 | 133 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:50:32Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d66-953d-7771-8a61-57036a03fd06 | ORCL | 2026-09-04 13:10 | call_calendar | 2 | 1 | 4 | 46320.00 | short | bid | 157.8550 | 0.8500 | ["100"] | ["6.7500"] | [] | ["XCBO"] | 100.0000 | 100.0000 | 0 | 7 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:11:08Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |