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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b600-3e4f-7e61-b7a6-6a9522d0cd97 | SPY | 2026-09-18 15:31 | strangle | 2 | 1 | 1500 | 289500.00 | long | ask | 760.7800 | 0.0200 | ["700","795"] | ["0.2090","0.1003"] | ["698.07","796.93"] | ["XPHO"] | 700.0000 | 795.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:31:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ff-586b-7e31-9149-1a14da29439a | SPY | 2026-09-17 16:11 | synthetic | 2 | 1 | 150 | 327900.00 | long | bid | 762.6431 | 0.5500 | ["775"] | ["0.1177"] | ["763"] | ["AMXO"] | 775.0000 | 775.0000 | 29 | 29 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T20:12:57Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e9-b943-7922-82cf-cfc7b4cd6641 | SPY | 2026-09-17 15:48 | straddle | 2 | 1 | 2250 | 1122750.00 | long | ask | 762.9250 | 0.0700 | ["760"] | ["0.1317"] | ["755.01","764.99"] | ["XPHO"] | 760.0000 | 760.0000 | 1 | 1 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:48:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b057-f0f3-7882-9e1c-ba4358361807 | SPY | 2026-09-17 13:09 | call_vertical_spread | 2 | 1 | 168 | 76944.00 | long | ask | 762.4900 | 0.0300 | ["759","762"] | ["0.1863","0.1280"] | ["761.62"] | ["SPHR"] | 759.0000 | 762.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:09:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afdd-2373-7ae0-bca8-be55ac519c78 | SPY | 2026-09-17 10:54 | call_ratio_spread | 2 | 3 | 3508 | 213952.00 | long | ask | 760.6700 | 0.0200 | ["764","767"] | ["0.1193","0.1260"] | ["764.18","769.81"] | ["AMXO"] | 764.0000 | 767.0000 | 1 | 1 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:55:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb1-b644-78f2-8b7a-356a837c22fe | SPY | 2026-09-17 10:07 | straddle | 2 | 2 | 900 | 2349000.00 | long | ask | 760.1900 | 0.3800 | ["735"] | ["0.4017"] | ["708.90","761.10"] | ["AMXO"] | 735.0000 | 735.0000 | 1 | 1 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:07:36Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abac-106c-7843-a327-f34a33903810 | SPY | 2026-09-16 15:22 | put_vertical_spread | 2 | 1 | 514 | 1859652.00 | long | ask | 750.3800 | 0.1300 | ["700","715"] | ["0.2042","0.1951"] | ["712.04"] | ["SPHR"] | 700.0000 | 715.0000 | 184 | 184 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:23:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab01-035b-7b10-8048-a1ae38415b96 | SPY | 2026-09-16 12:16 | synthetic | 2 | 2 | 300 | 1839900.00 | long | ask | 760.4750 | 3.6900 | ["700"] | ["0.5656"] | ["761.17"] | ["AMXO"] | 700.0000 | 700.0000 | 2 | 2 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:16:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aadb-4733-7733-9914-853b8275f120 | SPY | 2026-09-16 11:34 | risk_reversal | 2 | 1 | 36 | 185760.00 | long | ask | 760.0600 | 3.3900 | ["680","710"] | ["0.5859","0.6623"] | ["761.50"] | ["XBOX"] | 680.0000 | 710.0000 | 2 | 2 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:35:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a585-5a96-7d51-9e9b-e8af2aa03ad3 | SPY | 2026-09-15 10:42 | call_calendar | 2 | 1 | 500 | 1380500.00 | long | ask | 757.1001 | 0.0800 | ["760"] | ["0.1504"] | [] | ["XPHO"] | 760.0000 | 760.0000 | 3 | 94 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:43:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0bd-a5d9-71d0-ba6e-756ee21d2c0b | SPY | 2026-09-14 12:26 | put_vertical_spread | 2 | 1 | 1175 | 3937425.00 | long | ask | 762.0500 | 0.1600 | ["735","745"] | ["0.1779","0.1711"] | ["742.59"] | ["SPHR"] | 735.0000 | 745.0000 | 123 | 123 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:26:41Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02e-e2f8-7702-8428-228b81a85773 | SPY | 2026-09-14 09:50 | put_vertical_spread | 2 | 1 | 600 | 2194200.00 | long | ask | 760.4400 | 0.1900 | ["715","725"] | ["0.1962","0.1905"] | ["722.95"] | ["XPHO"] | 715.0000 | 725.0000 | 186 | 186 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:50:24Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f3-5110-7b83-a427-42419b451112 | SPY | 2026-09-11 15:30 | put_vertical_spread | 2 | 1 | 200 | 413600.00 | long | ask | 765.0750 | 0.0900 | ["705","710"] | ["0.1978","0.1942"] | ["709.30"] | ["SPHR"] | 705.0000 | 710.0000 | 126 | 126 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:30:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09133-9af0-76e0-9404-67a8fb88de68 | SPY | 2026-09-11 12:01 | call_diagonal_spread | 2 | 1 | 90 | 329760.00 | long | bid | 765.9000 | 0.3700 | ["750","763"] | ["0.1119","0.1304"] | [] | ["SPHR"] | 750.0000 | 763.0000 | 14 | 49 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:01:46Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ba-3ca0-7433-993c-777af98774e5 | SPY | 2026-09-11 09:48 | put_vertical_spread | 2 | 1 | 52 | 167856.00 | long | ask | 765.0100 | 0.1800 | ["750","770"] | ["0.1635","0.1496"] | ["763.22"] | ["SPHR"] | 750.0000 | 770.0000 | 70 | 70 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:48:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cd2-11a8-7502-ac5b-d8fb2871b240 | SPY | 2026-09-10 15:36 | put_diagonal_spread | 2 | 1 | 150 | 132600.00 | long | ask | 757.8200 | 0.0400 | ["761","762"] | ["0.1801","0.4203"] | [] | ["SPHR"] | 761.0000 | 762.0000 | 0 | 1 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:36:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cbf-c9f8-7bc3-8aad-ffeb51b5a60d | SPY | 2026-09-10 15:16 | synthetic | 2 | 2 | 500 | 850000.00 | long | ask | 757.7500 | 0.1500 | ["750"] | ["0.1751"] | ["757.70"] | ["AMXO"] | 750.0000 | 750.0000 | 8 | 8 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:16:43Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb2-d668-7f53-9264-68672f1b5916 | SPY | 2026-09-10 10:22 | call_vertical_spread | 2 | 1 | 757 | 3071149.00 | long | ask | 758.2800 | 0.2700 | ["880","890"] | ["0.1405","0.1388"] | ["882.77"] | ["XPHO"] | 880.0000 | 890.0000 | 463 | 463 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:22:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bb0-abb8-7372-b3c6-4825977eb133 | SPY | 2026-09-10 10:20 | put_vertical_spread | 2 | 1 | 1150 | 4356200.00 | long | ask | 758.0100 | 0.2100 | ["735","745"] | ["0.1802","0.1741"] | ["742.28"] | ["XPHO"] | 735.0000 | 745.0000 | 127 | 127 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:20:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0877f-7588-76e1-a972-94bb91de0d3e | SPY | 2026-09-09 14:47 | call_diagonal_spread | 2 | 1 | 72 | 1087272.00 | long | bid | 763.0900 | 3.2300 | ["680","765"] | ["0.3353","0.1651"] | [] | ["SPHR"] | 680.0000 | 765.0000 | 9 | 373 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:48:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0872e-fbf8-7451-b05d-e7e2979c7e77 | SPY | 2026-09-09 13:19 | put_vertical_spread | 2 | 1 | 200 | 73400.00 | long | ask | 762.8700 | 0.0300 | ["764","765"] | ["0.1343","0.1469"] | ["764.15"] | ["SPHR"] | 764.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:20:12Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086a0-0a38-71c3-a4ac-b76d155ebb34 | SPY | 2026-09-09 10:43 | put_diagonal_spread | 2 | 1 | 126 | 110124.00 | long | bid | 763.6700 | 0.0600 | ["765","768"] | ["0.1463","0.1265"] | [] | ["SPHR"] | 765.0000 | 768.0000 | 1 | 2 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:44:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08262-1651-7ef3-9319-e0127e969912 | SPY | 2026-09-08 14:57 | put_vertical_spread | 2 | 1 | 158 | 49454.00 | long | ask | 767.0300 | 0.0300 | ["750","765"] | ["0.1752","0.1352"] | ["762.69"] | ["SPHR"] | 750.0000 | 765.0000 | 3 | 3 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:58:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08196-d711-7881-bf08-fe6b09dfa904 | SPY | 2026-09-08 11:15 | risk_reversal | 2 | 1 | 260 | 1516060.00 | long | bid | 768.0050 | 0.1800 | ["730","845"] | ["0.2010","0.1405"] | ["726.67"] | ["XPHO"] | 730.0000 | 845.0000 | 374 | 374 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:15:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08168-cde9-7231-b2b6-04e3519ca561 | SPY | 2026-09-08 10:25 | iron_condor | 4 | 1 | 161 | 157297.00 | long | ask | 767.1099 | 0.0900 | ["745","750","780","785"] | ["0.1614","0.1552","0.0984","0.0960"] | ["748.15","781.85"] | ["SPHR"] | 745.0000 | 785.0000 | 17 | 17 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:25:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |