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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b60e-76f0-7150-a376-2c2286b63a3f | COST | 2026-09-18 15:46 | call_diagonal_spread | 2 | 1 | 4 | 156684.00 | short | ask | 896.7700 | 9.7000 | ["700","740"] | ["21.6879","0.2544"] | [] | ["XPHO"] | 700.0000 | 740.0000 | 0 | 272 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c5-6000-7140-967b-24ebec2d16ca | COST | 2026-09-18 14:26 | put_calendar | 2 | 1 | 20 | 536560.00 | short | ask | 896.0850 | 13.2500 | ["960"] | ["0.2853"] | [] | ["XMIO"] | 960.0000 | 960.0000 | 819 | 854 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:26:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b574-84c7-7a91-8b19-704d88548456 | COST | 2026-09-18 12:58 | call_diagonal_spread | 2 | 1 | 2 | 101746.00 | short | bid | 897.7500 | 15.2000 | ["520","860"] | ["0.2310","0.2283"] | [] | ["XCBO"] | 520.0000 | 860.0000 | 119 | 854 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:58:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afb6-80d3-7ee0-8ced-39519a28e75b | COST | 2026-09-17 10:12 | put_butterfly_spread | 3 | 1 | 4 | 122868.00 | short | bid | 890.1350 | 18.2500 | ["800","1000","1200"] | ["0.2543","0.2669","0.3624"] | ["875.50","1124.50"] | ["XCBO"] | 800.0000 | 1200.0000 | 365 | 365 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:12:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb6-c2b3-7103-bc9c-9f7027f8fe0e | COST | 2026-09-16 15:34 | put_condor | 4 | 1 | 2 | 110884.00 | short | bid | 893.7400 | 32.6000 | ["800","900","1000","1100"] | ["0.2745","0.2788","0.2905","0.3136"] | ["828.40","1071.60"] | ["XCBO"] | 800.0000 | 1100.0000 | 856 | 856 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacc-7253-7000-9041-c7e13e1643aa | COST | 2026-09-16 11:18 | put_vertical_spread | 2 | 1 | 15 | 110340.00 | short | bid | 900.1900 | 5.7000 | ["920","930"] | ["0.2594","0.2615"] | ["923.24"] | ["XCBO"] | 920.0000 | 930.0000 | 23 | 23 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:19:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa8f-2ebc-7212-aba9-081210e1c573 | COST | 2026-09-16 10:11 | call_vertical_spread | 2 | 1 | 4 | 137528.00 | short | bid | 897.0200 | 13.6500 | ["910","920"] | ["0.2584","0.2581"] | ["914.76"] | ["XMIO"] | 910.0000 | 920.0000 | 821 | 821 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:12:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a5-5d0e-7060-b271-9234f8831c1e | COST | 2026-09-15 15:57 | put_diagonal_spread | 2 | 1 | 24 | 366432.00 | short | ask | 900.3000 | 11.0500 | ["975","980"] | ["0.2368","0.3817"] | [] | ["XMIO"] | 975.0000 | 980.0000 | 10 | 17 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a635-b31e-7c63-a9c6-9d69052e137e | COST | 2026-09-15 13:55 | call_vertical_spread | 2 | 1 | 5 | 201540.00 | short | bid | 907.3200 | 9.8500 | ["700","900"] | ["0.2619","0.2514"] | ["831.50"] | ["XCBO"] | 700.0000 | 900.0000 | 493 | 493 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:56:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a03e-2150-7ba0-a134-e94a94a8994c | COST | 2026-09-14 10:06 | put_calendar | 2 | 1 | 13 | 151398.00 | short | bid | 913.6400 | 6.6000 | ["970"] | ["0.2664"] | [] | ["XMIO"] | 970.0000 | 970.0000 | 11 | 18 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:07:12Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08684-21b0-70e1-a7d6-d8da999701ae | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-21b0-70e1-a7d6-d8cd3df16032 | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08684-1dc8-7e80-8e44-9e0006244784 | COST | 2026-09-09 10:13 | call_condor | 4 | 1 | 5 | 169105.00 | short | bid | 906.3700 | 26.0000 | ["1000","1100","1200","1300"] | ["0.2560","0.2563","0.2547","0.2574"] | ["1015.73","1284.27"] | ["XCBO"] | 1000.0000 | 1300.0000 | 737 | 737 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:13:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081ed-6b20-71b1-9712-8a726303224a | COST | 2026-09-08 12:50 | call_vertical_spread | 2 | 1 | 3 | 108012.00 | short | bid | 908.5400 | 12.7500 | ["900","920"] | ["0.2583","0.2579"] | ["909.66"] | ["XMIO"] | 900.0000 | 920.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:50:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |