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 |
| 01a0b55e-ce2f-7cb0-842d-af2bfba709e2 | SPY | 2026-09-18 12:34 | synthetic | 2 | 1 | 917 | 165060.00 | short | ask | 759.2050 | 0.0200 | ["760"] | ["0.1406"] | ["759.02"] | ["AMXO"] | 760.0000 | 760.0000 | 0 | 0 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:35:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fb-8050-7cb2-994a-1ce76f3b6baf | SPY | 2026-09-18 10:46 | put_vertical_spread | 2 | 3 | 850 | 433925.00 | unknown | ask | 759.1150 | 0.0400 | ["695","700"] | ["0.2125","0.2056"] | ["694.95"] | ["AMXO"] | 695.0000 | 700.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:46:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 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 |
| 01a0b053-803b-7dd2-818e-441b64bdd948 | SPY | 2026-09-17 13:04 | put_calendar | 2 | 1 | 355 | 192765.00 | short | ask | 762.5300 | 0.0600 | ["750"] | ["0.1425"] | [] | ["SPHR"] | 750.0000 | 750.0000 | 11 | 12 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:04:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b024-0fb3-7f90-bc73-221d14796198 | SPY | 2026-09-17 12:12 | put_calendar | 2 | 2 | 1000 | 1178000.00 | short | ask | 762.2500 | 0.0600 | ["760"] | ["0.1683"] | [] | ["AMXO"] | 760.0000 | 760.0000 | 1 | 29 | false | true | true | false | false | mlft | 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 |
| 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 |
| 01a0af9b-53cb-7ad2-9644-f3ca176503cd | SPY | 2026-09-17 09:43 | put_calendar | 2 | 1 | 330 | 195690.00 | short | ask | 760.9799 | 0.0700 | ["750"] | ["0.1532"] | [] | ["SPHR"] | 750.0000 | 750.0000 | 8 | 11 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:43:08Z"} | 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 |
| 01a0a023-9470-79d1-b4f3-57169fa3be79 | SPY | 2026-09-14 09:37 | call_diagonal_spread | 2 | 1 | 14 | 241304.00 | short | ask | 758.5700 | 3.9400 | ["660","750"] | ["0.2609","0.1668"] | [] | ["XBOX"] | 660.0000 | 750.0000 | 95 | 276 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:02Z"} | 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 |
| 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 |
| 01a08767-7118-7601-bf85-646d68edfcd5 | SPY | 2026-09-09 14:21 | call_diagonal_spread | 2 | 1 | 53 | 746558.00 | short | ask | 762.8100 | 2.5600 | ["690","765"] | ["0.3465","0.1650"] | [] | ["SPHR"] | 690.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:21:41Z"} | 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 |
| 01a08295-1cd0-7a72-ab2d-2eb7ddddcb07 | SPY | 2026-09-08 15:53 | put_diagonal_spread | 2 | 1 | 110 | 78760.00 | short | ask | 765.8450 | 0.0600 | ["768","770"] | ["0.1023","1.1270"] | [] | ["SPHR"] | 768.0000 | 770.0000 | 0 | 1 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:53:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |
| 01a081a9-97d8-78b1-8af4-7552bd6d3c4c | SPY | 2026-09-08 11:36 | risk_reversal | 2 | 1 | 390 | 2304510.00 | short | ask | 767.4600 | 0.1600 | ["725","840"] | ["0.2033","0.1415"] | ["724.33"] | ["XPHO"] | 725.0000 | 840.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:36:18Z"} | 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 |