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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0eb-4f83-7350-9746-6ce39ed20bdb | AMAT | 2026-09-17 15:50 | put_vertical_spread | 2 | 3 | 3 | 166382.00 | long | ask | 417.5100 | 17.9500 | ["690","700"] | ["0.9740","0.9968"] | ["690.02"] | ["ARCO","EMLD","SPHR"] | 690.0000 | 700.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:50:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a69d-6dce-7b42-a9bc-c44a48e43440 | AMAT | 2026-09-15 15:48 | put_vertical_spread | 2 | 1 | 6 | 370740.00 | long | ask | 420.8400 | 10.2000 | ["710","750"] | ["0.9899","1.0831"] | [] | ["XPHO"] | 710.0000 | 750.0000 | 31 | 31 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:49:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5de-2126-78f1-8515-21dca0d5256d | AMAT | 2026-09-15 12:19 | put_vertical_spread | 2 | 3 | 40 | 140936.00 | long | ask | 417.7000 | 1.5200 | ["415","420"] | ["0.5030","0.5035"] | ["417.42"] | ["ARCO","C2OX"] | 415.0000 | 420.0000 | 17 | 17 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:20:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09200-f540-7db0-980a-92f42ec6c54e | AMAT | 2026-09-11 15:45 | put_vertical_spread | 2 | 6 | 12 | 447946.00 | long | ask | 457.4100 | 11.7792 | ["640","650"] | ["1.4385","1.4928"] | [] | ["ARCO","EMLD","MCRY","SPHR","XBOX","XISX"] | 640.0000 | 650.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:45:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09200-f540-7db0-980a-92e0258c12a4 | AMAT | 2026-09-11 15:45 | put_vertical_spread | 2 | 2 | 3 | 111440.00 | long | ask | 457.4100 | 12.5000 | ["640","650"] | ["1.5324","1.5865"] | [] | ["ARCO","XBOX"] | 640.0000 | 650.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:45:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091d9-d5a0-7a10-a3f9-dec572e49c67 | AMAT | 2026-09-11 15:02 | put_vertical_spread | 2 | 5 | 24 | 236702.00 | long | ask | 458.0400 | 10.3875 | ["500","505"] | ["0.4545","0.4544"] | ["500.95"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 500.0000 | 505.0000 | 21 | 21 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:03:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09124-3970-78e0-b227-4ad179680666 | AMAT | 2026-09-11 11:44 | put_vertical_spread | 2 | 1 | 9 | 188433.00 | long | ask | 462.8650 | 8.0500 | ["480","570"] | ["0.5612","0.5690"] | ["508.65"] | ["ARCO"] | 480.0000 | 570.0000 | 161 | 161 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:44:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a06d4e-a455-7bd2-a201-a873f6dea50d | AMAT | 2026-09-04 12:44 | put_vertical_spread | 2 | 1 | 25 | 183825.00 | long | ask | 454.2650 | 3.2500 | ["460","470"] | ["0.5185","0.5205"] | ["464.13"] | ["AMXO"] | 460.0000 | 470.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:44:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4c-567d-7730-b6dd-1ab0299fbaca | AMAT | 2026-09-04 12:41 | put_vertical_spread | 2 | 1 | 25 | 181625.00 | long | ask | 454.3750 | 2.5000 | ["460","470"] | ["0.5125","0.5139"] | ["464.17"] | ["XMIO"] | 460.0000 | 470.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:42:34Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |