Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b615-c607-7f50-a4a1-a6e186814936 | MU | 2026-09-18 15:54 | risk_reversal | 2 | 1 | 10 | 37100.00 | long | bid | 1009.8250 | 1.9000 | ["930","1120"] | ["0.6585","0.6752"] | ["928.36"] | ["XMIO"] | 930.0000 | 1120.0000 | 14 | 14 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b024-4e33-7da1-9175-f6e7df9fb8a8 | MU | 2026-09-17 12:12 | risk_reversal | 3 | 1 | 5 | 147011.00 | long | bid | 976.5850 | 6.8000 | ["800","1200","1600"] | ["0.5844","0.5926","0.6105"] | ["777.81"] | ["XCBO"] | 800.0000 | 1600.0000 | 273 | 273 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:12:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd8-e19b-7940-a789-7146b15eff3d | MU | 2026-09-17 10:50 | risk_reversal | 2 | 1 | 7 | 40292.00 | short | bid | 978.1150 | 1.2000 | ["890","1090"] | ["0.6034","0.6146"] | ["1091.88"] | ["XMIO"] | 890.0000 | 1090.0000 | 29 | 29 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:50:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab15-7d8b-7df0-9715-69cfa843b8c2 | MU | 2026-09-16 12:38 | risk_reversal | 2 | 1 | 40 | 82918.00 | short | bid | 929.3950 | 0.9500 | ["630","1500"] | ["0.5909","0.6267"] | ["1501.88"] | ["XMIO"] | 630.0000 | 1500.0000 | 93 | 93 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:39:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab12-7c03-7681-8a42-bb3dc87e8f4e | MU | 2026-09-16 12:35 | risk_reversal | 2 | 1 | 40 | 32320.00 | long | ask | 929.2300 | 0.2000 | ["580","1200"] | ["0.7775","0.6326"] | ["1206.14"] | ["XMIO"] | 580.0000 | 1200.0000 | 30 | 30 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:36:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a0b4-b4c9-7300-ae4a-b53c12b769e8 | MU | 2026-09-14 12:16 | risk_reversal | 3 | 1 | 5 | 145350.00 | long | bid | 919.1450 | 8.4500 | ["800","1200","1600"] | ["0.5928","0.6198","0.6356"] | ["748.96"] | ["XCBO"] | 800.0000 | 1600.0000 | 276 | 276 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:16:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a066-8140-70e2-aa5e-354869d1bf16 | MU | 2026-09-14 10:51 | risk_reversal | 3 | 1 | 10 | 99410.00 | short | ask | 914.5400 | 5.5300 | ["880","980","1120"] | ["0.5641","0.5654","0.6408"] | ["923.87"] | ["XMIO"] | 880.0000 | 1120.0000 | 11 | 11 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:51:08Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a040-3490-7251-acb8-2a6f4a8a4b2c | MU | 2026-09-14 10:09 | risk_reversal | 2 | 1 | 5 | 25125.00 | long | bid | 916.4100 | 0.4500 | ["935","940"] | ["0.6418","0.6516"] | ["915.35"] | ["XCBO"] | 935.0000 | 940.0000 | 4 | 4 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:09:17Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03f-6588-70d0-8cae-1046b9ffdce6 | MU | 2026-09-14 10:08 | risk_reversal | 2 | 1 | 4 | 126988.00 | short | ask | 914.3401 | 6.7000 | ["1100","1110"] | ["0.6235","0.6258"] | ["926.09"] | ["XCBO"] | 1100.0000 | 1110.0000 | 123 | 123 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:08:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090e1-b230-7721-b35e-2eaf7870352a | MU | 2026-09-11 10:31 | risk_reversal | 2 | 1 | 5 | 32310.00 | short | ask | 978.8600 | 4.6000 | ["970","1000"] | ["0.5107","0.5151"] | ["966.82"] | ["XCBO"] | 970.0000 | 1000.0000 | 14 | 14 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:31:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c89-dd48-7703-9ac6-eb5ab44ab834 | MU | 2026-09-10 14:17 | risk_reversal | 2 | 1 | 35 | 27615.00 | unknown | — | 981.1350 | 0.4000 | ["700","1500"] | ["0.6917","0.7238"] | [] | ["XCBO"] | 700.0000 | 1500.0000 | 36 | 36 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:17:47Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb4-0719-72d2-a46f-539a1331e851 | MU | 2026-09-10 10:23 | risk_reversal | 2 | 1 | 20 | 174580.00 | long | ask | 988.7700 | 7.9500 | ["985","990"] | ["0.5613","0.5631"] | ["993.02"] | ["XCBO"] | 985.0000 | 990.0000 | 15 | 15 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:24:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086ae-13f9-7383-bede-2e1303878df7 | MU | 2026-09-09 10:59 | risk_reversal | 2 | 1 | 4 | 28376.00 | short | bid | 1034.5150 | 4.6300 | ["965","970"] | ["0.7548","0.7522"] | ["1035.28"] | ["XCBO"] | 965.0000 | 970.0000 | 2 | 2 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:59:18Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08188-2940-7563-a497-2bd8ea454a1b | MU | 2026-09-08 10:59 | risk_reversal | 3 | 1 | 5 | 122950.00 | long | ask | 1016.8100 | 9.5500 | ["700","950","1150"] | ["0.6732","0.6615","0.6805"] | ["1016.18"] | ["XCBO"] | 700.0000 | 1150.0000 | 73 | 73 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:59:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08170-a5b9-7651-b7a0-0942c7ed3003 | MU | 2026-09-08 10:33 | risk_reversal | 3 | 1 | 10 | 125450.00 | long | ask | 1018.9500 | 8.2500 | ["875","1020","1150"] | ["0.7010","0.7099","0.7341"] | ["1043.73"] | ["XCBO"] | 875.0000 | 1150.0000 | 24 | 24 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:34:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813c-1c80-7223-b45c-d2f045b85e15 | MU | 2026-09-08 09:36 | risk_reversal | 2 | 1 | 5 | 36155.00 | short | bid | 1026.6000 | 0.9000 | ["965","970"] | ["0.7794","0.7686"] | ["1027.67"] | ["EDGO"] | 965.0000 | 970.0000 | 3 | 3 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:36:47Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d43-6d3d-76a1-96fb-f65b6ce5df06 | MU | 2026-09-04 12:32 | risk_reversal | 2 | 1 | 5 | 46620.00 | long | ask | 1007.0000 | 0.6000 | ["940","950"] | ["0.5474","0.5459"] | ["1011.20"] | ["XMIO"] | 940.0000 | 950.0000 | 14 | 14 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:32:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d2e-00de-7300-ab1b-bc40c21d48d2 | MU | 2026-09-04 12:08 | risk_reversal | 2 | 1 | 20 | 98095.00 | long | bid | 999.6300 | 0.5000 | ["970","1060"] | ["0.5392","0.5562"] | ["963.56"] | ["XCBO"] | 970.0000 | 1060.0000 | 14 | 14 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:09:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |