Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 rowsexportable
active:ticker = JD×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0ca58-8f87-79c1-b59c-f38ddd36031a | JD | 2026-09-22 14:19 | strangle | 2 | 1 | 3000 | 1194000.00 | long | ask | 27.3800 | 0.1700 | ["20","35"] | ["0.4203","0.3559"] | ["16.02","38.98"] | ["ARCO"] | 20.0000 | 35.0000 | 486 | 486 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:20:01Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c97b-2bbf-7b33-8512-a4bdb5978d7f | JD | 2026-09-22 10:18 | call_calendar | 2 | 1 | 825 | 177375.00 | short | ask | 27.3600 | 0.2500 | ["26.5"] | ["0.3968"] | [] | ["BATO"] | 26.5000 | 26.5000 | 3 | 10 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T14:18:23Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0b507-672f-7720-bc1f-486720c3c0d7 | JD | 2026-09-18 10:59 | call_calendar | 2 | 1 | 565 | 242385.00 | unknown | ask | 26.9650 | 0.2200 | ["25"] | ["0.8915"] | [] | ["XPHO"] | 25.0000 | 25.0000 | 0 | 28 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b504-84e7-7ab1-ba5f-6ffb875f769a | JD | 2026-09-18 10:56 | call_calendar | 2 | 1 | 2000 | 854002.00 | short | ask | 26.9650 | 0.2700 | ["25"] | ["1.3078"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 0 | 28 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b500-6e07-7900-94a9-f889898c3f13 | JD | 2026-09-18 10:51 | call_calendar | 2 | 1 | 290 | 124120.00 | short | bid | 26.9719 | 0.2700 | ["25"] | ["1.2644"] | [] | ["XMIO"] | 25.0000 | 25.0000 | 0 | 28 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:51:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0a5-1adb-7000-9077-be7ab371a3d9 | JD | 2026-09-17 14:33 | put_diagonal_spread | 2 | 1 | 1004 | 829304.00 | unknown | — | 26.7050 | 0.8500 | ["29","33"] | ["1.2412","0.5978"] | [] | ["XBOX"] | 29.0000 | 33.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:33:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a5-036a-7e00-a527-160907c1373a | JD | 2026-09-17 14:33 | put_vertical_spread | 2 | 1 | 2735 | 2395860.00 | unknown | — | 26.7050 | 0.6000 | ["29","33"] | ["1.2412","2.5114"] | [] | ["XBOX"] | 29.0000 | 33.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:33:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a4-efe3-7033-b312-1e9f88da1d90 | JD | 2026-09-17 14:33 | put_vertical_spread | 2 | 1 | 4227 | 4945590.00 | unknown | — | 26.7050 | 0.6500 | ["32","33"] | ["2.0432","2.3141"] | [] | ["XBOX"] | 32.0000 | 33.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:33:42Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a1-32db-7fa1-a0c8-71e8c6d4564d | JD | 2026-09-17 14:29 | other | 4 | 1 | 1760 | 1920300.00 | unknown | — | 26.7350 | 1.5500 | ["30","32","33","34"] | ["1.5840","2.2145","2.5022","3.2766"] | [] | ["XBOX"] | 30.0000 | 34.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:29:07Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba5-f9d3-7611-ac32-67f263438670 | JD | 2026-09-16 15:16 | ratio_risk_reversal | 2 | 3 | 7911 | 843750.00 | long | bid | 26.8900 | 0.1800 | ["27","33"] | ["0.3408","0.3860"] | ["26.70"] | ["AMXO","ARCO","XPHO"] | 27.0000 | 33.0000 | 93 | 93 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-f9d3-7611-ac32-67ebbab4cb48 | JD | 2026-09-16 15:16 | ratio_risk_reversal | 2 | 5 | 13011 | 1385798.00 | long | bid | 26.9000 | 0.1800 | ["27","33"] | ["0.3412","0.3853"] | ["26.7"] | ["C2OX","EDGO","XCBO","XMIO","XPHO"] | 27.0000 | 33.0000 | 93 | 93 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab32-b21b-73d3-93c4-ebac4de84d70 | JD | 2026-09-16 13:10 | synthetic | 2 | 2 | 500 | 271000.00 | short | ask | 26.9250 | 0.1300 | ["28"] | ["0.3524"] | ["27.50"] | ["ARCO"] | 28.0000 | 28.0000 | 184 | 184 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:11:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1f-baa3-7930-a7f7-01ae76db0800 | JD | 2026-09-16 12:49 | straddle | 2 | 1 | 1400 | 1771000.00 | short | bid | 26.9281 | 1.7500 | ["32"] | ["0.3824"] | ["19.35","44.65"] | ["SPHR"] | 32.0000 | 32.0000 | 821 | 821 | true | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:50:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa78-244b-7283-afc9-052287e1097e | JD | 2026-09-16 09:46 | call_ratio_spread | 2 | 1 | 1000 | 119750.00 | unknown | — | 26.8850 | 1.5000 | ["26.5","27"] | ["0.3543","0.3711"] | [] | ["AMXO"] | 26.5000 | 27.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:46:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a678-bb46-7061-979d-8589409c7d59 | JD | 2026-09-15 15:08 | synthetic | 2 | 3 | 641 | 361524.00 | long | bid | 27.1050 | 0.4090 | ["29"] | ["0.3532"] | ["27.83"] | ["ARCO","MCRY","XBOX"] | 29.0000 | 29.0000 | 185 | 185 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a644-1e86-7ec3-a77c-dcf3a40e839d | JD | 2026-09-15 14:11 | synthetic | 2 | 5 | 219 | 124830.00 | long | bid | 27.1650 | 0.4073 | ["29"] | ["0.3573"] | ["27.90"] | ["ARCO","EMLD","XBOX","XISX"] | 29.0000 | 29.0000 | 185 | 185 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:11:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a546-9c15-7c10-bd1f-9a96fff12992 | JD | 2026-09-15 09:34 | call_calendar | 2 | 1 | 660 | 459360.00 | unknown | — | 27.3300 | 0.5000 | ["24"] | ["0.6108"] | [] | ["XPHO"] | 24.0000 | 24.0000 | 3 | 31 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:34:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a119-3b28-7fe2-8ad2-b897d0c7220d | JD | 2026-09-14 14:06 | synthetic | 2 | 4 | 223 | 128894.00 | long | bid | 27.3811 | 0.7282 | ["29"] | ["0.3601"] | ["28.17"] | ["ARCO","MCRY","XBOX","XMIO"] | 29.0000 | 29.0000 | 186 | 186 | true | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:06:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09180-43f0-79e2-a8cf-c10ba911b41a | JD | 2026-09-11 13:24 | other | 2 | 1 | 140 | 143260.00 | unknown | — | 27.1350 | 0.5500 | ["32","36"] | ["0.3667","0.4359"] | [] | ["XMIO"] | 32.0000 | 36.0000 | 98 | 98 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:24:57Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090e4-bb88-7b70-bf8d-61aa541b209e | JD | 2026-09-11 10:35 | put_frontspread | 2 | 1 | 96 | 113920.00 | long | ask | 27.1850 | 0.7500 | ["33","36"] | ["0.3698","0.4448"] | ["26.78"] | ["AMXO"] | 33.0000 | 36.0000 | 98 | 98 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:35:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ca0-1c98-73d0-acc4-09d8315560ac | JD | 2026-09-10 14:41 | other | 4 | 1 | 1206 | 621320.00 | unknown | — | 26.9650 | 0.8000 | ["28","29","29.5","31"] | ["0.5968","0.9164","1.4624","0.6384"] | [] | ["XBOX"] | 28.0000 | 31.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:42:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08729-fab8-7680-b962-66f529671fd0 | JD | 2026-09-09 13:14 | other | 2 | 1 | 80 | 102320.00 | unknown | — | 26.9545 | 1.0000 | ["32","33"] | ["0.4327","0.4512"] | [] | ["ARCO"] | 32.0000 | 33.0000 | 44 | 281 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:14:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08702-98b0-7360-9ec5-2cb68305053d | JD | 2026-09-09 12:31 | other | 2 | 1 | 135 | 191705.00 | unknown | — | 26.9600 | 1.1500 | ["34","35"] | ["0.4931","0.4489"] | [] | ["XISX"] | 34.0000 | 35.0000 | 37 | 499 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:31:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081db-5638-72d3-8e1f-9aa5948dda0e | JD | 2026-09-08 12:30 | risk_reversal | 2 | 1 | 307 | 112976.00 | unknown | — | 27.4450 | 0.1100 | ["28","29"] | ["0.3486","0.3572"] | [] | ["XBOX"] | 28.0000 | 29.0000 | 101 | 101 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:30:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d8-f0f0-7d72-b0ca-57dee7f2327d | JD | 2026-09-08 12:27 | risk_reversal | 2 | 4 | 292 | 108132.00 | long | bid | 27.4400 | 0.1100 | ["28","29"] | ["0.3502","0.3596"] | ["27.4"] | ["ARCO","EMLD","SPHR","XBOX"] | 28.0000 | 29.0000 | 101 | 101 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:28:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d1-c8e9-7391-8015-8f7d35c59a75 | JD | 2026-09-08 12:20 | strangle | 2 | 7 | 406 | 150616.00 | short | bid | 27.4400 | 0.0600 | ["28","29"] | ["0.3508","0.3602"] | ["24.29","32.71"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR","XBOX"] | 28.0000 | 29.0000 | 101 | 101 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:20:23Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |