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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5a3-b2e7-7850-99df-cf10b905b9ff | AMAT | 2026-09-18 13:49 | call_vertical_spread | 2 | 2 | 44 | 119284.00 | long | ask | 436.0900 | 1.9000 | ["550","680"] | ["0.5301","0.5576"] | ["563.21"] | ["XPHO"] | 550.0000 | 680.0000 | 119 | 119 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b536-fec7-7073-8286-4bcf7a307056 | AMAT | 2026-09-18 11:51 | call_vertical_spread | 2 | 1 | 2 | 111328.00 | long | ask | 436.2000 | 13.6500 | ["155","160"] | ["28.3652","27.6591"] | ["160"] | ["XCBO"] | 155.0000 | 160.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:51:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a144-c798-7082-b5ff-27fb7a2cb52f | AMAT | 2026-09-14 14:53 | call_vertical_spread | 2 | 2 | 8 | 125956.00 | long | ask | 428.7600 | 4.6500 | ["350","430"] | ["0.5522","0.5418"] | ["396.12"] | ["ARCO","XISX"] | 350.0000 | 430.0000 | 123 | 123 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:54:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a144-c3b0-7681-a231-c480e4992f02 | AMAT | 2026-09-14 14:53 | call_vertical_spread | 2 | 2 | 16 | 251880.00 | long | ask | 428.7600 | 4.2000 | ["350","430"] | ["0.5522","0.5415"] | ["396.16"] | ["ARCO","XISX"] | 350.0000 | 430.0000 | 123 | 123 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:54:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091a4-5650-7212-8eb7-542188645439 | AMAT | 2026-09-11 14:04 | call_vertical_spread | 2 | 2 | 15 | 116775.00 | long | ask | 461.0800 | 3.2000 | ["500","550"] | ["0.5511","0.5503"] | ["514.95"] | ["C2OX"] | 500.0000 | 550.0000 | 126 | 126 | false | true | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:04:32Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09145-8cb0-7180-a390-2ae0e800d532 | AMAT | 2026-09-11 12:20 | call_vertical_spread | 2 | 1 | 15 | 211755.00 | long | ask | 462.8300 | 6.9500 | ["430","460"] | ["0.5507","0.5487"] | ["445.01"] | ["XMIO"] | 430.0000 | 460.0000 | 126 | 126 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:20:54Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b82-dd5e-7273-ac8a-d12a34a50b5c | AMAT | 2026-09-10 09:30 | call_vertical_spread | 2 | 1 | 10 | 106400.00 | long | ask | 455.4000 | 12.0000 | ["460","470"] | ["0.5853","0.5843"] | ["464.32"] | ["XISX"] | 460.0000 | 470.0000 | 99 | 99 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:30:03Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0872a-44f0-7222-9479-cbac34b81976 | AMAT | 2026-09-09 13:14 | call_vertical_spread | 2 | 1 | 10 | 106040.00 | long | ask | 468.2000 | 12.4000 | ["410","420"] | ["1.4958","1.3090"] | ["419.90"] | ["XISX"] | 410.0000 | 420.0000 | 2 | 2 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:15:06Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08203-4cb0-71f1-a98b-e12aa600235c | AMAT | 2026-09-08 13:14 | call_vertical_spread | 2 | 1 | 18 | 137856.00 | long | ask | 471.0050 | 4.9500 | ["460","470"] | ["0.5686","0.5689"] | ["464.97"] | ["XCBO"] | 460.0000 | 470.0000 | 38 | 38 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:14:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08203-4cb0-71f1-a98b-e1060a026240 | AMAT | 2026-09-08 13:14 | call_vertical_spread | 2 | 2 | 20 | 153186.00 | long | ask | 471.0050 | 2.5500 | ["460","470"] | ["0.5690","0.5687"] | ["465"] | ["BATO","XISX"] | 460.0000 | 470.0000 | 38 | 38 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:14:22Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0817b-4478-78c2-916e-542093d2811c | AMAT | 2026-09-08 10:45 | call_vertical_spread | 2 | 3 | 20 | 115720.00 | long | ask | 465.7900 | 9.0000 | ["450","455"] | ["0.5350","0.5352"] | ["452.90"] | ["XISX"] | 450.0000 | 455.0000 | 17 | 17 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:45:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |