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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ec-c5ef-75c2-872d-eac8be2a78ad | AMAT | 2026-09-18 15:09 | other | 4 | 1 | 865 | 1182455.00 | unknown | bid | 436.9000 | 2.4400 | ["435","445","457.5"] | ["0.8223","0.7210","0.4452"] | [] | ["XPHO"] | 435.0000 | 457.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:10:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b558-ea5f-7bc2-91fb-e7aaecd1cec6 | AMAT | 2026-09-18 12:28 | call_vertical_spread | 2 | 1 | 3 | 149712.00 | short | bid | 433.9300 | 13.7000 | ["175","195"] | ["20.7226","18.5190"] | ["194.98"] | ["XCBO"] | 175.0000 | 195.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:28:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0c5-06bb-7fc0-9ddb-7b4765422554 | AMAT | 2026-09-17 15:08 | call_vertical_spread | 2 | 1 | 100 | 1293500.00 | short | bid | 416.9600 | 10.7000 | ["350","400"] | ["0.5728","0.5510"] | ["383.07"] | ["XCBO"] | 350.0000 | 400.0000 | 64 | 64 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:08:19Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aba9-f55b-7b92-93c4-36a9d06ed4b2 | AMAT | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 13 | 394979.00 | short | bid | 412.7700 | 13.8000 | ["410","420"] | ["0.5614","0.5619"] | ["413.29"] | ["XCBO"] | 410.0000 | 420.0000 | 856 | 856 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a603-9ece-78e3-9ea5-7e7c79abf9e0 | AMAT | 2026-09-15 13:00 | put_calendar | 2 | 1 | 36 | 1064808.00 | short | bid | 418.6000 | 7.5500 | ["540"] | ["0.5971"] | [] | ["XCBO"] | 540.0000 | 540.0000 | 31 | 493 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:01:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55f-ae0e-78a0-98f3-3f97924b57cc | AMAT | 2026-09-15 10:01 | put_vertical_spread | 2 | 1 | 200 | 146600.00 | short | bid | 423.9500 | 0.3100 | ["350","360"] | ["0.5381","0.5287"] | ["358.83"] | ["XCBO"] | 350.0000 | 360.0000 | 31 | 31 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:01:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a556-6326-79a0-8403-f65db0e19709 | AMAT | 2026-09-15 09:51 | put_calendar | 2 | 1 | 20 | 570220.00 | long | bid | 423.1800 | 9.8500 | ["550"] | ["0.5758"] | [] | ["XCBO"] | 550.0000 | 550.0000 | 122 | 157 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:51:40Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a103-1f01-7731-aaea-958ca4cd69fd | AMAT | 2026-09-14 13:42 | call_vertical_spread | 2 | 1 | 7 | 319774.00 | short | bid | 426.9500 | 12.1000 | ["220","230"] | ["0.5830","0.5787"] | ["227.60"] | ["XCBO"] | 220.0000 | 230.0000 | 459 | 459 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:42:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c7-5650-7e31-bcb5-1dc280093f73 | AMAT | 2026-09-14 12:36 | call_vertical_spread | 2 | 1 | 10 | 342410.00 | short | bid | 428.2299 | 9.3000 | ["260","270"] | ["0.6139","0.6033"] | ["269.07"] | ["XMIO"] | 260.0000 | 270.0000 | 123 | 123 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a07a-2880-7d92-aa3d-10d435ae3a0f | AMAT | 2026-09-14 11:12 | call_diagonal_spread | 2 | 1 | 10 | 265789.00 | long | bid | 425.3100 | 12.0000 | ["500","520"] | ["0.5771","0.5716"] | [] | ["XCBO"] | 500.0000 | 520.0000 | 823 | 858 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:13:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-2c80-7d00-af88-dd7223df493d | AMAT | 2026-09-14 09:40 | synthetic | 2 | 2 | 4 | 108800.00 | short | bid | 419.9000 | 18.0000 | ["420"] | ["0.5832"] | ["455.66"] | ["XMIO"] | 420.0000 | 420.0000 | 823 | 823 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:57Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a081b8-5548-77d2-9dae-2bae5029f1b9 | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b8-5160-7a62-aa44-f63cd74413be | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b8-5160-7a62-aa44-f62384b80bbe | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:52:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813b-8bf8-7201-b7e6-3d12dfc57f4f | AMAT | 2026-09-08 09:35 | put_vertical_spread | 2 | 1 | 5 | 232645.00 | short | bid | 463.4150 | 16.5000 | ["610","620"] | ["0.5892","0.5902"] | ["612.81"] | ["XCBO"] | 610.0000 | 620.0000 | 829 | 829 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:36:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08139-45f0-7073-94d6-56ed8d4d0437 | AMAT | 2026-09-08 09:33 | call_backspread | 2 | 1 | 26 | 110630.00 | long | bid | 468.3800 | 8.9500 | ["440","720"] | ["0.5547","0.5889"] | ["496.22","943.78"] | ["XMIO"] | 440.0000 | 720.0000 | 101 | 101 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:33:29Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |