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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 01a0b0a6-3beb-7180-a3c6-fcb9fc4b6aa6 | SPY | 2026-09-17 14:34 | call_vertical_spread | 2 | 1 | 20 | 561960.00 | short | bid | 762.5419 | 5.8400 | ["520","724"] | ["4.0242","0.6509"] | ["724"] | ["XPHO"] | 520.0000 | 724.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:59Z"} | 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 |
| 01a0b008-560b-7200-9b00-3c417f573723 | SPY | 2026-09-17 11:42 | synthetic | 2 | 2 | 750 | 1619250.00 | short | bid | 762.3000 | 0.0600 | ["740"] | ["0.2594"] | ["761.33"] | ["AMXO"] | 740.0000 | 740.0000 | 1 | 1 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:42:26Z"} | 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 |
| 01a0aba9-9f6b-7971-a6ef-396e588060ce | SPY | 2026-09-16 15:20 | put_vertical_spread | 2 | 1 | 1175 | 4138350.00 | short | bid | 751.3200 | 0.3000 | ["725","735"] | ["0.1857","0.1783"] | ["732.58"] | ["XPHO"] | 725.0000 | 735.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-3684-74e1-918c-da00cab63d34 | SPY | 2026-09-16 15:15 | put_vertical_spread | 2 | 1 | 200 | 760000.00 | short | bid | 752.0400 | 0.4200 | ["760","770"] | ["0.1501","0.1486"] | ["763.80"] | ["SPHR"] | 760.0000 | 770.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:15:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba3-ee63-7ed0-84ab-b7adb6224315 | SPY | 2026-09-16 15:14 | put_vertical_spread | 2 | 1 | 60 | 101400.00 | short | bid | 751.3950 | 0.2900 | ["730","760"] | ["0.1980","0.1549"] | ["750.20"] | ["SPHR"] | 730.0000 | 760.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:14:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a610-48fe-7623-a31e-d2f264ac0392 | SPY | 2026-09-15 13:14 | call_diagonal_spread | 2 | 1 | 62 | 222518.00 | short | bid | 757.2400 | 2.2000 | ["740","741"] | ["0.3391","0.1526"] | [] | ["SPHR"] | 740.0000 | 741.0000 | 1 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:14:38Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a08c-2dc9-7853-808a-2b8787791c75 | SPY | 2026-09-14 11:32 | risk_reversal | 2 | 2 | 660 | 4387020.00 | short | bid | 759.5300 | 0.2100 | ["720","815"] | ["0.2062","0.1455"] | ["820.95"] | ["ARCO"] | 720.0000 | 815.0000 | 368 | 368 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:32:18Z"} | 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 |
| 01a09132-4b00-73c2-97c2-842e31850e21 | SPY | 2026-09-11 11:59 | put_vertical_spread | 2 | 1 | 60000 | 12600000.00 | short | bid | 765.7300 | 0.0200 | ["730","750"] | ["0.2139","0.1657"] | ["748.84"] | ["AMXO"] | 730.0000 | 750.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:59:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09111-bb11-7c80-9f8b-2c24a88bd9cc | SPY | 2026-09-11 11:24 | strangle | 2 | 2 | 300 | 145200.00 | short | bid | 765.6000 | 0.0200 | ["760","775"] | ["0.1501","0.0969"] | ["755.16","779.84"] | ["AMXO"] | 760.0000 | 775.0000 | 7 | 7 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:24:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d5-1b88-7620-8408-5bb80798c4d9 | SPY | 2026-09-11 10:17 | call_vertical_spread | 2 | 1 | 400 | 77200.00 | short | bid | 764.8200 | 0.0200 | ["765","766"] | ["0.1630","0.1585"] | ["765.45"] | ["SPHR"] | 765.0000 | 766.0000 | 0 | 0 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:18:22Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c4f-58d0-7b71-9f9c-455dcc1d5c61 | SPY | 2026-09-10 13:13 | strangle | 2 | 1 | 250 | 424500.00 | short | bid | 759.2900 | 0.1000 | ["746","770"] | ["0.1642","0.1236"] | ["729.02","786.98"] | ["XPHO"] | 746.0000 | 770.0000 | 36 | 36 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:13:39Z"} | 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 |
| 01a086f6-b1d0-7703-86f5-aeebf584159a | SPY | 2026-09-09 12:18 | put_vertical_spread | 2 | 1 | 200 | 36600.00 | short | bid | 761.4400 | 0.0200 | ["761","762"] | ["0.1440","0.1343"] | ["761.55"] | ["SPHR"] | 761.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-09T16:18:50Z"} | 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 |
| 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 |
| 01a0817f-e028-7230-b790-ab100d5f4380 | SPY | 2026-09-08 10:50 | risk_reversal | 2 | 2 | 500 | 3789500.00 | short | bid | 767.3850 | 0.4500 | ["685","790"] | ["0.2189","0.1554"] | ["822.15"] | ["AMXO"] | 685.0000 | 790.0000 | 374 | 374 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:50:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08146-2ab8-7143-ae8a-6974f1abb472 | SPY | 2026-09-08 09:47 | call_diagonal_spread | 2 | 1 | 16 | 237809.00 | short | bid | 767.3880 | 7.3500 | ["700","750"] | ["0.4035","0.1657"] | [] | ["XBOX"] | 700.0000 | 750.0000 | 10 | 374 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:47:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de0-16b5-7750-83c5-7c163e760318 | SPY | 2026-09-04 15:23 | call_vertical_spread | 2 | 1 | 400 | 1242400.00 | short | bid | 769.6800 | 0.3900 | ["768","770"] | ["0.1167","0.1158"] | ["769.20"] | ["SPHR"] | 768.0000 | 770.0000 | 49 | 49 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:23:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd2-95ad-75f0-976b-020a80c151e2 | SPY | 2026-09-04 15:08 | put_calendar | 2 | 1 | 25 | 151700.00 | short | bid | 769.6450 | 3.2500 | ["800"] | ["0.1735"] | [] | ["XPHO"] | 800.0000 | 800.0000 | 7 | 10 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |