Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
active:ticker = APH×
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c464-4c97-7422-bdc6-03404ae6e233 | APH | 2026-09-21 10:35 | call_diagonal_spread | 2 | 2 | 34 | 255786.00 | short | bid | 80.1600 | 4.5971 | ["42.5","45"] | ["1.0519","0.4130"] | [] | ["XISX"] | 42.5000 | 45.0000 | 60 | 361 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:35:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c461-bc57-7923-b3c2-d275d1e1f3fb | APH | 2026-09-21 10:32 | call_diagonal_spread | 2 | 1 | 72 | 618912.00 | short | bid | 80.1800 | 4.1000 | ["37.5","40"] | ["0.9970","0.4115"] | [] | ["XCBO"] | 37.5000 | 40.0000 | 88 | 487 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:32:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c44d-e24e-72c0-9544-570b3a416303 | APH | 2026-09-21 10:10 | call_ladder | 3 | 3 | 322 | 842996.00 | long | bid | 79.3550 | 3.6000 | ["70","80","82.5"] | ["0.4775","0.4533","0.4513"] | ["92.52"] | ["XISX"] | 70.0000 | 82.5000 | 88 | 88 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:10:36Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b619-ec87-77a2-8ae7-a682801e4b7e | APH | 2026-09-18 15:59 | call_vertical_spread | 2 | 2 | 500 | 162500.00 | long | ask | 77.7800 | 0.4000 | ["80","87.5"] | ["0.4024","0.3886"] | ["81.95"] | ["XMIO"] | 80.0000 | 87.5000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b619-9a7f-7d62-b97e-b3d334f3fb4d | APH | 2026-09-18 15:58 | call_vertical_spread | 2 | 2 | 500 | 164500.00 | long | ask | 77.8100 | 0.5000 | ["80","87.5"] | ["0.4032","0.3915"] | ["81.95"] | ["XMIO"] | 80.0000 | 87.5000 | 28 | 28 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55b-1ce0-7252-8b68-b745e9501763 | APH | 2026-09-18 12:30 | other | 4 | 2 | 260 | 293040.00 | unknown | — | 78.8400 | 1.7000 | ["75","85","90"] | ["1.1207","0.3956","2.6878"] | [] | ["XCBO"] | 75.0000 | 90.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:31:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0c7-8f2b-75d1-8115-03be545c4314 | APH | 2026-09-17 15:11 | call_diagonal_spread | 2 | 1 | 354 | 587640.00 | unknown | — | 78.1700 | 1.5000 | ["67.5","72.5"] | ["0.3368","1.1420"] | [] | ["XPHO"] | 67.5000 | 72.5000 | 1 | 29 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:11:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a7-d9fb-78e1-b924-56bc0b2aead8 | APH | 2026-09-17 14:36 | put_ladder | 3 | 1 | 343 | 608536.00 | unknown | — | 78.1400 | 4.8000 | ["85","87.5","90"] | ["1.4403","2.4001","2.9376"] | [] | ["XBOX"] | 85.0000 | 90.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:36:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abca-4ab3-7f83-b2dc-dd44725b02b7 | APH | 2026-09-16 15:55 | put_calendar | 2 | 1 | 40 | 104000.00 | unknown | — | 77.1400 | 3.2000 | ["90"] | ["1.2948"] | [] | ["XBOX"] | 90.0000 | 90.0000 | 2 | 30 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:56:11Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab10-41b3-7a51-8f43-50be0d1d9184 | APH | 2026-09-16 12:32 | other | 3 | 1 | 56 | 213360.00 | unknown | — | 78.2275 | 3.2500 | ["50","95"] | ["0.5200","0.4889"] | [] | ["SPHR"] | 50.0000 | 95.0000 | 30 | 184 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:32:52Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a631-cb1d-7773-93f5-67601394a8aa | APH | 2026-09-15 13:51 | strangle | 2 | 2 | 350 | 420000.00 | unknown | — | 77.5350 | 1.0000 | ["70","90"] | ["0.4677","0.4552"] | [] | ["AMXO"] | 70.0000 | 90.0000 | 185 | 185 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:51:16Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5b3-86e6-7583-8b8f-ec9961d40ab2 | APH | 2026-09-15 11:33 | straddle | 2 | 2 | 136 | 107440.00 | long | ask | 77.3450 | 0.3000 | ["77.5"] | ["0.4398"] | ["69.6","85.40"] | ["ARCO","XBOX"] | 77.5000 | 77.5000 | 31 | 31 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:34:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08cb5-17b0-7150-ae2e-8a731119a545 | APH | 2026-09-10 15:04 | other | 2 | 1 | 2210 | 377860.00 | unknown | — | 80.1200 | 0.1500 | ["87.5","90"] | ["0.4102","0.4016"] | [] | ["XBOX"] | 87.5000 | 90.0000 | 8 | 36 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:04:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba7-7c29-7ba2-8f9f-7fde18b931ef | APH | 2026-09-10 10:10 | call_vertical_spread | 2 | 1 | 100 | 102200.00 | long | ask | 79.9200 | 1.4500 | ["70","87.5"] | ["0.4307","0.4403"] | ["79.8"] | ["XCBO"] | 70.0000 | 87.5000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:10:21Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08667-cfb0-75f2-a590-fb659dcc3ee1 | APH | 2026-09-09 09:42 | call_vertical_spread | 2 | 1 | 389 | 931655.00 | unknown | — | 81.9700 | 3.5000 | ["67.5","72.5"] | ["1.0744","0.3322"] | [] | ["XISX"] | 67.5000 | 72.5000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:32Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081a4-e0d0-77f1-9fee-d1f01fc65b5d | APH | 2026-09-08 11:30 | risk_reversal | 2 | 1 | 593 | 403833.00 | short | bid | 83.6400 | 0.4000 | ["75","95"] | ["0.5019","0.4796"] | ["95.05"] | ["SPHR"] | 75.0000 | 95.0000 | 73 | 73 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:31:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |