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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a081b6-af68-7c62-95fa-b7a1f3d03b0d | XLV | 2026-09-08 11:50 | put_vertical_spread | 2 | 1 | 10000 | 3120000.00 | unknown | — | 167.2350 | 0.8800 | ["150","157"] | ["0.1970","0.1893"] | [] | ["SPHR"] | 150.0000 | 157.0000 | 101 | 101 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:50:48Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ba-5500-7673-b7e5-d5e2436e5ce9 | XLV | 2026-09-08 11:54 | other | 4 | 1 | 6 | 40368.00 | unknown | — | 167.1600 | 5.0800 | ["100","135","136","147"] | ["0.4404","0.9597","0.2732","0.1936"] | [] | ["XPHO"] | 100.0000 | 147.0000 | 10 | 101 | false | false | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:54:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08220-bbd8-7952-a753-7fce438b7b6c | XLV | 2026-09-08 13:46 | other | 2 | 1 | 52 | 56992.00 | unknown | — | 167.8700 | 0.6600 | ["170","180"] | ["0.1582","0.1511"] | [] | ["XISX"] | 170.0000 | 180.0000 | 129 | 192 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:46:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08222-3e90-7aa3-877e-e40780d39286 | XLV | 2026-09-08 13:47 | other | 2 | 1 | 41 | 44936.00 | unknown | — | 167.9200 | 0.6600 | ["170","180"] | ["0.1576","0.1507"] | [] | ["BATO"] | 170.0000 | 180.0000 | 129 | 192 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08bff-1dc0-7c73-9bf9-02df894ee67f | XLV | 2026-09-10 11:45 | call_vertical_spread | 2 | 1 | 52 | 456664.00 | unknown | — | 165.9100 | 1.6000 | ["120","125"] | ["0.8637","0.7759"] | [] | ["XBOX"] | 120.0000 | 125.0000 | 15 | 15 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:46:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0914d-9748-7402-a419-5b0a2799a9ee | XLV | 2026-09-11 12:29 | other | 2 | 2 | 12 | 78696.00 | unknown | — | 165.5600 | 4.8500 | ["134","135"] | ["0.2215","0.2839"] | [] | ["XMIO"] | 134.0000 | 135.0000 | 98 | 126 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:29:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a592-fec6-7e92-8f3f-0a239d9f8f5c | XLV | 2026-09-15 10:57 | call_diagonal_spread | 2 | 1 | 14 | 54796.00 | unknown | — | 166.9700 | 2.1000 | ["145","155"] | ["0.7171","0.1504"] | [] | ["MCRY"] | 145.0000 | 155.0000 | 3 | 185 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:57:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ee-78be-7ab0-89e4-ffca68255e41 | XLV | 2026-09-15 12:37 | call_diagonal_spread | 2 | 2 | 20 | 62060.00 | unknown | — | 167.9400 | 1.2563 | ["152","155"] | ["0.5858","0.1460"] | [] | ["XISX"] | 152.0000 | 155.0000 | 3 | 94 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:37:44Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a650-d086-7283-b1b8-ef0cc7ae9cde | XLV | 2026-09-15 14:25 | iron_condor | 4 | 1 | 205 | 178999.00 | unknown | — | 167.7400 | 2.5800 | ["162","169"] | ["0.3088","0.2252"] | [] | ["SPHR"] | 162.0000 | 169.0000 | 3 | 3 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:25:43Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa72-a9f3-7961-be94-f36f1bd4992b | XLV | 2026-09-16 09:40 | call_vertical_spread | 2 | 1 | 10 | 58060.00 | unknown | — | 168.2350 | 3.5500 | ["120","200"] | ["0.3174","0.1500"] | [] | ["XCBO"] | 120.0000 | 200.0000 | 492 | 492 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:40:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaaf-ed8b-7b83-83e5-8ee27722bccf | XLV | 2026-09-16 10:47 | put_vertical_spread | 2 | 2 | 206 | 34196.00 | unknown | — | 168.1500 | 0.5100 | ["140","155"] | ["0.2190","0.1904"] | [] | ["C2OX","EDGO"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:47:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab0-c84b-7831-be26-c49dab40f0f0 | XLV | 2026-09-16 10:48 | put_vertical_spread | 2 | 1 | 187 | 28798.00 | unknown | — | 168.1500 | 0.4000 | ["140","155"] | ["0.2037","0.1889"] | [] | ["XBOX"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:48:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aab0-d403-7350-84a4-4b7db3c8ba46 | XLV | 2026-09-16 10:48 | put_vertical_spread | 2 | 1 | 369 | 62730.00 | unknown | — | 168.1500 | 0.3500 | ["140","155"] | ["0.2175","0.1928"] | [] | ["XCBO"] | 140.0000 | 155.0000 | 93 | 93 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:48:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b530-e447-7863-90ef-df1e403fab41 | XLV | 2026-09-18 11:44 | call_diagonal_spread | 2 | 1 | 10 | 26790.00 | unknown | bid | 168.1800 | 2.2400 | ["150","170"] | ["0.1473","0.1273"] | [] | ["XCBO"] | 150.0000 | 170.0000 | 7 | 364 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:45:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b539-0e20-74c1-a470-688ee6a0345c | XLV | 2026-09-18 11:53 | put_ratio_spread | 2 | 1 | 15000 | 5200000.00 | unknown | bid | 167.9800 | 1.8700 | ["90","135"] | ["0.2687","0.2198"] | ["6.20","131.90"] | ["ARCO"] | 90.0000 | 135.0000 | 854 | 854 | true | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:53:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5db-2638-70e0-8b86-aba972f01f82 | XLV | 2026-09-18 14:50 | call_ladder | 6 | 1 | 5 | 127220.00 | unknown | bid | 168.8500 | 6.4000 | ["90","95","100","155","158","159"] | ["1.9959","1.8323","1.6771","0.3287","0.2653","0.2075"] | ["134.40","168.80"] | ["XPHO"] | 90.0000 | 159.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:50:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e3-9277-7513-a594-622890c7e896 | XLV | 2026-09-18 14:59 | call_diagonal_spread | 2 | 1 | 45 | 26685.00 | unknown | bid | 168.7900 | 0.9000 | ["166","172"] | ["1.3497","0.1471"] | [] | ["XISX"] | 166.0000 | 172.0000 | 0 | 63 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:00:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-5eef-72e3-adf0-f1b0ca5c81c3 | XLV | 2026-09-18 15:50 | call_diagonal_spread | 2 | 1 | 30 | 203460.00 | unknown | ask | 168.6100 | 4.8500 | ["130","140"] | ["0.9734","0.5700"] | [] | ["XPHO"] | 130.0000 | 140.0000 | 7 | 28 | true | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-7277-7261-929f-a8b8702423f9 | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 30 | 255000.00 | unknown | ask | 168.5850 | 3.1000 | ["100","152.5"] | ["1.6029","0.3465"] | ["168.75"] | ["XPHO"] | 100.0000 | 152.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-85ff-7aa0-97da-881864bf12aa | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 40 | 368960.00 | unknown | ask | 168.5600 | 2.1500 | ["110","135"] | ["1.7134","1.0055"] | ["168.62"] | ["XPHO"] | 110.0000 | 135.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-8dd0-7fa1-81fc-7d4f363c4e77 | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 15 | 107010.00 | unknown | ask | 168.5600 | 2.7000 | ["115","151"] | ["1.0323","0.6037"] | ["168.67"] | ["XPHO"] | 115.0000 | 151.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-9d6f-7561-a9c3-39d1f8d69249 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 10 | 72320.00 | unknown | ask | 168.5900 | 2.8500 | ["115","150"] | ["1.6004","0.4183"] | [] | ["XPHO"] | 115.0000 | 150.0000 | 7 | 14 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-a53f-7d83-8365-d23d2cc83620 | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 31830.00 | unknown | ask | 168.6100 | 4.3500 | ["120","154"] | ["0.8215","0.3397"] | [] | ["XPHO"] | 120.0000 | 154.0000 | 14 | 28 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b612-b0f8-7421-8617-65e629495d4a | XLV | 2026-09-18 15:51 | call_diagonal_spread | 2 | 1 | 5 | 68800.00 | unknown | ask | 168.5850 | 4.2000 | ["90","110"] | ["0.8741","1.4075"] | [] | ["XPHO"] | 90.0000 | 110.0000 | 7 | 21 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b613-0acf-7de1-a653-d697bfc61bfe | XLV | 2026-09-18 15:51 | call_vertical_spread | 2 | 1 | 90 | 537660.00 | unknown | bid | 168.5600 | 1.9000 | ["120","157.5"] | ["1.3764","0.4237"] | ["168.62"] | ["XPHO"] | 120.0000 | 157.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:51:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |