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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ea-3997-7aa1-b321-5336d5d707a4 | ORCL | 2026-09-18 15:06 | other | 4 | 1 | 30 | 1235300.00 | unknown | — | 148.2200 | 3.1000 | ["180","300","310"] | ["0.5845","0.8827","0.9595"] | [] | ["XPHO"] | 180.0000 | 310.0000 | 7 | 119 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:07:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a8-3ba3-7ad2-a4cf-207c4917c80f | ORCL | 2026-09-17 14:36 | other | 4 | 1 | 1630 | 24739250.00 | unknown | — | 149.1600 | 1.4500 | ["190","195","200","210"] | ["2.2143","2.4127","2.6036","2.9657"] | [] | ["XBOX"] | 190.0000 | 210.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:36:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a4-ccbb-7ce2-98e5-d41bded13ad6 | ORCL | 2026-09-17 14:33 | other | 8 | 1 | 527 | 12745570.00 | unknown | — | 149.3950 | 3.3000 | ["170","175","200","220","240","250","270","310"] | ["1.2866","1.5220","2.5476","3.2415","0.9823","4.1403","4.4004","0.8846"] | [] | ["XBOX"] | 170.0000 | 310.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:33:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a4-ad7b-7781-90c8-b82b488d334e | ORCL | 2026-09-17 14:32 | other | 5 | 1 | 2344 | 18600032.00 | unknown | — | 149.4100 | 2.3500 | ["175","185","260","270","300"] | ["1.5518","1.9943","4.4725","4.7325","0.9060"] | [] | ["XBOX"] | 175.0000 | 300.0000 | 1 | 92 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:33:02Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a661-c846-7c33-a5f6-045339fc3111 | ORCL | 2026-09-15 14:43 | other | 3 | 2 | 1000 | 1395500.00 | unknown | — | 141.4100 | 0.8000 | ["140","155"] | ["0.5346","0.4936"] | [] | ["AMXO"] | 140.0000 | 155.0000 | 31 | 122 | false | true | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:44:19Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0914d-1278-7a60-b1de-2c31849400af | ORCL | 2026-09-11 12:29 | other | 2 | 2 | 400 | 608000.00 | unknown | — | 151.7600 | 0.9000 | ["125","145"] | ["0.5589","0.5688"] | [] | ["ARCO"] | 125.0000 | 145.0000 | 98 | 189 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:29:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c46-f848-7ea2-8e7d-3979b2b4e842 | ORCL | 2026-09-10 13:04 | other | 2 | 2 | 500 | 849500.00 | unknown | — | 156.5200 | 0.9500 | ["110","115"] | ["0.5946","0.6106"] | [] | ["ARCO"] | 110.0000 | 115.0000 | 127 | 400 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:04:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c46-0618-7ad2-9b77-a79c35e6bf4e | ORCL | 2026-09-10 13:03 | other | 2 | 2 | 1000 | 490000.00 | unknown | — | 156.8100 | 0.2200 | ["150","200"] | ["1.1110","1.2420"] | [] | ["ARCO"] | 150.0000 | 200.0000 | 8 | 8 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:03:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bda-d0c8-7463-9efa-1eb18bd9227e | ORCL | 2026-09-10 11:06 | other | 3 | 1 | 160 | 302600.00 | unknown | — | 158.4199 | 0.9000 | ["120","170","220"] | ["0.6244","0.6397","0.6550"] | [] | ["XPHO"] | 120.0000 | 220.0000 | 99 | 99 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:06:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08748-cd59-7b21-b69a-20c47c1162fa | ORCL | 2026-09-09 13:48 | other | 2 | 1 | 400 | 2190000.00 | unknown | — | 163.3500 | 2.0000 | ["200","230"] | ["0.6666","0.7007"] | [] | ["AMXO"] | 200.0000 | 230.0000 | 100 | 100 | false | false | false | true | false | mlft | 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 |
| 01a0872f-80c8-7ed2-bc69-8eab7a8265f8 | ORCL | 2026-09-09 13:20 | other | 2 | 2 | 400 | 1472300.00 | unknown | — | 162.6150 | 1.3500 | ["250","280"] | ["0.7280","0.6068"] | [] | ["AMXO"] | 250.0000 | 280.0000 | 100 | 373 | false | false | true | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:21:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08152-0db0-7713-b703-bb715284fac5 | ORCL | 2026-09-08 10:00 | other | 4 | 1 | 1125 | 4358737.00 | unknown | — | 164.8399 | 1.5000 | ["155","170","175","185"] | ["0.6393","0.6721","0.6689","0.6849"] | [] | ["XBOX"] | 155.0000 | 185.0000 | 38 | 38 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:00:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d7b-fdb5-76c1-a6d9-44a3fabcb77e | ORCL | 2026-09-04 13:33 | other | 2 | 1 | 1300 | 1658150.00 | unknown | — | 157.5900 | 0.7000 | ["125","170"] | ["0.6455","0.6594"] | [] | ["XBOX"] | 125.0000 | 170.0000 | 42 | 42 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7b-22f5-7a40-8a6f-fbe97a7a7aea | ORCL | 2026-09-04 13:32 | other | 2 | 2 | 1300 | 2361450.00 | unknown | — | 157.3550 | 1.0000 | ["90","250"] | ["0.6057","0.5897"] | [] | ["AMXO"] | 90.0000 | 250.0000 | 469 | 469 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:33:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |