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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c442-97af-7db2-a2d4-979a0b893af5 | AMAT | 2026-09-21 09:58 | put_diagonal_spread | 2 | 1 | 14 | 151760.00 | short | bid | 456.2300 | 11.1000 | ["430","450"] | ["0.5372","0.5385"] | [] | ["XCBO"] | 430.0000 | 450.0000 | 151 | 207 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:58:27Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b56d-1a57-7841-88de-00f6257c9c75 | AMAT | 2026-09-18 12:50 | call_diagonal_spread | 2 | 1 | 10 | 409610.00 | short | ask | 434.9100 | 6.0000 | ["230","270"] | ["18.2025","0.5574"] | [] | ["XPHO"] | 230.0000 | 270.0000 | 0 | 490 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:50:38Z"} | 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 |
| 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 |
| 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 |
| 01a0827b-3401-73d2-be3c-2bed0a857baf | AMAT | 2026-09-08 15:25 | put_calendar | 2 | 1 | 100 | 120600.00 | short | ask | 471.6750 | 1.1700 | ["445"] | ["0.5729"] | [] | ["XCBO"] | 445.0000 | 445.0000 | 3 | 17 | false | true | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:25:40Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e4-9568-7a63-8932-92c0fe53bfb2 | AMAT | 2026-09-08 12:40 | put_calendar | 2 | 1 | 50 | 367738.00 | short | ask | 468.7100 | 11.0000 | ["500"] | ["0.5717"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 3 | 17 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:40:58Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081c3-51c8-74c3-adc1-2acc91053ff6 | AMAT | 2026-09-08 12:04 | call_diagonal_spread | 2 | 1 | 3 | 104628.00 | short | ask | 470.8000 | 17.4500 | ["360","500"] | ["0.5874","0.5875"] | [] | ["XCBO"] | 360.0000 | 500.0000 | 500 | 829 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:04:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 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 |