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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06dc9-2b86-7150-8fc7-b1e5dad69838 | FCX | 2026-09-04 14:58 | call_diagonal_spread_bearish | 2 | 1 | 133 | 245385.00 | long | bid | 72.8800 | 1.8500 | ["62","66"] | ["8.8144","0.4799"] | [] | ["EDGO"] | 62.0000 | 66.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:58:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfe-06c5-7952-aeb3-f20af38c9a7f | FCX | 2026-09-04 15:55 | call_frontspread | 2 | 2 | 26 | 157396.00 | long | bid | 72.7000 | 3.8000 | ["50","55"] | ["0.4496","0.4554"] | ["50.08","114.00"] | ["XMIO"] | 50.0000 | 55.0000 | 833 | 833 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0816e-38a0-7452-b834-7e9cd7d05244 | FCX | 2026-09-08 10:31 | call_diagonal_spread | 2 | 1 | 1300 | 1049100.00 | long | bid | 78.0050 | 0.5500 | ["85","95"] | ["0.5130","0.5170"] | [] | ["XMIO"] | 85.0000 | 95.0000 | 73 | 101 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:31:34Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08703-38d8-7a31-b2e1-028668eb5007 | FCX | 2026-09-09 12:32 | call_backspread | 2 | 2 | 204 | 102680.00 | long | bid | 76.5850 | 0.1796 | ["80","82.5"] | ["0.4937","0.4972"] | ["88.60"] | ["ARCO","EDGO"] | 80.0000 | 82.5000 | 37 | 37 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:32:33Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c61-d348-75b3-89c1-fb5710937e06 | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 333 | 442224.00 | short | bid | 70.8800 | 1.5500 | ["77"] | ["0.8473"] | [] | ["XMIO"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:33:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c61-d348-75b3-89c1-fb44c02ea5ea | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 333 | 441306.00 | short | bid | 70.8700 | 1.5500 | ["77"] | ["0.8126"] | [] | ["EDGO"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:33:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c61-d348-75b3-89c1-fb3042582f24 | FCX | 2026-09-10 13:33 | put_calendar | 2 | 1 | 334 | 439230.00 | short | bid | 70.9100 | 1.6000 | ["77"] | ["0.8834"] | [] | ["XBOX"] | 77.0000 | 77.0000 | 1 | 15 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:33:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090d8-a5c8-7b82-8c74-cb6005311bbe | FCX | 2026-09-11 10:21 | call_calendar | 2 | 1 | 108 | 145152.00 | long | bid | 72.0100 | 2.0500 | ["66"] | ["0.5772"] | [] | ["XCBO"] | 66.0000 | 66.0000 | 7 | 14 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:22:03Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e6-ed30-78f2-a279-04aaa53850a2 | FCX | 2026-09-11 15:17 | synthetic | 2 | 1 | 200 | 548000.00 | short | bid | 71.2299 | 2.1500 | ["70"] | ["0.4933"] | ["73.80"] | ["XPHO"] | 70.0000 | 70.0000 | 371 | 371 | true | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:17:24Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0afde-f063-7442-96a8-a0222551880f | FCX | 2026-09-17 10:56 | call_calendar | 2 | 1 | 18 | 115308.00 | short | bid | 70.9000 | 3.5500 | ["50"] | ["0.4656"] | [] | ["XCBO"] | 50.0000 | 50.0000 | 820 | 855 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:57:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b090-cba3-7861-94f6-38f0b0cc9a42 | FCX | 2026-09-17 14:11 | call_diagonal_spread | 2 | 1 | 1000 | 403000.00 | short | bid | 70.9900 | 0.3300 | ["70","80"] | ["0.5313","0.4739"] | [] | ["XCBO"] | 70.0000 | 80.0000 | 1 | 64 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:11:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b4-16cb-7ed3-870f-6c9dc6237a83 | FCX | 2026-09-17 14:49 | call_calendar | 2 | 1 | 45 | 151065.00 | long | bid | 70.9550 | 1.0500 | ["55"] | ["1.3627"] | [] | ["AMXO"] | 55.0000 | 55.0000 | 1 | 92 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:49:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4bc-4c9f-7802-9310-3ea3d16f9f2f | FCX | 2026-09-18 09:37 | call_diagonal_spread | 2 | 1 | 5128 | 14003780.00 | unknown | bid | 70.9900 | 3.2000 | ["38","85"] | ["0.8824","0.4863"] | [] | ["EDGO"] | 38.0000 | 85.0000 | 119 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:37:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c42e-f83f-7ab1-939e-c011d2e2a2f3 | FCX | 2026-09-21 09:36 | call_diagonal_spread | 2 | 1 | 3029 | 7864491.00 | unknown | bid | 72.4940 | 1.9000 | ["38","85"] | ["0.7897","0.4827"] | [] | ["XCBO"] | 38.0000 | 85.0000 | 116 | 487 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:36:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c506-c657-72f2-89b6-c199d58fc3a6 | FCX | 2026-09-21 13:32 | call_diagonal_spread | 2 | 1 | 72 | 246384.00 | long | bid | 71.7450 | 1.5500 | ["55","60"] | ["0.5028","0.4762"] | [] | ["ARCO"] | 55.0000 | 60.0000 | 88 | 151 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:32:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |