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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4d4-9e7f-7e41-bf83-da23a98f241f | XLV | 2026-09-21 12:37 | call_vertical_spread | 2 | 1 | 2 | 26426.00 | long | ask | 168.6200 | 3.5500 | ["100","105"] | ["1.3333","1.2597"] | ["104.97"] | ["XMIO"] | 100.0000 | 105.0000 | 18 | 18 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:37:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5e5-d0af-73f2-95fb-7c2e3f1aae42 | XLV | 2026-09-18 15:02 | call_diagonal_spread | 2 | 1 | 15 | 56385.00 | long | ask | 168.7800 | 2.6000 | ["152","165"] | ["0.1479","0.1414"] | [] | ["XISX"] | 152.0000 | 165.0000 | 119 | 490 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:24Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a578-a4ae-7270-bcf6-c067ca96d988 | XLV | 2026-09-15 10:28 | call_diagonal_spread | 2 | 1 | 25 | 95975.00 | long | ask | 166.7800 | 6.4000 | ["165","175"] | ["0.1538","0.1479"] | [] | ["ARCO"] | 165.0000 | 175.0000 | 493 | 857 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:29:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a043-7c69-7653-a328-90ba0cc88243 | XLV | 2026-09-14 10:12 | call_vertical_spread | 2 | 1 | 2 | 32012.00 | long | ask | 167.1000 | 2.2500 | ["85","90"] | ["3.2958","3.0688"] | ["89.98"] | ["XMIO"] | 85.0000 | 90.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:13:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08756-c778-7163-a9cd-0b062b8f3edc | XLV | 2026-09-09 14:03 | call_diagonal_spread | 2 | 1 | 23 | 90459.00 | long | bid | 166.7200 | 2.5000 | ["147","150"] | ["0.4655","0.1551"] | [] | ["XCBO"] | 147.0000 | 150.0000 | 9 | 128 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:04:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081e2-a169-7f81-8a41-5cca6432067a | XLV | 2026-09-08 12:38 | call_vertical_spread | 2 | 1 | 12 | 132840.00 | long | ask | 167.7200 | 3.2000 | ["110","115"] | ["2.0091","1.8657"] | ["114.98"] | ["XISX"] | 110.0000 | 115.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:38:28Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081df-6160-7f73-91f9-18d06de56f32 | XLV | 2026-09-08 12:34 | call_vertical_spread | 2 | 1 | 11 | 198924.00 | long | ask | 167.8000 | 2.9000 | ["75","80"] | ["1.7880","1.7198"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:34:56Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d3-ff51-7cf0-b0c0-3f61ba1bea93 | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 2 | 36168.00 | long | ask | 167.5550 | 2.9000 | ["75","80"] | ["2.3198","2.1663"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:22:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d87-57f5-7012-b9dd-7f8393e94e33 | XLV | 2026-09-04 13:46 | call_diagonal_spread_bearish | 2 | 1 | 5 | 27655.00 | long | bid | 171.4900 | 2.7500 | ["144","146"] | ["0.5226","0.1896"] | [] | ["XCBO"] | 144.0000 | 146.0000 | 14 | 133 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:46:38Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |